# SQL repository database server not starting (Mac OS X) **URL:** \ **Category:** Classic Servoy\ **Created:** [August 29, 2005, 6:13pm UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667 "2005-08-29T18:13:58Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [August 29, 2005, 6:13pm UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/1 "2005-08-29T18:13:58Z")
Hello All I followd the Servoy Developer User Guide to create a database connection. I am stuck at the point, where I stop the SQL repository database server. Servoy doesn’t start the server any more and I get an error message (see attachemnt). It seems to be the process sybase\_db/dbsrv9 @sybase\_db/sybase.config in the process list. How can I start this process again? Best regards, Robert PS: Hopefully this time with attachment ![Picture 3.jpg](https://canada1.discourse-cdn.com/flex010/uploads/servoy/original/2X/6/61c04e5e2e3385592257350393d0c93a5429e309.jpeg) ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 29, 2005, 10:19pm UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/2 "2005-08-29T22:19:02Z")
Hello Robert, Are all your databases in a location that your sybase.config points to? ---
**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:** [August 30, 2005, 6:57am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/3 "2005-08-30T06:57:03Z")
Hello Marcel I added one database into location /Applications/Servoy/database/ where all the other Servoy installed databases (like crm.db, example.db …) reside (are installed by default at installation). Best regards, Robert > IT2BE: > Hello Robert, > > Are all your databases in a location that your sybase.config points to? ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:03am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/4 "2005-08-30T07:03:42Z")
OK, so that is putting your physical database file into the location but what about the sybase.config file that is in your servoy root/sybase\_db/ directory? Did you modify that to point to the file too? ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 30, 2005, 7:16am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/5 "2005-08-30T07:16:12Z")
Like Marcel said are you sure that Sybase opens the repository database? Unlike database engines like MySQL and PostgreSQL Sybase has to be told what database it has open for you to connect to. ---
**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:** [August 30, 2005, 7:17am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/6 "2005-08-30T07:17:19Z")
Hello Marcel Yes, I added the entry fo the db. My sybase.config file looks like this -ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase\_db/sybase\_log.txt database/servoy\_repository.db database/user\_data.db database/example.db database/log\_data.db database/crm.db database/SoaringSky.db where the last line is the newly added db. I think the problem is that the server proces (sybase\_db/dbsrv9 @sybase\_db/sybase.config) is not running (as daemon process). Before I was quitting the process (see my initial post) everythin was ok. But after restarting Servoy, this process did not start again. So I assume I have to start it somehow manually. Best regards, Robert ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 30, 2005, 7:22am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/7 "2005-08-30T07:22:03Z")
Can you check the sybase\_log.txt for errors? You find it in /Applications/servoy/sybase\_db/. Btw are you launching Developer or Server ? ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:23am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/8 "2005-08-30T07:23:17Z")
Yes and no ![:)]( "Smile") Nope, when the db’s are not running servoy developer will start them for you. When you run the server however you have to start them manually. ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:26am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/9 "2005-08-30T07:26:40Z")
Don’t know for sure if and what it will help but my first line looks like this:``` -ti 0 -x tcpip{dobroadcast=no} -qs -qw -o ../Servoy/sybase\_db/sybase\_log.txt ```auto ``` ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 30, 2005, 7:35am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/10 "2005-08-30T07:35:06Z")
Mine has a slightly different path: ```auto -ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase_db/sybase_log.txt ``` Edit: Looking again at your path it does the same thing as mine. ---
**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:** [August 30, 2005, 7:37am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/11 "2005-08-30T07:37:11Z")
hello Robert This is my sybase\_log I. 08/29 19:36:13. Database server started at Mon Aug 29 2005 19:36 I. 08/29 19:36:13. Trying to start SharedMemory link … I. 08/29 19:36:13. SharedMemory link started successfully I. 08/29 19:36:13. Trying to start TCPIP link … I. 08/29 19:36:13. Starting on port 2638 I. 08/29 19:36:13. TCPIP link started successfully I. 08/29 19:36:13. Now accepting requests E. 08/29 19:56:51. Database cannot be started – server must be upgraded to start “/Applications/Servoy/database/SoaringSky.db” (capability 35 missing). E. 08/29 19:59:46. Database cannot be started – server must be upgraded to start “/Applications/Servoy/database/SoaringSky.db” (capability 35 missing). I assume E. stands for Error and that seems to be the problem. The db is not started by the developer (I use Servoy Developer). The Developer should do that automatically (but doesn’t), shouldn’t it? What is capability 35? Regards, Robert > ROCLASI: > Can you check the sybase\_log.txt for errors? > You find it in /Applications/servoy/sybase\_db/. > > Btw are you launching Developer or Server ? ---
**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:** [August 30, 2005, 7:39am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/12 "2005-08-30T07:39:06Z")
hello Robert I think the repository database is not opened by Sybase, but I thought Servoy Developer does start that? Regards, Robert > ROCLASI: > Like Marcel said are you sure that Sybase opens the repository database? > Unlike database engines like MySQL and PostgreSQL Sybase has to be told what database it has open for you to connect to. ---
**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:** [August 30, 2005, 7:41am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/13 "2005-08-30T07:41:26Z")
Hello Robert I have the same first line as you have. Best regards, Robert > ROCLASI: > Mine has a slightly different path: > > ```auto > -ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase_db/sybase_log.txt > > ``` > > Edit: > Looking again at your path it does the same thing as mine. ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:41am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/14 "2005-08-30T07:41:52Z")
From what I read here you have created your database with a different (read higher) version of iAnywhere. Is that possible? ---
**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\ **Post date:** [August 30, 2005, 7:44am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/15 "2005-08-30T07:44:35Z")
Robert, Did you by any chance created the Sybase database with Sybase Central 9.02? Servoy uses Sybase iAnywhere 9.0.1. They don’t seem to be compatible. Make sure you create the database with the Servoy provided dbinit (see /Applications/Servoy/sybase\_db/) It seems when Sybase encounters an error it quits on you so that is the reason why the repository database won’t open. Hope this helps. ---
**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:** [August 30, 2005, 7:47am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/16 "2005-08-30T07:47:14Z")
Hello Marcel I tried your path but still get the same message of my initial post Can’t connect to the repository server so I assume it’s safe to say the repository db is not up (whatever that exactly is, I don’t know yet .-) Regards, Robert ---
**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:** [August 30, 2005, 7:51am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/17 "2005-08-30T07:51:50Z")
Robert, Marcel YES, I created the db with Sybase Central 9.02. So that seems to be the problem!? Is this a reported problem to Servoy and what is their solution? Best regards and thanks a lot for your help, Robert ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:52am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/18 "2005-08-30T07:52:48Z")
The repository db is the db that is used to hold your solution data. It is THE main database we need to develop and deploy our solution. Marcel ---
**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\ **Post date:** [August 30, 2005, 7:53am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/19 "2005-08-30T07:53:29Z")
Servoy is aware and you should go with the tip Robert provided… ---
**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:** [August 30, 2005, 7:56am UTC](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667/20 "2005-08-30T07:56:57Z")
Ok, I will go with this tip and do it on command line level. Regards, Robert > IT2BE: > Servoy is aware and you should go with the tip Robert provided… [Next page](https://forum.servoy.com/t/sql-repository-database-server-not-starting-mac-os-x/4667.md?page=2)