Install without Developer and database settings

Classic Servoy
1

Hi everybody,

I would like to know how you can install Servoy Server without Developer and then configure your database connection settings? Especially the encrypted password.
How can you modify the password if you don’t have Developer? :roll:

I know that you can change the settings manually in servoy.properties but if you want to keep an encrypted password for db connections how do you do?

2

Good question.
I was going to say the servoy (web) admin pages but that does not work for password settings

If you wish to change the driver, username, or password, it is neccessary to edit the servoy.properties file by hand.

One could argue if this is an omission or additional security.
Maybe it is best to create a feature request for that…

3

Just fill in the unencrypter Password and start the application server: Servoy will then encrypt it automatically for you

4

pbakker:
Just fill in the unencrypter Password and start the application server: Servoy will then encrypt it automatically for you

You mean that the properties file will be edited by Servoy and it will replace the unencrypter Password by its encrypted version and if I open it again I will see something like “server.0.password=encrypted:DCykX67jKoBcARDYloh1PK==” :|

EDIT: I’ve tried it. I’ve edited servoy.properties. Changed “server.0.password=encrypted:DCykX67jKoBcARDYloh1PK==” by “server.0.password=myPWD”. Restarted the service. Re-opened servoy.properties but I still have “server.0.password=myPWD” :(

5

Yes, optimal security

6

pbakker:
Yes, optimal security

I’ve tried it. I’ve edited servoy.properties. Changed “server.0.password=encrypted:DCykX67jKoBcARDYloh1PK==” to “server.0.password=myPWD”. Restarted the service. Re-opened servoy.properties but I still have “server.0.password=myPWD” :(

7

Did you shut down the service first, then edited the properties file and then started the server again?

editing the properties file while the server is running doesn’t help, as it gets overwritten when shutting down/restarting.

Paul

8

pbakker:
Did you shut down the service first, then edited the properties file and then started the server again?

editing the properties file while the server is running doesn’t help, as it gets overwritten when shutting down/restarting.

Paul

I just tried but no change.
Here is what i’ve done: * put back the encrypted password

  • Stopped the service
  • Started the service
  • Tested my solution to verify if the database connection was fine (it was fine)
  • Looked at servoy.properties: still had the encrypted password
  • Stopped the service
  • put back the unencrypted password
  • Started the service
  • Tested my solution to verify if the database connection was fine (it was fine)
  • Looked at servoy.properties: still has the unencrypted password

EDIT: I suspected Servoy to not look at the file to check the password. Or I was even not sure that I modified the correct file. So I’ve put a wrong password to see if I still could connect with my solution. But no, I couldn’t. So it means that I’m modifying the right file and Servoy is using the password I enter (encrypted and unencrypted)

9

You missed the last step: restart the service one more time, for the encrypted PW to be written back to the servoy.properties file

10

pbakker:
You missed the last step: restart the service one more time, for the encrypted PW to be written back to the servoy.properties file

:?: :?: :?: I don’t understand.

I’ve done another test following your last advise:

  • The service was started.
  • I’ve looked at servoy.properties: the unencrypted password was there
  • I’ve stopped the service
  • I’ve started it
  • I’ve stopped the service again
  • I’ve started it again
  • I’ve looked at servoy.properties: the unencrypted password was there

How many time do I have to restart the service for the encrypted password to be entered?

Could you please tell me the exact procedure to make Servoy put the encrypted password into servoy.properties? :roll:
My current state is: Service Started, password is unencrypted.

11

dont edit the properties file itself.
Edit/save the password through the admin pages so that the server will actually write the properties file
If you just start/stop the server the properties arent touched.

12

How do you change the password of an existing database server used by a solution through the admin page? :roll:
The only page allowing to enter a password is the one to add a new database server :(

If I want to modify the servoy.properties file, it’s because I would like to make a custom one that I’ll use for future Servoy installs (to gain time) and also avoiding to install Developer on the server. But also be able to modify a database server password without developer.

13

try to change something else. like a system property or another setting

then the settings are also resaved.

14

Oooh yes I didn’t though about it! Nice workaround :D

By the way, you don’t even have to change any setting in the admin page. Just clicking on the ‘Save Settings’ button and restarting the server will do the job :)

Many thx :mrgreen: