Re: Replication OpenBSD <-> Linux is failing

2002-05-20 Thread Michal Ludvig

On Mon, 20 May 2002, Jeremy Zawodny wrote:

> On Mon, May 20, 2002 at 03:44:36PM +0200, Michal Ludvig wrote:
> > Hi all,
> > I have a master MySQL server running 3.23.49 on RedHat Linux 7.2 and want 
> > to setup a slave on OpenBSD 3.0 (both are i386 archs). So I took the 
> > source (3,23,49 as well), compiled natively and configured as a slave. The 
> > problem is, that I can't connect to the master: it always fails with:
> > Access denied for user: 'repl@slave' (Using password: YES)
> 
> What if you shutdown the slave, remove the master.info file, and start
> it back up?

Oh, shame on me! Now it works... Thanks a lot!

Michal Ludvig


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Replication OpenBSD <-> Linux is failing

2002-05-20 Thread Michal Ludvig

Hi all,
I have a master MySQL server running 3.23.49 on RedHat Linux 7.2 and want 
to setup a slave on OpenBSD 3.0 (both are i386 archs). So I took the 
source (3,23,49 as well), compiled natively and configured as a slave. The 
problem is, that I can't connect to the master: it always fails with:
Access denied for user: 'repl@slave' (Using password: YES)

My /etc/my.cnf on slave is:
[mysqld]
master-host=master
master-user=repl
master-password=ahoj
master-port=3306
server-id=3
datadir=/space/mysql
default-character-set=latin2
log-slave-updates
log=mysql.log

There are two strange things:
1) I can connect from slave to master with the command line mysql:
slave% mysql -h master -u repl -p 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3463 to server version: 3.23.49-log
[...]
mysql> ^D
2) I can connect from different machine (say slave2) running SuSE Linux 
8.0 with exactly the same my.cnf (except different server-id) and 
successfully replicate the database.

Have anyone met the same problems? Can someone try it?

Michal Ludvig


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php