Thread: RE: [Perfparse-users] Errors after install running perfparse

Status: Beta

Brought to you by: benclewett, brad9, g_force, redflo

perfparse-users

RE: [Perfparse-users] Errors after install running perfparse

From: Cook, G. <GW...@ma...> - 2004-08-05 13:32:56

What version of PerfParse are you running?

Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)=20

-----Original Message-----
From: per...@li...
[mailto:per...@li...] On Behalf Of Barry
Weeks
Sent: Thursday, August 05, 2004 6:54 AM
To: per...@li...
Subject: [Perfparse-users] Errors after install running perfparse



I have compiled and installed Nagios and perfparse as per docs.

I have a MySQL database running with all tables created.

The host and service perf logs are being written to correctly.

=20

When I try to run perfparse -r I get

=20

[root@smatest bin]# ./perfparse -r

Database version is not correct

Consider upgrading with perfparse-db-tool -update

=20

When I try to run perfparse-db-tool -update I get

=20

"START TRANSACTION" failed:

You have an error in your SQL syntax near 'START TRANSACTION' at line 1

=20

Please help

=20

Barry

Visit our website at www.rm.com=20

This message is confidential. You should not copy it or disclose its
contents to anyone. You may use and apply the information only for the
intended purpose. Internet communications are not secure and therefore
RM does not accept legal responsibility for the contents of this
message. Any views or opinions presented are only those of the author
and not those of RM. If this email has come to you in error please
delete it and any attachments. Please note that RM may intercept
incoming and outgoing e-mail communications.=20

This email has been scanned for viruses by Trend ScanMail.

RE: [Perfparse-users] Errors after install running perfparse

From: Cook, G. <GW...@ma...> - 2004-08-05 14:23:45

In the future, please respond to all, or just to the list. I don't have
all the answers all of the time, so others still might be able to
assist if you stay on list. Also, this will keep the threads archived,
so that others may benefit from this information in the future. Also,
it's a good idea to not use HTML email when sending to mailing lists,
as some users don't have the ability to view HTML email, or just ignore
HTML messages. If you send a reply in a text message, as opposed to
HTML email, it will probably be easier to respond to questions inline.=20

Barry Weeks wrote:
> Hi Gary
>=20
> Thanks for quick response
>=20
> [root@smatest bin]# ./perfparse -v
> Version 0.99.08

OK, 0.99.08 is the latest stable version, so that's all good.

A few more questions:

Did you upgrade from a previous version of PP, or is this a brand new
installation? Either way, did you copy perfparse.cfg.example to
perfparse.cfg? =20

Is your MySQL >=3D v.4.0.11? See
http://perfparse.sourceforge.net/docs.php#compilingpp and
http://perfparse.sourceforge.net/faq.php#installing for more
information.  =20

How did you create your MySQL tables? Instructions for this are located
here: http://perfparse.sourceforge.net/docs.php#compilingpp

Are you using the default db
name/username/password(nagios/nagios/nagios)? If not, you might need to
make some adjustments
to the perfparse.cfg file. =20

-g

> ----- Original Message -----
> From: Cook, Garry
> To: Barry Weeks ; per...@li...
> Sent: Thursday, August 05, 2004 2:32 PM
> Subject: RE: [Perfparse-users] Errors after install running perfparse
>=20
>=20
> What version of PerfParse are you running?
> Garry W. Cook, CCNA
> Network Infrastructure Manager
> MACTEC, Inc. - http://www.mactec.com/
> 303.308.6228 (Office) - 720.220.1862 (Mobile)
> -----Original Message-----
> From: per...@li...
> [mailto:per...@li...] On Behalf Of
> Barry Weeks =20
> Sent: Thursday, August 05, 2004 6:54 AM
> To: per...@li...
> Subject: [Perfparse-users] Errors after install running perfparse
>=20
>=20
> I have compiled and installed Nagios and perfparse as per docs.
> I have a MySQL database running with all tables created.
> The host and service perf logs are being written to correctly.
>=20
> When I try to run perfparse -r I get
>=20
> [root@smatest bin]# ./perfparse -r
> Database version is not correct
> Consider upgrading with perfparse-db-tool -update
>=20
> When I try to run perfparse-db-tool -update I get
>=20
> "START TRANSACTION" failed:
> You have an error in your SQL syntax near 'START TRANSACTION' at line
> 1=20
>=20
> Please help
>=20
> Barry
> Visit our website at www.rm.com

