Navigation

MM- · #1 10th July 2009, 14: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 · #2 11th July 2009, 08: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

Code:

$conf["log_priority"] = 0

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

MM- · #3 15th July 2009, 10: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- · #4 15th July 2009, 10:25

By the way, this message seems more then a WARNING log message

)

till · #5 16th July 2009, 11: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.