hi all,

i had this issue today on a cetnos 7 installation with rpms from redhat

<pre>
[jaile-sogo]
name=Copr repo for sogo owned by jaile
baseurl=https://copr-be.cloud.fedoraproject.org/results/jaile/sogo/epel-7-$basearch/
</pre>

SOGO was throwing 1000s of msql errors -- I finally saw the segfault messages 
on the console.

I decommissioned the server and replaced it with centos 6 -- works perfectly.

I will not be using centos 7 again until rpms are available here

Apr  8 13:31:44 alt kernel: sogod[6962]: segfault at 0 ip 00007f1e2a40b053 sp 
00007fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000]
Apr  8 13:31:44 alt kernel: sogod[6963]: segfault at 0 ip 00007f1e2a40b053 sp 
00007fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000]
Apr  8 13:31:44 alt kernel: sogod[6964]: segfault at 0 ip 00007f1e2a40b053 sp 
00007fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000]
Apr  8 13:31:44 alt kernel: sogod[6965]: segfault at 0 ip 00007f1e2a40b053 sp 
00007fff86af5890 error 6 in libmysqlclient.so.18.0.0[7f1e2a3af000+28c000]
...

Cheers

M


On 04/08/2015 09:55 PM, Jeroen Beerstra wrote:
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 to work as
mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder

This is driving me nuts :( Something is clearly broken, if only the log
would provide some more clou...

mvg,

Jeroen Beerstra

Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr:
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 allocate
MySQL4 connection!
Apr 08 15:12:52 sogod [992]: [ERROR] <0x0x7f4529584700[GCSChannelManager]>
could not open channel <MySQL4Channel[0x0x7f45298f63e0]
connection=0x(null)> for mysql://localhost/sogo/sogo_sessions_folder
Apr 08 15:12:52 sogod [992]: [WARN] <0x0x7f4529584700[GCSChannelManager]>
  will prevent opening of this channel 5 seconds after 2015-04-08 17:12:52
+0200

I have my "OCSSessionsFolderURL" well defined with username, password, and
DB port, but it looks like this is not well setted in the running SOGo. Is
there a way to get the config of the running SOGo ? And how can I correct
this problem ?

Best regards

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.
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 error in my logs messages :

2015-04-08 8:18:58.708 sogod[8174]  ERROR((null)): could not allocate
MySQL4 connection!
Apr 08 8:18:58 sogod [8174]: [ERROR]
<0x0x7f3a2c9564f0[GCSChannelManager]> could not open channel
<MySQL4Channel[0x0x7f3a2ce4e490] connection=0x(null)> for
mysql://localhost/sogo/sogo_custom_users
Apr 08 8:18:58 sogod [8174]: [WARN]
<0x0x7f3a2c9564f0[GCSChannelManager]>   will prevent opening of this
channel 5 seconds after 2015-04-08 8:18:58 +0200
Apr 08 8:18:58 sogod [8174]: [ERROR] <0x0x7f3a2c8fb050[SQLSource]>
failed to acquire channel for URL:
mysql://sogo:PASSWORD@localhost:3306/sogo/sogo_custom_users

However :
* it worked well before the reboot,
* I am able to be connected to my db with "mysql -h localhost -u sogo
-p",
* when I do "telnet localhost 3306" I have a opened connection to
MariaDB (the connection is accepted and there is a kind of welcome
message)
* the port used by MariaDB is still the same,
* and I even configured iptable for having the 3306 port open to
everybody.
What did I forget ?

Best regards

--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to