On 11/16/2012 12:43 PM, Dave Burkholder wrote:
Authenticating with MySQL database
Hello everyone,
First-time poster here after lurking for awhile. Finally decided to
take Sogo for a spin on my Clearos 5 server based on Centos 5.
I've gotten everything installed, but when I go to login to SOGo
webmail, I get the error: Wrong username or password. Here are the
loglines that surround the failed login attempt. Am I supposed to be
creatinng a sogo.sogo_view table in MySQL?
You did specify "mysql://sogo:[email protected]:3306/sogo/sogo_view" in
your SOGoUserSources. So that had better exist. From the install docs:
Here is an example of an SQL-based authentication and address book source:
SOGoUserSources =
(
{
type = sql;
id = directory;
viewURL = "postgresql://sogo:[email protected]:5432/sogo/sogo_view";
canAuthenticate = YES;
isAddressBook = YES;
userPasswordAlgorithm = md5;
}
);
Certain database columns must be present in the view/table, such as :
c_uid - will be used for authentication – it's the username or
[email protected])
c_name - which can be identical to c_uid – will be used to uniquely
identify entries
c_password – password of the user, plain-text, md5 or sha encoded for now
c_cn - the user's common name – such as “John Doe”
mail – the user's mail address
--
htholidays.com
--
[email protected]
https://inverse.ca/sogo/lists
