General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Calendar can't cannot to mysql database, strange configuration error


Chronological Thread 
  • From: "Christian Mack" ( ) < >
  • To:
  • Subject: Re: [SOGo] Calendar can't cannot to mysql database, strange configuration error
  • Date: Mon, 27 Feb 2017 17:21:52 +0100
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca 1809F11E344A

Hello

Your problem is, that SOGo stores the database link into its database.
Therefore it says in the Installation manual:
https://sogo.nu/files/docs/SOGoInstallationGuide.html#_database_configuration

"
SOGo stores the database hostname together with table references inside
several database tables. To prevent possible future issues when moving
the database to another host, it is best practice to add a local alias
name to your /etc/hosts file, and using this in /etc/sogo/sogo.conf
instead of the actual name of your server or localhost. When the
database host name changes, you can now simply change the hosts file
instead of updating several table columns replacing the old hostname. An
example entry for /etc/hosts when running the database on the same host,
registering 127.0.0.1 not only for localhost, but also the db-alias alias:

127.0.0.1 localhost db-alias

In the SOGo configuration, use the alias name instead of the real IP
address or host name, for example

SOGoProfileURL =
"postgresql://sogo:sogo@db-alias:5432/sogo/sogo_user_profile";

"



Kind regards,
Christian Mack

Am 25.02.2017 um 23:31 schrieb Никита
( ):
> Still no responce?
>
> 2017-02-12 16:13 GMT+03:00 Никита
> < >:
>
>> Hi everyone,
>> I have sogo 3.2a installed on my server1 and mail server2 (postfix,
>> dovecot etc) on another server2
>> everything works fine except Calendar, i cant save anything to calendar
>> (event, to-do etc).
>>
>> The part of error log is:
>>
>> 2017-02-12 15:59:05.481 sogod[100573] ERROR: could not open MySQL4
>> connection to database 'sogo': Access denied for user 'sogo'@'localhost'
>> (using password: YES)
>> Feb 12 15:59:05 sogod [100573]: [ERROR]
>> <0x0x7fcafbbfc640[GCSChannelManager]>
>> could not open channel <MySQL4Channel[0x0x7fcafc7e26f0]
>> connection=0x(null)> for mysql://127.0.0.1/sogo/sogouser.asen0016f56fcd8
>> Feb 12 15:59:05 sogod [100573]: [WARN]
>> <0x0x7fcafbbfc640[GCSChannelManager]>
>> will prevent opening of this channel 5 seconds after 2017-02-12 15:59:05
>> +0300
>> Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]>
>> could not open storage channel!
>> Feb 12 15:59:05 sogod [100573]: [ERROR] <0x0x7fcafc8bdf60[GCSFolder]>
>> could not open storage channel!
>> Feb 12 15:59:05 sogod [100573]: [ERROR] <0x7fcafc80b530[
>> SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
>> fetchFields:from:to:title:component:additionalFilters:
>> includeProtectedInformation:]): fetch failed!
>> Feb 12 15:59:05 sogod [100573]: 5.18.62.183 "GET /SOGo/so/
>> /Calendar/eventsblocks?ed=20170212&sd=20170212&view=
>> multicolumndayview HTTP/1.1" 200 567/0 0.008 - - 0
>> Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]>
>> could not open storage channel!
>> Feb 12 15:59:05 sogod [100574]: [ERROR] <0x0x7fcafc684770[GCSFolder]>
>> could not open storage channel!
>> Feb 12 15:59:05 sogod [100574]: [ERROR] <0x7fcafc7bc1d0[
>> SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
>> fetchFields:from:to:title:component:additionalFilters:
>> includeProtectedInformation:]): fetch failed!
>> Feb 12 15:59:05 sogod [100574]: 5.18.62.183 "GET /SOGo/so/
>> /Calendar/eventslist?asc=1&day=20170212&filterpopup=view_
>> next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200
>> 439/0 0.014 - - 0
>>
>> I know about OCSFolderInfoURL:
>> In my sogo.conf itis look's like:
>> OCSFolderInfoURL = "mysql://sogo:mypassword@mail.
>> mydomainname.ru:3306/sogo/sogo_folder_info";
>>
>> And strange thing is:
>>
>> mysql> select * from sogo_folder_info;
>> +-------------+---------------------------------------------
>> ---+---------+-----------------------+----------+----------+
>> ---------------------------------------------+--------------
>> ------------------------------------------------------------
>> -----+------------------------------------------------------
>> -------------------------------+----------------------------
>> -------------------------------------------------------+---------------+
>> | c_folder_id | c_path | c_path1 |
>> c_path2 | c_path3 | c_path4 | c_foldername
>> | c_location
>> | c_quick_location
>> | c_acl_location
>> | c_folder_type |
>> +-------------+---------------------------------------------
>> ---+---------+-----------------------+----------+----------+
>> ---------------------------------------------+--------------
>> ------------------------------------------------------------
>> -----+------------------------------------------------------
>> -------------------------------+----------------------------
>> -------------------------------------------------------+---------------+
>> | 5 |
>> /Users/ /Calendar/personal
>> | Users |
>>
>> | Calendar | personal | Персональный календарь
>> | mysql://sogo:userpassword@127.0.0.1:3306/sogo/
>> usera00169e4bfb4 | mysql://sogo:userpassword@127.0.0.1:3306/sogo/
>> usera00169e4bfb4_quick | mysql://sogo:userpassword@127.0.0.1:3306/sogo/
>> usera00169e4bfb4_acl | Appointment |
>>
>> +-------------+---------------------------------------------
>> ---+---------+-----------------------+----------+----------+
>> ---------------------------------------------+--------------
>> ------------------------------------------------------------
>> -----+------------------------------------------------------
>> -------------------------------+----------------------------
>> -------------------------------------------------------+---------------+
>> 5 rows in set (0.00 sec)
>>
>> Where he found 127.0.0.1 in my config, and how it hit into my mysql db?
>>


--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature




Archive powered by MHonArc 2.6.18.

Top of page