Hello, 1) Have you tried to check the mysql log for any related message ? 2) Can you connect to my sql, using tcp/ip, with the same account ? 3) May be you can try plain password first
Regards Le 14/09/2011 00:21, Christoph a écrit :
Hi, we are using SOGo in a couple of environments and are very happy with it. Thanks for the great work to the developers! Now it's the first time that I need to authenticate against a mysql database instead of ldap. I read everything I could find, but I'm not able to get it to work. Everytime I try to log into SOGo I get the following error in /var/log/sogo/sogo.log: Sep 13 23:40:53 sogod [16764]: SOGoRootPage Login for user '[email protected]' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 My .GNUsetpDefaults looks like this: ================================================================================ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml";> <plist version="0.9"> <dict> <key>NSGlobalDomain</key> <dict> </dict> <key>sogod</key> <dict> <key>OCSEMailAlarmsFolderURL</key> <string>mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_alarms_folder</string> <key>OCSFolderInfoURL</key> <string>mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_folder_info</string> <key>OCSSessionsFolderURL</key> <string>mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_sessions_folder</string> <key>SOGoACLsSendEMailNotifications</key> <string>YES</string> <key>SOGoAppointmentSendEMailNotifications</key> <string>YES</string> <key>SOGoAppointmentSendEMailReceipts</key> <string>YES</string> <key>SOGoCalendarDefaultRoles</key> <array> <string>PublicViewer</string> <string>ConfidentialDandTViewer</string> </array> <key>WOUseRelativeURL</key> <string>YES</string> <key>SOGoDraftsFolderName</key> <string>INBOX/Drafts</string> <key>SOGoEnableEMailAlarms</key> <string>YES</string> <key>SOGoEnablePublicAccess</key> <string>YES</string> <key>SOGoFoldersSendEMailNotifications</key> <string>YES</string> <key>SOGoForwardEnabled</key> <string>YES</string> <key>SOGoIMAPServer</key> <string>localhost</string> <key>SOGoLanguage</key> <string>German</string> <key>SOGoMailComposeMessageType</key> <string>text</string> <key>SOGoMailDomain</key> <string>example.org</string> <key>SOGoMailMessageCheck</key> <string>every_minute</string> <key>SOGoMailReplyPlacement</key> <string>above</string> <key>SOGoMailShowSubscribedFoldersOnly</key> <string>NO</string> <key>SOGoMailSignaturePlacement</key> <string>above</string> <key>SOGoMailingMechanism</key> <string>smtp</string> <key>SOGoOtherUsersFolderName</key> <string>INBOX/user</string> <key>SOGoProfileURL</key> <string>mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_user_profile</string> <key>SOGoSMTPServer</key> <string>localhost</string> <key>SOGoSentFolderName</key> <string>INBOX/Sent Items</string> <key>SOGoSharedFolderName</key> <string>INBOX/shared</string> <key>SOGoSieveScriptsEnabled</key> <string>YES</string> <key>SOGoForceIMAPLoginWithEmail</key> <string>YES</string> <key>SOGoSuperUsernames</key> <array> <string>sogo</string> <string>[email protected]</string> </array> <key>SOGoTimeFormat</key> <string>%H:%M</string> <key>SOGoTimeZone</key> <string>Europe/Berlin</string> <key>SOGoTrashFolderName</key> <string>INBOX/Trash</string> <key>SOGoUserSources</key> <array> <dict> <key>type</key> <string>sql</string> <key>id</key> <string>database</string> <key>viewURL</key> <string>mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_view</string> <key>userPasswordAlgorithm</key> <string>sha</string> <key>canAuthenticate</key> <string>YES</string> <key>isAddressBook</key> <string>YES</string> <key>displayname</key> <string>SOGoAdressBook</string> </dict> </array> <key>SOGoVacationEnabled</key> <string>YES</string> </dict> </dict> </plist> ================================================================================ I have created the view sogo_view with this command: ================================================================================ mysql> use sogo; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> create or replace ALGORITHM = MERGE view sogo_view as select concat(local_part,'@example.org') as c_uid, concat(local_part,'@example.org') as c_name, password as c_password, name as c_cn, concat(local_part,'@example.org') as mail from vboxadm.mailboxes where is_active = 1; mysql> desc sogo_view -> ; +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | c_uid | varchar(74) | NO | | | | | c_name | varchar(74) | NO | | | | | c_password | longtext | NO | | NULL | | | c_cn | varchar(255) | NO | | NULL | | | mail | varchar(74) | NO | | | | +------------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> mysql> select * from sogo_view; +------------------------+----------------------+-----------------------------------+-----------------------+-----------------------+ | c_uid | c_name | c_password | c_cn | mail | +-----------------------+-----------------------+-----------------------------------+-----------------------+-----------------------+ | [email protected] | [email protected] | {SHA}AAAAAAAAAAAAAAAAAAAAAAAAAAAA | [email protected] | [email protected] | | [email protected] | [email protected] | {SHA}BBBBBBBBBBBBBBBBBBBBBBBBBBBB | Christoph M. | [email protected] | | [email protected] | [email protected] | {SHA}CCCCCCCCCCCCCCCCCCCCCCCCCCCC | Ela A. | [email protected] | +-----------------------+-----------------------+-----------------------------------+-----------------------+-----------------------+ 3 rows in set (0.00 sec) =============================================================================== I'm using dovecot, vboxadm and postfix. SOGo version is 1.3.8b on Ubuntu 10.04.3 LTS. If anyone has an ideas where my mistake is please let me know Thanks in advance Christoph
-- -- [email protected] https://inverse.ca/sogo/lists
