NEED HELP – Not been able to start Servoy Server 6.1.x

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

NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Sun Sep 09, 2012 11:17 am

NEED HELP – I have NOT been able to start Servoy Server 6.1.0 or 6.1.2 in Windows 2003.

Please help. This is URGENT.

I have tried various possible configurations/installations.

The one that I am posting here, and I'd like to get working, is the Servoy installation with the bundled PostgreSQL database option.

The installation goes well, but when I start Servoy from the Start menu...

start_1.GIF
start_1.GIF (26.51 KiB) Viewed 12411 times


But then Servoy server terminal windows opens and close. The error that is stored in the servoy_log.txt file is this:

Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository:  [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
   at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
   at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
   at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
   at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
   at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
   at org.postgresql.Driver.makeConnection(Driver.java:393)
   at org.postgresql.Driver.connect(Driver.java:267)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
   at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
   at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
   at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
   at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
   at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
   ... 4 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(Unknown Source)
   at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at org.postgresql.core.PGStream.<init>(PGStream.java:62)
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
   ... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]


Then, I tried to start from the command line using ‘servoy_server.bat –upgradeRepository,’ but I get this…

start_2.GIF
start_2.GIF (2.64 KiB) Viewed 12411 times


See the error log with the added lines at the bottom here..

Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository:  [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
   at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
   at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
   at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
   at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
   at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
   at org.postgresql.Driver.makeConnection(Driver.java:393)
   at org.postgresql.Driver.connect(Driver.java:267)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
   at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
   at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
   at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
   at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
   at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
   ... 4 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(Unknown Source)
   at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at org.postgresql.core.PGStream.<init>(PGStream.java:62)
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
   ... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
2012-09-09 01:27:24,216 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


The I modified the servoy_server.bat file adding this line (as suggested in the same .bat file):

postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

Still nothing! It says that the process cannot be accessed because the file is being used…. See here:

start_3.GIF
start_3.GIF (3.68 KiB) Viewed 12411 times


The entire error log is below. Please note the added lines at the bottom don;t say much (Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag)

Code: Select all
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository:  [ ]
com.servoy.j2db.persistence.RepositoryException: Error checking repository
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:34)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:1684)
   at com.servoy.j2db.server.Za.Za.<init>(Za.java:706)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:8)
   at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:686)
Caused by: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)
   at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
   at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
   at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
   at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
   at org.postgresql.Driver.makeConnection(Driver.java:393)
   at org.postgresql.Driver.connect(Driver.java:267)
   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at com.servoy.j2db.datasource.Zp.createConnection(Zp.java:5)
   at com.servoy.j2db.datasource.Ze.createConnection(Ze.java:5)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
   at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1158)
   at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
   at com.servoy.j2db.datasource.Za.getConnection(Za.java:14)
   at com.servoy.j2db.datasource.jmx.ManagedBasicPoolingDataSource.getConnection(ManagedBasicPoolingDataSource.java:34)
   at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:1272)
   at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:644)
   at com.servoy.j2db.server.Za.Za.Zb(Za.java:1625)
   ... 4 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(Unknown Source)
   at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at java.net.Socket.<init>(Unknown Source)
   at org.postgresql.core.PGStream.<init>(PGStream.java:62)
   at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:76)
   ... 21 more
2012-09-09 01:24:58,078 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
2012-09-09 01:27:24,216 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-09 01:28:24,246 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


Same thing happen if I use MySQL instead of the bundled PostgreSQL (of course, configuring the properties file/repository_server/using the correct driver, etc.)

Now, the only way I can get Servoy Server working is when after installing Developer I start Developer. Only then, Servoy server works. If I close Developer and I try to start just Servoy Server from the command line (and of course after modifying the .bat file to start PostgreSQL), Servoy does not work. Same happens!

Any help will be appreciated.

Thank you VERY MUCH in advance, 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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby logicimpresa » Sun Sep 09, 2012 12:44 pm

Try to stop your firewall or antivirus, stop the Servoy server and upgrade the repository with servoy_server.bat -upgradeRepository
User avatar
logicimpresa
 
Posts: 65
Joined: Sun May 01, 2011 3:58 pm
Location: Bernate Ticino (MI) - Italy

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Sun Sep 09, 2012 1:57 pm

logicimpresa wrote:Try to stop your firewall or antivirus, stop the Servoy server and upgrade the repository with servoy_server.bat -upgradeRepository


Gianluca, thank you very much. I did exactly as you suggested*, but this not solved the problem. See below:

