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 > 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 > 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 > 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 > 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 > 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 > 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 > 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 > 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. 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. Perha
Re: [SOGo] Collected Address Book?
On Jun 17, 2014, at 8:19 PM, Ludovic Marcotte wrote: > On 2014-06-17, 5:16 PM, tzm@gmail.com wrote: >> Anybody know what this is Collected Address Book is and how to make it go >> away? > From the "Mail Options" Preferences pane, uncheck " When sending mail, add > unknown recipients to my" and delete the contacts collection. Thanks Ludovic for the info. But it was already unchecked. Also, deleting the Collected acts as a ghost. Upon logging out and logging back in to the Sogo web interface the Collected reappears. The only way to get it to work is to select "When sending mail..", then choose, in our case, the Public group. Then it disappears from the iPhone and won't reappear in the web interface. It seems like unchecking the box doesn't matter. Like the gui isn't doing anything and it is coded to always be on(checked). But the bigger issue is this would have to be done to our 150 users individually. And…none of the users have ever seen the web interface as we only use Sogo as a CardDav server. Using only the Contact app in 10.9.3 and IOS 7 contacts. So, can this Collected Address Book be turned off globally? Thanks. Todd-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGoSuperUsers
Hi, > Could you please try the following as sogo user? > > defaults write sogod SOGoSuperUsernames '( sogoadmin )' > > And restart everything above. this did the trick, sogoadmin is now a sogo admin.. Setting ended up in ~sogo/GNUstep/Defaults/.GNUstepDefaults as expected. I would appreciate any pointers on why / how to make it work if configured in /etc/sogo/sogo.conf though.. lg, rupi -- Rainer Ruprechtsberger Volkshilfe Oberösterreich EDV 4020 Linz, Glimpfingerstrasse 48 Tel.: +43 732 3405 123 Mobil.: +43 676 8734 1123 ZVR Zahl: 064371505 Volkshilfe. Wir haben Ideen, die viel bewegen. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGoSuperUsers
2014-06-18 09:53 keltezéssel, Rainer Ruprechtsberger írta: Hi, Could you please try the following as sogo user? defaults write sogod SOGoSuperUsernames '( sogoadmin )' And restart everything above. this did the trick, sogoadmin is now a sogo admin.. Setting ended up in ~sogo/GNUstep/Defaults/.GNUstepDefaults as expected. I would appreciate any pointers on why / how to make it work if configured in /etc/sogo/sogo.conf though.. Excellent question... -- users@sogo.nu https://inverse.ca/sogo/lists
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 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 repos for Ubuntu Trusty 14.04
Any news on the repositories? On 06/01/2014 07:40 AM, Ludovic Marcotte wrote: On 2014-05-31, 11:46 AM, Steve Ankeny wrote: Perhaps Inverse is not finished revising their repositories? Things are almost ready in this regard - expect more details next week on this. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] "PROPFIND /SOGo/" and "OPTIONS /SOGo/" in the logs
Hi list! I'm a new user of SOGo, I'm running it on a debian wheezy VPS using inverse's debian package. Sogo listens on localhost:2 and i have an nginx instance setup as a reverse proxy, a pretty standard configuration I presume. My users, about 25, use a mixture of Thunderbird (with lightning and sogo connector) and the web interface, and they are pretty happy so far. I have an issue though, in my sogo logfile I very often see this kind of things: 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.023 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.037 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "PROPFIND /SOGo/ HTTP/1.0" 200 3947/306 0.035 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "PROPFIND /SOGo/ HTTP/1.0" 200 3947/306 0.049 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "PROPFIND /SOGo/ HTTP/1.0" 200 3947/306 0.013 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.009 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.019 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.015 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "PROPFIND /SOGo/ HTTP/1.0" 200 3947/306 0.023 12401 68% 0 127.0.0.1 - - [17/Jun/2014:10:36:13 GMT] "OPTIONS /SOGo/ HTTP/1.0" 200 3947/0 0.035 12401 68% 0 and it goes on and on, forever, to the point that the sogo process reaches 90% of my cpu and I have to restart it. It happens so often that I ended up with a crontab restarting the sogo server every 5 minutes. Does anyone have an idea of what's going on? Is there some kind of misconfiguration on my side? I can provide configuration files. Any help appreciated. Cheers, -- Mat signature.asc Description: Digital signature
Re: [SOGo] Outlook logon to SOGo/OpenChange/Samba fails
On 17 Jun 2014, at 19:02, Anantha Padmanaban Potty wrote: > and yes, I have run openchange_newuser --create USERNAME. Also run the > openchange_provision and openchange_provision --openchangedb commands as > instructed ... > > could something be missing from the openchange_newuser script? could you > point me to what can be checked to verify whether the script has *REALLY* > done what it is supposed to? I remember that when installing from source openchange commands had to be run from source directory rather then from install one. E.g if your git checkout was in ~/openchange then you’d run ~/openchange/setup/openchande_newuser —create …. etc. instead from install directory (/usr/local) BTW, install doc is not great, there are some redundant / incorrect steps in it. I got to working setup combining various docs from sogo.nu, openchage.org and iabsis.com and understanding what is done in each step. My plan was to write a “proper” setup documentation, but did not get a chance yet. :( Best Regards Martin. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] preferences - save and close (error)
Hi Ludovic Marcotte, thanks for the info: The result of telnet from SOGO1 is: telnet sogosrv 4190 Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. "IMPLEMENTATION" "Dovecot Pigeonhole" "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave" "NOTIFY" "mailto" "SASL" "PLAIN" "STARTTLS" "VERSION" "1.0" OK "Dovecot ready." authenticate "plain" "xxx..." OK "Logged in." the result of telnet from SOGO2 is: telnet sogosrv 4190 Trying 192.168.168.232... Connected to sogodb. Escape character is '^]'. "IMPLEMENTATION" "Dovecot Pigeonhole" "SIEVE" "fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-umeric relational regex imap4flags copy include variables body enotify environment mailbox ate ihave" "NOTIFY" "mailto" "SASL" "" "STARTTLS" "VERSION" "1.0" OK "Dovecot ready." authenticate "plain" "XXX..." NO [ENCRYPT-NEEDED] "Authentication not allowed until SSL/TLS is enabled." BYE "Disconnected for inactivity." Connection closed by foreign host. - I hope it is helpful Do you neet some config files ? thanks for your help -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Dovecot shared mailbox dictionary via SOGo
On 17/06/14 23:24, Ludovic Marcotte wrote: > Create a brand new ActiveSync profile on Android and only sync the > address book. While doing so, sniff the traffic using tcpdump on port > 2 from your SOGo server. Send the pcap over privately. I'm working with Ludovic off-line on this one as requested... > How wrong? What is the URL being generated? Show your SOGo Integrator > customizations and your sogo.conf file. I'm feeling rather silly now. it turns out that the problem all along was a mixture of errors in my Dovecot and AutoMX (used to auto-configure Thunderbird, Outlook, etc. with mail account details) configurations. These were causing the original problem with the incorrect entries in the shared dictionary. I have reverted to using a simple username (sAMAccountName as it's Active Directory) to identify my users uniquely in Dovecot. My mistake was returning mail as the attribute instead of sAMAccountName as the "user" variable in my auth-ldap.conf.ext file (pass_attrs entry). I've also now switched the Dovecot auth_username_format parameter from %Lu to %Ln. These two changes have made shared folders work in SOGo and Thunderbird without the need for a domain name in the shared dictionary file. The inconsistency in the SOGo Integrator occurred when I was using domain extensions. On a fresh Thunderbird profile it was generating URLs with the correct user@domain in them for calendars but "forgetting" the @domain part of the URL for contacts. Although confusing, it is working as designed. The calendar URLs must be queried from the SOGo database in some way, whereas the contact ones are constructed locally using the IMAP username. We use AutoMX to look-up e-mail addresses in our Active Directory and publish autoconfig/discovery information for Thunderbird. This was still returning just the plain username and hence the account username for the IMAP account in Thunderbird did not contain the @domain part. As we have reverted to using simple usernames, our AutoMX configuration (returning sAMAccountName for the IMAP username) is now correct and the SOGo Integrator and everything else is happy. Sorry for the noise about this but hope it helps someone else in the future? It's a complex business integrating all these products but is great when it eventually works! -- Ian McMichael • E-Mail: ian.mcmich...@gmail.com • Phone: +44-(0)7703-192837 -- 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 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
[SOGo] BTS activities for Wednesday, June 18 2014
Title: BTS activities for Wednesday, June 18 2014 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Wednesday, June 18 2014 idlast updatestatus (resolution)categorysummary 2822 2014-06-18 18:12:21 updated (open) Backend Calendar Copying event with attendees and repeating 2820 2014-06-18 08:51:47 updated (open) Backend Mail NGImap4ParserException while processing a broken multipart email -> SOGo frontend will not list emails 1840 2014-06-18 10:56:52 updated (open) Web Calendar Audio reminders / notifications / alerts via the WebUI 2819 2014-06-18 07:21:17 updated (open) Web Calendar SOGo allows you to set nonsense recurrence until date and event then fails to display at all 2821 2014-06-18 09:58:06 updated (open) Web Mail ISSUE 0002675: Error adding a second attachment 2745 2014-06-18 09:02:03 assigned (reopened) Web Mail Crash if generated sieve script is larger than 8192B