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/www (again dbname may be optional

5.  cd /home/web/manage/CUSTOMERNAME/dbname; edit stats-allcron.sh 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/variables.sh and fill it correctly

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

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.