1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
Quick install:
-------------
NOTE: if upgrading, read the UPGRADE file.
NOTE2: if you get a fatal error about an undefined database function, read
the FAQ section in the README
I assume a working installation of MySQL 3.23.15 or higher and php 4.1 or
higher should work. To get multilingual support (languages other than
English), you will need to follow the steps later in this document.
In your web tree (normally /home/httpd/html or /var/www/html),
1) create a directory called ipplan
2) untar tar-ball into this directory
3) change the directory ownership and permissions of the ipplan directory
chown -R root.nobody ipplan
chmod -R 750 ipplan
this is operating system dependent - the above line is for a Redhat 6.2
based system. Have a look at the rest of your web tree for the correct
settings for your system.
For Redhat 7.x systems use:
chown -R root.apache ipplan
chmod -R 750 ipplan
It is important to set the correct permissions to prevent people from
seeing your passwords stored in config.php
4) create the database by issuing the following at the command prompt:
mysqladmin -p create ipplan
ONLY DO THIS STEP ONCE FOR A NEW INSTALLATION
NOTE: You may get errors about password compatibility with later
versions of MySQL when running the IPplan install script. If you
do, you may need to issue the following on a MySQL prompt:
set password for 'ipplan'@'localhost' = old_password('password');
Replace password with the password you want to use for your database
5) 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
ONLY DO THIS STEP ONCE FOR A NEW INSTALLATION
6) modify the user and password info in the config.php script.
additional settings can be changed in the config.php script at this
stage too. See the README for more information.
if you are using InnoDB transaction safe tables, make sure to enable
transaction support in config.php
7) open a web browser and point it to the installation script in the
admin directory (http://mywebserver.com/ipplan/admin/install.php)
you will be prompted to create the database schema. The user created
above does not have enough rights to create tables so you will need
to either copy the statements into the database, or temporarily change
the database password in the config.php file to a database user that has
enough rights to do this.
you can manually load the statements by copying the display output
from the install.php script into a file (example ipplandbf.sql)
and then executing the file by logining in as the newly created user using
mysql and issue:
mysql -p ipplan < ipplandbf.sql
8) 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
9) send me an e-mail about how you use IPplan!
Backing Up your MySQL Database:
---------------------------------
Being the responsible system administrator that you are, from time to time you
are going to want to backup your ipplan database. Perhaps you are upgrading or perhaps
you are moving IPPlan to a new server. The follow procedure is appropriate for a
MySQL environment:
To dump the database:
mysqldump -u ipplan -pipplan99 ipplan > ipplan.sql
(Be sure to alter with your username and password)
This will create a file with all of the SQL statements necessary in order to rebuild
the MySQL database. Now, some day may come when you will be glad that you were such
a responsible system admin and you will want to restore this backup.
To restore the database:
1. If needed, remove the old ipplan database with "drop database ipplan"
*** STEP 1 WILL CAUSE TOTAL DATA LOSS FOR YOUR IPPLAN DATABASE.
2. Follow the installation directions for creating the ipplan database
up to step 6.
3. Copy the ipplan.sql file to your current directory.
4. Run "mysql -u ipplan -pipplan99 ipplan < ipplan.sql"
Enabling multilingual support:
-----------------------------
To get multilingual support working, php must be compiled with GNU gettext
support enabled. This is NOT enabled by default. gettext is normally
installed on all Linux distributions, but may not be available on other
UNIX variants. So if you are not using Linux, download and install gettext
from http://www.gnu.org/software/gettext before installing php. Once gettext
is installed, you will need to recompile php with gettext support enabled.
To do this, follow the instructions for installing php from http://www.php.net,
but make sure you add
--with-gettext
to the ./configure line. To check if gettext is enabled in php, execute this
simple php script:
<?php
phpinfo();
?>
If you change the language on the IPplan settings page and no change occurs,
try turning on debugging in config.php. This will return an error if the
language change resulted in an error. If an error occurs, try checking the
output of the "locale -a" command on the IPplan webserer to see if the required
language is installed.
If you are running your webserver with chroot environment, just copy
your locale files to jail dir. eg.: cp -Rp /usr/share/locale /chrooted_dir
If gettext is installed and you are still having trouble, try changing the
$iso_codes values in /ipplan/config.php to match the values of the
locale -a output for your system. These values differ depending on the
distribution.
If your language is not currently available, feel free to follow the
instructions in the TRANSLATIONS file and do your own.
Hope it works!
ipplan@gmail.com
|
