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