Hola lista; No puedo replicar una base de datos MYSQL. La parte del maestro funciona. la parte del esclavo me da en el log 070214 14:55:00 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay lo g './linux-profesor-relay-bin.000001' position: 4 070214 14:55:00 [ERROR] Slave I/O thread: error connecting to master 'repl@linux-profesor.colon.org:3306': Error : 'Acceso negado para usuario: 'repl'@'linux-profesor.colon.org' (Usando clave: SI)' errno: 1045 retry-time: 6 0 retries: 86400 No se porque no se conecta pongo los scripts , pings y mysql -u de ambos lados ====================== EL MAESTRO espartaco02:/var/lib/mysql # ping maestro.colon.org PING espartaco02.dieguez.es (172.16.0.3) 56(84) bytes of data. 64 bytes from espartaco02.dieguez.es (172.16.0.3): icmp_seq=1 ttl=64 time=0.068 ms 64 bytes from espartaco02.dieguez.es (172.16.0.3): icmp_seq=2 ttl=64 time=0.068 ms espartaco02:/var/lib/mysql # ping esclavo.colon.org PING linux-profesor.colon.org (172.16.0.4) 56(84) bytes of data. 64 bytes from linux-profesor.colon.org (172.16.0.4): icmp_seq=1 ttl=64 time=0.146 ms en /etc/my.cnf server-id = 1 log-bin=/var/bd/repl/log-bin ====================== EN AMBOS espartaco02:/var/lib/mysql # mysql -u repl -p -h esclavo.colon.org Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 5.0.26-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye espartaco02:/var/lib/mysql # mysql -u repl -p -h linux-profesor.colon.org Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 5.0.26-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> mysql> show grants for 'repl'@'maestro.colon.org'; +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for repl@maestro.colon.org | +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'maestro.colon.org' IDENTIFIED BY PASSWORD '*2BE0312EC46D55F19DA2FB0C59FBA60F14AFB21A' | +-----------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show grants for 'repl'@'esclavo.colon.org'; +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for repl@esclavo.colon.org | +-----------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'esclavo.colon.org' IDENTIFIED BY PASSWORD '*2BE0312EC46D55F19DA2FB0C59FBA60F14AFB21A' | +-----------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) ====================== EL ESCLAVO linux-profesor:/var/lib/mysql # ping maestro.colon.org PING maestro.colon.org (172.16.0.3) 56(84) bytes of data. 64 bytes from maestro.colon.org (172.16.0.3): icmp_seq=1 ttl=64 time=0.133 ms linux-profesor:/var/lib/mysql # ping linux-profesor.colon.org PING linux-profesor.colon.org (172.16.0.4) 56(84) bytes of data. 64 bytes from linux-profesor.colon.org (172.16.0.4): icmp_seq=1 ttl=64 time=0.040 ms esclavo /etc/my.cnf--------------- [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M log=/var/lib/mysql/esclavo.log language=spanish server-id=2 master-host=maestro.colon.org master-user=repl master-password=redes1234 master-port=3306 ----------------------------------------------------------- linux-profesor:/var/lib/mysql # mysql -u repl -p -h linux-profesor.colon.org Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 to server version: 5.0.26-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> -- ************************************************** Juan Antonio Diéguez Martín Linux user #329149. See http://counter.li.org juanandieguez@telefonica.net Alcorcón (Madrid) ************************************************** ______________________________________________ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com --------------------------------------------------------------------- Para dar de baja la suscripción, mande un mensaje a: opensuse-es+unsubscribe@opensuse.org Para obtener el resto de direcciones-comando, mande un mensaje a: opensuse-es+help@opensuse.org