[SOGo] BTS activities for Friday, September 07 2012
Title: BTS activities for Friday, September 07 2012 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Friday, September 07 2012 idlast updatestatus (resolution)categorysummary 1947 2012-09-07 17:36:54 updated (open) SOGo Native Outlook Compatibility Creation of Junk mail folder but in Russian encoding by MS Outlook causes Samba4 & Openchange to crash with error. 1972 2012-09-07 17:42:36 updated (open) SOGo Native Outlook Compatibility SOGo appliance RC5 doesn' t automatically push out / load new messages to MS OL Inbox folder. 1971 2012-09-07 12:57:08 updated (open) Web Calendar Can not set reminder on tasks 1954 2012-09-07 08:49:47 resolved (fixed) SOGo Native Outlook Compatibility Samba4 crashes when MS OL tries to add and synchronizes 'Junk Mail' folder but in Russian language in UTF-7.
Re: [SOGo] SOGo v2 architecture
It would be nch better if you send or post more detailed algo of IMAP folder synchronization beetwen MS Outlook local post file (OST) , Openchange ldb storage, SOGo PgSQL storage and IMAP folders. And mechanism description of pushing of new Inbox messagimg. Because sometimes sending / incoming messages goes not to Inbox, but to Drafts, deleting from Outlook messages is not deleted from IMAP server. And ot know wether is to know new e-mail at user' s mailbox or not user has to press Synch button at Inbox each time instead Idle or polling or some other pushing out mechanisms as with Exchange. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo v2 architecture
Hi SOGo fellows I've made a diagram of the components surrounding the Outlook compatibility layer of the upcoming 2.0 release. It's on the website and the "Native Microsoft Outlook Configuration" guide. Hopefully it will help anyone to better understand the integration of Samba 4 and OpenChange into the new Outlook compatibility feature. http://www.sogo.nu/english/about/overview.html http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calender events deleted after upgrade 1.3.17 to 1.3.18
Hi Jim On 2012-09-05, at 2:49 PM, Jim Hague wrote: > I'm running SOGo with MySQL on a x86 Debian Stable server using the Inverse > packages from the Inverse apt repository. > > I recently upgraded 1.3.17-1 to the latest 1.3.18-1. Shortly after the > upgrade, I started getting complaints from users that some current and future > events had vanished from a shared calendar. This calendar is the main focus > of > use in our company; there might well have been similar on personal calendars, > but they are lightly used and I have not had a report. FYI, SOGo 1.3.18 doesn't delete random events. Thank God. :) > Poking around in the database, I find the events are present in the main > table > but marked as deleted (c_deleted is 1). They have been removed from the > corresponding _quick table. > > Has anyone else seen similar? > > And is there a way I can undelete the events? Update your tables (c_deleted = 0) and use sogo-tool to restore the entries in the quick tables : su - sogo mkdir foo sogo-tool backup foo jim.hague sogo-tool restore -F ALL foo jim.hague rm -fR foo exit Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Does the latest appliance support more then one address book ?
HI anybody. Is it possible to make two or more addresses books with the latest appliance version that could be accesses both via MS Outlook and via Web GUI ? There is called as address lists in MS Exchange. For example, there are 4 separate address books: my organization GAL, then separate CMA-CGM address book (address list as in Exchange terms) , separate MSC address book (address list as in Exchange terms) and OOCL address book. Which each consists of its own contacts - contacts belonging to it exact address book only, that is my internal - my LDAP users / contacts (in particular who can log on to the server, that is can be authorized by the server and can access to mail or other server services) , CMA-CGM consists partner contacts from its company (who has name, surname, phones, e-mail, some other information, but such users couldn' t logon to my server) , then the same address books for MSC and OOCL contacts. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.18a
On 2012-09-07, at 2:13 PM, Jeff Folk wrote: > > On Sep 7, 2012, at 1:07 PM, Francis Lachapelle wrote: > >> - fixed support for OS X 10.8 (Mounting Lion) > > LOL! ^ > > I can't get that image out of my head… ^-- umount /lion and stop watching Animal Planet :) -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.18a
On Sep 7, 2012, at 1:07 PM, Francis Lachapelle wrote: > - fixed support for OS X 10.8 (Mounting Lion) LOL! ^ I can't get that image out of my head… ^-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.18a
Hi On 2012-09-07, at 4:54 AM, MJ Ray wrote: >> We just released a minor update that fixes a regression. >> >> See http://www.sogo.nu/bugs/changelog_page.php?project_id=1 for closed >> tickets and http://sogo.nu/files/downloads/SOGo/Sources/ChangeLog for the >> complete change log. > > I guess http://www.sogo.nu/bugs/view.php?id=1966 was the regression. > It'd be really great if that could be included in the package changelog > or the release announcements. I agree, I should have include the NEWS entries : Bug Fixes - fixed display of weekly events with no day mask - fixed parsing of mail headers - fixed support for OS X 10.8 (Mounting Lion) > I see that two of the bugs relate to unknown user-agents. Would you > accept a patch that makes blocking by user-agent optional? It would fix > http://www.sogo.nu/bugs/view.php?id=1823 Yes! Attach your patch to the ticket. But hurry, 2.0 is coming very soon :) Thanks! Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 nightly build: CardDAV, SSL and port 8843
Still, if I specify the port in the AddressBook GUI or iPhone it should (and does) connect to it initially. But then, somehow it switches to 443. Same story with Android client. On 9/7/12 12:51 PM, Martin Seener wrote: On 10.8.x (Calendar and Contacts) its 8443 On 10.7.x (iCal) was 8443 - AddressBook i dont remember and 10.6.x 8843 but iam SURE on 10.8 - can send u a screenshot. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 nightly build: CardDAV, SSL and port 8843
Hi, thats not entirely correct - sorry. we have several OS X Versions here and the Port differs to each version - yes, thanks apple :/ On 10.8.x (Calendar and Contacts) its 8443 On 10.7.x (iCal) was 8443 - AddressBook i dont remember and 10.6.x 8843 but iam SURE on 10.8 - can send u a screenshot. so it really depends on your OSX and therefore iCal/Calendar and Address Book/Contacts Version!!! Put a Firewall in front of the Mac or set up an account and see which port it "wants" to use. then set appropiate Apache Vhosts for each port and you should be totally fine for all "versions" Greets from Berlin, Martin On 9/7/12 12:38 PM, Marek Skubela wrote: From http://support.apple.com/kb/TS1629: 8443: iCal service (SSL) 8843: Address Book service (SSL) iCal on 8443 port is working flawlessly using only 8443. On 9/7/12 12:03 PM, Martin Seener wrote: The default port für CalDAV/CardDAV with SSL should be 8443 (used here with sogo 1.3.17) On 9/7/12 11:38 AM, Marek Skubela wrote: Hello, I'm trying to set up CardDAV on separate port (8843) without any luck. I am using SOGO 2.0.0.20120907-1 on Ubuntu 10.04 with Apache 2.2.14. My CardDAV VHost is as follows: -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 nightly build: CardDAV, SSL and port 8843
From http://support.apple.com/kb/TS1629: 8443: iCal service (SSL) 8843: Address Book service (SSL) iCal on 8443 port is working flawlessly using only 8443. On 9/7/12 12:03 PM, Martin Seener wrote: The default port für CalDAV/CardDAV with SSL should be 8443 (used here with sogo 1.3.17) On 9/7/12 11:38 AM, Marek Skubela wrote: Hello, I'm trying to set up CardDAV on separate port (8843) without any luck. I am using SOGO 2.0.0.20120907-1 on Ubuntu 10.04 with Apache 2.2.14. My CardDAV VHost is as follows: -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo 2.0 nightly build: CardDAV, SSL and port 8843
The default port für CalDAV/CardDAV with SSL should be 8443 (used here with sogo 1.3.17) On 9/7/12 11:38 AM, Marek Skubela wrote: Hello, I'm trying to set up CardDAV on separate port (8843) without any luck. I am using SOGO 2.0.0.20120907-1 on Ubuntu 10.04 with Apache 2.2.14. My CardDAV VHost is as follows: ServerName mail.example.pl SSLEngine on SSLCertificateFile /etc/ssl/certs/cert.pem SSLCertificateKeyFile /etc/ssl/private/key.key SSLProtocol all -SSLv2 RewriteEngine Off ProxyRequests Off SetEnv proxy-nokeepalive 1 ProxyPreserveHost On ProxyPassInterpolateEnv On ProxyPass /principals http://127.0.0.1:2/SOGo/dav/ interpolate ProxyPass /SOGo/ http://127.0.0.1:2/SOGo interpolate ProxyPass / http://127.0.0.1:2/SOGo/dav/ interpolate Order allow,deny Allow from all http://127.0.0.1:2> # Directive replaces previous header with that name. RequestHeader set "x-webobjects-server-port" "8843" RequestHeader set "x-webobjects-server-name" "mail.example.pl:8843" RequestHeader set "x-webobjects-server-url" "https://mail.example.pl:8843"; RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0" RequestHeader set "x-webobjects-remote-host" "127.0.0.1" AddDefaultCharset UTF-8 LogLevel debug ErrorLog /var/log/apache2/sogo-ab-error.log CustomLog /var/log/apache2/sogo-ab-access.log combined When I try to connect with Android CardDAV client on port 8843: 10.1.0.12 - - [07/Sep/2012:11:17:18 +0200] "PROPFIND /.well-known/carddav HTTP/1.1" 404 1905 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:18 +0200] "PROPFIND /SOGo/dav/ HTTP/1.1" 401 445 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:19 +0200] "PROPFIND /SOGo/dav/ HTTP/1.1" 207 2189 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" And then I see that it switches to 443 port, because in ssl-access log I then see: 10.1.0.12 - - [07/Sep/2012:11:17:20 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/ HTTP/1.1" 401 1757 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:21 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/ HTTP/1.1" 207 2219 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:21 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/Contacts/ HTTP/1.1" 401 445 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:22 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/Contacts/ HTTP/1.1" 207 2481 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" Similar behaviour I've noticed with Apple AddressBook. If I disable the 443 port, none of the clients work at all. I tested PROPFIND request manually with curl on 8843 and the responses seem valid. Is there something in SOGo that redirects requests to 443 port? TIA, Marek Skubela marek.skub...@dignum.pl -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Sync deleted "items" to client
Hello everybody, I use the SOGo Connector Thunderbird extension 10.0.3 with Thunderbird 15 at Linux Mint 13 (based on Ubuntu 12.14) to sync my contacts with ownCloud 4.0.7 via CardDAV. I recognized the following behavior: When I add an "item" to a contact with the help of the ownCloud web-frontend (e. g. a telephone number), it gets synced with Thunderbird as expected. But if I delete an item at the web-frontend, it is not deleted at Thunderbird after I sync the address book. Is this behavior normal? Or is there an possibility to sync deletions as well? Regards, Daniel -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo 2.0 nightly build: CardDAV, SSL and port 8843
Hello, I'm trying to set up CardDAV on separate port (8843) without any luck. I am using SOGO 2.0.0.20120907-1 on Ubuntu 10.04 with Apache 2.2.14. My CardDAV VHost is as follows: ServerName mail.example.pl SSLEngine on SSLCertificateFile /etc/ssl/certs/cert.pem SSLCertificateKeyFile /etc/ssl/private/key.key SSLProtocol all -SSLv2 RewriteEngine Off ProxyRequests Off SetEnv proxy-nokeepalive 1 ProxyPreserveHost On ProxyPassInterpolateEnv On ProxyPass /principals http://127.0.0.1:2/SOGo/dav/ interpolate ProxyPass /SOGo/ http://127.0.0.1:2/SOGo interpolate ProxyPass / http://127.0.0.1:2/SOGo/dav/ interpolate Order allow,deny Allow from all http://127.0.0.1:2> # Directive replaces previous header with that name. RequestHeader set "x-webobjects-server-port" "8843" RequestHeader set "x-webobjects-server-name" "mail.example.pl:8843" RequestHeader set "x-webobjects-server-url" "https://mail.example.pl:8843"; RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0" RequestHeader set "x-webobjects-remote-host" "127.0.0.1" AddDefaultCharset UTF-8 LogLevel debug ErrorLog /var/log/apache2/sogo-ab-error.log CustomLog /var/log/apache2/sogo-ab-access.log combined When I try to connect with Android CardDAV client on port 8843: 10.1.0.12 - - [07/Sep/2012:11:17:18 +0200] "PROPFIND /.well-known/carddav HTTP/1.1" 404 1905 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:18 +0200] "PROPFIND /SOGo/dav/ HTTP/1.1" 401 445 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:19 +0200] "PROPFIND /SOGo/dav/ HTTP/1.1" 207 2189 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" And then I see that it switches to 443 port, because in ssl-access log I then see: 10.1.0.12 - - [07/Sep/2012:11:17:20 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/ HTTP/1.1" 401 1757 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:21 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/ HTTP/1.1" 207 2219 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:21 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/Contacts/ HTTP/1.1" 401 445 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" 10.1.0.12 - - [07/Sep/2012:11:17:22 +0200] "PROPFIND /SOGo/dav/marek.skubela%40example.pl/Contacts/ HTTP/1.1" 207 2481 "-" "CardDAV-Sync (Android) (like iOS/5.0.1 (9A405) dataaccessd/1.0) gzip" Similar behaviour I've noticed with Apple AddressBook. If I disable the 443 port, none of the clients work at all. I tested PROPFIND request manually with curl on 8843 and the responses seem valid. Is there something in SOGo that redirects requests to 443 port? TIA, Marek Skubela marek.skub...@dignum.pl -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication Using Ldap
Hi chris, just finish doing this su - sogo defaults write sogod SOGoTimeZone "America/Montreal" defaults write sogod SOGoMailDomain "acme.com" defaults write sogod SOGoLanguage English defaults write sogod SOGoAppointmentSendEMailNotifications YES defaults write sogod SOGoFoldersSendEMailNotifications YES defaults write sogod SOGoACLsSendEMailNotifications YES Could you assist me what next to do? Thanks in Advnace mate, - Original Message - From: "Christian Mack" To: Sent: Friday, September 07, 2012 4:05 PM Subject: Re: [SOGo] Authentication Using Ldap Hello Joms Ariola On 2012-09-07 09:43, Joms Ariola wrote: Im stock to this.. su – sogo defaults write sogod SOGoUserSources '({CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; IMAPHostFieldName = mailHost; baseDN = "ou=users,dc=acme,dc=com"; bindDN = "uid=sogo,ou=users,dc=acme,dc=com"; bindPassword = qwerty; canAuthenticate = YES; displayName = "Shared Addresses"; hostname = "localhost"; id = public; isAddressBook = YES; port=389})' How to do this.. The above are 2 commands used in the command line of your server. The first one "su - sogo" switches the user you are connected with to the user "sogo" and adjusts your environment to the one user "sogo" uses. If you execute this as user "root", then you don't have to give the password for user "sogo". The second command "defaults write sogod ." adds or alters some configuration option in the sogod configuration. sogod is the sogo daemon, which your browser will connect to when using SOGo. The above given example option SOGoUserSources defines how to connect to your LDAP for authentication of SOGo users. Before using that, you must have an LDAP set up already. Then you have to adjust the values set above to your LDAP configuration. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo v1.3.18a
Francis Lachapelle > We just released a minor update that fixes a regression. > > See http://www.sogo.nu/bugs/changelog_page.php?project_id=1 for closed > tickets and http://sogo.nu/files/downloads/SOGo/Sources/ChangeLog for the > complete change log. I guess http://www.sogo.nu/bugs/view.php?id=1966 was the regression. It'd be really great if that could be included in the package changelog or the release announcements. I see that two of the bugs relate to unknown user-agents. Would you accept a patch that makes blocking by user-agent optional? It would fix http://www.sogo.nu/bugs/view.php?id=1823 Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Export addressbook
Is this working server-side as well? I need to run a script once a day to export a particular address book. Regards, Burkart On 09/06/2012 05:09 PM, Christian Mack wrote: Hello Burkart Orlowsk On 2012-09-06 14:29, Burkart Orlowski | Onlinehelp24 wrote: I am looking for a solution to export a particular addressbook into a CSV file. mysql sogo --user=*** --password=***< mysql2csv.sql mysql2csv.sql => SELECT * FROM sogob***0012ca32195_quick INTO OUTFILE '/tmp/adressen_aktuell.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'; This is working pretty fine but unfortunately the exported address book fields are not complete. It lacks the address fields (street, ZIP, ...) for example. Any ideas how to export all address book information into a single CSV file? Why don't you use the export in LDIF format and convert it to csv afterwards? Kind regards, Christian Mack -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication Using Ldap
Hello Joms Ariola On 2012-09-07 09:43, Joms Ariola wrote: > > Im stock to this.. > > su – sogo > > defaults write sogod SOGoUserSources '({CNFieldName = cn; > IDFieldName = uid; UIDFieldName = uid; IMAPHostFieldName = mailHost; > baseDN = "ou=users,dc=acme,dc=com"; > bindDN = "uid=sogo,ou=users,dc=acme,dc=com"; > bindPassword = qwerty; canAuthenticate = YES; displayName = > "Shared Addresses"; hostname = "localhost"; id = public; > isAddressBook = YES; port=389})' > > How to do this.. > The above are 2 commands used in the command line of your server. The first one "su - sogo" switches the user you are connected with to the user "sogo" and adjusts your environment to the one user "sogo" uses. If you execute this as user "root", then you don't have to give the password for user "sogo". The second command "defaults write sogod ." adds or alters some configuration option in the sogod configuration. sogod is the sogo daemon, which your browser will connect to when using SOGo. The above given example option SOGoUserSources defines how to connect to your LDAP for authentication of SOGo users. Before using that, you must have an LDAP set up already. Then you have to adjust the values set above to your LDAP configuration. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Authentication Using Ldap
Hi, Im stock to this.. su - sogo defaults write sogod SOGoUserSources '({CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; IMAPHostFieldName = mailHost; baseDN = "ou=users,dc=acme,dc=com"; bindDN = "uid=sogo,ou=users,dc=acme,dc=com"; bindPassword = qwerty; canAuthenticate = YES; displayName = "Shared Addresses"; hostname = "localhost"; id = public; isAddressBook = YES; port=389})' How to do this.. Regards, -- users@sogo.nu https://inverse.ca/sogo/lists