Thanks Simon. I had made a mistake in following a tutorial. Got it changed to the correct table now. -----Original message----- From:Simon Walter <[email protected]> Sent:Thu 15-11-2012 23:29 Subject:Re: [SOGo] Authenticating with MySQL database To:[email protected]; 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 -- [email protected] https://inverse.ca/sogo/lists
