[Pacemaker] mysql/drbd on wheezy active/passive setup issues

[christopher barry]

OK, so I think it's all good now!

I ran crm_resource --resource foo --cleanup and that apparently jiggled
the handle enough to make it all work.



On Thu, 2013-03-14 at 12:21 -0400, christopher barry wrote:
> Hi,
> 
> I get this when I run ocf-tester:
> 
> ocf-tester -n p_mysql /usr/lib/ocf/resource.d/heartbeat/mysql
> Beginning tests for /usr/lib/ocf/resource.d/heartbeat/mysql...
> /usr/sbin/ocf-tester: 214: /usr/sbin/ocf-tester: xmllint: not found
> * rc=127: Your agent produces meta-data which does not conform to
> ra-api-1.dtd
> * rc=1: Demoting a start resource should not fail
> * rc=1: Promote failed
> * rc=1: Demote failed
> mysql[6876]: ERROR: ERROR 1045 (28000): Access denied for user
> 'root'@'localhost' (using password: NO)
> mysql[6876]: ERROR: Failed to set read-only
> Aborting tests
> 
> I'm not even sure I'm running that tester correctly.
> 
> Q: why does the agent get shipped if the metadata is incorrect? Or is
> that just a warning?
> 
> Oddly, I can login as root to mysql without issue, both with and without
> a password, so that error appears to be a red herring.
> 
> I had a look at the resource script:
> /usr/lib/ocf/resource.d/heartbeat/mysql
> 
> I noticed it had defaults if nothing was set. I changed the socket
> location in the default to match debian's default, removed the instance
> attributes from my CIB so it would use defaults, and I get the same
> outcome.
> 
> How can I get actual error output so I can debug this? I'm sure the
> issue is trivial, but I just can't see what the issue is! There has to
> be a better way to troubleshoot/debug this kind of thing.
> 
> The info in the corosync.log is just not very helpful for me.
> 
> Thanks for any insight you can give.
> 
> Regards,
> Christopher
> 
> 
> On Wed, 2013-03-13 at 18:13 -0400, christopher barry wrote:
> > Thanks, I'll have a go with that.
> > 
> > -C
> > 
> > On Wed, 2013-03-13 at 22:58 +0100, emmanuel segura wrote:
> > > Hello
> > > 
> > > Use ocf-tester to debug your resource
> > > 
> > > 2013/3/13 christopher barry <cbarry at rjmetrics.com>
> > >         Greetings all,
> > >         
> > >         I'm almost there, and figure I just have something small out
> > >         of place. Wondering if you can view my setup here:
> > >         
> > >         https://zerobin.permutation.net/?d8664af27a7de3be#Bh3fBAupeEw3RhBWOlvDomyPkoOzvD5ajTCk6+a1MW0=
> > >         
> > >         and let me know what you think.
> > >         
> > >         If you need more data to understand what could be wrong,
> > >         please let me know.
> > >         
> > >         Thanks,
> > >         Christopher
> > >         
> > >         
> > >         
> > >         _______________________________________________
> > >         Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > >         http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> > >         
> > >         Project Home: http://www.clusterlabs.org
> > >         Getting started:
> > >         http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > >         Bugs: http://bugs.clusterlabs.org
> > >         
> > > 
> > > 
> > > 
> > > -- 
> > > esta es mi vida e me la vivo hasta que dios quiera 
> > > _______________________________________________
> > > Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> > > http://oss.clusterlabs.org/mailman/listinfo/pacemaker
> > > 
> > > Project Home: http://www.clusterlabs.org
> > > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> > > Bugs: http://bugs.clusterlabs.org
> > 
>