#1  
Old 5th November 2010, 14:31
jtheed jtheed is offline
Member
 
Join Date: Jul 2007
Posts: 70
Thanks: 12
Thanked 4 Times in 3 Posts
Default Mirrored Servers by the Book

I am trying to setup a Slave Server for an ISPConfig3.03 Server. Both are NEW machines and both are using version 3.03 with a debian 5.06 netinstall.

Everything goes fine until I go to install ISPConfig3.03 on the slave server. By the manual, it says to use expert mode, give a new db name and do not install the web interface. I have copied over the debian.cnf file before restarting the mysql. According to the manual, the only thing you don't duplicate on the slave is the copying of the backup files for mysql and www and the host and db names are to be different. The install completes but when I go back to the master and try to run the ispconfig interface, I get an error.
Before I created the slave, I was able to get into the ISPConfig interface.

The error is: Access denied to ispconfig@localhost (using password:YES) in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 72

I've tried doing this 3 times now from the beginning and every time I end up getting this error. twice it has corrupted a random table, 1 in the mysql dba dn one in the 1st ispconfig db.

The privileges are all there, the user root from the slave server is in the db and there is also a name of ispcsrv2 from the slave server is in the mysql db.
I have rebooted both servers with no change.

I can see the db's using phpmyadmin but viewing the information.schema db comes up very slow but I can view all tables in it as well as the other db's.

No log file at all in /var/log/mysql.
In the /var/log/apache2/error.log, I also see that I am getting the exact same error for vlogger in :
/usr/local/ispconfig/server/scripts/vlogger at line 514.

Any ideas on this one?
Reply With Quote
Sponsored Links
  #2  
Old 6th November 2010, 16:09
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Why did you copy the debian.cnf? Don't you get errors now when you restart MySQL?

Are the MySQL credentials in /usr/local/ispconfig/interface/lib/config.inc.php correct?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 6th November 2010, 16:56
jtheed jtheed is offline
Member
 
Join Date: Jul 2007
Posts: 70
Thanks: 12
Thanked 4 Times in 3 Posts
Default

Quote:
Originally Posted by falko View Post
Why did you copy the debian.cnf? Don't you get errors now when you restart MySQL?
I copied it because in your manual on page 51 it says:
When you setup the slave server, copy the file /etc/mysql/debian.cnf file from the master server to the slave server before you restart MYSQL again!
Could it be that this was supposed to be the my.cnf file?

Quote:
Originally Posted by falko View Post
Are the MySQL credentials in /usr/local/ispconfig/interface/lib/config.inc.php correct?
Everything appears to be correct as far as the type, host, database user and characterset but the password is encrypted, yes?

Last edited by jtheed; 7th November 2010 at 17:23.
Reply With Quote
  #4  
Old 7th November 2010, 22:04
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Quote:
Originally Posted by jtheed View Post
I copied it because in your manual on page 51 it says:
When you setup the slave server, copy the file /etc/mysql/debian.cnf file from the master server to the slave server before you restart MYSQL again!
Could it be that this was supposed to be the my.cnf file?
Ah, ok. No, debian.cnf is correct.

Quote:
Originally Posted by jtheed View Post
Everything appears to be correct as far as the type, host, database user and characterset but the password is encrypted, yes?
The password is written in cleartext in /usr/local/ispconfig/interface/lib/config.inc.php, but it's encrypted in the database.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 9th November 2010, 04:20
jtheed jtheed is offline
Member
 
Join Date: Jul 2007
Posts: 70
Thanks: 12
Thanked 4 Times in 3 Posts
Default

Quote:
Originally Posted by falko View Post
Ah, ok. No, debian.cnf is correct.

The password is written in cleartext in /usr/local/ispconfig/interface/lib/config.inc.php, but it's encrypted in the database.
Cleartext as in 32 hex characters long?
Reply With Quote
  #6  
Old 9th November 2010, 17:54
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

That looks like an MD5 encrypted password. Have you tried to replace it with the cleartext password?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 9th November 2010, 20:13
jtheed jtheed is offline
Member
 
Join Date: Jul 2007
Posts: 70
Thanks: 12
Thanked 4 Times in 3 Posts
 
Default

Quote:
Originally Posted by falko View Post
That looks like an MD5 encrypted password. Have you tried to replace it with the cleartext password?
In the 3 machines that I have ISPConfig 3 installed on, all 3 of them have an MD5 password in that config.inc.php file. I did not try changing the password to a cleartext password.

I needed to get my SSL cert working, so I created a new machine and have transferred the one particular web site that needed the SSL Cert to the new machine and as soon as I can get the rest of the sites transferred, I will start again fresh with 2 other machines.

I tried to get the mirror working 3 times before I went with the standalone machine. Out of the 3 tries, twice a mysql table was corrupted right after I installed ispconfig3 on the slave. They were not the same one each time.

Also, you have in the manual to add the backports repository and then do an apt-get install of the debian-backports-keyring, before you do an apt-get update. so of course, it doesn't find the app until after you do an apt-get update. Just something you may want to reverse on an update to the manual.

Just to make sure I am doing it right, there are not that many things that are different on the slave vs the master server.
The Server Name, IPAddress, Copying the files from mysql_bak to mysql and www_bak to www only on the master, copying the debian.cnf from the master to the slave, create the root user for the slave server in mysql and grant options and then on the master, set the slave as the mirror. Everything else is all the same, correct?

When setting up the glusterfs server configuration files and volume files, is it ok to create the files on the master and then just copy them to the slave?

I'd like to say Thanks to You and Till for all the patience and hard work you guys do on this project. I for one would still be using Windoze for my internet servers if not for you guys.
Thank You Thank you Thank you
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
Help:two isp3 servers primary and secondary dns u4david Installation/Configuration 6 17th June 2010 21:53
DNS data from Standalone servers to Primary DNS server SamTzu Tips/Tricks/Mods 7 15th November 2009 14:38
Using ISPConfig on mirrored primary and secondary servers wxman Installation/Configuration 6 8th April 2009 14:34
Unable send receive emails vassilis3 Installation/Configuration 15 19th May 2007 15:34
No SPF record. beryl Installation/Configuration 6 17th May 2007 20:52


All times are GMT +2. The time now is 18:23.


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