Topic: Horde - Funambol and exchange replacement

[daniel]

I know this topic has been discussed in part in several past threads, but I'd like to share what I've uncovered so far today.

I have a test SME 7.3 server and using the Horde Rpms from John Bennett's work.  I'm testing with kronolith (calendar) Nag (tasks) Mnemo (notes) and turba (contacts).  With one change I was able to get the funambol client plugin to work and sync outlook on a PC with Horde on SME 7.3.  Changing the realm setting in /home/httpd/html/horde/imp/config/servers.php  from @domainname.com to nothing, tags all items in the horde tables to username instead of username@domainname.com.  Then funambol can sync with the horde tables and everything shows up in both places.  Yippeee!!!!

Further reading of the servers.php.dist shows the following code:

$servers['exchange'] = array(
    'name' => 'Exchange 5.5 server',
    'server' => 'exchange.example.com',
    'hordeauth' => false,
    'protocol' => 'imap',
    'port' => 143,
    'maildomain' => '',
    'smtphost' => 'smtp.example.com',
    'realm' => '',
    'preferred' => '',
);

Would this code allow horde to emulate an exchange server or does that mean horde could attach to an exchange server running on a MS box somewhere?

Also would turning on ACL support in Horde allow for public and shared folders to follow the ACL support if SME is set as a domain controller?  This is what servers.php.dist says.

* acl: Use this if you want to use Access Control Lists (folder sharing)
 *      Set 'driver' equal to the type of ACL your server supports and
 *      'params' to an array containing any additional parameters the
 *      driver needs. Not all IMAP servers currently support this
 *      feature.
 *

It seems more and more of my people are wanting MS Outlook and I can't seem to move the tide to another direction.  Whatever I can do to make an SME server to do more things MS servers do the easier my server management functions will be.

Thanks to everyone for the great work on SME.

[Stefano]

I know this topic has been discussed in part in several past threads, but I'd like to share what I've uncovered so far today.

I have a test SME 7.3 server and using the Horde Rpms from John Bennett's work.  I'm testing with kronolith (calendar) Nag (tasks) Mnemo (notes) and turba (contacts).  With one change I was able to get the funambol client plugin to work and sync outlook on a PC with Horde on SME 7.3.  Changing the realm setting in /home/httpd/html/horde/imp/config/servers.php  from @domainname.com to nothing, tags all items in the horde tables to username instead of username@domainname.com.  Then funambol can sync with the horde tables and everything shows up in both places.  Yippeee!!!!

Hi

could you please write down an how-to to achieve it?

TIA

Ciao
Stefano

[daniel]

Let me state first, this is not for production, I'm testing and there are still many things to do yet to make it completely stable.  I don't want to write a full howto yet because I think it still needs alot of finishing.  Here's what I've done so far.

Build a stock 7.3 server

Add and update kronolith, nag, mnemo, turba, gollem, with yum to the server from the smetest repo. I also made reference to this http://wiki.horde.org/RHEL3PearHowTo?referrer=HowTo#

Verify all of that is working.

Remark out the realm line in /home/httpd/html/horde/imp/config/servers.php.  NOTE:  This should be templated or added as a DB variable before ever going into production.

Add funambol to a WinXP running Outlook (2000-2003,XP)
Configure funabol from this reference:
http://wiki.horde.org/SyncHowTo?referrer=HowTo#

Contacts are still not syncing but the Horde Tables need modification, I'm about to test this to see how well it works.  Reference here http://wiki.horde.org/TurbaOutlook2003?referrer=HowTo#

Once all this is tested and working, I'll add funambol to a smartphone device to see how well it syncs with Horde.

I hope this helps the community.  There is certainly a real need to outlook interface with  a linux based server for the business communities worldwide.  Now with MS Vista having calendar.tasks also built into it, theres even more a need for synchronization. 

[dmay]

You should raise this topic on the Developers mailing list.

Darrell

[daniel]

Good point, how might one do that?

[dmay]

Click the LISTS menu item above. Then navigate to here:

http://lists.contribs.org/mailman/listinfo/devinfo

Darrell

[mrjhb3]

http://bugs.horde.org/ticket/6749

http://bugs.horde.org/ticket/6746

John

[pwalter]

<snip>
I don't want to write a full howto yet because I think it still needs alot of finishing.
</snip>

danielr, is it time to write a howto yet? There are a lot of people interested in this.

[David Harper]

I've been testing this as well, and coincidentally the note here about the modifications to server.php should be a workaround for the last problem I've been having with regards to Funambol - see http://bugs.contribs.org/show_bug.cgi?id=4772, although this refers to 7.4, as Horde 3.2 is required.

I am interested in writing a HowTo for a shared company address book, calendar, task list and note list, but we need to iron the bugs out so users do not have to fiddle with the underlying code. I'm not sure about IMAP permissions and all that, but certainly if Funambol works with Horde out of the box then you can easily have a shared company address book etc.

[mrjhb3]

I am interested in writing a HowTo for a shared company address book, calendar, task list and note list, but we need to iron the bugs out so users do not have to fiddle with the underlying code. I'm not sure about IMAP permissions and all that, but certainly if Funambol works with Horde out of the box then you can easily have a shared company address book etc.

Creating a shared anything is as easy as creating a new address book, calendar, etc. and granting permissions to all authenticated users.  Then, all authenticated users will be able to see the calendar.  If you grant them all permissions, then they can edit/modify, etc.

John

[David Harper]

In webmail, sure, but we are talking about Outlook synchronisation.

[pwalter]

I am interested in writing a HowTo for a shared company address book, calendar, task list and note list, but we need to iron the bugs out so users do not have to fiddle with the underlying code.

My primary interest is in getting to my data from my Windows Mobile smartphone, my desktop, and the web while storing the data only once in Horde. I am willing to collaborate with others on writing / testing a HowTo on getting SME 7.3, Horde, Funambol, and Outlook 2003/2007 to work together. Are you interested in / have you tried anything like that?

[David Harper]

It won't work on SME 7.3, as Horde is only at version 3.2. But Outlook synchronisation does work on 7.4 if we disable realms - I have tried it and it works seamlessly once the necessary custom template is in place.

[mrjhb3]

The realm has been configured since the early days of SME.  But since SME doesn't allow you to create an identical username for virtual domains (i.e. user1@1domain1.com and user1@domain2.com), the use of the realm really isn't needed and doesn't add any value. 

If you need to have a user1 at multiple domains, then you can create pseudonyms for
this.

So, what could be done is someone raise a bug report to either remove the realm altogether or possibly move the realm to a db setting.  But, as stated, a db setting won't add any value since we don't need a realm at all.  Regardless of what is done, the big thing will be working on the mysql changes to the horde_prefs table to remove the @domain.com entries from that table.  Then sync could work for all that want to use it.


John
John

[shawnbishop]

Hi David

You said you had this working on 7.4, could you give  a detailed How To?, or I can write the How to and test and then put it onto the Wiki, this would be very interesting for all my users, who want the calendering and address book feature discussed above