[HowTO] add cronjob on Debian Lenny Improved

[xtc007]

have you build the sql table with the sql file provided, a field have been added from the older version,

you must have the true_domain_id field, else an error will occure

i suppose this are a wrong line typed too fast...

server: localhost:

the second : aren't supposed to be here...

xtc007
RTMedia.ca

(01-03-2010 06:24 AM)MasterTH Wrote:  Array
File: /var/www/ispcp/gui/client/cronjobs_overview.php (Line: 63) Function: exec_query
File: /var/www/ispcp/gui/client/cronjobs_overview.php (Line: 123) Function: gen_cron_jobs


I get this email from the ispcp daemon.

The databasesettings are correct.
server: localhost:
Port: 3306
Database: ispcp
table : hcrondtab

as connectionuser i used the root-user but this shouldnt be the problem

[MasterTH]

yes typed too fast, its just "localhost"

and yes i'm imported the *.sql-file which comes in the package
in the table is a file called true_domain_id

[xtc007]

use the fqnl of the machine, like web.server.com or the ip of the machine, i don't have tried with localhost in field

xtc007
RTMedia.ca

[MasterTH]

same error occured

[xtc007]

are you able to connect in mysql command line with your user and password, or with phpmyadmin? i have reproduce your problem by inserting a bad password in my /etc/hcrondrc file

# host - address (IP or hostname) of server running mysql
host = put your fully qualified name

# port - the port mysql listens to
port = 3306

# user - username
user = username

# pass - password
pass = yourpassword

# dbnm - database name
dbnm = ispcp

# table - table name
table = hcrondtab



you can try that line too
# allow_root (bool) - allow running cmd with uid=0 or gid=0
allow_root = no

try to put yes on this line

xtc007
RTMedia.ca

[MasterTH]

this is my config file:

Code:

# sample hcrond config file

# comments begin with #, whole line is ignored
# empty lines are ignored
# so is all whitespace other than newline
# one 'option = "value"' per line, "s can be omitted unless empty

# the values used here are the defaults

# bool values are expressed (case insensitively) with any of
# 1, 0, true, false, yes, no

# command line options have preference over these
# there are other command line options:
#  configfile - configfile filename
#  help - show help
#  version - show version

# XXX Please note that many of the options are not yet implemented, see --help

# pidfile - hcrond pidfile filename
pidfile = /var/run/hcrond.pid

# host - address (IP or hostname) of server running mysql
host = 127.0.0.1

# port - the port mysql listens to
port = 3306

# user - username
user = root

# pass - password
pass = password

# dbnm - database name
dbnm = ispcp

# table - table name
table = hcrondtab

# allow_root (bool) - allow running cmd with uid=0 or gid=0
allow_root = yes

# allow_uidgid (bool) - allow running cmd with different uid && gid
allow_uidgid = yes

# force_uid - run everything with this uid or username
force_uid = ""

# force_gid - run everything with this gid or groupname
force_gid = ""

# force_hostname - use this hostname for comparison with `machine' field
force_hostname = ""

# ignore_machine (bool) - ignore the `machine' field
ignore_machine = false

# allow_notnice (bool) - allow negative nice values
allow_notnice = false

# force_shell - always use this shell
force_shell = ""

# force_shell_die (bool) - die if forced shell different from `sh'
force_shell_die = true

# reload - reload
reload = 30

# debug (bool) - debug mode (no detach and more verbosity)
debug = false

# max_jobs - keep only up to $max_jobs jobs running at the same time (0 = oo)
max_jobs = 5

PMA & mysql over shell works fine...
When i enable the debug mode in the config file i could see that the connection to the mysql has been made.

[xtc007]

let me sleep on it, i will think what's wrong with your configuration...

all gui files are copied at good place?

you have set permission on them

the current cronjob are a fresh install or you have tried to install before on this server?

xtc007
RTMedia.ca

[koko92_national]

I think that host shouldn't be 127.0.0.1 but it should be host.domain.com It works fine for me.

[MasterTH]

i'll try it with domain.tld and post back.

its a fresh installation, all files are where they should be (i followed the readme)

[koko92_national]

After you edit the config file do you restart the service? Its a silly question but i have to ask.