client_stats table missing in log server ...

[jcarlos]

Hi there,

I get this error message from Servoy Server 6.1.0.:

client_stats table missing in log server, cannot save client statistics.

Capture.GIF

How can I fix this? 

Also, I'd like to learn about what this client_stats table is about and how I could use it... Any advice? 

Best, Carlos

[jcarlos]

Is this client_stats table that is missing from log server the one that in Servoy 5.x was named servoy_client_stats?

How critical is this warning/error message? Any advice will be appreciated.

Thanks!
Carlos

[Mark Crichton]

Hi folks

Curios there has been no response to Carlos' posts

I am getting the same error on a new 6.1.2 application server install. I cannot find any reference anywhere as to how this database\table should be set up. Can't find it in developer or anywhere.

Is this a setting somewhere to switch on or off?

Could not find any reference in the manual either.

Need to get this resolved urgently. Can anybody help to get the database, table and field definitions, or point me to some documentation.

Thanks Mark

MArk

[Mark Crichton]

Oops ... found it...
http://wiki.servoy.com/display/public/D ... it+Logging

[Mark Crichton]

Hi
Servoy 6.1.4 on Windows
I am again having this problem, and have checked in the Application server and Database Servers and there is no checkbox for logging as showing in the help guide image.
I want to switch logging off, and cannot find how to do this.

Thanks
MArk

[jcarlos]

Hi
Servoy 6.1.4 on Windows
I am again having this problem, and have checked in the Application server and Database Servers and there is no checkbox for logging as showing in the help guide image.
I want to switch logging off, and cannot find how to do this.

Thanks
MArk

This sounds to me like a bug. If I were you I'd report this as a bug.

[lvostinar]

There was already a case on it: https://support.servoy.com/browse/SVY-3888 . "client_stats" table is now automatically created in log server. It is the replacement for "servoy_client_stats" from repository server and contains data about client connection. If you don't have a log server defined you will get this error. If you don't need the client connection logging, you can disable it with setting: servoy.log.clientstats=false (that was added in 6.1.4).

[Mark Crichton]

Hi Laurian

where do I find the place to make the change "servoy.log.clientstats=false " as you suggest? I could not find it in the Servoy-admin screens.
Thanks MArk

[lvostinar]

Hi Laurian

where do I find the place to make the change "servoy.log.clientstats=false " as you suggest? I could not find it in the Servoy-admin screens.
Thanks MArk

"servoy.log.clientstats" is in Admin Settings section of admin page. It was added in Servoy 6.1.4 so maybe you use an earlier version ?

[Mark Crichton]

Thanks Laurian
Finally found it.

[stefanoni]

In Version 7.2.0 -releaseNumber 2013
I don't see any option like describet in
http://wiki.servoy.com/display/public/DOCS/Implementing+Audit+Logging

"Logserver", Create Logtabel

Printscreen.jpg (66.93 KiB) Viewed 8880 times

Is there something new/depreciated ?

[stefanoni]

The Wick describes
"Servoy provides the ability to log any data change or data read in a table in Servoy."
what means "data change " in the database ?

But the info-button talks about
allow logging of client connections....

Printscreen1.jpg (55.17 KiB) Viewed 8879 times

what means "something about the time of connections" ?

Does the Wicki and the Info-Button mean the same ?

[rgansevles]

Alessandro,

The wiki page talks about logging data changes made by the clients, this is in the log server in a table named log.

The client_stats table is a different table, also placed in the log server, that logs for (un)registering of clients.
Servoy wants to create this table in the log server, when that fails (usually because there is no log-server defined), this message is printed.

On the admin page to change the log server, select one in the 'Database Servers' page.

Rob

[stefanoni]

thank you rob, I understand, there are two different types of logs.

Question 1:
Is it possible to log the "client_stats" without logging the "data changes" ? I only
see the choice of "client_stats" on/off, but nowhere "logging data changes" on/off.

Question 2:
How to create the log-table, after selecting a database (like your suggestion) in the
'Database Servers' Page ?

I selected, restarted the server, after this I watched the database with pgadmin3
but no log-file added)

Question 3:
Does this link to the wicki 7.x point to a depreciated description, how to creat
the log-table ?
http://wiki.servoy.com/display/public/DOCS/Implementing+Audit+Logging
(see the red arrow point to something witch is not existing in 7.2 ) ?

I understand, that the wicki at this point is talking about logging the 'data changes',
but it talks also about how to create the log table in the log server.

Question 4:
What does this button mean "Update" ? Update the structure, create it ?

Printscreen2.jpg (25.17 KiB) Viewed 8844 times

Alessandro