02-12-2019 01:11 AM
sorry for my poor english .....
but I do not understand your solution.....
the problem is the library:
in the table "connection", field "connectionstring" the password is readable
host=192.168.5.4 dbname=civici2018 user=pippone password=test2019 port=5432
this thing is not beautiful ....
02-12-2019 01:45 AM
the password is a password to a 3rd party database, so the software which reads the library (GeoMedia, WebMap) must get the password and pass it to the database upon connection. Even if we know the hash algorithm the database internally use for password storage, it would not help us, since we could not recover the password from the hash, and there is usually no way to pass the password hash to the database directly.
So please advise, how should the password in the library be stored. It perhaps could be a simple cipher, which would obviously be easily to crack, and thus would have not a big benefit. So the only other options are:
There is nothing much more to do about it.
02-12-2019 07:05 AM
If the default value for the following registery is set to 0 (zero) then the password will NOT be stored in the library.
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\GDO\PostGIS Read-Write\1.0\Store Password
After the edit, the connect string for the library might look like the following:
host=myserver dbname=mydatabase user=wile_coyote password=* port=5432
I'm sure this falls short of your expectatons but wanted other readers to know that it is possible to suppress the storage of the password.