Talk:Server

From ArchWiki
Revision as of 12:35, 17 December 2012 by Fengchao (Talk | contribs) (LAMP: LAMP has these info.)

Jump to: navigation, search

Original Document

Template:Box Note

LAMP

Configuration

PHP

PHP is practically available out of the box now.

  • Add these line in /etc/httpd/conf/httpd.conf
LoadModule php5_module modules/libphp5.so
Include conf/extra/php5_module.conf

NOTE: The "Include" can not be directly after the "LoadModule" line in the configuration file, it need to be down with the other "Includes".

Apache2:

LoadModule php5_module  /usr/lib/httpd/modules/libphp5.so
AddHandler php5-script php

http://dan.drydog.com/apache2php.html

  • Remember to add a file handler for .phtml if you need it in /etc/httpd/conf/extra/php5_module.conf:
DirectoryIndex index.php index.phtml index.html
  • If you want the libGD module, uncomment in /etc/php/php.ini:
;extension=gd.so

to

extension=gd.so

Pay attention to which extension you uncomment, as this extension is sometimes mentioned in an explanatory comment before the actual line you want to uncomment.

  • If your DocumentRoot is outside of /home/, add it to open_basedir in /etc/php/php.ini as such:
open_basedir = /home/:/tmp/:/usr/share/pear/:/path/to/documentroot
suggestion - Add your document root as follows:
open_basedir = /home/:/tmp/:/usr/share/pear/:/srv/http
  • Restart the Apache service to make changes take effect (as root):
# /etc/rc.d/httpd restart
  • Test PHP with a simple, but very informative script:
<html>
<head>
<title>PHP Test Page</title>
</head>
<body>
This is Arch Linux, running PHP.
<?php
  phpinfo();
?>
</body>
</html>

Save this file as test.php and copy to /srv/http/ or to ~/public_html if you permitted such a configuration.

If you continue to have problems, edit your /etc/httpd/conf/httpd.conf file with the following information

  • Edit your httpd.conf file
# nano /etc/httpd/conf/httpd.conf
  • Under <IfModule mime_module>
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
  • Restart Apache
# /etc/rc.d/httpd restart

Be sure to test the page again to verify it's working properly (as stated above).

MySQL

  • Configure MySQL as described at the MySQL wiki.
  • Edit /etc/php/php.ini (this is in /usr/etc on older systems) to uncomment the following line (By removing ;):
;extension=mysql.so
  • You can add minor privileged users for your web scripts by editing the tables found in the mysql database. You have to restart MySQL for changes to take effect. Don't forget to check the mysql/users table. If there's a second entry for root and your hostname is left with no password set, everybody from your host probably could gain full access. Perhaps see next section for these jobs.
  • Run in terminal (as root):
# /etc/rc.d/mysqld start
  • MySQL should now be running. Test by visiting http://localhost/phpMyAdmin in a web browser - for testing by phpMyAdmin, you should have installed phpMyAdmin (pacman -S phpmyadmin). It should display phpMyAdmin main page.
  • Edit /etc/rc.conf (to start MySQL at boot):
DAEMONS=(... mysqld ...)

Or add this line to rc.local:

/etc/rc.d/mysqld start
  • You can get the "error no. 2013: Lost Connection to mysql server during query" message instantly whenever you try to connect to the MySQL daemon by TCP/IP. This is the TCP wrappers system (tcpd), which uses the hosts_access(5) system to allow or disallow connections.
  • If you're running into this problem, be sure to add this to your /etc/hosts.allow file:
 # mysqld : ALL : ALLOW
 # mysqld-max : ALL : ALLOW
 # and similar for the other MySQL daemons.
  • Notes: The examples above are the simplest case, telling tcpd to allow connections from anywhere. You may wish to use a more-appropriate choice of permissible sources instead of ALL. Just make sure that localhost and the IP address (numeric or DNS) of the interface by which you connect are specified.
  • You might also need to edit /etc/my.cnf and comment out the skip-networking line as such:
skip-networking

to

#skip-networking