Database error when running runcronjobs.php

«

Previous topic

|

Install & configuration

|

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 04:25:39
Script start
Timing:	Jan 31 2025 04:25:39
Module start 'layout'
Timing:	Jan 31 2025 04:25:39
Module start 'content'
Timing:	Jan 31 2025 04:25:39
Module end 'content'
Timing:	Jan 31 2025 04:25:39
Script end

Main resources:

Total runtime	0.0162 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0054	588.3828	151.2422
Module start 'layout'	0.0054	0.0026	739.6250	36.7109
Module start 'content'	0.0081	0.0066	776.3359	102.3438
Module end 'content'	0.0147	0.0015	878.6797	41.9922
Script end	0.0162		920.6719

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	14.4312	14	0.0002
Check MTime	0.0012	7.1209	14	0.0001
Mysql Total
Database connection	0.0007	4.4880	1	0.0007
Mysqli_queries	0.0032	19.6589	3	0.0011
Looping result	0.0000	0.0807	1	0.0000
Template Total	0.0011	6.6	1	0.0011
Template load	0.0008	5.1147	1	0.0008
Template processing	0.0002	1.4471	1	0.0002
Override
Cache load	0.0006	3.6573	1	0.0006
General
dbfile	0.0025	15.6156	8	0.0003
String conversion	0.0000	0.0440	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs