General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] sogo failed to acquire channel for URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile


Chronological Thread 
  • From: Carles Christophe < >
  • To:
  • Subject: Re: [SOGo] sogo failed to acquire channel for URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile
  • Date: Tue, 23 Jun 2015 17:26:34 +0200

Hello,

Thanks for your reply.
I have do it yet :

CREATE USER 'sogo'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `sogo`.* TO 'sogo'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;


But it still the same.
In sogo.conf i have activate more log :

SOGoDebugRequests = YES;
SoDebugBaseURL = YES;

MySQL4DebugEnabled = YES;



And now

sogod[4749] ERROR((null)): could not allocate MySQL4 connection!
Jun 23 17:23:07 sogod [4749]: [ERROR] <0x0x7fa179d38cc0[GCSChannelManager]> could not open channel <MySQL4Channel[0x0x7fa17a133c10] connection=0x(null)> for mysql://127.0.0.1/sogo/sogo_sessions_folder



Le 23/06/2015 17:08, Kelbley, Steven a écrit :
That means that SOGo wasn't able to get a connection to your database. Make sure that you have a
role created for "sogo" with "password", and that you have granted them
access the sogo database.


-----Original Message-----
From:


[mailto: ]
On Behalf Of Carles Christophe
Sent: Tuesday, June 23, 2015 10:13 AM
To:

Subject: [SOGo] sogo failed to acquire channel for URL:
mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile

Hello,

I'm installing sogo 2.3.0 on a new VM with centos 7.
The database is mysql.

When I try to logon, it's OK but there are lot of error in sogo.log :

Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:password@127.0.0.1:3306/sogo/sogo_user_profile

I have search with google what kind of error it could be.

I have made change in memcached : change localhost by 127.0.0.1

But it's still the same.

Here is my conf of sogo :

OCSEMailAlarmsFolderURL =
"mysql://sogo:password@localhost:3306/sogo/sogo_alarms_folder";
SOGoProfileURL =
"mysql://sogo:password@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:password@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:password@localhost:3306/sogo/sogo_sessions_folder";

Is anyone have an idea ?

regards,


--
Christophe Carles
CNRS - LMGM
Service Informatique
Bât. IBCG
118, route de Narbonne
31062 Toulouse Cedex9

Tél : 05.61.33.59.60
Fax : 05.61.33.58.86




Archive powered by MHonArc 2.6.18.

Top of page