Re: [SOGo] Instant messaging

[Corrado Fiore]

Hi,

have you already checked out JSXC?

https://www.jsxc.org/sogo.html
https://github.com/jsxc/jsxc.sogo

As far as external (smartphone) access is concerned:  JSXC requires an XMPP 
servers (formerly known as Jabber) as a backend, so chances are that your 
mobile clients could be able to connect to the same backend from the public 
internet.  I'm actually interested in deploying such a scenario myself.

Best,
Corrado Fiore

__
On 01/08/2016, at 5:29 PM, s...@adeux.net wrote:

> Hi,
> 
> Has anyone implemented instant messaging in a sogo environment?  Are ther any 
> open source apckages that allow this cross platform - ie iphone, android, web?
> 
> Thanks
> -- 
> users@sogo.nu
> https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Outlook CalDAV Synchronizer (was: Re: ANN: SOGo Package Repositories)

[Corrado Fiore]

Hi Alex, hi Slávek,

thanks a lot for your feedback, very appreciated.  We'll be glad to test the 
product in our environment and contribute back to it as much as we can.

All the best,
Corrado

___
> On 1 Aug 2016, at 12:22 AM, Alexander Nimmervoll (n...@technikum-wien.at) 
>  wrote:
> 
> Hi!
> 
> As one of the developers of CalDavSynchronizer I can confirm that we have 
> many users which use it in production with large calendars. SOGo is our main 
> caldav server we test against btw and we try to fix any issues as soon as 
> possible. The poor performance and stability of other commercial outlook 
> caldav addins was my main motivation to start the project. 
> 
> br
> Alex

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

[SOGo] Outlook CalDAV Synchronizer (was: Re: ANN: SOGo Package Repositories)

[Corrado Fiore]

Dear All,

On 29/07/2016, at 3:20 AM, Slávek Banko (slavek.ba...@axis.cz) wrote:

> Without OpenChange are two possibilities for MS Outlook support:
> 
> [...]
> 2) Outlook CalDav Synchronizer with Outlook 2007 ane later.
> 
> [...] adds into MS Outlook exactly what is missing == CalDAV 
> and CardDAV.

This plugin could be a game changer for us because it fits nicely into the 
"hosted Exchange" model that we're trying to implement, whereas OpenChange is 
more tied to a different paradigm (Active Directory / corporate environments).

Has anyone tested it in production already?  I mean, business users with lots 
of events listed in multiple calendars, etc.

The plugin repo on GitHub looks very active and that's surely a good sign, but 
I was interested in first-hand reviews from the list.  A couple of years ago, 
in fact, we were pushing Bynari Connector to our clients, only to discover that 
it was not only quite intrusive, but it also tended to explode when it had to 
sync lots of data :-(

Cheers,
Corrado Fiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] integration with jsxc/sjsxc

[Corrado Fiore]

Dear All,

> On 22 Jun 2016, at 7:11 PM, sg gs (s...@mail.com) <users@sogo.nu> wrote:
> 
> this works for 2.3.12 but unfortunately not for 3.1.2 - seems that (at least) 
> jquery is missing from 3.1.2.

We're very interested in integrating JSXC, too.  I guess it shouldn't be hard 
to integrate Jquery into 3.1.x as well, possibly using a separate namespace.  
Or am I missing something?

Kind regards,
Corrado Fiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Running SOGo v2 and v3 in parallel (sharing database)

[Corrado Fiore]

Dear All,

we'd like to keep two instances of SOGo (v2 and v3) running in parallel.  The 
idea is that users on a desktop/laptop would continue to use v2 whereas users 
on a touch device would use the newer interface.

Given the database structure overhaul that was introduced in version 3.1.0, is 
it still possible to run the two versions in parallel?

Will the enhanced DB structure be backported at some point to v2 or have the 
backends effectively started to diverge?

(Don't get me wrong, v3 theme is terrific but we still see lots of demand for a 
more traditional point-and-click theme like in v2).

Thanks,
Corrado Fiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] ActiveSync question

[Corrado Fiore]

On Oct 22, 2013, at 14:19 , boyd yang wrote:

 Can this solution work well for mail,calendar,contacts at the same time？ No 
 need to configure calendar,contacts differently?

Yup, exactly.  All like a real Exchange account.  Plus, you get push email, 
which is a definite bonus for business users.

The downside - which might apply or not to your case - is that push mail via 
Z-push (which is a PHP application) requires way more resources per user than 
SOGo itself since the TCP connection underlying the HTTP protocol must remain 
in open state.

As the author of Z-push-contrib suggests, the rule of thumb is:  1.5 PHP 
processes per email user, so 1,000 users would translate to 1,500 active PHP 
processes.  Of course you can set up a balanced pool of servers, but the point 
here is:  don't expect Z-Push (which I love, don't get me wrong) to scale 
beautifully as SOGo does.

In this light, I can understand one of the reasons why the SOGo team is looking 
for a native implementation instead.

Best,
Corrado



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

Re: Have to make CardDav work too - was: Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear Marcio,

sorry for the late reply.  Please set CARDDAV_SUPPORTS_SYNC = FALSE.  SOGo 
doesn't implement the SYNC function yet.

Best,
Corrado

_
On Sep 12, 2013, at 16:28 , Marcio Merlone wrote:

 As I sayd before, IMAP and CalDav are working great. But could not make 
 CardDav work, can you assist me? CardDav backend config is as follows:
 
 // http://YOURSOGOINSTALL/dav/YOURUSERNAME/Contacts/personal
 define('CARDDAV_PROTOCOL', 'https');
 define('CARDDAV_SERVER', 'sogo.domain.tld');
 define('CARDDAV_PORT', '443');
 define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/personal/');
 define('CARDDAV_CONTACTS_FOLDER_NAME', '');
 define('CARDDAV_SUPPORTS_SYNC', true);
 
 Have tested on my real Defy CM10 (Android 4.1) and a virtual Galaxy S4 from 
 Genymotion, both (did not) worked the same. Also tried:
 
 define('CARDDAV_PATH', '/SOGo/dav/%u/Contacts/');
 define('CARDDAV_CONTACTS_FOLDER_NAME', 'personal');
 
 Thank you, best regards.
 
 -- 
 Marcio Merlone
 TI - Administrador de redes
 
 A1 Engenharia - Unidade Corporativa
 Fone: +55 41 3616-3797
 Cel:  +55 41 9689-0036http://www.a1.ind.br/

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

