No statemants are being logged

This forum is the right place for all discussion about IBExpertSQLMonitor.

No statemants are being logged

Postby cubism » Wed Feb 03, 2010 2:52 pm

Hi,
I am currently testing the trial verion of the sql mointor included in the server tools suite we have purchased because we have the need for a monitoring app for security reasons. I set up the service with standard options (ports and filters) and directed the output into a separate db with the "SQLMonitor DB" service.
I both changed the configuration in ibexpert and the connect statement of our client application concerning the port addressing.

Now I am able to log connect and disconnect but nothing else. Even simple sql statements executed in ibexpert sql editor are not logged.
What could be missing or where could be my mistake?

Best regards
cubism
 
Posts: 12
Joined: Tue Nov 04, 2008 12:56 pm

Re: No statemants are being logged

Postby colin » Fri Feb 12, 2010 8:20 pm

Same problem here, but not a trial version. Var license.

If I look at Service runtime info, Active connections, and double-click the connection, I see only the connect. No selects, etc.

Windows 7, FB 2.1.3, Ibexpert 2009.11.02

Regards, Colin
colin
 
Posts: 3
Joined: Fri Feb 12, 2010 8:14 pm

Re: No statemants are being logged

Postby colin » Sun Feb 14, 2010 1:46 pm

Just installed ibexpert 2010.01.06. Problem remains.
Thought Is might be caused by Windows 7 resolving localhost resolution within DNS itself, and SQLMonistor allowing only localhost.

Thats not the problem, though. I've just tried it on an XP machine. Same problem. Only connect/disconnect showing.

regards Colin
colin
 
Posts: 3
Joined: Fri Feb 12, 2010 8:14 pm

Re: No statemants are being logged

Postby hklemt » Sun Feb 14, 2010 5:44 pm

please try to replace th efbclient library by an older version (for example fb2.0 or fb1.5), in some situations, this helps
Holger Klemt
IBExpert KG
Im Gewerbepark 8 / 27798 Hude / Germany
Sitz der Gesellschaft/Registered Office: Hude
Registergericht/Registered Court: Oldenburg HRA 201201
Geschäftsführer/General Manager: Holger Klemt
hklemt
Site Admin
 
Posts: 124
Joined: Sun May 04, 2008 12:01 am

Re: No statemants are being logged

Postby colin » Mon Feb 15, 2010 12:01 pm

Using fb 2.0.3 version of fbclient instead of 2.1.3 fixed the problem. Thanks.

Will using an older version not cause any problems with communications between client ansd server?

regards, Colin
colin
 
Posts: 3
Joined: Fri Feb 12, 2010 8:14 pm

Re: No statemants are being logged

Postby hklemt » Tue Feb 16, 2010 1:32 am

no, there might only be some physical disadvantages, but all should work
Holger Klemt
IBExpert KG
Im Gewerbepark 8 / 27798 Hude / Germany
Sitz der Gesellschaft/Registered Office: Hude
Registergericht/Registered Court: Oldenburg HRA 201201
Geschäftsführer/General Manager: Holger Klemt
hklemt
Site Admin
 
Posts: 124
Joined: Sun May 04, 2008 12:01 am


Return to IBExpertSQLMonitor

Who is online

Users browsing this forum: No registered users and 1 guest