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
'christ...@example.org' 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
keyNSGlobalDomain/key
dict
/dict
keysogod/key
dict
keyOCSEMailAlarmsFolderURL/key
stringmysql://sogo:PASSWORD@localhost:3306/sogo/sogo_alarms_folder/string
keyOCSFolderInfoURL/key
stringmysql://sogo:PASSWORD@localhost:3306/sogo/sogo_folder_info/string
keyOCSSessionsFolderURL/key
stringmysql://sogo:PASSWORD@localhost:3306/sogo/sogo_sessions_folder/string
keySOGoACLsSendEMailNotifications/key
stringYES/string
keySOGoAppointmentSendEMailNotifications/key
stringYES/string
keySOGoAppointmentSendEMailReceipts/key
stringYES/string
keySOGoCalendarDefaultRoles/key
array
stringPublicViewer/string
stringConfidentialDandTViewer/string
/array
keyWOUseRelativeURL/key
stringYES/string
keySOGoDraftsFolderName/key
stringINBOX/Drafts/string
keySOGoEnableEMailAlarms/key
stringYES/string
keySOGoEnablePublicAccess/key
stringYES/string
keySOGoFoldersSendEMailNotifications/key
stringYES/string
keySOGoForwardEnabled/key
stringYES/string
keySOGoIMAPServer/key
stringlocalhost/string
keySOGoLanguage/key
stringGerman/string
keySOGoMailComposeMessageType/key
stringtext/string
keySOGoMailDomain/key
stringexample.org/string
keySOGoMailMessageCheck/key
stringevery_minute/string
keySOGoMailReplyPlacement/key
stringabove/string
keySOGoMailShowSubscribedFoldersOnly/key
stringNO/string
keySOGoMailSignaturePlacement/key
stringabove/string
keySOGoMailingMechanism/key
stringsmtp/string
keySOGoOtherUsersFolderName/key
stringINBOX/user/string
keySOGoProfileURL/key
stringmysql://sogo:PASSWORD@localhost:3306/sogo/sogo_user_profile/string
keySOGoSMTPServer/key
stringlocalhost/string
keySOGoSentFolderName/key
stringINBOX/Sent Items/string
keySOGoSharedFolderName/key
stringINBOX/shared/string
keySOGoSieveScriptsEnabled/key
stringYES/string
keySOGoForceIMAPLoginWithEmail/key
stringYES/string
keySOGoSuperUsernames/key
array
stringsogo/string
stringmailad...@example.org/string
/array
keySOGoTimeFormat/key
string%H:%M/string
keySOGoTimeZone/key
stringEurope/Berlin/string
keySOGoTrashFolderName/key
stringINBOX/Trash/string
keySOGoUserSources/key
array
dict
keytype/key
stringsql/string
keyid/key
stringdatabase/string
keyviewURL/key
stringmysql://sogo:PASSWORD@localhost:3306/sogo/sogo_view/string
keyuserPasswordAlgorithm/key
stringsha/string
keycanAuthenticate/key
stringYES/string
keyisAddressBook/key
stringYES/string
keydisplayname/key
stringSOGoAdressBook/string
/dict
/array
keySOGoVacationEnabled/key
stringYES/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
