Software Download
First you have to download all necessary software packages. As I am running voyage linux (a debian derivate) it is really simple by using apt-get.
|
1 2 3 4 5 |
apt-get update apt-get install lighttpd apt-get install php5-cgi apt-get install sqlite apt-get install php5-sqlite |
Configuration
First of all you have to add the fast_cgi-module to the lighty configuration file (/etc/lighttpd/lighttpd.conf).
Add „mod_fastcgi“ to the „server.modules =()“-part.
After that I aded the following code right to the end of the same file to get php5 recognised by lighttpd.
I also disabled „mod_accesslog“ by commenting this module out, as I do not need any logging. Also the logs-files must be commented out, as shown below.
|
1 2 3 4 |
fastcgi.server = ( ".php" => (( "bin-path" => "/usr/bin/php5-cgi", "socket" => "/tmp/php.socket" ))) |
|
1 2 3 4 5 |
## where to send error-messages to #server.errorlog = "/var/log/lighttpd/error.log" #### accesslog module #accesslog.filename = "/var/log/lighttpd/access.log" |
The last step is cleaning up the environment for lighty. Logs can be erased.
|
1 2 |
cp -a /rw/var/log/lighttpd /ro/var/log/lighttpd rm /ro/var/log/lighttpd/* |
Test your installation
Now we can recheck our installation by adding a new PHP-file to /var/www.
Just copy and paste the following code to a file called db.php.
Save, and point your browser to http://{your_Alix_IP}/db.php.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
<?php // Create an SQLite DB in the file test.sqlite $db = new SQLiteDatabase("test.sqlite"); $db->query("BEGIN; CREATE TABLE dbtest(id INTEGER PRIMARY KEY, article CHAR(50),price FLOAT(10)); INSERT INTO dbtest (article,price) VALUES('Book1','12.99'); INSERT INTO dbtest (article,price) VALUES('Book2','15.23'); COMMIT;"); $result = $db->query("SELECT * FROM dbtest"); // Read and show the DB we created echo "<PRE>"; printf("+------------+------------------------------------------+\n"); printf("| Price | Article |\n"); printf("+------------+------------------------------------------+\n"); while ($result->valid()) { $row = $result->current(); printf("| %10s | %-40s |\n",$row[/fusion_builder_column][fusion_builder_column type="1_1" background_position="left top" background_color="" border_size="" border_color="" border_style="solid" spacing="yes" background_image="" background_repeat="no-repeat" padding="" margin_top="0px" margin_bottom="0px" class="" id="" animation_type="" animation_speed="0.3" animation_direction="left" hide_on_mobile="no" center_content="no" min_height="none"]['price'],$row['article']); $result->next(); } printf("+------------+------------------------------------------+\n"); echo "</PRE>"; unset($db); phpinfo(); ?> |
Alix Board running lighttpd, PHP5 and SQLite
Pretty! This was a really wonderful article. Thanks for providing this info.
Excellent way of explaining, and pleasant article to obtain facts about my presentation focus, which i am going to deliver in college next week.
Thanks a lot!
Steve.