Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 6/18/2014 4:17 PM, Charles Marcus cmar...@media-brokers.com wrote: How many connections does SOGo use for each user, and how are they counted? For example, is it one connection per user? Per user per shared resource (calendar, address book)? Would appreciate a response to this very simple question. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 2014-06-25, 11:58 AM, Charles Marcus wrote: How many connections does SOGo use for each user, and how are they counted? For example, is it one connection per user? Per user per shared resource (calendar, address book)? Would appreciate a response to this very simple question. 2 db connections per sogod processes will be used and most likely not more than 2 for sogo-tool either. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 6/25/2014 3:13 PM, Ludovic Marcotte lmarco...@inverse.ca wrote: On 2014-06-25, 11:58 AM, Charles Marcus wrote: How many connections does SOGo use for each user, and how are they counted? 2 db connections per sogod processes will be used and most likely not more than 2 for sogo-tool either. Thanks Ludo - but can you elaborate on what is meant by 'sogod process' above, so I understand how to determine how many I need to allow for? Is there one sogod process per user+IP? Or maybe per user+IP+resource? For example, if a user has access to 3 calendars and 3 address books, and they access these from 2 different computers running thunderbird+Integrator+Connector, as well as their phone, do they use 3 sogod process (6 db connections)? Or 18 (36 db connections)? Or something else? Thanks very much... Charles -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 2014-06-25, 3:23 PM, Charles Marcus wrote: For example, if a user has access to 3 calendars and 3 address books, and they access these from 2 different computers running thunderbird+Integrator+Connector, as well as their phone, do they use 3 sogod process (6 db connections)? Or 18 (36 db connections)? Or something else? If you have 3 sogod processes, it'll use 6 connections. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 2014-06-25, 4:21 PM, Tanstaafl wrote: But what determines how many sogod processes will be used? http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf Search for WOWorkersCount. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 6/17/2014 10:24 AM, Charles Marcus cmar...@media-brokers.com wrote: 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 I got a response on the MariaDB list claiming that the mysql4 protocol is extremely outdated and no longer supported by mariadb (or mysql5.5), so should not be used. So... why is it trying to use the mysql4 protocol? Charles -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
Am 2014-06-17 16:24, schrieb Charles Marcus: I'm re-sending this as a new thread, since it is a new issue. These occasional errors only started right after I updated to 2.2.5, and are only happening, once, or yesterday, twice per day. I saw not one of these in the prior 3 months of using SOGo. connect_timeout is set to the default of 10 as it always has. Here are the errors in question (these are all of them since we first started using SOGo in March, as you can see the first one was on 6/12, right after the 2.2.5 update): 2014-06-12 03:30:15.530 sogo-tool[31674] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 0x0x236c140[GCSChannelManager] could not open channel MySQL4Channel[0x0x22241b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x236c140[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-12 03:30:01 -0400 2014-06-12 03:30:15.531 sogo-tool[31674] Can't aquire channel 2014-06-13 03:33:20.201 sogo-tool[6852] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x1d5f140[GCSChannelManager] could not open channel MySQL4Channel[0x0x1c171b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x1d5f140[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-13 03:33:01 -0400 2014-06-13 03:33:20.202 sogo-tool[6852] Can't aquire channel 2014-06-14 11:09:19.303 sogo-tool[16644] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x18c2140[GCSChannelManager] could not open channel MySQL4Channel[0x0x177a1b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x18c2140[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-14 11:09:01 -0400 2014-06-14 11:09:19.304 sogo-tool[16644] Can't aquire channel 2014-06-14 19:29:16.259 sogo-tool[4321] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x1ff4140[GCSChannelManager] could not open channel MySQL4Channel[0x0x1eac1b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x1ff4140[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-14 19:29:01 -0400 2014-06-14 19:29:16.260 sogo-tool[4321] Can't aquire channel 2014-06-15 11:36:12.184 sogo-tool[11336] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x1534410[GCSChannelManager] could not open channel MySQL4Channel[0x0x13ec1b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x1534410[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-15 11:36:02 -0400 2014-06-15 11:36:12.185 sogo-tool[11336] Can't aquire channel 2014-06-16 19:29:17.300 sogo-tool[22163] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x20a4410[GCSChannelManager] could not open channel MySQL4Channel[0x0x1f5c1b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x20a4410[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-16 19:29:01 -0400 2014-06-16 19:29:17.301 sogo-tool[22163] Can't aquire channel 2014-06-17 03:08:22.791 sogo-tool[24540] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 0 0x0x282b410[GCSChannelManager] could not open channel MySQL4Channel[0x0x26e31b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x282b410[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-17 03:08:01 -0400 2014-06-17 03:08:22.792 sogo-tool[24540] Can't aquire channel 2014-06-17 03:32:14.985 sogo-tool[24652] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 0x0x172b410[GCSChannelManager] could not open channel MySQL4Channel[0x0x15e31b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x172b410[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-17 03:32:01 -0400 2014-06-17 03:32:14.988 sogo-tool[24652] Can't aquire channel Anyone have any ideas? Everything seems to be working fine, and like I said, they only happen once per day (except
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
Thanks for the reply Christian - more inline below... On 6/18/2014 4:09 AM, Christian Mack wrote: Am 2014-06-17 16:24, schrieb Charles Marcus: 2014-06-17 03:32:14.985 sogo-tool[24652] ERROR: could not open MySQL4 connection to database 'sogo': Lost connection to MySQL server at 'reading authorization packet', system error: 104 0x0x172b410[GCSChannelManager] could not open channel MySQL4Channel[0x0x15e31b0] connection=0x(null) for URL: mysql://user:passw...@myhost.com:3306/sogo/sogo_sessions_folder 0x0x172b410[GCSChannelManager] will prevent opening of this channel 5 seconds after 2014-06-17 03:32:01 -0400 2014-06-17 03:32:14.988 sogo-tool[24652] Can't aquire channel Anyone have any ideas? Everything seems to be working fine, and like I said, they only happen once per day (except twice today)... We see more connections to the database since SOGo 2.2.4. I'm curious, how many more? In other words, is it a lot (double or more)? Or just a little (10% increase, etc)... Also - I'm curious what you and/or others who are using [my][postgre]sql or mariadb have set for max_connections max_user_connections Are there any connection tuning (preferably sql related, but I imagine the number of connections SOGo requires is similar or the same regardless of what backend is used) recommendations for SOGo anywhere? Searching the install doc for 'connection' didn't reveal anything. This error says, you lost a connection in mid transport of data and it can not open a new one. That is a really generic problem. Perhaps your network is busy. I doubt any of the above. First, the times these happen are outside normal business hours. If it had to do with a busy network, it would be happening during business hours. My network is fairly small - 60 or so users - but, they are all using shared Calendars Address Books (at least 3 of each, more in a few cases), so maybe I do need to tune the mysql connections. Perhaps you run out of port numbers. What do you mean 'run out of port numbers'? This is connecting to mariadb over TCP on port 3306 - one port. Perhaps you have not enough file descriptors. My SOGo server is on a different box than my SQL server - so, do you mean file descriptors on the SOGo box or the SQL box? And wouldn't there be other symptoms? And more importantly, again, this happens at odd times - the first few times at about 3:00am or so, so when the load on the server is at its lowest. But I'll investigate this further. Thanks again -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool 'lost connection' errors afetr update to SOGo 2.2.5
On 6/18/2014 7:00 AM, Tanstaafl tansta...@libertytrek.org wrote: Also - I'm curious what you and/or others who are using [my][postgre]sql or mariadb have set for max_connections max_user_connections Are there any connection tuning (preferably sql related, but I imagine the number of connections SOGo requires is similar or the same regardless of what backend is used) recommendations for SOGo anywhere? Searching the install doc for 'connection' didn't reveal anything. How about a more specific question for the SOGo devs. How many connections does SOGo use for each user, and how are they counted? For example, is it one connection per user? Per user per shared resource (calendar, address book)? Thanks, Charles Marcus I.T. Director Media Brokers International, Inc. 678.514.6224 | 678.514.6299 fax -- users@sogo.nu https://inverse.ca/sogo/lists
