Ok, I've got everything installed, the server works, hlstats plugin loads. But when I navigate to my http page I get this:
Code:
ERROR
Database Error
Server Address: db.myserver.com
Server Username: hlx
Error Diagnostic:
Could not connect to database server. Check that the values of DB_ADDR, DB_USER and DB_PASS in config.php are set correctly.
Server Error: (2003) Can't connect to MySQL server on 'db.myserver.com' (13)
Last SQL Query:
I've a dedicated server that I have full access to (it's a Dell R710 in a rack) It's running virtualized servers. The one caveat to my setup is I have a database server, and am not hosting the db in the same vm as hlstats.
All of my vm's are running:
CentOS Linux release 7.2.1511 (Core)
PHP 5.4.16 (cli)
and the db is running:
MySQL server version 5.6.31
At first I could not run the cron jobs. I figured out that I had to install DBD which was difficult but it's working.
Now I can run the cron job scripts:
Code:
cd /home/fofserver/serverfiles/fof/addons/sourcemod/scripting/ && ./hlstats-awards.pl
-- Connecting to MySQL database 'hlstatsx' on 'db.myserver.com' as user 'hlx' ... connected OK
++ HLstatsX:CE Awards & Maintenance script version 1.6.19 starting...
++ Cleaning up database: deleting events older than 28 days... done
++ Cleaning up database: deleting player history older than 28 days... done
++ Cleaning up database: deleting stale trend samples... done
++ Cleaning up database: deleting server load history older than one year... done
++ Updating player activity... done
++ Processing awards... (generating awards for 2016-07-02 (previous: 2016-07-02))... done
++ Processing ribbons... done
++ HLstatsX:CE Awards & Maintenance script finished.
But, for some reason, the php is failing with some sort of error.
The login credentials are identical.
Any ideas?