Re: Slave is not updated

2009-12-24 Thread Nagaraj S
Master_SSL_CA_File: >Master_SSL_CA_Path: > Master_SSL_Cert: > Master_SSL_Cipher: >Master_SSL_Key: > Seconds_Behind_Master: NULL > > > Thanks > Jeetendra Ranjan > - Original Message - From: "Shanmugam, Dhandapani&qu

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
Please ignore the user name and ip. i am passing the right information here - Original Message - From: "Parikh, Dilip Kumar" To: "Jeetendra Ranjan" ; Sent: Thursday, December 24, 2009 2:51 PM Subject: RE: Slave is not updated User is not the replicat

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
m: "Shanmugam, Dhandapani" To: "Parikh, Dilip Kumar" ; "Jeetendra Ranjan" ; Sent: Thursday, December 24, 2009 2:47 PM Subject: RE: Slave is not updated by the way did you flush the privileges on the master? What is the output you get, when you log in as root user on th

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
.mysql.com Subject: RE: Slave is not updated User is not the replication it is 'root' (or) mysqladm Thanks, Dilipkumar Database Engineering + mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: Shanmugam, Dhandapani Sent: Thursday,

RE: Slave is not updated

2009-12-24 Thread Parikh, Dilip Kumar
ilip Kumar; Jeetendra Ranjan; mysql@lists.mysql.com Subject: RE: Slave is not updated by the way did you flush the privileges on the master? What is the output you get, when you log in as root user on the mysql master server and issue the below command: select * from mysql.user where user='

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
ilip Kumar [mailto:dilipkumar.par...@eds.com] Sent: Thursday, December 24, 2009 2:43 PM To: Jeetendra Ranjan; mysql@lists.mysql.com Subject: RE: Slave is not updated You can see in the logs, access denied So give trying for hostname or with full domain or Grant replication slave on *.* to 'mysqladm'@

RE: Slave is not updated

2009-12-24 Thread Parikh, Dilip Kumar
M To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com Subject: Re: Slave is not updated 091223 5:55:22 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.01' position: 4 091223 5:55:22 [ERR

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
Note] Slave I/O thread killed while connecting to master 091224 1:04:48 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.42', position 4436 091224 1:04:48 [Note] Error reading relay log event: slave SQL thread was killed 091224 1:07:59 [Note] Slave SQL thr

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
Jeetendra, Can you paste the error log here. -D -Original Message- From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com] Sent: Thursday, December 24, 2009 1:49 PM To: Parikh, Dilip Kumar; mysql@lists.mysql.com Subject: Re: Slave is not updated Hi Dilip, Thanks for your

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
: "Jeetendra Ranjan" ; Sent: Thursday, December 24, 2009 1:10 PM Subject: RE: Slave is not updated You can see connecting to master means it is not able to establish the connection from slave to master, give the grants as (replication client etc..) and then try again. Thanks,

RE: Slave is not updated

2009-12-23 Thread Parikh, Dilip Kumar
You can see connecting to master means it is not able to establish the connection from slave to master, give the grants as (replication client etc..) and then try again. Thanks, Dilipkumar Database Engineering Pager mail:9884430...@nma.vodafone.in -Original Message- From: Jeetendra Ranjan