Re: [SOGo] php-push2 question

[Corrado Fiore]

Dear Donny,

I was able to compile libawl-php on a CentOS 6.4 box just fine.  It's a package 
that you won't find in RPM format, but compilation is easy enough.

On a related note, my favorite fork of Z-Push 
(https://github.com/fmbiete/Z-Push-contrib/blob/master/INSTALL) seems to not 
require libawl-php anymore (I haven't tested it myself, as I installed it on 
the same box where I had compiled libawl-php).

Best,
Corrado

_
On Sep 9, 2013, at 18:06 , Donny Brooks wrote:

 I have z-push setup and functioning just fine on an external server. However 
 I am looking to test out the modified php-push2 so it can integrate the 
 contacts and calendar without seperate server settings, mainly on apple 
 devices. The only problem I am running in to is I am running CentOS 6.4, so 
 there is no libawl-php in any of the repositories I can find. the site in the 
 readme is not reachable either. Is this a package that is needed for it to 
 work at all? If it is needed, can someone point me to where to obtain it?
 
 --
 Donny B.



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Hi Marcio,

 I could not make it work with SOGo. I commented all but BackendImap, caldav 
 and carddav on combined/config.php, edited each config.php for each enabled 
 backend, and yet only imap works. When I try to list available calendars on 
 my account it shows nothing.

Could you please post the relevant lines in the CardDAV / CalDAV backends' conf 
to a pastebin?  It's likely that the paths you specified are the culprit here.

-- 
Corrado




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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Hi Marcio,

 could not find the relevant options to set on it - imap server, caldav and 
 carddav server, path, etc

Each backend has its own config file, located at 

  /backend/$backendName/config.php

For instance, the IMAP config file is

  /backend/imap/config.php

Best,
Corrado


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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear All,

I've been in touch in the past days with Francisco Miguel Biete, author of 
Z-Push-contrib, a fork from the original Z-Push that is working well (at least, 
in our tests) with SOGo:

https://github.com/fmbiete/Z-Push-contrib

What's important here is that Francisco Miguel has been very responsive in 
fixing the bugs we submitted (one for CardDAV, the other for the IMAP backend). 
 I must say I'm quite impressed.

ActiveSync seems to be working very well, and so far seems to be solid enough 
that we can use it in production.  However, documentation could be a bit more 
organized, so here's the idea:  I'll try to sum all the usual mistakes on a 
page in the SOGo wiki.  Allow me some days for this, I'll try my best.

On the other hand, I agree that the SOGo community needs a point of reference 
for Z-Push just like Inverse is for SOGo.

Best,
Corrado Fiore


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

Re: [SOGo] ActiveSync question

[Corrado Fiore]

Dear Albrecht,

 Another question is: Have these projects all to be based on z-push? What if 
 hordes ActiveSync interface also could be used as starting point?

Actually, Horde's ActiveSync module is based on Z-Push:

The code that handles the protocol level is essentially the same, though it 
has been heavily refactored and cleaned.

Ref.:  http://wiki.horde.org/ActiveSync#toc24

Best,
Corrado


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

Re: [SOGo] Php-push2 - Active Sync

[Corrado Fiore]

Hi Marcio,

 If I set 'BackendCombined' it complains about php-mapi missing and apache 
 throws a 500 error. How did you manage it? 

In the /backend/combined/config.php file you should find the 
GetBackendCombinedConfig() function and comment out the lines that refer to 
backends other than IMAP, CardDAV and CalDAV:

'backends' = array(
'i' = array(
'name' = 'BackendIMAP',
),
//'z' = array(
//'name' = 'BackendZarafa',
//),
//'m' = array(
//'name' = 'BackendMaildir',
//),
//'v' = array(
//'name' = 'BackendVCardDir',
//),
'c' = array(
'name' = 'BackendCalDAV',
),
//'l' = array(
//'name' = 'BackendLDAP',
//),
'd' = array(
'name' = 'BackendCardDAV',
),
),
'delimiter' = '/',

---

Then you should select the right backend for each function:


//force one type of folder to one backend
//it must match one of the above defined backends
'folderbackend' = array(
SYNC_FOLDER_TYPE_INBOX = 'i',
SYNC_FOLDER_TYPE_DRAFTS = 'i',
SYNC_FOLDER_TYPE_WASTEBASKET = 'i',
SYNC_FOLDER_TYPE_SENTMAIL = 'i',
SYNC_FOLDER_TYPE_OUTBOX = 'i',
SYNC_FOLDER_TYPE_TASK = 'c',
SYNC_FOLDER_TYPE_APPOINTMENT = 'c',
SYNC_FOLDER_TYPE_CONTACT = 'd',
SYNC_FOLDER_TYPE_NOTE = 'i',
SYNC_FOLDER_TYPE_JOURNAL = 'i',
SYNC_FOLDER_TYPE_OTHER = 'i',
SYNC_FOLDER_TYPE_USER_MAIL = 'i',
SYNC_FOLDER_TYPE_USER_APPOINTMENT = 'c',
SYNC_FOLDER_TYPE_USER_CONTACT = 'd',
SYNC_FOLDER_TYPE_USER_TASK = 'c',
SYNC_FOLDER_TYPE_USER_JOURNAL = 'i',
SYNC_FOLDER_TYPE_USER_NOTE = 'i',
SYNC_FOLDER_TYPE_UNKNOWN = 'i',
),
//creating a new folder in the root folder should create a folder 
in one backend
'rootcreatefolderbackend' = 'i',



I agree that the filesystem layout in PHP-push-2 is quite confusing, as there 
are multiple config files scattered around and they also have similar names.  
My advice is to install the latest PHP-Push-Contrib 
(https://github.com/fmbiete/Z-Push-contrib/), which is a fork of the original 
PHP-Push, too, but thanks to the effort of the developer is working quite well 
with our SOGo installation.

Don't forget to set CARDDAV_SUPPORTS_SYNC = false in 
/backend/carddav/config.php, otherwise the addressbook won't work with a SOGo 
backend.

Hope this helps.

Best,
Corrado Fiore



smime.p7s
Description: S/MIME cryptographic signature

Re: [SOGo] Log to syslog

[Corrado Fiore]

Thanks Odhiambo and Martin for your thoughts and for the advice!  We'll work on 
it and post the results on the list in (hopefully) a few days.

Best,
Corrado

_
On Jul 22, 2013, at 16:07 , Martin Rabl wrote:

 Hi,
 
 hit me, if I'm wrong, but syslog(-ng) can read from a file, and SOGo write 
 into a file - and all in Unix is a file.
 Means: IMHO it could be possible to defining a file (unix-socket?) for SOGo, 
 which will be read by syslog.
 But I did no tests ...
 
 Greetings,
 Martin
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Log to syslog

[Corrado Fiore]

Dear All,

we would like to use Rsyslogd to redirect all logs to a centralized server.

Is there a way to have SOGo write logs to 'syslog' instead of a file?

I have searched through the documentation and the mailing list's archives but 
have found nothing so far.

Thanks for your help.

Best,
Corrado Fiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Why not move from Funambol to Z-Push? Many features will be obtained.

[Corrado Fiore]

On Feb 19, 2012, at 21:39 , Lacroix Francois wrote:

 How are still interest in a Caldav/Carddav support for Z-Push?

Yup, definitely.

 I would be able to do it for 800€.
 I would need to take holiday to be fully concentrate on it.

That sounds reasonable to me.

 I have only an iPhone to do test but ActiveSync shoud be the same accross OS 
 as it license.

Luckily, I have an Android-powered device, so I could help test it.

Some quick questions:

1) Just to make sure we're all on the same page, what would be the final 
product of your effort?  A Z-push backend to be installed onto the latest 
stable release of Z-push?

2) Would you release your code with a GPL license?

