Configuration - Mysql
1) create the database by issuing the following at the command prompt:
mysqladmin -p create ipplan
2) add a database user for ipplan using mysql -p
GRANT SELECT,INSERT,UPDATE,DELETE on ipplan.*
TO ipplan@localhost IDENTIFIED by 'password';
Change the above password to whatever you wish
3) modify the user and password info in the /etc/ipplan/config.php,
additional settings can be changed in the /etc/ipplan/config.php
at this stage too. See /usr/share/doc/ipplan-*/README for more
information.
Make sure you leave transaction support enabled in /etc/ipplan/config.php
4) Import the database schema into the database
mysql -p ipplan < /usr/share/doc/ipplan-*/sql/ipplan-mysql.sql
5) Point your web browser to the main IPplan web page (http://mywebserver.com/ipplan),
select the admin drop down menu and add customers, groups and users using the admin
user defined in the config.php file - you MUST create at least one regular user
one group and one customer
Configuration - Postgresql
1) Create the database, database user and tables by issuing the following at the
command prompt as the postgres user (su - postgres):
su - postgres
createuser -P ipplan
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) n
Shall the new role be allowed to create more new roles? (y/n) n
createdb -O ipplan ipplan
Make sure that the ipplan user is allowed to connect to the ipplan
database from another user by modifying the pg_hba.conf file and
adding the following then restart the postgresql service
host ipplan ipplan 127.0.0.1/32 md5
host ipplan ipplan ::1/128 md5
local ipplan ipplan md5
Import the database schema
psql -U ipplan < /usr/share/doc/ipplan-*/sql/ipplan-pgsql.sql
2) Modify the user and password info in the config.php script, additional
settings can be changed /etc/ipplan/config.php at this stage too.
See the /usr/share/doc/ipplan-*/README for more information.
3) now point your web browser to the main IPplan web page
(http://mywebserver.com/ipplan), select the admin drop down menu and add
customers, groups and users using the admin user defined in the config.php
file - you MUST create at least one regular user, one group and one customer
Configuration - Oracle
Oracle is not supported on fedora