Capture.GIF
Capture.GIF (34.82 KiB) Viewed 12400 times


Any other idea? Again, thanks a bunch!


* [I really needed to stop the Servoy server because I have not been able to start it up]
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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Mon Sep 10, 2012 5:26 am

While reading again Servoy Documentation, I read a comment from Ron van der Burg. He wrote:

"When installing on a server make sure you create the installation directory first and apply the correct (full) rigths first.

When installing on a server and you want the database started by the same bat or sh file as Servoy you can edit the bat or sh file and uncomment the line to startup PostgreSQL."


I've done what he advised in the second paragraph, but not what he recommended in the first paragraph. I didn't even think about it because I'be been using the .exe installation file and letting the installer to select the location of Servoy directory/folder.
 
I'll try anyway. Hopefully it works, but seriously I have run every time the .exe installer while having off the firewall.

If any one has something to say, please do so. 

Thank you very much! 
Carlos
jcarlos
 
Posts: 578
Joined: Thu May 04, 2006 8:55 pm
Location: Palo Alto, California USA

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Mon Sep 10, 2012 3:54 pm

Servoyans,

I have done everything following the documentations. It's perhaps an issue in my Windows 2003 machine, but I do not see how, specially because I installed in the same machine Servoy 5.1.x without problem -and using MySQL as the repository.

Please, I need help here. I am supposed to show case Servoy this afternoon.

My machine:

Windows Server 2003 Service Pack 2 - 64-bit
java version "1.6.0_35"
Java(TM) SE Runtime Environment (build 1.6.0_35-b10)
Java HotSpot(TM) Client VM (build 20.10-b01, mixed mode, sharing)


Installation:
- Servoy 6.1.2 using servoy_installer.exe
- Option: Servoy Server installation with the bundled PostgreSQL database
- Creating installation directory first and applying the correct (full) rigths

Starting Server
- Editing the .bat file and un-commenting the line to startup PostgreSQL. The use .bat file code is here:

Code: Select all
@echo off

rem To start postgres add this to the next line:
postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

setlocal
if "%CMD_LINE_CHANGED%"=="" set CMD_LINE_START=java

:restart
%CMD_LINE_START% -Djava.awt.headless=true -Xmx1280m -Xms64m -XX:MaxPermSize=128m -classpath .;lib\activation.jar;lib\antlr.jar;lib\apache-mime4j.jar;lib\BrowserLauncher2.jar;lib\commons-codec.jar;lib\commons-collections.jar;lib\commons-dbcp.jar;lib\commons-fileupload.jar;lib\commons-io.jar;lib\commons-logging.jar;lib\commons-pool.jar;lib\dom4j.jar;lib\hibernate3.jar;lib\httpclient.jar;lib\httpclient-cache.jar;lib\httpcore.jar;lib\httpmime.jar;lib\j2db.jar;lib\j2dbdev.jar;lib\jabsorb.jar;lib\xstream.jar;lib\javassist.jar;lib\jcifs.jar;lib\joda-time.jar;lib\js.jar;lib\jta.jar;lib\jug.jar;lib\log4j.jar;lib\mail.jar;lib\MRJAdapter.jar;lib\networktnl.jar;lib\rmitnl.jar;lib\server-bootstrap.jar;lib\servlet-api.jar;lib\slf4j-api.jar;lib\slf4j-log4j.jar;lib\wicket.jar;lib\wicket-calendar.jar;lib\wicket-extentions.jar;lib\wiquery.jar;lib\fs-parser.jar;lib\fs-commons.jar;lib\minis.jar;lib\PBKDF2.jar com.servoy.j2db.server.main.ApplicationServer %1 %2 %3 %4 %5 %6 %7 %8 %9

rem Restart if the server exited with the restart exit code 99
if %errorlevel%==99 goto restart
if NOT "%ADDITIONAL_RESTART_LEVEL%"=="" if %errorlevel%==%ADDITIONAL_RESTART_LEVEL% goto restart
endlocal


- Starting Servoy with -upgradeRepository flag:

C:\Servoy\application_server>servoy_server.bat -upgradeRepository



Still, can't get Servoy started!

See the errors...

Capture.GIF
Capture.GIF (5.05 KiB) Viewed 12363 times


servoy_log.txt file:

2012-09-10 06:16:18,617 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-10 06:16:29,242 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


Also trying MySQL as the repository

servoy.properties
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


Or I sued on the URL line: server.0.URL=jdbc:mysql://localhost/srms_repository

- Starting Servoy with -upgradeRepository flag:

