---

FreeBSD установка Apache+MYSQL+PHP

In this post I’ll describe how to install the so called LAMP (Linux, Apache, MySQL, Perl/PHP) on a FreeBSD 10 server. Technically, it should be FAMP. We’ll use FreeBSD 10, Apache 2.4.9, PHP 5.4.34 and MySQL 5.6.17.

First, let’s install Apache.

Leave the defaults which will install SSL as well (mod_ssl). Once the installation finishes, edit /etc/rc.conf and add the following line which will ensure that apache will start on boot.

The main configuration file for apache is /usr/local/etc/apache24/httpd.conf. Edit this file and change these two values.

They should match whatever your server name is and whatever is your admin’s e-mail. Another important command is apachectl. Use this command to start, stop and restart the apache daemon. If you want to make a change in your configuration files and don’t want to kick off any current users, use:

In this case, apache will wait for the open connections to close before stopping the daemon. With these simple config changes, we can now start the Apache and test it.

Go to your www.servername.com domain and you should see the “It works!” page.

Most of the time, you will need to host multiple web sites and in order to do that we need to make some other changes.

Edit httpd.conf again, look for the following line and uncomment it.

This tells apache to read another configuration file that describes the virtual hosts. This config file is under /usr/local/etc/apache24/extra directory. Edit this file and change the values so it suit your needs. In my case, here is an example of a server that I have.

Test the server by accessing the virtual host name, in my case it was http://mail.mycloudserver.org.

Finally, let’s configure the SSL portion of it. We’ll use fake (self-issued) certificate, so you’ll get a warning. Again, edit httpd.conf and uncomment the following lines.

Then go to the extra directory and edit httpd-ssl.conf file. Uncomment the way the random numbers are generated. See the URL inside the config file for more info. For FreeBSD I used this line.

Similary to the httpd.conf file, configure the ServerName and ServerAdmin. At the end, create the self-signed certificate.

Restart the apache daemon and test with https://www.servername.com.

MySQL

MySQL installation is very straightforward with minimal configuration files.

If you want to install MariaDB instead, do:

Once completed, edit /etc/rc.conf and add this line so MySQL starts on each boot. The entry is the same for MySQL and MariaDB.

Start the server with:

Do the initial config. Hit ENTER for the first question (current root password), then just follow the prompts. Pretty much, accept all the defaults. Again, it’s the same for MySQL and MariaDB.

PHP

Install PHP by doing:

This will install the PHP language, some PHP extensions (accept the defaults) and the Apache PHP module. Once completed, create the php.ini file.

Now, edit the php.ini file and change the date.timezone line. Pick a value from here. In my case, I used America/New_York. Then, edit the httpd.conf file and look for these configuration lines.

Insert the following after (you can insert them at the end if you want).

Again, look for these configuration lines.

and change it so it looks like this.

Finally, create this file in the root folder of the Apache or anywhere in the root folder of any virtual host.

Restart the apache daemon and go to http://somewhere.com. You don’t have to put index.php. Apache should pick that up automatically with the DirectoryIndex change that we made above. If everything is OK, you should see something like this.

Права доступа и их изменения:
chmod -R 777 /var/www
chown -R root:root /var/www

sudo apt-get --purge remove phpmyadmin
sudo apt-get --purge remove mysql-server-5.5
sudo apt-get --purge remove mysql-common
sudo reboot
sudo apt-get --purge remove phpmyadmin
sudo apt-get --purge remove mysql-server-5.5
sudo apt-get --purge remove mysql-common
снова повторил удаления, так как phpmyadmin вроде не удалился, далее
sudo apt-get autoremove
sudo reboot
sudo apt-get install mysql-common
sudo apt-get install mysql-server-5.5
sudo service mysql start
sudo apt-get install phpmyadmin

mysql -uroot -p dbname < /var/www/user/dbbackup.sql

---