Also, even if the amount of money involved is relatively small, I think we 
should rely on an external fundraising service like Kickstarter 
(https://www.kickstarter.com/proposals/profiles/new) or something similar 
(suggestions welcome!).

Best,
Corrado Fiore-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Why not move from Funambol to Z-Push? Many features will be obtained.

[Corrado Fiore]

Dear All,

I second this proposal of developing a SOGo-version of Z-Push.  I'd contribute 
with another 400 Euros.  Time to start a fundraising for this?

Best,
Corrado Fiore

__
On Feb 7, 2012, at 15:54 , mayak-cq wrote:

 i'm willing to finance 400 euros ... just need an invoice of some sort.
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] iCal4OL (was: Experiences with Bynari WebDAV Collaborator?)

[Corrado Fiore]

Dear All,

 I'm trying to configure the WebDAV Collaborator from Bynari on my Outlook 
 2007, with no luck.  Can anyone point me to any resources out there, apart 
 from the inadequate Bynari docs?

I think I've found the solution by myself:  instead of the product from Bynari, 
I'm using iCal4OL (http://ical.gutentag.ch/).  The trial version is fully 
functional.

iCal4OL acts as a standalone CardDAV - CalDAV client which keeps Outlook 
calendar and addressbook in sync with SOGo and vice versa.

The documentation on their website might need some polishing, but the product 
works and the support from the author is stellar, even on Sunday ;-)

There's also a pre-configured version available, useful for those who need to 
deploy iCal4OL on many machines.

I think I've (finally!) found the way to fully support Outlook calendar and 
addressbook. :-)

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

Re: [SOGo] Experiences with Bynari WebDAV Collaborator?

[Corrado Fiore]

On Apr 19, 2011, at 22:45 , Jeroen Dekkers wrote:

 I just tried it, I get an error when I press test account settings,
 but the calendar actually works out of the box.

I'm trying to configure the WebDAV Collaborator from Bynari on my Outlook 2007, 
with no luck.  Can anyone point me to any resources out there, apart from the 
inadequate Bynari docs?

@Jeroen:  which string did you use in the Server URL field in calendar 
configuration?

Thanks,
Corrado Fiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Slow performance when sending outgoing mail

[Corrado Fiore]

Dear All,

I have SOGo 1.3.6 configured to send via Sendmail on localhost on a CentOS 
server.

The response time is very good on average (about 80% of the request take less 
than 0.25 sec to execute, thanks also to Imapproxy), except when sending a 
message:  even a small (about 1KB) message makes SOGo work for at least 2.5 sec 
(sometimes much more, i.e. more than 10 sec) before closing the Compose window.

This is the relevant portion of the sogo.log:  http://pastebin.com/sT6vu01S

I see almost no difference between Sendmail and an SMTP connection (actually, I 
have tried also with Sendmail stopped).  My idea is that the delay could be an 
effect of negotiation with the IMAP server for storing the message in the draft 
folder and then into the sent folder.

Thanks for any suggestions and comments.

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

Re: [SOGo] Character size, messages look smaller

[Corrado Fiore]

Hi,

for a drop-in replacement of the SOGo default theme, see bug #758 and download 
the attachment.  I'm about to release a slightly improved version, but the one 
attached is already usable.

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

@Philippe:  you might have not noticed, but you hijacked the thread.

Best,
Corrado


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

Re: [SOGo] New e-mail notification in webinterface

[Corrado Fiore]

Hi Paul,

 [...] Sogo says always Sogo, so she needs to open the browser to see if
 there are new messages.

I think this is an instance of a more general problem (the fixed title in 
windows).  There's a bug already filed for this, you might want to add details 
to it:  http://www.sogo.nu/bugs/view.php?id=1045

My two cents :-)

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

Re: [SOGo] Multiple IMAP servers with authentication in Active Directory

[Corrado Fiore]

Hello Pašek,

I think you could use filters:  SOGo supports them when using LDAP sources.  
You could set a different filter for each group and achieve user segregation 
with a single AD backend.

There's an old thread with more specific information on how to set them:
http://www.mail-archive.com/users@sogo.nu/msg00159.html

(hope filters will be implemented soon for MySQL userSources, too ;-)

Cheers,
Corrado

_
Il giorno 05/mar/2011, alle ore 11:28, Pašek Ladislav ha scritto:

 Hello,
 
 as I've seen it the bug report that it is solved. Also there is written that 
 SOGo is differentiating domain through UserSource. That would be a problem 
 for me because I have all my users in Active Directory and independent 
 Dovecots for different domain just authenticate them with filled email filed 
 in AD. I also thought that SOGo will differentiate users to domain through 
 the @domain.tld part of the email.
 
 So is there way to differentiate users to SOGOdomain when they are in the 
 same AD server but in the different groups like:
 
 ou=PRX,ou=Users,dc=domain,dc=tld
 ou=LBC,ou=Users,dc=domain,dc=tld
 
 Thanks in Advance
 
 Ladislav
 
 Úterý, 01 Únor, 2011 13:03 CET, Corrado Fiore mail...@corradofiore.it 
 napsal:
 
 Il giorno 01/feb/2011, alle ore 12:29, Ladislav Pašek ha scritto:
 
 we are using authentication in Active Directory(one domain) for our 4 
 different independent mail servers based on Postfix+Dovecot(IMAP). It is 
 possible to configure SOGo to use different IMAP server according to filled 
 email in mail field in AD?
 
 As far as I know, you could set a different IMAP host per domain.  However, 
 there's currently a bug in that function:  IMAP hosts set into a domain 
 declaration will revert to localhost (see 
 http://www.sogo.nu/bugs/view.php?id=1097).
 
 Of course, if anyone managed to make per-domain IMAP hosts work with a MySQL 
 backend, feel free to correct me.
 
 Best,
 Corrado Fiore
 
 __--
 users@sogo.nu
 https://inverse.ca/sogo/lists
 
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists

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

Re: [SOGo] Removing /SOGo/ from URL

[Corrado Fiore]

Hi,

 hopefully, you don't dislike the word SOGo in the URL, but think of your 
 poor users, who cannot remember how to spell the end of the URL

Yup, that's the problem.  Shorter is better and having to remember capital 
letters is not easy for most people.

 - but THAT is rather easy to circumvent ...

Let me analyze the problem from a different standpoint:  yes, as long as the 
webmail interface is involved, you can use a Apache / Nginx redirection like 
the following (btw, thanks for sharing your code):

location / {
rewrite ^/$ $scheme://$host/SOGo/;
}

But, if you think about calendar and addressbook clients (like iCal or 
Thunderbird), I'm pretty sure you cannot apply the same workaround.

Things get worse on mobile devices, e.g. iPhones or Android ones, where it can 
be difficult or impossible to paste a ready-made URL and it is quite difficult 
to compose URL strings with mixed uppercase and lowercase letters.

And bear in mind that when you configure, say, iCal on the iPhone you must 
insert the *full path* for *each* of your calendars.

Of course, if I'm missing something, feel free to correct me :-)

Best,
Corrado

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

[SOGo] Google public calendars subscription problem

[Corrado Fiore]

Dear All,

I'm trying to subscribe one of the public calendars provided by Google (Italian 
holidays), at the following URL:

http://www.google.com/calendar/ical/it.italian%23holiday%40group.v.calendar.google.com/public/basic.ics

If I call that URL from a browser or from iCal.app, it works fine.  SOGo will 
refuse to subscribe it (Error during import).

Here you are the relevant log lines:

Mar 03 21:41:47 sogod [26045]: |SOGo| version 1.3.5 (build 
r...@vizzini.inverse.ca 201102070652) -- starting
Mar 03 21:41:47 sogod [26045]: |SOGo| vmem size check enabled: shutting down 
app when vmem  384 MB

2011-03-03 21:42:37.873 sogod[26045] Note: Using UTF-8 as URL encoding in 
NGExtensions.
Mar 03 21:42:38 sogod [26045]: |SOGo| starting method 'POST' on uri 
'/SOGo/so/myu...@corradofiore.it/Calendar//addWebCalendar?url=http%3A//www.google.com/calendar/ical/it.italian%2523holiday%2540group.v.calendar.google.com/public/basic.ics'
Mar 03 21:42:38 sogod [26045]: 0x0x8db9878[SOGoCache] Cache cleanup interval 
set every 300.00 seconds
Mar 03 21:42:38 sogod [26045]: 0x0x8db9878[SOGoCache] Using host(s) 
'localhost' as server(s)
Mar 03 21:42:38 sogod [26045]: |SOGo| traverse(acquire): myu...@corradofiore.it 
= Calendar = addWebCalendar
Mar 03 21:42:38 sogod [26045]: |SOGo|   do traverse name: 
'myu...@corradofiore.it'
2011-03-03 21:42:38.103 sogod[26045] Note(SoObject): SoDebugKeyLookup is 
enabled!
2011-03-03 21:42:38.103 sogod[26045] Note(SoObject): SoDebugBaseURL is enabled!
2011-03-03 21:42:38.103 sogod[26045] Note(SoObject): relative base URLs are 
enabled.
Mar 03 21:42:38 sogod [26045]: |SOGo|   do traverse name: 'Calendar'
Mar 03 21:42:38 sogod [26045]: 
0x09084A78[SOGoUserFolder]:myu...@corradofiore.itD traverse key 'Calendar' 
(acquire=yes) ..
Mar 03 21:42:38 sogod [26045]: [WARN] 0x0x908f5b8[SOGoWebDAVAclManager] entry 
'{DAV:}write' already exists in DAV permissions table
Mar 03 21:42:38 sogod [26045]: [WARN] 0x0x908f5b8[SOGoWebDAVAclManager] entry 
'{DAV:}write-properties' already exists in DAV permissions table
Mar 03 21:42:38 sogod [26045]: [WARN] 0x0x908f5b8[SOGoWebDAVAclManager] entry 
'{DAV:}write-content' already exists in DAV permissions table
Mar 03 21:42:38 sogod [26045]: 
0x09084A78[SOGoUserFolder]:myu...@corradofiore.itD   key 'Calendar' 
resolved: 0x0908C1C0[SOGoAppointmentFolders]: name=Calendar 
container=0x09084A78/myu...@corradofiore.it
Mar 03 21:42:38 sogod [26045]: |SOGo|   do traverse name: 'addWebCalendar'
Mar 03 21:42:38 sogod [26045]: 0x0908C1C0[SOGoAppointmentFolders]:CalendarD 
traverse key 'addWebCalendar' (acquire=yes) ..
Mar 03 21:42:38 sogod [26045]: 0x0908C1C0[SOGoAppointmentFolders]:CalendarD 
  key 'addWebCalendar' resolved: 0x0x8f3e8d0[SoActionInvocation]: 
