Hi Jacek, On Mon, Mar 18, 2013 at 09:37:22AM +0100, Jacek Osiecki wrote: > LoadPlugin mysql > <Plugin mysql> > <Database "sqlone"> > User "backup" > Password "xxxx" > Host "192.168.0.21" > Database "mysql" > #Socket "/var/lib/mysql/sc-sqlcrit/mysql.sock" > </Database> > <Database "sqltwo"> > User "backup2" > Password "yyyy" > Database "mysql" > Host "192.168.0.22" > #Socket "/var/lib/mysql/sc-sqlmain/mysql.sock" > </Database> > </Plugin> > > I tried many combinations: using "Host" in first database and "Socket" in > second one, using > different users - nothing helped. Always only the first database is handled. > > Am I doing something wrong, or is collectd simply unable to handle two (or > more) mysql servers?
I think the 'Database' directive *in* the block overrides the name in the 'Database' *definition*. This means that in your example, `sqlone` and `sqltwo` are both being overridden by `mysql`, thus yielding the error message. I remember banging my head on a hard surface too when trying to achieve the same goal. If I were you, I'd simply drop the `Database "mysql"` from your example, and it should work as-is. _______________________________________________ collectd mailing list [email protected] http://mailman.verplant.org/listinfo/collectd
