PDA

View Full Version : Multiserver Prolem / Salve doesnt get updated (jobqeue)


MM-
10th July 2009, 15:02
Hi all,

i did install a Multiserver setup with some information i did gathered on this forum. What i did was:

1) Install normal ISPCONFIG Masterserver
2) Install expert installation on Slave
db > localhost
masterserver db > x.x.x.x
ISPCONFIG Interface on Slave > Choose no


After looking at the Jobqeue (on the Masterserver), i saw it just gets filled with Updates for the Slave.

The ispconfig.log on both server is empty.

How can i debug this problem?

PS: If anybody has some notes about the "Replication", that would be great.

Thanks,
MM

Croydon
11th July 2009, 09:31
Try to enable verbose log in the ispconfig server config (/usr/local/ispconfig/server/lib/config.inc.php) on both the master and slave
$conf["log_priority"] = 0

Check if running
/usr/local/ispconfig/server/server.sh
gives any errors.

MM-
15th July 2009, 11:22
Sorry i had much todo and didnt dig into it.

After checking the log, i found this very clear message:
WARNING - DB::connect()-> mysql_connect Access denied for user 'ispcsrv5'@'static.169.58.40.188.clients.your-server.de'
SELECT * from user on master, shows that the user is added but with the worng ip / hostname.

The problem is caused by wrong entry's in /etc/hosts.

MM-
15th July 2009, 11:25
By the way, this message seems more then a WARNING log message :o)

till
16th July 2009, 12:04
You will have to correct the settings in the hosts file and then correct the permission records (allowed hsos) for the user ispcsrv5 in the mysql master database table.

MM-
17th July 2009, 12:42
yeah i did that and ispconfig runs now very nicely. (forgot to say that after figuring out the problem:))

Again, shouldn't this message be rated as ERROR? :confused:
If yes, should i report a bug?