class=UIxCalMainActions action=addWebCalendar
Mar 03 21:42:38 sogod [26045]: |SOGo| set clientObject: 
0x0908C1C0[SOGoAppointmentFolders]: name=Calendar 
container=0x09084A78/myu...@corradofiore.it
2011-03-03 21:42:40.475 sogod[26045] WOCompoundElement: pool embedding is on.
2011-03-03 21:42:40.475 sogod[26045] WOCompoundElement: id logging is on.
2011-03-03 21:42:40.477 sogod[26045] Note: using 'UCS-2LE' on Linux.
C: connect to 0x0x906bfc0[NGInternetSocketAddress]: host=MYHOST.com not-filled
...smtp stuff here...
S: SMTP-Reply: code=250 line='2.0.0 Ok: queued as 53FB5A6784B3'
C: QUIT
S: SMTP-Reply: code=221 line='2.0.0 Bye'
Mar 03 21:42:41 sogod [26045]: |SOGo| request took 3.582545 seconds to execute
127.0.0.1 - - [03/Mar/2011:21:42:41 GMT] POST 
/SOGo/so/myu...@corradofiore.it/Calendar//addWebCalendar?url=http%3A//www.google.com/calendar/ical/it.italian%2523holiday%2540group.v.calendar.google.com/public/basic.ics
 HTTP/1.0 200 16/0 3.715 - - 3M

---

The first thing I notice is that the URL provided by Google is already encoded. 
 SOGo does double encoding in the url parameter (%23 becomes %2523):

url=http%3A//www.google.com/calendar/ical/it.italian%2523holiday%2540group.v.calendar.google.com/public/basic.ics

Is this a bug in SOGo?

Thanks,
Corrado Fiore


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

Re: [SOGo] Google public calendars subscription problem

[Corrado Fiore]

 I'm trying to subscribe one of the public calendars provided by Google 
 (Italian holidays), at the following URL:
 http://www.google.com/calendar/ical/it.italian%23holiday%40group.v.calendar.google.com/public/basic.ics

Il giorno 03/mar/2011, alle ore 22:39, André Schild ha scritto:

 Have you tried to subscribe with the unencoded google url ?

Yes, I did -- thanks for the suggestion.  If I enter

http://www.google.com/calendar/ical/it.italian#holi...@group.v.calendar.google.com/public/basic.ics

SOGo translates it into

127.0.0.1 - - [03/Mar/2011:22:58:56 GMT] POST 
/SOGo/so/myu...@corradofiore.it/Calendar//addWebCalendar?url=http%3A//www.google.com/calendar/ical/it.italian%23holi...@group.v.calendar.google.com/public/basic.ics
 HTTP/1.0 200 16/0 2.274 - - 576K

...which is almost correct (i.e. Google Calendar happily serves the file if I 
call the URL directly into a browser).  Nevertheless, SOGo still gives an error 
message and refuses to subscribe the calendar.

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

Re: [SOGo] Removing /SOGo/ from URL

[Corrado Fiore]

Il giorno 02/mar/2011, alle ore 20:16, Paul van der Vlis ha scritto:

 I would like to run Sogo on the root of an URL, so not something like:
 https://sogo.vandervlis.nl/SOGo/
 But something like:
 https://sogo.vandervlis.nl/

This is something that has been discussed already.  Unfortunately, the /SOGo/ 
path is hardcoded in several SOGo files, so at the moment you can't get rid of 
it (I tried by myself without success).  I agree that it would be nice to have 
such a feature.

Best,
Corrado Fiore-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] SOGoUserSources SQL

[Corrado Fiore]

Hi Romain,

seems like we're facing the same problems at the same time.  You may want to 
check out the mail I sent yesterday to the list (Multiple domains, single 
MySQL userSource, http://tinyurl.com/652nord) after one day and a half of 
unsuccessful digging and testing.

I hope there's a viable way to achieve domain isolation using MySQL, too.

Best,
Corrado


Il giorno 21/feb/2011, alle ore 17:59, Romain LE DISEZ ha scritto:

 Hello all,
 
 I'm deploying a SOGo with SQL user source and multi-domains. I'm facing
 two problems, one is critical (security).
 
 1/ Critical : With SQL user source, the domains isolation does not seem
 to work.
 
 When I'm connected with a user from domain1.tld, I can see the users of
 all domains (domain1.tld and domain2.tld) in the sharing dialog and in
 the subscription dialog.
 
 
 2/ The shared address book does not work in multi-domains configuration
 
 Setting isAddressBook = YES for a SOGoUserSources works fine in a
 simple configuration. When setting the same parameter in a
 SOGoUserSources in a domain, it does not work (the shared address book
 does not appear in the webui).
 
 
 Are they know problems ? I attache my configuration.
 
 Thanks for your help.
 GNUstepDefaults.txt

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

Re: [SOGo] Is is possible to change the default /SOGo URL?

[Corrado Fiore]

 Am 18.02.2011 um 23:23 schrieb Adi Linden:
 Is it possible to change the default /SOGo URL to something different, like 
 /something?

Il giorno 19/feb/2011, alle ore 16:24, Martin Rabl ha scritto:
 Sure - it is only a proxy before the SOGo-Application-Server.


Hi,

I'm using Nginx as proxy (I'm on CentOS), with a conf file similar to this one:
http://mail.opengroupware.org/pipermail/sogo/2009-November/004351.html

