Georg,
sogo_users is the authentication table I added according to multiple
sources for sql authentication.
Here is my sogo defaults with password replaced with *.
sogod SOGoVacationEnabled NO
sogod SOGoSMTPServer localhost
sogod SOGoUserSources '(
{
IMAPLoginFieldName = mail;
LoginFieldNames = mail;
canAuthenticate = YES;
displayName = "SOGo Users";
id = users;
isAddressBook = YES;
type = sql;
userPasswordAlgorithm = md5;
viewURL = "mysql://sogo:*@127.0.0.1:3306/sogo/sogo_users";
}
)'
sogod SOGoEnableEMailAlarms YES
sogod SOGoIMAPServer imaps://localhost:9434
sogod SOGoLanguage English
sogod OCSEMailAlarmsFolderURL
mysql://sogo:*@localhost:3306/sogo/sogo_alarms_folder
sogod PGDebugEnabled NO
sogod SOGoProfileURL mysql://sogo:*@localhost:3306/sogo/sogo_user_profile
sogod SOGoEnablePublicAccess =
sogod SOGoTimeZone US/Pacific
sogod SOGoFoldersSendEMailNotifications YES
sogod SOGoMemcachedHost 127.0.0.1
sogod LDAPDebugEnabled NO
sogod SOGoMailingMechanism smtp
sogod OCSSessionsFolderURL
mysql://sogo:*@localhost:3306/sogo/sogo_sessions_folder
sogod SOGoSieveServer sieve://localhost
sogod SOGoSuperUsernames '(
bennabiy
)'
sogod WOLogFile /var/log/sogo/sogo.log
sogod SOGoForwardEnabled NO
sogod OCSFolderInfoURL mysql://sogo:*@localhost:3306/sogo/sogo_folder_info
sogod SOGoMailAuxiliaryUserAccountsEnabled NO
sogod SOGoSieveScriptsEnabled NO
sogod SOGoACLsSendEMailNotifications YES
sogod SOGoAppointmentSendEMailNotifications YES
sogod SOGoUIxDebugEnabled NO
sogod WOWorkersCount 6
On 2/7/12 3:09 PM, Georg Bretschneider wrote:
Hi,
your one table name looks odd.
"sogo_users"
Could you show us your SOGo config?
Maybe it should be "sogo_user_profile"?
Did you take a look into your database and is there a table called
sogo_users? Was this table auto installed? Or did you rename it?
Bye
Georg
Am 08.02.2012 00:43, schrieb Yellow Deli:
Below is from the sogo.log file from an attempted login. I am using
MySQL for login, with IMAP.
Sogo 1.3.11 on Debian squeeze. I have mysql5.1. Is this causing the issue?
Feb 07 15:25:19 sogod [31727]: [ERROR]<0x0x9c143a8[GCSChannelManager]>
could not open channel<MySQL4Channel[0x0x9e98a38] connection=0x(null)>
for URL: mysql://sogo:[email protected]:3306/sogo/sogo_users
Feb 07 15:25:19 sogod [31727]: [WARN]<0x0x9c143a8[GCSChannelManager]>
will prevent opening of this channel 5 seconds after 2012-02-07 15:25:19
-0800
Feb 07 15:25:19 sogod [31727]: [ERROR]<0x0x9b0a5f8[SQLSource]> failed
to acquire channel for URL:
mysql://sogo:[email protected]:3306/sogo/sogo_users
Feb 07 15:25:19 sogod [31727]: SOGoRootPage Login for user
'[email protected]' might not have worked - password policy: 65535
grace: -1 expire: -1 bound: 0
<WANIP> - - [07/Feb/2012:15:25:19 GMT] "POST /SOGo/connect HTTP/1.1" 403
34/101 0.006 - - 36K
-------------
I removed certain personal information to protect my system.
--
[email protected]
https://inverse.ca/sogo/lists
