log server in war

[derk.hulshof]

Hi all,
I have a strange issue.

In my ng solution I have a log server.
It shows up in de database servers in the admin page.

Now when I create a war file of the solution and deploy it on tomcat
I don't have the log server in the database server list.
Log error is: client_stats table missing in log server, cannot save client statistics; because of missing database server log

I have equal configurations of the log server in the client and war server properties file.

Anyone have an idea?

Servoy 803
Tomcat 8.0.28 and/or 8.0.32
Java 8 latest update

[vschuurhof]

Is setting "servoy.log_server=my_log_server" present in your properties file? Because even if the database is there and defined in your properties file, this setting links the log server to the relevant database. Can you also check if there is a table inside that server called "client_stats"? Because this should be there for the statistics to be stored in.

[derk.hulshof]

the setting servoy.log_server isn't present in my developer nor my war file properties file.
Should this be ? Is this property mandatory or required?

Tables are available

[vschuurhof]

This property sets the log server binding. So if the tables are there but this setting is not, the log server is not known to Servoy.

When you set the log server from Developer, then this setting should be set by Servoy.

[derk.hulshof]

thank you, will give it a try with the next deployment

[derk.hulshof]

I tried a new deployment with the ini param
servoy.log_server=log_server

where log_server is
server.6.serverName=log_server

but still the same errors

ERROR com.servoy.j2db.util.Debug client_stats table missing in log server, cannot save client statistics

com.servoy.j2db.util.Debug Server 'log_server' does not exist. Import failed.
WARN com.servoy.j2db.util.Debug Reserved words used as table or column names: tables: resource;
WARN com.servoy.j2db.util.Debug Database Import started with properties: {addUsersToAdminGroup=false, allowSQLKeywords=true, overrideSequenceTypes=false, automaticallyUpgradeRepository=true, overrideDefaultValues=false, allowDataModelChange=true, insertNewI18NKeysOnly=false, overwriteGroups=true, importUserPolicy=0, updateSequences=false}

[jcompagner]

i don't think this is directly really about the log_server (as a special log_server in servoy that we use for that client_stats)

the problem is that the server doesn't have a log_server at all if you look at the admin page db servers.

So it is really not in the servoy properties file, or it somehow can't enable/connect to it

So your war should really show first that "log_server" database before anything else will work

[derk.hulshof]

Hi Johan,
Thanks for your reply.

The properties file is located somewhere in the windows/system32 directory.

I checked this file with the connected war propertie file and it looks like it wont get updated.
Because in this file the log_server is missing.

I manually updated the properties file restarted the server and its works well.

[jcompagner]

thats really in a weird place for a properties file
the file should be in c:\users\auser\.servoy\server\context

system32 dir i think normally you can't ever write to that file.

you can always override that location by using a system property see: https://wiki.servoy.com/display/DOCS/WAR+Deployment
and search for SERVOY_USER_HOME

[patrick]

I think the system dir is always then default when tomcat runs as a service with the default "SYSTEM" account. When you install tomcat and then just install the service this is what you get. It's always better to create a user account that runs the tomcat server, then you will have all servoy related stuff in /user/server/.servoy/context where it should be.