Re: [Perfparse-users] Errors after install running perfparse

From: Barry W. <ba...@if...> - 2004-08-05 14:29:39

Appologies for not replying to all and not using plain text.

Any have any ideas to my query?

Thanks in advance

Barry
----- Original Message ----- 
From: "Cook, Garry" <GW...@ma...>
To: "Barry Weeks" <ba...@if...>; <per...@li...>
Sent: Thursday, August 05, 2004 3:23 PM
Subject: RE: [Perfparse-users] Errors after install running perfparse


> In the future, please respond to all, or just to the list. I don't have
> all the answers all of the time, so others still might be able to
> assist if you stay on list. Also, this will keep the threads archived,
> so that others may benefit from this information in the future. Also,
> it's a good idea to not use HTML email when sending to mailing lists,
> as some users don't have the ability to view HTML email, or just ignore
> HTML messages. If you send a reply in a text message, as opposed to
> HTML email, it will probably be easier to respond to questions inline. 
> 
> Barry Weeks wrote:
> > Hi Gary
> > 
> > Thanks for quick response
> > 
> > [root@smatest bin]# ./perfparse -v
> > Version 0.99.08
> 
> OK, 0.99.08 is the latest stable version, so that's all good.
> 
> A few more questions:
> 
> Did you upgrade from a previous version of PP, or is this a brand new
> installation? Either way, did you copy perfparse.cfg.example to
> perfparse.cfg?  
> 
> Is your MySQL >= v.4.0.11? See
> http://perfparse.sourceforge.net/docs.php#compilingpp and
> http://perfparse.sourceforge.net/faq.php#installing for more
> information.   
> 
> How did you create your MySQL tables? Instructions for this are located
> here: http://perfparse.sourceforge.net/docs.php#compilingpp
> 
> Are you using the default db
> name/username/password(nagios/nagios/nagios)? If not, you might need to
> make some adjustments
> to the perfparse.cfg file.  
> 
> -g
> 
> > ----- Original Message -----
> > From: Cook, Garry
> > To: Barry Weeks ; per...@li...
> > Sent: Thursday, August 05, 2004 2:32 PM
> > Subject: RE: [Perfparse-users] Errors after install running perfparse
> > 
> > 
> > What version of PerfParse are you running?
> > Garry W. Cook, CCNA
> > Network Infrastructure Manager
> > MACTEC, Inc. - http://www.mactec.com/
> > 303.308.6228 (Office) - 720.220.1862 (Mobile)
> > -----Original Message-----
> > From: per...@li...
> > [mailto:per...@li...] On Behalf Of
> > Barry Weeks  
> > Sent: Thursday, August 05, 2004 6:54 AM
> > To: per...@li...
> > Subject: [Perfparse-users] Errors after install running perfparse
> > 
> > 
> > I have compiled and installed Nagios and perfparse as per docs.
> > I have a MySQL database running with all tables created.
> > The host and service perf logs are being written to correctly.
> > 
> > When I try to run perfparse -r I get
> > 
> > [root@smatest bin]# ./perfparse -r
> > Database version is not correct
> > Consider upgrading with perfparse-db-tool -update
> > 
> > When I try to run perfparse-db-tool -update I get
> > 
> > "START TRANSACTION" failed:
> > You have an error in your SQL syntax near 'START TRANSACTION' at line
> > 1 
> > 
> > Please help
> > 
> > Barry
> > Visit our website at www.rm.com

RE: [Perfparse-users] Errors after install running perfparse

From: Cook, G. <GW...@ma...> - 2004-08-05 14:35:50