My goal is to get rid of any paths after the domain.  I tried to modify the 
paths by removing the /SOGo prefix, in the Nginx conf, i.e.

server {
location / {
proxy_redirect http://127.0.0.1:2/SOGo//;
...other lines unchanged...
}
location ~ /WebServerResources/(.*){
alias /usr/GNUstep/System/Library/SOGo/WebServerResources/$1;
}
}

...but it doesn't work.  I end up with login errors (for example, the 
redirection at login becomes http://connect instead of a FQDN).
Assuming that SOGo internally needs a path after the domain, I tried to 
modify it like this:

server {
location /webmail {
proxy_redirect http://127.0.0.1:2/SOGo//webmail;
...other lines unchanged...
}
location ~ /WebServerResources/(.*){
alias /usr/GNUstep/System/Library/SOGo/WebServerResources/$1;
}
}

...but again it doesn't work.  I can login but messages in the webmail are not 
retrieved.

So, before investigating more, let me ask:  did anyone managed to remove the 
/SOGo path under Nginx?

Thanks,
Corrado Fiore

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

[SOGo] Multiple domains, single MySQL userSource

[Corrado Fiore]

Dear All,

I'm trying to deploy SOGo on top of my existing IMAP infrastructure, which is 
powered by PostFix with a MySQL backend to support virtual users and domains.  
All my email users belong to a single MySQL DB and through views it's been easy 
to make SOGo recognize the existing tables.

My problem:  seems like it's impossible to separate users per email domain (see 
for example 
http://mail.opengroupware.org/pipermail/sogo/2010-April/006105.html).

In SOGo, as far as I've seen, which sogo-domain will match, say, user 
j...@domain.com depends on which userSource j...@domain.com belongs to.  
Quoting Matto Marjanovic 
(http://mail.opengroupware.org/pipermail/sogo/2010-March/005843.html):

 A sogo-domain is basically a set of UserSources.  If a UID ('c_uid') is
 found in a UserSource, then the sogo-domain of the UID is considered to be
 whatever sogo-domain the UserSource belongs to.  One implication of this is
 that each UserSource must be used by a single sogo-domain.

Correct me if I'm wrong, but that means I cannot segregate users per domain 
because all of them belong to a single UserSource.  This would be quite a 
showstopper:  imagine users of ABC Company being able to browse usernames of 
their competitor XYZ Company in the sharing calendar or subscribe 
addressbook panel...

POSSIBLE SOLUTIONS

1)  I know I could use a couple of MySQL views to accomplish segregation, i.e. 
set one view per each domain, but it would be VERY inefficient (and would also 
uselessly pollute the database structure).  Imagine having 100 domains:  each 
login would produce 100 queries just to discover which one the user belongs to. 
 Weird.

2)  A slightly better way of handling this would be to declare a filter in the 
UserSource -- something like (domain = `mydomain.com`), but as far as I can 
tell filters work only with LDAP sources.

3)  The best solution would be to switch the sogo-domain according to the 
hostname or another http header.  I've tried for a couple of hours but couldn't 
make it happen (let me say SOGo documentation is not that clear about which key 
is used when switching the domain).  Am I missing something, or is it something 
not yet implemented in SOGo?

Thanks,
Corrado Fiore-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Script

[Corrado Fiore]

Il giorno 18/feb/2011, alle ore 11:59, Michael Crilly ha scritto:

 I've written a Perl script that I've found, so far, makes my life a lot 
 easier...

 If people would find this script useful, then I will refine the script and 
 add a lot of other support (logging, rollback, etc)

Wow.  I must say I'm impressed and I vote for this.

At the moment, I usually modify the GNUstep XML conf file by hand or using the 
Apple plist editor bundled with Mac OS x Developers' Tools and then pasting the 
resulting XML into the conf file.

While both method work, they're definitely ugly and there's always a chance 
that a mistyped character will make GNUstep wipe away your file during the next 
parsing.  Therefore you must always to keep a backup copy of your old file.  
Argh.

(Another issue that I find quite annoying is that sogod startup script doesn't 
have a 'reload' function just like httpd.  But I'm going off topic here.)

Is there an URL at which we can download your script?

Cheers,
Corrado Fiore-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] userPasswordAlgorithm problem

[Corrado Fiore]

Hi,

could you give us more details on your system, like which version of SOGo 
you're running, the kind of MD5 (plain or crypt-MD5)... ?

Can you see the queries SOGo is issuing to the SQL server, for example in a 
query log?

Without these details, it's difficult to give you any hints.

Regards,
Corrado


Il giorno 17/feb/2011, alle ore 10:00, Szasz Tamas ha scritto:

 Hi list!
 
 I have a problem configuring the sogo to use md5 for user passwords. 
 Before I have made the change of userPasswordAlgorithm to md5 the user could 
 log in to the system. 
 After the change from none to md5 the user couldn't login with the value of 
 md5 string. 
 This is a part from my config:
 
 [...]
 keydomain.com/key
 dict
 keySOGoMailDomain/key
 stringdomain.com/string
 keySOGoUserSources/key
 array
 dict
 keycanAuthenticate/key
 stringYES/string
 keyid/key
 stringdirectory/string
 keyisAddressBook/key
 stringYES/string
 keytype/key
 stringsql/string
 keyuserPasswordAlgorithm/key
 stringmd5/string
 keyviewURL/key
 
 stringpostgresql://sogo:sogo@localhost:5432/sogo/sogo_view/string
 /dict
 /array
 /dict
 [...]
 
 Thanks for any help,
 
 Szász Tamás

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

