Hello everyone, I have just installed a new installation of sogo on Ubuntu 10.10. I have used mysql as the data store.
I have the daemons running and am able to display the web page. My problem is that I cannot login. I have tried creating a couple of users in the sogo_view table and have tried passwords in clear text, and md5 hashed. All the other tables are empty since ths is my first login attempt. It seems that the communication is happening between sogo and the database, but something fails after the query. I don't know how to debug this any further. Every time the logs give the same result: 2011-12-23 20:32:47.966 sogod[31374] <MySQL4Channel[0x0x116bb10] connection=0x0xf1f9d0> SQL: SELECT c_password FROM sogo_view WHERE c_uid = 'nigel'; 2011-12-23 20:32:47.966 sogod[31374] <MySQL4Channel[0x0x116bb10] connection=0x0xf1f9d0> query has results, entering fetch-mode. Dec 23 20:32:47 sogod [31374]: SOGoRootPage Login for user 'nigel' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 localhost.localdomain - - [23/Dec/2011:20:32:47 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/39 0.002 - - 0 My configuration is below (with passwords changed). <?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>MySQL4DebugEnabled</key> <string>yes</string> <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>SOGoDraftsFolderName</key> <string>Drafts</string> <key>SOGoEnableEMailAlarms</key> <string>YES</string> <key>SOGoFoldersSendEMailNotifications</key> <string>YES</string> <key>SOGoIMAPServer</key> <string>localhost:993</string> <key>SOGoLanguage</key> <string>English</string> <key>SOGoMailComposeMessageType</key> <string>html</string> <key>SOGoMailDomain</key> <string>pegram.homelinux.net</string> <key>SOGoMailMessageCheck</key> <string>every_10_minutes</string> <key>SOGoMailReplyPlacement</key> <string>above</string> <key>SOGoMailSignaturePlacement</key> <string>above</string> <key>SOGoMailingMechanism</key> <string>smtp</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>Sent</string> <key>SOGoTimeZone</key> <string>Australia/Perth</string> <key>SOGoTrashFolderName</key> <string>Trash</string> <key>SOGoUserSources</key> <array> <dict> <key>canAuthenticate</key> <string>YES</string> <key>displayName</key> <string>Pegram Address Book</string> <key>id</key> <string>directory</string> <key>isAddressBook</key> <string>YES</string> <key>type</key> <string>sql</string> <key>userPasswordAlgorithm</key> <string>md5</string> <key>viewURL</key> <string>mysql://sogo:password@localhost:3306/sogo/sogo_view</string> </dict> </array> <key>SoSecurityManagerDebugEnabled</key> <string>yes</string> </dict> </dict> </plist> TIA Nigel -- [email protected] https://inverse.ca/sogo/lists
