Re: [Replication] Problem connecting to master

[Jan Roehrich]

 If nothing helps, trace files could spill the light on your problem.

many thanks for your help. With tracing I found the problem. Like almost
every time it was just a typing error :-(

Regards Jan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Replication] Problem connecting to master

[Jan Roehrich]

 Please send your configuration files for master and slave. Check that
 
 you don't have skip-networking in your slave's configuration file.

Master:
--
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=bin-log
server-id=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
---

Slave:
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
server-id=2
master-host=82.165.25.207
master-port=3306
master-user=replication
master-password=hw4Gabfy


[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
--

Could not see skip-networking anywhere.

Greetings Jan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [Replication] Problem connecting to master

[Jan Roehrich]

 --skip-networking can be specified as the command line option. Use:
   show variables like 'skip_networking';
 to check if it is enabled.

mysql show variables like 'skip_networking';
+-+---+
| Variable_name   | Value |
+-+---+
| skip_networking | OFF   |
+-+---+




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[Replication] Problem connecting to master

[Jan Roehrich]

I have a strange problem setting up replication. I followed each step of
setting up replication in the mysqld documentation
(http://dev.mysql.com/doc/mysql/en/replication-howto.html). 

But there are some error messages on the salve:
050828 13:22:58 [ERROR] Slave I/O thread: error connecting to master
'[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL
server on 'alturo.vlugnet.org' (13)'  errno: 2003  retry-time: 60 
retries: 86400

When I try to connect to the master using same hostname, same user, same
password with the mysql client it works without problems. 

I tried to drag the problem with ethereal. It seems that the slave doesn't
even try to connect to the master. There are not even connection attempts
between master and slave on port 3306.

Also have a look at http://forums.mysql.com/read.php?26,36766 it seems
that he has the same problem.

As slave I'm using mysql version 4.1.12 on Fedora Core 4. Master is
3.23.58 on Fedora Core 2.

Any ideas?

Regards Jan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]