MySQL error/no workflow notifications

[rlbyrd]

I don't even know at this point if these are related. However, in researching why I no longer get any workflow emails when opportunities change state, etc., I discovered a raft of MySQL error messages in my ./sugarcrm.log file.

a) It would appear from the timing of these MySQL errors that they are generated by cron.php. What is attempting to use the root account?

b) I have a workflow rule to send me an email, via the sendmail method, when an Opportunity changes state. Worked fine in RC1, tail -f of the maillog doesn't generate *anything* when an Opportunity changes now.

These were the errors that caught my eye:

Mon Sep 11 09:42:02 2006,346 [27085] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:43:02 2006,128 [27090] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:44:01 2006,780 [27095] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:45:02 2006,426 [27101] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:46:02 2006,475 [27107] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:47:02 2006,267 [27112] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:48:01 2006,944 [27119] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:49:02 2006,954 [27128] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:50:02 2006,736 [27141] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:51:02 2006,675 [27152] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:52:02 2006,673 [27157] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:53:02 2006,345 [27162] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:54:02 2006,018 [27171] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)
Mon Sep 11 09:55:02 2006,217 [27181] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)

Changed log level to debug, and everything runs fine until this bit...

Mon Sep 11 10:05:02 2006,076 [27310] DEBUG SugarCRM - ----->SchedulersJob firing processQueue
Mon Sep 11 10:05:02 2006,142 [27310] INFO SugarCRM - Query:SELECT * FROM report_schedules WHERE next_run < '2006-09-11 10:05:02' AND deleted=0 AND active=1 AND schedule_type='proC
Mon Sep 11 10:05:02 2006,143 [27310] INFO SugarCRM - Query Execution Time:0.00034300000000001
Mon Sep 11 10:05:02 2006,144 [27310] INFO SugarCRM - -----> SchedulersJob setting Job flag: completed AND setting Scheduler status to: Active
Mon Sep 11 10:05:02 2006,144 [27310] DEBUG SugarCRM - Retrieve schedulers : SELECT schedulers.* FROM schedulers WHERE schedulers.id = '8110d68c-2c81-d0f1-67ec-44eb1e64ec5b'
Mon Sep 11 10:05:02 2006,145 [27310] DEBUG SugarCRM - Limit Query:SELECT schedulers.* FROM schedulers WHERE schedulers.id = '8110d68c-2c81-d0f1-67ec-44eb1e64ec5b' Start: 0 count1
Mon Sep 11 10:05:02 2006,145 [27310] INFO SugarCRM - Query:SELECT schedulers.* FROM schedulers WHERE schedulers.id = '8110d68c-2c81-d0f1-67ec-44eb1e64ec5b' LIMIT 0,1
Mon Sep 11 10:05:02 2006,146 [27310] INFO SugarCRM - Query Execution Time:0.000444
Mon Sep 11 10:05:02 2006,146 [27310] FATAL SugarCRM - MySQL error 1045: Access denied for user 'root'@'localhost' (using password: NO)


Any assistance is apprciated--on the MySQL error, the non-workflow notification, or both.

*sigh*

r

RHES4
Sugar 4.5.0 Pro
Apache 2.0.52
php 4.4.2
MySQL 4.1.20

[rlbyrd]

ARRGGH.

Having been laboring over this problem all day, log-trolling, parsing error messages, etc., and I finally gave in 10 minutes ago, blew the entire installation away and re-installed. Voila, workflow notification works now.

VERY upsetting. I have had 85% reliable, solid performance and predictability from Sugar thus far, but stuff like this drives me $%^#&*! batty.

Final analysis: Everything works now, no idea why it was broken, no idea why it's fixed. Grrr.

r