PHP Warning: 7 is not a valid MySQL-Link resource
OK, I've been through all the related threads I could find. The problem is that the cron list of ISPConfig does not get executed.
My error response when executing
is littered with
PHP Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 184
PHP Warning: mysql_select_db(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 104
errors. I' ve checked the mysql access using
mysql -h localhost -u root dbispconfig -p
with the user(root) and password as stored in
tar xvfz ISPConfig-3-stable.tar.gz
php -q update.php
The /var/log/mysql.err and /var/mysql.log files are empty. I've had to disable the /usr/local/ispconfig/server/server.sh entry in crontab just to keep my sever from misbehaving.
IServer: 22.214.171.124 (Debian Squeeze/Sid)
Everything worked fine up to the point where I did general system upgrade. My /etc/hosts file looks like this:
127.0.0.1 localhost localhost.localdomain
# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
Anything that I can do next to solve this problem?
The file /usr/local/ispconfig/server/lib/config.inc.php may not contain the mysql root user or password. If it conatisn the user root on your setup, then you have a installtion error. The mysql user used by ispconfig to connect with the database is always named "ispconfig". The file mysql_cientdb.conf contains the root user which is only used to create new mysql databases.
The error can also be caused by wrong settings in the mysql my.cnf file e.g. when you set timeout values too low.
Thanks till , good to know what is happening behind the scenes. :)
I changed the root users to ispconfigs, and experimented a bit. The mails get delivered, and adding websites and databases works. BUT the cron list is not deleted, which causes all the actions to be repeated whenever /usr/local/ispconfig/server/server.sh is executed.
Is there any way to remove the tasks from the cronlist?
Your sytem seams to be really messed up as someone must have altered a lot of ispconfig files manually and entered wrong users there or changed permissions in mysql. You should consider to run a ispconfig update and let the ispconfig updater on all servers that belong to the cluster and let the ispconfig updater reconfigure the permissions in the mysql database.
No, I mean the ISPconfig jobqueue under the monitor tab. Wrong wording, sorry.
Login to ispconfig, go to monitor > System state > system log and select loglevel error. If there are any errors listed, delete them by clicking on the delete icon.
No errors listed.
The Monitor-> Show services shows something interesting :
but my apache server is running. And all the sites are served. The System -.> system services list the web server as activated. Why would it report here as not running?
Went through everything. In the end, my problem seems to be solved when I edit the database according to this link:
|All times are GMT +2. The time now is 23:05.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.