by bdezonia » Mon Apr 06, 2015 6:03 pm
Thanks for the feedback guys. First a bit about my setup. The database in use is MSSQL (maybe 2008). I have two database servers. Developer is setup on Windows and working with our dev server database. I dumped those MAC_* databases to sql scripts and imported them on the production database. I also copied the servoy.properties file to the Linux server and just changed the hostname for the six database connections.
The original log entries were in /var/log/messages and ./service_log.txt. I did not know about the server.log file until today. The server.log file showed that the database user account I was using did not have permissions to create tables. The database script backup and restore did not copy user permissions. I updated the user permissions (db_reader, db_writer, db_owner) and get a different result.
The original result shows this 5 times in service_log.txt:
STATUS | wrapper | 2015/04/02 11:10:42 | Launching a JVM...
INFO | jvm 4 | 2015/04/02 11:10:42 | WrapperManager: Initializing...
INFO | jvm 4 | 2015/04/02 11:10:46 | Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.
STATUS | wrapper | 2015/04/02 11:10:48 | on_exit trigger matched. Restarting the JVM. (Exit code: 1)
And then this:
FATAL | wrapper | 2015/04/02 11:10:59 | There were 5 failed launches in a row, each lasting less than 300 seconds. Giving up.
FATAL | wrapper | 2015/04/02 11:10:59 | There may be a configuration problem
So I once again run ServoyServer -upgradeRepository since the user permissions are setup. Now I get this error in server.log:
Upgrading repository.
Error upgrading repository: com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: There is already an object named 'servoy_content_spec' in the database.
This make some sense but its not clear to me why it thinks it needs an upgrade at all.
I went over the linux instructions you gave. The only gotcha in my case is I'm almost sure I installed servoy as root. I also did not do the set the look and feel to metal.