Thanks Nick. Just a small extension question - For the production environment, is it better to store connection details of a user in MySQL or LDAP?
Thanks Tushar Jain On Fri, Nov 29, 2019 at 10:56 PM Nick Couchman <[email protected]> wrote: > On Wed, Nov 27, 2019 at 10:37 AM Tushar Jain < > [email protected]> wrote: > >> Hi, >> >> I have more than a million users in LDAP to whom i have to give access to >> the same set of connections/connection groups. What would be the easiest >> and the fastest way to do so. >> >> Will writing a small program to upload directly from Excel to Guacamole >> Mysql be a good idea? >> > > I wouldn't go to Excel - I'd write a program in one of any number of > languages that queries LDAP for the user and/or group accounts, and inserts > them into the database. Bindings for both LDAP and MySQL (or PostgreSQL or > SQL Server) are readily available for all sorts of languages - C, C++, C#, > Java, Python - so writing something to do this translation ought to be > reasonably easy. You can also just do a shell script of some sort - for > example, in bash, use "ldapsearch" to query ldap for the required > information, parse it out into some intermediate format (CSV, for example), > and then use the mysql command line to read the data from stdin and insert > it into the database. > > Plenty of options :-). > > -Nick > -- **Disclaimer:* This message and any attachment may contain confidential, proprietary information and is intended only for the individual named. If you are not the original intended recipient and have erroneously received this message, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Hitachi MGRM Net E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Hitachi MGRM Net therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required, please request a hard-copy version. Hitachi MGRM Net Ltd, C - 6/5, Safdarjung Development Area, New Delhi - 110016, India* * * *'Please consider the environment before printing this e-mail'.*
