Mirrored Servers by the Book

Discussion in 'Installation/Configuration' started by jtheed, Nov 5, 2010.

  1. jtheed

    jtheed Member HowtoForge Supporter

    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 [email protected] (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?
  2. falko

    falko Super Moderator ISPConfig Developer

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

    jtheed Member HowtoForge Supporter

    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?

    Everything appears to be correct as far as the type, host, database user and characterset but the password is encrypted, yes?
    Last edited: Nov 7, 2010
  4. falko

    falko Super Moderator ISPConfig Developer

    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.
  5. jtheed

    jtheed Member HowtoForge Supporter

    Cleartext as in 32 hex characters long?
  6. falko

    falko Super Moderator ISPConfig Developer

    That looks like an MD5 encrypted password. Have you tried to replace it with the cleartext password?
  7. jtheed

    jtheed Member HowtoForge Supporter

    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

Share This Page