C:\Servoy\application_server>servoy_server.bat -upgradeRepository


Still, can't get Servoy started!

Error:

2012-09-10 06:49:00,269 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-10 06:49:08,238 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


Please help!

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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby ROCLASI » Mon Sep 10, 2012 6:44 pm

Hi Carlos,

Did you install Servoy inside the applications directory or somewhere else. The latter is recommended due to permission issues. Usually C:\Servoy will do (or another drive).
Your first post suggests that PostgreSQL wasn't running. This can be due to the fact that the database cluster wasn't initialized properly due to said permission issues.

In your last post you try to make Servoy connect to MySQL. Is MySQL running ? And does the srms user have access from this IP/hostname to the srms_repository database? Also has the srms user the proper permissions to create database objects?

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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Mon Sep 10, 2012 7:20 pm

ROCLASI wrote:Did you install Servoy inside the applications directory or somewhere else. The latter is recommended due to permission issues. Usually C:\Servoy will do (or another drive).
Your first post suggests that PostgreSQL wasn't running. This can be due to the fact that the database cluster wasn't initialized properly due to said permission issues.


I installed Servoy in C:\Servoy every time. I also tried the installation by turning off Windows Firewall.

As I mentioned, I installed Servoy Server with the bundled PostgreSQL database (in various of the many tries). I also edited the servoy_server.bat file and un-commenting the line to startup PostgreSQL, and I tried servoy_server.bat -upgradeRepository.

This did not work.

ROCLASI wrote:In your last post you try to make Servoy connect to MySQL. Is MySQL running ? And does the srms user have access from this IP/hostname to the srms_repository database? Also has the srms user the proper permissions to create database objects?


Yes, MySQL is running. The user (srms) has grant privileges on the server - same privileges as root. To double-check, I just log-in into MySQL with srms and create and drop a database with no problems.

I think is Windows 2003 giving me a problem, but no one in the Law School see anything wrong with my Windows machine. It might have to do with PostgreSQL. It was installed in this machine before, and I removed a long ago using the Windows "Add or Remove Programs" utility and not the uninstaller from EnterpriseDB.

Any other idea?

Rob, I really appreciate your help on this. Thank you for replying to this post.

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

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby ROCLASI » Mon Sep 10, 2012 7:58 pm

jcarlos wrote:I installed Servoy in C:\Servoy every time. I also tried the installation by turning off Windows Firewall.

Ah yes, I see it in your screenshots now.
But do you have anything in your database directory though. It should have a host of subdirectories and some config files. If not then your database cluster was never initialized and PostgreSQL will NOT run.
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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Mon Sep 10, 2012 8:24 pm

ROCLASI wrote:
jcarlos wrote:I installed Servoy in C:\Servoy every time. I also tried the installation by turning off Windows Firewall.

Ah yes, I see it in your screenshots now.
But do you have anything in your database directory though. It should have a host of subdirectories and some config files. If not then your database cluster was never initialized and PostgreSQL will NOT run.


I just performed a clean installation again of Servoy Server with the bundled PostgreSQL database. See these screenshots :

Capture.GIF
Capture.GIF (20.05 KiB) Viewed 12331 times

Capture2.GIF
Capture2.GIF (32.08 KiB) Viewed 12331 times

Capture3.GIF
Capture3.GIF (16.2 KiB) Viewed 12331 times


However,it just occur to me to look into the postgres_log.txt file...

Code: Select all
LOG:  database system was shut down at 2012-09-10 11:15:08 PDT
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
FATAL:  role "scac-team" does not exist
LOG:  received smart shutdown request
LOG:  autovacuum launcher shutting down
LOG:  shutting down
LOG:  database system is shut down


What does the line FATAL: role "scac-team" does not exist mean? Could this be the problem?

scac-team is the administrator user of this computer.

Thanks a bunch 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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcompagner » Tue Sep 11, 2012 8:04 am

i think you are starting it twice. i see you also have installed the service
And you try to start it through the command line.

So is the service started?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Tue Sep 11, 2012 3:20 pm

jcompagner wrote:i think you are starting it twice. i see you also have installed the service
And you try to start it through the command line.

So is the service started?


Hi Johan,

The service was not started. I have installed Servoy with or without the service trying to get Servoy server working. Most of the time I have installed it without the service.

While replying to you comments, I am installing everything (clean installation again of Servoy Server with the bundled PostgreSQL database). This time without the service. See below:

application_server directories and files:

Capture.GIF
Capture.GIF (21.91 KiB) Viewed 12300 times


