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

 

     Re: [snips-users] problems with sqlmon

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.

I just ran across this problem myself while trying to get sqlmon
working. Looks like a bug to me. The problem is with the alter_event
function call at line 86-87 in the bin/sqlmon script. Seems to be
missing one value as there should be 7 values passed with the call and
there are only 6 listed as in the original line as shown below:

       alter_event($event, undef, $devicename[$count],
$deviceaddr[$count],
                   undef, undef);

I just plopped in another 'undef' value since I'm not sure what the
missing value should be and it now sqlmon runs:

       alter_event($event, undef, $devicename[$count],
$deviceaddr[$count],
                   undef, undef, undef);

Jeremy Palmer
Network Administration
Great Basin Internet Services
www.greatbasin.net
(775)321-8450
(888)477-7299

ORIGINAL MESSAGE BELOW
__________________________________
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

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







Zyrion Traverse Network Monitoring & Network Management Software