Issue installing Servoy Server with NOT bundled PostgreSQL

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

Issue installing Servoy Server with NOT bundled PostgreSQL

Postby jcarlos » Sat Sep 01, 2012 7:58 am

Re: Servoy 6.1.0, Java version "1.6.0_18", Windows XP

I am trying to install Servoy Server without the PostgreSQL database. Instead I want to use MySQL.

Hence, I followed the recommendation at: http://wiki.servoy.com/display/public/D ... +databases

I used the following servoy.properties file:

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
servoy.rmiStartPort=1099
servoy.application_server.startRepositoryAsTeamProvider=false


I also put the JDBC Driver for MySQL in the correct application_server\drivers directory. The MySQL database is running, permissions granted, etc.

Then, I start the server with the upgradeRepository flag:

Code: Select all
servoy_server.bat -upgradeRepository


Still, I keep getting this error message in the command line window: Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.

Or as appear in the servoy_log file:

2012-08-31 22:46:58,546 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]

I also tried these URLs in the properties file:
server.0.URL=jdbc:mysql://localhost/srms_repository
server.0.URL=jdbc:mysql://localhost:3306/srms_repository
server.0.URL=jdbc:mysql\://localhost\:3306/srms_repository


And I tried these driver notations:
com.mysql.jdbc.Driver
com.mysql.jdbc.NonRegisteringDriver


A few times I removed everything and I installed everything again. Any idea of what am I be doing wrong or missing?

Thank you in advance for any help!

Best, Carlos
Last edited by jcarlos on Sat Sep 01, 2012 8:07 pm, edited 3 times 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: Issue installing Servoy Server with NOT bundled PostgreS

Postby ROCLASI » Sat Sep 01, 2012 10:19 am

Hi Carlos,

Sounds to me it's all setup correctly. The only thing is that Servoy server doesn't create/update the schema without you telling it that it should do it.
That's what's the -upgradeRepository flag is all about.
Just launch the servoy_server like so:
Code: Select all
servoy_server.bat -upgradeRepository

This will force it to create any tables/columns when needed and then quits. After it's done you can launch Servoy server the regular way.

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: Issue installing Servoy Server with NOT bundled PostgreS

Postby jcarlos » Sat Sep 01, 2012 7:01 pm

Unfortunately, every time I tried to start the application server I did just that:

Capture.GIF
Capture.GIF (3.12 KiB) Viewed 8193 times

I was really hoping for something missing or wrong from my part so that I could fix it and move on.

Is anyone experiencing issues when installing Servoy Server without the PostgreSQL database and instead using MySQL?

I'll try in another computer and OS to see if the issue can then be fixed. If not, then I will report it as a bug. Again, still hoping for something wrong from my part :roll:

Thanks Rob.

Carlos
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: Issue installing Servoy Server with NOT bundled PostgreS

Postby Roberto Blasco » Sat Sep 01, 2012 10:07 pm

Hi Juan Carlos

Maybe with the servoy_log.txt file we'll see if something's wrong

Best regards. Roberto Blasco.
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: roberto.blasco.serrano@gmail.com
User avatar
Roberto Blasco
007
 
Posts: 355
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain

Re: Issue installing Servoy Server with NOT bundled PostgreS

Postby ptalbot » Sat Sep 01, 2012 10:24 pm

What you can do is create a blank database, use it as your repository database and then do
Code: Select all
servoy_server.bat -upgradeRepository
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
https://www.servoyforge.net
Velocity rules! If you don't use it, you don't know what you're missing!
User avatar
ptalbot
 
Posts: 1654
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: Issue installing Servoy Server with NOT bundled PostgreS

Postby jcarlos » Sun Sep 02, 2012 4:53 am

ptalbot wrote:What you can do is create a blank database, use it as your repository database and then do
Code: Select all
servoy_server.bat -upgradeRepository


I did that. It's part of the recipe. I've never used PostgreSQL in Servoy Server. :?

See the recipe I followed in my first post above.

Man, thank you, but unfortunately that's not the issue. :?
Last edited by jcarlos on Sun Sep 02, 2012 5:09 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: Issue installing Servoy Server with NOT bundled PostgreS

Postby jcarlos » Sun Sep 02, 2012 5:06 am

Roberto Blasco wrote:Hi Juan Carlos

Maybe with the servoy_log.txt file we'll see if something's wrong

Best regards. Roberto Blasco.


Gracias Roberto.

The only thing I've seen in the log is this:

Code: Select all
2012-08-31 22:46:58,546 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-01 09:52:24,453 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-01 11:02:36,953 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-01 19:54:46,984 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]

It really doesn't offer any clue about what is going on. I thought it could be something with the user's permissions/privileges, but it's not. The user has now root grated privileges in the entire system not just srms_repository database, which is the database specified in the servoy.properties file.

I'll try the whole process in another computer and OS. If it doesn't work, I'll report it in the support system as a bug. Hopefully it is not a bug, and there is something on the machine or it's something that I am missing or I did wrong. But honestly, at this point, I don't think that something I did could be causing the problem.

Muchas gracias a todos,
Carlos
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: Issue installing Servoy Server with NOT bundled PostgreS

Postby jcarlos » Wed Sep 05, 2012 7:22 am

Team,

I never got working Servoy Server in Windows XP and Windows 7 32-bit machines while installing Servoy Server with the 'Connect to an existing database' option.

