OS X 10.7.2 Server + Servoy 6.03

The Servoy installer does not work unter OS X 10.7.2 Server Edtion.
Can you please test it ? There are missing some .sh files in the installer…

thank you

Rainer Böhm

What errors are you seeing? Due to low numbers of people running OSX Server it is not in our standard test-suite.

I’ve been using Servoy on MacOS X server for a long time until recently and as far as I know there is no difference whatsoever between OS X server and client.
What file is missing?

Hi Rainer,

I just did an Servoy 6.0.3 install on a pristine Mac OS X 10.7.2 Server install (thanks to VMware) and got the following error:

[attachment=1]error.png[/attachment]
[attachment=0]message.png[/attachment]

Is this what you are seeing or is it something else?

We created a workaround for the missing files… it works now.
The installer fails with install_service.sh and uninstall_service.sh as missing files ( just rename the .temp file during installation…)

There is another bug in the URL requester not adding the DB name field to the used url…

rainer

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)

HELP!

rainer / dsp:
We created a workaround for the missing files… it works now.
The installer fails with install_service.sh and uninstall_service.sh as missing files ( just rename the .temp file during installation…)

There is another bug in the URL requester not adding the DB name field to the used url…

rainer

Can someone provide a step by step as I have renamed the .temp to installer.sh and the server fails to start. I would really appreciate details on the workaround ASAP.

Thanks

Hi,

You can simply set the executable bit (+x) on the servoy_server.sh and service/ServoyServer files like so:

cd /path/to/servoy/application_server
chmod +x servoy_server.sh
chmod +x service/ServoyServer

After this you can launch Servoy server using the servoy_server.sh shell script or you can install it as a service (and start it) using the ServoyServer script.

Hope this helps.

ROCLASI:
Hi,

You can simply set the executable bit (+x) on the servoy_server.sh and service/ServoyServer files like so:

cd /path/to/servoy/application_server

chmod +x servoy_server.sh
chmod +x service/ServoyServer



After this you can launch Servoy server using the servoy_server.sh shell script or you can install it as a service (and start it) using the ServoyServer script.

Hope this helps.

I followed the steps, but on the install it still came up with the same error.

I also tried to run the service after making these changes but still no luck.

Have I missed something?

What error are you getting?
Also did you install the EnterpriseDB PostgreSQL installer or the Servoy bundled one ?

Hi Laurian,

lvostinar:
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.

ROCLASI:
What error are you getting?
Also did you install the EnterpriseDB PostgreSQL installer or the Servoy bundled one ?

Hi again, I followed the instructions - it started - showing a PID.

After about 5 seconds the service had stopped again - never to restart.

This is the error at terminal level (not very helpful)

WARNING: Servoy Application Server may have failed to start.
server:application_server administrator$

Can someone send the files that are missing?

As a matter of course - I receive exactly the same error on install as above.

I meant to also say that I used the Enterprise version of Postgres

itgenetics:

ROCLASI:
What error are you getting?
Also did you install the EnterpriseDB PostgreSQL installer or the Servoy bundled one ?

Hi again, I followed the instructions - it started - showing a PID.

After about 5 seconds the service had stopped again - never to restart.

This is the error at terminal level (not very helpful)

WARNING: Servoy Application Server may have failed to start.
server:application_server administrator$

Can someone send the files that are missing?

As a matter of course - I receive exactly the same error on install as above.

What error do you have in the service log?

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:

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 :)

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.(Za.java:1410)
at com.servoy.j2db.server.Za.Za.(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!

Seems to me it cannot connect to repository server. Are you sure connection data is ok and repository is initialized?

are there any tests I can perform?

ROCLASI:
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:

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 <img src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" />

I’ll try this and and come back to you all…