Database error when running runcronjobs.php

Next topic

Author	Message
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
Felix Laate	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. Felix Publlic Relations Manager Greater Stavanger www.greaterstavanger.com
Ł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
Felix Laate	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/. Felix Publlic Relations Manager Greater Stavanger www.greaterstavanger.com
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
Łukasz Serwatka	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 Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Felix Laate	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! Felix PS! What on earth is the linkcheck.php for? Publlic Relations Manager Greater Stavanger www.greaterstavanger.com
Łukasz Serwatka	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. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog