THIS ASSUMES PACTIME HAS ALREADY BEEN SETUP


apt-get install libapache2-mod-php php php-mysql
/etc/init.d/apache2 restart


vi includes/config.php
match settings from ../pactime/my_config.py and ../pactime/server_config.py
i.e.:
mysql_pt_user_prepend="gvu_"
mysql_pt_pw_prepend="gvpw_"
mysql_pt_db_prepend="gvdb_"
mysql_pt_host="localhost"

vi python/my_config.py

vi python/server_config.py


mysql -u gxu_XXXX -pXXXXXX gxdb_XXXX

mysql -u gxu_XXXX -pXXXXXX gxdb_XXXX < ./howto.init.status.mysql
mysql -u gxu_XXXX -pXXXXXX gxdb_XXXX < ./howto.init.web.mysql


##NOTE##now in pactime setup
###. populate password file
##mkdir -p /etc/groovix
##htpasswd -c /etc/groovix/cmon_staff.pw staff
##htpasswd  /etc/groovix/cmon_staff.pw admin
##
###. password protection for some functionality
###add a section like this to /etc/apache2/sites-available/default
##
##     <Directory /var/www/groovix/cmon/admin>
##          AuthName "Cmon Staff"
##            AuthType Basic
##              AuthUserFile /etc/groovix/cmon_staff.pw
##                require valid-user
##        </Directory>


# to change name of default location:, this one will always be default since id=1 (could change later)
mysql -h localhost -u cmonuser --password=demopw  cmon
mysql> update pages set page_title = 'Main Library 1st Floor' where page='default_page';

#add more locations: #NOTE: keep location as default_location unless you are adding additional sub-servers in config.php
mysql -h localhost -u cmonuser --password=demopw  cmon
mysql> INSERT INTO `pages` VALUES (null,'first_floor','1st Floor','default_location','ip_range',0,'default_branch');
mysql> INSERT INTO `pages` VALUES (null,'third_floor','3rd Floor','default_location','ip_range',0,'default_branch');

#add workstation by command line:
(can move using gui later, just get the pageid,workstation, and name fields set right)
mysql> INSERT INTO `maps` VALUES (null,1,'mweb01','w01','left:100px; top:200px;','',1,'','');

example batch add:
for T in $(seq -w 2 32) ; do echo mysql -u gxu_XYZ -pXYZ gxdb_XYZ -e "INSERT INTO maps VALUES (null,1,\"REFNET$T\",\"RN$T\",\"left:100px; top:${T}5px;\",'',1,'','');" ; done

#copying workstations to another page (in this example copy all stations named A* from page 1 to page 3):
mysql> INSERT INTO maps (id,pageid,workstation,pcname,style,class,visible,model,monitor) select NULL,3,workstation,pcname,style,class,visible,model,monitor from maps where pageid=1
 AND class='' AND visible=1 AND workstation LIKE "A%" ;

