Servoy is not starting Servoy after installing Servoy Server

Servoy is not starting Servoy after installing Servoy Server (7.3.x).

Platform:

Servoy 7.3.1 RC (because Servoy 7.3 wasn’t available for download from the website last night)
Linux - RHEL Server 6.5, x86_64
java version “1.7.0_45”
Java™ SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot™ 64-Bit Server VM (build 24.45-b08, mixed mode)

During installation I selected:

[attachment=0]Capture.JPG[/attachment]

Then I modified the servoy.properties to add the database URL and the driver. The servoy.properties is shown below:

server.0.URL=jdbc:mysql://localhost/srms_repository
server.0.driver=com.mysql.jdbc.Driver
server.0.userName=srms
server.0.password=password

Then, as I’ve done before, I started the Server with the ‘upgradeRepository’ option:

./servoy_server.sh –upgradeRepository

Servoy installed without problem. I did all by the book. I thought it was going to be all Ok, but I run into trouble.

These are some of the servoy.properties definition I tried:

[1]

# Servoy properties file
# NOTE: At least one connection must be called 'repository_server' !!

# Number of servers defined in this file
ServerManager.numberOfServers=1

# Definition 1
server.0.serverName=repository_server
server.0.URL=jdbc\:mysql\://localhost/srms_repository
server.0.driver=com.mysql.jdbc.Driver
server.0.userName=srms
server.0.password=password
server.0.schema=<none>
server.0.catalog=<none>

#start database engine
waitForNativeStartup=false

#for use by pdf_forms plugin
pdf_forms_plugin_servername=pdf_forms

#network config
SocketFactory.useTwoWaySocket=true
SocketFactory.useSSL=true
java.rmi.server.hostname=127.0.0.1

selectedlnf=
servoy.rmiStartPort=1099
servoy.application_server.startRepositoryAsTeamProvider=false

[2]

# Servoy properties file
# NOTE: At least one connection must be called 'repository_server' !!

# Number of servers defined in this file
ServerManager.numberOfServers=1

# Definition 1
server.0.URL=jdbc\:mysql\://localhost/srms_repository
server.0.catalog=<none>
server.0.connectionValidationType=0
server.0.driver=com.mysql.jdbc.Driver
server.0.enabled=true
server.0.maxConnectionsActive=30
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=password
server.0.schema=<none>
server.0.serverName=repository_server
server.0.skipSysTables=false
server.0.userName=srms

#start database engine
waitForNativeStartup=false

#for use by pdf_forms plugin
pdf_forms_plugin_servername=pdf_forms

#network config
SocketFactory.useTwoWaySocket=true
SocketFactory.useSSL=true
java.rmi.server.hostname=127.0.0.1

selectedlnf=
servoy.rmiStartPort=1099
servoy.application_server.startRepositoryAsTeamProvider=false

In both instances I got this from the Servoy logs:

[1]

2013-12-13 17:54:53,730 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2013-12-13 18:05:32,739 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]

And this…

[2]

2013-12-13 17:54:53,730 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]

I tried other permutations of the servoy.properties file, but the other thrown error messages that I was able to recognize, and so fixed them – I thought.

I really can’t see anything wrong in these two servoy.properties definitions (shown above). What can be going wrong?

Please I need your help. This is my biggest and most important deployment of Servoy.

Thank you!

Hi Juan-Carlos,

I’m not familar with MySQL, but is this property correct?

server.0.URL=jdbc\:mysql\://localhost/srms_repository

Don’t you need a port number after …//localhost:XXXX/… ?

Hi Juan-Carlos,

Servoy still needs to setup the repository tables inside the repository database. You can do this by using the following line from the command line

servoy_server.bat -upgradeRepository

This will run, do it’s thing and exit again. After this you can launch Servoy server normally and you should be up and running.

Hope this helps.

tgs:
Hi Juan-Carlos,

I’m not familar with MySQL, but is this property correct?

server.0.URL=jdbc\:mysql\://localhost/srms_repository

Don’t you need a port number after …//localhost:XXXX/… ?

I don’t think it does. I used the same definition I have in my windows server, which is:

server.0.URL=jdbc:mysql://localhost/srms_repository

