I don’t really understand what it’s going on. I just installed Servoy without the database but with Developer. Then I created the connection from developer (the database server connection ‘repository_server’), restarted it. Then I started the Server only and it works fine.
This really does not solve the problem. I was trying to create a recipe of Servoy installation without developer. I’ll try the Servoy only installation in two other computers. If it works in other computers (with only 1 server connection defined), as it did for Robert (read his posting above), then the problem is very particular to this machine.
If the recipe works in most computers (another XP, and Windows 2003 and 2008), then I post the recipe with the caveat that if it does not work, then the installation with Developer is required (the only way to troubleshooting it).
Thanks all for your time and advice. It was a good exercise
By installing with developer and successfully creating the servoy_repository connection you used developer to create the correct server definition in the servoy.properties file.
Now all you need to do is to grab the working server.* entries from the working servoy.properties file and use those in your recipe.
Regarding uninstalling developer, you are right, just delete the /path/to/servoy_install/developer and the servoy_workspace directories.
rgansevles:
By installing with developer and successfully creating the servoy_repository connection you used developer to create the correct server definition in the servoy.properties file.
Now all you need to do is to grab the working server.* entries from the working servoy.properties file and use those in your recipe.
Regarding uninstalling developer, you are right, just delete the /path/to/servoy_install/developer and the servoy_workspace directories.
Thanks! I removed the Developer now… However, because I thought that I had a correct definition in the servoy.properties file I thought that it wouldn’t be a problem to change the repository from one backend database to another.
I tried to change the repository_server backend database. I opened the servoy.properties file. I changed the database, password and user in these lines:
Then I tried the -upgradeRepository procedure, but I got the same error than before. See below:
C:\Program Files\Servoy\application_server>servoy_server.bat -upgradeRepository
Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.
Then I tried servoy_server.bat -upgradeRepository with the option flag. I got the error…
C:\Program Files\Servoy\application_server>servoy_server.bat -upgradeRepository flag
Cannot upgrade repository: make a backup of your repository and start server with -upgradeRepository flag.
I know that using Developer does the trick. But, I am trying to do this without Developer. IT shouldn’t need to install Developer.
WHAT ELSE I NEED TO DO TO CHANGE REPOSITORY WITHOUT DEVELOPER?
This exercise of trying to create a recipe for my IT department - and all of us - is becoming painful!
2010-09-30 17:14:37,158 ERROR [main] com.servoy.j2db.util.Debug - Cannot start repository: com.servoy.j2db.persistence.RepositoryException: Error checking repository 2010-09-30 17:14:37,158 ERROR [main] com.servoy.j2db.util.Debug - Do note Servoy server does not start any database!
I gave up about doing this installation without installing developer first. Actually, I think that there are problems with Windows and the installation of PostgreSQL (even with the all-in-one-click installation of Servoy). I will add a post in an existing issue, which really was never resolved: Application Server in Servoy 5.2.1 don’t work !!!.
For now, I am just going to install Servoy 5.2.2 with a MySQL database as the repository server since I need to get the server running in a couple of hours. This is very frustrating!
I’ll follow up on this issue tomorrow. I REALLY want to use PostgreSQL -at least as the repository server. Hopefully, we can do that.
I had the same problem as you had and after some trial and error it seems to work at my end.
there were 2 problems that I had to fix to get it to work:
I had created the dba user in postgresql using instead of using uppercase (DBA) as it was specified in my servoy.properties. I changed the properties file to use lowercase and added the password in plain text just to be sure.
I had created the (empty) databases in pgAdmin using the postgres superuser (dba is not a superuser). Which resulted in the application_server not being able to connect to the tables. I modified the database properties to set dba as the owner. HOWEVER that was not enough I had to change the owner of the public schema to dba AND of all the tables.
Changing the owner of the tables can be done manually from within pgAdmin, but is a bit tedious because you have to change them 1-by-1. Using the following sql statement you can generate the list of SQL-statements for all tables of a database:
select 'ALTER TABLE ' || tablename || ' owner to dba;' from pg_tables where schemaname = 'public';
I hope this helps, it seems to have done the trick for me.