Menu
▾
▴
perfparse-devel-int
|
From: Alex P. <ale...@ci...> - 2006-01-11 17:02:42
|
Hi, host_id host_name service_id service_description I sea that host_id and serviice_id are defined but not used into the other tables. How can I change the name form a host (host_name) when this is needed. After I dit change the hostname, the data is sended with the new key to Perfparse. When I now want to delet the old hostname I get: "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE perfdata_service.host_name = perfdata_host.host_name AND perfdata_host.is_deleted = 1" Because the charge the same services CONSTRAINT `perfdata_service_ibfk_1` FOREIGN KEY (`host_name`) REFERENCES `perfdata_host` (`host_name`), CONSTRAINT `perfdata_service_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `perfdata_host` (`host_id`), -- Alex Peeters -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.17/226 - Release Date: 10/01/2006 |
|
From: Alex P. <ale...@ci...> - 2006-03-10 21:39:43
|
root@chablis [/export/download/ASNMTAP-3.000.006]# /opt/asnmtap/perfparse/bin/perfparse-db-purge An error occured with the SQL: "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE perfdata_service.host_name = perfdata_host.host_name AND perfdata_host.is_deleted = 1" Failure Message: "Cannot delete or update a parent row: a foreign key constraint fails" root@chablis [/export/download/ASNMTAP-3.000.006]# /opt/asnmtap/perfparse/bin/perfparse-db-purge An error occured with the SQL: "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL" Failure Message: "Deadlock found when trying to get lock; Try restarting transaction" -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 10/03/2006 |
|
From: Florian G. <fl...@bi...> - 2006-03-14 10:26:55
|
Are these permanent errors? What can i do to reproduce the error? Flo Alex Peeters wrote: > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE > perfdata_service.host_name = perfdata_host.host_name AND > perfdata_host.is_deleted = 1" > > Failure Message: > > "Cannot delete or update a parent row: a foreign key constraint fails" > > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE > raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL" > > Failure Message: > > "Deadlock found when trying to get lock; Try restarting transaction" > |
|
From: Alex P. <ale...@ci...> - 2006-04-01 17:08:50
|
Where can i download the latestd version 0.106.1 please -----Original Message----- From: Alex Peeters [mailto:ale...@ci...] Sent: vrijdag 10 maart 2006 22:40 To: 'Alex Peeters'; 'per...@li...' Subject: RE: Perfparse Queation root@chablis [/export/download/ASNMTAP-3.000.006]# /opt/asnmtap/perfparse/bin/perfparse-db-purge An error occured with the SQL: "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE perfdata_service.host_name = perfdata_host.host_name AND perfdata_host.is_deleted = 1" Failure Message: "Cannot delete or update a parent row: a foreign key constraint fails" root@chablis [/export/download/ASNMTAP-3.000.006]# /opt/asnmtap/perfparse/bin/perfparse-db-purge An error occured with the SQL: "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL" Failure Message: "Deadlock found when trying to get lock; Try restarting transaction" -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/279 - Release Date: 10/03/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.4/299 - Release Date: 31/03/2006 |
|
From: Florian G. <fl...@bi...> - 2006-04-01 19:00:45
|
Hi, 0.106.1 is not yet out. It was planned long ago but due to increased work at work i did not manage to make a release. I planned to add a full featured php gui to 0.106.1 but for now i think i'll deliver a php gui with some features missing - but with some features that the C cgi's lack. You can download a cvs snapshot for now at http://wiki.perfparse.org/cvs_snapshots/ Flo P.S.: Any help is welcome! Alex Peeters schrieb: > Where can i download the latestd version 0.106.1 please > > -----Original Message----- > From: Alex Peeters [mailto:ale...@ci...] > Sent: vrijdag 10 maart 2006 22:40 > To: 'Alex Peeters'; 'per...@li...' > Subject: RE: Perfparse Queation > > > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE > perfdata_service.host_name = perfdata_host.host_name AND > perfdata_host.is_deleted = 1" > > Failure Message: > > "Cannot delete or update a parent row: a foreign key constraint fails" > > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' WHERE > raw_delete_policy_type = 'template' AND raw_delete_policy_name IS NULL" > > Failure Message: > > "Deadlock found when trying to get lock; Try restarting transaction" > |
|
From: Alex P. <ale...@ci...> - 2006-04-04 17:29:44
|
Copyright =A9 2004-2006. Program Version 0.106.1. Schema Version 0.19.=20 Where are mij translations when i compile with = --with-data-source=3Dasnmtap ??? ./configure --prefix=3D/opt/asnmtap-3.000.xxx/perfparse --with-imagedir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/img/ --with-cgidir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/cgi-bin --with-http_image_path=3D/asnmtap/img --with-data-source=3Dasnmtap -- Alex -----Original Message----- From: Florian Gleixner [mailto:fl...@bi...]=20 Sent: zaterdag 1 april 2006 21:00 To: Alex Peeters Cc: per...@li... Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation Hi, 0.106.1 is not yet out. It was planned long ago but due to increased=20 work at work i did not manage to make a release. I planned to add a full featured php gui to 0.106.1 but for now i think=20 i'll deliver a php gui with some features missing - but with some=20 features that the C cgi's lack. You can download a cvs snapshot for now at=20 http://wiki.perfparse.org/cvs_snapshots/ Flo P.S.: Any help is welcome! Alex Peeters schrieb: > Where can i download the latestd version 0.106.1 please >=20 > -----Original Message----- > From: Alex Peeters [mailto:ale...@ci...] > Sent: vrijdag 10 maart 2006 22:40 > To: 'Alex Peeters'; 'per...@li...' > Subject: RE: Perfparse Queation >=20 >=20 > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: >=20 > "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE=20 > perfdata_service.host_name =3D perfdata_host.host_name AND=20 > perfdata_host.is_deleted =3D 1" >=20 > Failure Message: >=20 > "Cannot delete or update a parent row: a foreign key constraint=20 > fails" >=20 > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: >=20 > "UPDATE perfdata_service SET raw_delete_policy_name =3D 'Raw = Default'=20 > WHERE raw_delete_policy_type =3D 'template' AND raw_delete_policy_name = > IS NULL" >=20 > Failure Message: >=20 > "Deadlock found when trying to get lock; Try restarting transaction" >=20 --=20 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.4/299 - Release Date: = 31/03/2006 =20 --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/300 - Release Date: 3/04/2006 =20 |
|
From: Florian G. <fl...@bi...> - 2006-04-04 20:13:37
|
Hi, can you be more specific? I did only apply your patch and commit. I had=20 no time to build another test environment besides nagios 1.3 and nagios=20 2.0 with different perfparse methods. You can get cvs access to commit your changes. Flo Alex Peeters schrieb: > Copyright =A9 2004-2006. Program Version 0.106.1. Schema Version 0.19.=20 >=20 >=20 > Where are mij translations when i compile with --with-data-source=3Dasn= mtap > ??? >=20 > ./configure --prefix=3D/opt/asnmtap-3.000.xxx/perfparse > --with-imagedir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/img/ > --with-cgidir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/cgi-bin > --with-http_image_path=3D/asnmtap/img --with-data-source=3Dasnmtap >=20 > -- Alex >=20 > -----Original Message----- > From: Florian Gleixner [mailto:fl...@bi...]=20 > Sent: zaterdag 1 april 2006 21:00 > To: Alex Peeters > Cc: per...@li... > Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation >=20 >=20 > Hi, >=20 > 0.106.1 is not yet out. It was planned long ago but due to increased=20 > work at work i did not manage to make a release. > I planned to add a full featured php gui to 0.106.1 but for now i think= =20 > i'll deliver a php gui with some features missing - but with some=20 > features that the C cgi's lack. >=20 > You can download a cvs snapshot for now at=20 > http://wiki.perfparse.org/cvs_snapshots/ >=20 > Flo >=20 > P.S.: Any help is welcome! >=20 > Alex Peeters schrieb: >> Where can i download the latestd version 0.106.1 please >> >> -----Original Message----- >> From: Alex Peeters [mailto:ale...@ci...] >> Sent: vrijdag 10 maart 2006 22:40 >> To: 'Alex Peeters'; 'per...@li...' >> Subject: RE: Perfparse Queation >> >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE=20 >> perfdata_service.host_name =3D perfdata_host.host_name AND=20 >> perfdata_host.is_deleted =3D 1" >> >> Failure Message: >> >> "Cannot delete or update a parent row: a foreign key constraint=20 >> fails" >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "UPDATE perfdata_service SET raw_delete_policy_name =3D 'Raw Default= '=20 >> WHERE raw_delete_policy_type =3D 'template' AND raw_delete_policy_name= =20 >> IS NULL" >> >> Failure Message: >> >> "Deadlock found when trying to get lock; Try restarting transaction" >> >=20 |
|
From: Alex P. <ale...@ci...> - 2006-04-05 16:02:44
|
Problem is: ./configure --prefix=3D/opt/asnmtap-3.000.xxx/perfparse --with-imagedir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/img/ --with-cgidir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/cgi-bin --with-http_image_path=3D/asnmtap/img --with-data-source=3Dasnmtap Then normally in the config.h should be: config.h /* Data Source is ASNMTAP */ #define USE_SOURCE_ASNMTAP 1 /* Data Source is Nagios */ /* #undef USE_SOURCE_NAGIOS */ Instead of now: config.h /* Data Source is ASNMTAP */ /* #undef USE_SOURCE_ASNMTAP */ /* Data Source is Nagios */ #define USE_SOURCE_NAGIOS 1 I mean, that when i after configure, mannualy change the config.h, = everthing is compiling OK with make and instaling with make install-strip -- Alex -----Original Message----- From: Florian Gleixner [mailto:fl...@bi...]=20 Sent: dinsdag 4 april 2006 22:13 To: Alex Peeters Cc: per...@li... Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation Hi, can you be more specific? I did only apply your patch and commit. I had=20 no time to build another test environment besides nagios 1.3 and nagios=20 2.0 with different perfparse methods. You can get cvs access to commit your changes. Flo Alex Peeters schrieb: > Copyright =A9 2004-2006. Program Version 0.106.1. Schema Version 0.19. >=20 >=20 > Where are mij translations when i compile with=20 > --with-data-source=3Dasnmtap ??? >=20 > ./configure --prefix=3D/opt/asnmtap-3.000.xxx/perfparse > --with-imagedir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/img/ > --with-cgidir=3D/opt/asnmtap-3.000.xxx/applications/htmlroot/cgi-bin > --with-http_image_path=3D/asnmtap/img --with-data-source=3Dasnmtap >=20 > -- Alex >=20 > -----Original Message----- > From: Florian Gleixner [mailto:fl...@bi...] > Sent: zaterdag 1 april 2006 21:00 > To: Alex Peeters > Cc: per...@li... > Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation >=20 >=20 > Hi, >=20 > 0.106.1 is not yet out. It was planned long ago but due to increased > work at work i did not manage to make a release. > I planned to add a full featured php gui to 0.106.1 but for now i = think=20 > i'll deliver a php gui with some features missing - but with some=20 > features that the C cgi's lack. >=20 > You can download a cvs snapshot for now at > http://wiki.perfparse.org/cvs_snapshots/ >=20 > Flo >=20 > P.S.: Any help is welcome! >=20 > Alex Peeters schrieb: >> Where can i download the latestd version 0.106.1 please >> >> -----Original Message----- >> From: Alex Peeters [mailto:ale...@ci...] >> Sent: vrijdag 10 maart 2006 22:40 >> To: 'Alex Peeters'; 'per...@li...' >> Subject: RE: Perfparse Queation >> >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE >> perfdata_service.host_name =3D perfdata_host.host_name AND=20 >> perfdata_host.is_deleted =3D 1" >> >> Failure Message: >> >> "Cannot delete or update a parent row: a foreign key constraint >> fails" >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "UPDATE perfdata_service SET raw_delete_policy_name =3D 'Raw = Default' >> WHERE raw_delete_policy_type =3D 'template' AND = raw_delete_policy_name=20 >> IS NULL" >> >> Failure Message: >> >> "Deadlock found when trying to get lock; Try restarting=20 >> transaction" >> >=20 --=20 No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/302 - Release Date: 5/04/2006 =20 --=20 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/302 - Release Date: 5/04/2006 =20 |
|
From: Alex P. <ale...@ci...> - 2006-04-04 18:16:43
|
0.106.1 is not yet out. It was planned long ago but due to increased work at work i did not manage to make a release. I planned to add a full featured php gui to 0.106.1 but for now i think i'll deliver a php gui with some features missing - but with some features that the C cgi's lack. ? How is the status regarding the card shopping feature for the stats ? ? Will the php interface as fast as the old one ? -----Original Message----- From: Florian Gleixner [mailto:fl...@bi...] Sent: zaterdag 1 april 2006 21:00 To: Alex Peeters Cc: per...@li... Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation Hi, 0.106.1 is not yet out. It was planned long ago but due to increased work at work i did not manage to make a release. I planned to add a full featured php gui to 0.106.1 but for now i think i'll deliver a php gui with some features missing - but with some features that the C cgi's lack. You can download a cvs snapshot for now at http://wiki.perfparse.org/cvs_snapshots/ Flo P.S.: Any help is welcome! Alex Peeters schrieb: > Where can i download the latestd version 0.106.1 please > > -----Original Message----- > From: Alex Peeters [mailto:ale...@ci...] > Sent: vrijdag 10 maart 2006 22:40 > To: 'Alex Peeters'; 'per...@li...' > Subject: RE: Perfparse Queation > > > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE > perfdata_service.host_name = perfdata_host.host_name AND > perfdata_host.is_deleted = 1" > > Failure Message: > > "Cannot delete or update a parent row: a foreign key constraint > fails" > > root@chablis [/export/download/ASNMTAP-3.000.006]# > /opt/asnmtap/perfparse/bin/perfparse-db-purge > An error occured with the SQL: > > "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' > WHERE raw_delete_policy_type = 'template' AND raw_delete_policy_name > IS NULL" > > Failure Message: > > "Deadlock found when trying to get lock; Try restarting transaction" > -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.4/299 - Release Date: 31/03/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/300 - Release Date: 3/04/2006 |
|
From: Florian G. <fl...@bi...> - 2006-04-04 20:31:12
|
Alex Peeters schrieb: > 0.106.1 is not yet out. It was planned long ago but due to increased > work at work i did not manage to make a release. > I planned to add a full featured php gui to 0.106.1 but for now i think > i'll deliver a php gui with some features missing - but with some > features that the C cgi's lack. > > > ? How is the status regarding the card shopping feature for the stats ? > It is now possible with the php interface to select multiple hosts and within this selection multiple metrics. At the moment with this selection you will get one web page with multiple graphs, each one can be configured individually. The goal is to add the possibility to draw multiple metrics in one graph too. Design is ugly at the moment. I uploaded a screenshot: http://wiki.perfparse.org/tiki-browse_image.php?offset=0&sort_mode=created_desc&desp=0&galleryId=1&imageId=2 > ? Will the php interface as fast as the old one ? > Almost. The graph generating part will remain C code while the web page related code will be php due to faster and easier development. > > -----Original Message----- > From: Florian Gleixner [mailto:fl...@bi...] > Sent: zaterdag 1 april 2006 21:00 > To: Alex Peeters > Cc: per...@li... > Subject: Re: [Perfparse-devel-int] RE: Perfparse Queation > > > Hi, > > 0.106.1 is not yet out. It was planned long ago but due to increased > work at work i did not manage to make a release. > I planned to add a full featured php gui to 0.106.1 but for now i think > i'll deliver a php gui with some features missing - but with some > features that the C cgi's lack. > > You can download a cvs snapshot for now at > http://wiki.perfparse.org/cvs_snapshots/ > > Flo > > P.S.: Any help is welcome! > > Alex Peeters schrieb: >> Where can i download the latestd version 0.106.1 please >> >> -----Original Message----- >> From: Alex Peeters [mailto:ale...@ci...] >> Sent: vrijdag 10 maart 2006 22:40 >> To: 'Alex Peeters'; 'per...@li...' >> Subject: RE: Perfparse Queation >> >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE >> perfdata_service.host_name = perfdata_host.host_name AND >> perfdata_host.is_deleted = 1" >> >> Failure Message: >> >> "Cannot delete or update a parent row: a foreign key constraint >> fails" >> >> root@chablis [/export/download/ASNMTAP-3.000.006]# >> /opt/asnmtap/perfparse/bin/perfparse-db-purge >> An error occured with the SQL: >> >> "UPDATE perfdata_service SET raw_delete_policy_name = 'Raw Default' >> WHERE raw_delete_policy_type = 'template' AND raw_delete_policy_name >> IS NULL" >> >> Failure Message: >> >> "Deadlock found when trying to get lock; Try restarting transaction" >> > |
Thanks for helping keep SourceForge clean.
X