Pggraph

1.  login to cmdalert and su - extnagios

2.  cd /home/web/manage

3.  cp -rp template newinstalldirectoryname

4.  cd newinstalldirectoryname/www

5.  edit stats-allcron and change "template" to the newdirname

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

7.  edit dbstatscript/dbstat-allcron.sh, mpstatscript/mpstat-allcron.sh 

8.  edit pggraphscripts/vmstatscript/vmstat-allcron.sh and change "template" to the newdirname

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

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

11.  cp pggraphscripts/userindexscript/variables.sh pggraphscripts/

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

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; sh create-statrrd.sh 

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

17. run pggraphscripts/userindexscript/userindex.sh

extnagios@www:/home/web/manage/mailwise-sqlgrey/www/pggraphscripts/userindexscript$ sh createmainindex-ui.sh > ../../userindex-uistats.php

extnagios@www:/home/web/manage/mailwise-sqlgrey/www/pggraphscripts/userindexscript$ sh createmainindex-uixacts.sh > ../../userindex-uixact.php