Re: [SOGo] One user unable to see any mail
On a hunch that there was a malformed messgae in the user's inbox, I went ahead and performed a binary search by moving messages into new folders until I found the culprit. Sure enough, I found one message that was causing the user's issue. The only thing that jumps out at me about this message is that the Subject header is multi-line and UTF formatted. Is it possible that SOGo can't handle that? FWIW, Thunderbird did display the message correctly. I have a zip of the problem message in case anyone wants to see it. Here's the subject header: Subject: =?utf-8?B?R2lhbnQgQmFsbCB0byBEcm9wIGF0IE5ldyBZZWFy4oCZcyBFdmUgQmxvd291dCBhdCA=?= =?utf-8?B?VHJhbnNmb3JtZWQgU3RvbmVyaWRnZSBTaG9wcGluZyBDZW50ZXLigKhCZW5lZml0cyA=?= =?utf-8?B?Zm91ciBUcmktVmFsbGV5IENoaWxkcmVu4oCZcyBDaGFyaXRpZXM=?= Chris On Thursday, January 6, 2011 12:57 PM PST, Ludovic Marcotte wrote: On 11-01-06 3:54 PM, Chris Hobbs wrote: > Still need some ideas on this one... thanks! You might want to sniff the IMAP session for that user (SOGo <-> IMAP server). Could be tricky if you don't have a test environment and tons of traffic. Regards, -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. http://mx.nhusd.k12.ca.us/cgi-bin/learn-msg.cgi?id=6575228B90.A48D8 -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean.
Re: [SOGo] One user unable to see any mail
Still need some ideas on this one... thanks! Chris On 1/5/11 2:00 PM, Chris Hobbs wrote: I have an odd one. I have one user (out of thousands) that is unable to see any of his mail any longer in the SOGo web interface. He can log in successfully, view his calendar and his address book, but the folder pane is empty, and the "Get Mail" and "Write" buttons do nothing. Steps taken to trouble shoot: 1) Tried on a different computer with multiple browsers (Firefox, Chrome, Safari). 2) Deleted sogo user with sogo-tool. Logged back in which created sogo account successfully 3) Created account in Thunderbird to confirm IMAP was functioning correctly - it is. I can see SOGo logging into the IMAP server in the dovecot logs, so that isn't the problem. No other users are complaining of the issue, and I've not installed any updates in at least 10 weeks. User claimed it began just before our winter break which started 12/17. Any ideas on what to look at next? Thanks, Chris -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean. -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] One user unable to see any mail
On 1/5/11 3:52 PM, Chris Hobbs wrote: BTW - 'sogo-tool remove' doesn't remove all users data. His preferences (like a position of the separating line in Mail module) stay in the database all the time :-( Good to know - guess I need to go be more aggressive in the mysql database instead. Actually, it does seem that sogo_tool remove does remove all trace of the user. At least I can't find him anymore in sogo_user_profile or sogo_folder_info after his removal. When he logs in again, entries in both are created with new path names in sogo_folder_info. -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] One user unable to see any mail
On 1/5/11 2:54 PM, Milos Wimmer wrote: On Wed, 5 Jan 2011, Chris Hobbs wrote: I have an odd one. I have one user (out of thousands) that is unable to see any of his mail any longer in the SOGo web interface. He can log in successfully, view his calendar and his address book, but the folder pane is empty, and the "Get Mail" and "Write" buttons do nothing. I had one similar case. The reason of it was user had separating line (in between list of header lines and message body) moved to top of the window - so no headers of messages were displayed). Moving separating line down solved it ;-) Do you see that line? We've seen that issue as well, but that isn't the problem in this case. In fact, that's what I fully expected to find when I got the squawk :) BTW - 'sogo-tool remove' doesn't remove all users data. His preferences (like a position of the separating line in Mail module) stay in the database all the time :-( Good to know - guess I need to go be more aggressive in the mysql database instead. Chris -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] One user unable to see any mail
I have an odd one. I have one user (out of thousands) that is unable to see any of his mail any longer in the SOGo web interface. He can log in successfully, view his calendar and his address book, but the folder pane is empty, and the "Get Mail" and "Write" buttons do nothing. Steps taken to trouble shoot: 1) Tried on a different computer with multiple browsers (Firefox, Chrome, Safari). 2) Deleted sogo user with sogo-tool. Logged back in which created sogo account successfully 3) Created account in Thunderbird to confirm IMAP was functioning correctly - it is. I can see SOGo logging into the IMAP server in the dovecot logs, so that isn't the problem. No other users are complaining of the issue, and I've not installed any updates in at least 10 weeks. User claimed it began just before our winter break which started 12/17. Any ideas on what to look at next? Thanks, Chris -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Event disappears from all but organizer
One of our admins described for me an issue where she would invite several (~8) users to a meeting via SOGo web. She has delegated access to many of their calendars and could see that the event correctly appeared on their calendars. At some point subsequent to that, and with no action taken on the other users' parts, the event disappeared from all calendars except the admin/organizer. She could fix it by simply re-opening the event to edit and then "Save & Close". However, that's only useful when she knows the item disappeared. Since she had already repaired the events she was aware of, we looked through her calendar for a few minutes trying to find an unfixed example. We couldn't, so I asked her to let me know when it happened again before she fixed it so I could see it. Not five minutes later she was back in my office with another example and I was able to confirm what she reported. We're running a relatively recent nightly: 201010241123 Any ideas? What further info might I try to find for troubleshooting? -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean.
Re: [SOGo] Web Interface
On Monday, November 8, 2010 11:57 AM PST, Chris Hobbs wrote: On 11/8/10 1:57 AM, ghido wrote: > - possibility to use "modify as new" Here's a hack for that. Copy the message to your Drafts folder. You can re-edit from there. Would like the feature enabled directly though :-) BTW, there's a bug open for this request at: http://www.sogo.nu/bugs/view.php?id=686 -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean.
Re: [SOGo] Web Interface
On 11/8/10 1:57 AM, ghido wrote: - possibility to use "modify as new" Here's a hack for that. Copy the message to your Drafts folder. You can re-edit from there. Would like the feature enabled directly though :-) -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Access from iPad fails
Did you go into the Calendar settings on the iPad and tell it to Sync All Items? I had the same issue until I performed that (documented) step. Chris On 10/12/10 3:14 AM, Stefan Peter wrote: Hello everybody, i tried to use the Virtual Appliance (ZEG) with a iPad (Web, Thunderbird, iCal works fine). But it didn't work. The iPad respectively the standard calendar app tries endless to get data. In the server-log I found these messages (see below). Via Google I found no answer to solve the problem. Maybe anyone has a tip? Would be very nice. Ciao! Stefan ... 192.168.2.66 - - [12/Oct/2010:01:32:38 +] "PROPFIND /SOGo/dav/sogo1/ HTTP/1.1" 401 243 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:38 +] "PROPFIND /SOGo/dav/sogo1/ HTTP/1.1" 207 1282 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:38 +] "PROPFIND /SOGo/dav/sogo1/Calendar/ HTTP/1.1" 207 7395 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:38 +] "REPORT /SOGo/dav/sogo1/Calendar/359-4CB32E00-7-727EDB00/ HTTP/1.1" 207 710 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:49 +] "PROPFIND /SOGo/dav/sogo1/ HTTP/1.1" 401 243 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:49 +] "PROPFIND /SOGo/dav/sogo1/ HTTP/1.1" 207 1282 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:49 +] "PROPFIND /SOGo/dav/sogo1/Calendar/ HTTP/1.1" 207 7395 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" 192.168.2.66 - - [12/Oct/2010:01:32:49 +] "REPORT /SOGo/dav/sogo1/Calendar/personal/ HTTP/1.1" 207 695 "-" "DAVKit/5.0 (752); iCalendar/1 (42.1); iPhone/3.2.2 7B500" ... 192.168.2.66 is my iPad in my local net. -- This message was scanned by ESVA and is believed to be clean. Click here to report this message as spam. <http://mx.nhusd.k12.ca.us/cgi-bin/learn-msg.cgi?id=6E62B106F8C.A74D7> -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] found no viewer for MIME type: application/msword
On 10/4/10 1:11 PM, Ludovic Marcotte wrote: Oct 04 12:30:33 sogod: SOGo watchdog [28196]: [ERROR] <0x0x24e3040[WOWatchDogChild]> FAILURE receiving status for child 28228 You might want to see what's causing "Stale mailbox lock file detected" - this message is coming from your IMAP server. Thanks Ludovic. It was (not surprisingly) self-inflicted. I had brought up a second Dovecot 1.2 server and was splitting the load with haproxy. Apparently that was dumb :-) Time to get Dovecot 2.0 with its built-in balancer (with user persistence) up and running here. Chris -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] 1.3.2 and IMAP errors
On 9/22/10 1:58 PM, Ludovic Marcotte wrote: On 22/09/10 3:48 PM, Chris Hobbs wrote: And I meant to mention that there are not corresponding errors in our dovecot logs. Not that I don't trust you but I find it strange that SOGo tries to connect, simply can't and you don't see anything in your Dovecot logs. I hear you, and was surprised myself. That's why I was running simultaneous "tail -f" on both servers' log files and watched the sogo errors scrolling by while dovecot was quiet. Perhaps it was a network error at that time? (lame or buggy switch, flaky network cable or vacuum-cleaner-used-too-close-of-your-gears) I wish it were that easy, but both are servers are VMs running in the same ESX host, so I don't think we're dealing with network issues. And switching back to 1.3.0 resolved things instantly. -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] 1.3.2 and IMAP errors
On 9/22/10 12:46 PM, Chris Hobbs wrote: Sep 22 10:58:14 sogod: SOGo watchdog [28555]: [ERROR] <0x0x2987490[NGImap4ConnectionManager]> IMAP4 login failed: host=10.3.1.41, user=lhamann, pwd=yes url=imap://lham...@10.3.1.41/INBOX/ base=(nil) base-class=(nil)) = <0x0x2f69540[NGImap4Client]: login=lhamann(pwd) socket=address=<0x0x2e8a1b0[NGInternetSocketAddress]: host=sogo2.nhusd.k12.ca.us port=55537 > connectedTo=<0x0x2e2ea60[NGInternetSocketAddress]: host=10.3.1.41 port=143>>> And I meant to mention that there are not corresponding errors in our dovecot logs. -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] 1.3.2 and IMAP errors
Built a new box with 1.3.2 last night and pointed our proxy at it. Everything looked fine last night, but under load this morning it started falling over badly, with lots of errors about Folders not being IMAP4 folders, messages not being sent, etc. sogo.log has lots of these sorts of errors in it: Sep 22 10:58:14 sogod: SOGo watchdog [28555]: [ERROR] <0x0x2987490[NGImap4ConnectionManager]> IMAP4 login failed: host=10.3.1.41, user=lhamann, pwd=yes url=imap://lham...@10.3.1.41/INBOX/ base=(nil) base-class=(nil)) = <0x0x2f69540[NGImap4Client]: login=lhamann(pwd) socket=address=<0x0x2e8a1b0[NGInternetSocketAddress]: host=sogo2.nhusd.k12.ca.us port=55537 > connectedTo=<0x0x2e2ea60[NGInternetSocketAddress]: host=10.3.1.41 port=143>>> I've reverted back to 1.3.0 until I can get this sorted. Any ideas? Thanks, -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Slow Script errors in Firefox & Safari
Hi All, We regularly have users with relatively modern computers complain that their browser sessions freeze with warnings of slow or unresponsive scripts in SOGo. These users are running Firefox 2.x and 3.6.6-9 on both Mac and Windows, as well as Safari on Macs. Of course, I can't seem to reproduce it myself, so it's hard to get a handle on what causes it. A few of the users have 2000-4000 messages in their INBOX, but others have 100-300, so it doesn't seem to be a volume issue. Any ideas on how to start troubleshooting this? Thanks, -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BCC Visibility
We've recently realized that SOGo completely hides the BCC list from the Sender of a message. This seems different than how most (or at least many) e-mail clients handle this. For example, if I send a message in Thunderbird with BCCs, the BCC headers remain on my message and are visible in my Sent folder. SOGo appears to do two different things oddly here: 1) It doesn't store the BCC headers on the Sent message like TB does 2) It doesn't display the BCC headers in the Sent folder header pane, even if the headers are there in the source. Is this behavior by design, or just something that hasn't come up before? If it isn't by design, would it be appropriate to file an RFE for it? Thanks, -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Sync Iphone calendar
On 9/7/10 8:22 AM, Mark Adams wrote: Make sure your iPhone is set to "Sync all events" right at the bottom of the initial Mail,Contacts,Calendars config. +1 on this. I spent a couple of weeks frustrated by this until I read *all* of the instructions provided and made this change. Has worked great ever since :-) -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Modifying Calendar Entries
Any ideas on this? On 8/23/10 10:27 AM, Chris Hobbs wrote: We use a calendar to keep track of substitute teacher requests in our district. I've set up a calendar for that purpose, and granted the user that will be managing those requests full access to it (Modify on everything, and Add/Delete permissions). Schools request substitutes by inviting the 'subs' calendar to a meeting. 15 minutes == 1 sub. So if a school needs 4 subs on the 20th, the school secretary schedules a 1 hour meeting with the 'subs' calendar. The problem is that the person in charge of managing the subs cannot modify the events that have been created, since 'subs' is merely an attendee and not the organizer. Optimally, we'd like this person to be able to modify the category of the item to reflect its state in processing (approved and filled). I realize that SOGo is working as designed in this situation, and that using a calendar in this way to manage subs in completely weird, but I'm wondering if anyone has any ideas on how we might make this work. I'm not above mucking about in the database to deal with this if I need to... Thanks! -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean. -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Modifying Calendar Entries
We use a calendar to keep track of substitute teacher requests in our district. I've set up a calendar for that purpose, and granted the user that will be managing those requests full access to it (Modify on everything, and Add/Delete permissions). Schools request substitutes by inviting the 'subs' calendar to a meeting. 15 minutes == 1 sub. So if a school needs 4 subs on the 20th, the school secretary schedules a 1 hour meeting with the 'subs' calendar. The problem is that the person in charge of managing the subs cannot modify the events that have been created, since 'subs' is merely an attendee and not the organizer. Optimally, we'd like this person to be able to modify the category of the item to reflect its state in processing (approved and filled). I realize that SOGo is working as designed in this situation, and that using a calendar in this way to manage subs in completely weird, but I'm wondering if anyone has any ideas on how we might make this work. I'm not above mucking about in the database to deal with this if I need to... Thanks! -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can't modify tasks/events with TB 3.1 addons
Ludovic, I have the same issue with the English version of TB; I updated my extensions this morning with the latest nightlies in the hopes that would resolve it. No dice. Chris Hobbs Director, Technology New Haven Unified School District On Aug 10, 2010, at 5:32 PM, Ludovic Marcotte wrote: > I do not have this issue at all. > > Could you perhaps try with the English version of Thunderbird? > > Regards, > > On Tuesday, August 10, 2010 15:21 EDT, Patrick Ben Koetter > wrote: > > >> Ludovic, >> >> is this a bug or is this me doing something wrong? >> >> p...@rick >> >> >> * Patrick Ben Koetter : >> > * Martin Rabl : >> > > Today, I tested the newest/latest plugins (all three) with a fresh >> > > installed Thunderbird 3.1 (virgin Windows7, virgin TB). >> > > >> > > The first calendar entry was put via web interface into the personal >> > > calendar - this one was editable with Thunderbird, as long as I created a >> > > new event in Thunderbird ... since then Thunderbird didn't show me the >> > > edit-window again. The events are only changeable with the web interface, >> > > not with TB. >> > >> > In the meantime I have setup a VM running a vanilla Windows XP and a >> > vanilla >> > TB 3.1.2 to exclude all side-effects I can think of. I fetched the >> > nightlies >> > from August 8, edited the updateURL in extensions.rdf and installed all >> > add-ons. >> > >> > TB starts, connects and shows the calendar. I can add an event, but I can't >> > reopen it once it has been saved. Again, opening the event in the WUI is no >> > problem. >> > >> > The TB error console says: >> > >> > Warnung: Overlay konnte nicht von >> > chrome://sogo-integrator/content/messenger/startup-overlay.xul geladen >> > werden. >> > Quelldatei: chrome://messenger/content/messenger.xul >> > Zeile: 0 >> > Warnung: Overlay konnte nicht von >> > chrome://sogo-integrator/content/calendar/calendar-overlay.xul geladen >> > werden. >> > Quelldatei: chrome://messenger/content/messenger.xul >> > Zeile: 0 >> > Warnung: Overlay konnte nicht von >> > chrome://sogo-integrator/content/calendar/calendars-list-overlay.xul >> > geladen werden. >> > Quelldatei: chrome://messenger/content/messenger.xul >> > Zeile: 0 >> > Warnung: Overlay konnte nicht von >> > chrome://sogo-integrator/content/calendar/calendar-common-sets.xul geladen >> > werden. >> > Quelldatei: chrome://messenger/content/messenger.xul >> > Zeile: 0 >> > >> > This translates to: >> > >> > Warning: Could not load overlay from ... >> > Source: ... >> > Line: 0 >> > >> > >> > Sorry to pester you Inverse folks with this, but at the moment this bug is >> > a >> > show stopper. Is there anything else I can do to help fix this? >> > >> > p...@rick >> > >> > -- >> > state of mind >> > Digitale Kommunikation >> > >> > http://www.state-of-mind.de >> > >> > Franziskanerstraße 15 Telefon +49 89 3090 4664 >> > 81669 München Telefax +49 89 3090 4666 >> > >> > Amtsgericht München Partnerschaftsregister PR 563 >> > >> >> >> > -- >> > users@sogo.nu >> > https://inverse.ca/sogo/lists >> >> >> -- >> state of mind >> Digitale Kommunikation >> >> http://www.state-of-mind.de >> >> Franziskanerstraße 15 Telefon +49 89 3090 4664 >> 81669 München Telefax +49 89 3090 4666 >> >> Amtsgericht München Partnerschaftsregister PR 563 >> > > > > -- > > 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) > > > > -- > This message was scanned by ESVA and is believed to be clean. > Click here to report this message as spam. > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can't modify tasks/events with TB 3.1 addons
On 8/5/10 12:03 PM, Patrick Ben Koetter wrote: Any news on this? p...@rick FWIW, I have this problem with my personal calendar. We've not rolled out TB to users, so I don't know if it's unique to me or not. Interestingly, I *can* edit other calendars' entries where I've been given permission, and I created a new calendar for myself that I can edit entries in. So it appears to be isolated to just my original 'personal' calendar. Hope this helps in troubleshooting. Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Calendar Printing?
How are others handling the printing of calendars? I have several users that feel they must have a hard copy of their calendars, and there's no support in the web client to handle that nicely. I've been installing Sunbird with limited success, and suspect I'll need to get them on TB+Lightning once the kinks are worked out in the latest release, but I am annoyed to be installing a client side app for the single purpose of printing. Anyone else handling this differently? Is printing from the web client on anyone's radar, or are my users just odd? ;-) Thanks for any advice, Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Rebuilding calendar table: Was: Funambol/SOGo/Blackberry Problem
On 8/3/10 10:37 AM, Chris Hobbs wrote: On 8/2/10 11:08 AM, Chris Hobbs wrote: I highly recommend you back up the user's table first, just in case something horrible goes wrong. So, I didn't take my own advice and ran this process without backing up a user's table first. So now I have 0 rows in the calendar table. I do have a copy of the _quick table. Any ideas on how to rebuild the calendar table from the _quick table? I'd like ot avoid going back to a back-up since I know items have been added today. Perl to the rescue... looks like I'll be able to rebuild the calendar table using Perl's iCal modules. Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Rebuilding calendar table: Was: Funambol/SOGo/Blackberry Problem
On 8/2/10 11:08 AM, Chris Hobbs wrote: I highly recommend you back up the user's table first, just in case something horrible goes wrong. So, I didn't take my own advice and ran this process without backing up a user's table first. So now I have 0 rows in the calendar table. I do have a copy of the _quick table. Any ideas on how to rebuild the calendar table from the _quick table? I'd like ot avoid going back to a back-up since I know items have been added today. :-) Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Bundling SOGo Extensions with TB
I'd like to begin deploying TB to our users, and rather than install TB and then install the three extensions on every workstation, I figure there's got to be a way to pre-include the extensions in our deployment packages. Anyone have any pointers on doing this? Thanks! Chris -- Chris Hobbs Director, Technology New Haven Unified School District -- This message has been checked by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Funambol/SOGo/Blackberry Problem
On 7/28/10 9:38 PM, Chris Hobbs wrote: I was able to recreate the card, stask and scal linked to SOGo and tested it successfully on a second BB; didn't have access to the user's BB I experienced this with yesterday, but I assume hers will be resolved as well. I then ran into bug 690, which looks to be an artifact of our imported calendars. I'm thinking I'm going to be playing with mysqldump and perl to fix that one... Creating these new types in funamboladmin did get my user working with her BB (yay!). I resolved our bad imports with the following one-liner: mysqldump -u root -ptopsecr3t sogo sogousername0037dead777 | perl -pi -e 's/\\r\\r/\\r/g' | mysql -u root -ptopsecr3t sogo This dumps a user's calendar table, strips out the repeated \r that are reported in bug 690, and then re-imports the table. Took no more than a second running it against my 3,600 item calendar. I highly recommend you back up the user's table first, just in case something horrible goes wrong. Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo/Thunderbird+Lightning and Time Changes
So my boss just scheduled a recurring monthly meeting with me for the next school year - every third Thursday of the month at 3:00pm. Looks exactly right in the SOGo web interface, but in TB+Lightning the occurrences from November thru February display at 2:00pm. I assume it's because of the switch to Pacific Standard Time. Any ideas? -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Funambol/SOGo/Blackberry Problem
On Wednesday, July 28, 2010 09:30 AM PDT, Ludovic Marcotte wrote: > > The settings on the BB still reflect the sogo-card, sogo-task, and > > sogo-cal. > I've seen that in the past and recently, I think it's a bug in the > Funambol BB client. > > What I do generally is that I delete the card, stask, scal and I > recreate them so they point to SOGo. Neat hack. I was able to recreate the card, stask and scal linked to SOGo and tested it successfully on a second BB; didn't have access to the user's BB I experienced this with yesterday, but I assume hers will be resolved as well. I then ran into bug 690, which looks to be an artifact of our imported calendars. I'm thinking I'm going to be playing with mysqldump and perl to fix that one... -- Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Funambol/SOGo/Blackberry Problem
I have installed and configured Funambol and confirmed that it works by successfully using syncevolution to sync my MacBook address book with SOGo. So I believe Funambol is configured properly. I tried my first BB install yesterday, and failed the first time because I did not change the item types from their default (stask, scal, card). The sync worked, but obviously not against my SOGo info (which is configured for sogo-todo, sogo-cal, sogo-card). Noticing my fail, I went into the settings on the BB and corrected the item types, but the logs on the Funambol server still showed it looking for card, scal and stask. So I removed the User, Device, and Principal in Funambol admin and let the client connect again. It did re-create the User, Device and Principal, but it is still seeking card, stask, and scal. The settings on the BB still reflect the sogo-card, sogo-task, and sogo-cal. Any ideas? Thanks, Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Unable to Subscribe iCal 4 to caldav calendar
On 7/14/10 3:48 PM, Chris Hobbs wrote: I am unable to subscribe to my SOGo 1.2.2.20100707 calendar in iCal 4 on OS X 10.6. sogo.log shows the following when I try: 127.0.0.1 - - [14/Jul/2010:15:37:58 GMT] "GET /SOGo/dav/chobbs/Calendar/personal/ HTTP/1.1" 401 0/0 0.002 - - 8K 127.0.0.1 - - [14/Jul/2010:15:37:58 GMT] "GET /SOGo/dav/chobbs/Calendar/personal/ HTTP/1.1" 501 191/0 0.040 - - 40K The caldav URL I am using is: https://mail.nhusd.k12.ca.us/SOGo/dav/chobbs/Calendar/personal/ Wolfgang correctly guessed at my error. I was using the Calendar->Subscribe menu to try to get access to the Calendar. The correct process was to go to the Account Tab under Preferences and create a CalDAV account with the appropriate username and password pointing to https://mail.nhusd.k12.ca.us/SOGo/dav/chobbs/ With that done, iCal works perfectly. Thanks Inverse team! Chris -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Unable to Subscribe iCal 4 to caldav calendar
I am unable to subscribe to my SOGo 1.2.2.20100707 calendar in iCal 4 on OS X 10.6. sogo.log shows the following when I try: 127.0.0.1 - - [14/Jul/2010:15:37:58 GMT] "GET /SOGo/dav/chobbs/Calendar/personal/ HTTP/1.1" 401 0/0 0.002 - - 8K 127.0.0.1 - - [14/Jul/2010:15:37:58 GMT] "GET /SOGo/dav/chobbs/Calendar/personal/ HTTP/1.1" 501 191/0 0.040 - - 40K The caldav URL I am using is: https://mail.nhusd.k12.ca.us/SOGo/dav/chobbs/Calendar/personal/ iCal reports "There was an unexpected error with the request on subscribed calendars (error -1)." I can subscribe to the .ics URL in iCal. I can successfully subscribe to this caldav calendar in TB/Lightning as well as standalone Sunbird. Here is my .GNUstepDefaults file: { NSGlobalDomain = { }; sogod = { OCSFolderInfoURL = "mysql://sogo:passw...@sogo1:3306/sogo/sogo_folder_info"; SOGoACLsSendEMailNotifications = YES; SOGoAppointmentSendEMailNotifications = YES; SOGoDraftsFolderName = Drafts; SOGoFoldersSendEMailNotifications = YES; SOGoIMAPServer = 10.3.1.41; SOGoLanguage = English; SOGoMailComposeMessageType = html; SOGoMailDomain = nhusd.k12.ca.us; SOGoSuperUsernames = (chobbs, iochoa); SOGoMailingMechanism = smtp; SOGoSoftQuotaRatio = 0.7; SOGoOtherUsersFolderName = "shared"; SOGoProfileURL = "mysql://sogo:passw...@sogo1:3306/sogo/sogo_user_profile"; SOGoSMTPServer = 10.3.1.1; SOGoSentFolderName = Sent; SOGoSharedFolderName = "Shared Folders"; SOGoTimeFormat = "%I:%M %p"; SOGoMailListViewColumnsOrder = ("Flagged", "Attachment", "From", "Subject", "Unread", "Date", "Priority", "Size"); SOGoForwardEnabled = YES; SOGoVacationEnabled = YES; SOGoSieveScriptsEnabled = YES; SOGoCalendarDefaultRoles = ("PublicDAndTViewer"); SOGoLDAPContactInfoAttribute = displayName; SOGoTimeZone = US/Pacific; SOGoTrashFolderName = Trash; WOUseRelativeURLs = YES; SOGoUserSources = ( { CNFieldName = displayName; IDFieldName = uid; UIDFieldName = uid; baseDN = "dc=nhusd,dc=k12,dc=ca,dc=us"; bindDN = "cn=admin."; bindFields = ( cn, uid ); bindPassword = ; canAuthenticate = YES; scope = SUB; displayName = "NHUSD Logins"; hostname = 10.3.1.1; id = directory; isAddressBook = NO; port = 389; type = ldap; }, { CNFieldName = displayName; IDFieldName = uid; UIDFieldName = uid; baseDN = "ou=staff,dc=nhusd,dc=k12,dc=ca,dc=us"; bindDN = "cn=admin."; bindFields = ( cn, uid ); bindPassword = ; canAuthenticate = NO; scope = SUB; displayName = "NHUSD Staff Directory"; hostname = 10.3.1.1; id = staffdirectory; isAddressBook = YES; port = 389; type = ldap; }, { CNFieldName = displayName; IDFieldName = uid; UIDFieldName = uid; baseDN = "ou=students,dc=nhusd,dc=k12,dc=ca,dc=us"; bindDN = "cn=admin."; bindFields = ( cn, uid ); bindPassword = ; canAuthenticate = NO; scope = SUB; displayName = "NHUSD Student Directory"; hostname = 10.3.1.1; id = studentdirectory; isAddressBook = YES; port = 389; type = ldap; }, { CNFieldName = displayName; IDFieldName = uid; UIDFieldName = uid; baseDN = "ou=groups,dc=nhusd,dc=k12,dc=ca,dc=us"; bindDN = "cn=admin."; bindFields = ( cn, uid ); bindPassword = ; canAuthenticate = NO; scope = SUB; displayName = "NHUSD Group Directory&q
Re: [SOGo] MISMATCH: different db ..
I had a similar error when I tried to bring up a second sogo web server pointed to the original database. I changed the .GNUstepDefaults to point to the correct host (sogo1), but all of my created users had localhost in their paths in sogo_folder_info. I fixed it with the following mysql statements. Make sure you understand what this does before you blow up your database :-) update sogo_folder_info set c_location=replace(c_location, 'localhost', 'sogo1'); update sogo_folder_info set c_quick_location=replace(c_quick_location, 'localhost', 'sogo1'); update sogo_folder_info set c_acl_location=replace(c_acl_location, 'localhost', 'sogo1'); Chris On Jul 6, 2010, at 6:06 AM, Ludovic Marcotte wrote: > Mark Adams wrote: >> I'm also seeing this - What is causing it > My guess is that your database config in your .GNUstepDefaults differs for > some users based on what's found in the sogo_folder_info table for them. > > Perhaps you changed it after those users were created and you forgot to > adjust the path. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Setting Date and Time Viewer permissions on all user calendars
I discovered after we had migrated all of our users to SOGo that unless the "Any Authenticated User" is granted access to view date and time, the free/busy search does not work. So I fixed that with some perl and mysql hackery (see below) , but I'm not sure how to ensure that future new users have that permission enabled by default. Reading the description for "SOGoCalendarDefaultRoles", it doesn't sound like it exactly does what I want, but maybe I'm reading it wrong? In case anyone finds themselves in the same boat, here's how I fixed it: 1) get a list of users and their acl tables from the database. I used the mysql interactive command line: select c_path2, c_acl_location from sogo_folder_info where c_foldername='Personal Calendar' into outfile 'useracls.txt'; 2) Feed the resultant file into the following perl script: #!/usr/bin/perl foreach (<>) { ($user, $mysql) = split /\t/; ($a, $b, $c, $d, $table) = split (/\//, $mysql); chomp $table; print "insert into $table (c_uid, c_object, c_role) values ('', '/$user/Calendar/personal', 'PublicDAndTViewer');\n"; } I ran this as: aclfix.pl < useracls.txt > acl.sql 3) Finally, load the .sql script into mysql: mysql -A -u root -p sogo < acl.sql -- This message has been checked by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Proxy Access (Manager/Secretary) Best Practices?
Thanks Ludovic, What it would it take to add the mail identity concept to SOGo? Feel free to e-mail me off-list to talk about this. > Good to know! Sad that Novell will likely fire one on their side for lack of > revenue ;-) Well, the solution to that would have been to create a product we couldn't live without... :-) -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Proxy Access (Manager/Secretary) Best Practices?
I've mostly got our dovecot+postfix+SOGo+openldap open source groupware replacement working the way I want it to; we're replacing GroupWise in our organization and I'm thrilled to be doing it. I'm supporting about 1,000 active staff users (and another 6,000 student accounts). I've got e-mail and calendar sharing working, and it does what it says it will do, but it is (go figure) different in concept from Proxy access under GroupWise. In GroupWise, I can give my secretary proxy access to my account and she can read all of my folders, see my calendars, and send e-mail as me. To someone that receives an e-mail or appointment request from her while she's proxied to me, there's no distinction at all. Is there a way to mimic this sort of functionality with the tools I've chosen? I've figured out that I can add additional 'mail' attributes to the secretary's record, and those addresses are available as drop-down choices in the SOGo web interface, but with the secretary's name and not the manager. Any advice will be much appreciated. And many thanks to the developers involved for writing and making available such amazingly good software. Eliminating the license fees we've been paying to Novell is allowing me to save a technician that surely would have been eliminated in budget cuts this year. Chris Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Migrating Calendars from GroupWise to SOGo
Hello all, We're in the process of converting our users from GroupWise to SOGo+dovecot+postfix. We're using Gilles Lamiral most excellent imapsync.pl to handle moving e-mail from GW to dovecot, and that is going well. I had planned to simply export the GW calendars as .ics and import them into SOGo, which works well, but I realized after running imapsync that the GW Calendar folder is copied over via IMAP, and all calendar entries are available on the dovecot server as RFC822 messages (we're using maildir for storage). So, my question is, Is there any way to leverage the presence of these messages and get them into SOGo's calendar programmatically so that I avoid having to run the export/import manually on each users' account? Thanks for the help, Chris Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo and haproxy docs?
My google-fu seems to be failing me, and I can't seem to be finding good docs and setting up haproxy to work with SOGo. My goal is to have multiple web front-ends behind the haproxy box. I'm currently getting 502 errors when I go through the haproxy server. Thanks for any tips, Chris Chris Hobbs Director, Technology New Haven Unified School District -- This message was scanned by ESVA and is believed to be clean. -- users@sogo.nu https://inverse.ca/sogo/lists