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
Contents:
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 - contains SELECT query statements from application in production mode; opened in append mode; rotated using log_rotate.pl (count => 3)
development.sql - contains all query statements (SELECT/UPDATE, etc) from application in development mode; rotated using log_rotate.pl (count => 3)
{yyyy-mm-dd}.sql - contains UPDATE/INSERT/DELETE statements from application in production mode; archived in /old daily using log_rotate.pl
file ownership:
{yyyy-mm-dd}.sql 660 www-data:www-data/staff
development.sql 640 raj:raj/staff
debug.txt 666 raj:raj/staff
debug.log 666 raj:raj/staff
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