[SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
Hello, we have a serious problem with database connection. Events cannot be stored. From the logs: Mar 01 12:04:30 sogod [31801]: [ERROR] <0x7fb1c8daef00[SOGoAppointmentFolders]:Calendar> a database error occured: Can't connect to MySQL server on 'sogo-db' (111) Mar 01 12:04:30 sogod [31801]: <0x7fb1c8e7d960[SOGoCacheGCSObject]:69D0A7B538974937AC6B42382E34C614> an exception occurred when executing query 'SELECT * FROM sogo_cache_folder WHERE c_path = '/69D0A7B538974937A C6B42382E34C614' AND c_uid = ''' What happened? What can I do to fix it? Regards -- R. Cirksena -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
On Wed, Mar 01, 2017 at 12:11:35PM +0100 I wrote: > we have a serious problem with database connection. Events cannot be > stored. From the logs: > > Mar 01 12:04:30 sogod [31801]: [ERROR] > <0x7fb1c8daef00[SOGoAppointmentFolders]:Calendar> a database error occured: > Can't connect to MySQL server on 'sogo-db' (111) > Mar 01 12:04:30 sogod [31801]: > <0x7fb1c8e7d960[SOGoCacheGCSObject]:69D0A7B538974937AC6B42382E34C614> an > exception occurred when executing query 'SELECT * FROM sogo_cache_folder > WHERE c_path = '/69D0A7B538974937A > C6B42382E34C614' AND c_uid = ''' > > What happened? What can I do to fix it? Calender entries are not writable from the web interface. From Thunderbird or Outlook it works (mostly). From time to time Thunderbird complains: "Status-Code: 2147746065, Die Anfrage kann nicht verarbeitet werden. Server Replied with 503" Translated: "Status-Code: 2147746065, The request can not be processed. Server Replied with 503" Regards -- R. Cirksena -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
Seems that the connection to your MySQL Database does not work (not a SOGo issue). Pls check if your database Server is up and MySQL is reachable. Am Mi, 1. Mär 2017, um 12:11, schrieb Ralf Cirksena: > Hello, > > we have a serious problem with database connection. Events cannot be > stored. From the logs: > > Mar 01 12:04:30 sogod [31801]: [ERROR] > <0x7fb1c8daef00[SOGoAppointmentFolders]:Calendar> a database error > occured: Can't connect to MySQL server on 'sogo-db' (111) > Mar 01 12:04:30 sogod [31801]: > <0x7fb1c8e7d960[SOGoCacheGCSObject]:69D0A7B538974937AC6B42382E34- > C614> an > exception occurred when executing query 'SELECT * FROM > sogo_cache_folder > WHERE c_path = '/69D0A7B538974937A > C6B42382E34C614' AND c_uid = ''' > > What happened? What can I do to fix it? > > > Regards > -- > R. Cirksena > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
Am 01.03.2017 um 13:28 schrieb Ralf Cirksena (c...@holmco.de): > On Wed, Mar 01, 2017 at 12:11:35PM +0100 I wrote: > >> we have a serious problem with database connection. Events cannot be >> stored. From the logs: >> >> Mar 01 12:04:30 sogod [31801]: [ERROR] >> <0x7fb1c8daef00[SOGoAppointmentFolders]:Calendar> a database error occured: >> Can't connect to MySQL server on 'sogo-db' (111) >> Mar 01 12:04:30 sogod [31801]: >> <0x7fb1c8e7d960[SOGoCacheGCSObject]:69D0A7B538974937AC6B42382E34C614> an >> exception occurred when executing query 'SELECT * FROM sogo_cache_folder >> WHERE c_path = '/69D0A7B538974937A >> C6B42382E34C614' AND c_uid = ''' >> >> What happened? What can I do to fix it? > > Calender entries are not writable from the web interface. From > Thunderbird or Outlook it works (mostly). From time to time > Thunderbird complains: > > "Status-Code: 2147746065, Die Anfrage kann nicht verarbeitet werden. > Server Replied with 503" > > Translated: > "Status-Code: 2147746065, The request can not be processed. > Server Replied with 503" > Can you connect to your mysql server on sogo-db? If yes, check your mysql logs. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416 smime.p7s Description: S/MIME Cryptographic Signature
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
On Wed, Mar 01, 2017 at 01:35:14PM +0100 you wrote: > Seems that the connection to your MySQL Database does not work (not a > SOGo issue). Pls check if your database Server is up and MySQL is > reachable. Meanwhile I found out that max # of connections of the mysql server exhausted. SOGo processes requested more than 150 database connections. I increased the limit to 250 (never had to do that in the last 10 years of working with MySQL). During the last few hours we did not see more than about 60 open connections. Will keep an eye on that. Regards -- R. Cirksena -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
On Wed, Mar 01, 2017 at 02:21:03PM +0100 you wrote: > Am 01.03.2017 um 13:28 schrieb Ralf Cirksena (c...@holmco.de): > > On Wed, Mar 01, 2017 at 12:11:35PM +0100 I wrote: > > > >> we have a serious problem with database connection. Events cannot be > >> stored. From the logs: > >> > >> Mar 01 12:04:30 sogod [31801]: [ERROR] > >> <0x7fb1c8daef00[SOGoAppointmentFolders]:Calendar> a database error > >> occured: Can't connect to MySQL server on 'sogo-db' (111) > >> Mar 01 12:04:30 sogod [31801]: > >> <0x7fb1c8e7d960[SOGoCacheGCSObject]:69D0A7B538974937AC6B42382E34C614> an > >> exception occurred when executing query 'SELECT * FROM sogo_cache_folder > >> WHERE c_path = '/69D0A7B538974937A > >> C6B42382E34C614' AND c_uid = ''' > >> > >> What happened? What can I do to fix it? > > > > Calender entries are not writable from the web interface. From > > Thunderbird or Outlook it works (mostly). From time to time > > Thunderbird complains: > > > > "Status-Code: 2147746065, Die Anfrage kann nicht verarbeitet werden. > > Server Replied with 503" > > > > Translated: > > "Status-Code: 2147746065, The request can not be processed. > > Server Replied with 503" > > > > Can you connect to your mysql server on sogo-db? > If yes, check your mysql logs. As I wrote in my other mail there was in fact a problem with open database connections. But the problem that I cannot save events (new or while changing them) from within the web interface remains. Regards -- R. Cirksena -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ActiceSync w/outlook 2016
any help will be great, thanks Ivan Gonzalez Jr. x101 NocRoom | ceo | e: iva...@nocroom.com w: NocRoom.com [http://nocroom.com/] West Coast/Las Vegas 702-789-0409 | East Coast/Miami 786-802-7666 [ social tw [http://twitter.com/nocroom] | fb [http://fb.com/miaminetwork] | in [http://linkedin.com/company/nocroom] | g+ [https://url.nocroom.com/ODF8S] ] Turnkey Solution | Virtualization Kings – Dedicated Servers – Cloud Email Servers – Cloud PBX Hosted Systems - Bitcoin ok All emails from NocRoom.com are encrypted IMPORTANT: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If the reader is not the intended recipient, please notify us immediately by return e-mail and delete the original message from your e-mail system. Any dissemination, distribution or copying of the communication is strictly prohibited. This correspondence is being transmitted for informational purposes only and the views, opinions and any electronic signatures of the sender are not intended to bind NocRoom LLC. On 2/27/2017 4:02:57 PM, Ivan Gonzalez wrote: just noticed it is added was in /etc/nginx/templates/sogo.tmpl # Settings for SOGo Groupware # SOGo location ~ ^/sogo { rewrite ^ https://$host/SOGo; } location ~ ^/SOGO { rewrite ^ https://$host/SOGo; } # For Mac OS X and iOS devices. rewrite ^/.well-known/caldav /SOGo/dav permanent; rewrite ^/.well-known/carddav /SOGo/dav permanent; rewrite ^/principals/ /SOGo/dav permanent; location ^~ /SOGo { proxy_pass http://127.0.0.1:2; #proxy_redirect http://127.0.0.1:2/SOGo/ /SOGo; # forward user's IP address #proxy_set_header X-Real-IP $remote_addr; #proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; #proxy_set_header Host $host; proxy_set_header x-webobjects-server-protocol HTTP/1.0; #proxy_set_header x-webobjects-remote-host 127.0.0.1; #proxy_set_header x-webobjects-server-name $server_name; proxy_set_header x-webobjects-server-url $scheme://$host; } location ^~ /Microsoft-Server-ActiveSync { proxy_pass http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync; proxy_redirect http://127.0.0.1:2/Microsoft-Server-ActiveSync /; proxy_connect_timeout 3540; proxy_send_timeout 3540; proxy_read_timeout 3540; } location ^~ /SOGo/Microsoft-Server-ActiveSync { proxy_pass http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync; proxy_redirect http://127.0.0.1:2/SOGo/Microsoft-Server-ActiveSync /; proxy_connect_timeout 3540; proxy_send_timeout 3540; proxy_read_timeout 3540; } location /SOGo.woa/WebServerResources/ { alias /usr/lib/GNUstep/SOGo/WebServerResources/; } location /SOGo/WebServerResources/ { alias /usr/lib/GNUstep/SOGo/WebServerResources/; } location ^/SOGo/so/ControlPanel/Products/([^/]*)/Resources/(.*)$ { alias /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2; } Ivan Gonzalez Jr. x101 NocRoom | ceo | e: iva...@nocroom.com w: NocRoom.com [http://nocroom.com/] West Coast/Las Vegas 702-789-0409 | East Coast/Miami 786-802-7666 [ social tw [http://twitter.com/nocroom] | fb [http://fb.com/miaminetwork] | in [http://linkedin.com/company/nocroom] | g+ [https://url.nocroom.com/ODF8S] ] Turnkey Solution | Virtualization Kings – Dedicated Servers – Cloud Email Servers – Cloud PBX Hosted Systems - Bitcoin ok All emails from NocRoom.com are encrypted IMPORTANT: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If the reader is not the intended recipient, please notify us immediately by return e-mail and delete the original message from your e-mail system. Any dissemination, distribution or copying of the communication is strictly prohibited. This correspondence is being transmitted for informational purposes only and the views, opinions and any electronic signatures of the sender are not intended to bind NocRoom LLC. On 2/27/2017 8:11:42 AM, Christian Mack wrote: Hello You are right, this config is missing. The below FAQ is for running 2 different SOGo servers on the same maschine, one for ActiveSync, the other for the web interface and calDAV+cardDAV. That is not what you want. For nginx config see http://wiki.sogo.nu/nginxSettings At the bottom is what you need. Kind regards, Christian Mack Am 27.02.2017 um 16:56 schrieb "Ivan Gonzalez" (iva...@nocroom.com): > Doesnt look like activesync is config on nginx, unless you see it and i dont > > i take it that i follow the steps here for Debian 8? > https://sogo.nu/nc/support/faq/article/dedicated-separate-sogo-instance-for-activesync.html > > > > Ivan Gonzalez Jr. x101 > NocRoom | ceo | e: iva...@nocroom.com w: NocRoom.com [http://nocroom.com/] > West Coast/Las Vegas 702-789-0409 | East Coast/Miami 786-802-7666 [ social tw > [http://twitter.com/nocroom] | fb [http://fb.com/miaminetwork] | in > [http://linkedin.com/company/nocroom] | g+ [https://url.nocroom.com/ODF8S] ] > > Turnkey Solution |
Re: [SOGo] URGENT: "can't connect to MySQL server on sogo-db"...
On 2017-03-01 9:57 AM, Ralf Cirksena (c...@holmco.de) wrote: But the problem that I cannot save events (new or while changing them) from within the web interface remains. You mean the save button is disabled? If so, upgrade again to the latest nightly build. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu), PacketFence (http://packetfence.org) and Fingerbank (http://fingerbank.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Wednesday, March 01 2017
Title: BTS activities for Wednesday, March 01 2017 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, March 01 2017 idlast updatestatus (resolution)categorysummary 4050 2017-03-01 20:09:38 updated (open) ActiveSync Confidential and private entries exposed in Outlook (ActiveSync) 4059 2017-03-01 03:51:40 updated (open) ActiveSync Reminders from subscribed calendars always show up regardless of how you set the "show alarms" for the caledar 4060 2017-03-01 06:26:27 updated (open) ActiveSync Recurring events in the eas client are shown in the wrong time zone 4061 2017-03-01 01:35:37 updated (open) ActiveSync Unable to sync contacts with the exchange connector in Android 3992 2017-03-01 16:25:17 updated (open) Backend Calendar Double mailto: when creating an event with invitees in another calendar 4051 2017-03-01 13:43:34 updated (open) Backend Calendar Exceptions to recurring events not handled properly during resource reservations 3933 2017-03-01 11:24:47 updated (open) Web General SAML authentication does not work with XHR requests 1456 2017-03-01 11:22:43 resolved (fixed) Backend General CAS Authentication : CAS session timeout leads to bad parameters when adding a new appointment 2425 2017-03-01 11:24:09 resolved (fixed) Web Mail Invalid "no recipient" warning when sending mail with CAS authentication 4053 2017-03-01 15:14:48 resolved (fixed) Web Mail SOGoMailAutoSave not working as a system preference 4034 2017-03-01 16:04:49 closed (not a bug) ActiveSync Outlook 2016 and Outlook 2013 free/busy funktion for the Calendar is not working with ActiveSync 4057 2017-03-01 11:33:14 closed (not a bug) Web Preferences Malfunctioning while changing password from Web UI -- users@sogo.nuhttps://inverse.ca/sogo/lists