Servoy is not starting Servoy after installing Servoy Server

Questions and answers for all installation-related topics for Servoy products

Servoy is not starting Servoy after installing Servoy Server

Postby jcarlos » Sat Dec 14, 2013 4:45 am

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(TM) SE Runtime Environment (build 1.7.0_45-b18)
Java HotSpot(TM) 64-Bit Server VM (build 24.45-b08, mixed mode)

During installation I selected:

Capture.JPG
Capture.JPG (106.88 KiB) Viewed 8451 times


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]

Code: Select all
# 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]

Code: Select all
# 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!
Last edited by jcarlos on Sun Dec 15, 2013 7:30 am, edited 1 time in total.
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby tgs » Sat Dec 14, 2013 1:48 pm

Hi Juan-Carlos,

I'm not familar with MySQL, but is this property correct?
Code: Select all
server.0.URL=jdbc\:mysql\://localhost/srms_repository

Don't you need a port number after ..//localhost:XXXX/... ?
Thomas Schnaus
SAN Developer
yomotec GmbH
User avatar
tgs
 
Posts: 886
Joined: Wed Oct 04, 2006 12:05 pm
Location: Germany

Re: Servoy is not starting Servoy after installing Servoy Se

Postby ROCLASI » Sat Dec 14, 2013 6:59 pm

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
Code: Select all
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 Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy is not starting Servoy after installing Servoy Se

Postby jcarlos » Sat Dec 14, 2013 7:43 pm

tgs wrote:Hi Juan-Carlos,

I'm not familar with MySQL, but is this property correct?
Code: Select all
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
Last edited by jcarlos on Sun Dec 15, 2013 7:36 am, edited 1 time in total.
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby jcarlos » Sat Dec 14, 2013 7:44 pm

ROCLASI wrote: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
Code: Select all
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 wrote: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
Code: Select all
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
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby ROCLASI » Sat Dec 14, 2013 8:13 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy is not starting Servoy after installing Servoy Se

Postby jcarlos » Sat Dec 14, 2013 9:45 pm

ROCLASI wrote: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
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby ROCLASI » Sat Dec 14, 2013 11:53 pm

Hi Juan-Carlos,
jcarlos wrote: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 ?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy is not starting Servoy after installing Servoy Se

Postby jcarlos » Sun Dec 15, 2013 7:46 am

ROCLASI wrote:Hi Juan-Carlos,
jcarlos wrote: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 wrote: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. 
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby jcarlos » Mon Dec 16, 2013 5:37 pm

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!
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Servoy is not starting Servoy after installing Servoy Se

Postby ROCLASI » Mon Dec 16, 2013 9:05 pm

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).
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Servoy is not starting Servoy after installing Servoy Se

Postby ROCLASI » Tue Dec 24, 2013 2:05 am

Hi Juan-Carlos,

Perhaps this thread is related to your problem.

Hope this helps.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests