Pggraph

1. login to cmdalert and su - extnagios

2. cd /home/web/manage/svn/repo

3. mkdir -p /home/web/manage/CUSTOMERNAME/dbname (/dbname is optional if the customer has only 1 database)

4. svn export www /home/web/manage/CUSTOMERNAME/dbname (again dbname may be optional

5. cd /home/web/manage/CUSTOMERNAME/dbname; edit stats-allcron and change "template" to the newdirname

6. edit pggraphscripts/userindexscript/cron.sh and change "template" to the newdirname

7. edit pggraphscripts/cron.sh and change "template" to the newdirname

8 . edit pggraphscripts/userindexscript/variables.sh and fill it correctly

9. cp pggraphscripts/userindexscript/variables.sh pggraphscripts/

10. Edit pggraphscripts/pggraph.sql and change template. Please use the schema name here to match the variables.sh that we changed in step

11. Enable passwordless ssh auth between extnagios user and remote user. Use http://www.linuxproblem.org/art_9.html for help.

13. cd pggraphscripts/ and run pggraph.sh . Run this file "ONCE". Run chmod 000 after you run this; otherwise you WILL lose previous data
if this file is run again.

This file will gather the information from remote database, create rrds, create .html files, create graphs, create db schema and   
    initialize it.

14. createupdatescript.sh

This script creates a script named update.sh, which is run every 5 mins by a cron job.

15. cd pggraphscripts/allstats; sh stats-createrrd.sh

16. edit index.php at the top location, under www/

17. cd pggraphscripts/userindexscript/; sh userindex.sh

18. sh createmainindex-ui.sh ; sh createmainindex-uixacts.sh

19. Edit cron. Please check that the files have x permissions.