isn't the unique regenerated files I see that in /etc/httpd/conf/sites-available the last create hosts keep regenerating. -rw-r--r-- 1 root root 3551 Feb 8 14:16 xxxxxxeds.es.vhost -rw-r--r-- 1 root root 2461 Feb 8 14:16 apartmentsbenidorm.xxxxxxntsvalencia.es.vhost -rw-r--r-- 1 root root 4148 Feb 8 14:16 xxxxxxentsvalencia.es.vhost -rw-r--r-- 1 root root 1022 Feb 9 10:38 apps.vhost -rw-r--r-- 1 root root 2398 Feb 8 14:16 barcelona.xxxxxentsvalencia.es.vhost -rw-r--r-- 1 root root 3534 Feb 8 14:16 xxxxxoliday.com.vhost -rw-r--r-- 1 root root 2138 Feb 8 14:16 holiday.xxxxxxentsvalencia.es.vhost.err -rw-r--r-- 1 root root 3960 Feb 8 14:16 holiday.xxxxxxa-holiday.com.vhost -rw-r--r-- 1 root root 2433 Feb 8 14:16 hostelvalencia.xxxxxxentsvalencia.es.vhost -rw-r--r-- 1 root root 2454 Feb 8 14:16 hotelesparagrupos.xxxxxxentsvalencia.es.vhost -rw-r--r-- 1 root root 1350 Feb 8 14:24 ispconfig.conf -rw-r--r-- 1 root root 1688 Feb 8 14:24 ispconfig.vhost -rw-r--r-- 1 root root 2398 Feb 8 14:16 peniscola.xxxxxxentsvalencia.es.vhost -rw-r--r-- 1 root root 2424 Feb 8 14:16 xxxxxxplayaresort.com.vhost -rw-r--r-- 1 root root 3581 Feb 8 14:16 pruebas.xxxxxxia-holiday.com.vhost -rw-r--r-- 1 root root 3541 Feb 8 14:16 xxxxxxms.es.vhost -rw-r--r-- 1 root root 3630 Feb 8 14:16 xxxxxxe.valencia-holiday.com.vhost -rw-r--r-- 1 root root 2696 Feb 9 10:38 svn.xxxencia-holiday.com.vhost -rw-r--r-- 1 root root 2780 Feb 9 10:38 xxxxxxpartments.com.vhost -rw-r--r-- 1 root root 3040 Feb 9 10:38 xxxxxxia-holiday.com.vhost
Are there any pending jobs listed in the jobqueue of the ispconfig monitor? Are there any messages with level "error" in the syslog in the ispconfig monitor?
thank a lot for your reply Yes jobqueue is full: 2012-02-08 17:31 server.xxxxxaprop.net Update web_domain 2012-02-08 17:00 server.xxxxxaprop.net Update web_domain 2012-02-08 16:58 server.xxxxxaprop.net Update cron 2012-02-08 16:48 server.xxxxxaprop.net Insert ftp_user 2012-02-08 16:47 server.xxxxxaprop.net Insert web_domain 2012-02-06 09:35 server.xxxxxaprop.net Update web_domain 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_soa 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr 2012-01-26 12:56 server.xxxxxaprop.net Delete dns_rr Page 1 of 12 NO errors in syslog ...
Ok,so there must be something on your server that blocks processing of jobs, so that the first job is repeated every minute. Pleases ee here on how to debug that: http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/
problem persists thats the debug tail 09.02.2012-14:37 - DEBUG - Processed datalog_id 1435 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 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 09.02.2012-14:37 - DEBUG - Calling function 'restartBind' from module 'dns_module'. 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 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 09.02.2012-14:37 - DEBUG - Calling function 'restartHttpd' from module 'web_module'. 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 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 09.02.2012-14:37 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 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 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 finished. PHP Warning: mysql_close(): 7 is not a valid MySQL-Link resource in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 360 i see similar problem http://www.howtoforge.com/forums/archive/index.php/t-51900.html but no solution. thanks for your helpful.
Check that the mysql login details in the following files are correct: /usr/local/ispconfig/server/lib/config.inc.php /usr/local/ispconfig/server/lib/mysql_clientdb.conf You can check them with the mysql comand like this: mysql -h localhost -u username dbispconfig replace username with the username from the file, the mysql command will then ask for the password, use the password from the config file.
correct Yes. It's correct and i can login with this credential with console mysql -u root -p and with phpmyadmin in /usr/local/ispconfig/server/lib/mysql_clientdb.conf only this 3 variables is normal ?? $clientdb_host = 'localhost'; $clientdb_user = 'xxxxxx'; $clientdb_password = 'kaoxxxxxx'; no $clientdb_database for example ?? thanks a lot ??
Yes, thats ok. Have you set some short timeouts in the my.cnf cobnfiguration file, if yes, then this might cause your problem as well when the mysql connection is dropped too fast.
see this the output of tail -n 100 /var/log/mysqld.log 120209 15:33:27 [Warning] Found invalid password for user: 'ispconfig@localhost'; Ignoring user 120209 15:33:27 [Warning] Found invalid password for user: 'ispconfig@localhost'; Ignoring user 120209 15:37:34 [Warning] Found invalid password for user: 'ispconfig@localhost'; Ignoring user 120209 15:37:34 [Warning] Found invalid password for user: 'ispconfig@localhost'; Ignoring user but the user and pass is correct on this files.
The ispconfig user is used by all services to connect to the mysql db. Have you changed the password for the ispconfig user manually?
Yes, I use root user and password for the mysql-virtual_client.cf mysql-virtual_recipient.cf mysql-virtual_transports.cf etc files ...
Thats not good, as it destroyed the ispconfig setup and is really insecure as well. You should undo the changes in all config files where you changed a mysql user. The mysql user that is used by the services like postfix, dovecot, courier, vlogger and pure-ftpd has to be the user "ispconfig" with the password that you find in the ispconfig config.inc.php files.
The username has to be "ispconfig" and the password has to be the password that is in the files /usr/local/ispconfig/server/lib/config.inc.php and /usr/local/ispconfig/interface/lib/config.inc.php. This mysql user is a user which is managed by ispconfig internally and shall not be altered as manual changes will break your server. You should either restore backups of all config files that you altered manually or you will have to search and fix all files which contain mysql login details to match the files from ispconfig. The files with the mysql login details are in the following locations on debian systems, the locations may differ on other distributions. /etc/postfix/ /etc/dovecot/ /etc/courier/ /etc/pure-ftpd/ /etc/amavis/ /etc/vlogger-dbi.conf
