Blob Blame History Raw

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