Database as a service: Mac OS X

Classic Servoy
1

Hi All

I configured a Database as a service: Mac OS X as described in the ServoyServer4AdminGuide.pdf, pages 60ff, without any success. Anyone successful in doing this?

Best regards, Robert

2

Hi All

One of the problem I found ist the path to be wrong in the manual, as it has changed in the reality to: /Applications/Servoy/application_server/sybase_db/ instead of the manual saying /Applications/Servoy/sybase_db/.

If I change all corresponding paths and try to start the dbsrv10 manually in the terminal, I get an error message as seen in the attachment.

Nobody have set up a database as a service successfully yet?

Regards, Robert

invalid database server cmd .png
invalid database server cmd .png1065×783 25.8 KB

3

Hi Robert,

I have also tried to start the sybase dbsrv10 from the terminal without success. Of course I have set the direction path like my installation [/applications/servoy41/application_server/sybase_db/…] and not how discribed in the Servoy ServerAdmin docs. I also tried the startuplauncher string in the terminal, but nothing works although the sybase db ist starting by the startuplauncher and Servoy Developer!?
Some day if we would get a solution for that issue we can create a startupitem for Max OS X with Armadillo http://www.versiontracker.com/dyn/moreinfo/macosx/26051.

Thomas

4

Hi,

Indeed we had to do some more than follow the instructions on the manual, but at the end I succeeded.

Enclosed you will find a zip.file, if you decompress it you’ll see a folder containing 2 documents, StartupParameters.plist and servoy.
First: change the path in de servoy document to the path of your servoy_server.sh file is. You can do it with textEdit. Put the whole folder in Library->Startupitems of your root folder.
Second: change the servoy_server.sh as shown below. Of corse the path should be the true one. Don’t forget to set all your databases in sybase.config.
Restart the computer. The first time it will ask to fix the privileges of the Servoy folder in the Startupitems, do it and restart.
Open your browser at site ‘localhost:8080/servoy-admin’ it should be there.

If not open the terminal and type: ‘sudo /library/startupitems/servoy/servoy start’ he wil complain that a database with the same name has already started… but who cares!
(I guess this is a little bug in OSX)
After a couple of seconds retry the address in the browser.

I hope it helps.

#!/bin/sh

cd /Applications/Servoy4.0/application_server/
export DYLD_LIBRARY_PATH=/Applications/Servoy4.0/application_server/sybase_db
/Applications/Servoy4.0/application_server/sybase_db/dbsrv10 @/Applications/Servoy4.0/application_server/sybase_db/sybase.config &

while true
do
java -Djava.awt.headless=true -Xmx256m -Xms64m -XX:MaxPermSize=128m -classpath .:lib/ohj-jewt.jar:lib/MRJAdapter.jar:lib/compat141.jar:lib/commons-codec.jar:lib/commons-httpclient.jar:lib/activation.jar:lib/antlr.jar:lib/commons-collections.jar:lib/commons-dbcp.jar:lib/commons-fileupload-1.0.jar:lib/commons-logging.jar:lib/commons-pool.jar:lib/dom4j.jar:lib/help.jar:lib/jabsorb.jar:lib/hibernate3.jar:lib/j2db.jar:lib/j2dbdev.jar:lib/jdbc2_0-stdext.jar:lib/jmx.jar:lib/jndi.jar:lib/js.jar:lib/jta.jar:lib/BrowserLauncher2.jar:lib/jug.jar:lib/log4j.jar:lib/mail.jar:lib/ohj-jewt.jar:lib/oracle_ice.jar:lib/server-bootstrap.jar:lib/servlet-api.jar:lib/wicket-extentions.jar:lib/wicket.jar:lib/wicket-calendar.jar:lib/slf4j-api.jar:lib/slf4j-log4j.jar:lib/joda-time.jar:lib/rmitnl.jar:lib/networktnl.jar com.servoy.j2db.server.ApplicationServer “$@” 1>> server.log 2>> server.log
EXITCODE=$?
if [ “$EXITCODE” != 99 ]; then exit $EXITCODE; fi
done

Servoy.zip (1.36 KB)

5

Irene, beware that the use of StartupItems to start daemons in Leopard (MacOS X 10.5) is deprecated, you should use LaunchDaemons. Be preapred to have your service startup broken sooner or later.

6

Hi Nicola,

very interesting answer! Can you please explain how to create a LaunchDeamon for starting the sybase db?!

Thomas

7

I’m sorry but I don’t use Sybase, anyway a good starting point for learning how to operate LaunchDaemon can be found here: http://www.opensource.apple.com/darwinsource/projects/other/launchd-152/launchd/doc/HOWTO.html

There’s also a nice app called Lingon if you don’t like to work in the CLI.

8

Hi Nicola,

Sorry for the late answer… busy, busy, busy…
I use StartupItems because I’ ve found it a couple of years ago in a post and never had problems.
viewtopic.php?t=5914

If I use the launchDaemon I get “permission denied” in my log.