Personal Apache MySQL PHP for S60 3rd Edition

[vinumsv]

PAMP, an S60 Powered Apache Web Server with PHP and MySQL



PAMP, an S60 Powered Apache Web Server with PHP and MySQL is now available for the S60 3rd edition phones.

The acronym AMP refers to a solution stack of software, usually free software / open-source software, used to run dynamic Web sites or servers.

The original expansion is as follows: Apache, the Web server; MySQL, the database management system (or database server); PHP and sometimes Perl or Python, the programming languages.

The combination of these technologies is used primarily to define a web server infrastructure, def... .. .

Read more:
An S60 Powered Apache Web Server - full story


Installation

Download from SourceForge either pamp_with_htdocs_on_c.zip or pamp_with_htdocs_on_e.zip, depending on whether you want to have the web-server's document root in phone memory or on the memory card. It's easy to later change the location of the document root.

The zip file contains:

* pips_s60_1_2_SS.sis
* openc_ssl.sis
* PythonForS60_1_4_1_3rdEd.sis
* PythonScriptShell_1_4_1_3rdEd.sis
* pamp_with_htdocs_on_...sisx

and you should install them all, unless you already have Open-C (the two first files) and Python for S60 (the two following files) installed.

Code: Select all

NOTE : The PAMP sis is a composite file containing many individual sis-files that all have been signed with a so called self-signed certificate. The implication is that you numerous times have to acknowledge that you really want to have the software installed.

Code: Select all

NOTE : The PAMP files are big and there are many of them. After the security warnings there will be a significant delay before the installation proceeds and the phone may appear frozen. Just wait; patience is a virtue.
[edit] Optional Files

PED

You will want to be able to make minor modifications to httpd.conf and php-ini directly on the phone and for that you need a decent editor. Ped is actually a Python programmer's editor, but is also the best S60 text editor I've encountered.

MySQL

In order to be able to directly interact with the MySQL server running on the phone you need to install MySQL on your laptop. Download the right version for your OS from MySQL.

Code: Select all

  NOTE : Depending on the PHP package you intend to install on top of PAMP you may or may not actually need to do this. It won't harm though and is quite convenient.

Running

After the installation you will find two new applications on your phone; Pamp and Connector. The former is, well, PAMP, and the latter is a component that can provide your phone with a global URL (more about that later).

Smoketest 1

1. Start Pamp
2. Invoke [Options]->[Start]->[Pamp]
3. Wait until both Apache and MySQL says Running
4. Start the browser on the phone.
5. Browse to http://127.0.0.1.

You should be greeted with a page that says It works!.

Next you can click on the link phpinfo.php to find out what PHP of PAMP has eaten. The other links refer to sites of different CMSs and are not served from your phone.

Smoketest 2

1. Ensure that Pamp is running.
2. Invoke [Options]->[Start WLAN] and select an approriate WLAN access point. Check here for more information about WLAN access points.
3. Connect your laptop to the same WLAN.
4. Type http://address in your browser, where address is the IP address shown on the Pamp screen. Note that if you have a firewall on your laptop you may have to explicitly enable that address.

You should be greeted with the same It works! as in the previous step.

Smoketest 3

1. Ensure that Pamp is running.
2. Invoke [Options]->[Start WLAN] and select an approriate WLAN access point.
3. Connect your laptop to the same WLAN.
4. Enter mysql -h address, where address is the IP address shown on the Pamp screen, in a command prompt on your PC. Note that if you have a firewall on your laptop you may have to explicitly enable that address.

You should be greeted with:

Code: Select all

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

You are talking with MySQL running on your phone.

More opensource.nokia.com



..:: VinuMsv? ::.. Reporting for Symbian Freak News?

[fosron]

Cooooooooooooooool downloaded it and trying to install , hope it works

[fosron]

As i thought , because of low ram , only http works properly all pamp runs , but i cant enter to 127.0.0.1

[Stewart]

looks awesome cant wait to get it on my phone

[Apocalypso]

Wow, what a nice find bro, thx 4 sharing

[MORF]

Wow!
Very nice!
But I don't have so many RAM

[marty3]

awsem, its finally here.. this is great news indeed

[Ravirdv]

its working gr8 on my e51!

EDIT: I'm trying to install Joomla On it any idea on how to create database?
phpmyadmin is not working

[marty3]

anyone tried on n95-1 yet no work for enough RAM, or does it work.. i not tried it..

[fosron]

tried it apache+mysql should leave some empty ram on n95,but not on 5700 so i now only use httpd ...
Some 5700 screenies: