I have installed Servoy on win2003 and I have noticed that I cannot access /servoy-admin/ without first starting developer. How do I get the app server to iniate automatically without having to start developer first.
Thanks in advance.
Servoy server doesn’t start the database automatically, like Developer. Check your servoy_log.txt, there are probably some exceptions about connecting to the database.
Before you start the server, you have to make sure that your database is running. See the Server guide for more info on running Servoy server and sybase.
I have downloaded v11 of sybase, register and installed.
I have fully pathed the log file and db files in the sybase.config file, configured the service as per the manual, with parameters, but every time I go to start the service sybase central hangs, no windows service is created. The console just says “start pending”
Any ideas would be great. Thx
Hi James!
If I recall it well, I stumbled upon this one too!
And I finally found out that something was wrong in the Server Admin Guide pdf: the parameter to use for SQL Anywhere service.
Instead of using :
@C:\Program Files\Servoy\application_server\sybase\sybase.config
you should use quotes like this:
@"C:\Program Files\Servoy\application_server\sybase\sybase.config"
Otherwise the path (using spaces) is not poperly regognized.
So you should uninstall your service and start this step again, and it should work.
Thanks, almost worked.
The service is now installed but will not run. Event log reads
Event Type: Error
Event Source: SQLANY 10.0
Event Category: None
Event ID: 1
Date: 8/1/2009
Time: 1:53:31 PM
User: N/A
Computer: ENTERPRISE
Description:
The description for Event ID ( 1 ) in Source ( SQLANY 10.0 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: SQLANYs_ASASERVICE, Could not start server.
Never seen this one.
I will check the sybase.config file to see if the paths to the database are also using quotes, and that there is no typo in the path/names of db used (and that the db files are not missing in the database folder).
FYI, sybase.config looks like this (never changed it after installing as a service, since I don’t really use Sybase except for local repository and tests):
-ti 0 -x tcpip{dobroadcast=no;port=2638} -qs -qw -o
"C:/Program Files/Servoy/application_server/sybase_db/sybase_log.txt"
"C:/Program Files/Servoy/application_server/database/servoy_repository.db"
"C:/Program Files/Servoy/application_server/database/user_data.db"
"C:/Program Files/Servoy/application_server/database/example.db"
"C:/Program Files/Servoy/application_server/database/log_data.db"
"C:/Program Files/Servoy/application_server/database/udm.db"
"C:/Program Files/Servoy/application_server/database/pdf_forms.db"
"C:/Program Files/Servoy/application_server/database/bug_db.db"
You can also check that the sybase_db is writable by the service (for the logs) as well as the database folder of course…
Also, make sure that the 2638 port is not already used, and that sybase is not already open as a program (maybe it has been open by Servoy developer? To be sure, check in the task manager for a process called “dbsrv10.exe”)
Hope this helps.
Thanks for the response,
My sybase.config file is exactly the same
Port 2638 is not in use. verified by netstat - an,
“Everyone & Service” has been given full control permissions on sybase & db folders.
No process is active as you spec. and I have temporarily disabled the local firewall…rebooted. with the same result.
Do I have to use sybase as the repository, can I use mysql?
Yes, you can use MySQL as a repository, although I would try to check about this Sybase before giving up, maybe have a look in Sybase’s forums?
Anyway, to use MySQL, first, make sure your have the jdbc driver’s jar in the application_server/drivers folder.
Then, all you have to do is to create an empty database in your MySQL server, name it “repository_server”, then edit your application_server/ “servoy.properties” file, changing the reference of the server.0 to use this database (change USER and PASSWORD to those of a valid user with DDL rights):
server.0.URL=jdbc\:mysql\://localhost/repository_server
server.0.catalog=<none>
server.0.connectionValidationType=0
server.0.driver=com.mysql.jdbc.Driver
server.0.enabled=true
server.0.maxConnectionsActive=10
server.0.maxConnectionsIdle=10
server.0.maxPreparedStatementsIdle=100
server.0.password=PASSWORD
server.0.schema=<none>
server.0.serverName=repository_server
server.0.userName=USER
When you launch Servoy developer the next time, it will show you this dialog:
[attachment=0]repository_upgrade.gif[/attachment]
Click OK, Servoy will create the tables for you, once finished you will have to restart Servoy.
Of course there will be no samples solutions, but if you need them you can import them from the application_server/solutions/examples folder.
Hope this helps.
James,
I too am having the same problem and I see your question has not been answered yet. I have a novel idea though. Get a Servoy installer for windows 2003, run it, then start the servoy application service and it serves up the demo files. This shouldn’t be so difficult out of the gate. Do you think this is a test to see if you’re worthy of operating Servoy?
Bill Belanger