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 Никита <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 <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/
> 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] Got incomplete multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8 SOGo 3.2.6a

2017-02-12 Thread imfromtheh...@gmail.com
Hello,
You mean  about email sender adress?
I guess it's is not sogo issue, email address wich we recieving icorrect
headers used for automatic annocement's posting.
But on rouncube we dont have such error's.

2017-02-12 14:47 GMT+03:00 André Schild <users@sogo.nu>:

> Hello,
>
>
> have you a way to track it down to a specific email?
>
>
> André
>
> Am 10.02.2017 um 18:30 schrieb Никита (imfromtheh...@gmail.com):
>
> Hello everyone,
> I have sogo version 3.2.6a sogo installed, The problem is sometimes i
> have wrong character encodings in a mail topic (incorrect sender name). Here
> is a part of my sogo.log Feb 10 20:19:26 sogod [100573]:
> <0x0x7fcaf7350bc0[NSString]> Got incomplete multibyte sequence. ToEncode:
> UTF-16LE FromEncode: UTF-8 Feb 10 20:19:26 sogod [100573]:
> <0x0x7fcaf7350bc0[NSString]> Got invalid multibyte sequence. ToEncode:
> UTF-16LE FromEncode: UTF-8. I tried to find any information, and i dont
> found anything.
> -- users@sogo.nu https://inverse.ca/sogo/lists
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Got incomplete multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8 SOGo 3.2.6a

2017-02-11 Thread imfromtheh...@gmail.com
Hello everyone,
I have sogo version 3.2.6a sogo installed,
The problem is sometimes i have wrong character encodings in a mail topic
(incorrect sender name).

Here is a part of my sogo.log
Feb 10 20:19:26 sogod [100573]: <0x0x7fcaf7350bc0[NSString]> Got incomplete
multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8
Feb 10 20:19:26 sogod [100573]: <0x0x7fcaf7350bc0[NSString]> Got invalid
multibyte sequence. ToEncode: UTF-16LE FromEncode: UTF-8.

I tried to find any information, and i dont found anything.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] How-to set default-cache policy for sogo repository? To: users@sogo.nu

2017-02-05 Thread imfromtheh...@gmail.com
Hi everyone.
My system is a Debian 7
and my sourceslist contains:

deb http://http.debian.net/debian wheezy main
deb-src http://http.debian.net/debian wheezy main

deb http://http.debian.net/debian wheezy-updates main
deb-src http://http.debian.net/debian wheezy-updates main

deb http://security.debian.org/ wheezy/updates main
deb-src http://security.debian.org/ wheezy/updates main
deb http://ftp.debian.org/debian wheezy-backports main
deb http://packages.inverse.ca/SOGo/nightly/3/debian/ wheezy wheezy

But i cant install sogo third version, instead sogo version 2 installing
everytime,

apt-cache policy sogo
sogo:
  Установлен: 1.3.16-1
  Кандидат:   1.3.16-1
  Таблица версий:
 2.0.5a-1~bpo70+1 0
100 http://ftp.debian.org/debian/ wheezy-backports/main i386
Packages
 *** 1.3.16-1 0
500 http://http.debian.net/debian/ wheezy/main i386 Packages
100 /var/lib/dpkg/status
root@mail:/etc/sogo#
How to change default repository to inverse repo?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists