Re: [SOGo] Using users (login, password) of Plesk-database
On 26-9-2012 22:13, Holger Biber wrote: Hi Christian, Am 26.09.2012 14:24, schrieb Christian Mack: On 2012-09-24 18:45, Holger Biber wrote: Hi, I've several users (approx. 100) in a Plesk-database used for my old webmailer (Horde). These logins and the passwords are stored in different tables of the same database. How could I connect or synchronize the Sogo-MySql-Connector with these tables? Just create a VIEW matching the requirements of SOGo, which collects the data from the existing TABLEs. sorry for the question, but could you explain me the way to create the VIEW. What do you mean with VIEW ? How to use this for sogo? Is there any documentation for this? A VIEW is a database object that embodies the result of an SQL query. It looks much like a table but does a query behind the scenes to get the data. It's (fortunately) fairly basic SQL stuff. Have a look at your database documentation for what is. Or google view mysql. Hint: CREATE VIEW In this case, you're using it to create a table that Sogo wants to see with the columns it wants to see by getting its data from your existing tables. Have a look at the sogo documentation to see what columns Sogo expects to see as well as the name of the view (which is the table name Sogo expects). -- Regards, jb -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Using users (login, password) of Plesk-database
On 2012-09-24 18:45, Holger Biber wrote: Hi, I've several users (approx. 100) in a Plesk-database used for my old webmailer (Horde). These logins and the passwords are stored in different tables of the same database. How could I connect or synchronize the Sogo-MySql-Connector with these tables? Just create a VIEW matching the requirements of SOGo, which collects the data from the existing TABLEs. Are there any other solutions to import / synchronize existing user databases with sogo (LDAP or SQL)? Google for identity management systems. The best solution would be the auth against the local IMAP/POP3-Server, but if I understand the docs there is no IMAP-authentification. There is IMAP authentication, but this is not used for login into SOGo. It is only used to get access to IMAP itself. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Using users (login, password) of Plesk-database
Hi, I've several users (approx. 100) in a Plesk-database used for my old webmailer (Horde). These logins and the passwords are stored in different tables of the same database. How could I connect or synchronize the Sogo-MySql-Connector with these tables? Are there any other solutions to import / synchronize existing user databases with sogo (LDAP or SQL)? The best solution would be the auth against the local IMAP/POP3-Server, but if I understand the docs there is no IMAP-authentification. Thanks for any hints. Bye and best regards Holger -- users@sogo.nu https://inverse.ca/sogo/lists