Aw: [SOGo] Thunderbird 102 support

[John Bieling]

Whoever is going to work on the update, please be aware of the switch from a flat property bag to a vCard storage:

Changes to the WebExtension API:
https://webextension-api.thunderbird.net/en/102/how-to/contacts.html

Description of the core change:
https://developer.thunderbird.net/thunderbird-development/codebase-overview/address-book#transition-to-vcard-storage

The new address book looks like so:


 

I assume none of the old overlays will apply to the new UI.

Thunderbirds auto discover capabilities for CardDAV did improve, so maybe Thunderbird itself is working for you already and there is not much missing anymore.

John



 
 

Gesendet: Dienstag, 28. Juni 2022 um 14:05 Uhr
Von: "Christian Naumer (c...@brain-biotech.de)" 
An: users@sogo.nu
Betreff: Re: [SOGo] Thunderbird 102 support

Am 28.06.22 um 09:46 schrieb c3...@mail77.eu:
> I'm not working for Alinto, the company which takes over maintenance of
> SOGo. However, I've talked to a sales representative some months ago as
> we were inquiring for a support license, and they told me that they are
> relocating the development of SOGo (server) to France, and would
> continue development. We didn't talk about the sogo-connector
> specifically though. Do you have specific indications that they will
> stop development of sogo-connector? It would be a pity, especially
> because TB is getting a major overhaul since about 2 years.

No. No specific indications. However their product is:

"SOGomail by Alinto"
Powerful business-class mail Server for organisations that are looking
for a proven European alternative.

And I don't see any indication that they will support Thunderbird. Come
to that support from Inverse was not really enthusiastic in the last
release.

As mentioned our best bet is to work to get most of this into TB itself
or a lightweight addon.


Regards

Christian

--
Dr. Christian Naumer
Vice President
Unit Head Bioprocess Development

BRAIN Biotech AG
Darmstaedter Str. 34-36
64673 Zwingenberg, Germany

T: +49 6251 9331-30
F: +49 6251 9331-11

c...@brain-biotech.com
www.brain-biotech.com

Follow @BRAINbiotech on Twitter: https://twitter.com/BRAINbiotech
Follow @BRAIN Biotech AG on LinkedIn: https://www.linkedin.com/company/brainbiotech

Sitz der Gesellschaft: Zwingenberg | Bergstrasse
Registergericht AG Darmstadt | HRB 24758
Vorstand: Adriaan Moelker (Vorstandsvorsitzender) | Lukas Linnig
Aufsichtsratsvorsitzender: Dr. Georg Kellinghusen
--
users@sogo.nu
https://inverse.ca/sogo/lists



-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird 102 support

[John Bieling]

Whoever is going to work on the update, please be aware of the switch
from a flat property bag to a vCard storage:

Changes to the WebExtension API:
https://webextension-api.thunderbird.net/en/102/how-to/contacts.html

Description of the core change:
https://developer.thunderbird.net/thunderbird-development/codebase-overview/address-book#transition-to-vcard-storage

The new address book looks like so:



I assume none of the old overlays will apply to the new UI.

John


On 21.06.2022 11:30, Fabio Ciuffani (fabio.ciuff...@gmail.com) wrote:

Hi,

In February, Lukas Wringer asked about a SOGo Connector update
supporting the next Thunderbird release but got no answer. Thunderbird
102 will probably be released at the end of the month and we have lots
of users needing the connector. Could you please tell us if a connector
update is planned in the near future ?

Thank you,

Fabio


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird Status

[John Bieling]

If you have error reports regarding Thunderbird CardDAV, than it would be 
beneficial to file a bug, so they can improve. I don't think they know...

John

> Am 13.01.2021 um 19:24 schrieb Lukas Wringer 
> (lukas.wrin...@rz.uni-augsburg.de) :
> 
> Hi,
> 
> I think it was just to early to use the MZLA/Mozilla integration of CardDav. 
> I tried it without the plugin (in 78*) and it was just garbage (it is still 
> on proof-of-concept level imho). Maybe we just have to skip 78 for good...
> 
> I think the only way for even 86 (or whatever will be the next final) to work 
> properly (with lists, read-only address books, and so on) would be if SOGo 
> and MZLA could work together on this.
> 
> Although on Beta 85 CardDav is enabled by default...
> 
> greetings, Lukas
> 
>> Am 13.01.21 um 18:00 schrieb Frank Pauxberger (fr...@pauxberger.de):
>> Hi Christian,
>> I have started with SOGo some time back in 2011 and still love it after 
>> about 10 years. It does everything I need and look for and I keep 
>> recommending it! Great work once more and once again!!
>> This time though I have to admit I am slightly disappointed on whatever 
>> happens around the Plugin for TB78. I have tested it over and over again 
>> with varying results, always using the latest versions of the SW required. 
>> And with various comments here in the mailing list.
>> But I fully agree, it is not production ready.
>> So for now I stay on TB68 in Prod and have a test instance with TB78 using 
>> TbSync/provider for CalDAV and CardDAV/Category Manager. That is sort of ok 
>> but nothing I would recommend in larger scenarios. I am really (really 
>> really, Ludovic) looking forward to having a reliably working SOGo Connector 
>> for Thunderbird 78.
>> What is the bottle neck?
>> Kind regards
>> Frank
>>  Original-Message 
>> Subject: [SOGo] Thunderbird Status
>> From: Cn 
>> To: Users 
>> CC:
>> Date:  Mittwoch, 13. Jan. 2021, 14:09 (MN +0100)
>>> Hello all,
>>> I wanted to ask what the current plan/status is of the TB Plugin for 78. It 
>>> is not really ready for production yet.
>>> So what are the plans?
>>> Is there a timeline?
>>> What are other doing in the meantime? Stay on 68 ?
>>> 
>>> Regards
>>> 
>>> 
>>> Christian
>> -- 
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
> 
> -- 
> Lukas Wringer
> 
> Universität Augsburg
> Rechenzentrum
> Service & Support
> 86135 Augsburg
> 

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird 78

