Hi,
I guess this is right place for this. I'm trying to setup replication
between two hosts over the Internet.
My problem is that i can't seem to solve an authentication problem
between the slave and the master. Before I tried this I setup a test
between two computers here in the office and managed to get it to work.
My config is as follows for the master:
-------------------/etc/my.cnf
# global options for mysql
[mysqld]
set-variable = ft_min_word_len=2
set-variable = ft_stopword_file=/var/lib/mysql/stopwords
log-bin
server-id=2048
ssl-ca=/usr/share/ssl/mysql-cacert.pem
ssl-cert=/usr/share/ssl/mysql-cert.pem
ssl-key=/usr/share/ssl/mysql-key.pem
Grants for [EMAIL PROTECTED]
GRANT FILE, SUPER, REPLICATION SLAVE ON *.* TO 'repl'@'XXXX.demon.co.uk'
IDENTIFIED BY PASSWORD 'blah blah' REQUIRE SSL ;
and on the slave :
-----------------------------/etc/my.cnf
#mysql configuration file
[mysqld]
server-id=1024
master-host=www.YYYY.co.uk
master-port=3306
master-user=repl
master-password='blah blah'
master-connect-retry=30
master-ssl
master-ssl-key=/usr/share/ssl/mysql-client-key.pem
master-ssl-cert=/usr/share/ssl/mysql-client-cert.pem
report-host=XXXX.demon.co.uk
[client]
ssl-ca=/usr/share/ssl/mysql-cacert.pem
ssl-cert=/usr/share/ssl/mysql-client-cert.pem
ssl-key=/usr/share/ssl/mysql-client-key.pem
The error log records the following message
030603 9:16:50 Slave I/O thread: error connecting to master
'[EMAIL PROTECTED]:3306': Error: 'Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)' errno: 1045 retry-time:
30 retries: 86400
but using mysql client from XXXX.demon.co.uk
mysql --ssl -u repl -h www.YYYY.co.uk -p
works just fine!!
In addition if I change the master to allow plain none SSL connections
for repl then it works fine, well it conplains about something else
completely but that's a sync problem I can fix :)
My mysql version is 4.0.13 built from source using
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions
\
-fno-rtti" ./configure \
--enable-assembler \
--enable-local-infile \
--with-mysqld-user=mysql \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--prefix=/ \
--with-extra-charsets=complex \
--exec-prefix=/usr \
--libexecdir=/usr/sbin \
--sysconfdir=/etc \
--datadir=/usr/share \
--localstatedir=/var/lib/mysql \
--infodir=/usr/share \
--includedir=/usr/include \
--mandir=/usr \
--with-embedded-server \
--enable-thread-safe-client \
--with-vio \
--with-openssl ;
Any help or advice would be gratefully received.
Thanks,
--
Gareth Davis <[EMAIL PROTECTED]>
Logical Practice Systems Limited
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
