Hello everybody.
I have two servers in the Internet. They both are running mysql
3.23.27-beta and Openssh 2.1.1; I am trying to replicate the db running on
server2.domain.com in client2.domain.com. To do so I did the following:
1. Configured client2 to replicate vs. localhost (under its point of view)
by the port 4242. Thats the whole my.cnf:
[mysqld]
replicate-do-db=database
master-host=localhost
master-port=4242
master-connect-retry=5
master-user=replicador
master-password=password
server-id=2
2. Opened an ssh session and tunnel like follows:
ssh -l user -L 4242:server2:3306 server2 -p 1222
On server2 sshd listens on port 1222; mysql on port 3306. If I now
scan my openned ports I can see 4242 as opened. If I telnet to that
port a mysql server responds to me.
3. The mysql log shows me lots of this error msg: binary log not open(0)
after rebooting the server.
I don`t think it`s an access error. If I configure slave to run directly
(with no ssh) versus 3306 on server2 it replicates fine, changin
master-host and port values in my.cnf.
I send copy of this message to ssh list; has anyone done what I`m trying????
Best regards, Juan.
