Koozali.org: home of the SME Server

SOGO for Sme

Offline daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #75 on: May 07, 2010, 02:35:07 PM »
I'm still having issues with funambol not even building the database in mysql.  I'm going to step back and look at it fresh later.

I believe this
Quote
The default Funambol admin password is sa. This can be changed with the admin-password utility.

Edit /opt/Funambol/bin/admin-password

vim /opt/Funambol/bin/admin-password

Should actually reference admin-passwd. 

I think I'll reformat and start with a new fresh 8.0b5 server tomorrow and try your sogo/funambol connection again. 

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #76 on: May 07, 2010, 03:59:36 PM »
Thanks for spotting the passwd typo :)

I am doing all my testing with a VMware image and use the Revert to Snapshot snapshot feature to quickly revert the image to a pristine installation with a couple of users and configuration settings setup already so I can login immediately with a Putty session. Way easier than a real hardware re-install. With the cut and past between the webpage and the terminal window, the Funambol installation as described can be done in under 10minutes or so.

In my last attempt I also got some SOGo sync with the calendar but not with contacts. I had to go in on the admin interface (from a separate PC) and recreate the sogo xml files and then reexpand the SME templates. I need to check why that syncing did not happen immediately with the files and templates as described. Maybe some other config items gets set that I have not discovered yet.
Adelaide - Australia

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #77 on: May 08, 2010, 09:42:58 AM »
Turns out that when you use the funambol-admin tool to create the sync sources as described in the SOGo documentation, besides the XML config files, this also creates a couple of entries in a table in the funambol database (fnbl_sync_source table).

