Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread Peter Peterse
] MYSQL replication question. Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread Richard Whittaker
On 2014-04-11 16:41, Wim Godden wrote: Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. So I did some more digging on this, and realized the IP 192.168.0.4 reverse resolved to more than one hostname, so I

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread Sebastian Grewe
Hey Goddon, Sorry, haven't followed the entire convo here but did you try adding the user@ip too? I see you try to connect with an IP so maybe it circumvents the host check? Cheers, Sebastian On 12.04.2014, at 21:50, Richard Whittaker rich...@avits.ca wrote: On 2014-04-11 16:41, Wim

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread richard
Hi.As mentioned I have tried GRANTS by IP, Hostname and wildcard, and various combinations of those.Thanks,Richard

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread richard
I am thinking of updating MYSQL to a more recent version, as that may solve this issue. 5.0.95 is pretty old. Are there any caveats using a newer version of MYSQL with QmailToaster, and what versions have people had success with? Running CentOS 5.10.Thanks,Richard

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread NoriyukiHayashi
Hi, I am going try to test on CentOS 5.10 64bit version with OpenSSL-0.9.8y and MySQL-5.5.23. I guess that is working including ezmlm,ezmlm-idx with MySQL. My impression is fine. php is php-5.4.x latest also. apache is 2.2.x as latest. thank you Nori -- NoriyukiHayashinhaya...@wats.gr.jp

Re: [qmailtoaster] MYSQL replication question.

2014-04-12 Thread NoriyukiHayashi
Hi, again In this case all depends packages and QMT must recompile as rpm rebuild that I did. I never use any repo. Thanks, -- NoriyukiHayashinhaya...@wats.gr.jp ibisMailで送信! - To unsubscribe, e-mail:

[qmailtoaster] MYSQL replication question.

2014-04-11 Thread Richard Whittaker
Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The

Re: [qmailtoaster] MYSQL replication question.

2014-04-11 Thread Eric Broch
If I may ask, where did you get the replication video? On 4/11/2014 4:53 PM, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers

Re: [qmailtoaster] MYSQL replication question.

2014-04-11 Thread richard
: qmailtoaster-list@qmailtoaster.comReply To: qmailtoaster-list@qmailtoaster.comSubject: Re: [qmailtoaster] MYSQL replication question. If I may ask, where did you get the replication video? On 4/11/2014 4:53 PM, Richard Whittaker wrote: Hi

Re: [qmailtoaster] MYSQL replication question.

2014-04-11 Thread Wim Godden
Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall,

Re: [qmailtoaster] MYSQL replication question.

2014-04-11 Thread richard
: [qmailtoaster] MYSQL replication question. Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm