index.html keeps reappearing

Discussion in 'Installation/Configuration' started by gkovacs, Jan 18, 2009.

  1. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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?
     
  3. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    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 ...
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

  5. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    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.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  7. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    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 ??
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  9. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    see this

    the output of tail -n 100 /var/log/mysqld.log

    120209 15:33:27 [Warning] Found invalid password for user: '[email protected]'; Ignoring user
    120209 15:33:27 [Warning] Found invalid password for user: '[email protected]'; Ignoring user
    120209 15:37:34 [Warning] Found invalid password for user: '[email protected]'; Ignoring user
    120209 15:37:34 [Warning] Found invalid password for user: '[email protected]'; Ignoring user

    but the user and pass is correct on this files.
     
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    The ispconfig user is used by all services to connect to the mysql db. Have you changed the password for the ispconfig user manually?
     
  11. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    Yes,

    I use root user and password for the

    mysql-virtual_client.cf
    mysql-virtual_recipient.cf
    mysql-virtual_transports.cf

    etc files ...
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  13. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    I changed becouse ispconfig user got login error.
     
    Last edited: Feb 9, 2012
  14. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    Don't worry thanks a lot i can reinstall server and then migrate.
     
  15. till

    till Super Moderator Staff Member ISPConfig Developer

    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
     
  16. sulfuric

    sulfuric ISPConfig Developer ISPConfig Developer

    OK thanks

    SOLVED !!! thanks a lot ...
     

Share This Page