Hi Folks:
I am trying to set up Sogo on an Ubuntu 14.04 server using mysql as the
authenticator.
I have gotten to a point where the website interface is working, but no one
can log in. The interface says “Wrong username or password.” I’m not sure
what I’m missing.
The log says: May 29 19:27:20 sogod [25088]: [ERROR]
0x0x7fd85fdd05a8[SOGoUserManager] No authentication sources defined -
nobody will be able to login. Check your defaults.
It does seem to be connecting to the database, as far as I can tell. The
tables seem to be there.
I’m missing something basic, but after several days I can’t figure out
what. Any thoughts?
Thanks so much!
—
Doc Kinne
American Assoc. of Variable Star Observers
My sogo.conf is here:
{
/* Database configuration (mysql:// or postgresql://) */
SOGoProfileURL = mysql://sogo:password@localhost
:3306/sogo/sogo_user_profile;
OCSFolderInfoURL = mysql://sogo:password@localhost
:3306/sogo/sogo_folder_info;
OCSSessionsFolderURL = mysql://sogo:password@localhost
:3306/sogo/sogo_sessions_folder;
/* Mail */
SOGoDraftsFolderName = Drafts;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoIMAPServer = localhost;
SOGoSieveServer = sieve://127.0.0.1:4190;
SOGoSMTPServer = 127.0.0.1;
SOGoMailDomain = aavso.org;
SOGoMailingMechanism = smtp;
SOGoForceExternalLoginWithEmail = NO;
SOGoMailSpoolPath = /var/spool/sogo;
SOGoMailMessageCheck = every_5_minutes;
NGImap4ConnectionStringSeparator = /;
/* Notifications */
SOGoAppointmentSendEMailNotifications = YES;
SOGoACLsSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
/* Authentication */
SOGoPasswordChangeEnabled = YES;
/* LDAP authentication example */
//SOGoUserSources = (
// {
type = sql;
userPasswordAlgorithm = md5;
viewURL = mysql://sogo:SOGOSaveUs!@50.198.80.204:3306/sogo/sogo_users
;
//CNFieldName = cn;
//UIDFieldName = uid;
//IDFieldName = uid; // first field of the DN for direct binds
//bindFields = (uid, mail); // array of fields to use for indirect
binds
//baseDN = ou=users,dc=acme,dc=com;
//bindDN = uid=sogo,ou=users,dc=acme,dc=com;
//bindPassword = qwerty;
canAuthenticate = YES;
displayName = SOGo Users;
//hostname = ldap://127.0.0.1:389;
id = users;
isAddressBook = YES;
// }
//);
/* 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:sogo@127.0.0.1:5432/sogo/sogo_view;
// canAuthenticate = YES;
// isAddressBook = YES;
// userPasswordAlgorithm = md5;
//}
// );
/* Web Interface */
SOGoPageTitle = SOGo;
SOGoVacationEnabled = YES;
SOGoForwardEnabled = YES;
//SOGoSieveScriptsEnabled = YES;
//SOGoMailAuxiliaryUserAccountsEnabled = YES;
//SOGoTrustProxyAuthentication = NO;
/* General */
WOWorkersCount = 3;
SOGoTrustProxyAuthentication = YES;
SOGoLanguage = English;
SOGoTimeZone = America/Montreal;
SOGoCalendarDefaultRoles = (
PublicDAndTViewer,
ConfidentialDAndTViewer
);
SOGoSuperUsernames = (sogo, sogo1, sogo2, admin); // This is an array -
keep the parens!
SxVMemLimit = 384;
WOPidFile = /var/run/sogo/sogo.pid;
SOGoMemcachedHost = /var/run/memcached.sock;
/* Debug */
SOGoDebugRequests = YES;
SoDebugBaseURL = YES;
ImapDebugEnabled = YES;
LDAPDebugEnabled = YES;
PGDebugEnabled = YES;
MySQL4DebugEnabled = YES;
SOGoUIxDebugEnabled = YES;
//WODontZipResponse = YES;
WOLogFile = /var/log/sogo/sogo.log;
}
My mysql tables are here:
+--+
| Tables_in_sogo |
+--+
| sogo_folder_info |
| sogo_sessions_folder |
| sogo_user_profile|
| sogo_users |
+--+
4 rows in set (0.00 sec)
mysql describe sogo_folder_info;
+--+-+--+-+-++
| Field| Type| Null | Key | Default |
Extra |
+--+-+--+-+-++
| c_folder_id | bigint(20) unsigned | NO | UNI | NULL|
auto_increment |
| c_path | varchar(255)| NO | PRI | NULL
||
| c_path1 | varchar(255)| NO | | NULL
||
| c_path2 | varchar(255)| YES | | NULL
||
| c_path3 | varchar(255)|