gmane.comp.cms.opengroupware.sogo

Iphone & Timezone

Ben Luey — 2012-03-16T21:46:31

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

sogod process over 100% of CPU

Jérémy Guasco — 2012-02-23T10:21:23

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

Errors since SOGo 1.3.12c

Jérémy Guasco — 2012-02-23T09:47:19

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

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

Brian Lockwood — 2011-11-14T20:37:11

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_se

Apache configuration

Bambero — 2011-11-07T15:12:26

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

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

Billy Baker — 2011-08-04T10:36:25

I am away until August 15th.   If this is an urgent matter, please direct
your query to my very appreciated colleagues. (Gregg Montieth, David
Forsythe, or Kevin Eliuk)

Thanks,
Billy

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

Jérémy Guasco — 2011-08-04T10:27:15

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

Re Calendar after upgrade

Brian Lockwood — 2011-01-24T21:18:08

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/jkIBnfWJrzHfBNe6p/wvtYmv/m3< at >public.gmane.org in again.

Brian L

SRPMS gnustep ?!

Fabrice Durand — 2011-01-24T21:15:33

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

Re: Calendar after upgrade

Brian Lockwood — 2011-01-24T21:03:41

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.

Re Calendar after upgrade

Brian Lockwood — 2011-01-24T20:45:00

Each Calendar appears to have a quick tabel associated with the user
(sogobrianloc*0057ef807a8*_quick).
The problem is that the field c_category seems to have gone awol.
When I added an event to my staff calendar it seemed to fix that calendar
too.

Before I start adding fields to loads of calndar tables for my 2000 users,
any suggestions about whether this "fix" is conincidental
and not just a chance fix that reveals a deeper problem with my database or
sogo installation?

Brian L

Re Calendar after upgrade

Brian Lockwood — 2011-01-24T20:34:16

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.

Re calendar afrer upgrade

Brian Lockwood — 2011-01-24T20:17:42

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:
c

Calendar seems to have failed on upgrade

Brian Lockwood — 2011-01-24T18:49:41

I use SOgo for the school email system but wanted to expand use of the
calendar. Unfortunately it seems to have broken, probably since the 1.33
upgrade.
I get this kind of error in the sogo log (placed below this message).
When I upgraded, I ran a database upgrade script that came with the upgrade.
Mail and address books all seem fine for all users.

Any suggestions

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 !=

Autentication on IMAP only.

Simone Piccardi — 2011-01-14T18:44:16

Hi,

there is a way to have users defined and authenticated just on IMAP?

It's quite easy for both courier and dovecot to support many
authentication backend, not just using LDAP or a database. And also for
the database there are installation managed by different software (like
Postfixadmin) that have with different conventions of those used by SOGo.

Using directly to IMAP authentication (that you have to do anyway to
access mailbox) would leave total freedom on the way you could manage
user, so I'd like to use such a configuration, if it exists.

Regards
Simone

cache problems? || carddav sync with iPhone

Andreas Tylmann — 2011-01-14T17:39:14

I tried to get sogo syncing contacts with the iPhone over carddav. After 
several hours of not getting anything to work I decided to code my own 
syncer which works with activeSync. (iPhone does that quite well)

Because it had to be done very quickly I read/write the data directly 
from/into the mysql database.
Results are:
- Sync from sogo to iPhone works
- Syncing changes from iPhone to sogo works
- Adding contacts from iPhone doesn't work (data is written to the db 
but not shown in the sogo web frontend)

Is there any other storage mechanism except of the database? (i.e. any 
cache?)
Or are there any rules that must be regarded? (i.e. the vcard version, 
the name of the vcard (field c_name) or any fields that must be filled)

Any advice is highly appreciated, if necessarily I can provide more 
information about the syncing process.

On the other side would it also be enough if anybody could tell me how 
to get the iPhone syncing with carddav.

Thanks in advance,
Andreas Tylmann

Re: Funambol connector after upgrade

Brian Lockwood — 2011-01-07T14:45:43

Solved.

For the benefit of others I included this solution

