Re: [SOGo] SOGo database

2011-04-20 Thread Pascal Gienger
Am 21.04.11 07:40, schrieb Martin Rabl: @Pascal Gienger: Pascal, you work with a large SOGo-Installation, do you have any problems with the many tables? We use two Postgres instances: One locally on the SOGo system for the session table, and one in a central Postgres Server infrastructure to

Re: [SOGo] SOGo database

2011-04-20 Thread Martin Rabl
Hi, I was wondering, too. It is a little bit ... strange, in terms of common database design ;-) But it is easy to understand: Every table is a folder of an user. Contacts are folders, calendars are folders ... The current used folder for contacts or calendars you will find in the folder_info-

[SOGo] SOGo database

2011-04-20 Thread dkillen
I was wondering about the structure of SOGo's database. I am using MySQL, not that it is probably all that relevant to this question. Each user appears to have many tables generated for it. I was wondering if there is a finite set of tables that a single user is likely to have, or are these generat

[SOGo] Re: SOGo-Nightlies can't be installed!

2011-04-20 Thread Martin Lehmann
What about this bug? It's very easy to fix and until it's fixed the nightlies are unusable for CentOS/Redhat! See: http://inverse.ca/downloads/SOGo/CentOS5/nightly/x86_64/RPMS/ You've only to replace "libmemcached" in libmemcached.spec through "libmemcached3" or sometheing simular for version

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Martin Lehmann
I have the same question? Is this bug also fixed?! Am 20.04.2011 08:42, schrieb Heiner Markert: Hello, thank you for your work. Will Bug 633 http://www.sogo.nu/bugs/view.php?id=633 "Alarms aren't synced correctly. Conversion necessary! " also be addressed in this release? Best Regards, Heiner

Re: [SOGo] Configure Signature in Webmail

2011-04-20 Thread Pascal Gienger
Am 20.04.11 18:19, schrieb Ben Luey: Ok, I tried it and it works great for me. But some (most?) of my users don't get a link creating / editing the signature. It just shows "Signature: " with no text or link after it Easy trick: Change the language setting, save it, and change it back to your

[SOGo] Can't export targeted data from SOGo

2011-04-20 Thread bertrand.pujos
Hi all, We are using SOGo (actually v1.3.5a) since early 2010. One of its functions is to manage the occupation of some parts of the building, such as operating rooms for surgery, amphitheaters or meeting rooms. As we plan to install a Digital Media System (DMS) in the building, we're trying to ex

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Davide Bozzelli
On 4/20/11 10:08 AM, Comune di Cossato - Andrea Ferraris wrote: Thanks to enourmous crawd of people and flooding of replies, and maybe also googleing a bit more, I've found that such password, if not in hex, has to be translated in hex and so I did with xdd and now, finally, it doesn't work at a

[SOGo] SOGo with multiple mysql servers

2011-04-20 Thread Rahul Amaram
Hi, I would like to know if sogo supports multiple mysql servers. Essentially this is the requirement. A client of mine has his offices distributed across different cities. Is it possible that sogo be distributed so that even if the connectivity link at one of the offices is lost, users at tha

Re: [SOGo] Configure Signature in Webmail

2011-04-20 Thread Ben Luey
I've got SOGo 1.3.6 running on Debian Lenny. Maybe I missing something obvious, but how can a user set his/her signature? In the preferences window, there is a grayed out option for where to place the signature, but I can't find anything about setting the content of the signature. You have to s

Re: [SOGo] Unable To Create Public Calander

2011-04-20 Thread Phil Burnsworth
Thank you for the quick response. Do you happen to know if I were to install OpenChange and Sogo by hand would this be supported? Also do you happen to know when this functionality will be available in ZEG? Thanks Again, Phil 2011/4/20 André Schild > Am 20.04.2011 17:37, schrieb pmcr...@gmail.c

Re: [SOGo] Unable To Create Public Calander

2011-04-20 Thread André Schild
Am 20.04.2011 17:37, schrieb pmcr...@gmail.com: Hello, I am running ZEG appliance with Sogo and OpenChange. When I set up my Outlook client I have able to connect and authenticate, but under public folders there is no calendar. I have tried to copy the calendar from personal items and my opencha

[SOGo] Unable To Create Public Calander

