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