Re: [SOGo] General Question
On 10/09/2015 08:17 AM, Christian Eichert wrote: OK, so it looks like I need a example of using SogoUserSources with Mysql Can someone help please? Am 09-10-2015 um 13:29 schrieb Christian Eichert: I am a bit confused about SOGo It looks to be a nice combination of webmail calendar and addressbook. I have installed it and configured it as best I can, (of course its not working yet, else everybody would use it) and now I reached the point where it comes to the user configuration. I am using Dovecot with Postfix and virtual users in a MySQL database. Now SOG is demanding a LDAP usermanagement. Is there a way to access this already existing user database I am using with dovecot? mfg Christian Eichert Have you looked in '/etc/sogo/sogo.conf'? /* SQL authentication example */ /* These database columns MUST be present in the view/table: *c_uid - will be used for authentication - it's the username or usern...@domain.tld) *c_name - which can be identical to c_uid - will be used to uniquely identify entries *c_password - password of the user, plain-text, md5 or sha encoded for now *c_cn - the user's common name - such as "John Doe" *mail - the user's mail address * See the installation guide for more details */ //SOGoUserSources = // ( //{ // type = sql; // id = directory; // viewURL = "mysql://sogo:$Isaiah53@127.0.0.1:3306/sogo/sogo_view"; // canAuthenticate = YES; // isAddressBook = YES; // userPasswordAlgorithm = md5; //} // ); That plus the Installation guide should walk you through it. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] General Question
users-requ...@sogo.nu wrote on 09.10.2015 14:17:06: > > OK, so it looks like I need a example of using SogoUserSources with Mysql > Can someone help please? I installed such a setup a few months ago (using MySQL for authentication for both Postfix/Dovecot and SOGo). I used this as a (german) guideline: https://www.foteviken.de/?p=1247 It is not perfect but I was able to get my server up and running this way. Kai-Uwe Rommel kai-uwe.rom...@ars.de Telefon+Mobil +49 89 32468-120 Veranstaltungshinweis: ARS Konferenz "ARScon ? Strategien von morgen" am 15.10.2015 in der Allianz Arena Muenchen http://www.ars.de/konferenz ARS Computer und Consulting GmbH, http://www.ars.de Ridlerstrasse 37, 80339 Muenchen, Deutschland Individuelle Softwareentwicklung, Beratung und Projekte IBM Software, IBM Lizenzmanagement IT-Infrastrukturservices Handelsregister Muenchen, HRB 101829, USt-ID: DE 155 068 909 Geschaeftsfuehrer: Michael Arbesmeier, Kai-Uwe Rommel, Roland Schock, Joachim Gucker -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] General Question
I am a bit confused about SOGo It looks to be a nice combination of webmail calendar and addressbook. I have installed it and configured it as best I can, (of course its not working yet, else everybody would use it) and now I reached the point where it comes to the user configuration. I am using Dovecot with Postfix and virtual users in a MySQL database. Now SOG is demanding a LDAP usermanagement. Is there a way to access this already existing user database I am using with dovecot? mfg Christian Eichert -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] General Question
OK, so it looks like I need a example of using SogoUserSources with Mysql Can someone help please? Am 09-10-2015 um 13:29 schrieb Christian Eichert: I am a bit confused about SOGo It looks to be a nice combination of webmail calendar and addressbook. I have installed it and configured it as best I can, (of course its not working yet, else everybody would use it) and now I reached the point where it comes to the user configuration. I am using Dovecot with Postfix and virtual users in a MySQL database. Now SOG is demanding a LDAP usermanagement. Is there a way to access this already existing user database I am using with dovecot? mfg Christian Eichert -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] General Question
Installation handbook, page 31, "Authentication using SQL" … On 2015-10-09 13:29, Christian Eichert wrote: > I am a bit confused about SOGo > It looks to be a nice combination of webmail calendar and addressbook. > > I have installed it and configured it as best I can, (of course its not > working yet, else everybody would use it) and now I reached the point > where it comes to the user configuration. I am using Dovecot with > Postfix and virtual users in a MySQL database. > > Now SOG is demanding a LDAP usermanagement. > Is there a way to access this already existing user database I am using > with dovecot? > > mfg > Christian Eichert -- Mit freundlichen Grüßen, / Best Regards, Sven Schwedas Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167 http://software.tao.at signature.asc Description: OpenPGP digital signature
Re: [SOGo] General Question
Hello. Den 09-10-2015 kl. 13:29 skrev Christian Eichert: I am a bit confused about SOGo It looks to be a nice combination of webmail calendar and addressbook. I have installed it and configured it as best I can, (of course its not working yet, else everybody would use it) and now I reached the point where it comes to the user configuration. I am using Dovecot with Postfix and virtual users in a MySQL database. Now SOG is demanding a LDAP usermanagement. Is there a way to access this already existing user database I am using with dovecot? yes read authentication using sql https://github.com/inverse-inc/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc#authentication-using-sql i use it for multiple domains all stored in MySQL Regards Christian Jensen -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] General Question
On 10/09/2015 01:29 PM, Christian Eichert wrote: I am a bit confused about SOGo It looks to be a nice combination of webmail calendar and addressbook. I have installed it and configured it as best I can, (of course its not working yet, else everybody would use it) and now I reached the point where it comes to the user configuration. I am using Dovecot with Postfix and virtual users in a MySQL database. Now SOG is demanding a LDAP usermanagement. Is there a way to access this already existing user database I am using with dovecot? Hi Christian, I don't think SOGo is demanding LDAP, you can also use SQL for example. (see manual page 31). But I wouldn't try to extend an existing database with the needed tables as if there are sql updates in newer versions of SOGo There is another thread [1] from 2012 regarding the similar issue and Christian Mack mentioned creating a view which collects the data from existing tables. Regards Peter [1] https://lists.inverse.ca/sogo/arc/users/2012-09/msg00288.html -- users@sogo.nu https://inverse.ca/sogo/lists