2011-04-20 Thread pmcross
Hello, I am running ZEG appliance with Sogo and OpenChange. When I set up my Outlook client I have able to connect and authenticate, but under public folders there is no calendar. I have tried to copy the calendar from personal items and my openchange mailbox to the public folders, but when I do I

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 20/04/2011 14.57, Jeroen Dekkers ha scritto: > I also see that there is undocumented support for the "crypt" > algorithm which uses the libc crypt(), the same function as used for > /etc/shadow, which should make it possible to copy hashes unchanged > from /etc/shadow AFAICS. Thx. That's very

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Patrick Ben Koetter
* Ludovic Marcotte : > On 20/04/11 08:24, Patrick Ben Koetter wrote: > >Nope. That won't solve my problem. > Adjust the port/hostname values in SOGoOfficer.xml That did it. Thx! p@rick -- state of mind Digitale Kommunikation http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 8

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 20/04/2011 14.55, Ludovic Marcotte ha scritto: > On 20/04/11 08:03, Comune di Cossato - Andrea Ferraris wrote: >> The second field of /etc/shadow that is something like >> '$1$nxf2V.NT$thmaXnvSJAUjltyslUWUG/' > This password is salted ('nxf2V.NT' being the salt). SOGo's SQL-based > authenticatio

Re: [SOGo] Bad visualization with gb2312 charset

2011-04-20 Thread Alessio Fattorini
On 20/04/2011 14:48, Christian Mack wrote: For description see: http://en.wikipedia.org/wiki/GBK Thanks christian, it's obvously a configuration error of my customer but he has a lot of mail with this charset, and it make sogo unusable :-| -- users@sogo.nu https://inverse.ca/sogo/lists

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Jeroen Dekkers
At Wed, 20 Apr 2011 07:57:34 -0400, Ludovic Marcotte wrote: > > On 20/04/11 07:52, Martin Rabl wrote: > > Since when is md5 used for encrypting passwords in /etc/shadow?? > If the password string starts with $1$, it means it was MD5-encoded. > > My guess is that he strapped '$1$foobar' directly i

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Ludovic Marcotte
On 20/04/11 08:03, Comune di Cossato - Andrea Ferraris wrote: The second field of /etc/shadow that is something like '$1$nxf2V.NT$thmaXnvSJAUjltyslUWUG/' This password is salted ('nxf2V.NT' being the salt). SOGo's SQL-based authentication source doesn't yet support this. -- Ludovic Marcotte lm

Re: [SOGo] Bad visualization with gb2312 charset

