Ben Luey | 16 Mar 2012 22:46
Favicon

Iphone & Timezone

I'm having a timezone issue with an iPhone user (iphone 3, ios 4 I 
think) accessing their calendar via caldav. I'm wondering if this is a 
misconfiguration or an apple bug and if other people are seeing this too:

When the user gets an external (ical via email) invite to an event that 
is hosted on a different timezone, everything works fine on T-bird and 
the web interface (shows, for example that the event is stored 2pm EST, 
and displays as being at 1pm Central). But on the iPhone (accessed via 
caldav), the event shows up as 2pm (not 1pm). I'm assuming everything is 
right in the db backend since sogo web and t-bird work right. Is this is 
bug with the iPhone? If the external invite is on the same timezone as 
we are, it works fine. Anyone else see this? Any work-arounds?

Thanks,

Ben

Jérémy Guasco | 23 Feb 2012 11:21
Picon

sogod process over 100% of CPU

Hello,

SOGo sometimes crashes (sogod process over 100% of CPU)
Here is the last line in the log file before crash:

localhost - - [22/Feb/2012:08:59:43 GMT] "REPORT /SOGo/dav/LoginHidden/Calendar/personal/ HTTP/1.1" 207 723233/223 13.006 4267621 83% 830M
Feb 22 08:59:43 sogod [11021]: |SOGo| terminating app, vMem size limit (1000 MB) has been reached (currently 1158 MB)

We only have 50 users on SOGo. It that normal to have a vMem size limit at 1200MB ?

Thanks
Jérémy Guasco | 23 Feb 2012 10:47
Picon

Errors since SOGo 1.3.12c

Hello,

We have the folowings errors with SOGo since we updated from 1.3.9 to 
1.3.12c

2012-02-22 08:19:23.600 sogod[9984] ERROR(-[NGBundleManager 
bundleWithPath:]): could not create bundle for path: 
'/usr/share/GNUstep/Libraries/gnustep-base/Versions/1.20/Resources/SSL.bundle'

2012-02-22 08:19:23.721 sogod[9986] ERROR(-[NSNull(misc) 
forwardInvocation:]): called selector lowercaseString on NSNull !

Feb 22 08:19:37 sogod [9986]: [ERROR] <0x0x1ebbbf0[GSCBufferString]> 
json parser: Object key string expected
Feb 22 08:19:37 sogod [9986]: [ERROR] <0x0x1ebbbf0[GSCBufferString]> 
original string is: {

Feb 22 08:34:08 sogod [10470]: [ERROR] 
<0x020B2DD0[SOGoAppointmentFolder]:LoginHidden_personal> DAV property 
'{urn:ietf:params:xml:ns:caldav}schedule-tag' has no matching SQL field, 
response could be incomplete

Could you please tell me more about them and how to fix it.

Thanks
Brian Lockwood | 14 Nov 2011 21:37
Picon

Restrict access to the Cyrus mailer in AD situation in a school

In business, naughty boys get sacked, in school you have to try and manage their behaviour.


The IT tech did the following which might be of interest to other school users of sogo

We need to be able to restrict users from email without blocking their AD access and hence stopping them logging in to any school computers at all.

we edited our saslauthd.conf to limit the login capability of naughty boys so that they cannot login to the cyrus and hence SOGo and/or squirrelmail.

Basically we added the requirement for users to be in an "Email" Security Group to have access.


####################################################################
# 14.11.2011
# Amended version of saslauthd.conf
# Now requires users to be in "Email" Security Group to have access
####################################################################
ldap_version: 3
ldap_servers: ldap://172.16.32.11:389/
ldap_auth_method: bind
ldap_bind_dn: CN=binduser,OU=Admins,DC=egglescliffe,DC=local
ldap_bind_pw: bindpassword
ldap_scope: sub
ldap_search_base: DC=egglescliffe,DC=local
ldap_filter: (&(sAMAccountName=%u)(memberOf=CN=Email,CN=Users,DC=egglescliffe,DC=local))
Bambero | 7 Nov 2011 16:12
Picon

Apache configuration

Hello

I have no SOGo.conf for Apache in my OpenBSD package.
So the first quastion is:
what are the minimal configuratiojn settings for virtualhost ?

Second quation:
Are there any problems to run sogo with chrooted apache ?

Regards,
Bambero
Jérémy Guasco | 4 Aug 2011 12:27
Picon

How can I synchronize multiple address books on my mobile device?

Hi all,

With Funambol, I can only sync my personnal address book.

Is that possible to sync the public address book or an other address book ?

Best regards

Jérémy

--

-- 
OpenGroupware.org SOGo
sogo@...
http://mail.opengroupware.org/mailman/listinfo/sogo

Brian Lockwood | 24 Jan 2011 22:18
Picon

Re Calendar after upgrade

I will definitely shut up after this post.

A new calendar appears to not inherit the issue. Checking in the database, the c_category field appears in the ...quick table.
I have checked and all my users appear to have this issue in their personal Calendar.

Either. I can run a sql job and add the extra fields(s) to the _quick tables. Bit of a big job and I have not managed to distinguish the calendar and contacts tables for each user yet.
They both end in _quick. Without advice from someone who knows the system I am loathe to try this.

OR. Somehow, export every calendar, delete it, remake the calendar, reimport.

Suggestions gratefully received when the emails from sogo-7882/jkIBnfWJrzHfBNe6gC/G2K4zDHf@public.gmane.org come in again.

Brian L

Fabrice Durand | 24 Jan 2011 22:15
Picon
Gravatar

SRPMS gnustep ?!

Hi,

I have just one question, why don't you use the gnustep-base and gnustep-make that come from the official centos release ?
I just installed a new server with centos 5.5 (on fedora i can follow all the release), but i have a conflict when i try to install sogo.
So i take the src.rpm of sope and sogo and i compil with the gnustep and gnustep-make that come from centos and it seems to work.

Don't you think that if you use the "official" gnustep pakage from centos the sogo rpm will be more "official" ?

Sorry for my english ;-)

