Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 20th September 2011, 06:07
holykim holykim is offline
Member
 
Join Date: Jan 2009
Posts: 53
Thanks: 15
Thanked 3 Times in 2 Posts
Default Slave with Mysql5.5 cannot connect to the Master

Hi,

Recently I installed MySQL 5.5 to one of the slaves and found that it cannot connect to the master server anymore. I created a new db on the slave from the master server but nothing created.

I tried to reconfigure permission in the master database but got an error as below.
Unable to connect to mysql server Lost connection to MySQL server at 'reading initial communication packet', system error: 110

All other slaves which installed MySQL 5.0 are working fine. I installed MySQL 5.5 to the test server and had a same result.

I cannot figure out how to resolve this issue and need your advise. ISPConfig version is 3.0.3.3.

Thanks in advance.

Harry
Reply With Quote
Sponsored Links
  #2  
Old 20th September 2011, 09:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,472
Thanks: 813
Thanked 5,255 Times in 4,121 Posts
Default

Are you able to connect to the master server as root user from the shell of the slave with the mysql command. Example:

mysql -h master.yourdomain.tld -u root -p dbispconfig

the command should ask you then for the root password of the master server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th September 2011, 10:30
holykim holykim is offline
Member
 
Join Date: Jan 2009
Posts: 53
Thanks: 15
Thanked 3 Times in 2 Posts
 
Default

Thanks Till

I was unable to have the connection to the master server. It wasn't mysql problem.

I added the master IP in the hosts file and it works.

Thanks again.

Harry
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
ISPConfig "backend" completely unfunctional after a restart Xaymar Installation/Configuration 1 22nd August 2011 22:31
Email problem 'Cannot set my user or group id.' (using ISPConfig 3 + OpenSuSE 11.2) urosm Installation/Configuration 5 19th June 2010 22:41
can't send/receive mail fedora 12 - ispconfig 3 ev0css Installation/Configuration 9 17th May 2010 21:44
ISPConfig 3 Send/Receive mail not working. Acidut General 6 4th April 2010 11:24
Mail not working epicuniversal General 5 13th June 2009 08:24


All times are GMT +2. The time now is 15:29.


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