Until these entries exist, funambol will not recognise the sync source XML files as they are described and templated in the Funambol Wiki installation recipe  :-(.

So all I need now is a way of adding a few entries in that database table from a script to get a fully scripted install. The information needed is something like:

uriconfignamesourcetype
sogo-calsogo/sogo/sogo/sogo-cal.xml sogo-calsogo
sogo-cardsogo/sogo/sogo/sogo-card.xml sogo-cardsogo
sogo-todosogo/sogo/sogo/sogo-todo.xml sogo-todosogo

In SQL this is probably something like this:

Code: [Select]
INSERT INTO `fnbl_sync_source` (`uri`, `config`, `name`, `sourcetype`) VALUES
('sogo-cal', 'sogo/sogo/sogo/sogo-cal.xml', 'sogo-cal', 'sogo'),
('sogo-card', 'sogo/sogo/sogo/sogo-card.xml', 'sogo-card', 'sogo'),
('sogo-todo', 'sogo/sogo/sogo/sogo-todo.xml', 'sogo-todo', 'sogo');


« Last Edit: May 08, 2010, 10:05:48 AM by Marco Hess »
Adelaide - Australia

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SOGO for Sme
« Reply #78 on: May 08, 2010, 09:48:20 AM »
So all I need now is a way of adding a few entries in that database table from a script to get a fully scripted install.
Perhaps you can generate the SQL based on a template. Create an action script to feed the queries from the template into the database. Tie both of them to an event, e.g. funambol-sync-create and fire that event.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #79 on: May 08, 2010, 10:22:56 AM »
Wiki is updated with the SQL insert commands. Still need to validate that this is now all that is required.

UPDATE: Can report that from a clean Funambol 8.0 install with the SQL insert statements as per Wiki recipe I now successfully synced calendar and contacts with SOGo.
« Last Edit: May 08, 2010, 10:54:16 AM by Marco Hess »
Adelaide - Australia

Offline daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #80 on: May 11, 2010, 07:42:18 PM »
Wow, after doing and redoing some stuff, I have funambol sycing with SOGo.  Thanks to everyone for the wiki instructions.

To make this a production grade product, I would suggest the following:
1.  Set the web interface default language to English (or whatever language) instead of choosing each time.
2.  Create a secured connection to Funambol everytime.  Block unsecured Funambol Connection.
3.  Ical doesn't seem to work.  According to the SOGo documentation https://host.domain.com/SOGo/dav/{username} should produce an ical.  It doesn't seem to work on this installation.
4.  Cannot sync multiple calendars in Sogo to calendars on Outlook via Funambol

I'm sure at some point someone will be able to get an RPM package together for Funambol for SOGo and not have to do all these steps.  Just curious, has anyone synced SOGo and blackberry or active sync phones?

Seems SOGo and Zarafa are the two top contenders for an Exchange like replacement.

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #81 on: May 11, 2010, 08:20:24 PM »
To make this a production grade product, I would suggest the following:
1.  Set the web interface default language to English (or whatever language) instead of choosing each time.

If you don't choose a language SOGo automatically assumes your language is English, so you don't actually have to change each time.
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #82 on: May 13, 2010, 01:30:59 PM »
Wiki is updated with the SQL insert commands. Still need to validate that this is now all that is required.

UPDATE: Can report that from a clean Funambol 8.0 install with the SQL insert statements as per Wiki recipe I now successfully synced calendar and contacts with SOGo.

Marco, does your free/busy work fine ? I see 401 errors in my sogo.log

localhost - - [13/May/2010:12:27:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.003 - - 0
localhost - - [13/May/2010:12:28:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.002 - - 0
localhost - - [13/May/2010:12:29:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.003 - - 0
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #83 on: May 13, 2010, 01:36:32 PM »
Marco, does your free/busy work fine ? I see 401 errors in my sogo.log

Both SOGo and Funambol are quite new for me too. I really don't know. Have not really looked at that.

Adelaide - Australia

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SOGO for Sme
« Reply #84 on: May 13, 2010, 01:39:39 PM »
Marco, does your free/busy work fine ? I see 401 errors in my sogo.log

localhost - - [13/May/2010:12:27:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.003 - - 0
localhost - - [13/May/2010:12:28:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.002 - - 0
localhost - - [13/May/2010:12:29:43 GMT] "GET /SOGo/dav/joe/freebusy.ifb HTTP/1.1" 401 0/0 0.003 - - 0
401 errors normally indicate authorization problems: http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.2
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #85 on: May 13, 2010, 01:40:47 PM »
Both SOGo and Funambol are quite new for me too. I really don't know. Have not really looked at that.

I should mention that I'm using Outlook 2007 and configured funambol client for Outlook to sync contacts,cal,tasks and under Tools > Options > Calendar Options > Freebusy Options, I've used:

https://<doman-name>/SOGo/dav/%NAME%/freebusy.ifb

I'll see if I get any further if so I'll post back.
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #86 on: May 13, 2010, 01:44:18 PM »
401 errors normally indicate authorization problems: http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.2

Correct, but I don't have option in Outlook 2007 for enter user/pass details, while entering the url:

https://<domain-name>/SOGo/dav/%NAME%/freebusy.ifb

(and substituted %NAME% for joe)

I can download the freebusy file as the browser asks for the user/pass credentials.

Thanks both.
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SOGO for Sme
« Reply #87 on: May 13, 2010, 01:48:58 PM »
Correct, but I don't have option in Outlook 2007 for enter user/pass details, while entering the url:
Not sure, but perhaps this might help:
http://support.microsoft.com/kb/291621
http://support.microsoft.com/kb/827775

Could it be Outlook uses the configured username and password associated with the main/default account?
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline kevinb

  • *
  • 237
  • +0/-0
Re: SOGO for Sme
« Reply #88 on: May 13, 2010, 04:52:36 PM »
Just a blind man taking a stab in the dark .... have you tried https://username:password@hostname/SOGo/dav/%NAME%/freebusy.ifb to pass credentials?
 
Kevin

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #89 on: May 13, 2010, 05:51:02 PM »
Just a blind man taking a stab in the dark .... have you tried https://username:password@hostname/SOGo/dav/%NAME%/freebusy.ifb to pass credentials?
 
Kevin

Hi Kevin,

I did think to try that earlier but its only applicable to ftp:

Thanks for the thought!
--[byte]--

Have you filled in a Bug Report over @ http://bugs.contribs.org ? Please don't wait to be told this way you help us to help you/others - Thanks!