Servoy Forum

Discuss Servoy here!

Skip to content

OS X 10.7.2 Server + Servoy 6.03

Questions and answers for all installation-related topics for Servoy products
Post a reply

Re: OS X 10.7.2 Server + Servoy 6.03

Postby ROCLASI » Tue Jan 03, 2012 11:27 am

Hi,

Is there a repository database created in PostgreSQL (check via PgAdmin or psql)?
Does Servoy point to this repository database (check the servoy.properties)?

If that all exists and is correct then you need to let Servoy create the repository tables using the following command:
Code: Select all
cd /path/to/servoy/application_server
./servoy_server.sh -upgradeRepository

Servoy server will start, create the repository tables and quit again. After this you can launch Servoy server the normal way.

Hope this helps.


P.s. EnterpriseDB is a company name. They have their own PostgreSQL derived (non-free) product (PostgreSQL Plus Advanced) which aims to be Oracle compatible but they also create (free) community installers of 'plain' PostgreSQL. So there is no 'Enterprise version of PostgreSQL'. If anything PostgreSQL is already enterprise out of the box :)
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
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby itgenetics » Tue Jan 03, 2012 11:30 am

2012-01-03 09:27:51,875 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
2012-01-03 09:28:00,676 ERROR [WrapperSimpleAppMain] 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:504)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1410)
at com.servoy.j2db.server.Za.Za.<init>(Za.java:1325)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:920)
at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:156)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:238)
at java.lang.Thread.run(Thread.java:680)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ""itg""
Position: 13
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.servoy.j2db.Za.Zg.invoke(Zg.java:16)
at $Proxy0.execute(Unknown Source)
at com.servoy.j2db.server.Za.Zo.Za(Zo.java:233)
at com.servoy.j2db.Za.Zq.initializeConnection(Zq.java:17)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:586)
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.Za.Za.getConnection(Za.java:139)
at com.servoy.j2db.server.Za.Zo.getRawConnection(Zo.java:49)
at com.servoy.j2db.server.Za.Zo.Zf(Zo.java:930)
at com.servoy.j2db.server.Za.Za.Zb(Za.java:638)
... 10 more
2012-01-03 09:28:00,681 ERROR [WrapperSimpleAppMain] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database! [ ]
itgenetics
 
Posts: 63
Joined: Fri Apr 08, 2011 11:26 am
Location: Cambridge, UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby lvostinar » Tue Jan 03, 2012 11:32 am

Seems to me it cannot connect to repository server. Are you sure connection data is ok and repository is initialized?
Laurian Vostinar
Servoy
lvostinar
 
Posts: 1062
Joined: Tue Feb 19, 2008 10:53 am
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby itgenetics » Tue Jan 03, 2012 11:33 am

are there any tests I can perform?
itgenetics
 
Posts: 63
Joined: Fri Apr 08, 2011 11:26 am
Location: Cambridge, UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby itgenetics » Tue Jan 03, 2012 11:37 am

ROCLASI wrote:Hi,

Is there a repository database created in PostgreSQL (check via PgAdmin or psql)?
Does Servoy point to this repository database (check the servoy.properties)?

If that all exists and is correct then you need to let Servoy create the repository tables using the following command:
Code: Select all
cd /path/to/servoy/application_server
./servoy_server.sh -upgradeRepository

Servoy server will start, create the repository tables and quit again. After this you can launch Servoy server the normal way.

Hope this helps.


P.s. EnterpriseDB is a company name. They have their own PostgreSQL derived (non-free) product (PostgreSQL Plus Advanced) which aims to be Oracle compatible but they also create (free) community installers of 'plain' PostgreSQL. So there is no 'Enterprise version of PostgreSQL'. If anything PostgreSQL is already enterprise out of the box :)


I'll try this and and come back to you all....
itgenetics
 
Posts: 63
Joined: Fri Apr 08, 2011 11:26 am
Location: Cambridge, UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby lvostinar » Tue Jan 03, 2012 11:41 am

