Forums / Install & configuration / Database error when running runcronjobs.php

Database error when running runcronjobs.php

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