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
Hello Robert,
Are all your databases in a location that your sybase.config points to?
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?
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?
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.
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
Can you check the sybase_log.txt for errors?
You find it in /Applications/servoy/sybase_db/.
Btw are you launching Developer or Server ?
Yes and no
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.
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
Mine has a slightly different path:
-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.
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 ?
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.
Hello Robert
I have the same first line as you have.
Best regards, Robert
ROCLASI:
Mine has a slightly different path:-ti 0 -x tcpip{dobroadcast=no} -qs -qw -o sybase_db/sybase_log.txtEdit:
Looking again at your path it does the same thing as mine.
From what I read here you have created your database with a different (read higher) version of iAnywhere. Is that possible?
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.
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
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
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
Servoy is aware and you should go with the tip Robert provided…
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…