[Sguil-users] Database Problems

[P F <tar...@gm...>]

Hi everyone,

i am in a need for a NSM System and i am amazed by Sguil. Damn good job. =)

But, i have some problems getting my test installation going. The server,
two sensors and a client all run, and everything looks fine, but when i am
tring to expire an event, the server breaks with this message:

Error: mysqlexec/db server: Table 'sguildb.event_IDSCenter_20060818' doesn't
exist
mysqlexec/db server: Table 'sguildb.event_IDSCenter_20060818' doesn't exist
    while executing
"mysqlexec $MAIN_DB_SOCKETID $updateString"
    (procedure "UpdateDBStatusList" line 9)
    invoked from within
"UpdateDBStatusList $eventTable $whereTmp [GetCurrentTimeStamp]
$userIDArray($socketID) $status"
    (procedure "DeleteEventIDList" line 111)
    invoked from within
"$clientCmd $socketID $data1 "
    ("DeleteEventIDList" arm line 1)
    invoked from within
"switch -exact $clientCmd {
      DeleteEventID { $clientCmd $socketID $index1 $index2 }
      DeleteEventIDList { $clientCmd $socketID $data1 }
      ..."
    (procedure "ClientCmdRcvd" line 30)
    invoked from within
"ClientCmdRcvd sock13"
SGUILD: killing child procs...

Althou, if i try a "Standard Query", for example "Last modified (event)" i
get an error message:

wrong # args: should be "DBQueryRequest selectedTable whereList ?winTitle?"
wrong # args: should be "DBQueryRequest selectedTable whereList ?winTitle?"
    while executing
"DBQueryRequest [lindex $whereStatement 1]"
    (procedure "StdQuery" line 70)
    invoked from within
"StdQuery"
    (menu invoke)

Maybe i should state a few information about my systems:
I run sguil 0.6.1 without ssl,  my mysql version is 14.12. My client runs on
Win-XP with "ActiveState ActiveTcl 8.4.13.0".
I installed the mysql database via the "create_sguildb.sql" script and cept
further rather close to the install doc.

Please help me, o wise and knowledgeable Sguil-Gurus and -Users!

Tarwin