[SOGo] Alternate theme proposal

[Corrado Fiore]

Dear All,

following some remarks I appended to bug #758 
(http://www.sogo.nu/bugs/view.php?id=758), I decided to try some CSS 
modifications in order to fix some user interface annoyances and to take 
advantage of some features of modern browsers (like text-shadow).

I'd like to share the results of my work with both SOGo users and developers, 
in the hope that they can be incorporated in next releases of SOGo.

== HOW DOES IT LOOK? ==

A screenshot of this modified UI is available here:
http://www.corradofiore.it/files/sogo_alternate_theme_20110213.jpg

while the WebServerResources replacement folder can be downloaded here:
http://www.corradofiore.it/files/WebServerResources_1.3.5a_20110213.zip

You will need to unpack it and upload its contents to 
/usr/GNUstep/System/Library/SOGo/WebServerResources (assuming you're on CentOS, 
don't know if that's the same on Debian / Ubuntu)

== WHAT ARE THE CHANGES / ENHANCEMENTS? ==

*  Bigger font in the login panel

*  Top menu is taller and easier to click (following Fitt's Law).  The default 
height is really too low to be easily targeted by the mouse pointer.

*  Top menu and command bar fonts use text-shadow for better contrast with the 
background and easier readability

*  Reworked left column:
1)  Lighter background for better contrast
2)  Accounts' names are presented with a different font and no icon to make it 
easier for the user to spot them among other lines
3)  New icons without dotted lines = less clutter on the screen.  This mimics 
the appearance of all mail clients on Mac OS X and of RoundCube webmail.
4)  Selected folder is more visible (darker background, text-shadow)
5)  Used quota indicator is cleaner

*  Search input field has rounded corners (on Webkit / Gecko), to make it 
easier to spot it.

*  Drag handlers have gradient background with a slight 3D appearance, to make 
them stick out and hence afford dragging.  To be fair, the 3D appearance is 
probably not yet enough, but it's a start.

*  The selected message row features now a much more bright blue background, to 
make it easier to find (the benchmark for legibility was iTunes application).  
The background color is actually a CSS3 gradient.

*  Both HTML and text-only messages now are rendered in 16px Helvetica / 
Calibri / Arial font.  This is perhaps the most outstanding change from the 
original version and I think it deserves a bit of explanation.  As far as I'm 
concerned, email is my primary tool when I'm at work.  I must be able to read 
it with good speed even at 7 PM, after I've been in front of my monitors for 
ten hours, or in a train under far-from-optimal lighting.  Font-size is the 
primary tool to achieve easy and FAST reading under those conditions, and 
that's precisely why I bumped it up so much.  A bit of tuning will be needed 
under Windows XP, so your comments are welcome.

*  I changed also the default enter mode in CKeditor 
(http://docs.cksource.com/ckeditor_api/symbols/CKEDITOR.config.html#.enterMode) 
to make it use BR.  A one-line break is the expected result of hitting Enter 
in any email applications, that's it.

Any thoughts, suggestions or comments are welcome!

-- 
Corrado Fiore

___
Via Gramsci 16/M
20060  Cassina de' Pecchi MI - Italy
mail...@corradofiore.it
http://it.linkedin.com/in/corradofiore
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Mysql source w/ crypt broken after 1.3.5a upgrade?

[Corrado Fiore]

Il giorno 02/feb/2011, alle ore 03:04, Ludovic Marcotte ha scritto:

 A fix was just pushed - try the upcoming nightly builds.

Works perfectly now!  -Thanks.

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

Re: [SOGo] Mysql source w/ crypt broken after 1.3.5a upgrade?

[Corrado Fiore]

Dear All,

after a bit (well, several hours...) of investigation, I found that:

1)  md5 works flawlessly on my installation, while crypt does not.  So it's not 
a configuration problem.

2)  The code pre-1.3.5a, i.e. the one attached to bug report #703 
(http://www.sogo.nu/bugs/view.php?id=703) worked fine (I've been using it on 
1.3.4 without any problems).

3)  In 1.3.5 the crypt() code was modularized and moved to NSstring+Utilities.m:

 2010-12-29  Ludovic Marcotte  lmarco...@inverse.ca
 
   * Moved the string encryption code from SoObjects/SOGo/SQLSource.m
   to SoObjects/SOGo/NSString+Utilites.m

4)  Feel free to correct me if I'm wrong, but it seems to me that the new 
implementation doesn't use the right salt.