Further examination of the ds-server log revealed the string below.

This indicated an issue with the Jsonsimple.jar

 The problem stemmed from having the incorrect or possibly broken

/opt/funambol/tools/tomcat/lib/json_simple.jar

The one I have now has a size of  14435, the previous one was smaller. I
probably just downloaded the wrong one.



java.lang.NoClassDefFoundError: org/json/simple/JSONObject
        at
ca.inverse.sogo.engine.source.SOGoSyncSource.beginSync(SOGoSyncSource.java:190)
        at
com.funambol.server.engine.Sync4jEngine.sync(Sync4jEngine.java:610)
        at
com.funambol.server.session.SyncSessionHandler.processModifications(SyncSessionHandler.java:1655)
        at
com.funambol.server.session.SyncSessionHandler.processSyncMessage(SyncSessionHandler.java:1499)
        at
com.funambol.server.session.SyncSessionHandler.processInitSyncMapMessage(SyncSessionHandler.java:960)
        at
com.funambol.server.session.SyncSessionHandl

Re: Funambol connector after upgrade

Brian Lockwood — 2011-01-07T10:17:50

In the pursuit of this "ever so nearly working" synchronisation, I dragged
out a Palm and tried synchronising that.
The Funambol connector on the Palm just says "synchronisation failed"

In the logs (/..../ds-server.log) I have
[2011-01-07 10:17:55,880] [funambol.transport.http] [INFO]
[50322F119240B9960F8671D66BE29727] [172.16.36.65] [] [] [] Requested
sessionId: 461C7BA1C321D2A3B4A538EFAAC2FDD8
[2011-01-07 10:17:55,880] [funambol.transport.http] [INFO]
[50322F119240B9960F8671D66BE29727] [172.16.36.65] [] [] [] Session
'461C7BA1C321D2A3B4A538EFAAC2FDD8' not found


Any suggestions?

Re: Funambol connector after upgrade

Brian Lockwood — 2011-01-06T18:21:31

Even more information

The ds-server log carries this from the login attempt from my Nokia. Some
edits marked by <.............>.

[2011-01-06 18:20:29,597] [funambol.engine.pipeline] [INFO] [4<......>9]
[<proxy ip address>] [IMEI:3<....>207] [brianlockwood] [] Output processing
stopped by com.funambol.foundation.synclet.BeanShellSynclet< at >1d1b44b[script=com/funambol/server/engine/pipeline/phones-support/bsh/NokiaS60out.bsh,header=user-agent,pattern=Nokia
SyncML HTTP Client|S60 SyncML HTTP Client] (reason: NokiaS60out Synclet
finished)


On 6 January 2011 16:27, Brian Lockwood <t100ss-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

Re: Funambol connector after upgrade

Brian Lockwood — 2011-01-06T16:27:03

Following on from yesterday I made some progress. One problem lay with my
firewall redirections. These tests are from inside the network.
By testing with the outlook 2003 client I have now reduced the problem to
the following in the log for the client. The key point being the error code
511. I left my mob at home today so will try with my Nokia client again this
evening. (GMT)

<Lots of pretty positive messages with words like success in it>

15:45:08 GMT +0:00 [ERROR] - Server Failure: server returned error code 511
15:45:08 GMT +0:00 [DEBUG] - ----------------------  END (mode "none")
----------------------
15:45:08 GMT +0:00 [DEBUG] - Error occurred in sync: code 3 = Server
Failure: server returned error code 511
15:45:08 GMT +0:00 [ERROR] - Error in syncing: Server Failure: server
returned error code 511
15:45:08 GMT +0:00 [INFO] -
============================================================
================   SYNCHRONIZATION REPORT   ================
=====================================================

Re: 404 Error when trying to access Web Interface

Stefan Fuhrberg — 2011-01-06T15:49:52

Got the Login Screen to work, proxy_http was not enabled in my apaches 
settings.

But it seems that there is no UI-Theme loaded.

Am 06.01.2011 14:25, schrieb Stefan Fuhrberg: