General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Ubuntu Sogo Mysql Authentication Setup Problem.


Chronological Thread 
  • From: "Richard \"Doc\" Kinne" < >
  • To:
  • Subject: [SOGo] Ubuntu Sogo Mysql Authentication Setup Problem.
  • Date: Fri, 29 May 2015 16:20:34 -0400

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 )
   *    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)        | 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





  • [SOGo] Ubuntu Sogo Mysql Authentication Setup Problem., Richard "Doc" Kinne, 05/29/2015

Archive powered by MHonArc 2.6.18.

Top of page