Code: Select all
Directory of C:\Servoy\application_server

09/11/2012  05:30 AM    <DIR>          .
09/11/2012  05:30 AM    <DIR>          ..
09/11/2012  05:30 AM    <DIR>          .extensions
09/11/2012  05:30 AM    <DIR>          beans
09/11/2012  05:30 AM    <DIR>          database
09/11/2012  05:30 AM    <DIR>          docs
09/11/2012  05:30 AM    <DIR>          drivers
09/11/2012  05:30 AM    <DIR>          lafs
09/11/2012  05:30 AM    <DIR>          lib
09/11/2012  05:30 AM    <DIR>          plugins
09/11/2012  05:30 AM    <DIR>          postgres_db
09/11/2012  05:30 AM    <DIR>          server
09/11/2012  05:30 AM               759 servoy.properties
09/11/2012  05:33 AM             1,399 servoy_server.bat
09/11/2012  05:30 AM    <DIR>          terracotta
               2 File(s)          2,158 bytes
              13 Dir(s)  136,618,471,424 bytes free


This is what is in the database directory:

Code: Select all
Directory of C:\Servoy\application_server\database

09/11/2012  05:30 AM    <DIR>          .
09/11/2012  05:30 AM    <DIR>          ..
09/11/2012  05:30 AM    <DIR>          base
09/11/2012  05:30 AM    <DIR>          global
09/11/2012  05:30 AM    <DIR>          pg_clog
09/11/2012  05:30 AM             4,363 pg_hba.conf
09/11/2012  05:30 AM             1,678 pg_ident.conf
09/11/2012  05:30 AM    <DIR>          pg_multixact
09/11/2012  05:30 AM    <DIR>          pg_notify
09/11/2012  05:30 AM    <DIR>          pg_serial
09/11/2012  05:30 AM    <DIR>          pg_stat_tmp
09/11/2012  05:30 AM    <DIR>          pg_subtrans
09/11/2012  05:30 AM    <DIR>          pg_tblspc
09/11/2012  05:30 AM    <DIR>          pg_twophase
09/11/2012  05:30 AM                 4 PG_VERSION
09/11/2012  05:30 AM    <DIR>          pg_xlog
09/11/2012  05:30 AM            19,785 postgresql.conf
09/11/2012  05:30 AM               116 postmaster.opts
               5 File(s)         25,946 bytes
              13 Dir(s)  136,618,471,424 bytes free


In postgres_db:

Code: Select all
Directory of C:\Servoy\application_server\postgres_db

09/11/2012  05:30 AM    <DIR>          .
09/11/2012  05:30 AM    <DIR>          ..
09/11/2012  05:30 AM    <DIR>          bin
09/11/2012  05:30 AM    <DIR>          lib
09/11/2012  05:30 AM               368 postgres_log.txt
09/11/2012  05:30 AM    <DIR>          share
               1 File(s)            368 bytes
               5 Dir(s)  136,618,471,424 bytes free


NOTE:
I don't see any see anything wrong with the installation. The only message I find that concerns me is in the postgres_log.txt file.

LOG: database system was shut down at 2012-09-11 05:30:48 PDT
FATAL: the database system is starting up
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: role "scac-team" does not exist
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down


What does the line FATAL: role "scac-team" does not exist mean? Could this be the problem?

*scac-team is the administrator user of this computer. I installed Servoy 'as administrator' with the firewall and virus software off.

This installation is complete. I am checking if there is anything running... No postgresql process running.

Now, I am getting ready to start Servoy.

Ok, I un-commented the line postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt in the .bat file.

This is the 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:postgresql://localhost:5432/servoy_repository
server.0.driver=org.postgresql.Driver
server.0.enabled=true
server.0.userName=DBA
server.0.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 added server.0.enabled=true just to make sure...

I am ready to go, I am typing 'servoy_server.bat -upgradeRepository'
... .... ...

Did not work! See here:

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



In the servoy_log.txt
2012-09-11 06:00:16,304 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


Then, I see not one but three postgresql processes:

Capture3.GIF
Capture3.GIF (18.33 KiB) Viewed 12300 times


And of course if I tried again, then I get this:

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.
Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.


And then more postgresql processes:

Capture4.GIF
Capture4.GIF (13.42 KiB) Viewed 12300 times


But the sevoy_log does not say much:

2012-09-11 06:00:16,304 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]
2012-09-11 06:05:05,550 ERROR [main] com.servoy.j2db.util.Debug - Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag. [ ]


