Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Ulrich Maurus
I first had issues with postgresql as well but realized it was caused by the different user authentication. Fortunately there were entries in the postgresql log and the root cause was that postgresql may / can use "ident" as authentication. For sogo it looks like the DB access is done by user "apa

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny
What about MariaDB 10.0? I don't see a "libs" package. On 04/09/2015 11:54 AM, Gilles Gagniard wrote: Hello, I think this is actually linked to the recent mariadb upgrade, not because of mariadb-server, but because of mariadb-libs ie the client side. Here is where it fails (there is a "could

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
As said, same problem when I use the local Lan hostname. The host file hasn't changed. My guess is a software version problem somewhere since multiple users report having updated to centos 7.1, as have I Op 9 apr. 2015 18:59 schreef Steve Ankeny : > > actually, I'd agree . . . > > You use 'lo

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Gilles Gagniard
Hello, I think this is actually linked to the recent mariadb upgrade, not because of mariadb-server, but because of mariadb-libs ie the client side. Here is where it fails (there is a "could not allocate MySQL4 connection" error in the logs) : https://github.com/inverse-inc/sope/blob/6452ca58f

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny
actually, I'd agree . . . You use 'localhost' What about using 127.0.0.1? And, since it worked once, has hosts file changed? On 04/09/2015 10:28 AM, Alessandro Briosi wrote: Il 09/04/2015 15:03, Jeroen Beerstra ha scritto: The only thing I haven't tried is mysql, postgresql and mariadb bo

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
Yes I did, also with the local network name, same problem. Also verified ipv6 is disabled. It seems the first connection succeeds (selecting jeroen from the user table) but the second connection (without user or pwd) fails and triggers a db connection suspend so everything else (with user / pwd) al

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Alessandro Briosi
Il 09/04/2015 15:03, Jeroen Beerstra ha scritto: > The only thing I haven't tried is mysql, postgresql and mariadb both have the > same problem. So I don't think it's related to changes in recent mariadb Just a wild guess here (or a long shot if you prefere :P ). Could it be that the name reso

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
The only thing I haven't tried is mysql, postgresql and mariadb both have the same problem. So I don't think it's related to changes in recent mariadb Op 9 apr. 2015 14:32 schreef Steve Ankeny : > > (1) try MariaDB 10.x > > (2) move back to MySQL > > (3) try PostgreSQL > > > On 04/09/2015 07:

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny
(1) try MariaDB 10.x (2) move back to MySQL (3) try PostgreSQL On 04/09/2015 07:30 AM, schif...@polytech.unice.fr wrote: 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 for mysql:/

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread schifano
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 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,

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
Not sure, I also tried switching from mariadb to postgresql. Same errors :( From the looks of it this is what happens: - sogo tries to connect to the db without the sogo user/pwd and ofcourse this doesn't work - sogo suspends the db connection for 5 seconds - result = access denied or object not f

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Steve Ankeny
. . . 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 m

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Ulrich Maurus
I run into the same problem last week when upgrading from CentOS 7 to CentOS 7.1, which I found a bit "stealthy", since the repo links stay the same. But a lot of base as well as epel packages are having a major upgrades. I am using IPA for authentication with SOGO / Dovecot and that went from 3.2

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Jeroen Beerstra
Yes CentOS 7.1, I used to just use newer gnustep-make and gnustep-base from either fedora or epel, but guess this doens't work anymore. Bad news is I can't get the sogu.nu provided srpms counterparts to compile, guess they are just too old for 7 :( mvg, Jeroen Beerstra Op 09-04-15 om 00:19 schr

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Schifano Alexandre
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 update

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Gilles Gagniard
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 t

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Steve Ankeny
(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 pro

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread mayak
hi all, i had this issue today on a cetnos 7 installation with rpms from redhat [jaile-sogo] name=Copr repo for sogo owned by jaile baseurl=https://copr-be.cloud.fedoraproject.org/results/jaile/sogo/epel-7-$basearch/ SOGO was throwing 1000s of msql errors -- I finally saw the segfault message

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Jeroen Beerstra
Exact same problem here, SOGo used to work just fine and now it doesn't. Tried everything I could think of, including altering db host user pwd and even recompiling since I´d seen some OS updates. also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log, while this is defined and used

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread schifano
I tried this and it changed nothing. I read more carefully my logd and I saw this before the error previously quoted : Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from '127.0.0.1' for user 'USER' - expire = -1 grace = -1 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not a

Re: [SOGo] Sogo and MySQL problem

2015-04-08 Thread Dominik Breu
Hi, imho when you set IMAPLoginFieldName (see documentation for more explanation) to your field which only returns the Given Name it would work. best regards Am Mittwoch, den 08.04.2015, 08:35 +0200 schrieb Schifano Alexandre: > Hi, > > I'm facing to a very weird problem about SOGo and MySQL.

[SOGo] Sogo and MySQL problem

2015-04-08 Thread Schifano Alexandre
Hi, I'm facing to a very weird problem about SOGo and MySQL. I had a SOGo server working correctly with no problem, but I had to reboot the server. After that I restarted Sogod, MariaDB, memcache, Apache, and the other services, but now sogo is unable to use MySQL/MariaDB. I have this kind of erro

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread André Schild
Am 14.04.2014 19:53, schrieb Bruno Andrade: One more thing... ActiveSync. I know that for Openchange there is the need of Samba. But, what about ActiveSync? Does he needs Samba or can I use only the SQL DB as banckend? ActiveSync should work without Samba André -- users@sogo.nu https://invers

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread Bruno Andrade
One more thing... ActiveSync. I know that for Openchange there is the need of Samba. But, what about ActiveSync? Does he needs Samba or can I use only the SQL DB as banckend? Thanks in advance. On 04/14/2014 03:26 PM, Bruno Andrade wrote: Thanks a lot Florian. One more thing, do you use Op

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread Bruno Andrade
Thanks a lot Florian. One more thing, do you use Openchange with SOGo? Or like it was said before, for Openchange is obligatory using samba4/LDAP? Thanks. On 04/14/2014 02:23 PM, Florian wrote: Hi Bruno, I´m running Sogo with mysql as full backend in combination with ispconfig, there is

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread Bruno Andrade
Is there any tutorial on how to configure SOGo with MySQL as backend? On 04/14/2014 01:47 PM, André Schild wrote: Am 14.04.2014 14:07, schrieb Bruno Andrade: Hey, Is it possible to use MySQL as full backend to SOGo instead of LDAP? (I found some emails about these, but they were pretty old,

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread Florian
Hi Bruno, I´m running Sogo with mysql as full backend in combination with ispconfig, there is a thread on ispconfig-forum http://www.howtoforge.com/forums/archive/index.php/t-51162.html i have setup a mysql view over the ispconfig mailusertable... mFg Florian On 14.04.2014 14:07, Bruno Andr

Re: [SOGo] SOGo and MySQL

2014-04-14 Thread André Schild
Am 14.04.2014 14:07, schrieb Bruno Andrade: Hey, Is it possible to use MySQL as full backend to SOGo instead of LDAP? (I found some emails about these, but they were pretty old, for SOGo v1.*) Basically. I'm verifying if it's possible to use SOGo with ISPConfig. And I don't pretend to use a

[SOGo] SOGo and MySQL

2014-04-14 Thread Bruno Andrade
Hey, Is it possible to use MySQL as full backend to SOGo instead of LDAP? (I found some emails about these, but they were pretty old, for SOGo v1.*) Basically. I'm verifying if it's possible to use SOGo with ISPConfig. And I don't pretend to use any kind of synchronization between LDAP (SOGo