Re: [collectd] [5.1] Multiple mysql instances?
Wiadomość napisana przez Sebastian Harl w dniu 18 mar 2013, o godz. 21:29: Hi, On Mon, Mar 18, 2013 at 11:12:24AM +0100, Fabien Wernli wrote: On Mon, Mar 18, 2013 at 09:37:22AM +0100, Jacek Osiecki wrote: LoadPlugin mysql Plugin mysql Database sqlone User backup Password Host 192.168.0.21 Database mysql #Socket /var/lib/mysql/sc-sqlcrit/mysql.sock /Database 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. This issue should have been fixed in 5.1.1. The name of the Database definition is now used when registering the callback. The above configuration is perfectly fine in that case. Does that mean, that I need to upgrade to 5.1.1 in order to have multiple mysql instances handled (now I have 5.1.0)? I'm really confused... Greetings, -- Jacek ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd
[collectd] Fwd: [5.1] Multiple mysql instances?
Hello, I'm trying to set up again collectd to handle more than one mysql instance per host. The problem is, that there is no information on how to do this - anywhere... When I start collectd, I get the warning: The read function mysql-mysql is already registered. Check for duplicate LoadPlugin lines in your configuration! However, the only place where I handle mysql is /etc/collectd.d/mysql.conf: LoadPlugin mysql Plugin mysql Database sqlone User backup Password Host 192.168.0.21 Database mysql #Socket /var/lib/mysql/sc-sqlcrit/mysql.sock /Database Database sqltwo User backup2 Password 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? Greetings, -- Jacek Osiecki josie...@silvercube.pl Silvercube s.c. ul. Makuszynskiego 4 31-752 Kraków +48 (12) 684 21 00 ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd
Re: [collectd] [5.1] Multiple mysql instances?
Hi Jacek, On Mon, Mar 18, 2013 at 09:37:22AM +0100, Jacek Osiecki wrote: LoadPlugin mysql Plugin mysql Database sqlone User backup Password Host 192.168.0.21 Database mysql /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. Unfortunately, that didn't help. Collectd still is monitoring only one mysql instance, the only difference is that now in syslog I can see: Mar 18 13:53:32 delta collectd[15436]: mysql plugin: Successfully connected to database none at server 192.168.0.21 via TCP/IP (server version: 5.5.27-log, protocol version: 10) Any other ideas? I can't believe that there is no possibility to monitor more than one mysql per server... Greetings, -- Jacek Osiecki ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd
[collectd] Apache graphs in 5.0.2 still don't work
Hello again, I have been trying to set up apache graphs and still - they don't work. All I get are broken images and message in apache log: collection.cgi: RRDs::graph: No DS called 'count' in '/var/lib/collectd/bravo.silvercube.pl/apache-apache80/apache_scoreboard-idle_cleanup.rrd' at /usr/share/collectd/cgi-bin/collection.cgi line 787. In documentation there is only info in changelog for 5.0.0, saying: * apache plugin: Backwards compatibility code has been removed. I have just downloaded collectd-5.0.3.tar.bz2 from collectd.org, and in contrib/collection.cgi there is still the same code referring to 'count': apache_bytes = ['DEF:min_raw={file}:count:MIN', apache_connections = ['DEF:min={file}:count:MIN', apache_idle_workers = ['DEF:min={file}:count:MIN', ...etc. Is there something wrong with collection.cgi, or is collectd apache plugin broken? Greetings, -- Jacek ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd
Re: [collectd] Apache graphs in 5.0.2 still don't work
On Fri, 24 Feb 2012 16:27:24 +0100, Bostjan Skufca wrote: What if you remove them and restart collectd to let it recreate it? That's not the case - on this server the collectd was installed from scratch in 5.0.2 version, so RRD's have not been touched by previous collectd's versions. Greetings, -- Jacek b. On 24 February 2012 12:13, Jacek Osiecki wrote: Hello again, I have been trying to set up apache graphs and still - they don't work. All I get are broken images and message in apache log: collection.cgi: RRDs::graph: No DS called 'count' in '/var/lib/collectd/bravo.silvercube.pl/apache-apache80/apache_scoreboard-idle_cleanup.rrd [1]' at /usr/share/collectd/cgi-bin/collection.cgi line 787. In documentation there is only info in changelog for 5.0.0, saying: * apache plugin: Backwards compatibility code has been removed. I have just downloaded collectd-5.0.3.tar.bz2 from collectd.org [2], and in contrib/collection.cgi there is still the same code referring to 'count': apache_bytes = ['DEF:min_raw={file}:count:MIN', apache_connections = ['DEF:min={file}:count:MIN', apache_idle_workers = ['DEF:min={file}:count:MIN', ...etc. Is there something wrong with collection.cgi, or is collectd apache plugin broken? Greetings, -- Jacek ___ collectd mailing list collectd@verplant.org [3] http://mailman.verplant.org/listinfo/collectd [4] Links: -- [1] http://bravo.silvercube.pl/apache-apache80/apache_scoreboard-idle_cleanup.rrd [2] http://collectd.org [3] mailto:collectd@verplant.org [4] http://mailman.verplant.org/listinfo/collectd [5] mailto:vj...@silvercube.pl ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd
[collectd] Apache graphs don't render in collectd 5.0.2
Hi, I have been checking the possibilities of collectd lately. Finally found the tool that does what I need... :) However, when I was discovering various collectd plugins and versions (depending on mysql and apache versions on my servers), I found out that there is a problem with apache plugin on servers where I use version 5.0.2. Simply, the apache graphs do not show up. Instead, when I use collectd-collection CGI, I see in the apache logs: [Fri Feb 10 01:11:51 2012] [error] [client 89.79.179.92] [Fri Feb 10 01:11:51 2012] collection.cgi: RRDs::graph: No DS called 'count' in '/var/lib/collectd/http/apache-apache80/apache_scoreboard-dnslookup.rrd' at /usr/share/collectd/cgi-bin/collection.cgi line 787., referer: (...) and my apache.conf for collectd is as simple as possible: Plugin apache Instance apache80 URL http://127.0.75.1/server-status?auto; /Instance /Plugin The address is the address of local vserver. On the other hosts, where I use version 4.9 - everything works great. Any suggestions? I have tried some other interfaces like cgp - no errors (probably hidden) but still graphs don't show up :( I tried collectd-web, but I'm still getting some problems with launching it. Best regards, -- Jacek Osiecki Silvercube s.c. ul. Makuszyńskiego 4, 31-752 Kraków tel/fax: +48 (12) 684 21 00 ___ collectd mailing list collectd@verplant.org http://mailman.verplant.org/listinfo/collectd