The FreeBSD Experience - Part 4 : phpMyAdmin & Joomla installation

I've decided to include phpMyAdmin in the installation so before we jump into the Joomla installation, we first add......(drums rolling).....phpMyadmin.



phpMyAdmin

# whereis phpmyadmin

phpmyadmin: /usr/ports/databases/phpmyadmin

# cd /usr/ports/databases/phpmyadmin

# make install clean

Select the MYSQLI Option and continue with the default selections.

Add the following line to /usr/local/etc/apache22/httpd.conf:

<IfModule alias_module>

   # Location of phpMyAdmin

   Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/" 

</IfModule>

#Directory rights

<Directory "/usr/local/www/phpMyAdmin/">

   Options none

   AllowOverride Limit

   Order Deny,Allow

   Deny from all

   #change this line to appropriate values:

   Allow from 127.0.0.1 .example.com

</Directory>

Joomla 1.7
Joomla can be found in the ports-repository:

# whereis joomla
joomla: /usr/ports/www/joomla
# cd /usr/ports/www/joomla
# make install clean

Go to the /usr/local/www directory and make a copy of the original joomla directory

cd /usr/local/www
cp -Rp joomla15 <your site>
chown www:www <your site>

For Apache HTTP server must know about this site, we will create a NameVirtualHost for it. First, edit /usr/local/etc/apache22/httpd.conf, and uncomment the line

Include etc/apache22/extra/httpd-vhosts.conf

Open the file /usr/local/etc/apache22/extra/httpd-vhosts.conf, comment out all the lines for VirtualHost examples. Add the following lines to the file:

#
# <your site>
#
<VirtualHost *:80>
    ServerAdmin webmaster@<your domain name>
    DocumentRoot "/usr/local/www/<your site>"
    ServerName <your domain name>
    ServerAlias www.<your domain name>
    ErrorLog "/var/log/<your site>-error_log"
    CustomLog "/var/log/<your site>-access_log" common
    <Directory "/usr/local/www/<your site>">
        Order Allow,Deny
        Allow From All
        AllowOverride All
        Options Indexes FollowSymLinks ExecCGI
    </Directory>
</VirtualHost>

Please replace <your site> and <your domain name> with your own values.

Check Apache HTTP server configureation:

# /usr/local/etc/rc.d/apache22 configtest

Fix any configuration problems, and then restart Apache.

# service apache22 restart

Before running Joomla! 1.7 installer, you need to create a MySQL database and a database user with proper permission to access that database. To create MySQL database, issue the command:

# mysqladmin -u root -p create <your db>

You will be asked to enter the password for MySQL root user.

Now let's use the MySQL client program to create a user and grant that user permissions.

# mysql -u root -p

Once you are at the client program's command prompt, enter this command:

mysql> CREATE USER '<db user>'@'localhost' IDENTIFIED BY '<db password>'; 

mysql> GRANT ALL PRIVILEGES ON <your db>.* TO '<db user>'@'localhost' WITH GRANT OPTION;

There <your db> is the newly created MySQL database, <db user> is the username used to access that database, and <db password> is the password for that user. Of course is this process also possible via phpMyAdmin.

Now open your browser and go to http://<yourserver> and you will be greeted by the Joomla installation script.

Cheers !

In the next installment I will include multiple Joomla sites and SSL/https configs.