Do you have repository server defined in servoy.properties? Did you start application server with -upgradeRepository (if don't use the default db) so that repository tables are created?
Laurian Vostinar
Servoy
lvostinar
 
Posts: 1062
Joined: Tue Feb 19, 2008 10:53 am
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby itgenetics » Tue Jan 03, 2012 11:44 am

lvostinar wrote:Do you have repository server defined in servoy.properties? Did you start application server with -upgradeRepository (if don't use the default db) so that repository tables are created?

No - can you walk me through that please?
itgenetics
 
Posts: 63
Joined: Fri Apr 08, 2011 11:26 am
Location: Cambridge, UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby lvostinar » Tue Jan 03, 2012 12:04 pm

itgenetics wrote:
lvostinar wrote:Do you have repository server defined in servoy.properties? Did you start application server with -upgradeRepository (if don't use the default db) so that repository tables are created?

No - can you walk me through that please?


see previous post: viewtopic.php?f=11&t=17336&p=94485#p94476
Laurian Vostinar
Servoy
lvostinar
 
Posts: 1062
Joined: Tue Feb 19, 2008 10:53 am
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby itgenetics » Tue Jan 03, 2012 12:22 pm

OK - I uninstalled the server from the Mac and started again.

The installation failed twice as previously mentioned.

On the first failure rename install_service_temp.sh to install_service.sh
On the second failure rename install_service_temp.sh to uninstall_service.sh

If you are using a pre-loaded version of postgres

only complete the bare minimum: username and password (don't do what I did and add a schema name!)

once completed enter terminal and get to your application server path

cd Applications/Servoy/application_server

and type:

./servoy_server.sh -upgradeRepository

then install the daemon

then start - all is now well here at Mac towers!!

Thanks to all who helped me get to a solution - forums at their finest!
itgenetics
 
Posts: 63
Joined: Fri Apr 08, 2011 11:26 am
Location: Cambridge, UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby Andrei Costache » Mon Jan 09, 2012 6:13 pm

ROCLASI wrote:Hi Laurian,

lvostinar wrote:Did someone create a case for this? Can you check what does this: System.getProperty("os.name") return ?(you can execute this Java code from Servoy client, for example)


application.output( java.lang.System.getProperty("os.name")) returns "Mac OS X" for me on Mac OS X 10.7.

Issue SVY-1312 filed.

Issue SVY-1312 has been fixed in 6.0.x (and Trunk); the fix is available in the next public release of Servoy.

Regards,
Andrei
Andrei Costache
Servoy
User avatar
Andrei Costache
 
Posts: 196
Joined: Mon Sep 07, 2009 11:53 am
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby Gordon » Fri Jan 27, 2012 11:30 am

I am trying to install the Servoy Application Server on OSX 10.6.8 and running into the same issues as itgenetics. Essentially the installer is throwing the error

/bin/chmod a+x /Applications/Servoy604/application_sever/service/install_service.sh

On investigation this file does not exist, nor does install_service_temp.sh. I have tried repeating the process and followed the instructions from itgenetics without success. I have also tried installing the full version of Postgres which again failed. Any ideas how to get this working would be appreciated.

Incidentally the installer was downloaded from the Servoy site 27/01/12 so is the current version as of today

Cheers
Gordon
Gordon McLean
Click Digital Media Ltd
SAN Developer
www.clickdigital.com
User avatar
Gordon
 
Posts: 265
Joined: Thu Mar 17, 2005 8:05 pm
Location: UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby Andrei Costache » Fri Jan 27, 2012 11:41 am

Gordon wrote:I am trying to install the Servoy Application Server on OSX 10.6.8 and running into the same issues as itgenetics. Essentially the installer is throwing the error

/bin/chmod a+x /Applications/Servoy604/application_sever/service/install_service.sh

On investigation this file does not exist, nor does install_service_temp.sh. I have tried repeating the process and followed the instructions from itgenetics without success. I have also tried installing the full version of Postgres which again failed. Any ideas how to get this working would be appreciated.

Incidentally the installer was downloaded from the Servoy site 27/01/12 so is the current version as of today

Cheers
Gordon

The fix for SVY-1312 will be available in Servoy 6.0.5.

Regards,
Andrei
Andrei Costache
Servoy
User avatar
Andrei Costache
 
Posts: 196
Joined: Mon Sep 07, 2009 11:53 am
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby Gordon » Fri Jan 27, 2012 1:58 pm

Andrei Costache wrote:The fix for SVY-1312 will be available in Servoy 6.0.5.

Regards,
Andrei


Any idea when ??? cos is certainly does not seem to want to be installed in the interim !

G
Gordon McLean
Click Digital Media Ltd
SAN Developer
www.clickdigital.com
User avatar
Gordon
 
Posts: 265
Joined: Thu Mar 17, 2005 8:05 pm
Location: UK
Top

Re: OS X 10.7.2 Server + Servoy 6.03

Postby lvostinar » Mon Jan 30, 2012 9:38 am

Gordon wrote:
Andrei Costache wrote:The fix for SVY-1312 will be available in Servoy 6.0.5.

Regards,
Andrei


Any idea when ??? cos is certainly does not seem to want to be installed in the interim !

G


Servoy 6.0.5 was released on Friday viewtopic.php?f=16&t=17657
Laurian Vostinar
Servoy
lvostinar
 
Posts: 1062
Joined: Tue Feb 19, 2008 10:53 am
Top
Previous
Post a reply

Return to Installation

Who is online

Users browsing this forum: Bing [Bot] and 7 guests

Learn more about Servoy
cron