Hi Richard, > I am trying to set up Sogo on an Ubuntu 14.04 server using mysql as the authenticator. > > I have gotten to a point where the website interface is working, but no one can log in. The interface says “Wrong username or password.” I’m not sure what I’m missing. > > The log says: May 29 19:27:20 sogod [25088]: [ERROR] <0x0x7fd85fdd05a8[SOGoUserManager]> No authentication sources defined - nobody will be able to login. Check your defaults. > > It does seem to be connecting to the database, as far as I can tell. The tables seem to be there. > > I’m missing something basic, but after several days I can’t figure out what. Any thoughts?
It's in the following part of your config file: > /* SQL authentication example */ > /* These database columns MUST be present in the view/table: > * 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 > * See the installation guide for more details > */ > //SOGoUserSources = > // ( > // { > // type = sql; > // id = directory; > // viewURL = "mysql://sogo:[email protected]:5432/sogo/sogo_view"; > // canAuthenticate = YES; > // isAddressBook = YES; > // userPasswordAlgorithm = md5; > // } > // ); Uncomment the above, update it with valid settings and then add users to your sogo_users table. As in: insert into sogo_users values ('[email protected]','user',md5('secret'),'Email User','[email protected]'); B -- [email protected] https://inverse.ca/sogo/lists
