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

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

2017-02-27 Thread Christian Mack

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 Никита (imfromtheh...@gmail.com):
> 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 > 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/
>> use...@example.ru/Calendar/eventsblocks?ed=20170212=20170212=
>> 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/
>> use...@example.ru/Calendar/eventslist?asc=1=20170212=view_
>> next7=title_Category_Location=start= 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/use...@example.ru/Calendar/personal  | Users   |
>> use...@example.ru  | Calendar | personal | Персональный календарь
>>  |

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

2017-02-27 Thread imfromtheh...@gmail.com

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  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/
> use...@example.ru/Calendar/eventsblocks?ed=20170212=20170212=
> 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/
> use...@example.ru/Calendar/eventslist?asc=1=20170212=view_
> next7=title_Category_Location=start= 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/use...@example.ru/Calendar/personal  | Users   |
> use...@example.ru  | 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?
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

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

2017-02-12 Thread imfromtheh...@gmail.com

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
 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/
use...@example.ru/Calendar/eventsblocks?ed=20170212=20170212=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/
use...@example.ru/Calendar/eventslist?asc=1=20170212=view_next7=title_Category_Location=start=
HTTP/1.1" 200 439/0 0.014 - - 0

I know about OCSFolderInfoURL:
In my sogo.conf itis  look's like:
OCSFolderInfoURL = "mysql://
sogo:mypassw...@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/use...@example.ru/Calendar/personal  | Users   |
use...@example.ru  | 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?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

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

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

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

3 matches

Site Navigation

Mail list logo

Footer information