Hi All!
Our Email system uses MySQL database, so i would like to use Mysql for
sogo to.
I have made test installation of sogo system on Debian Lenny.
I have problems with SQL authentication using MySQL.
I have set my system according the user manual but I am not able to log
in.
*my configuration:*
{
NSGlobalDomain = {
};
sogod = {
OCSFolderInfoURL =
"mysql://sogo:pass@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:pass@localhost:3306/sogo/sogo_sessions_folder";
SOGoACLsSendEMailNotifications = YES;
SOGoAppointmentSendEMailNotifications = YES;
SOGoFoldersSendEMailNotifications = YES;
SOGoLanguage = English;
SOGoMailDomain = sogo.test;
SOGoProfileURL =
"mysql://sogo:pass@localhost:3306/sogo/sogo_user_profile";
SOGoTimeZone = Europe/Moscow;
SOGoAuthenticationMethod = SQL;
SOGoDebugRequests = YES;
GCSFolderDebugEnabled = YES;
GCSFolderStoreDebugEnabled = YES;
LDAPDebugEnabled = YES;
SOGoUserSources =
(
{
type = sql;
id = public;
viewURL = "mysql://sogo:pass@localhost:3306/sogo/new_view";
catAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = none;
displayName = "test";
}
);
};
I have created a table in my sogo databases and a view with expected fields
mysql> describe new_view;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | int(11) | NO | | NULL | |
| c_uid | varchar(45) | YES | | NULL | |
| c_name | varchar(45) | YES | | NULL | |
| c_password | varchar(45) | YES | | NULL | |
| c_cn | varchar(45) | YES | | NULL | |
| mail | varchar(45) | YES | | NULL | |
+------------+-------------+------+-----+---------+-------+
mysql> SELECT * FROM sogo_view;
+----+-------+--------+------------+------+-----------------+
| id | c_uid | c_name | c_password | c_cn | mail |
+----+-------+--------+------------+------+-----------------+
| 0 | admin | admin | pass | admin | [email protected] |
+----+-------+--------+------------+------+-----------------+
When I try to login throe the web interface a have the " Wrong password
or username" error
*
logs:*
The sogo.log contains only this:
localhost - - [21/Feb/2011:13:25:16 GMT] "GET /SOGo/ HTTP/1.1" 200
3987/0 0.064 11476 65% 3M
Feb 21 13:25:27 sogod [8196]: |SOGo| starting method 'POST' on uri
'/SOGo/connect'
Feb 21 13:25:27 sogod [8196]: SOGoRootPage Login for user 'admin' might
not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0
Feb 21 13:25:27 sogod [8196]: |SOGo| request took 0.001080 seconds to
execute
localhost - - [21/Feb/2011:13:25:27 GMT] "POST /SOGo/connect HTTP/1.1"
403 34/61 0.003 - - 12K
I enabled query logging on MySQL, and my login attempts don't result in
any queries to the database.
in mysql log i can see only this:
110221 13:25:03 59 Connect sogo@localhost on sogo
59 Query SET CHARACTER SET utf8
59 Query SELECT count(*) FROM sogo_user_profile
59 Query SELECT count(*) FROM sogo_folder_info
59 Query SELECT count(*) FROM
sogo_sessions_folder
110221 13:25:16 59 Query SELECT c_defaults FROM
sogo_user_profile WHERE c_uid = 'anonymous'
I googled a lot about it, but didn't find out a solution.
Please Help me...
--
Best Regads
IT Support Team
--
[email protected]
https://inverse.ca/sogo/lists
