# Database as a service: Mac OS X

**URL:** <https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922>\
**Category:** Classic Servoy\
**Created:** [November 24, 2008, 6:50pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922 "2008-11-24T18:50:48Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\
**Post date:** [November 24, 2008, 6:50pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/1 "2008-11-24T18:50:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\
**Post date:** [November 26, 2008, 10:47am UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/2 "2008-11-26T10:47:25Z")

</div>

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](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/0/05f6d9299e48646b21762000fb333f284a1d3f0c.png)

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [November 27, 2008, 8:54am UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/3 "2008-11-27T08:54:00Z")

</div>

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](http://www.versiontracker.com/dyn/moreinfo/macosx/26051).

Thomas

---

<div class="post-metadata">

**Author:** ![irenem](https://avatars.discourse-cdn.com/v4/letter/i/977dab/32.png) [@irenem](https://forum.servoy.com/u/irenem)\
**Post date:** [November 28, 2008, 9:36am UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/4 "2008-11-28T09:36:07Z")

</div>

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](https://forum.servoy.com/uploads/short-url/pXopEBjNZLiJdxHGHkRxhehqzWE.zip) (1.36 KB)

---

<div class="post-metadata">

**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\
**Post date:** [November 28, 2008, 5:25pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/5 "2008-11-28T17:25:57Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [November 28, 2008, 6:43pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/6 "2008-11-28T18:43:08Z")

</div>

Hi Nicola,

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

Thomas

---

<div class="post-metadata">

**Author:** ![ngervasi](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@ngervasi](https://forum.servoy.com/u/ngervasi)\
**Post date:** [November 28, 2008, 6:48pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/7 "2008-11-28T18:48:39Z")

</div>

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](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.

---

<div class="post-metadata">

**Author:** ![irenem](https://avatars.discourse-cdn.com/v4/letter/i/977dab/32.png) [@irenem](https://forum.servoy.com/u/irenem)\
**Post date:** [December 2, 2008, 3:22pm UTC](https://forum.servoy.com/t/database-as-a-service-mac-os-x/9922/8 "2008-12-02T15:22:58Z")

</div>

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](http://forum.servoy.com/viewtopic.php?t=5914)

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