General discussion on installation and configuration of SOGo

Text archives Help

[SOGo] Adding, removing users with "sql"-auth in 2.1.1b

Chronological Thread 
  • From: Holger Biber < >
  • To:
  • Subject: [SOGo] Adding, removing users with "sql"-auth in 2.1.1b
  • Date: Fri, 31 Jan 2014 18:33:09 +0100


we are using SOGo 2.1.1b with "sql"-auth on a CentOS with Plesk (POP3/Imap and MySQL/phpMyAdmin are on this machine).

I've added several users via Plesk-interface to our EMail-Users. These users aren't added to sogo-sql-tables automatically. What ist the best way to add them to sogo, too?
Encryption in plesk email-user-database is "$AES-128-CBC$"

Parts from my /etc/sogo/sogo.conf:

SOGoAuthenticationMethod = SQL;
SOGoForceIMAPLoginWithEmail = yes;
SOGoIMAPServer = localhost;
SOGoMailingMechanism = smtp;
SOGoPasswordChangeEnabled = NO;
SOGoSMTPServer = localhost;
SOGoUserSources = (
MultipleBookingsFieldName = "multiple_bookings";
canAuthenticate = YES;
id = directory;
isAddressBook = YES;
kindFieldName = kind;
type = sql;
userPasswordAlgorithm = md5;
viewURL = "mysql://SOGOADM:SOGOADMPW@localhost:3306/sogo/sogo_auth";

How could I change this config to use just IMAP or POP3 authentication for all users. Especially not to enter the full email-adress, i.e. just use "myemailname" to login not " " at the SOGo-weblogin.

Thanks for any hints.
Bye an best regards

  • [SOGo] Adding, removing users with "sql"-auth in 2.1.1b, Holger Biber, 01/31/2014

Archive powered by MHonArc 2.6.18.

Top of page