moved path to ChartDirector from /home/raj/perl5/lib/perl5/ChartDirector to /home/raj/perl-lib/ChartDirector/lib where ~/perl-lib/ChartDirector is symlink to CD v6.0; enabled trend_analysis graphs
LIMS::Local::QueryLog - fix permissions issue with previous commit (9171b6a & bf60ec8); format queries for console & log file using SQL::Abstract::Tree
Contents:
chown raj:www-data sessions
debug.txt - contains debugging information; opened in overwrite mode ('>') per request
debug.log - contains debugging information; opened in append mode ('>>'); rotated using log_rotate.pl (count => 3)
deployment.sql - all query statements from application in production mode; rotated using log_rotate.pl (count => 3)
development.sql - all query statements from application in development mode; rotated using log_rotate.pl (count => 3)
today.sql - contains UPDATE/INSERT/DELETE statements from application in production mode; archived in /old daily using log_rotate.pl
file ownership:
development.sql 640 raj:raj/staff
debug.txt 666 raj:raj/staff
debug.log 666 raj:raj/staff
# where cron user is NOT a member of apache-user group:
deployment.sql 666 www-data:www-data
today.sql 644 www-data:www-data
# where cron user IS a member of apache-user group:
deployment.sql 660 www-data:www-data
today.sql 640 www-data:www-data
To truncate file in use:
sudo cp new_msgs.log new_msgs.log.nn && sudo cat /dev/null > new_msgs.log
sudo chown raj:raj new_msgs.log.nn