[John Bieling]

Hi,

Maybe you could publish this at
https://developer.thunderbird.net/add-ons/about-add-ons
so that also other addon developers can get aware of this.


It is still a draft and was heavily modified in the last two days. We
will send this information to all add-on developers (who are registered
on ATN) this Friday.

It will be added to DTN as soon as the related API for bootstrap
extensions is done.

John

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird 78

[John Bieling]

Maybe this can help:

https://github.com/thundernest/addon-developer-support/wiki/Using-the-WindowListener-API-to-convert-a-Legacy-Overlay-WebExtension-into-a-MailExtension-for-Thunderbird-78

I will add the options section today or tomorrow. There is also an API
for legacy bootstrapped extension, but if I remember correct, sogo was a
legacy overlay extension, but have not looked lately. The guide for the
bootstrapped API will need a few more days.

This is intended to get compatible with TB78 with minimal efforts, but
of course it is not a long term solution. After the initial update, we
will send out little update-steps to get rid of the legacy parts one by one.

John


On 22.07.2020 13:48, Ludovic Marcotte (lmarco...@inverse.ca) wrote:

On 2020-07-13 10:20 a.m., Christian Naumer (c...@brain-biotech.de) wrote:


Hello you all,
ist there any time line for supporting TB78 with the SOGo-Plugins?
Currently they are not working in the Beta. Has someone else tried this?


I've spent some time on this yesterday and it'll be quite complex to
adjust the extensions so they work with Thunderbird 78. Most of the
difficulties is coming from the GUI parts that we were changing using
overlays.

It'll take a few weeks before we are done.

Thanks,


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Connector for Thunderbird 68 ?

[John Bieling]

Hi Boris,

Nextcloud docs suggest to use TbSync instead of the SOGo Connector.

https://docs.nextcloud.com/server/latest/user_manual/pim/sync_thunderbird.html

TbSync:

https://addons.thunderbird.net/addon/tbsync/

John

> Am 09.02.2020 um 12:18 schrieb Boris (bo...@cation.de) :
> 
> Hej all,
> 
> 
> I was using the SoGO connector to sync the addressbook of Thunderbird
> with NextCloud (running all on Debian Linux).
> Great software - absolutely reliable! Thanks for this!
> 
> Since Thunderbird changes the API (with V 68) the connector doesn't work
> any longer.
> Will there be a new connector - hopefully in the official
> Thunderbird-AddOn-Repositories?
> 
> Thanks and regards,
> 
> Boris
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] outlook 365 / activesync

[John Bieling]

Office 365 still supports ActiveSync. Nothing changed there. The
Administrator of a Office 365 tenant however is able to disable EAS for
his instance. So that could have happened.

John




On 13.11.2019 13:26, mj (li...@merit.unu.edu) wrote:

Hi,

Recently a user came to us, asking dor help configuring her outlook
with SOGo / ActiveSync.

Turned out that our instructions no longer work for office365, as they
seem to have removed ActiveSync support..? (or at least the
configuration part of it?)

Are we missing something, or is this really the case? And of course
next: how do you guys here solve this new problem..?

Is this the way to go: https://caldavsynchronizer.org/ combined with
imap..?

Or is there a way to make outlook365 *still* do regular ActiveSync?

Life was so good when SOGo started supporting ActiveSync as a method
to access mails and calendar like exchange...

MJ

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird 68

[John Bieling]

TbSync supports NextCloud (or any CalDAV/CardDAV server), so that could
be an alternative.

John




On 07.11.2019 10:12, olvy prad (olivy.p...@yahoo.com) wrote:

Hi Christian

Currently, Nextcloud synchronization is not supported by SOGO connector.
Is it planned or definitively not ?


Regards
Olivier
Le jeudi 7 novembre 2019 à 10:07:53 UTC+1, Christian Mack
 a écrit :


Hello

Inverse developers are aware of the signing of add-ons in the future.
Configuration within Thunderbird is planned.
It is not there, because noone implemented its visual interface.
The pressing problem right now was to get it working again.

I do not know the priority that has.
Therefore no estimate from me on when this gets implemented.


Kind regards,
Christian Mack

Am 30.10.19 um 17:27 schrieb Stefan Klatt
(stefan.kl...@cac-netzwerk.de ):
> Hi Christian,
>
> To customize the could be a problem if Thunderbird checks the signature
> (now or probably in near future).
> Why it isn't possible to use a external configuration, like a file or a
> Thunderbird configuration option?
>
> Regards
>
> Stefan
>
> Am 28.10.2019 um 16:45 schrieb Christian Mack
> (christian.m...@uni-konstanz.de
):
>> Hello
>>
>> Am 23.10.19 um 09:41 schrieb olvy prad (olivy.p...@yahoo.com
):
>>> I'm using your plugin with nextcloud calddav/cardav server . so,is
it the same thing to create custom/mysite ?
>>> and I have an error "Plugin is not compatible with Thunderbir
68.1.1" whith the master branch...
>>>
>> CalDAV is handled by Lightning in Thunderbird.
>> It is used for synchronizing calendars with servers.
>> CardDAV is used by many backends for address book synchronization.
>> There is no built in support for cardDAV in Thunderbird.
>>
>> "SOGo Connector" is such a cardDAV implementation.
>> The "SOGo Connector" Add-On is currently under development, in order to
>> make it run under Thunderbird 68+.
>> That is not easy, as multiple APIs have changed.
>> Additionally the sandboxing of Add-Ons was introduced.
>> Because of that Add-Ons are no longer able to communicate directly with
>> each other.
>> Therefore "SOGo Connector" is now merged with "SOGo Integrator".
>> "SOGo Integrator" adds some functionality like calendar and addressbook
>> auto discovering, managing of share privileges and synchronizing of
>> calendar and addressbook colors.
>> "SOGo Integrator" has to be manually customized before
installation, and
>> only supports SOGo as backend.
>> That is the reason, that the current implementation will only run with
>> SOGo as backend.
>>
>>
>>
>> Kind regards,
>> Christian Mack
>>
>


