I made this new user with no more results. The only changes are the url in my logs, like : [ERROR] <0x0x7f2dcac33220[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7f2dcb017190] connection=0x(null)> for mysql://host.org/sogo/sogo_sessions_folder
So as you can see, the problem is still the same : for joining the sessions_folder table, SOGo seems to not use the login/password and the port. > . . . answer below . . . > > On 04/08/2015 06:19 PM, Schifano Alexandre wrote: >> On 08/04/2015 22:45, Gilles Gagniard wrote:> Hello ! >>> Same issue here. Are you still running your sogo install on centos 7 >> by any chance ? >>> On my side the only significant change I did is to yum update, which >> upgraded my box to the recently released centos 7.1, which among other >> things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too >> before restarting your server ... >>> I tried to rebuild everything in case there is some binary >> compatibility issue, but to no avail. >>> Gilles >>> >> Hi, >> >> I used CentOS 7. After my server reboot I did a yum update and I'm now >> with a CentOS 7.1. >> I tried the new binaries available in the SOGo repository, with the same >> result. >> >> On 08/04/2015 22:26, Steve Ankeny wrote: >>> (1) What version of MariaDB are you using? >>> >>> (2) Are you using anything else such as Samba 4 LDAP with MariaDB? >>> >>> (3) What are you using for SOGoUserSources? >>> >>> I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine. >>> >>> I rebooted over the weekend for a kernel upgrade, and I've had no >>> problems. >>> >>> My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as >>> yours. >>> >>> I had an issue creating the OpenChange MySQL user as >>> 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did >>> not like the single quotes. Once I removed those, everything worked >>> fine. >>> >>> I had thought that was the case with the SOGo MySQL user, but it was >>> created without single quotes. >>> >>> I wonder if it has to do with the MariaDB version? >>> >> Hi, >> >> I have MariaDB 5.5.41, with no LDAP and no Samba. My user >> authentification is done throught the SQL backend. > > IF it's not too difficult, you might try deleting the 'sogo' user and > recreating it. > > MariaDB prefers creating the user without @localhost but using @% > instead. Look at documentation. > > How it looks in MySQL > > > > > > > > Somehow or other, I ended up with sogo and 'openchange-user' (but it > works fine) > > I'm just trying to think of things you can consider. Maybe someone will > know more about MariaDB > > > -- > [email protected] > https://inverse.ca/sogo/lists -- [email protected] https://inverse.ca/sogo/lists