I tried without it the backslash characters, and the error was then something about missing the database.

Thank you.
JC

ROCLASI:
Hi Juan-Carlos,

Servoy still needs to setup the repository tables inside the repository database. You can do this by using the following line from the command line

servoy_server.bat -upgradeRepository

This will run, do it’s thing and exit again. After this you can launch Servoy server normally and you should be up and running.

Hope this helps.

ROCLASI:
Hi Juan-Carlos,
Servoy still needs to setup the repository tables inside the repository database. You can do this by using the following line from the command line

servoy_server.bat -upgradeRepository

This will run, do it’s thing and exit again. After this you can launch Servoy server normally and you should be up and running.
Hope this helps.

Robert, that command is the one I used for my windows machine. This is the command I used in this Linux server:

./servoy_server.sh –upgradeRepository

I might be missing something. What could be?

Thanks, JC

Hi Juan-Carlos,

So you ran the installer and pointed it to your local MySQL instance. Did you also install the MySQL driver inside the application_server/drivers/ directory?
If I am not mistaken Servoy doesn’t bundle the MySQL driver (due to licensing).

Else what do you see in the servoy log when you run the servoy_server.bat -upgradeRepository ?

Hope this helps.

ROCLASI:
Hi Juan-Carlos,
So you ran the installer and pointed it to your local MySQL instance. Did you also install the MySQL driver inside the application_server/drivers/ directory?
If I am not mistaken Servoy doesn’t bundle the MySQL driver (due to licensing).
Else what do you see in the servoy log when you run the servoy_server.bat -upgradeRepository ?
Hope this helps.

Yes, I run the installer and I pointed out to my local MySQL instance. After the installation I moved the MySQL JDBC driver into the drivers directory. Then I tried to star Servoy server with upgradeRepository option.

Should I have had to create manually the directories
Servoy/application_server/drivers/ and then run the installer?

About the MySQL driver: I used a driver I have in windows developer machine. The driver is a year old. I’ll download the driver from the j connector site and try that later.

Thank you.
JC

Hi Juan-Carlos,

jcarlos:
Should I have had to create manually the directories
Servoy/application_server/drivers/ and then run the installer?

No need to do that. Servoy will create these directories for you and install some bundled drivers.

What do you see in the servoy log ?

ROCLASI:
Hi Juan-Carlos,

jcarlos:
Should I have had to create manually the directories
Servoy/application_server/drivers/ and then run the installer?

No need to do that. Servoy will create these directories for you and install some bundled drivers.

Yes, I know. But if I create those directories before running the installer, perhaps I could place in there the MySQL JDBC driver before the installation is complete. Maybe then I could get the config file with the correct syntax. Just an idea.

ROCLASI:
What do you see in the servoy log ?

See the red bold text in my first post above… “got this from the Servoy logs”

Does anyone has a recent recipe that could be shared on how to install Servoy server in a Linux machine? If not, that’s ok. Once I’ll figure this out, I’ll put together a recipe and post it in this forum.

Thank you.

I think I figured what the problem is. I don’t have the priviledges to run the servoy_server.sh program. I’ll check with the IT department today. I didn’t note the issue before because I was typing:
:shock:
./servoy_server.sh –upgradeRepository

This command didn’t do anything.

I think I should have typed:

sudo ./servoy_server.sh -upgradeRepository

or

sudo -u servoy ./servoy_server.sh -upgradeRepositorySorry

‘servoy’ is a user with the privilege to install servoy in this computer. I think it should have the privileges to run every program at least inside the Servoy directory.

I am hoping this to be the issue. I’ll check with my IT department today and I’ll update the forum.

Thanks!

Hi Juan-Carlos,

Normally you would see it immediately when you don’t have permission to run things.
I just wonder what else is in the log file. I am sure it’s not just the ‘Cannot upgrade repository’ message. Do you see any evidence it can’t connect to the database server at all? Or some timeout errors?
Also can you connect to your MySQL install using another tool ? Also what version of MySQL do you connect to ? You might have to install the latest and greatest version of the JDBC driver (which is a good thing to do anyway).

Hi Juan-Carlos,

Perhaps this thread is related to your problem.

Hope this helps.