NAS 110/220/440 part 3: Install a webserver (lighttpd, mysql or sqlite, php5)

php

Well, this is easy...

• Install webserver, sqlite, php5
  aptitude install lighttpd php5-cgi php5-cli php5-sqlite
• Or if you want mysql:
  aptitude install lighttpd  mysql-server mysql-client php5-cgi
  
  There is a chance you might need php5.3 so look here
  
  Ftp server
• To edit the vsftpd server.
  nano /etc/vsftpd.conf (info on default directory here)

• 
  
   Lighttpd
• Lighttpd's default document root is /var/www on Debian, and the configuration file is /etc/lighttpd/lighttpd.conf. (From there you can change your Document root to be somewhere else and not /var/www).
  Additional configurations are stored in files in the /etc/lighttpd/conf-available directory - these configurations can be enabled with the lighttpd-enable-mod command which creates a symlink from the /etc/lighttpd/conf-enabled directory to the appropriate configuration file in /etc/lighttpd/conf-available. You can disable configurations with the lighttpd-disable-mod command.
  
  
  Php in lighttpd
• nano /etc/php5/cgi/php.ini and edit
  cgi.fix_pathinfo=1
• To enable the fastcgi configuration (which is stored in /etc/lighttpd/conf-available/10-fastcgi.conf), run the following command:
  lighttpd-enable-mod fastcgi
  lighttpd-enable-mod fastcgi-phpThis creates a symlink /etc/lighttpd/conf-enabled/10-fastcgi.conf which points to /etc/lighttpd/conf-available/10-fastcgi.conf:
  ls -l /etc/lighttpd/conf-enabled
• Then we reload Lighttpd:
  /etc/init.d/lighttpd force-reload
• nano /var/www/info.php
  and edit the file to include only this line
  <?php  phpinfo();  ?>
• Now go to your browser and enter http://<NAS'I.P.>/info.php
  In case you get 403 forbidden then issue chmod 644 /var/www/info.php
  
  Don't forget to change rights.
  groupadd lighttpd
  useradd -g lighttpd -d /var/www/html -s /sbin/nologin lighttpd
  mkdir /var/log/lighttpd
  chown lighttpd:lighttpd /var/log/lighttpd
  chown -R lighttpd:lighttpd /var/www
  
• To create a php startup page that connects to the php5-sqlite just add this code to the start
• <?php
  if ($db = sqlite_open('my_sqlite_db', 0666, $sqlite_error)) { }
  else {     die ($sqlite_error);  }
  ?>
• The first parameter of sqlite_open() is the name of the database you want to open. You can think of this as the database name in MySQL, except that if the database does not exist, it will be created for you. The database will be created in the same directory as the PHP file that calls the function. If this file is in a path that is accessible to anyone, they will be able to access your database and to view the contents of it. Obviously, this is a major security risk. To remedy this, you need to enter a relative path out of the web root, such as:
  sqlite_open(' ../../../database_name ', 0666, $sqlite_error)
• So to retrieve info from a query all you need to do is
<?php
if ($db = sqlite_open('../../../my_sqlite_db', 0666, $sqlite_error))
{
    $result = sqlite_query($db, 'SELECT name FROM test');
     while ($row = sqlite_fetch_array($result))
    {        echo 'Name: '.$row['name'].'<br />';     }
}
else { die ($sqlite_error); }
?>

Sources: here and here, as for phph and sqlite connection here