Re: SOGo nightly + Funambol

Hi Steve,
> EXCEPTION: <NSException: 0x85a2880> NAME:NSInvalidArgumentException
REASON:GSMutableString(instance) does not recognize removeObjectsInArray: INFO:(nil)
>   

Could it be that you defined SOGoMailListViewColumnsOrder as a string in 
your SOGo configuration?

W.

Re: SOGo nightly + Funambol

-------- Original-Nachricht --------
> Datum: Mon, 30 Nov 2009 19:16:56 -0500
> Von: Wolfgang Sourdeau <wsourdeau@...>
> An: sogo@...
> Betreff: Re: [SOGo] SOGo nightly + Funambol

> Hi Steve,
> > EXCEPTION: <NSException: 0x85a2880> NAME:NSInvalidArgumentException
> REASON:GSMutableString(instance) does not recognize removeObjectsInArray:
> INFO:(nil)
> >   
> 
> Could it be that you defined SOGoMailListViewColumnsOrder as a string in 
> your SOGo configuration?
> 
Yes. It's a string:
---------------
sogo <at> nyx ~ $ defaults -u sogo read sogod SOGoMailListViewColumnsOrder
sogod SOGoMailListViewColumnsOrder Flagged
sogo <at> nyx ~ $
---------------

If I check my file system for that option then I get this:
---------------
sogo <at> nyx ~ $ find /usr/GNUstep/ -name "*.plist" -exec sed -n "/^[\t
]*SOGoMailListViewColumnsOrder/,/;\n/p" "{}" ";" | sed -e :a -e '$!N;s/,\n[\t ]*/, /;ta' -e 'P;D' |
head -n 1
    SOGoMailListViewColumnsOrder = ( "Flagged", "Attachment", "Subject", "From", "Unread", "Date",
"Priority", "Size" );

BTS activities for Monday, November 30 2009

MySQL Table Structure HELP

Re: MySQL Table Structure HELP

-------- Original-Nachricht --------
> Datum: Tue, 1 Dec 2009 13:14:06 +0100
> Von: "Kiss Tamás" <littlet@...>
> An: sogo@...
> Betreff: [SOGo] MySQL Table Structure HELP

> Hello!
> 
Hello,

> I like use the SOGo in MySQL auth, but I don't know, what is the default
> table structure. How do I search it?
> 
it's described in the installation documentation on page 19:
http://www.scalableogo.org/files/docs/SOGo%20Installation%20Guide.pdf

Do you already have a database and table where you have your user data? If so then you could make just a view for
SOGo and reuse that data. You don't need to mirror the content for SOGo.

What do you normally use to manage your SMTP/IMAP/POP users? Any tool like Postfix.Admin or such? Can you
post the table structure of the table where you already have the user data? What version of MySQL are you using?

> Thank's: LittleT!
>
Steve
-- 
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser
--

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

Re: MySQL Table Structure HELP

Re: MySQL Table Structure HELP

-------- Original-Nachricht --------
> Datum: Tue, 1 Dec 2009 13:48:09 +0100
> Von: "Kiss Tamás" <littlet@...>
> An: sogo@...
> Betreff: Re: [SOGo] MySQL Table Structure HELP

> Hi!
> 
Hello,

> What do you normally use to manage your SMTP/IMAP/POP users? Any tool like
> > Postfix.Admin or such? Can you post the table structure of the table
> where
> > you already have the user data? What version of MySQL are you using?
> >
> 
> I use PostFix + Courier IMAP + Virtual Users from MySQL 5.0 in Debian
> Lenny
> system.
> 
> The Mail MySQL structure is the default.
> 
It might surprise you but there are users out there on the Internet that don't know what this default is, that
you use in MySQL on your Debian installation. Me included. If the information on page 19 of the
documentation is enough for you to craft the table or view for SOGo then you don't need to explain anything
about the structure you are using. If you need more help then you should be more detailed with your answers.

> Thank's : LittleT!
>
Steve
-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
--

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

Re: LDAP auth

I tryed it this Weekend..
ldapsearch works fine (plain over SSL)
but sogo login failed..

anyone know if sogo uses sasl when SSL encryption is enabled ?

toSpooky@... schrieb:
> Hi..
> 
> is there a way to configure SOGo to use simple LDAP auth over SSL ?
> 
> thx
> 

Re: LDAP auth

On Tue, 1 Dec 2009, Marco Smiatek wrote:

  Hello Marco,

> ldapsearch works fine (plain over SSL)
> but sogo login failed..
>
> anyone know if sogo uses sasl when SSL encryption is enabled ?
>
> toSpooky@... schrieb:
>> Hi..
>>
>> is there a way to configure SOGo to use simple LDAP auth over SSL ?

I'm using it without problem.
Here is my configuration:

 	SOGoUserSources = (
 	    {
 		CNFieldName = cn;
 		IDFieldName = uid;
 		IMAPHostFieldName = mailHost;
 		UIDFieldName = uid;
 		baseDN = "ou=users,ou=portal,ou=services,dc=zcu,dc=cz";
 		bindDN = "uid=#USER#,ou=users,ou=portal,ou=services,dc=zcu,dc=cz";
 		bindPassword = #PASSWORD#;
 		canAuthenticate = YES;
 		displayName = = "Shared Addresses";
 		encryption = SSL;
 		hostname = ldap.zcu.cz;
 		id = shared;
 		isAddressBook = YES;
 		port = 637;
 		type = ldap;
 	    }
 	);

You need to have your CA certificate in your system cert directory.

Best regards,

  Milos

Re: LDAP auth

Hi Marco,

You need to make sure that your certificate is a valid one, or that 
libldap is configured to ignore the certificate validity. You need to 
edit your ldap.conf for that.

W.