Hi,
I have had this particular FreePBX VM running since Nov. 2012. Since Sunday Jan 12, 2014, the system is sending 3 emails from running cron failures. The content of the 3 emails are the same. The difference is the user being root and asterisk.
Today I have tried upgrading from 4.211.64-7 to 4.211.64-10
using the upgrade FreePBX upgrade scripts. However, the server (and this is happening to about 10 different FreePBX VMs) is still sending these emails.
The content of the emails are:
Subject: Cron root@sip21-tor /var/lib/asterisk/bin/freepbx-cron-scheduler.php
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
Message-Id: [email protected]
Date: Mon, 13 Jan 2014 09:12:01 -0500 (EST)
[FATAL] DB Error: connect failed
Trace Back:
/var/www/html/admin/libraries/db_connect.php:63 die_freepbx()
[0]: DB Error: connect failed
/var/www/html/admin/bootstrap.php:98 require_once()
[0]: /var/www/html/admin/libraries/db_connect.php
/etc/freepbx.conf:9 require_once()
[0]: /var/www/html/admin/bootstrap.php
/var/lib/asterisk/bin/freepbx-cron-scheduler.php:5 include_once()
[0]: /etc/freepbx.conf
Subject: Cron asterisk@sip21-tor /var/lib/asterisk/bin/freepbx-cron-scheduler.php
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/var/lib/asterisk>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=asterisk>
X-Cron-Env: <USER=asterisk>
Message-Id: [email protected]
Date: Mon, 13 Jan 2014 09:21:01 -0500 (EST)
[FATAL] DB Error: connect failed
Trace Back:
/var/www/html/admin/libraries/db_connect.php:63 die_freepbx()
[0]: DB Error: connect failed
/var/www/html/admin/bootstrap.php:98 require_once()
[0]: /var/www/html/admin/libraries/db_connect.php
/etc/freepbx.conf:9 require_once()
[0]: /var/www/html/admin/bootstrap.php
/var/lib/asterisk/bin/freepbx-cron-scheduler.php:5 include_once()
[0]: /etc/freepbx.conf
I am able to connect to the MySQL db as root (without passwd) and as freepbxuser with passwd using the password from /etc/freepbx.conf. Able to select databases and select * from tables within those databases as either user.
If you happen to know the fix to this, I am much obliged.
Thank you in advance for your time and help.