Hi Jonathan, thanks a lot for your offering! If you like to share the script you use to create the database entries, this would be useful for me. For the workshop use-case I indeed create all the accounts in LDAP with random passwords using a script, the SQL part of this is still missing though and I started with creating a user-mapping.xml for Guacamole instead. But in order to be more flexible, when it comes to the creation of additional users/sessions, the database approach seems more convenient.
Thanks a lot and best regards Felix Am Donnerstag, den 10.05.2018, 22:19 +0000 schrieb Jonathan Hankins: > Felix, > > There are some examples of generating the salt and hashing the > password correctly for postgres and mysql in the online docs, for > various programming languages. My use case is similar to yours > (postgres+LDAP.) I needed to create users via script with random > passwords in postgres, and I did it in shell script (bash) using the > openssl(1) to generate the random data, salts and do the hashes, some > bash as glue and psql to load the data in the database. It took me > some trial and error to translate what was in the docs online to work > in bash, and I'd be happy to share my script if it'd be useful to > you. > > -Jonathan Hankins >
signature.asc
Description: This is a digitally signed message part