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: [email protected] [mailto:[email protected]] On Behalf Of Carles
Christophe
Sent: Tuesday, June 23, 2015 10:13 AM
To: [email protected]
Subject: [SOGo] sogo failed to acquire channel for URL:
mysql://sogo:[email protected]: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:[email protected]:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:[email protected]:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:[email protected]:3306/sogo/sogo_user_profile
Jun 23 15:57:38 sogod [4586]: [ERROR]
<0x0x7fd6cc1299e0[SOGoSQLUserProfile]> failed to acquire channel for
URL: mysql://sogo:[email protected]: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
[email protected]
Tél : 05.61.33.59.60
Fax : 05.61.33.58.86
--
[email protected]
https://inverse.ca/sogo/lists
