Issue installing Servoy Server with NOT bundled PostgreSQL

[jcarlos]

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

[ROCLASI]

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.

[jcarlos]

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

Capture.GIF (3.12 KiB) Viewed 9668 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

Thanks Rob.

Carlos

[Roberto Blasco]

Hi Juan Carlos

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

Best regards. Roberto Blasco.

[ptalbot]

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

[jcarlos]

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.

[jcarlos]

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]

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

[ROCLASI]

Hi Carlos,

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.

[jcarlos]

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 (25.86 KiB) Viewed 9596 times

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

Best, Carlos