Forums / Install & configuration / Database error when running runcronjobs.php
Felix Laate
Wednesday 10 May 2006 5:41:13 am
Hi all!
I'm trying to set up notifications, but have ran into problems concerning runcronjobs.php. I run the script with:
php -C runcronjobs.php -d
and I get the following:
#################################### DEBUG ################################# Error: (eZMySQLDB) Connection error: Couldn't connect to database. Please try again later or inform the system administrator. Access denied for user: 'root@localhost' (Using password: NO)
Any ideas might make me reeeeeally happy :-)
Felix
Publlic Relations Manager Greater Stavanger www.greaterstavanger.com
Thursday 11 May 2006 4:23:34 am
Still having the problems.
Thaught I should say a little bit more:
- notification works when kicked off from the admin interface but NOT with cli and thus not from cron - mysql.so is loaded in php.ini- system runs on debian 3.1 with php 4.4.x
I'm getting pretty frustrated, so if anybody knows anything that could help me, I would really appreciate it.
Łukasz Serwatka
Thursday 11 May 2006 4:38:13 am
Hi Felix,
php -m
Make sure that php command line interface was compiled with mysql support. Do you run script from eZ publish root directory?
Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Thursday 11 May 2006 4:46:30 am
Hi Luke!
Thank your for your as-allways-swift response. Here's the output:
tiberius:~# php -m [PHP Modules] bcmath bz2 calendar ctype curl dba dbx domxml exif filepro ftp gd gettext iconv imap ldap mbstring mcal mcrypt mhash mime_magic mysql ncurses openssl overload pcntl pcre posix session shmop sockets standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlrpc xslt yp zip zlib [Zend Modules]
It appears to me that mysql.so is loaded.
I run the script from /home/myuser/ezpublish_root/.
Steven E. Bailey
Thursday 11 May 2006 4:52:47 am
Access denied for user: 'root@localhost' (Using password: NO)
Is this true? You are running mysql with the default user root with no password?
Certified eZPublish developer http://ez.no/certification/verify/396111 Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com
Thursday 11 May 2006 4:56:44 am
Hmm, interesting is in this debug ouput that script reads database data from site.ini not from your overrides (siteaccess)? What are results with:
php runcronjobs.php -s your_siteaccess
Thursday 11 May 2006 5:11:22 am
Much better..
tiberius:/home/my_user/ezpublish# php runcronjobs.php -s plain_user Using siteaccess plain_user for cronjob Running cronjobs/workflow.php Checking for workflow processes Status list 0 out of 0 processes was finished Running cronjobs/notification.php Starting notification event processing Done Running cronjobs/linkcheck.php Checking link ... check-http://ez.no/ez_publish/documentation valid check-http://ez.no/community/forum valid check-http://ez.no/services/support valid check-http://ez.no/services/consulting valid check-http://ez.no/services/training valid check-http://ez.no valid ... All links have been checked! Running cronjobs/unpublish.php Running cronjobs/rssimport.php Running cronjobs/indexcontent.php Starting processing pending search engine modifications Done Running cronjobs/hide.php Running cronjobs/subtreeexpirycleanup.php
Thanks guys!
PS! What on earth is the linkcheck.php for?
Thursday 11 May 2006 5:13:29 am
You can disable it in cronjobs.ini.append.php. Basically checks if link is accessible or not.