Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 28th March 2011, 14:23
acrobal acrobal is offline
Junior Member
 
Join Date: Apr 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with mirror setup and multiserver setup

Hi,

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

http://www.howtoforge.com/installing...th-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/installing...th-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
Reply With Quote
Sponsored Links
  #2  
Old 28th March 2011, 17:23
acrobal acrobal is offline
Junior Member
 
Join Date: Apr 2009
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 by acrobal; 28th March 2011 at 17:25.
Reply With Quote
  #3  
Old 12th April 2011, 11:52
abu.hurayra abu.hurayra is offline
Junior Member
 
Join Date: Apr 2011
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Question

Quote:
Originally Posted by acrobal View Post
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
Thank you for all your answers
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 by abu.hurayra; 12th April 2011 at 11:56.
Reply With Quote
  #4  
Old 12th April 2011, 12:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,500 Times in 4,329 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 12th April 2011, 12:47
abu.hurayra abu.hurayra is offline
Junior Member
 
Join Date: Apr 2011
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
Thumbs up

Quote:
Originally Posted by till View Post
Do you have a problem only with the ns1 server or with the otherservers as well?
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
Quote:
Originally Posted by till View Post
And in which database did you update the ispconfig user manually?
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
Reply With Quote
  #6  
Old 12th April 2011, 13:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,500 Times in 4,329 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 12th April 2011, 14:43
abu.hurayra abu.hurayra is offline
Junior Member
 
Join Date: Apr 2011
Posts: 7
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by till View Post
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.
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
Quote:
Originally Posted by till View Post
and post the output of:

ls -la /var/run/mysqld/

from the dns server.
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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail send/recieve problem DKLeader Installation/Configuration 14 22nd February 2011 15:13
Multiserver setup with mysql-only server Croydon Developers' Forum 4 21st February 2011 22:04
Multiserver Setup on Centos 5.5 dfinehub Installation/Configuration 3 24th October 2010 12:47
multiserver setup IzFazt Installation/Configuration 8 8th August 2010 17:58
Multiserver setup design documentation agoston Developers' Forum 4 4th June 2009 13:53


All times are GMT +2. The time now is 10:11.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.