IPPLAN - The Easy Tutorial

IPplan Tutorials
Last Change : May 18 2008

Tool
Install
Ergonomy
Forum

Details What is IPplan?
Screenshots
Prerequisites
Tutorial IPplan
Configuration

⚠️⚠️⚠️
Please check our website about
attractions in Western Switzerland !! (Please use english translation).

⚠️⚠️⚠️
Merci de consulter notre site sur les
activités à faire en Suisse romande !!

1. PACKAGE INSTALLATION 2. MANUAL INSTALLATION

1. PACKAGE INSTALLATION

Coming soon

2. MANUAL INSTALLATION

Download IPplan.
Uncompress the tar.gz file

#tar -xvf ipplan-4.80b.tar.gz
Move the ipplan directory into your apache2 directory, for example:

#mv /home/user/Desktop/ipplan /var/www/
Then create the ipplan database

#mysqladmin -u root -p create ipplan
As always, it's better to avoid accessing the database through the root user.
So, log into the database and create a user called ipplan:

#mysql -u root -p ipplan
We give all the rights to the ipplan user on the ipplan database:

mysql> grant all on ipplan.* to ipplan@localhost identified by 'ipplanpassword';
Now, reload the MySQL rights:

mysql>flush privileges;
mysql>exit
We need to change the ipplan config file and insert the ipplan MySQL connection settings:

define("DBF_TYPE", 'maxsql');
define("DBF_HOST", 'localhost');
define("DBF_USER", 'ipplan');
define("DBF_NAME", 'ipplan');
define("DBF_PASSWORD", 'ipplanpassword');
Then we need to set the correct permissions on the /var/www/ipplan directory.
For example:

#chown -R user:www-data /var/www/ipplan
#chmod -R 750 /var/www/ipplan
The files inside the /var/www/ipplan directory are now owned by "user" with full rights. The www-data group holds execute permissions on these same files.
It contains the www-data user which is in fact the apache web server user.
You can of course substitute the user called "user" in our example with another one of your choice. However, you must keep the www-data group since the apache web server will need execute permission on the files inside the /var/www/ipplan/ directory.

Now we can install the MySQL ipplan tables through a script.
Enter the following path in your web browser:

http://localhost/ipplan/admin/install.php

Click on "Go".

That's all there is to it! IPplan is now installed. Go on with the configuration tutorial.

Below is a typical message when the MySQL connection settings are not or wrongly configured in the /var/www/ipplan/config.php file.

Access denied for user 'ipplan'@'localhost' (using password: YES)