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:[email protected]: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
[email protected])
* 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:[email protected]: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) | YES | | NULL
| |
| c_path4 | varchar(255) | YES | | NULL
| |
| c_foldername | varchar(255) | NO | | NULL
| |
| c_location | varchar(2048) | NO | | NULL
| |
| c_quick_location | varchar(2048) | YES | | NULL
| |
| c_acl_location | varchar(2048) | YES | | NULL
| |
| c_folder_type | varchar(255) | NO | | NULL
| |
+------------------+---------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)
mysql> describe sogo_sessions_folder;
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| c_id | varchar(255) | NO | PRI | NULL | |
| c_value | varchar(255) | NO | | NULL | |
| c_creationdate | int(11) | NO | | NULL | |
| c_lastseen | int(11) | NO | | NULL | |
+----------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> describe sogo_user_profile;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| c_uid | varchar(255) | NO | PRI | NULL | |
| c_defaults | text | YES | | NULL | |
| c_settings | text | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> describe sogo_users;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| c_uid | varchar(60) | NO | PRI | NULL | |
| c_name | varchar(60) | YES | | NULL | |
| c_password | varchar(32) | YES | | NULL | |
| c_cn | varchar(128) | YES | | NULL | |
| mail | varchar(128) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
The latest log extract is here:
======
May 29 19:26:57 sogod [25083]: version 2.2.17a (build @shiva.inverse
201503261625) -- starting
May 29 19:26:57 sogod [25083]: vmem size check enabled: shutting down app
when vmem > 384 MB
May 29 19:26:57 sogod [25083]: <0x0x7fd85f9471e8[SOGoProductLoader]> SOGo
products loaded from '/usr/lib/GNUstep/SOGo':
May 29 19:26:57 sogod [25083]: <0x0x7fd85f9471e8[SOGoProductLoader]>
ContactsUI.SOGo, Contacts.SOGo, Appointments.SOGo, AdministrationUI.SOGo,
SchedulerUI.SOGo, CommonUI.SOGo, ActiveSync.SOGo, PreferencesUI.SOGo,
MailerUI.SOGo, MainUI.SOGo, Mailer.SOGo, MailPartViewers.SOGo
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> listening on
127.0.0.1:20000
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> watchdog
process pid: 25083
May 29 19:26:58 sogod [25083]: <0x0x7fd85d4106c0[WOWatchDogChild]> watchdog
request timeout set to 10 minutes
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> preparing 3
children
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> child spawned
with pid 25086
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> child spawned
with pid 25087
May 29 19:26:58 sogod [25083]: <0x0x7fd85f735c08[WOWatchDog]> child spawned
with pid 25088
2015-05-29 19:26:58.091 sogod[25088] MySQL4 connection established
0x0x7fd85f75f060
2015-05-29 19:26:58.091 sogod[25087] MySQL4 connection established
0x0x7fd85f75f060
2015-05-29 19:26:58.092 sogod[25088] MySQL4 channel 0x0x7fd85fb29708 opened
(connection=0x0x7fd85f75f060,sogo)
2015-05-29 19:26:58.092 sogod[25087] MySQL4 channel 0x0x7fd85fb29708 opened
(connection=0x0x7fd85f75f060,sogo)
2015-05-29 19:26:58.092 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_user_profile;
2015-05-29 19:26:58.091 sogod[25086] MySQL4 connection established
0x0x7fd85f75f060
2015-05-29 19:26:58.092 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_user_profile;
2015-05-29 19:26:58.092 sogod[25086] MySQL4 channel 0x0x7fd85fb29708 opened
(connection=0x0x7fd85f75f060,sogo)
2015-05-29 19:26:58.092 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_user_profile;
2015-05-29 19:26:58.092 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.092 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.092 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.092 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_folder_info;
2015-05-29 19:26:58.092 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_folder_info;
2015-05-29 19:26:58.092 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_folder_info;
2015-05-29 19:26:58.092 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.092 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.092 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.097 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-05-29 19:26:58.097 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-05-29 19:26:58.097 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT count(*) FROM sogo_sessions_folder;
2015-05-29 19:26:58.097 sogod[25086] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.097 sogod[25087] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
2015-05-29 19:26:58.097 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
May 29 19:27:20 sogod [25088]: |SOGo| starting method 'GET' on uri '/SOGo/'
May 29 19:27:20 sogod [25088]: <0x0x7fd85f9eef68[SOGoCache]> Cache cleanup
interval set every 300.000000 seconds
May 29 19:27:20 sogod [25088]: <0x0x7fd85f9eef68[SOGoCache]> Using host(s)
'/var/run/memcached.sock' as server(s)
May 29 19:27:20 sogod [25088]: [ERROR] <0x0x7fd85f7edd58[NGBundleManager]>
could not create bundle for path:
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.24/Resources/SSL.bundle'
May 29 19:27:20 sogod [25088]: [WARN] <0x0x7fd85d4312c0[WOxElemBuilder]>
could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
May 29 19:27:20 sogod [25088]: [ERROR] <0x0x7fd85fdd05a8[SOGoUserManager]>
No authentication sources defined - nobody will be able to login. Check
your defaults.
2015-05-29 19:27:20.840 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> SQL: SELECT c_defaults FROM sogo_user_profile
WHERE c_uid = 'anonymous';
2015-05-29 19:27:20.840 sogod[25088] <MySQL4Channel[0x0x7fd85fb29708]
connection=0x0x7fd85f75f060> query has results, entering fetch-mode.
May 29 19:27:20 sogod [25088]: |SOGo| constructed root-url: /SOGo/
May 29 19:27:20 sogod [25088]: |SOGo| setting root-url in context: /SOGo/
May 29 19:27:20 sogod [25088]: |SOGo| ROOT baseURL(no container,
name=(null)):
own: /SOGo/
May 29 19:27:20 sogod [25088]: |SOGo| request took 0.315834 seconds to
execute
May 29 19:27:20 sogod [25088]: 10.10.10.8 "GET /SOGo/ HTTP/1.1" 200 3906/0
0.353 12384 68% 3M
May 29 19:27:26 sogod [25088]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'
May 29 19:27:26 sogod [25088]: SOGoRootPage Login from '10.10.10.8' for
user 'rkinne' might not have worked - password policy: 65535 grace: -1
expire: -1 bound: 0
May 29 19:27:26 sogod [25088]: |SOGo| request took 0.000986 seconds to
execute
May 29 19:27:26 sogod [25088]: 10.10.10.8 "POST /SOGo/connect HTTP/1.1" 403
34/64 0.002 - - 32K
--
[email protected]
https://inverse.ca/sogo/lists
