[Date Prev]   [Date Next] [Thread Prev]   [Thread Next] [Date Index]   [Thread Index]


     [snips-users] problems with sqlmon

Hi there,

i am having some issues with the sqlmon script and config files for
monitorring some mysql databases, i have already installed DBI-1.19 and
DBD-mysql-2.1004 to the system doing the monitorring, and i have the
following configured in my sqlmon-confg:

<hostname> <IP of host> Critical dbi:mysql:mysql:<hostname> <username>
<password> select
 * from user

Note: all pertinent details substituted for obvious reasons.

When i try and start sqlmon, i get the following error:

Date Tue Nov 20 14:42:54 GMT 2001
Not enough arguments for SNIPS::alter_event at /opt/snips/bin/sqlmon line
87, near "undef)"
Execution of /opt/snips/bin/sqlmon aborted due to compilation errors.

We have a number of databases within the single mysql instance on this
host, but it obviously has to connect to the "mysql" database in order to
perform a user query, is this signified by the second mysql entry in the
DBI connect string???

has anybody else successfully used the sqlmon modules , or seen this error??

many thanks in advance


Steve Foster
Senior Systems Administrator
PSINet Europe
Work: +44 (1223) 577322
Mobile: +44 (7720) 425911

Zyrion Traverse Network Monitoring & Network Management Software