How to configure net-snmp for mysql logging to log received traps

[Mallikharjun Lanke]

Hi

How to configure net-snmp for mysql logging to log received traps

my snmptrapd.conf

###########################
# maximum number of traps to queue before forced flush
# set to 1 to immediately write to the database
sqlMaxQueue 140

# seconds between periodic queue flushes
sqlSaveInterval 9

i loaded database schema from <dist/schema-snmptrapd.sql

can you guide me through this setup.

thanks
Best Regards
Mallik

[Stuart Henderson]

This is a multipart message in MIME format.
--===============2177140943630031801==
Content-Type: multipart/alternative;
boundary="=_alternative 0032E36B48257EAF_="
This is a multipart message in MIME format.
--=_alternative 0032E36B48257EAF_=
Content-Type: text/plain; charset="US-ASCII"
Hi
How to configure net-snmp for mysql logging to log received traps

Did you follow http://www.net-snmp.org/wiki/index.php/Snmptrapd to
create a ~/.my.cnf file?



------------------------------------------------------------------------------

[Ricardo Resina]

Hello Mallikharjun.



I've tried it yet, and it doesn't work if you don't have compiled net-snmp
tools with the --my-sql-support option. The precompiled 5.5 version that
I'm using so far, is not compiled with this option, so I can't get the traps
in a mysql database even if I configure it. My question is if is there any
precompiled version of net-snmp tools compiled to using mysql to store the
traps, because I'm not able to compile any version in windows systems.



Thank you for your response.







Ricardo Resina
INGENIERO PREVENTA

[+34] 916 366 058 [+34] 620 313 467

<mailto:***@tuyu.es> ***@tuyu.es



<http://www.tuyu.es/>



De: Mallikharjun Lanke [mailto:***@sg.panasonic.com]
Enviado el: viernes, 28 de agosto de 2015 11:16
Para: net-snmp-***@lists.sourceforge.net
Asunto: How to configure net-snmp for mysql logging to log received traps



Hi

How to configure net-snmp for mysql logging to log received traps

my snmptrapd.conf

###########################
# maximum number of traps to queue before forced flush
# set to 1 to immediately write to the database
sqlMaxQueue 140

# seconds between periodic queue flushes
sqlSaveInterval 9

i loaded database schema from <dist/schema-snmptrapd.sql

can you guide me through this setup.

thanks
Best Regards
Mallik

[Ricardo Resina]

Hello Stuart.

I’ve tried it yet, and it doesn’t work if you don’t have compiled net-snmp
tools with the --my-sql-support option. The precompiled 5.5 version that
I’m using so far, is not compiled with this option, so I can’t get the traps
in a mysql database even if I configure it. My question is if is there any
precompiled version of net-snmp tools compiled to using mysql to store the
traps, because I’m not able to compile any version in windows systems.

Thank you for your response.


Ricardo Resina
INGENIERO PREVENTA
[+34] 916 366 058 [+34] 620 313 467
***@tuyu.es




-----Mensaje original-----
De: Stuart Henderson [mailto:***@spacehopper.org]
Enviado el: miércoles, 2 de septiembre de 2015 0:28
Para: net-snmp-***@lists.sourceforge.net
Asunto: Re: How to configure net-snmp for mysql logging to log received
traps

This is a multipart message in MIME format.
--===============2177140943630031801==
Content-Type: multipart/alternative;
boundary="=_alternative 0032E36B48257EAF_="
This is a multipart message in MIME format.
--=_alternative 0032E36B48257EAF_=
Content-Type: text/plain; charset="US-ASCII"
Hi
How to configure net-snmp for mysql logging to log received traps

Did you follow http://www.net-snmp.org/wiki/index.php/Snmptrapd to create a
~/.my.cnf file?



----------------------------------------------------------------------------
--
_______________________________________________
Net-snmp-users mailing list
Net-snmp-***@lists.sourceforge.net
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users


------------------------------------------------------------------------------

[Ricardo Resina]

Hello again.

Here is the "warning" that gives the server when I try to configure the
sqlMaxQueue and sqlSaveInterval parameters:

C:\Users\Administrador>snmptrapd -Lo
C:/usr/etc/snmp/snmptrapd.conf: line 2: Warning: Unknown token: sqlMaxQueue.
C:/usr/etc/snmp/snmptrapd.conf: line 3: Warning: Unknown token:
sqlSaveInterval.
NET-SNMP version 5.5

Thank you so much.

Ricardo Resina
INGENIERO PREVENTA
[+34] 916 366 058 [+34] 620 313 467
***@tuyu.es



-----Mensaje original-----
De: Ricardo Resina [mailto:***@tuyu.es]
Enviado el: martes, 8 de septiembre de 2015 11:19
Para: 'Stuart Henderson' <***@spacehopper.org>;
'net-snmp-***@lists.sourceforge.net'
<net-snmp-***@lists.sourceforge.net>
Asunto: RE: How to configure net-snmp for mysql logging to log received
traps

Hello Stuart.

I’ve tried it yet, and it doesn’t work if you don’t have compiled net-snmp
tools with the --my-sql-support option. The precompiled 5.5 version that
I’m using so far, is not compiled with this option, so I can’t get the traps
in a mysql database even if I configure it. My question is if is there any
precompiled version of net-snmp tools compiled to using mysql to store the
traps, because I’m not able to compile any version in windows systems.

Thank you for your response.


Ricardo Resina
INGENIERO PREVENTA
[+34] 916 366 058 [+34] 620 313 467
***@tuyu.es




-----Mensaje original-----
De: Stuart Henderson [mailto:***@spacehopper.org]
Enviado el: miércoles, 2 de septiembre de 2015 0:28
Para: net-snmp-***@lists.sourceforge.net
Asunto: Re: How to configure net-snmp for mysql logging to log received
traps

This is a multipart message in MIME format.
--===============2177140943630031801==
Content-Type: multipart/alternative;
boundary="=_alternative 0032E36B48257EAF_="
This is a multipart message in MIME format.
--=_alternative 0032E36B48257EAF_=
Content-Type: text/plain; charset="US-ASCII"
Hi
How to configure net-snmp for mysql logging to log received traps

Did you follow http://www.net-snmp.org/wiki/index.php/Snmptrapd to create a
~/.my.cnf file?



----------------------------------------------------------------------------
--
_______________________________________________
Net-snmp-users mailing list
Net-snmp-***@lists.sourceforge.net
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/listinfo/net-snmp-users


------------------------------------------------------------------------------

[Ricardo Resina]

Hello again.



Here is the "warning" that gives the server when I try to configure the
sqlMaxQueue and sqlSaveInterval parameters:



C:\Users\Administrador>snmptrapd -Lo

C:/usr/etc/snmp/snmptrapd.conf: line 2: Warning: Unknown token: sqlMaxQueue.

C:/usr/etc/snmp/snmptrapd.conf: line 3: Warning: Unknown token:
sqlSaveInterval.

NET-SNMP version 5.5



Thank you so much.





Ricardo Resina
INGENIERO PREVENTA

[+34] 916 366 058 [+34] 620 313 467

<mailto:***@tuyu.es> ***@tuyu.es



<http://www.tuyu.es/>



De: Ricardo Resina [mailto:***@tuyu.es]
Enviado el: martes, 8 de septiembre de 2015 11:16
Para: 'Mallikharjun Lanke' <***@sg.panasonic.com>;
'net-snmp-***@lists.sourceforge.net'
<net-snmp-***@lists.sourceforge.net>
Asunto: RE: How to configure net-snmp for mysql logging to log received
traps



Hello Mallikharjun.



I've tried it yet, and it doesn't work if you don't have compiled net-snmp
tools with the --my-sql-support option. The precompiled 5.5 version that
I'm using so far, is not compiled with this option, so I can't get the traps
in a mysql database even if I configure it. My question is if is there any
precompiled version of net-snmp tools compiled to using mysql to store the
traps, because I'm not able to compile any version in windows systems.



Thank you for your response.







Ricardo Resina
INGENIERO PREVENTA

[+34] 916 366 058 [+34] 620 313 467

<mailto:***@tuyu.es> ***@tuyu.es



<http://www.tuyu.es/>



De: Mallikharjun Lanke [mailto:***@sg.panasonic.com]
Enviado el: viernes, 28 de agosto de 2015 11:16
Para: net-snmp-***@lists.sourceforge.net
<mailto:net-snmp-***@lists.sourceforge.net>
Asunto: How to configure net-snmp for mysql logging to log received traps



Hi

How to configure net-snmp for mysql logging to log received traps

my snmptrapd.conf

###########################
# maximum number of traps to queue before forced flush
# set to 1 to immediately write to the database
sqlMaxQueue 140

# seconds between periodic queue flushes
sqlSaveInterval 9

i loaded database schema from <dist/schema-snmptrapd.sql

can you guide me through this setup.

thanks
Best Regards
Mallik