--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416
--
users@sogo.nu
https://inverse.ca/sogo/lists

--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Technical issue with SOGo CardDAV server PROPFIND request

[John Bieling]

Hi,

I am trying to get all resources available for a given user by doing a 
few PROPFIND requests. One includes a request for group-membership and I 
get back a principal URL, but when I PROPFIND that URL, I get a 403.


Does anybody know what I am doing wrong? Here is a complete log of what 
is send and received:


** Sun Feb 10 2019 15:41:22 GMT+0100 (CET) **
[URL Request #1] : https://***/SOGo/dav/user1

** Sun Feb 10 2019 15:41:23 GMT+0100 (CET) **
[REQUEST] : PROPFIND


  
    
    
  


** Sun Feb 10 2019 15:41:23 GMT+0100 (CET) **
[RESPONSE] : 207


  
    /SOGo/dav/user1
    
  HTTP/1.1 200 OK
  
    
  /SOGo/dav/user1/Contacts/
    
    
  xmlns:D="DAV:">/SOGo/dav/user2/calendar-proxy-write/

    
  
    
  


** Sun Feb 10 2019 15:41:23 GMT+0100 (CET) **
[URL Request #1] : https://***/SOGo/dav/user2/calendar-proxy-write/

** Sun Feb 10 2019 15:41:23 GMT+0100 (CET) **
[REQUEST] : PROPFIND


  
    
    
  


** Sun Feb 10 2019 15:41:23 GMT+0100 (CET) **
[RESPONSE] : 403

http://www.w3.org/1999/xhtml;>
An error occurred during object publishingtried to 
access private object (0x0x55bfc2b12b90, 
SoClass=SOGoCalendarProxy)



Thanks for your time,
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Thunderbird Plugin

[John Bieling]

I just want to shed some light onto "TbSync" which has been mentioned in 
this thread.


Until a few weeks ago, it was a plain ActiveSync AddOn, but with the 
sogo-connectors missing support for Thunderbird 60, one of my clients 
asked me to add CardDAV support. So I did. Last week its description 
changed and is now officially supporting CardDAV.


I think users of the SOGo groupware should stick to the 
sogo-connector/integrator, because TbSync is "just" following the 
sabre/dav specs, but does not do any of the special stuff for SOGo. It 
does however support shared resources with read-only rights.


TbSync works a bit different from sogo-connector: Users do not need to 
know the URLs, TbSync uses the discovery service to find all address 
books and calendars and lets the user select which one to sync via UI.


The CalDAV sync is delegated to lightning, which means it has the same 
problems when it comes to syncing calendars of different users on the 
same server. My CardDAV implementation does not have a problem with that.


Best regards,
John





Am 03.09.2018 um 14:31 schrieb Marcio Vogel Merlone dos Santos 
(marcio.merl...@a1.ind.br):

Em 01/09/2018 05:07, "Kai-Uwe Rommel" (kai-uwe.rom...@ars.de) escreveu:


users-requ...@sogo.nu wrote on 30.08.2018 16:41:49:
> Plain calendar sync isn't the issue here as (at least)
> CalDAV sync is built into Lightning anyways.

Given that with the built-in Lightning and with CardBook I can also
work with SOGo's calendar and contacts, I see no advantage in the
SOGo connector. In both cases, I need to manually add the SOGo
calendar and contacts to Thunderbird with the SOGo CalDAV and CardDAV
URLs and account data. 


Odd. You should not need anything but the password with SOGo.


Or did I miss something about the SOGo
connector? 

I think so. Even in a small company the automation provided with SOGo 
connector is a must.

If you are just an end user and not admin, you are right.

--
*Marcio Merlone*
--
users@sogo.nu
https://inverse.ca/sogo/lists


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SQL errors on funambol sync, what am i doing wrong?

[John Bieling]

I forgot to mention, that this is a multidomain setup.

Maybe there is something wrong in the funambol connector so that 
identifying the desired user fails in a multidomain setup, returning 
null?


Any idea? Is it a real bug?

Thanks
John



Am 23.01.2013 19:28, schrieb John Bieling:

Hi,

I am failing on the last step of my sogo setup: Funambol Sync.

I followed the installation guide:
- standard sogo install with PostgreSQL 8.4
- standard Funambol 10.0.0.3 bundle setup (using 
postgresql-9.2-1002.jdbc4.jar + json_simple_1.1.jar)

- sogo-card SyncSource setup
- SOGoOfficer changed to inverse
- FunV10 android app

What I changed from the standard setup:
- only DS Server is started,
- CTP, Inbox Listener and PIM Listener are NOT started

With my andoid device and the FunV10 app I can connect (using my sogo 
username + password) and sync ok, no error on the phone.


However the new contacts do not show up in my sogo account. I get a 
few different kind of errors in the postgresql log:



2013-01-23 18:47:34 CET ERROR:  relation null_quick does not exist 
at character 20
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_name FROM null_quick 
WHERE c_component = 'vcard'


2013-01-23 18:47:34 CET ERROR:  syntax error at or near null at 
character 39
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_cn, c_mail, c_o, c_name 
FROM null


2013-01-23 18:47:36 CET ERROR:  syntax error at or near null at 
character 13
2013-01-23 18:47:36 CET STATEMENT:  INSERT INTO null (c_name, 
c_content, c_creationdate, c_lastmodified, c_version) VALUES 
($1,$2,$3,$4,$5)


2013-01-23 18:47:36 CET ERROR:  current transaction is aborted, 
commands ignored until end of transaction block
2013-01-23 18:47:36 CET STATEMENT:  SELECT c_name FROM null_quick 
WHERE c_name = $1


2013-01-23 18:54:47 CET ERROR:  function upper(bigint) does not exist 
at character 45
2013-01-23 18:54:47 CET HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts.
2013-01-23 18:54:47 CET STATEMENT:  select count(*) from 
fnbl_last_sync where ( UPPER(principal) = upper($1))


Any Idea? Thanks for your help.

John




--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo not releasing tcp spockets?

[John Bieling]

Glad I could help, will this be fixed in 2.0.4? Or is it already fixed 
in the current codebase (git clone...)?


Thanks
John

Am 23.01.2013 00:50, schrieb Jean Raby:

On 13-01-18 1:41 PM, John Bieling wrote:

I investigated the problem further. I dumped the output of netstat
before and after I restarted sogo. Before the restart (running 12 h) I
had 280 conns (steadily increasing all day), after the restart I was
back to 40.

The diff shows that almost all of the persistent connections, which only
go away by restarting sogo are somehow *ldap* related: (VERBUNDEN =
ESTABLISHED):

 tcp0  0 localhost.localdom:ldap localhost.localdo:53381
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51077
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:54146
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34959
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:50318
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51081
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34964
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36243
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41362
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36240
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49309
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:56988
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44452
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44451
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:39330
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49312
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46261
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:47551
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:60351
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41661
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:57017
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46264
VERBUNDEN
...


These ldap conns are used to authenticate any sogo related http/webdav
request with the local ldap server, right? Why do they stay?

Is it possible to tell ldap to release these connections after a 
timeout?

Is it possible to switch to a socket-based-communictaion?


Thanks for pointing that out, there was a leak in the error path of 
the password checking code.


Now fixed: 
https://github.com/inverse-inc/sogo/commit/9e38c5060ab161704e86398475f36aca105d2404




Thanks for your time
John






On 01/17/2013 12:04 PM, John Bieling wrote:

My sogo installation is running on a virtuozo system (server4you.com)
and I have a limit of 1200 numtcpsock. If I sync my adressbook via
thunderbird, I can see via

cat /proc/user_beancounters

that the number of held numtcpsock is going up. But it is not going
down again, it just stays there. Now if my server runs for about a
day, I reach the limit, which will disconnect my server from the
outside, since no new connections can be established.

Before reaching the limit, I can ssh into the maschine and restart
sogo and the numtcpsock value drops from about 1000 back to 50
(which is normal). This is now automated by a cron job, but why is
that happening?

Has someone else experienced this?

In my sogo profile I have setup an extra IMAP account (gmx.de) and
when I click through the gmx folders in the sogo web-interface, for
each folder-click the numtcpsock value increases by 1 or 2 as well.
And is not going back down.

Any Idea? The incomming connections vor CardDAV and CalDAV are http
request, right? Can I tweak something there?

Thanks
John







--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SQL errors on funambol sync, what am i doing wrong?

[John Bieling]

Hi,

I am failing on the last step of my sogo setup: Funambol Sync.

I followed the installation guide:
- standard sogo install with PostgreSQL 8.4
- standard Funambol 10.0.0.3 bundle setup (using 
postgresql-9.2-1002.jdbc4.jar + json_simple_1.1.jar)

- sogo-card SyncSource setup
- SOGoOfficer changed to inverse
- FunV10 android app

What I changed from the standard setup:
- only DS Server is started,
- CTP, Inbox Listener and PIM Listener are NOT started

With my andoid device and the FunV10 app I can connect (using my sogo 
username + password) and sync ok, no error on the phone.


However the new contacts do not show up in my sogo account. I get a few 
different kind of errors in the postgresql log:



2013-01-23 18:47:34 CET ERROR:  relation null_quick does not exist at 
character 20
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_name FROM null_quick WHERE 
c_component = 'vcard'


2013-01-23 18:47:34 CET ERROR:  syntax error at or near null at 
character 39
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_cn, c_mail, c_o, c_name 
FROM null


2013-01-23 18:47:36 CET ERROR:  syntax error at or near null at 
character 13
2013-01-23 18:47:36 CET STATEMENT:  INSERT INTO null (c_name, c_content, 
c_creationdate, c_lastmodified, c_version) VALUES ($1,$2,$3,$4,$5)


2013-01-23 18:47:36 CET ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
2013-01-23 18:47:36 CET STATEMENT:  SELECT c_name FROM null_quick WHERE 
c_name = $1


2013-01-23 18:54:47 CET ERROR:  function upper(bigint) does not exist at 
character 45
2013-01-23 18:54:47 CET HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts.
2013-01-23 18:54:47 CET STATEMENT:  select count(*) from fnbl_last_sync 
where ( UPPER(principal) = upper($1))


Any Idea? Thanks for your help.

John


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGo not releasing tcp spockets?

[John Bieling]

I investigated the problem further. I dumped the output of netstat 
before and after I restarted sogo. Before the restart (running 12 h) I 
had 280 conns (steadily increasing all day), after the restart I was 
back to 40.


The diff shows that almost all of the persistent connections, which only 
go away by restarting sogo are somehow *ldap* related: (VERBUNDEN = 
ESTABLISHED):


 tcp0  0 localhost.localdom:ldap localhost.localdo:53381 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51077 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:54146 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34959 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:50318 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51081 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34964 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36243 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41362 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36240 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49309 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:56988 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44452 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44451 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:39330 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49312 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46261 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:47551 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:60351 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41661 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:57017 
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46264 
VERBUNDEN

...


These ldap conns are used to authenticate any sogo related http/webdav 
request with the local ldap server, right? Why do they stay?


Is it possible to tell ldap to release these connections after a timeout?
Is it possible to switch to a socket-based-communictaion?


Thanks for your time
John






On 01/17/2013 12:04 PM, John Bieling wrote:
My sogo installation is running on a virtuozo system (server4you.com) 
and I have a limit of 1200 numtcpsock. If I sync my adressbook via 
thunderbird, I can see via


cat /proc/user_beancounters

that the number of held numtcpsock is going up. But it is not going 
down again, it just stays there. Now if my server runs for about a 
day, I reach the limit, which will disconnect my server from the 
outside, since no new connections can be established.


Before reaching the limit, I can ssh into the maschine and restart 
sogo and the numtcpsock value drops from about 1000 back to 50 
(which is normal). This is now automated by a cron job, but why is 
that happening?


Has someone else experienced this?

In my sogo profile I have setup an extra IMAP account (gmx.de) and 
when I click through the gmx folders in the sogo web-interface, for 
each folder-click the numtcpsock value increases by 1 or 2 as well. 
And is not going back down.


Any Idea? The incomming connections vor CardDAV and CalDAV are http 
request, right? Can I tweak something there?


Thanks
John


--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] sogo-tool does not backup contacts and agenda?

[John Bieling]

HI,

I just tried to backup my users using sogo-tool. The created backup 
files do not contain any contact or agenda data, is this as expected or 
did I do something wrong?


I called

sogo-tool backup test_backup ALL

If this is as expected, how do I backup the contacts of my users?

Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGo not releasing tcp spockets?

[John Bieling]

My sogo installation is running on a virtuozo system (server4you.com) 
and I have a limit of 1200 numtcpsock. If I sync my adressbook via 
thunderbird, I can see via


cat /proc/user_beancounters

that the number of held numtcpsock is going up. But it is not going down 
again, it just stays there. Now if my server runs for about a day, I 
reach the limit, which will disconnect my server from the outside, 
since no new connections can be established.


Before reaching the limit, I can ssh into the maschine and restart sogo 
and the numtcpsock value drops from about 1000 back to 50 (which is 
normal). This is now automated by a cron job, but why is that happening?


Has someone else experienced this?

In my sogo profile I have setup an extra IMAP account (gmx.de) and when 
I click through the gmx folders in the sogo web-interface, for each 
folder-click the numtcpsock value increases by 1 or 2 as well. And is 
not going back down.


Any Idea? The incomming connections vor CardDAV and CalDAV are http 
request, right? Can I tweak something there?


Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Which jdbc driver for postgreSQL 8.4?

[John Bieling]

Hi,

i am trying to install funambol v10(bundled) using postgreSQL 8.4 (which is 
also used for sogo). I am stuck at the step Download the preferred JDBC 
driver. 

Do I need JDBC3 or JDBC4?
Do I need the version which supports postgreSQL 8.4 or can I use the latest 
one, supporting 9.2, which will also support 9.2?

Thanks for your help,
John
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SMTP AUTH email address as username

[John Bieling]

Am 10.01.2013 11:15, schrieb Julien Escario:

Le 12/12/2012 15:04, Julien Escario a écrit :

Hello,
We recently upgraded to sogo v2. Before that, our sogo was sending
e-mail via a smarthost with a whitelist.
We would like to change to use SMTP AUTH, far more secure.

But when trying to send a mail, Sogo authenticate with the username and
our server ask for the e-mil address as username. Is there a way to
change this ? Like the SOGoForceIMAPLoginWithEmail for IMAP.


Nobody have a clue about this ?

Which ldap entry is used by sogo to authenticate against an external 
SMTP server ?


Right now, sogo is trying to authenticate with 'sogotry' and I would 
like it to do it with 'sogo...@domain.com'.


Using the embedded postfix as an authenticated smart relay isn't an 
acceptable solution.


Regards,
Julien


I am working on a patch for that

http://www.sogo.nu/bugs/view.php?id=2163

It is not entirely related to your question, but eventually It will 
allow to login with an email-address. Hope to get it into 2.0.4


John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] [JOB] SOGo Expert or new SOGo installation in OpenVZ for 1 domain needed urgent

