ODBC logs will not display in log analyzer

wchildress · Post by **wchildress** » Wed Mar 04, 2009 5:58 pm

I'm attempting to change logging from text file to mysql db. The ODBC setup test executes correctly and shows available tests. Loading ODBC logs into log analyzer displays no tests. Why not?

hostmon v 7.78
log Analyzer 5.48
MySQL v 5.0.77
Mysql ODBC Driver 3.51

SQl logging query - Insert into hmlog (eventtime, testname, status, reply, testid, testmethod) VALUES (Now(), '%TestName%', '%Status%', '%Reply%', %TestID%, '%TestMethod%')

KS-Soft · Post by **KS-Soft** » Wed Mar 04, 2009 6:05 pm

Does Log Analyzer shows some error message when you load ODBC log?
If not, probably you set additional filter ("Add custom filter" option)?

Regards
Alex

wchildress · Post by **wchildress** » Wed Mar 04, 2009 6:19 pm

It shows no errors and I don't have any custom query filters set in ODBC log manager or in log analyzer search.

The "test" in the ODBC logs manager shows 36977 record(s) retrieved and structure check: ok

I simply go to file >> load ODBC log >> check my one and only source >> click OK and nothing happens.

KS-Soft · Post by **KS-Soft** » Wed Mar 04, 2009 8:13 pm

Strange.. Could you please send odbclogs.lst file to support@ks-soft.net?
Could you export database (table) structure as well?

Regards
Alex

wchildress · Post by **wchildress** » Thu Mar 05, 2009 12:01 pm

Thanks Alex again for the quick responses. The files have been sent to you. Almost 9 years of using the product and the support is always superb.

greyhat64 · Post by **greyhat64** » Thu Mar 05, 2009 12:53 pm

wchildress,
Nine years!
I would love to tap into a 'veterans' experience with AHM to see if there are some workable strategies I haven't employed yet. So, if you're feeling educational, would you mind emailing me for an off-line chat? (see button below).

Regards,
Joel

KS-Soft · Post by **KS-Soft** » Thu Mar 05, 2009 9:14 pm

Looks like you have specified invalid table name (HMLOG) instead of correct name (hmlog). Its case sensitive.

I wonder how "Test" function could work? It shows "Table .. doesn't exist" error on our system.
Also, its strange Log Analyzer does not show any error message when you load table...
May be there are several problems on your system? Please change table name then we see what happens.

Regards
Alex