Regards

Fabrice Durand



Brian Lockwood | 24 Jan 2011 22:03
Picon

Re: Calendar after upgrade

The field type appears to be varchar and since the names of catergories appear to be a single word I used varcahr(10).
As it is after 9pm. I will leave this till tomorrow.

Brian Lockwood | 24 Jan 2011 21:34
Picon

Re Calendar after upgrade

My posts on this topic are still not appearing?

I added a field c_category (int4) to sogobrianloc00117296d89_quick

Lo and behold, my personal calendar has reappeared.


Brian Lockwood | 24 Jan 2011 21:17
Picon

Re calendar afrer upgrade

Sorry this post is not in line. My previous post seems not to have appeared

In the sogo logs when I post an event I get messages like

Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0xaa479f8[GCSFolder]> -[GCSFolder fetchFields:

fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_uid,a.c_startdate,a.c_enddate FROM sogobrianloc00117296d89_quick a, sogobrianloc00117296d89 b WHERE ((c_component = 'vevent') AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0x9464da0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xac78c40[PostgreSQL72Channel]: connection=<0x0x943c1a0[PGConnection]:  connection=0x0xaa8efd8>>): ERROR:  column a.c_category does not exist

Jan 24 18:50:39 sogod [15291]: [ERROR] <0x0AA24B08[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
172.16.32.243 - - [24/Jan/2011:18:50:39 GMT] "POST /SOGo/so/brianlockwood/Calendar/eventsblocks?sd=20110123&ed=20110129&view=weekview HTTP/1.1" 200 64/0 0.014 - - 0

The event is actually in the database though

BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Inverse inc./SOGo 1.0//EN BEGIN:VEVENT UID:3BC4-4D3DCB80-39-441DDF00 SUMMARY:Test LOCATION:home CREATED:20110124T185659Z DTSTAMP:20110124T185659Z LAST-MODIFIED:20110124T185659Z BEGIN:VALARM TRIGGER;X-WEBSTATUS=triggered;VALUE=DURATION:-PT15M ACTION:DISPLAY END:VALARM DTSTART;TZID=/inverse.ca/20101018_1/Europe/London:20110124T190000 DTEND;TZID=/inverse.ca/20101018_1/Europe/London:20110124T200000 TRANSP:OPAQUE END:VEVENT BEGIN:VTIMEZONE TZID:/inverse.ca/20101018_1/Europe/London X-LIC-LOCATION:Europe/London BEGIN:DAYLIGHT TZOFFSETFROM:+0000 TZOFFSETTO:+0100 TZNAME:BST DTSTART:19700329T010000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0100 TZOFFSETTO:+0000 TZNAME:GMT DTSTART:19701025T020000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE END:VCALENDAR

Gmane