Re: [SOGo] Calendar can't cannot to mysql database, strange configuration error
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
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 channelfor 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
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
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
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