Hi, I've upgrade to 2.3.0 (under Ubuntu 14.04) and I can't manage to have a working configuration anymore (I've updated the Mysql database using the script).
I'm using a mysql view to authenticate my users. After updating, nobody can login in anymore. The typical error message is: object not found: [email protected]@apiacoa.org with a double domain name. My configuration for authentication (which used to work perfectly with 2.2.17) is: SOGoEnableDomainBasedUID = YES; SOGoLoginDomains = ( "apiacoa.org" ); domains = { apiacoa.org = { SOGoMailDomain = "apiacoa.org"; SOGoUserSources = ( { type = sql; id = directory-apiacoa; viewURL = "mysql://user:[email protected]:3306/db/sogo_users"; canAuthenticate = YES; isAddressBook = YES; userPasswordAlgorithm = md5-crypt; LoginFieldNames = ( "c_name" ); IMAPLoginFieldName = "mail"; DomainFieldName = "domain"; displayName = "Utilisateurs Apiacoa.org"; hostname = "localhost"; } ); }; }; the c_name column of the view contains full ids such as [email protected]. The domain column contains the domain, here apiacoa.org. I tried to replace the c_name column by another one which contains only the user name. In this case, if I try to login with the full name [email protected] I get a "Wrong username or password." message. If I try to connect with the user name alone (fabrice.rossi), I don't get the 404 message above but I stay on the login page, trying to access the url https://sogo.apiacoa.org/SOGo/so/fabrice.rossi%40apiacoa.org. According to the log file, I'm successfully logged in: Jun 04 17:28:59 sogod [27161]: SOGoRootPage successful login from 'xx' for user 'fabrice.rossi' - expire = -1 grace = -1 but I can't access to anything. I've tried different variations with no success. Any help will be appreciated. Best regards, Fabrice -- [email protected] https://inverse.ca/sogo/lists