[John Bieling]

Hi,

sudo vi /etc/apache2/conf.d/SOGo.conf

is not working?



I guess most of us need a how to changing the example.com 
http://example.com to a custom domain, it will be a meaningful ZEG.


Anyone had tried changing and successfully get it working?

Please share.

Thank you


On Monday, January 7, 2013, Olivier Bitsch wrote:

Hi,

I think this could be very usefull to provide the logfile, but
probably you got the same error than me. Are you using the latest
git version like me?

Olivier.


2013/1/6 eso...@newmidian.com javascript:_e({}, 'cvml',
'eso...@newmidian.com');

First of all I apologize if this message should not be posted
in this List. But
I have a spanish client who need an urgent installation of SOGo.

My work is select freelance teams or companies for IT clients
outsourcing. We
have a work of a SOGo installation in an OpenVZ VM for one
domain and 90
accounts that has given lot of problems. The team working in
it has given their
best, but have been stuck with problems of Panic in Samba4
when in Outlook they
try to login, synchronize and importing from Exchange 2007 .pst.

My client need the SOGo running in two days, so, he need a
real expert in
SOGo that could take a look in the system, talk with the
actual installer and
find where is the problem... or... directly make a fresh
install of SOGo.

As my client had the prevention of installing OpenVZ in the
server, if you have
a 100% tested and working SOGo OpenVz image, it should be as
easy as upload the
image to the server and configure with the new domain.

If the administrator of the list consider appropiate, I would
like to ask all
interested to contact me and I will put in contact with my
client to further
details.

Work should start this Monday January 7th. So we'll take a
very quick decision.

Thanks for your attention, and hope SOGo continue evolving.

Cordially

Ernesto Soler
eso...@newmidian.com javascript:_e({}, 'cvml',
'eso...@newmidian.com');
New Midian
--
users@sogo.nu javascript:_e({}, 'cvml', 'users@sogo.nu');
https://inverse.ca/sogo/lists




--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] [JOB] SOGo Expert or new SOGo installation in OpenVZ for 1 domain needed urgent

[John Bieling]

Hi,

if you are not familiare with th vi editor, you might try nano (if that 
is installed, i do not know)


sudo nano /etc/apache2/conf.d/SOGo.conf

to gain access to the system, login as user sogo with pasword sogo

John

Am 07.01.2013 09:06, schrieb John Bieling:

Hi,

sudo vi /etc/apache2/conf.d/SOGo.conf

is not working?



I guess most of us need a how to changing the example.com 
http://example.com to a custom domain, it will be a meaningful ZEG.


Anyone had tried changing and successfully get it working?

Please share.

Thank you


On Monday, January 7, 2013, Olivier Bitsch wrote:

Hi,

I think this could be very usefull to provide the logfile, but
probably you got the same error than me. Are you using the latest
git version like me?

Olivier.


2013/1/6 eso...@newmidian.com javascript:_e({}, 'cvml',
'eso...@newmidian.com');

First of all I apologize if this message should not be posted
in this List. But
I have a spanish client who need an urgent installation of SOGo.

My work is select freelance teams or companies for IT clients
outsourcing. We
have a work of a SOGo installation in an OpenVZ VM for one
domain and 90
accounts that has given lot of problems. The team working in
it has given their
best, but have been stuck with problems of Panic in Samba4
when in Outlook they
try to login, synchronize and importing from Exchange 2007 .pst.

My client need the SOGo running in two days, so, he need a
real expert in
SOGo that could take a look in the system, talk with the
actual installer and
find where is the problem... or... directly make a fresh
install of SOGo.

As my client had the prevention of installing OpenVZ in the
server, if you have
a 100% tested and working SOGo OpenVz image, it should be as
easy as upload the
image to the server and configure with the new domain.

If the administrator of the list consider appropiate, I would
like to ask all
interested to contact me and I will put in contact with my
client to further
details.

Work should start this Monday January 7th. So we'll take a
very quick decision.

Thanks for your attention, and hope SOGo continue evolving.

Cordially

Ernesto Soler
eso...@newmidian.com javascript:_e({}, 'cvml',
'eso...@newmidian.com');
New Midian
--
users@sogo.nu javascript:_e({}, 'cvml', 'users@sogo.nu');
https://inverse.ca/sogo/lists






--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Only the last line of SMTP answer is returned - so SOGo fails to see AUTH PLAIN - sending fails

[John Bieling]

On 01/06/2013 09:56 PM, John Bieling wrote:

Am 06.01.2013 20:09, schrieb Anselm Martin Hoffmeister:

Am 06.01.2013 16:45, schrieb John Bieling:

Am 06.01.2013 14:40, schrieb John Bieling:

Hi,

using sogo 2.0.3 with

sogod SOGoSMTPAuthenticationType PLAIN

enabled. This is the SMTP reply after EHLO with telnet

open smtp.wordlserver.net 25

220 mail01.worldserver.net ESMTP Speedbone Mailservice
EHLO sogoserver
250-mail01.worldserver.net
250-PIPELINING
250-SIZE 69730304
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN CRAM-MD5
250-AUTH=PLAIN LOGIN CRAM-MD5


