problem with mirror setup and multiserver setup

Discussion in 'Installation/Configuration' started by acrobal, Mar 28, 2011.

  1. acrobal

    acrobal New Member

    Hi,

    I installed ispconfig3 on 3 servers. 2 servers installed with mirror setup with this tutorial

    http://www.howtoforge.com/installin...tabase-cluster-on-debian-5.0-with-ispconfig-3

    with all service except DNS.

    It worked well but when I had the third server to DNS service with this tutorial

    http://www.howtoforge.com/installin...tabase-servers-on-debian-5.0-with-ispconfig-3

    I had this problem
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php

    to resolv this problem I pasted the password found on /usr/local/ispconfig/server/lib/config.inc.php

    and i do this command

    mysql -u root -p
    use mysql;
    mysql> update user set password=PASSWORD("Password found on th file") where User='ispconfig';
    flush privileges;
    quit

    I resolv the problem but I have a new error

    PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 78
    PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
    PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

    Any idea?? please
    Thank you for all your answers
     
  2. acrobal

    acrobal New Member

    Falko Till could you help me please to understand what is wrong or would like some additionals informations

    the last week i did the same install and I had no problem with
     
    Last edited: Mar 28, 2011
  3. abu.hurayra

    abu.hurayra New Member

    I think I have a problem alike :

    in ispconfig/cron.log I have
    Code:
    PHP Warning:  mysql_connect(): Access denied for user 'ispcsrv4'@'ns1.myisp.be' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php
     on line 78
    PHP Warning:  mysql_errno() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 63
    PHP Warning:  mysql_error() expects parameter 1 to be resource, boolean given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 64

    I tried to launch ispconfig's update.php (and second time telling it reconfigure permissions) but it didn't change anything (maybe parameter 1 ... boolean actually appeared after that)

    In Master DB/ DB mysql/ Table user I have :
    Code:
    	Modifier 	Effacer 	ns1.myisp.be 	ispcsrv4 	*FA44CAB3F0172E7017ED9F04D7AEE769ED03D4CB 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	  	[BLOB - 0o] 	[BLOB - 0o] 	[BLOB - 0o]	0 	0 	0 	0
    	Modifier 	Effacer 	10.0.10.83 	ispcsrv4 	*FA44CAB3F0172E7017ED9F04D7AEE769ED03D4CB 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	  	[BLOB - 0o] 	[BLOB - 0o] 	[BLOB - 0o]	0 	0 	0 	0
    Config is 1 Master + 3 DNS Servers +1 DB Server + 1 Mail Server (ns2 works AND is mirror of ns1 ..), Debian 6.0, ISPConfig 3.0

    Please note that we had a bug in config : ns1 was mirror of ns2 AND ns2 was mirror of ns1 AND ns3 was mirror of ns2.
    Now ns1 is not a mirror anymore..

    From ispconfig interface I cannot see anything on ns1 in monitor tab..

    I don't have a clue of what to do next ..

    Keep on doing good work

    Cheers
    Abu Hurayra


    Edit : Forget to tell you :
    On ISPConfig Interface the status of ns1 is "ok"
    Well, Maybe it's ok but it seems it don't update anymore !!
     
    Last edited: Apr 12, 2011
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Do you have a problem only with the ns1 server or with the otherservers as well? And in which database did you update the ispconfig user manually?
     
  5. abu.hurayra

    abu.hurayra New Member

    All others servers seems ok, I can see logs or system information in interface.
    I checked on ns2 in /etc/bind/ It updates the config when I update DNS in ISPConfig interface
    I didn't update it manually
    I launched
    Code:
    php -q update.php
    because I first thought about a password problem.
    But :
    - Every Slave server avec one mysql database where he has his own ispconfig info.
    - The master Server avec one mysql database where he puts his info and all slave synchronize

    Can I give you more info ?

    Thanks for this quick reply !

    Abu Hurayra
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Please check the /etc/hosts files on all servers incl. the master server to ensure that they all contain the host lines for all servers that belong to this cluster.

    and post the output of:

    ls -la /var/run/mysqld/

    from the dns server.
     
  7. abu.hurayra

    abu.hurayra New Member

    I checked on all serveurs and they all have the same /etc/hosts that I copied via scp after install :
    Code:
    root@mail:~# cat /etc/hosts
    127.0.0.1       localhost
    10.0.10.81     mail.myisp.be    mail
    10.0.10.82     db.myisp.be      db
    10.0.10.83     ns1.myisp.be     ns1
    10.0.10.84     web.myisp.be     web
    10.0.10.85     ns2.myisp.be     ns2
    10.0.10.86     ns3.myisp.be     ns3
    10.0.10.88     backup.myisp.be  backup
    
    # The following lines are desirable for IPv6 capable hosts
    ::1     ip6-localhost ip6-loopback
    fe00::0 ip6-localnet
    ff00::0 ip6-mcastprefix
    ff02::1 ip6-allnodes
    ff02::2 ip6-allrouters
    Here is for ns1 :
    Code:
    root@ns1:/tmp/ispconfig3_install/install# ls -la /var/run/mysqld/
    total 12
    drwxr-xr-x 2 mysql root  4096 Apr 12 11:33 .
    drwxr-xr-x 6 root  root  4096 Apr 12 14:31 ..
    -rw-rw---- 1 mysql mysql    6 Apr 12 11:33 mysqld.pid
    srwxrwxrwx 1 mysql mysql    0 Apr 12 11:33 mysqld.sock
    Ad here is ns2 :
    Code:
    root@ns2:/etc/bind# ls -la /var/run/mysqld
    total 12
    drwxr-xr-x 2 mysql root  4096 Apr  7 17:57 .
    drwxr-xr-x 6 root  root  4096 Apr 12 14:31 ..
    -rw-rw---- 1 mysql mysql    6 Apr  7 17:57 mysqld.pid
    srwxrwxrwx 1 mysql mysql    0 Apr  7 17:57 mysqld.sock
    I don't think it is usefull but here is one record from /var/log/syslog (the same repeats itself every minute)
    Code:
    Apr 12 14:36:01 ns1 /USR/SBIN/CRON[26506]: (root) CMD (/usr/local/ispconfig/serv
    er/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log)
    It is how I ended up giving the content of /var/log/ispconfig/cron.log in my first post

    I checked ifconfig eth0 and resolv.conf on ns1 and ns2, they are the same (with their own ip adress)

    Inchaallah it helps
     

Share This Page