There is something really wrong but Servoy does not provide me with clues about what might be. I think I should open a case in Servoy Support for this. What do you think? Any other advice?

Johan, thank you very much.

Carlos
Last edited by jcarlos on Tue Sep 11, 2012 11:37 pm, edited 2 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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcompagner » Tue Sep 11, 2012 4:00 pm

it somehow doesn't see your "-upgradeRepository" as the only parameter that you give to servoy_server.bat
because only then it shows you that message in the log
what is exactly the content of your servoy_server.bat file?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Tue Sep 11, 2012 4:53 pm

jcompagner wrote:it somehow doesn't see your "-upgradeRepository" as the only parameter that you give to servoy_server.bat
because only then it shows you that message in the log
what is exactly the content of your servoy_server.bat file?


Here it is the content of the servoy_server.bat file:

Code: Select all
@echo off

rem To start postgres add this to the next line:
postgres_db\bin\pg_ctl start -D database -l postgres_db\postgres_log.txt

setlocal
if "%CMD_LINE_CHANGED%"=="" set CMD_LINE_START=java

:restart
%CMD_LINE_START% -Djava.awt.headless=true -Xmx1280m -Xms64m -XX:MaxPermSize=128m -classpath .;lib\activation.jar;lib\antlr.jar;lib\apache-mime4j.jar;lib\BrowserLauncher2.jar;lib\commons-codec.jar;lib\commons-collections.jar;lib\commons-dbcp.jar;lib\commons-fileupload.jar;lib\commons-io.jar;lib\commons-logging.jar;lib\commons-pool.jar;lib\dom4j.jar;lib\hibernate3.jar;lib\httpclient.jar;lib\httpclient-cache.jar;lib\httpcore.jar;lib\httpmime.jar;lib\j2db.jar;lib\j2dbdev.jar;lib\jabsorb.jar;lib\xstream.jar;lib\javassist.jar;lib\jcifs.jar;lib\joda-time.jar;lib\js.jar;lib\jta.jar;lib\jug.jar;lib\log4j.jar;lib\mail.jar;lib\MRJAdapter.jar;lib\networktnl.jar;lib\rmitnl.jar;lib\server-bootstrap.jar;lib\servlet-api.jar;lib\slf4j-api.jar;lib\slf4j-log4j.jar;lib\wicket.jar;lib\wicket-calendar.jar;lib\wicket-extentions.jar;lib\wiquery.jar;lib\fs-parser.jar;lib\fs-commons.jar;lib\minis.jar;lib\PBKDF2.jar com.servoy.j2db.server.main.ApplicationServer %1 %2 %3 %4 %5 %6 %7 %8 %9

rem Restart if the server exited with the restart exit code 99
if %errorlevel%==99 goto restart
if NOT "%ADDITIONAL_RESTART_LEVEL%"=="" if %errorlevel%==%ADDITIONAL_RESTART_LEVEL% goto restart
endlocal
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: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcompagner » Wed Sep 12, 2012 12:50 pm

that looks fine, but somehow the -upgradeRepository is not getting in.
maybe you can try it by adjusting the batch file:
change this:

xxxxxx.ApplicationServer %1 %2 %3 %4 %5 %6 %7 %8 %9

to

xxxxxx.ApplicationServer-upgradeRepository
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: NEED HELP – Not been able to start Servoy Server 6.1.x

Postby jcarlos » Wed Sep 12, 2012 3:29 pm

Unfortunately, it did not work.

C:\Servoy\application_server>servoy_server.bat -upgradeRepository
server starting
Exception in thread "main" java.lang.NoClassDefFoundError: com/servoy/j2db/server/main/ApplicationServer-upgradeRepository
Caused by: java.lang.ClassNotFoundException: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository. Program will exit.


The postgres.exe process started, but not Servoy server.

Capture.PNG
Capture.PNG (8.44 KiB) Viewed 12259 times


And of course, when I run the servoy_server.bat -upgradeRepository again, I get same error but with the warning about another pg_ctl server running.

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.
Exception in thread "main" java.lang.NoClassDefFoundError: com/servoy/j2db/server/main/ApplicationServer-upgradeRepository
Caused by: java.lang.ClassNotFoundException: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository.  Program will exit.

C:\Servoy\application_server>


Should I add a case for this in support? Could this be a bug?

What about the message in the postgres_log.txt file?
LOG: database system was shut down at 2012-09-11 05:30:48 PDT
FATAL: the database system is starting up
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: role "scac-team" does not exist
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down


What does the line FATAL: role "scac-team" does not exist mean?

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

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests

cron