2011-04-20 Thread Christian Mack
On 04/20/2011 02:14 PM, Alessio Fattorini wrote: > On 14/04/2011 16:01, Alessio Fattorini wrote: >> On 13/04/2011 13:58, Christian Mack wrote: >>> Hi >>> >>> I only had this if one part at least is in GBK encoding, either >>> Content-Type: text/plain; charset=x-gbk >> >> I have sync e-mail from a M

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Sorry for the [SPAM] tag of the previous messages, it wasn't intentional. Il 20/04/2011 13.52, Martin Rabl ha scritto: > Since when is md5 used for encrypting passwords in /etc/shadow?? I don't know exactely, maybe less than ten years (it's not only md5). > And: what do you want with this passwo

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Ludovic Marcotte
On 20/04/11 08:24, Patrick Ben Koetter wrote: Nope. That won't solve my problem. Adjust the port/hostname values in SOGoOfficer.xml -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfen

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Patrick Ben Koetter
* Ruud van Lent : > > My best guess is that you have to logout and login again on the android > client. That did the trick for me. Nope. That won't solve my problem. p@rick -- state of mind Digitale Kommunikation http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3

Re: [SPAM] Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 20/04/2011 13.57, Ludovic Marcotte ha scritto: > On 20/04/11 07:52, Martin Rabl wrote: >> Since when is md5 used for encrypting passwords in /etc/shadow?? > If the password string starts with $1$, it means it was MD5-encoded. > > My guess is that he strapped '$1$foobar' directly in the database

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Ruud van Lent
My best guess is that you have to logout and login again on the android client. That did the trick for me. regards, Ruud. On Wednesday, 20 April, 2011 14:07 CEST, André Schild wrote:   Am 20.04.2011 14:03, schrieb Patrick Ben Koetter: > * Ludovic Marcotte: >> On 20/04/11 03:39, Olivie

Re: [SOGo] Bad visualization with gb2312 charset

2011-04-20 Thread Alessio Fattorini
On 14/04/2011 16:01, Alessio Fattorini wrote: On 13/04/2011 13:58, Christian Mack wrote: Hi I only had this if one part at least is in GBK encoding, either Content-Type: text/plain; charset=x-gbk I have sync e-mail from a MS Exchange to sogo, i have a lot of e-mail with this charset, and I c

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread André Schild
Am 20.04.2011 14:03, schrieb Patrick Ben Koetter: * Ludovic Marcotte: On 20/04/11 03:39, Olivier Migeot wrote: Good news! What will the upgrade procedure look like? Just putting the new connector in place of the old one and restart Funambol? Or is there more to it? You have to modify ds-server

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 20/04/2011 13.34, Ludovic Marcotte ha scritto: > On 20/04/11 04:08, Comune di Cossato - Andrea Ferraris wrote: >>> INSERT INTO sogo_view VALUES ('alice', 'alice', 'linux-md5-password', >>> > 'Alice Thompson','alice-PV5Ro7/m...@public.gmane.org'); > Provide *exactly* what you're trying to do. We

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Patrick Ben Koetter
* Ludovic Marcotte : > On 20/04/11 03:39, Olivier Migeot wrote: > >Good news! What will the upgrade procedure look like? Just putting the > >new connector in place of the old one and restart Funambol? Or is > >there more to it? > You have to modify ds-server/install.properties if the filename > cha

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Ludovic Marcotte
On 20/04/11 07:52, Martin Rabl wrote: Since when is md5 used for encrypting passwords in /etc/shadow?? If the password string starts with $1$, it means it was MD5-encoded. My guess is that he strapped '$1$foobar' directly in the database without stripping the leading $1$. Regards, -- Ludovi

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Martin Rabl
Since when is md5 used for encrypting passwords in /etc/shadow?? And: what do you want with this passwords? Provide a single-login for your shell users at shell and SOGo? Thats not a quite good idea! If you want such a stuff, install a local ldap-server, configure linux PAM for using ldap and c

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Ludovic Marcotte
On 20/04/11 03:39, Olivier Migeot wrote: Good news! What will the upgrade procedure look like? Just putting the new connector in place of the old one and restart Funambol? Or is there more to it? You have to modify ds-server/install.properties if the filename changed for the file located in ds-s

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Ludovic Marcotte
On 20/04/11 04:08, Comune di Cossato - Andrea Ferraris wrote: INSERT INTO sogo_view VALUES ('alice', 'alice', 'linux-md5-password', > 'Alice Thompson','alice-PV5Ro7/m...@public.gmane.org'); Provide *exactly* what you're trying to do. We can't possibly guess what you put for 'linux-md5-password'

Re: [SPAM] Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 20/04/2011 12.53, Martin Rabl wrote: > Hi, Hi and thx for your reply. > > Am 19.04.2011 um 12:29 schrieb Comune di Cossato - Andrea Ferraris: >> I toke the Linux ones and put them in SOgo with psql like that: >> >> INSERT INTO sogo_view VALUES ('alice', 'alice', 'linux-md5-password', >> 'Alice

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Martin Rabl
Hi, Am 19.04.2011 um 12:29 schrieb Comune di Cossato - Andrea Ferraris: > I toke the Linux ones and put them in SOgo with psql like that: > > INSERT INTO sogo_view VALUES ('alice', 'alice', 'linux-md5-password', > 'Alice Thompson', 'alice-PV5Ro7/m...@public.gmane.org'); Read: http://www.postgres

[SOGo] 404 Error when user logins from web interface

2011-04-20 Thread d.borini
Hi all, i'm in trouble with a fresh installation of SOGo. I set up authentication agiainst LDAP (it works). I use MySQL DB. When i log into sogo from web interface I get this error: localhost - - [20/Apr/2011:12:41:35 GMT] "GET /SOGo/daniele HTTP/1.1" 404 36/0 0.014 - - 0 "daniele" is the user nam

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread André Schild
Am 20.04.2011 10:08, schrieb Comune di Cossato - Andrea Ferraris: Il 19/04/2011 12.29, Comune di Cossato - Andrea Ferraris ha scritto: After the warm welcome I received in the list with hundred of reply here and personnally to my question about *ERROR: relation "sogo_view" does not exist*, I'm a

Re: [SOGo] buggy MD5 in SOGoSigh?

2011-04-20 Thread Comune di Cossato - Andrea Ferraris
Il 19/04/2011 12.29, Comune di Cossato - Andrea Ferraris ha scritto: > After the warm welcome I received in the list with hundred of reply here > and personnally to my question about *ERROR: relation "sogo_view" does > not exist*, I'm again here full of love and hope. > > Now I'm trying to use the

Re: [SOGo] Configure Signature in Webmail

2011-04-20 Thread Christian Mack
Hi Ben On 04/19/2011 08:45 PM, Ben wrote: > I've got SOGo 1.3.6 running on Debian Lenny. Maybe I missing something > obvious, but how can a user set his/her signature? In the preferences > window, there is a grayed out option for where to place the signature, > but I can't find anything about sett

Re: [SOGo] Upcoming Funambol SOGo Connector release

2011-04-20 Thread Olivier Migeot
On Tue, Apr 19, 2011 at 2:54 PM, Ludovic Marcotte wrote: > Many months have passed since the release of the last Funambol SOGo > Connector and we're now ready to make a new release. Good news! What will the upgrade procedure look like? Just putting the new connector in place of the old one and r

Re: [SOGo] All configuration settings

2011-04-20 Thread Mark Adams
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf Regards, Mark On 20 Apr 2011, at 03:18, "Carsten Laun-De Lellis" wrote: > Hi all > > > > Does anybody know if there is a list with all configuration variables and > settings for SOGO? > > > > I would appreciate any link. >