Server with name 'udm' is not found

Classic Servoy
1

I just installed Servoy 7. I am trying to import the sample solutions. When I import I get Server not found. Server with the name ‘udm’ is not found, but used by the import solution, select another server to use or press cancel to define the server first.

How do I fix this problem and get the samples working?

2

Hi,

I see this is your first post, welcome to servoy community forum.

Before you import the solution just create the server with name ‘udm’.

Steps :

  1. Expand the resources node.
  2. Right click on the ‘Database server’ node and create the server. (Select the database you are using). Default is postgreSql which is bundled with servoy.
  3. Provide a name, in your case its ‘udm’, and save it.
  4. Now import the solution and you should be good to go.
  5. And note down the other server names if it prompts again and create them as above.

Thanks

3

Thanks for the response. Creating a new database is not available. The options are grayed out when I right click and select Create new database. “Create PostgreSQL Database” and “Create Sybase Database” are grayed out. Seems like the database didn’t get installed or isn’t running. How can I check that?

4

rrl,

It seems that something went wrong with the postgres install we bundle.

Did you select the ‘install bundled postgres’ option when installing?
It is on by default.

If yes, check the /path/to/servoy/application_server/postgres_db directory, it should contain bin, lib and other things.

What OS are you using?

Rob

5

I do have a postgres_db folder with \bin (51 items) \lib (88 items) \share (21 items)
I am running Windows Server 2008 R2 Standard.

When I installed Servoy the step that asks for the database port defaulted to 5432 and when I clicked “check availability” it found my next port number was in the 60,000 range. When I changed the port to 6x,xxx, clicking on the next button did nothing in the install wizard. Therefore I left the db port at the default to continue the installation. So is there a port conflict, is the db actually running?

6

rrl,

I guess something went wrong when you started changing the port nr.

Some things to check:

  • is the start-db-command set?
    See Window->Preferences->Servoy->Startup, the startup launcher should be something like
%%user.dir%%/postgres_db/bin/pg_ctl|start|-D|database|-l|postgres_db/postgres_log.txt

  • is postgres running? you should see that in your win task manager

  • what port is set in the server editors in the jdbc url?
    See SolutionExplorerView->Database Sercvers->udm->righ-click->open server

  • is the postgres port set to default, see
    /path/to/servoy/application_server/database/postgresql.conf

  • check the logs /path/to/servoy/application_server/servoy_log.txt

Rob