+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Contributions Area (/forum-40.html)
+--- Forum: Howtos (/forum-41.html)
+--- Thread: [HowTO] add cronjob on Debian Lenny Improved (/thread-9028.html)
RE: [HowTO] add cronjob on Debian Lenny Improved - xtc007 - 01-03-2010 06:36 AM
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
RE: [HowTO] add cronjob on Debian Lenny Improved - MasterTH - 01-03-2010 09:23 AM
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
RE: [HowTO] add cronjob on Debian Lenny Improved - xtc007 - 01-03-2010 09:39 AM
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
RE: [HowTO] add cronjob on Debian Lenny Improved - MasterTH - 01-03-2010 11:29 PM
same error occured
RE: [HowTO] add cronjob on Debian Lenny Improved - xtc007 - 01-04-2010 08:47 AM
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
RE: [HowTO] add cronjob on Debian Lenny Improved - MasterTH - 01-04-2010 03:14 PM
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 = 5PMA & 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.
RE: [HowTO] add cronjob on Debian Lenny Improved - xtc007 - 01-04-2010 03:20 PM
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
RE: [HowTO] add cronjob on Debian Lenny Improved - koko92_national - 01-04-2010 08:53 PM
I think that host shouldn't be 127.0.0.1 but it should be host.domain.com It works fine for me.
RE: [HowTO] add cronjob on Debian Lenny Improved - MasterTH - 01-05-2010 03:14 PM
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)
RE: [HowTO] add cronjob on Debian Lenny Improved - koko92_national - 01-05-2010 03:19 PM
After you edit the config file do you restart the service? Its a silly question but i have to ask.