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
