mysql_real_escape_string - access denied, depending on user who executes script?

Question

Hello All..

My setup: Ubuntu LAMP, application built w/ zend framework

My Problem: I have a few php scripts that I trigger via cron - daily email reports, rrd data capture etc.. I launch them via a cronjob like 'php -f scriptname.php'.
When I test the scripts from the commandline, logged in as myself, everything works fine. However, when the same script executes as root (via cron OR sudo) it fails with the following errors.

Warning: Access denied for user 'root'@'localhost'
Warning: mysql_real_escape_string(): A link to the server could not be established ...

I've done some research and I'm fairly sure that Im establishing a connection to mysql ahead of time, although the process is a bit obfuscated because Im working with the zend framework- Bootstrap class calls zend_db which calls registry class for the db credentials. and so on.

I've discovered one workaround: 'sudo -u myusername php -f scriptname.php' but I'd really like to know what Im doing wrong here..

TIA!

Answer 1

Warning: Access denied for user 'root'@'localhost'

This is the message you get when you login to mysql server with the wrong username and password, or you log in from a location you are not allowed. Check that root can log in from the host 'localhost' and that it has sufficient permissions for your database and the mysql database.

'sudo -u myusername php -f scriptname.php'

Maybe Zend is taking your sysem level user id and expecting to log into mysql with that? can you check or override the credentials that zend is using to connect to mysql?

Answer 2

Thanks for your time guys. Through trial and error I have determined that the error is related to my Zend Framework implementation. My bootstrap, db initalization, registry.. who knows.

While I love working with the ZF, simple issues like this turn into huge time vampires. All Im looking for is a mysql_connect() somewhere! I'll update when I find something.

Much Thanks..