Re: [SOGo] Saving name of user that created/modified event? Python hook?
Hi, On Wed, Mar 14, 2012 at 11:13 AM, Robert Casties wrote: > Since we use a lot of group calendars where events are created and > changed by different users it would be nice to know which user created > or changed an event (and when). > > It seems that the vcalendar format does not provide this information, at > least I didn't find it. > > Now I had the idea to automatically add a line like "created by $user at > $date" to the notes field. How would that be possible? > > Would it be possible with a Python hook? What do I need to play with > this? 2.0? No idea what it would need from SOGo, but if you are using a database backend and not LDAP, you could perhaps implement this with database triggers: on update of certain field you update some other field in the db? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar Temporaly Unavailable
Hi, On Wed, Mar 14, 2012 at 12:42 PM, Alessio Fattorini wrote: > I have some calendars on my Thunderbird that i see with a yellowe danger > signal with this label: james's calendar is temporaly unavailable I have experienced the same. > The only think that these calendars have in common is the sync with funambol > device. > Has anyone the same problem? Yes, those calendars showing warnings are ones that I have synced with Funambol. If I remember correctly, those that show the warnings in Thunderbird were calendars that got also synced from Outlook. My interpretation of the situation was that Outlook/Funambol transferred some events that include XML that Thunderbird is having problems with. But I think that even there is that danger signal the calendars work ok, or have you Alessio found otherwise? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Calendar Temporaly Unavailable
Hi, On Wed, Mar 14, 2012 at 3:11 PM, Alessio Fattorini wrote: > Absolutely, Calendars work but it is annoying because for customers it seems > an alert then i want avoid it I agree. But is this Thunderbird or SOGo issue? And how to find out which calendar entries are causing the trouble, is there a way to validate the "correctness" of a SOGo calendar, can someone tell? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] removing user with sogo-tool and resyncing with funambol creates unusable calendar
I have Funambol syncing working ok from Outlook to SOGo. My problem is, that with the following steps I end up with an unreadable calendar: 1. Delete an existing SOGo user that has been succesfully syncing Outlook with Funambol: [sogo@sogo ~]$ sogo-tool remove test...@testdomain.com 2. Login with test...@testdomain.com to SOGo web UI => an empty calendar that works ok is showed 3. Manually sync calendar from Outlook with Funambol WIndows Sync Client => No entries synced from Outlook, SOGo web calendar works still ok 4. From Funambol WIndows Sync Client select "Tools > Recover > Replace all of the server data with local data" and select "Calendar" => The client sends all entries, but after this in SOGo web UI I do not see anymore the red line indicating the current day and I do not see any Outlook entries either. If I now try to create a new event it is not showed in the SOGo web UI. If I subscribe to this calendar from some other user's calendar it will make the calendar view blank (empty, no entries) for this user unless I uncheck the Funambol synced calendar. If I remove the calendar with sogo-tool it starts working again ok (but is empty of course). This is what I see in the log: Apr 11 16:37:49 sogod [14176]: [WARN] <0x0x90dc8cc[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table Apr 11 16:37:49 sogod [14176]: [WARN] <0x0x90dc8cc[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table 83.145.213.126 - - [11/Apr/2012:16:37:49 GMT] "POST /SOGo/so/test...@testdomain.com/Calendar/taskslist?show-completed=0 HTTP/1.1" 200 2/0 0.033 - - 1M Apr 11 16:37:49 sogod [14176]: [ERROR] [we-rm] did not find locale for language: Finnish *** stack smashing detected ***: /usr/sbin/sogod terminated === Backtrace: = /lib/i686/nosegneg/libc.so.6(__fortify_fail+0x4d)[0x62b62d] /lib/i686/nosegneg/libc.so.6[0x62b5da] /usr/lib/libNGCards.so.4.9[0x67b8824] Software versions: [root@sogo ~]# rpm -qa |grep sogo sogo-tool-1.3.12c-1.centos6.i686 sogo-1.3.12c-1.centos6.i686 sogo-ealarms-notify-1.3.12c-1.centos6.i686 [root@sogo ~]# rpm -qa |grep sope sope49-appserver-4.9-20120214_1664.el6.1.i686 sope49-sbjson-2.3.1-20120214_1664.el6.1.i686 sope49-xml-4.9-20120214_1664.el6.1.i686 sope49-gdl1-contentstore-1.3.12c-1.centos6.i686 sope49-cards-1.3.12c-1.centos6.i686 sope49-gdl1-postgresql-4.9-20120214_1664.el6.1.i686 sope49-gdl1-4.9-20120214_1664.el6.1.i686 sope49-ldap-4.9-20120214_1664.el6.1.i686 sope49-gdl1-mysql-4.9-20120214_1664.el6.1.i686 sope49-core-4.9-20120214_1664.el6.1.i686 sope49-mime-4.9-20120214_1664.el6.1.i686 funambol-8.5.2 funambol-sogo-1.0.8.s4j I've tried also deleting all principals and devices related to this user from the funambol postgresq db, but this does not help either. Any ideas how I could get Funambol/Outlook syncing working for this user again? Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] removing user with sogo-tool and resyncing with funambol creates unusable calendar
Hi, On Wed, Apr 11, 2012 at 5:35 PM, Luca Olivetti wrote: > Al 11/04/2012 15:55, En/na Peter Peltonen ha escrit: > > >> *** stack smashing detected ***: /usr/sbin/sogod terminated >> === Backtrace: = >> /lib/i686/nosegneg/libc.so.6(__fortify_fail+0x4d)[0x62b62d] >> /lib/i686/nosegneg/libc.so.6[0x62b5da] >> /usr/lib/libNGCards.so.4.9[0x67b8824] >> > > > My old friend "stack smashing detected"! > I've had this problem since 1.3.1, I put a nasty hack in my spec file to > build NGCards with -fno-stack-protector: > > However this will only mask the symptoms, not the root cause of the problem > (which I couldn't debug and it seems that nobody else was experiencing it). Thanks for your reply. Are there some known dangers disabling the stack-protector? Is it the sope49-cards package I need to modify? Any other solutions? All I basically would want to do is to start from scratch with one user: to completely remove all information from Funambol and SOGo about the account (as syncing works fine with new SOGo users). I am using postgresql backend for both SOGo and Funambol, any pointers what data from which tables should I use to start all over again with this user? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] removing user with sogo-tool and resyncing with funambol creates unusable calendar
Replying tomyself: On Wed, Apr 11, 2012 at 10:27 PM, Peter Peltonen wrote: > Hi, > > On Wed, Apr 11, 2012 at 5:35 PM, Luca Olivetti wrote: >> Al 11/04/2012 15:55, En/na Peter Peltonen ha escrit: >> >> >>> *** stack smashing detected ***: /usr/sbin/sogod terminated >>> === Backtrace: = >>> /lib/i686/nosegneg/libc.so.6(__fortify_fail+0x4d)[0x62b62d] >>> /lib/i686/nosegneg/libc.so.6[0x62b5da] >>> /usr/lib/libNGCards.so.4.9[0x67b8824] >>> >> >> >> My old friend "stack smashing detected"! >> I've had this problem since 1.3.1, I put a nasty hack in my spec file to >> build NGCards with -fno-stack-protector: I have now identified that the problem is with recurring events in Outlook. If I remove the user's first recurring events in the Outlook list view, remove the user with sogo-tool, syncing with Funambol works ok with the exception that no recurring events are showed in the SOGo web ui. If I export the ics with the problematic events and try to import it via SOGo web tool I get a stack smashing crash as well, but I manage to get some events imported ok (as opposed nonfunctional events resulting from the Funambol sync) although the upload window never closes. No recurring events imported this way either. The only way to get syncing or importing the events as ics file fully work is to remove all recurring events from Outlook first. I have now opened a bug report with example ics files: http://www.sogo.nu/bugs/view.php?id=1772 Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] memcached missing package in SOGo 1.13.14 on a SME Server
Hi, On Thu, Apr 12, 2012 at 9:05 PM, Rosario Russo wrote: > If I try: > yum install memcached > > I get: > > No package memcached available. > Nothing to do > > I also tried --exclude=memcached without success. > > Do you have any ideas? At least for on my CentOS6 based SOGo installation memcached-1.4.7-1.el6.rfx is installed from the rpmforge repositry. And reading http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf I see: "Some of the softwares on which SOGo depends are available from the repository of RPMforge. To add RPMforge to your packages sources, download and install the appropriate RPM package from http://packages.sw.be/rpmforge-release/. Also make sure you enabled the “rpmforge-extras” repository. For more information on using RPMforge, visit http://rpmrepo.org/RPMforge/Using"; Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Web Performance issue
HI, On Fri, Apr 13, 2012 at 3:45 PM, Marco Coli wrote: > > The problem is the same: the system in the complex is ok, but 3 users with a > LOT of folders, needs to wait 9 seconds to pass from Calendar or Address tab > to Mail > No such problem in Squirrel, or in thunderbird client. > > I don't know what to do... You have probably tried with different browsers? Just noticed today that a user with Firefox + Firebug running caused SOGo web UI to render really slow. Disabling Firebug solved the problem. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] all day events synced with funambol show on wrong day
Hi, If I create an all day event in Outlook 2010 and then use Funambol to sync it to SOGo, the day is shown on wrong day: if the event is for the 19th of April, SOGo will show it for 18th in its calendar view, but if I double click it, the information displayed is shown correctly: x All day event Start: 2012-04-19 00:00 End: 2012-04-19 00:00 If I now save the event (without modifying anything) it will put the event in right place. And if I export the event from Outlook in ICS and import it, it will show correctly in SOGo. So I guess the problem is with Funambol or/and its SOGo connector. Is this a known problem? Are there known workarounds, such as modifying some Funambol settings, or should I report a bug? Software versions: [root@sogo ~]# rpm -qa |grep sogo sogo-tool-1.3.12c-1.centos6.i686 sogo-1.3.12c-1.centos6.i686 sogo-ealarms-notify-1.3.12c-1.centos6.i686 [root@sogo ~]# rpm -qa |grep sope sope49-appserver-4.9-20120214_1664.el6.1.i686 sope49-sbjson-2.3.1-20120214_1664.el6.1.i686 sope49-xml-4.9-20120214_1664.el6.1.i686 sope49-gdl1-contentstore-1.3.12c-1.centos6.i686 sope49-cards-1.3.12c-1.centos6.i686 sope49-gdl1-postgresql-4.9-20120214_1664.el6.1.i686 sope49-gdl1-4.9-20120214_1664.el6.1.i686 sope49-ldap-4.9-20120214_1664.el6.1.i686 sope49-gdl1-mysql-4.9-20120214_1664.el6.1.i686 sope49-core-4.9-20120214_1664.el6.1.i686 sope49-mime-4.9-20120214_1664.el6.1.i686 funambol-8.5.2 funambol-sogo-1.0.8.s4j Windows 7 Professional (English language version) Outlook 2010 (Finnish language version) Funambol Windows Sync Client 10.1.6 Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: all day events synced with funambol show on wrong day
Hi, On Tue, Apr 17, 2012 at 1:08 AM, Peter Peltonen wrote: > If I create an all day event in Outlook 2010 and then use Funambol to > sync it to SOGo, the day is shown on wrong day: if the event is for > the 19th of April, SOGo will show it for 18th in its calendar view, > but if I double click it, the information displayed is shown > correctly: > > x All day event > Start: 2012-04-19 00:00 > End: 2012-04-19 00:00 > > If I now save the event (without modifying anything) it will put the > event in right place. > > And if I export the event from Outlook in ICS and import it, it will > show correctly in SOGo. So I guess the problem is with Funambol or/and > its SOGo connector. I have now experienced this with events exported from the K5N Webcalendar that has been imported to SOGo, so it seems to be a general SOGo backend calendar issue and not related just to Funambol as I originally thought. I can reproduce the K5N Webcalendar behaviour in both public SOGo demo and on my test server running the latest nightly packages. I have now opened a bug for this and attached a test case .ics file: http://www.sogo.nu/bugs/view.php?id=1775 Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] I am worried now, can we use openchange from a remote location or not?
Hi, On Wed, May 16, 2012 at 1:19 PM, hans wrote: > could do the same. But reading carefully now it it states "outlook support" > everywhere and not "exchange server clone". I guess what I am looking for a > an activesync server. My fault. Should have read better. > > Thank you for your time. There is an activesync implementation on the works, see: https://github.com/xbgmsharp/sogosync You can also search list archives for activesync and you should find more info Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem with user mail tab
Hi, On Mon, May 21, 2012 at 1:57 PM, Alex wrote: > Hi! > One user has problems with his mail tab on SOGo, It does not display > anything. > I though using sogo-tool will fix it but when I run > $/usr/sbin/sogo-tool user-preferences set defaults user.name Mail > > I get this: > May 21 12:42:10 sogo-tool [15436]: <0x0x210dc00[SOGoCache]> Cache cleanup > interval set every 300.00 seconds > May 21 12:42:10 sogo-tool [15436]: <0x0x210dc00[SOGoCache]> Using host(s) > 'localhost' as server(s) > /usr/sbin/sogo-tool: Uncaught exception NSRangeException, reason: Index 4 is > out of range 4 (in 'objectAtIndex:') > > Any idea? Have you tried clearing the browser's cache? For some people that has helped with similar problems. Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo without LDAP and with mysql. Can I still share calendars?
Hi, On Thu, May 24, 2012 at 4:11 PM, hans wrote: > Hi, > > I read somewhere in the manual that mysql as backend does not support > groups. > Does this mean I cannot share calendars when using mysql? AFAIK you should be able to share calendards between individual users just fine. At least with PostgreSQL you can. BR, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Browser cache and upgrades (Was: Re: [SOGo] ANN: SOGo v1.3.15)
Hi, On Thu, May 24, 2012 at 9:34 PM, Jean Raby wrote: > We could finally reproduce the issue and it should now be fixed in the > nightly builds (sope). Will there be 1.3.15b or should one install 1.3.15a + updated sope packages from nightly? And which of the sope packages should be updated: sope49-appserver sope49-sbjson sope49-xml sope49-cards sope49-gdl1-contentstore sope49-gdl1-postgresql sope49-gdl1 sope49-ldap sope49-gdl1-mysql sope49-core sope49-mime And is the nightly version 20120524 or 20120525 where this is fixed? > The default apache configuration has been updated to allow the caching: > > > AllowOverride None > Order deny,allow > Allow from all > > # Explicitly allow caching of static content to avoid browser specific > behavior. > # A resource's URL MUST change in order to have the client load the new > version. > > ExpiresActive On > ExpiresDefault "access plus 1 year" > > And when updating should one add these changes to the Apache configs manually? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo 2.0.4
Hi, On Sat, Jan 26, 2013 at 2:15 AM, Francis Lachapelle wrote: > * added Finnish translation - thanks to Kari Salmu > * updated translations This is great news, thanks! I have a small problem though: After upgrade from 1.3.15 I don't seem to be able to refresh the langauge selection neither on login or preferences page to show the Finnish option. I tried with a vanilla browser with Finnish interface and after login the UI was in Finnish. But still I can't choose the new language from the prefs nor at the login page. Is there something I need to do so I can new languages to show up? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo 2.0.4
Hi, On Fri, Feb 1, 2013 at 11:08 PM, Francis Lachapelle wrote: > On 2013-02-01, at 2:45 PM, Peter Peltonen wrote: >> After upgrade from 1.3.15 I don't seem to be able to refresh the >> langauge selection neither on login or preferences page to show the >> Finnish option. >> Is there something I need to do so I can new languages to show up? > > Can you reproduce this problem on our demo instance? No I cannot: there can I select Suomi (Finnish) just fine. So it's just my upgraded installation. Any ideas what to try to solve the issue? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] user's calendar empty after upgrade (NSInvalidArgumentException -> coredump)
Hi all, I upgraded two separate SOGo servers to sogo-2.0.4a-1.centos6.i686 from 1.3.15a using yum. After the upgrade on both servers at least one user noticed that his calendar is empty. If I login to SOGo with this account I can see the following error in the logs: " 77.86.207.83 - - [04/Feb/2013:20:42:38 GMT] "POST /SOGo/so/j...@domainremoved.eu/Calendar/taskslist?show-completed=0&asc=true&sort=end HTTP/1.1" 200 710/0 0.024 - - 1M 2013-02-04 20:42:39.224 sogod[10801] WOCompoundElement: pool embedding is on. 2013-02-04 20:42:39.224 sogod[10801] WOCompoundElement: id logging is on. 77.86.207.83 - - [04/Feb/2013:20:42:39 GMT] "POST /SOGo/so/j...@domainremoved.eu/Calendar/weekview HTTP/1.1" 200 1954/0 0.330 22374 91% 1M EXCEPTION: NAME:NSInvalidArgumentException REASON:GSTimeZone(instance) does not recognize computedDateForDate: INFO:(null) Feb 04 20:42:39 sogod [1953]: <0x0xb63ebd94[WOWatchDogChild]> child 10801 exited Feb 04 20:42:39 sogod [1953]: <0x0xb63ebd94[WOWatchDogChild]> (terminated due to signal 6, coredump) Feb 04 20:42:39 sogod [1953]: <0x0xb63ebd94[WOWatchDogChild]> avoiding to respawn child before 2013-02-04 20:42:43 +0200 Feb 04 20:42:43 sogod [1953]: <0x0xb62ce01c[WOWatchDog]> child spawned with pid 10817 " What is common with both users is that they have been syncing events from their old Nokia phones with Funambol. But I have other users doing this as well who do not experience this problem. Any ideas how to fix these users' calendars? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo 2.0.4
Hi Christian, On Mon, Feb 4, 2013 at 12:36 PM, Christian Mack wrote: > Am 2013-02-01 23:44, schrieb Peter Peltonen: >> >> On Fri, Feb 1, 2013 at 11:08 PM, Francis Lachapelle >> wrote: >>> On 2013-02-01, at 2:45 PM, Peter Peltonen wrote: >>>> After upgrade from 1.3.15 I don't seem to be able to refresh the >>>> langauge selection neither on login or preferences page to show the >>>> Finnish option. >>>> Is there something I need to do so I can new languages to show up? >>> >>> Can you reproduce this problem on our demo instance? >> >> No I cannot: there can I select Suomi (Finnish) just fine. >> >> So it's just my upgraded installation. Any ideas what to try to solve the >> issue? >> > > What have you set in your configuration for SOGoSupportedLanguages ? > If it is not set, you should be able to use all supported languages per > default. > If it is set and Finnish is not included, just add it. I do not have it set. All I have in my /home/sogo/GNUstep/Defaults/.GNUstepDefaults is: SOGoTimeZone Europe/Helsinki SOGoLanguage English Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: user's calendar empty after upgrade (NSInvalidArgumentException -> coredump)
Replying to myself: It seems to be somehow timezone related: On Mon, Feb 4, 2013 at 8:50 PM, Peter Peltonen wrote: > EXCEPTION: NAME:NSInvalidArgumentException > REASON:GSTimeZone(instance) does not recognize computedDateForDate: > INFO:(null) I managed to subscribe to this users' calendar in Thunderbird although its not shown in the SOGo web UI. I exported then the calendar to ICS and used an ICS validator, which reported: " Error: Error was: Error at line 24: Cannot set timezone for UTC properties Cause: Caused by: Cannot set timezone for UTC properties Context for line 24: 21: END:VTIMEZONE 22: BEGIN:VEVENT 23: LAST-MODIFIED:20111024T062103Z 24: DTSTAMP;TZID=Europe/Helsinki:20120510T105656 25: UID:7464-4FAB7380-5-4559CA80 26: SUMMARY:Notaarintie 32\, hulevesisuunnitelman hyväksyntä 27: PRIORITY:0 " If I compare it to a working calendar I see the difference that there is no TZID on DTSTAMP lines. Instead they look like this: " DTSTAMP:20120214T125104Z " Is the DTSTAMP with TZID perhaps something Sogo cannot handle? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ANN: SOGo 2.0.4
Hi, After upgrading to 2.0.4b the issue seems to be fixed. Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: user's calendar empty after upgrade (NSInvalidArgumentException -> coredump)
More information on this issue: On Mon, Feb 4, 2013 at 9:38 PM, Peter Peltonen wrote: > Replying to myself: > > It seems to be somehow timezone related: > > On Mon, Feb 4, 2013 at 8:50 PM, Peter Peltonen > wrote: >> EXCEPTION: NAME:NSInvalidArgumentException >> REASON:GSTimeZone(instance) does not recognize computedDateForDate: >> INFO:(null) > > I managed to subscribe to this users' calendar in Thunderbird although > its not shown in the SOGo web UI. > > I exported then the calendar to ICS and used an ICS validator, which reported: > > " > Error: Error was: Error at line 24: Cannot set timezone for UTC properties > Cause: Caused by: Cannot set timezone for UTC properties > > Context for line 24: > 21: END:VTIMEZONE > 22: BEGIN:VEVENT > 23: LAST-MODIFIED:20111024T062103Z > 24: DTSTAMP;TZID=Europe/Helsinki:20120510T105656 > 25: UID:7464-4FAB7380-5-4559CA80 > 26: SUMMARY:Notaarintie 32\, hulevesisuunnitelman hyväksyntä > 27: PRIORITY:0 > " > > If I compare it to a working calendar I see the difference that there > is no TZID on DTSTAMP lines. Instead they look like this: > > " > DTSTAMP:20120214T125104Z > " > > Is the DTSTAMP with TZID perhaps something Sogo cannot handle? Upgrading to 2.0.4b did not help: reloading the user's calendar in the web UI still dumps core. I have now opened a bug for this: http://www.sogo.nu/bugs/view.php?id=2227 Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Meego Caldav | '{DAV:}getlastmodified' has no matching SQL field
Hi, On Sun, Apr 21, 2013 at 9:21 PM, mourik jan heupink wrote: > I'm trying to add a SOGo calendar to my Nokia N9 Meego 1.2 Harmattan > device, via it's native CalDAV support. But the calendar is not showing up > on my device. > > Sogo.log tells me the following: > > 2013-04-21 20:09:05.921 sogod[2784] -[WEClientCapabilities > initWithRequest:]: Unknown WebClient: user-agent='Nokia-CalDav/1.0' > > and, more interesting: > > Apr 21 20:09:09 sogod [2784]: [ERROR] <0x5093D5C0[** > SOGoAppointmentFolder]:**C5A8F1D0-B160-0001-B7D6-**1DC095B01274> DAV > property '{DAV:}getlastmodified' has no matching SQL field, response could > be incomplete > > Tips..? Anyone using Meego / SOGo / Caldav combination? > I have an N9 MeeGo 1.2 Harmattan (version PR1.3) as well and I just tried adding the CalDAV account to sync with my sogo-2.0.4b-1.centos6.i686 installation. Adding the calendar worked ok and I could get my Personal calendar events to show in my N9 calendar. I did nothing special, just added the account from N9 "Accounts" and used the CalDAV URL reported by the SOGo Web UI for my Personal Calendar. Checking my logs I can see the same errors as you, though: [root@sogo html]# grep AppointmentFolde /var/log/sogo/sogo.log Apr 22 12:09:28 sogod [2051]: [ERROR] <0xAFB4A004[SOGoAppointmentFolder]:personal> DAV property '{DAV:}getlastmodified' has no matching SQL field, response could be incomplete [root@sogo html]# grep Nokia /var/log/sogo/sogo.log 2013-04-22 08:00:58.657 sogod[2051] -[WEClientCapabilities initWithRequest:]: Unknown WebClient: user-agent='Nokia-CalDav/1.0' But as I can see my events and adding a new event works as well, I think your problem lies somewhere else in your installation? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Best way to sync Outlook 2010 calendars?
Hi, On Tue, Jan 21, 2014 at 7:45 PM, Remi Verchere wrote: > > So, how do you handle Outlook clients? I do not care if Outlook cannot > see people availability, I do not care if they cannot use shared > contacts. > > iCal4OL has worked for me: http://ical.gutentag.ch/ It is not free and the client configuration UI is a bit of a mess, but it seems to do the job. Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Windows phone and Active Sync
Hi, Did anyone get native ActiveSync support to work with WindowsPhone and SOGo? I have a Lumia 900 (WP7) and it is not working. When I try to sync the calendar I get the error code 85002028 on the phone claiming that my Windows Phone version does not support this server version. In SOGo log all I see is: 2014-05-16 00:50:28.707 sogod[2138] -[WEClientCapabilities initWithRequest:]: Unknown WebClient: user-agent='MSFT-WP/7.10.8860' 37.136.139.152, 192.168.0.11 - - [16/May/2014:00:50:28 GMT] "OPTIONS /SOGo/Microsoft-Server-ActiveSync?User=peter&DeviceId=513C3C1A3024FC84A2EDEA24DB51731B&DeviceType=WindowsPhone HTTP/1.1" 200 0/0 0.003 - - 0 With z-push setup the phone syncs ok. I've tried recreating the account on the phone with no luck. Regards, Peter On Wed, Apr 9, 2014 at 10:57 AM, Fabio Onorini wrote: > So I must configure sogo account like a Google account? > > Is not what I would to do with iOS and Android I configure Exchange > Account and I think that also windows phone should do this... > > > 2014-04-08 18:32 GMT+02:00 Rolf : >> >> Yes, by misusing /reconfiguring a google account (which effectively is >> CalDAV / CardDAV). >> >> Works like a charme, except for creating new calendar events. >> >> Rolf >> >> Von: Fabio Onorini >> Gesendet: 08.04.2014 10:38 >> >> An: SOGo mailinglist >> Betreff: Re: [SOGo] Windows phone and Active Sync >> >> Someone was able to configure a device with windows phone with sogo? >> >> >> 2014-03-31 15:37 GMT+02:00 Fabio Onorini : >>> >>> OK, the answer talk about gmail account with some default system folder >>> removed. >>> My default folder in sogo is Sent, Trash and Drafts... >>> >>> >>> With ZEG vm error code is 85002028 >>> >>> >>> 2014-03-31 14:44 GMT+02:00 Ludovic Marcotte : On 2014-03-31, 3:40 AM, Fabio Onorini wrote: > > Error code is: 85002012 A quick search lead me to that: http://answers.microsoft.com/en-us/winphone/forum/wp7-sync/error-code-85002012/8b2c7686-1af8-44a5-b2e8-d97acfa5f300 -- 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 >>> >>> >>> >>> >>> -- >>> --- >>> Fabio Onorini >> >> >> >> >> -- >> --- >> Fabio Onorini > > > > > -- > --- > Fabio Onorini -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo and funambol
Hi, On Tue, Mar 10, 2015 at 10:35 AM, mathilde rousseau wrote: > Hello > Thank you for the responses i will try. An other question how can i do with > windows phone ? I didn’t install samba4 on my logo’s server. You can use ActiveSync (Exchange) as mentioned before, or you can use CalDAV / CardDAV: this can be done with Windows Phone 8.1 by configuring an "iCloud" account which then allows configuring your own CalDAV / CardDAV server to be used. Works for me. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] cannot start sogod: libmemcached.so.7 not found
Hi all, I am a new to SOGo and to the list. I tried installing SOGo on my CentOS6 server following the installation guide using yum. I get the following error when trying to start the service: [root@sogo ~]# service sogod start Starting SOGo: /usr/GNUstep/System/Tools/Admin/sogod: error while loading shared libraries: libmemcached.so.7: cannot open shared object file: No such file or directory sogoD] It appears I do not have the libmemcached.so.7 shared library file: [root@sogo ~]# locate libmemcached.so /usr/lib/libmemcached.so.2 /usr/lib/libmemcached.so.2.0.0 [root@sogo ~]# rpm -qa |grep memcached libmemcached-0.31-1.1.el6.i686 memcached-1.4.4-3.el6.i686 Should I have a different version of libmemcached installed? Regards, Peter Peltonen -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot start sogod: libmemcached.so.7 not found
Hi! On Tue, Oct 11, 2011 at 4:24 PM, Ludovic Marcotte wrote: > On 11/10/11 04:08, Peter Peltonen wrote: >> >> Should I have a different version of libmemcached installed? > > Yes, install the one coming from the SOGo repo - libmemcached-0.49. Thanks for the tip. It appears that using yum priorities is keeping the new memcached package being installed. If I give the sogo repo the same priority (=1) as base and updates, I get the following errors: Error: Package: perl-core-5.10.1-119.el6.i686 (@cr) Requires: perl-Compress-Zlib Removing: perl-Compress-Zlib-2.020-119.el6.i686 (@cr) perl-Compress-Zlib = 2.020-119.el6 Obsoleted By: perl-IO-Compress-2.037-1.el6.rfx.noarch (rpmforge-extras) Not found Available: perl-Compress-Zlib-2.020-115.el6.i686 (base) perl-Compress-Zlib = 2.020-115.el6 Error: Package: perl-IO-Compress-2.037-1.el6.rfx.noarch (rpmforge-extras) Requires: perl(Compress::Raw::Zlib) = 2.037 Installed: perl-Compress-Raw-Zlib-2.023-119.el6.i686 (@cr) perl(Compress::Raw::Zlib) = 2.020 Available: perl-Compress-Raw-Zlib-2.023-115.el6.i686 (base) perl(Compress::Raw::Zlib) = 2.020 Error: Package: perl-core-5.10.1-119.el6.i686 (@cr) Requires: perl-IO-Compress-Zlib Removing: perl-IO-Compress-Zlib-2.020-119.el6.i686 (@cr) perl-IO-Compress-Zlib = 2.020-119.el6 Obsoleted By: perl-IO-Compress-2.037-1.el6.rfx.noarch (rpmforge-extras) Not found Available: perl-IO-Compress-Zlib-2.020-115.el6.i686 (base) perl-IO-Compress-Zlib = 2.020-115.el6 Error: Package: perl-core-5.10.1-119.el6.i686 (@cr) Requires: perl-IO-Compress-Base Removing: perl-IO-Compress-Base-2.020-119.el6.i686 (@cr) perl-IO-Compress-Base = 2.020-119.el6 Obsoleted By: perl-IO-Compress-2.037-1.el6.rfx.noarch (rpmforge-extras) Not found Available: perl-IO-Compress-Base-2.020-115.el6.i686 (base) perl-IO-Compress-Base = 2.020-115.el6 Hmm, is this because the rpmforge-extras has now a different priority? How have others solved this, are you using yum priorities at all with your CentOS SOGo servers? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] cannot start sogod: libmemcached.so.7 not found
Replying to myself: On Tue, Oct 11, 2011 at 6:10 PM, Peter Peltonen wrote: > Hmm, is this because the rpmforge-extras has now a different priority? > > How have others solved this, are you using yum priorities at all with > your CentOS SOGo servers? Removing yum-priorities did not help: those perl packages still conflicted and prevented upgrading memcached. I added "exclude=perl*" to the rpmforge-extras repo config and after that the upgrade went ok. Have other CentOS6 users needed to do this or is my server somehow misconfigured? Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Newbie questions about SQL authentication
I have done my first SOGo 1.3.8b installation on a CentOS6 server. My aim is to use SQL and not LDAP. I have a few basic questions about SQL authentication that were not clear when reading installation guide: - I have created a PostgreSQL database and a user as instructed, but in the guide there was nothing about the actual data that should go in the DB? Do I need to create some tables as well? - "Managing User Accounts" talked about LDAP only. How do I create an admin user with SQL? - Is this the way SOGo is intended to be used: 1. With SOGo web interface, after creating an admin user I create a normal user 2. I specify the IMAP credentials for this user in SOGo with the admin user account 3. Now the user can log into SOGo and see his email + new shared calendar If so, this means that I need to manage two user databases, in the IMAP server and in SOGo? And if a user changes his/her IMAP password by not using SOGo but for e.g. external webmail, I am in trouble? I have a feeling that I have not yet grasped all the principles of this software package and I am missing some points here :) Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Newbie questions about SQL authentication
Hi, On Thu, Oct 13, 2011 at 7:00 PM, Christian Reischl wrote: > Hi, > > you have to create an authentication table (sogo_auth). > > My MySQL table looks like this: Thanks for the info! What about the admin user, how do I create that? > You don't have to manage two user databases. I created a view (called > sogo_auth) to point the SOGo field names to an existing user database. But what if my IMAP user database is located in another server in remote location? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Newbie questions about SQL authentication
Hi, On Fri, Oct 14, 2011 at 11:28 AM, Julian Robbins wrote: > On 13/10/11 15:13, Peter Peltonen wrote: >> >> I have done my first SOGo 1.3.8b installation on a CentOS6 server. My >> aim is to use SQL and not LDAP. > > I used this excellent guide to sogo where there show you how to set up the > config with a SQL database > > http://www.linuxjournal.com/article/10894 Thanks for the tip, but I do not think the article deals with my situation: having a remote IMAP server not inside my LAN but in a different network behind a firewall. I was looking to avoid creating a new IMAP service just for testing SOGo, but unless someone knows a way to access a IMAP user MySQL database securely remotely, I need to start installing a new IMAP server. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Newbie questions about SQL authentication
Hi, 2011/10/17 André Schild : >> Well Mysql has SSL capabilities. I don't know if the SOPE/SOGo client >> supports them however. >> Alternatively, a SSH port forward is always a good option. especially if >> it is just for testing. Quick and easy. >> >> This will forward the local 'mysql' port to 'remote.host' (man ssh for >> option info): >> ssh -TNf -L 3306:127.0.0.1:3306 u...@remote.host >> > Just a normal plain ipsec (or openvpn) tunnel is most of the time the best > solution. > They are very well tested and you can tunnel many things trough them. Thanks for the tips! I should have thought about ssh port forwarding myself. If I need a more permanent remote solution I will check MySQL SSL support and VPN possibilities. Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] HELP !!! /etc/init.d/sogod: line 73: /usr/GNUstep/System/Library/Makefiles/GNUstep.sh: Aucun fichier ou répertoire de ce type Restarting SOGo: /usr/GNUstep/System/Tools/Admin/sogod: error w
Hi, On Fri, Oct 28, 2011 at 11:20 PM, Ludovic Marcotte wrote: > On 28/10/11 15:55, g...@orthobourg.com wrote: >> >> Hi , >> >> Since upgrade of my Centos 5 , I thing GNUStep alose upgrade :( >> >> No I have this error when I try to start sogod >> >> [root@serv1 ~]# service sogod start >> /etc/init.d/sogod: line 73: >> /usr/GNUstep/System/Library/Makefiles/GNUstep.sh: >> Aucun fichier ou répertoire de ce type >> Starting SOGo: >> /usr/GNUstep/System/Tools/Admin/sogod: error while loading shared >> libraries: >> libgnustep-base.so.1.20: cannot open shared object file: No such file or >> directory >> sogo [ÉCHOUÉ] > > Show us the list of installed sogo, sope and gnustep RPMS. > I had the same problem after running 'yum update' on my centos6 machine. What I have installed is: gnustep-base-1.23.0-1.i686 gnustep-make-2.6.1-1.i686 sogo-1.3.9-1.el6.i686 sope49-gdl1-contentstore-1.3.9-1.el6.i686 sope49-gdl1-postgresql-4.9-20111028_1664.el6.1.i686 sope49-sbjson-2.3.1-20111028_1664.el6.1.i686 sope49-appserver-4.9-20111028_1664.el6.1.i686 sope49-core-4.9-20111028_1664.el6.1.i686 sope49-mime-4.9-20111028_1664.el6.1.i686 sope49-xml-4.9-20111028_1664.el6.1.i686 sope49-ldap-4.9-20111028_1664.el6.1.i686 sope49-cards-1.3.9-1.el6.i686 sope49-gdl1-mysql-4.9-20111028_1664.el6.1.i686 sope49-gdl1-4.9-20111028_1664.el6.1.i686 I fixed the problem by editing /etc/init.d/sogod in the following way: #. /usr/GNUstep/System/Library/Makefiles/GNUstep.sh . /usr/share/GNUstep/Makefiles/GNUstep.sh But after this fix sogod still fails to start: [root@sogo ~]# service sogod start Starting SOGo: /usr/sbin/sogod: symbol lookup error: /usr/sbin/sogod: undefined symbol: main sogoD] Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] HELP !!! /etc/init.d/sogod: line 73: /usr/GNUstep/System/Library/Makefiles/GNUstep.sh: Aucun fichier ou répertoire de ce type Restarting SOGo: /usr/GNUstep/System/Tools/Admin/sogod: error w
Hi, On Fri, Oct 28, 2011 at 11:46 PM, Jan-Frode Myklebust wrote: > Could you post the output of "rpm -qi gnustep-make" ? Sure: [root@sogo ~]# rpm -qi gnustep-make Name: gnustep-make Relocations: (not relocatable) Version : 2.6.1 Vendor: The GNUstep Project Release : 1 Build Date: Wed 19 Oct 2011 05:09:24 PM EEST Install Date: Fri 28 Oct 2011 10:54:09 PM EEST Build Host: vizzini.inverse.ca Group : System Environment/Base Source RPM: gnustep-make-2.6.1-1.src.rpm Size: 807547 License: GPL Signature : (none) Packager: GNUstep Development URL : http://www.gnustep.org/ Summary : GNUstep Makefile package Description : This package contains the basic scripts, makefiles and directory layout needed to run and compile any GNUstep software. This package was configured for library combo gnu-gnu-gnu using the FHS filesystem layout. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] HELP !!! /etc/init.d/sogod: line 73: /usr/GNUstep/System/Library/Makefiles/GNUstep.sh: Aucun fichier ou répertoire de ce type Restarting SOGo: /usr/GNUstep/System/Tools/Admin/sogod: error w
Hi, On Sat, Oct 29, 2011 at 12:05 AM, Ludovic Marcotte wrote: > > > But after this fix sogod still fails to start: > > [root@sogo ~]# service sogod start > Starting SOGo: > /usr/sbin/sogod: symbol lookup error: /usr/sbin/sogod: undefined symbol: > main > sogoD] > > That has been fixed. We were building packages on SL Linux but it looks like > they recently broke binary compatibility with RHEL/CentOS 6. We're > rebuilding them with CentOS 6. Ok, good to hear that the problem has been found. I had considered in switching to SL for faster updates, but I guess I did the right thing by sticking with CentOS. Time for me to go to bed here in Finland, it would be a nice surprise to find working packages in the morning, so I could finish my first SOGo installation and start testing :) Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogo-1.3.9-2 update problems
Hi, Just ran 'yum update' on my centos6 box and SOGo was updated to version 1.3.9-2. When accessing my server with the address /SOGo/ I get now no graphics displayed in the login page. In the sogo.log file I see the errors: [Sun Oct 30 00:46:03 2011] [error] [client ::1] File does not exist: /usr/GNUstep/System/Library/SOGo/WebServerResources, referer: http://localhost/SOGo/ Looking at the output of "locate WebServerResources" I think on centos6 the correct directory should be: /usr/lib/GNUstep/SOGo/WebServerResources ? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: sogo-1.3.9-2 update problems
Hi, On Sun, Oct 30, 2011 at 12:53 AM, Peter Peltonen wrote: > Hi, > > Just ran 'yum update' on my centos6 box and SOGo was updated to version > 1.3.9-2. > > When accessing my server with the address /SOGo/ I get now no graphics > displayed in the login page. > > In the sogo.log file I see the errors: > > [Sun Oct 30 00:46:03 2011] [error] [client ::1] File does not exist: > /usr/GNUstep/System/Library/SOGo/WebServerResources, referer: > http://localhost/SOGo/ > > Looking at the output of "locate WebServerResources" I think on > centos6 the correct directory should be: > /usr/lib/GNUstep/SOGo/WebServerResources ? So... Is this a bug in the updated package or have I somehow managed to misconfigure my server? This is my first installation and the packages were updated by yum in the middle of the installation process. Maybe I should remove the packages and start all over again? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Re: sogo-1.3.9-2 update problems
Hi, On Sun, Oct 30, 2011 at 4:29 PM, Ludovic Marcotte wrote: > On 30/10/11 10:10, Peter Peltonen wrote: >> >> So... Is this a bug in the updated package or have I somehow managed >> to misconfigure my server? >> >> This is my first installation and the packages were updated by yum in >> the middle of the installation process. >> >> Maybe I should remove the packages and start all over again? > > Adjust your SOGo.conf Apache configuration file accordingly. Thanks for the tip: I found out that the yum update had created a .rpmnew file for the Apache config. Using that file as the template for my own configuration I was able to get the SOGo web UI working and logging in the first time :) Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] warning in the sogo log files
Hi, I've now got my first SOGo installation finally working with PostgreSQL and remote Dovecot IMAP server. When I login using the web UI I see the following warnings in /var/log/sogo/sogo.log : Oct 30 21:41:57 sogod [29911]: [WARN] <0x0x8a76f0c[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table Oct 30 21:41:57 sogod [29911]: [WARN] <0x0x8a76f0c[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table Oct 30 21:41:57 sogod [29911]: [WARN] <0x0x8a76f0c[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table 2011-10-30 21:41:58.373 sogod[29911] WARNING: IMAP4 connection pooling is disabled! 2011-10-30 21:42:20.172 sogod[29911] WARNING(-[NSNull(misc) length]): called NSNull -length (returns 0) !!! The last one appears when I use the calendar and it seems to repeated quite many times. Are these errors something I should be considered about? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] PostgreSQL gotchas
Hi, For other people trying to install SOGo using PostgreSQL authentication on CentOS6 here are a few gotchas I encountered: 1) By default PostgreSQL is not accepting TCP/IP connections. You can enable this by adding PGOPTS="-i" to /etc/sysconfig/pgsql/postgresql and restarting the postgresql service 2) If you are running PostgreSQL on localhost using IPv4, use IP address 127.0.0.1 and not name "localhost" in .GNUstepDefaults configuration, as "localhost" is interpreted as an IPv6 address for the PostgreSQL URLs. The other option could be to allow IPv6 connections in pg_hba.conf by specifying: host sogo sogo ::1/128 md5 Hope this helps others trying to setup SOGo with PostgreSQL. Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Thunderbird 7.1 + Lightning 1.0b7
Hi, I have just installed my first SOGo (version 1.3.9-2) on a CentOS6 server by using yum. I had succesfully installed my SOGo calendar to iCal with the URL http://myserver/SOGo/dav/myusern...@domain.dom Now I wanted to see if I could see my calendar using TB 7.1 with the Ligthning Calendar Add-On on Mac OSX. The calendar is installed using CalDAV format (using the same URL as in iCal) as a "remote" calendar without any errors in Lightning, but I do not see any calendar entries even if I choose "Reload Remote Calendars". On the server I see a continuous flow of messages like this in sogo.log: localhost - - [01/Nov/2011:18:32:21 GMT] "PROPFIND /SOGo/dav/myusern...@domain.dom/ HTTP/1.1" 207 831/223 0.004 - - 0 localhost - - [01/Nov/2011:18:32:21 GMT] "OPTIONS /SOGo/dav/ HTTP/1.1" 200 0/0 0.003 - - 0 which stops only if I quit Thunderbird. After starting TB+Ligthning again I see a warning sign next to the SOGo calendar which tooltip says "The calendar SOGo test is momentarily not available". If I do "Reload Remote Calendars", the tooltip goes away, but nothing happens and the messages start coming to the sogo.log again. Questions: - Is the new TB + Ligthning combination supported at all or is the only combination that works the modified 3.x one that Inverse provides? - If it is (for at least viewing the calendar), can you give me a hint what is wrong with my setup? Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 7.1 + Lightning 1.0b7
Hi, On Tue, Nov 1, 2011 at 7:11 PM, Brendan Murtagh wrote: > We run Thunderbird 3.1.x. We only install the frontends for Lightning > Inverse and SOGo Connector and tie into our mail server directly. You can > see on http://www.sogo.nu/english/downloads/frontends.html that the > Thunderbird versions listed are 3.1 and 2.0. I understand that with the version Inverse offers I can have all kinds of extra features. Unfortunately I probably will not be able to influence the version of TB the users will be using. So is it really so, that even the basic functionality won't work with TB + Ligthining (viewing / creating events)? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 7.1 + Lightning 1.0b7
Hi, On Tue, Nov 1, 2011 at 7:24 PM, Ludovic Marcotte wrote: > You can subscribe to users' calendars - you just need to add the calendar > manually (from Thunderbird's GUI) and use the proper DAV location URL. This was the answer I expected and the exact thing I tried to do, but which failed (see my original post). Is perhaps my DAV location URL somehow wrong? The one I used was the same I used with Mac's iCal: http://myserver/SOGo/dav/myusern...@domain.dom And what about the sogo.log being flooded with messages, is that normal, even if one has wrong settings? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Thunderbird 7.1 + Lightning 1.0b7
Hi, On Wed, Nov 2, 2011 at 11:43 AM, Robert Casties wrote: > The best way to get the correct URL is to go to the web frontend, select > the calendar, select "Properties" and copy the "CalDAV URL" from the tab > "Links to this calendar". Thanks for the tip, this worked for me as well! Also the sogo.log flooding stopped. It's probably not a good thing that using a wrong calendar URL can flood the logs like it happened to me? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Accessing SOGo with other applications
Hi, On Fri, Nov 4, 2011 at 2:28 PM, Christian Naumer wrote: > As the subject says. Does anyone have experience accessing SOGo from > other applications? Like PHP scripts. Do you use CalDAV/CardDAV or > access the DB directly? Or are there already interfaces which could be used? I would be interested in this as well. Quick googling revealed these two PHP client libraries: http://www.phpclasses.org/package/3619-PHP-Generate-calendars-in-iCal-format.html http://www.kigkonsult.se/iCalcreator/index.php Has someone tried them out / are there other (better) alternatives around? Never thought about accessing the DB directly, that would be a quick'n dirty way to get the calendar data out to a web page. Would someone know some example queries for example how to get events for one week for a specific user? Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] display all users calendars
Hi, I would need to introduce SOGo to a group of users who have been used to start they week by looking at everyone's calendars for the week. Their current calendar solution shows on one page a list of names and the tasks and the starting time of the task for these people for every day. I think there isn't a way to create this kind of view in the SOGo calendar web view? Does someone know a web client that could be used as a frontend for SOGo and could show this kind if view? Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo Multidomain
Hi, 2011/11/24 André Schild : > The system can work with both styles of files, but the XML is preffered now. Yes, XML seems to be preferred as if you use any SOGo tools, the configuration file is transformed into XML. But: What we newbie SOGo administrators find hard is that in the installation guides all examples are in the old format. Once your configuration file has been transferred to XML, one cannot any more rely on the example code provided by the guides. Is there perhaps a tool that could convert the old style config to an XML one, so one could convert the examples provided in the guide to the new format? For example this multi-domain config from the installation guide: { "sogod" = { SOGoProfileURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile"; OCSFolderInfoURL = "postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info"; OCSSessionsFolderURL = “postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder”; SOGoAppointmentSendEMailNotifications = YES; © 2008-2011 Inverse inc. Configuration 31Chapter 5 SOGoCalendarDefaultRoles = ( PublicViewer, ConfidentialDAndTViewer ); SOGoLanguage = English; SOGoMailingMechanism = smtp; SOGoSMTPServer = 127.0.0.1; SOGoSentFolderName = Sent; SOGoTimeZone = America/Montreal; SOGoTrashFolderName = Trash; SOGoIMAPServer = localhost; domains = { acme = { SOGoMailDomain = acme.com; SOGoDraftsFolderName = Drafts; SOGoUserSources = ( { type = ldap; CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; 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_acme; isAddressBook = YES; port = 389; } ); }; coyote = { SOGoMailDomain = coyote.com; SOGoIMAPServer = imap.coyote.com; SOGoUserSources = ( { type = ldap; CNFieldName = cn; IDFieldName = uid; UIDFieldName = uid; baseDN = "ou=users,dc=coyote,dc=com"; bindDN = "uid=sogo,ou=users,dc=coyote,dc=com"; bindPassword = qwerty; canAuthenticate = YES; displayName = "Shared Addresses"; hostname = localhost; id = public_coyote; isAddressBook = YES; port = 389; } ); } }; }; } Best regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Something for my webhosting company?
Hi, On Wed, Dec 7, 2011 at 1:59 PM, ha...@aasterud.com wrote: > In the mean time I have been doing some research. I found it rather > complicated to use LDAP. LDAP does not really fit in to my webhosting > business. But I found some info saying that Sogo also can authenticate > from MySql. As I wrote earlier, I have all my user info, domain info and > email accounts stored in both postgresql and mysql. Is there a way to let > these databases interact with SOGO? Any suggestions? I'm no SOGo expert, but I do know that SOGo can play together with MySQL and PostgreSQL. You can for example create a view in your db that maps to your existing user data in that database, and use that for authentication. I did that myself with a vpopmail user database and it seems to work fine. This is the SQL for that MySQL view I used: CREATE VIEW sogo AS SELECT concat( pw_name, '@example.com' ) AS c_uid, pw_name AS c_name, pw_passwd AS c_password, pw_name AS c_cn, concat( pw_name, '@example.com' ) AS mail FROM example_com; Hope this helps. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Accessing SOGo with other applications
Hi, On Fri, Dec 23, 2011 at 6:12 PM, Moussa NOMBRÉ wrote: > Le 2011-11-04 08:28, Christian Naumer a écrit : > >> As the subject says. Does anyone have experience accessing SOGo from >> other applications? Like PHP scripts. Do you use CalDAV/CardDAV or >> access the DB directly? Or are there already interfaces which could be >> used? > > I've an interface with phpicalendar to publish public calendars. > > It's work's with ics's file get from sogo, like this : > http://sogo.mydomain/SOGo/dav/public/some_username/Calendar/some-calendar's-name.ics. > You have to enable public access for thi sto work : sogod > SOGoEnablePublicAccess YES > > I wish you can gather some ideas from that. Thanks! I will experiment this. But I'd still be interested in importing data from my own web apps to the sogo calendar. Is accessing the db directly the easiest way or does this setting SOGoEnablePublicAccess also allow importing data to SOGo, do you know? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Authentication using MySQL
On Tue, Jan 17, 2012 at 7:54 PM, Brian KREULEN wrote: > Would it be possible to get a copy of this web app? Or maybe some code > snippets? I'm having some difficulties accessing the calendar, and there > seems to be a lack of examples on the net Thanks in advance. +1 I'd like to get my hands on this web app as well: > I wrote an webapplication which retrieves all events of a week from all users > (current 30) and displays them in a week-calendar-like table. > The events of every user are retrieved by CalDAV - runs quite good! > > Greetings, > Martin Rabl Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] funambol build fails: error while expanding funambol-sogo-1.0.8.s4j.s4j
I am trying to get Funambol working with sogo 1.3.11 on centos6 but bumped on this error: " [root@sogo Funambol]# ./bin/install-modules [echo] funambol-sogo-1.0.8.s4j pre-installation... BUILD FAILED /opt/Funambol/ds-server/install/install.xml:197: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:106: The following error occurred while executing this line: /opt/Funambol/ds-server/install/install-modules.xml:131: Error while expanding /opt/Funambol/ds-server/modules/funambol-sogo-1.0.8.s4j.s4j " I installed the funambol-10.0.3 server, is this supported? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] different mysql views not used in multi-domain setup
I am trying to get a multi-domain setup working, but I have a problem with views to my MySQL db as Sogo seems to always want to use the view I have named 'sogo' and not the one named 'sogo_domain2'. Here is my setup: domain1.net SOGoMailDomain domain1.net SOGoUserSources canAuthenticate YES id directory isAddressBook YES type sql userPasswordAlgorithm crypt viewURL mysql://sogo:pass@192.168.0.10:3306/vpopmail/sogo domain2.net SOGoMailDomain domain2.net SOGoUserSources canAuthenticate YES id directory isAddressBook YES type sql userPasswordAlgorithm crypt viewURL mysql://sogo:pass@192.168.0.10:3306/vpopmail/sogo_domain2 After doing my changes in the config files I've restarted both sogod and memcached so Sogo should have the correct config at least. But I cannot login to domain2.net when using the SOGo web UI. >From the MySQL query log I can see that the query is ran on against the wrong view (sogo and not sogo_domain2): SELECT c_password FROM sogo WHERE c_uid = 'pe...@domain2.net' Any ideas what I am doing wrong? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] different mysql views not used in multi-domain setup
On Sun, Jan 29, 2012 at 1:19 AM, Ludovic Marcotte wrote: > Sources ID must be different across domains and they are identical right now > ("directory"). Thanks, that was it! Should have noticed that myself... Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] problem with multiple imap servers: how to debug authentication?
I am using MySQL based authentication and my setup works fine if all domains are using the same IMAP/MySQL server. When I add a new IMAP/MySQL combo to my setup, authentication to the new domain does not work from SOGo web UI. The old domains work fine. All I get in the SOGo log is: Feb 02 12:49:56 sogod [28918]: SOGoRootPage Login for user 'pe...@newdomain.tld' might not have worked - password policy: 65535 grace: -1 expire: -1 bound: 0 localhost - - [02/Feb/2012:12:49:56 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/74 0.062 - - 3M I do not see any marks of a connection attempt in the new IMAP server's (Dovecot) log. How to debug this further? In GNUstepDefaults config for the domain that works (old server looks) likes this: olddomain.tld SOGoMailDomain olddomain.tld SOGoUserSources SOGoIMAPServer imaps://192.168.0.10:993 canAuthenticate YES id olddomain.tld isAddressBook YES type sql userPasswordAlgorithm crypt viewURL mysql://sogo:password@192.168.0.10:3306/vpopmail/sogo_olddomain And the new domain that does not work: newdomain.tld SOGoMailDomain newdomain.tld SOGoUserSources SOGoIMAPServer imaps://newserver.tld:993 canAuthenticate YES id newdomain.tld isAddressBook YES type sql userPasswordAlgorithm crypt viewURL mysql://sogocal:passw...@newserver.tld:3306/vpopmail/sogo_newdomain Both MySQL setups have the correct views created and I can connect to both MySQL servers from the sogo server just fine. Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: problem with multiple imap servers: how to debug authentication?
Replying to myself: On Thu, Feb 2, 2012 at 4:52 PM, Peter Peltonen wrote: > I do not see any marks of a connection attempt in the new IMAP > server's (Dovecot) log. > > How to debug this further? After turning MySQL query logging on and seeing the queries done by Sogo while authenticating, I realised I had a typo in my CREATE VIEW statement. After fixing that I could login via the web UI. Also it should be noted that the SOGoIMAPServer needs to be defined in the domain dict but not in the SOGoUserSources dict, so this is the correct definition: newdomain.tld SOGoMailDomain newdomain.tld SOGoIMAPServer imaps://newserver.tld:993 SOGoUserSources canAuthenticate YES id newdomain.tld isAddressBook YES type sql userPasswordAlgorithm crypt viewURL mysql://sogocal:passw...@newserver.tld:3306/vpopmail/sogo_newdomain Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Understanding how calendar sharing works
Hi, I want to be enable to create a task or an event in my coworker's SOGo calendar for him, but I dont't seem to find the correct way to do this. I tried the following in the Web UI: 1) In the Web UI's "Calendars" tab I chose "Subscribe to a calendar" and chose the coworker's Personal calendar. It appeared under the "Calendars" in my Calendar view. 2) I tried creating a new event in the Web UI but the only calendar available for this event was my own... I therefore assume the calendar's default mode is read-only. How do I change this? In the SOGo FAQ it reads: "You can also allow others to create and delete calendar objects in your calendars", so it should be possible, but I cannot find instructions how to achieve this? I also tried it in Lightning: 1) Added my coworker's calendar in Lightning 2) Tried creating a new event in his calendar. This resulted in the error: Error_code: MODIFICATION_FAILED Description: Status Code: 403, The user lacks the required permission to perform the request. http://www.w3.org/1999/xhtml";> An error occurred during object publishingtried to access private object (0x0x947fb4c, SoClass=SOGoAppointmentFolder) So, what am I missing? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Understanding how calendar sharing works
On Sat, Feb 4, 2012 at 6:02 PM, CF wrote: > ICS calendars are read only. You must use CalDAV. I am using CalDAV. At least I think I am :) I use the CalDAV address in Lightning to access the calendar provided by SOGo, therefore I am using CalDAV, right? And I also have the problem in using the SOGo web UI. Or am I missing some newbie gotcha here...? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Understanding how calendar sharing works
Hi Robert, On Sat, Feb 4, 2012 at 7:42 PM, Robert Casties wrote: > As the user that owns the calendar you can right-click on the calendar > in the web frontend and choose "permissions". There you can add another > user to the ACL and give them permission to create, change, and delete > events. > > Once you have done that you can use any CalDav client. Thanks for the tip, but: I do not see such option. If I right click my Personal Calendar in the SOGo web UI under Calendars tab all I see is: Properties New Calendar... Delete Calendar... Export Calendar... Import Events... Publish Calendar... Reload Remote Calendars Sharing... Am I looking in the wrong place? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Understanding how calendar sharing works
Hi, On Sun, Feb 5, 2012 at 5:02 AM, Mirko Stoffers wrote: >> Properties >> New Calendar... >> Delete Calendar... >> Export Calendar... >> Import Events... >> Publish Calendar... >> Reload Remote Calendars >> Sharing... >> > Did you try "Sharing"? Yes. From there I can search for users and "Subscribe users" for the calendar. But even if my coworker subscribes me, I cannot add events to this calendar. I have no idea what this "Sharing" option actually does, can someone enlighten on me this as well, please? I must be looking in the wrong place. I am obviously missing some documentation or FAQ, right? I am happy to read the fine manuals, if someone could just point me to this information? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] funambol not syncing from outlook but gives no errors
I am trying to get Outlook <-> Funambol <->SOGo sync working with the following software installed in CentOS6: sogo-1.3.11-1 installed with yum funambol-8.5.2 server + funambol-sogo-1.0.8 module Outlook 2010 + Funambol Windows Sync Client 10.1.6 For SOGo I am using PostgreSQL (no LDAP) and authenticating to multiple domains with email addresses. SOGo web UI logins work fine with the account test...@mydomain.tld AFAIK I've installed the server part as instructed by the official documentation by Inverse: added the module, configured SOGo SyncSource in the admin tool and enabled the use of Inverse's SOGoOfficer setup. In the Windows Sync Client I speficied the following configuration parameters: Server Location: http://sogo.mysogodomain.tld:8080/funambol/ds Username: test...@mydomain.tld Password: I've selected Calendars and Tasks to be synced and havent't checked "Enable Encryption" The problem is: when I click in the Sync window the Calendar button after adding an event in Outlook everything seems to go fine as the Sync Client is sending one event and and shows a green sign after syncing. But after reloading the calendar I see no new entries in my SOGo web UI calendar and now events/tasks have been synced from SOGo to Outlook. If I go to the Server Location with my browser I get the greeting: Funambol Data Synchronization Server v.8.5.2 I do not see any connection attemps in /var/log/sogo/sogo.log while syncing. But I guess that is expected, as Funambol should access the SOGo database directly, right? The Windows Sync Client Log says: " 15:34:34 GMT +2:00 [INFO] - Outlook session opened successfully! Using: Outlook 2010. 15:34:34 GMT +2:00 [INFO] - Begin synchronization of appointment source (two-way) 15:34:34 GMT +2:00 [INFO] - ** BEGIN of Synchronization session ** 15:34:34 GMT +2:00 [INFO] - Preparing synchronization of appointment... 15:34:34 GMT +2:00 [INFO] - Retrieved new appointment item: "outlookista taakin" 15:34:34 GMT +2:00 [INFO] - Clearing cache for appointment 15:34:34 GMT +2:00 [INFO] - END of Synchronization session. 15:34:34 GMT +2:00 [INFO] - Sync successfully completed. 15:34:34 GMT +2:00 [INFO] - Sync of appointment completed successfully 15:34:34 GMT +2:00 [INFO] - Outlook session closed successfully. 15:34:34 GMT +2:00 [INFO] - === SYNCHRONIZATION REPORT === === SYNC COMPLETED SUCCESSFULLY --- Last error code = 0 Last error msg = --|CLIENT-|SERVER-| Source | NEW | MOD | DEL | NEW | MOD | DEL | --|---| appointment| 0/ 0| 0/ 0| 0/ 0| 1/ 1| 0/ 0| 0/ 0| --|---| appointment: -- Source state= OK Last error code = 0 Last error msg = 15:34:34 GMT +2:00 [INFO] - Check on server location for update 15:34:34 GMT +2:00 [ERROR] - No response from update server 15:34:34 GMT +2:00 [ERROR] - Client update error - uses the stored parameters 15:34:34 GMT +2:00 [ERROR] - update check failed " And in /opt/Funambol/logs/ds-server/ds-server.log I see messages like this: " uaXN0cmF0b3I=] [test...@mydomain.tld] [] Handling incoming request [2012-02-05 15:59:16,256] [funambol.transport.http] [INFO] [16FFD5A133CB82F7510BB8837D270248] [fol-UEVURVJQRUxUT05BNjEwOkFkbWluaXN0cmF0b3I=] [test...@mydomain.tld]] [] Request URL: http://sogo.mysogodomain.tld]:8080/funambol/ds " and: " 2012-02-05 15:59:16,272] [funambol.engine.strategy] [INFO] [16FFD5A133CB82F7510BB8837D270248] [fol-UEVURVJQRUxUT05BNjEwOkFkbWluaXN0cmF0b3I=] [test...@kryptoniitti.com] [event] Synchronizing... [2012-02-05 15:59:16,359] [funambol.transport.http] [INFO] [16FFD5A133CB82F7510BB8837D270248] [fol-UEVURVJQRUxUT05BNjEwOkFkbWluaXN0cmF0b3I=] [test...@mydomain.tld]] [] Request processed. " and: " [2012-02-05 15:59:16,448] [funambol.engine] [INFO] [16FFD5A133CB82F7510BB8837D270248] [fol-UEVURVJQRUxUT05BNjEwOkFkbWluaXN0cmF0b3I=] [test...@mydomain.tld] [] fol-UEVURVJQRUxUT05BNjEwOkFkbWluaXN0cmF0b3I=/test...@mydomain.tld: synchronization completed " Any ideas how I could debug my problem further or what I am doing wrong? -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Re: funambol not syncing from outlook but gives no errors
Providing some more info: On Sun, Feb 5, 2012 at 4:11 PM, Peter Peltonen wrote: > The Windows Sync Client Log says: Here is the Windows Sync Client Log captured in Debug mode: http://pastebin.com/iKTHGgnH Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Understanding how calendar sharing works
Hi! On Sun, Feb 5, 2012 at 5:27 PM, CF wrote: > Ok, you should next verify if you have proper rights (ACL): click on > Sharing, add User, and double clic on the newly added user (or double clic > on Any to change common rights). You can then set the correct permissions. > > Don't bother with lightning until you have it working in web interface; as > soon as it is ok, you can quietly mapped your calendars (through CalDAV, but > you have this point ok :) ) Thank you! This was what I was missing: After clicking "Sharing" and seeing the list of users I didn't realise I need to double click the username to get the ACL info window visibile. I had tried clicking it once (as my mouse indicated the name was a link) but as nothing happened then I thought that the "Subscribe" checkbox was the only setting in this view I could set. I am sure I can now get Lightning working as well. Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Which version of Funambol server to use
The documentation for SOGo v. 1.3.11 says that Funambol server v. 8.5.2 is supported. Is this still correct, do people have this combo working? As I seem to be unable to get SOGo syncing with the Funambol server, I am wondering if it is some other version of the Funambol server that I should be installing (such as the newest 10.0.3)... Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Which version of Funambol server to use
Hi, 2012/2/7 André Schild : > Am 07.02.2012 11:55, schrieb Peter Peltonen: > >> The documentation for SOGo v. 1.3.11 says that Funambol server v. >> 8.5.2 is supported. >> >> Is this still correct, do people have this combo working? > > Yes, should work. Ok, good to know. > What happens ? > Logfiles ? Here is my first report of the problematic situation: https://inverse.ca/sogo/lists/arc/users/2012-02/msg00073.html Here are my notes of the steps I did while installing Funambol: http://pastebin.com/aRzhyGWu After that I've debugged my case a bit further: * I can login with my SOGo account ok using the Funambol webdemo in http://sogo.mydomain.tld:8080/webdemo/ and I can see the calendar events created in Outlook there --> I assume this means that Outlook is syncing to Funambol server ok, so I assume that the problem is between the Funambol server and SOGo * After enabling statement logging in PostgreSQL I can see that the Funambol sync is causing SQL statements such as this to be run: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'test...@mydomain.tld' AND c_folder_type = 'Appointment'; --> So Funambol should be able to access the SOGo database ok * If I run the previous statement using the psql client I get a sensibile answer in return: -- personal (1 row) * But I do not see any INSERT statements when syncing Outlook... I think I should be seeing in the log something similar as with the SOGo web ui when I create a new event: INSERT INTO sogotesterik0046e9ed3a5_quick (c_partstates, c_orgmail, c_uid, c_sequence, c_category, c_nextalarm, c_title, c_classification, c_location, c_name, c_component, c_iscycle, c_enddate, c_priority, c_status, c_isopaque, c_startdate, c_isallday) VALUES ('', '', '279B-4F2EB080-7-4797FD80', 0, null, 0, 'a test event created in sogo web ui', 0, '', '279B-4F2EB080-7-4797FD80.ics', 'vevent', 0, 1328463900, 0, 1, 1, 1328460300, 0) Right? It is a bit frustrating as I get no errors anywhere... All ideas appreciated! Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Which version of Funambol server to use
Hi, 2012/2/7 André Schild : > So you mean: > > Calendar entries from Sogo -> Outlook work > Calendar entries from Outlook -> Sogo don't work No. The only thing that works is Outlook -> Funambol as I can see the Outlook items in Funambol webapp But Funambol -> SOGo does not work And neither does SOGo -> Funambol (and therefore Funambol -> Outlook) How does SOGo and Funambol compare what is new and neets to be synced? Perhaps there is some time/date related setting wrong and therefore nothing is synced between Funambol and SOGo? This would also explain why I get no errors as in principal everything works. > Silly question: You have configured the funambol outlook connector to do a > 2way sync and not only server->client ? Yes, as the items are synced from Outlook to Funambol. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Which version of Funambol server to use
Hi, 2012/2/7 André Schild : > I think they should NOT show up in funambol webapp! > > Usually this means that the SyncML clients are using some default sync > source names, > and not the newly added ones. > > When you did install the sogo connector in funambol server, you did create > two > new sync urls. (Probably sogo-card and sogo-cal) Lets get this straight: I need to use some other URL than http://sogo.mysogodomain.tld:8080/funambol/ds for syncing the SOGo items? This is what I have configured for the sync client at the moment: Location: http://sogo.mysogodomain.tld:8080/funambol/ds Username: test...@mydomain.tld Password: And this is what I did with funamboladmin: Modules > sogo > FunambolSOGoConnector > SOGo SyncSource # added sogo-cal, sogo-todo, sogo-event and sogo-card like this: Source URI: sogo-card Name: sogo-card Supported type: text/x-vcard Database URL: jdbc:postgresql://127.0.0.1/sogo Database username: sogo Database password: sogo But in Windows Sync Client under "Account" I can configure only one Location, so if every resource (calendar, contacts) need a different URL, it is not possible to configure them? Hmm, now looking at Windows Sync Client settings, I see that there is also for each item an Advanced setting, for example for Calendar there is : Advanced Remote name: event Data format: vCalendar Should this be sogo-event instead? BTW what is the difference between sogo-event and sogo-cal? As there was a synsource type for both I created both but which one actually is handling the calendar events? And is "todo" same as "task" in the calendar? Best, Peter > > You must now also tell the syncml clients to use these sync URL's > > The funambol clients per default use standard names like card / cal / todo > etc. > And these are preconfigured in the funambol server to have a backend in the > db of the server. > > So either: > > - Change the clients to use the sogo-xxx url's > - Or remove the default sync sources in funambol and then add them with the > sogo backend. > > > André > -- > users@sogo.nu > https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Which version of Funambol server to use
Hi, 2012/2/7 André Schild : >> Hmm, now looking at Windows Sync Client settings, I see that there is >> also for each item an Advanced setting, for example for Calendar there >> is : >> >> Advanced >> Remote name: event >> Data format: vCalendar >> >> Should this be sogo-event instead? > > Yes This was it, hank you André for helping me out here! I encountered one more obstacle which was error in syncing and a Java exception reported in ds-server.log: [sogo-event] Exception occured in getUserTimeZone() - trying to read from JSON string: java.lang.NullPointerException Solution for this was to set the user's Timezone to something else in SOGo webapp Preferences, Save the preferences and then set the Timezone back to Europe/Helsinki (which is the default in my SOGo config). Now Outlook 2010 is syncing its tasks and events nicely. Next challenge is a Nokia N8 Symbian phone... Cheers, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Hi, On Thu, Feb 9, 2012 at 4:50 AM, Nigel Pegram wrote: > My problem is that I cannot login. > > I have tried creating a couple of users in the sogo_view table and have > tried > passwords in clear text, and md5. All the other tables are empty since > ths is my first login attempt. > > It seems that the communication is happening between sogo and the database, > but > something fails after the query. I don't know how to debug this any further. Perhaps the problem is with the MySQL views you created for authenticating your users? I have no experience on MySQL+SOGo combo myself, but perhaps this Linux Journal tutorial could help if you followed it step by step: http://www.linuxjournal.com/article/10894 Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Cannot login following new install
Hi, On Fri, Feb 10, 2012 at 4:43 AM, Nigel Pegram wrote: > However, nothing new is displayed, the login page still appears. If the > wrong password is used, an error message appears, as expected. And what happens if you give the correct password -- nothing? > There are no errors in the apache logs, just: > > 127.0.0.1 - - [10/Feb/2012:10:32:27 +0800] "GET /SOGo/chris HTTP/1.1" > 200 4036 "http://localhost/SOGo/"; "Mozilla/5.0 (X11; Ubuntu; Linux > x86_64; rv:10.0) Gecko/20100101 Firefox/10.0" What about SOGo's own log? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] error on sogo start libldap
On Mon, Feb 13, 2012 at 1:25 PM, wrote: > i've sogo installed on a centos6 > > Package sogo-1.3.11-1.centos6.x86_64 already installed and latest version > > but when i do : > service sogo start > > i have the following error : > > /usr/sbin/sogod: error while loading shared libraries: libldap-2.3.so.0: > cannot > open shared object file: No such file or directory > > and for sure i've no libldap-2.3.so.0 file on my host... I am running SOGo 1.3.11 on CentOS6 32bit without such problems. At least on my server the init script is called sogod and not sogo? Probably just a typo in your email? If you are using LDAP (and have LDAP configuration in your GNUstepDefaults file) then you most likely should have an LDAP library installed... For CentOS6 the LDAP library should be included in the openldap package. Do you have that installed? How did you install SOGo, did you use the yum repositry provided by Inverse for CentOS6? Yum should handle all dependencies AFAIK. Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Nokia Lumia 800 (Windows Phone 7) and SOGo calendar
Hello, Does anyone know a way to sync Windows Phone 7 based Nokia Lumia 800 with the SOGo calendar? AFAIK Windows Phone 7 does not have CalDAV support but it does support Google cal (over ActiveSync I think). At Funambol Downloads site there is "Windows Mobile (all) Source" available but I cannot find any documentation how one would work with that? And the only topic I found at the Funambol discussion area was one saying that Win Phone 7 isn't supported yet... Would it be possible to sync via SOGo <-> Google cal <-> Win Phone 7 ? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Nokia Lumia 800 (Windows Phone 7) and SOGo calendar
Hi, 2012/2/15 André Schild : >> >> There's a z-push script collection flying around. Maybe that would work. >> > Look in the z-push branch of the sogo repository. > Be aware that it requires much memory if you have a huge calendar (and/or > many reccuring items) Thanks for your suggestion. Are you referring with z-push branch to this: http://www.algepop.net/users/alge/sogo/z-push/ ? Looking at the README this does not seem to be production ready and newer Windows Phone seems to be totally untested. Would it be possible to sync SOGo with Google Calendar? As Windows Phone supports Google Calendar I could perhaps use this solution... Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] parseTimeZone Error
Hi Ben, On Tue, Feb 21, 2012 at 6:20 PM, Ben Luey wrote: > I've seen posts about this in the past, but not since the 1.3.12c release. I > upgraded my Debian Squeeze box from SOGo 1.3.11 to 1.3.12c. I ran the > (postgres) db upgrade script. Everything seems to be working (haven't done a This is the first time I hear that there is a db upgrade script for Postgres. I run CentOS6. Should I've ran something similar when upgrading from 1.3.11? Where can one find information about this (where did you)? > 2012-02-21 09:16:04.011 sogod[30569] parseTimeZone: cannot parse time > notation 'GMT' > 2012-02-21 09:16:04.011 sogod[30569] parseTimeZone: cannot parse time I see reports for this error msg even for 1.3.06: https://inverse.ca/sogo/lists/arc/users/2011-04/msg00174.html Don't know if its related or not. Have you tried recreating your user preferences (change timezone to something else and then back), I think it has helped for some TZ related problems in the past? Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] parseTimeZone Error
Hi, On Tue, Feb 21, 2012 at 10:10 PM, Ben wrote: > Take a look in (on debian at least) /usr/share/doc/sogo/ there is a > sql-update-1.3.11_to_1.3.12.sh script. It looks like it changes c_content > columns from varchar to text (not sure why) and adding c_id as the primary > key to the OCS sessions folder table. On CentOS6 I only see: [root@sogo ~]# updatedb [root@sogo ~]# locate sql-update /usr/share/doc/postgresql-8.4.9/html/contrib-dblink-build-sql-update.html /usr/share/doc/postgresql-8.4.9/html/sql-update.html /usr/share/doc/sogo-1.3.12c/sql-update-1.2.2_to_1.3.0-mysql.sh /usr/share/doc/sogo-1.3.12c/sql-update-1.2.2_to_1.3.0.sh /usr/share/doc/sogo-1.3.12c/sql-update-1.3.3_to_1.3.4-mysql.sh /usr/share/doc/sogo-1.3.12c/sql-update-1.3.3_to_1.3.4.sh /usr/share/doc/sogo-1.3.12c/sql-update-101_to_102.sh /usr/share/doc/sogo-1.3.12c/sql-update-20070724.sh /usr/share/doc/sogo-1.3.12c/sql-update-20070822.sh /usr/share/doc/sogo-1.3.12c/sql-update-20080303.sh So no sql-update-1.3.11_to_1.3.12.sh? And I would think that in the release notes there would be mentioned that one needs run an sql script while upgrading...? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] parseTimeZone Error
Hi, On Tue, Feb 21, 2012 at 10:44 PM, Nathanael Bettridge wrote: > There was some chatter on the list during release that apparently some > Ubuntu and Debian packages didn't include the scripts - Ludovic referred > people to > http://mtn.inverse.ca/revision/browse/235258efee8273e9b6d2822d3d5da125520631c7/Scripts > - though that's an old revision ID, the script hasn't changed :) > > However - I would guess Inverse fixed the missing packages in one of the > a/b/c versions - so it may be worth double-checking you're on the current > 1.3.12c version. I am not running Debian but CentOS6 with 1.3.12c. I assume I should run these scripts on CentOS as well? But where do I find them? As I reported earlier, there is no such script in /usr/share/doc/sogo-1.3.12c > As for the release notes, in Francis's original "ANN: SOGo v1.3.12 & > Thunderbird 10 compatibility" announcement: > > " > === Upgrading to v1.3.12 === > > Once you have updated and restarted SOGo, run the shell script > sql-update-1.3.11_to_1.3.12.sh or sql-update-1.3.11_to_1.3.12-mysql.sh (if > you use MySQL). > " It seems I've missed this... Best, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] What version of Funambol server is needed for sogo 1.3.12?
Hi, On Fri, Feb 24, 2012 at 9:49 AM, Alessio Cecchi wrote: > What version of funambol server is needed for sogo 1.3.12? In the > documentetion I read "8.7", this is the only supported version or the > minimum recommended version? First I tried funambol-10 and couldn't get it working. Then I followed the documentation and went with funambol-8.5.2 and it has been working fine, although my initial problems with version 10 could have been just because of some misconfiguration. I've used the installation for syncing Noka phones using their native SyncML and syncing Outlook with the latest Funambol Windows client. Although the connector I am using is funambol-sogo-1.0.9.s4j (I found the download link posted on this list, I think) and not the official version 1.0.8 available for download at http://www.sogo.nu/english/downloads/backend.html I have no experience with Blackberries though. Good luck :) Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] dependencies
Hi, On Mon, Feb 27, 2012 at 9:55 PM, John Marsetta wrote: > When I try to install sogo via yum, yum cannot detect memcache and httpd due > to both being installed via source. Do I therefore have to install sogo via > source or should I install via yum skipping dependencies? AFAIK you can try either, skipping dependencies is probably easier. But if you ask me, you are asking trouble replacing core packages with your own, as yum's dependency resolving will fail to work and you will not receive any security updates for those packages. Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] About using "Show Time as Free"
Hi, When adding an event in Sogo there is the option to set "Show Time as Free" If I set this for an event I do not see any change in the event color in the Sogo v2 UI, is this by design or a bug? Also when looking at the event data, this info is not included: BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 2.3.23//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Moscow X-LIC-LOCATION:Europe/Moscow BEGIN:STANDARD TZOFFSETFROM:+0300 TZOFFSETTO:+0300 TZNAME:MSK DTSTART:19700101T00 END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:4922-5A69EB00-1-375A0300 SUMMARY:test CLASS:PUBLIC CREATED:20180125T143430Z DTSTAMP:20180125T143430Z LAST-MODIFIED:20180125T143430Z DTSTART;TZID=Europe/Moscow:20180109T08 DTEND;TZID=Europe/Moscow:20180109T09 TRANSP:TRANSPARENT END:VEVENT END:VCALENDAR I would like to use this free/busy information outside Sogo, but I guess it is not possible to export it from Sogo events, or am I missing something here? Regards, Peter -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] About using "Show Time as Free"
Replying to myself: This was my own misunderstanding, I did not realise that the attribute TRANSP communicates exactly this information. So if TRANSP is TRANSPARENT then the time is free. If it is OPAQUE then it is busy. Regards, Peter On Thu, Jan 25, 2018 at 4:46 PM, Peter Peltonen wrote: > Hi, > > When adding an event in Sogo there is the option to set "Show Time as Free" > > If I set this for an event I do not see any change in the event color > in the Sogo v2 UI, is this by design or a bug? > > Also when looking at the event data, this info is not included: > > BEGIN:VCALENDAR > PRODID:-//Inverse inc./SOGo 2.3.23//EN > VERSION:2.0 > BEGIN:VTIMEZONE > TZID:Europe/Moscow > X-LIC-LOCATION:Europe/Moscow > BEGIN:STANDARD > TZOFFSETFROM:+0300 > TZOFFSETTO:+0300 > TZNAME:MSK > DTSTART:19700101T00 > END:STANDARD > END:VTIMEZONE > BEGIN:VEVENT > UID:4922-5A69EB00-1-375A0300 > SUMMARY:test > CLASS:PUBLIC > CREATED:20180125T143430Z > DTSTAMP:20180125T143430Z > LAST-MODIFIED:20180125T143430Z > DTSTART;TZID=Europe/Moscow:20180109T08 > DTEND;TZID=Europe/Moscow:20180109T09 > TRANSP:TRANSPARENT > END:VEVENT > END:VCALENDAR > > I would like to use this free/busy information outside Sogo, but I > guess it is not possible to export it from Sogo events, or am I > missing something here? > > Regards, > Peter -- users@sogo.nu https://inverse.ca/sogo/lists