Thanks Steve, I believed the SQL connection should be right, cause SOGo auto create three tables on sogo database, and I found there are three datas in sogo_sessions_folder table. but the logs always showed there are errors on SOGoSQLUserProfile, and right now I can login by LDAP authenticate but nothing shows up. just change the url from http://sogo/SOGo to http://sogo/SOGo/userid any ideas?
------ Original Message ------ From: "Steve Ankeny" <[email protected]> To: "[email protected]" <[email protected]> Sent: 2015/11/3 下午 09:50:30 Subject: Re: [SOGo] SOGo Configuration >On 11/03/2015 02:32 AM, 王建常-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 >> > >Sounds like an SQL error -- perhaps the 'sogo' user and password (or >grants) > >I ran into something similar when I initially configured MariaDB v.10, >and I "dropped" the user, recreated and granted permissions, etc. until >I got it right. Try logging into MySQL with the user 'sogo' > >It acts as though it's not "binding" the user to the database. I can't >tell you more. > >> >> ------ 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 >> >> > > >-- >[email protected] >https://inverse.ca/sogo/lists [http://www.6016.com.tw/image/top201502.jpg]<http://www.concords.com.tw/Default.htm> [http://www.6016.com.tw/image/Bottom201503.jpg] <http://www.concords.com.tw/Default.htm> -- [email protected] https://inverse.ca/sogo/lists