This is not RFC compliant, if I understand the spec correctly (see 
http://tools.ietf.org/html/rfc5321 page 33). It seems some mailservers

send that AUTH=PLAIN to support old Outlook Express clients that need
this for authentication to work (cf. http://www.wogri.at/248.html?L=1 ).

It would by nice if SOGo went the extra mile to accept this
non-standard but obviously existant line. Being RFC compliant is not 
a bug, though :-)


BR
-AMH-


Can we do something about it? Can we patch the source, or will that 
only be done by inverse?


Are they reading this or do we have to ask/tell someone?

Thanks
John


If found the Bug-Report System and I found a simple fix for the problem.

http://www.sogo.nu/bugs/view.php?id=2161

Hope it will be used.

--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Multi-User Login not working reliably? Something broken?

[John Bieling]

1. Issue


If I use SOGoLoginDomains, the system authenticates the user against the 
selected domain, so entering info with password of domainB but selected domainA 
will result in an wrong password error. Good.

If I do not use SOGoLoginDomains, he will try both info accounts and match it by 
the password - and sometimes messes up (log in to the wrong info account, if that 
account just logged out). Bad - He should not allow that at all, the user must 
specify info@domainA or info@domainB to log in and the system should grab the 
domain from there! Is this a feature or a bug? Can I change that behaviour?


 I opened a bug report for this and provided a patch, locally tested 
and considered working.


http://www.sogo.nu/bugs/view.php?id=2162
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Multi-User Login not working reliably? Something broken?

[John Bieling]

Hi,

I have a fresh install of SOGo 2.0.3 (Ubuntu 32Bit), and performed the 
setup as described in the official guide. The users in my LDAP directory 
are all without the @domain suffix. For example I have two users with 
uid info:


uid=info,ou=users_domainA,dc=local
uid=info,ou=users_domainB,dc=local


1. Issue


If I use SOGoLoginDomains, the system authenticates the user against the 
selected domain, so entering info with password of domainB but selected 
domainA will result in an wrong password error. Good.


If I do not use SOGoLoginDomains, he will try both info accounts and 
match it by the password - and sometimes messes up (log in to the wrong 
info account, if that account just logged out). Bad - He should not 
allow that at all, the user must specify info@domainA or info@domainB to 
log in and the system should grab the domain from there! Is this a 
feature or a bug? Can I change that behaviour?



2. Issue


The internal system email after login is constructed as uid@domain, but 
sometimes he forgets the @domain suffix and tries to authenticate 
against IMAP/SMTP with just the uid. I can overcome this by using 
SOGoForceIMAPLoginWithEmail , but that option is missing for SMTP.


Secondly I would like to know, why with one domain he always added the 
domain-suffix, but not for the other. Any Ideas? Am I the only one?


To reset my system, I drop the database and flush the memcached, could 
there be some leftover configuration somewhere else?


Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Multi-User Login not working reliably? Something broken?

[John Bieling]

Am 06.01.2013 14:13, schrieb Christian Rößner:

I have a fresh install of SOGo 2.0.3 (Ubuntu 32Bit), and performed the setup as described 
in the official guide. The users in my LDAP directory are all without the @domain suffix. 
For example I have two users with uid info:

uid=info,ou=users_domainA,dc=local
uid=info,ou=users_domainB,dc=local


1. Issue


If I use SOGoLoginDomains, the system authenticates the user against the 
selected domain, so entering info with password of domainB but selected domainA 
will result in an wrong password error. Good.

If I do not use SOGoLoginDomains, he will try both info accounts and match it by 
the password - and sometimes messes up (log in to the wrong info account, if that 
account just logged out). Bad - He should not allow that at all, the user must 
specify info@domainA or info@domainB to log in and the system should grab the 
domain from there! Is this a feature or a bug? Can I change that behaviour?


2. Issue


The internal system email after login is constructed as uid@domain, but 
sometimes he forgets the @domain suffix and tries to authenticate against 
IMAP/SMTP with just the uid. I can overcome this by using 
SOGoForceIMAPLoginWithEmail , but that option is missing for SMTP.

Secondly I would like to know, why with one domain he always added the 
domain-suffix, but not for the other. Any Ideas? Am I the only one?

To reset my system, I drop the database and flush the memcached, could there 
be some leftover configuration somewhere else?


can you show the output of defaults read as user sogo with passwords removed?

-Christian Rößner

--
[*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstraße 15, 81669 München

Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer
Aufsichtsratsvorsitzender: Joerg Heidrich


Sure, I orderd the output a bit for better reading

By the way, he just messed up the login even WITH SOGoLoginDomains (as 
in this config), and since I have currently SOGoForceIMAPLoginWithEmail 
enabled I could se the wrong login in the IMAP configuration popup (I 
logged in with cvjmbonn but the popup showed i...@jobisoft.de)


Very strange. Could it be a session failure? Trying a different browser 
now...


sogod SOGoLanguage German
sogod SOGoFirstDayOfWeek 1
sogod SOGoProfileURL 
postgresql://sogo:sogo@localhost:5432/sogo/sogo_user_profile
sogod OCSSessionsFolderURL 
postgresql://sogo:sogo@localhost:5432/sogo/sogo_sessions_folder
sogod OCSFolderInfoURL 
postgresql://sogo:sogo@localhost:5432/sogo/sogo_folder_info

sogod SOGoSearchMinimumWordLength 0
sogod SOGoTimeZone Europe/Berlin
sogod SOGoPasswordChangeEnabled YES
sogod SOGoFoldersSendEMailNotifications NO
sogod SOGoMailCustomFromEnabled NO
sogod SOGoACLsSendEMailNotifications NO
sogod SOGoAppointmentSendEMailNotifications NO
sogod SOGoMailAuxiliaryUserAccountsEnabled YES

sogod SOGoMailingMechanism smtp
sogod SOGoSMTPAuthenticationType PLAIN
sogod SOGoForceIMAPLoginWithEmail YES
sogod SOGoEnableDomainBasedUID YES
sogod SOGoLoginDomains '(
cvjmbonn.de,
jobisoft.de
)'

sogod domains '{
cvjmbonn.de = {
SOGoDraftsFolderName = Drafts;
SOGoIMAPServer = imap://imap.worldserver.net;
SOGoMailDomain = cvjmbonn.de;
SOGoSMTPServer = smtp.worldserver.net;
SOGoSentFolderName = Sent Items;
SOGoTrashFolderName = Trash;
SOGoUserSources = (
{
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN = ou=users.cvjmbonn,dc=local;
bindDN = uid=admin.cvjmbonn,ou=users.cvjmbonn,dc=local;
bindPassword = *;
canAuthenticate = YES;
displayName = Shared Addresses;
hostname = localhost;
id = public_cvjmbonn;
isAddressBook = YES;
port = 389;
type = ldap;
}
);
};
jobisoft.de = {
SOGoDraftsFolderName = INBOX/Drafts;
SOGoIMAPServer = imaps://mails.jobisoft.de:993;
SOGoMailDomain = jobisoft.de;
SOGoSMTPServer = mails.jobisoft.de;
SOGoSentFolderName = INBOX/Sent Items;
SOGoTrashFolderName = INBOX/Trash;
SOGoUserSources = (
{
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN = ou=users.jobisoft,dc=local;
bindDN = uid=admin.jobisoft,ou=users.jobisoft,dc=local;
bindPassword = *;
canAuthenticate = YES;
displayName = Shared Addresses;
hostname = localhost;
id = public_jobisoft;
isAddressBook = YES;
port = 389;
type = ldap;
}
);
};
}'

--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Only the last line of SMTP answer is returned - so SOGo fails to see AUTH PLAIN - sending fails

[John Bieling]

Hi,

using sogo 2.0.3 with

sogod SOGoSMTPAuthenticationType PLAIN

enabled. This is the SMTP reply after EHLO with telnet

open smtp.wordlserver.net 25

220 mail01.worldserver.net ESMTP Speedbone Mailservice
EHLO sogoserver
250-mail01.worldserver.net
250-PIPELINING
250-SIZE 69730304
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN CRAM-MD5
250-AUTH=PLAIN LOGIN CRAM-MD5
250-ENHANCEDSTATUSCODES
250 8BITMIME
QUIT
221 2.0.0 Bye

This is taken out of the logfile:

C: connect to 0x0xb969b420[NGInternetSocketAddress]: 
host=smtp.worldserver.net not-filled
S: SMTP-Reply: code=220 line='mail01.worldserver.net ESMTP Speedbone 
Mailservice'

C: EHLO sogoserver
S: SMTP-Reply: code=250 line='8BITMIME'
S: pipelining extension supported.
S: size extension supported.
C: QUIT
S: SMTP-Reply: code=221 line='2.0.0 Bye'

Anyone else? Bug?

Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Only the last line of SMTP answer is returned - so SOGo fails to see AUTH PLAIN - sending fails

[John Bieling]

Am 06.01.2013 14:40, schrieb John Bieling:

Hi,

using sogo 2.0.3 with

sogod SOGoSMTPAuthenticationType PLAIN

enabled. This is the SMTP reply after EHLO with telnet

open smtp.wordlserver.net 25

220 mail01.worldserver.net ESMTP Speedbone Mailservice
EHLO sogoserver
250-mail01.worldserver.net
250-PIPELINING
250-SIZE 69730304
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN CRAM-MD5
250-AUTH=PLAIN LOGIN CRAM-MD5
250-ENHANCEDSTATUSCODES
250 8BITMIME
QUIT
221 2.0.0 Bye

This is taken out of the logfile:

C: connect to 0x0xb969b420[NGInternetSocketAddress]: 
host=smtp.worldserver.net not-filled
S: SMTP-Reply: code=220 line='mail01.worldserver.net ESMTP Speedbone 
Mailservice'