Barry Weeks wrote:
> Appologies for not replying to all and not using plain text.

No apology necessary. The suggestion was meant to help you get a greater
response and possibly more help with your issue.


> Any have any ideas to my query?

Sure. I had some ideas. I posted a slew of questions in my last email.
Please re-read and respond when you get a chance.


> Thanks in advance

You're welcome.

=20
> Barry
> ----- Original Message -----
> From: "Cook, Garry" <GW...@ma...>
> To: "Barry Weeks" <ba...@if...>;
> <per...@li...>
> Sent: Thursday, August 05, 2004 3:23 PM
> Subject: RE: [Perfparse-users] Errors after install running perfparse
>=20
>=20
>> In the future, please respond to all, or just to the list. I don't
>> have all the answers all of the time, so others still might be able
>> to assist if you stay on list. Also, this will keep the threads
>> archived, so that others may benefit from this information in the
>> future. Also, it's a good idea to not use HTML email when sending to
>> mailing lists, as some users don't have the ability to view HTML
>> email, or just ignore HTML messages. If you send a reply in a text
>> message, as opposed to HTML email, it will probably be easier to
>> respond to questions inline.=20
>>=20
>> Barry Weeks wrote:
>>> Hi Gary
>>>=20
>>> Thanks for quick response
>>>=20
>>> [root@smatest bin]# ./perfparse -v
>>> Version 0.99.08
>>=20
>> OK, 0.99.08 is the latest stable version, so that's all good.
>>=20
>> A few more questions:
>>=20
>> Did you upgrade from a previous version of PP, or is this a brand new
>> installation? Either way, did you copy perfparse.cfg.example to
>> perfparse.cfg?=20
>>=20
>> Is your MySQL >=3D v.4.0.11? See
>> http://perfparse.sourceforge.net/docs.php#compilingpp and
>> http://perfparse.sourceforge.net/faq.php#installing for more
>> information.=20
>>=20
>> How did you create your MySQL tables? Instructions for this are
>> located here: http://perfparse.sourceforge.net/docs.php#compilingpp
>>=20
>> Are you using the default db
>> name/username/password(nagios/nagios/nagios)? If not, you might need
>> to make some adjustments to the perfparse.cfg file.
>>=20
>> -g
>>=20
>>> ----- Original Message -----
>>> From: Cook, Garry
>>> To: Barry Weeks ; per...@li...
>>> Sent: Thursday, August 05, 2004 2:32 PM
>>> Subject: RE: [Perfparse-users] Errors after install running
>>> perfparse=20
>>>=20
>>>=20
>>> What version of PerfParse are you running?
>>> Garry W. Cook, CCNA
>>> Network Infrastructure Manager
>>> MACTEC, Inc. - http://www.mactec.com/
>>> 303.308.6228 (Office) - 720.220.1862 (Mobile)
>>> -----Original Message-----
>>> From: per...@li...
>>> [mailto:per...@li...] On Behalf Of
>>> Barry Weeks Sent: Thursday, August 05, 2004 6:54 AM
>>> To: per...@li...
>>> Subject: [Perfparse-users] Errors after install running perfparse
>>>=20
>>>=20
>>> I have compiled and installed Nagios and perfparse as per docs.
>>> I have a MySQL database running with all tables created.
>>> The host and service perf logs are being written to correctly.
>>>=20
>>> When I try to run perfparse -r I get
>>>=20
>>> [root@smatest bin]# ./perfparse -r
>>> Database version is not correct
>>> Consider upgrading with perfparse-db-tool -update
>>>=20
>>> When I try to run perfparse-db-tool -update I get
>>>=20
>>> "START TRANSACTION" failed:
>>> You have an error in your SQL syntax near 'START TRANSACTION' at
>>> line 1=20
>>>=20
>>> Please help
>>>=20
>>> Barry
>>> Visit our website at www.rm.com



Garry W. Cook, CCNA
Network Infrastructure Manager
MACTEC, Inc. - http://www.mactec.com/
303.308.6228 (Office) - 720.220.1862 (Mobile)