To perform a check against an existing md5-crypted password, you must fetch it 
from the DB and pass it as the second parameter to the crypt() function (the 
first will be the user-provided password to validate).  This is because the 
salt to use is embedded into the crypted password (if you're using md5-crypt, 
it's the substring that starts with $1$ and ends with $). The crypt() 
function will recognize the salt part automagically and use it to encode the 
user provided password.  If you look at the patch code, you'll see the 
following lines:

 buf = (char *) crypt([plainPassword UTF8String], [encryptedPassword 
 UTF8String]);
 NSString *s = [NSString stringWithUTF8String: buf];
 return [s isEqualToString: encryptedPassword];

In the new code (lines 548-556 from NSString-Utilities.m), the password to 
check is provided also as the second parameter:

 - (NSString *) asCryptString
 {
   char *buf;
   
   // The salt is weak here, but who cares anyway, crypt should not
   // be used anymore
   buf = (char *)crypt([self UTF8String], [self UTF8String]);
   return [NSString stringWithUTF8String: buf];
 }

Are my assumptions correct? Is this a bug?

Also, just out of curiosity, are there any users who upgraded to 1.3.5 and have 
a working crypt-based SQL authentication?

Thanks,
Corrado Fiore
mail...@corradofiore.it


Il giorno 30/gen/2011, alle ore 22:47, Corrado Fiore ha scritto:

 Dear All,
 
 yesterday I upgraded from 1.3.4 to 1.3.5a stable using Yum and the official 
 SOGo repository (I'm on CentOS with kernel 2.6.18-194.8.1.el5.028stab070.2).
 
 Source for authentication is an external MySQL database where passwords are 
 hashed using MD5-crypt (it's our Postfix backend).
 
 ** After applying the upgrade, login doesn't work anymore.  I keep getting 
 wrong username or password error. **
 
 What I did:
 •  Stopped SOGo / Memcached
 •  Issued % yum upgrade sogo as root
 •  Added OCSSessionsFolderURL to the defaults file
 •  Started daemons, with no success
 •  Noticed that issuing % yum update there were newer versions of Sope49-* 
 packages, upgraded them
 •  Restarted daemons, with no success.
 
 You can grab a copy of my GNUstep defaults file in XML format from 
 http://www.corradofiore.it/files/GNUstepDefaults.20110130.txt
 
 Installed packages:
 [root@sogo /]# rpm  -q -a | grep sope
 sope49-gdl1-contentstore-1.3.5a-1.el5
 sope49-core-4.9-20110127_1664.el5.1
 sope49-gdl1-mysql-4.9-20110127_1664.el5.1
 sope49-ldap-4.9-20110127_1664.el5.1
 sope49-sbjson-2.3.1-20110127_1664.el5.1
 sope49-cards-1.3.5a-1.el5
 sope49-xml-4.9-20110127_1664.el5.1
 sope49-gdl1-4.9-20110127_1664.el5.1
 sope49-appserver-4.9-20110127_1664.el5.1
 sope49-mime-4.9-20110127_1664.el5.1
 
 In the logfile I see:
 Jan 30 22:29:33 sogod [16158]: SOGoRootPage Login for user 
 'mail...@corradofiore.it' might not have worked - password policy: 65535  
 grace: -1  expire: -1  bound: 0
 
 ...and in the Mysql log:
 SELECT c_password FROM sogo_users WHERE c_uid = 'mail...@corradofiore.it'
 
 Thanks for any suggestions,
 Corrado Fiore
 
 __
 
 -- 
 users@sogo.nu
 https://inverse.ca/sogo/lists

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

[SOGo] Mysql source w/ crypt broken after 1.3.5a upgrade?

[Corrado Fiore]

Dear All,

yesterday I upgraded from 1.3.4 to 1.3.5a stable using Yum and the official 
SOGo repository (I'm on CentOS with kernel 2.6.18-194.8.1.el5.028stab070.2).

Source for authentication is an external MySQL database where passwords are 
hashed using MD5-crypt (it's our Postfix backend).

** After applying the upgrade, login doesn't work anymore.  I keep getting 
wrong username or password error. **

What I did:
•  Stopped SOGo / Memcached
•  Issued % yum upgrade sogo as root
•  Added OCSSessionsFolderURL to the defaults file
•  Started daemons, with no success
•  Noticed that issuing % yum update there were newer versions of Sope49-* 
packages, upgraded them
•  Restarted daemons, with no success.

You can grab a copy of my GNUstep defaults file in XML format from 
http://www.corradofiore.it/files/GNUstepDefaults.20110130.txt

Installed packages:
[root@sogo /]# rpm  -q -a | grep sope
sope49-gdl1-contentstore-1.3.5a-1.el5
sope49-core-4.9-20110127_1664.el5.1
sope49-gdl1-mysql-4.9-20110127_1664.el5.1
sope49-ldap-4.9-20110127_1664.el5.1
sope49-sbjson-2.3.1-20110127_1664.el5.1
sope49-cards-1.3.5a-1.el5
sope49-xml-4.9-20110127_1664.el5.1
sope49-gdl1-4.9-20110127_1664.el5.1
sope49-appserver-4.9-20110127_1664.el5.1
sope49-mime-4.9-20110127_1664.el5.1

In the logfile I see:
Jan 30 22:29:33 sogod [16158]: SOGoRootPage Login for user 
'mail...@corradofiore.it' might not have worked - password policy: 65535  
grace: -1  expire: -1  bound: 0

...and in the Mysql log:
SELECT c_password FROM sogo_users WHERE c_uid = 'mail...@corradofiore.it'

Thanks for any suggestions,
Corrado Fiore

__

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

[SOGo] Allowing remote images in webmail

[Corrado Fiore]

Dear All,

is there a way to make SOGo webmail show remote images by default, without 
requiring users to allow them manually for each message?  I know it's a 
security measure found in many clients, but I wonder how to configure the 
default behavior.

Thanks,
Corrado Fiore

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

[SOGo] Cannot define per-domain IMAP hosts

[Corrado Fiore]

Dear Sogo Users,

has anyone solved the bug described here 
http://www.mail-archive.com/users@sogo.nu/msg02609.html about IMAP hosts 
reverting to localhost if declaration is put inside a domain?
Basically, in GNUstep defaults (I'm using XML notation here), the 
SOGoIMAPServer declaration, i.e.

keySOGoIMAPServer/key
stringimap://imap.mydomain.com:143/string

won't be parsed when put into a domain block.
For example, the following declaration

keydomains/key
dict
keymydomain.com/key
dict
keySOGoMailDomain/key
stringmydomain.com/string
keySOGoIMAPServer/key
stringimap://imap.mydomain.com:143/string
 /dict
/dict

will be ignored and SOGoIMAPServer value will default to localhost.  Works 
flawlessly if put outside.
The above could be a problem in a large deployment where multiple IMAP backends 
(possibly one per domain) are used.
My test setup:  SOGo 1.3.4 w/ MySQL 5 datasource on CentOS 5.4 32bit w/ 1 GB 
ram.

Thanks for any suggestions.

Best,
Corrado Fiore-- 
users@sogo.nu
https://inverse.ca/sogo/lists