C: EHLO sogoserver
S: SMTP-Reply: code=250 line='8BITMIME'
S: pipelining extension supported.
S: size extension supported.
C: QUIT
S: SMTP-Reply: code=221 line='2.0.0 Bye'

Anyone else? Bug?

Thanks
John
It seems as he only prints the last line of the reply in the logfile, 
but sees them all - because he states


S: pipelining extension supported.
S: size extension supported.

But why is he ignoring the AUTH PLAIN support? Is the answer mailformed? 
An other mailserver works with the same configuration...


Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Multi-User Login not working reliably? Something broken?

[John Bieling]

Am 06.01.2013 17:55, schrieb Christian Rößner:

sogod domains '{
cvjmbonn.de = {
SOGoDraftsFolderName = Drafts;
SOGoIMAPServer = imap://imap.worldserver.net;
SOGoMailDomain = cvjmbonn.de;
SOGoSMTPServer = smtp.worldserver.net;
SOGoSentFolderName = Sent Items;
SOGoTrashFolderName = Trash;
SOGoUserSources = (
{
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN = ou=users.cvjmbonn,dc=local;
bindDN = uid=admin.cvjmbonn,ou=users.cvjmbonn,dc=local;
bindPassword = *;
canAuthenticate = YES;
displayName = Shared Addresses;
hostname = localhost;
id = public_cvjmbonn;
isAddressBook = YES;
port = 389;
type = ldap;
}
);

I do not see many differences to my configuration. This looks like this:

sogod domains '{
 exampleserver-de = {
SOGoMailDomain = exampleserver.de;
SOGoUserSources = (
{
CNFieldName = cn;
IDFieldname = uid;
IMAPLoginFieldName = rnsMSDovecotUser;
KindFieldName = Kind;
MailFieldNames = (
mail
);
MultipleBookingsFieldName = Multiplebookings;
UIDFieldName = rnsMSDovecotUser;
baseDN = 
ou=exampleserver-de,ou=people,ou=it,dc=roessner-net,dc=de;
bindAsCurrentUser = NO;
bindDN = cn=sogo,ou=people,ou=it,dc=roessner-net,dc=de;
bindFields = (
rnsMSRecipientAddress,
uniqueIdentifier
);
bindPassword = ;
canAuthenticate = YES;
displayName = Gemeinsame Adressen;
encryption = STARTTLS;
hostname = roessner1.roessner-net.de db.roessner-net.de;
id = directory2;
isAddressBook = YES;
port = 389;
scope = SUB;
type = ldap;
}
);
 };
…

I have no further special options. Neither to force something (IMAP) nor 
options that tell SOGo which domains can be taken for login. I have set 
IMAPLoginFieldName for each domain, which is an email address.

Sorry, if I can not really help you.

-Christian Rößner

--
[*] sys4 AG

http://sys4.de, +49 (89) 30 90 46 64
Franziskanerstraße 15, 81669 München

Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263
Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer
Aufsichtsratsvorsitzender: Joerg Heidrich


Thanks for your time!

The field

IMAPLoginFieldName

is part of the LDAP user configuration? So each user can have his own setting? 
How do I get this setting into the database? Is this field part of the LDAP 
user or is it in the Postgresql database? Is there such a field also for smtp?

You use exampleserver-de for the domain-name, and not exampleserver.de 
why?

Thanks
John

--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] How to place/discuss bug reports?

[John Bieling]

Hi@all,

how do I report or introduce a bug for discussion? Simply writing to 
this mailinglist?


Thanks
John


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Only the last line of SMTP answer is returned - so SOGo fails to see AUTH PLAIN - sending fails

[John Bieling]

Am 06.01.2013 20:09, schrieb Anselm Martin Hoffmeister:

Am 06.01.2013 16:45, schrieb John Bieling:

Am 06.01.2013 14:40, schrieb John Bieling:

Hi,

using sogo 2.0.3 with

sogod SOGoSMTPAuthenticationType PLAIN

enabled. This is the SMTP reply after EHLO with telnet

open smtp.wordlserver.net 25

220 mail01.worldserver.net ESMTP Speedbone Mailservice
EHLO sogoserver
250-mail01.worldserver.net
250-PIPELINING
250-SIZE 69730304
250-VRFY
250-ETRN
250-STARTTLS
250-AUTH PLAIN LOGIN CRAM-MD5
250-AUTH=PLAIN LOGIN CRAM-MD5


This is not RFC compliant, if I understand the spec correctly (see 
http://tools.ietf.org/html/rfc5321 page 33). It seems some mailservers

send that AUTH=PLAIN to support old Outlook Express clients that need
this for authentication to work (cf. http://www.wogri.at/248.html?L=1 ).

It would by nice if SOGo went the extra mile to accept this
non-standard but obviously existant line. Being RFC compliant is not a 
bug, though :-)


BR
-AMH-


Can we do something about it? Can we patch the source, or will that only 
be done by inverse?


Are they reading this or do we have to ask/tell someone?

Thanks
John
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Multi-User Login not working reliably? Something broken?

[John Bieling]

Am 06.01.2013 21:18, schrieb Patrick Ben Koetter:

* Christian Rößner users@sogo.nu:

You use exampleserver-de for the domain-name, and not
exampleserver.de why?

To be honest? I had copied an example from Patrick Ben Koetter and adopted
it to my needs :) Maybe he may say something to this aspect. But I think you
may specify whatever you like, as it seems just to be an unique name for a
block.

It's been a while I tested that. IIRC a '.' dot led to an error. I don't
recall ATM, but I recall I changed it to '-' and never looked back again. It's
a good marker to jump to in vi. ;)

p@rick



In my config (using SOGoLoginDomains-Array) that unique-block-name is 
also used at the login-screen for domain selection - and not 
SogoMailDomain - or is there a switch to enforce the usage of the value 
of SogoMailDomainfor that dropdown menu?


Sorry for the many questions..

John
--
users@sogo.nu
https://inverse.ca/sogo/lists