On Debian GNU/Linux you need to install the following packages:
On Debian GNU/Linux use this command to install all at once:
apt-get install apache php4 php4-mysql phpmyadmin
On Debian Woody there are a few workarounds to get PHP working. Open /etc/apache/httpd.conf with your favorite editor. Search for the "LoadModule" line containing the php4-module. If necessary, comment the line in (delete the #). After that search for "DirectoryIndex" and add "index.php" at the end of the line. Also search for "AddType" and comment in (delete the #) the following two lines:
AddType application/x-httpd-php .php AddType application/x-httpd-php-source .phps
Also setup "ServerAdmin" and "ServerName" with the correct values concerning your server. Comment out or delete the following section:
# # UserDir: The name of the directory which is appended onto a user's home # directory if a ~user request is received. # <IfModule mod_userdir.c> UserDir public_html </IfModule> # # Control access to UserDir directories. The following is an example # for a site where these directories are restricted to read-only. # <Directory /home/*/public_html> AllowOverride FileInfo AuthConfig Limit Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec <Limit GET POST OPTIONS PROPFIND> Order allow,deny Allow from all </Limit> <Limit PUT DELETE PATCH PROPPATCH MKCOL COPY MOVE LOCK UNLOCK> Order deny,allow Deny from all </Limit> </Directory>
as this is not needed and not possible an this server.
- Apache Virtual Host from SQL
To use MySQL as backend for apache install libapache-mod-sqlinclude from http://sourceforge.net/projects/mod-sqlinclude/ After install edit /etc/apache/httpd.conf. Remove any
entries from this file and add at module section
LoadModule sqlinclude_module /usr/lib/apache/1.3/mod_sqlinclude.so
and at the end
SQL_ServerName "localhost" SQL_ServerPort 3306 SQL_SQLDB [database name] SQL_SQLUser [database user] SQL_SQLPassword [database password] SQL_Include "SELECT concat(data,data2) from domains where data <> '' order by domain" SQL_AbortOnError On SQL_UseNameColumn Off
The most secure thing is to add a new user "www-data" to the mysql database which only has select rights on the domains table. Do this by typing the following command into mysql command line tool:
grant select on [database name].domains to www-data@localhost identified by "www-data"
and set above database user and password to this values. Configuration of apache is done.