There is not really a workaround, but to get thing moving I installed Servoy Application Server with the 'Install bundled PostgreSQL database server' option. The repository itself has a really small footprint and so this is not really a showstopper for me (really because I am the administrator of the server.)

However, I have to point out that I was expecting that after installing Servoy with the bundled database, I was going to be able to click in the servoy_server.bat file and run Servoy without problem. That was not the case. You still need to modify the servoy_server.bat file to get it working to make sure that you start PostgresSQL first. Hence I ‘activated’ this line:

Code: Select all
postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

Then, you still need to start the server with -upgradeRepository flag. See below:

C:\Servoy\application_server>servoy_server.bat
pg_ctl: another server might be running; trying to start server anyway
server starting
Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.

C:\Servoy\application_server>servoy_server.bat
Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.

C:\Servoy\application_server>servoy_server.bat -upgradeRepository
Upgrading repository.
Repository update successful.

C:\Servoy\application_server>servoy_server.bat
Sep 04, 2012 4:47:27 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 04, 2012 4:47:28 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 544 ms
Sep 04, 2012 4:47:28 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 04, 2012 4:47:28 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
Sep 04, 2012 4:47:28 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Sep 04, 2012 4:47:30 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 04, 2012 4:47:30 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2257 ms


Regarding this I have a question about this line:
pg_ctl: another server might be running; trying to start server anyway
Is this there as a warning for Servoy installation with the PostgreSQL Standard Server by EnterpriseDB? I really don’t see why this warning is there when actually no another server is running. Can Servoy answer this?

Again, I got Servoy Server working after installing Servoy with the ‘Install bundled PostgreSQL database server’ option. The ‘Connect to an existing database’ option never worked, and I couldn’t use my existing MySQL server.

I tried many installations (BTW, Servoy 6.1.0 Developer is working as expected), but still could not figure out what is wrong. I suspect a bug, which it’s perhaps not about the installation but about successfully starting Servoy server with the .bat file, etc. I really don’t know. I will report this issue in Servoy Support.

Thanks,
Carlos
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: Issue installing Servoy Server with NOT bundled PostgreS

Postby ROCLASI » Wed Sep 05, 2012 10:17 am

Hi Carlos,

jcarlos wrote:Regarding this I have a question about this line:
pg_ctl: another server might be running; trying to start server anyway
Is this there as a warning for Servoy installation with the PostgreSQL Standard Server by EnterpriseDB? I really don’t see why this warning is there when actually no another server is running. Can Servoy answer this?


This means that there was already a PID file from a previous session that wasn't cleaned up. Question is of course why it was already there when you did a clean install. Unless of course Pg was already run and then forced quit or something.
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: Issue installing Servoy Server with NOT bundled PostgreS

Postby jcarlos » Wed Sep 05, 2012 6:53 pm

ROCLASI wrote:
jcarlos wrote:Regarding this I have a question about this line:
pg_ctl: another server might be running; trying to start server anyway
Is this there as a warning for Servoy installation with the PostgreSQL Standard Server by EnterpriseDB? I really don’t see why this warning is there when actually no another server is running. Can Servoy answer this?


This means that there was already a PID file from a previous session that wasn't cleaned up. Question is of course why it was already there when you did a clean install. Unless of course Pg was already run and then forced quit or something.


Rob, thanks for the reply. Honestly, I don't know what is going on, but i know this:

In order to run Servoy after installation (Install bundled PostgreSQL database server' option w/o service), I needed to use the -upgradeRepository flag. To get this working still I had to modify the servoy_server.bat and ‘activate’ the line postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt. By deactivating this line later, then the warning disappears.

In general:

1) After running Servoy the first time (servoy_server.bat -upgradeRepository), I always get this warning.

Code: Select all
C:\Servoy\application_server>servoy_server.bat -upgradeRepository
pg_ctl: another server might be running; trying to start server anyway
server starting
The process cannot access the file because it is being used by another process.
Upgrading repository.
Repository update successful.


2) Then, after the repository is updated, I can just use servoy_server.bat.

Code: Select all
C:\Servoy\application_server>servoy_server.bat
pg_ctl: another server might be running; trying to start server anyway
server starting
The process cannot access the file because it is being used by another process.
Sep 5, 2012 8:56:15 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 5, 2012 8:56:15 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 564 ms
Sep 5, 2012 8:56:15 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 5, 2012 8:56:15 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
Sep 5, 2012 8:56:16 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Sep 5, 2012 8:56:18 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 5, 2012 8:56:18 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2226 ms


3) Then after modifying the servoy_server.bat file for one last time by 'deactivating' the line postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt, the warning is banished and the Server works fine. See below:

Code: Select all
C:\Servoy\application_server>
C:\Servoy\application_server>servoy_server.bat
Sep 5, 2012 9:17:20 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 5, 2012 9:17:20 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 506 ms
Sep 5, 2012 9:17:20 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 5, 2012 9:17:20 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
Sep 5, 2012 9:17:20 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory ROOT
Sep 5, 2012 9:17:22 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 5, 2012 9:17:22 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2037 ms


Someone might ask, why do you have to start the Server is –upgradeRepository flag? The answer: if I don’t, I don’t ever get Servoy running and I keep getting the error ‘Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.’

See the snapshot below:

Capture.GIF
Capture.GIF (25.86 KiB) Viewed 8121 times


I reported this issue with Servoy Support. They'll figure it out. Issue key number: Bug SVY-2999

Best, Carlos
Juan-Carlos Sanchez, Stanford University - Law and Economics
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA


Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests

cron