Hello, Have you tried establishing a connection using the cli command with the user/pwd set for SOGo ie, "mysql -u sogo -p sogo -h localhost sogo"?
Just make sure you do have the database created with privileges granted to the dedicated db user and the mysql daemon accept incoming connections on the loopback. If both conditions are met, you may also try using 127.0.0.1 instead of localhost On 03/11/2015 08:32, 王建常-Test wrote: > Thanks Steve, > I had followed the document to configure these settings, but I don't > know how to make sure the setting is correct or not on connect to MySQL. > Below are the ERROR logs > > Nov 03 07:08:49 sogod [13856]: [ERROR] > <0x0x7f9535c64810[SOGoSQLUserProfile]> failed to acquire channel for > URL: mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile > Nov 03 07:08:49 sogod [13856]: [ERROR] > <0x0x7f9535c64810[SOGoSQLUserProfile]> failed to acquire channel for > URL: mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile > Nov 03 07:08:49 sogod [13856]: [ERROR] > <0x0x7f9535c64810[SOGoSQLUserProfile]> failed to acquire channel for > URL: mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile > My SQL config on sogo.conf > /* Database configuration (mysql:// or postgresql://) */ > SOGoProfileURL = > "mysql://sogo:sogo@localhost:3306/sogo/sogo_user_profile"; > OCSFolderInfoURL = > "mysql://sogo:sogo@localhost:3306/sogo/sogo_folder_info"; > OCSSessionsFolderURL = > "mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder"; > > > My environments: > CentOS7 > MariaDB 1:5.5.44-1.el7 > OpenLDAP 2.4.39-6.el7 > Postfix 2:2.10.1-6.el7 > Dovecot 1:2.2.10-4.el7 > > > ------ Original Message ------ > From: "Steve Ankeny" <[email protected]> > To: [email protected] > Sent: 2015/11/2 下午 09:33:52 > Subject: Re: [SOGo] SOGo Configuration > >> On 11/02/2015 01:20 AM, [email protected] wrote: >>> Hi, I'm trying to install and config SOGo for test purpose, >>> but I have no ideas how to configure SOGo to make it work properly. >>> I had installed postfix and dovecot with AD integrated and make them >>> work >>> properly, but I don't know how to config SOGo to use global address >>> book, >>> calendar and webmail function. >>> Is there any step by step configuration guide for a newbie to follow up? >>> Thanks in advance. >> documentation here -- >> >> http://www.sogo.nu/downloads/documentation.html >> >> faqs here -- >> >> http://www.sogo.nu/english/nc/support/faq.html >> >> >> -- [email protected] >> https://inverse.ca/sogo/lists > > -- Daniel Le Bray :: CRI :: Pôle Systèmes et Réseaux [email protected] / +33 02 32 74 42 94 Universite du Havre, 25 rue Philippe Lebon, BP1123, 76063 Le Havre Cedex -- [email protected] https://inverse.ca/sogo/lists
