Koozali.org: home of the SME Server

SOGO for Sme

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #60 on: March 23, 2010, 02:21:10 PM »
If anyone wants to follow the nightly releases you can do so by adding:

db yum_repositories set sogo-nightly-rhel5 repository \
BaseURL http://inverse.ca/downloads/SOGo/RHEL5/nightly/i386 \
EnableGroups yes \
GPGCheck no \
Name "Inverse SOGo nightly-build Repository" \
Visible yes \
status disabled

then:

signal-event yum-modify

followed by:

yum upgrade --enablerep=sogo-nightly-rhel5 sogo

finally:

/etc/init.d/sogod restart

Remember using the nightly updates should only be used in testing environment only.
--[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 alefattorini

  • **
  • 61
  • +0/-0
  • www.nethserver.org
    • www.nethserver.org
Re: SOGO for Sme
« Reply #61 on: April 07, 2010, 10:52:46 AM »
Is there anyone that are working on funambol integration?
We have make it works, but there is some problem for make all automatic with template and events.
Post your test please :-)
Thank you

Offline byte

  • *
  • 2,183
  • +2/-0
Re: SOGO for Sme
« Reply #62 on: April 07, 2010, 05:00:24 PM »
We have make it works, but there is some problem for make all automatic with template and events.

The only problem I found is the tasks do not update correctly, two way calendar syncs fine, although the free/busy url fails to work at the moment.
--[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 daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #63 on: April 27, 2010, 12:46:16 AM »
Has anyone had good success with installing the funambol server per the Sogo instructions?  I'm looking at testing this and wondered if someone has had success and made some notes on what to do.  My hope is I can use funambol to connect outlook to Sogo as well as blackberry and smartphones to the shared data.  It doesn't appear that funambol is installed as part of the installation as provided by the wiki.

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #64 on: April 29, 2010, 04:14:05 PM »
Has anyone had good success with installing the funambol server per the Sogo instructions?  I'm looking at testing this and wondered if someone has had success and made some notes on what to do.  My hope is I can use funambol to connect outlook to Sogo as well as blackberry and smartphones to the shared data.  It doesn't appear that funambol is installed as part of the installation as provided by the wiki.

I have installed Funambol. I added the writeup in the Wiki http://wiki.contribs.org/Funambol

In this installation I have Funambol working successfully by itself and am currently using it to sync my Nokia E61i with the Symbian Funambol connector with Thunderbird 3 with the Funambol connector. With my phone, I could not get the SOGO connector to work. Seems to be some sort of bug in the SOGO connector (or my phone is too old :-) ).

Good luck. If you find any issues with the description, please update it there for the benefit of others.

Cheers,

Marco
Adelaide - Australia

Offline daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #65 on: May 03, 2010, 09:03:39 PM »
Mark,
Thanks for the wiki instructions.  I've tried following them to the letter but I have questions:

You stated: MySQL Engine : Also in /usr/lib/Funambol/bin/funambol change COMED=true  to COMED=false somewhere around line 50 while you're at it

Should /usr/lib/Funambol be /opt/Funambol?  I didn't find any /usr/lib/Funambol in my installation.

Should all the xml templates be made 3 levels deep?  You have
mkdir -p /etc/e-smith/templates/opt/Funambol/config/sogo/sogo/sogo/sogo-cal.xml.  Shouldn't the xml template be created in /opt/Funambol/sogo/sog-cal.xml instead of the additional 2 sogo levels?  I had to manually create the 3 levels of sogo folder in order for the templates to expand into.

And you mention in the funambol connector the server should be "http://<server_domain_name>:8080/funambol/ds
".  But where does port 8080 get created, turned on, opened up?  I see nothing that does that in apache to point to the funambol location.

Thanks for your help, hopefully we can make this a great contrib someday!



Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #66 on: May 05, 2010, 07:10:32 AM »
I rechecked my Funambol installation and I have updated the Wiki and cleared up some items that may be confusing (or were incomplete), so please check there (and feel free to update/correct/add/etc.).

Yes everything is in /opt/Funambol

The XML files were originally created through the funambol admin tool (from a remote PC) and the sogo/sogo/sogo directories were a result of that. I just took them and made them into a template so that the SOGO database password could be reused and auto inserted in the XML file.

You won't find port 8080 in the apache config because Funambol is a Tomcat application.

And all together, even though my Funambol installation seems to work, the connection to SOGO still seems to be malfunctioning. Have not figured that out yet. :-(

Adelaide - Australia

Offline daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #67 on: May 05, 2010, 08:15:27 AM »
Thanks for the update, I'll look at your notes when I have some time. 
Quote
And all together, even though my Funambol installation seems to work, the connection to SOGO still seems to be malfunctioning. Have not figured that out yet. :-(

Would this have something to do with your problem?  Since as you said its a tomcat issue, the link http://wiki.contribs.org/Tomcat shows these commands at the end
Quote
config set tomcat service access public status enabled TCPPort 8080
signal-event remoteaccess-update


Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #68 on: May 05, 2010, 09:09:12 AM »
Would this have something to do with your problem?

No, it is not. I can access Funambol alright as it is on a separate clean test machine (no other software), but when I try to access the sogo connection items it spits the dummy with a lot of cryptic message in the log that I don't understand yet. It could still be something wrong with the last bits of the configuration.

But you should get a fair way with the Wiki instructions now.
Adelaide - Australia

Offline daniel

  • ***
  • 146
  • +0/-0
  • Platinum Sponsor
    • http://www.charton-mgmt.com
Re: SOGO for Sme
« Reply #69 on: May 05, 2010, 06:20:01 PM »
I followed through the wiki again to make sure A. its understandable, and B. it works.  Thanks for the additional information, I had made two assumptions that were incorrect before.  Now onto the next issue

I am using phpmyamdin to view mysql databases.  I see the funambol database there, but there are no tables inside of it.  I don't know what step creates the tables inside.  I thought maybe this step should have: 
Quote
Next, install the Funambol SOGo Connector within Funambol server by issuing the following commands :

cd /opt/Funambol/
./bin/install
would setup tables in the mysql funambol.  If its suppose to, it doesn't.  I can see the SOGO database and its creating tables with data from using the SOGo web interface.

Offline Marco Hess

  • *
  • 149
  • +0/-0
    • http://www.through-ip.com
Re: SOGO for Sme
« Reply #70 on: May 06, 2010, 01:34:59 AM »
That's right, the ./bin/install is were all the tables are created.

This was an area where I needed to back and forth a couple of times. When things go wrong, there are some error messages that give a bit of a clue as to where it goes wrong. e.g. mysql driver is use, access denied/refused, unable to create table, etc.

One area that could stop the tables being created is the right MySQL configuration.

You might want to try setting the MySQL configuration with a post-upgrade & reboot (even though the MySQL documentation here http://wiki.contribs.org/MySQL does not say we need that), but this is one of the things I ended up doing:

 
Code: [Select]
/sbin/e-smith/config setprop mysqld InnoDB enabled
 /sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
 signal-event post-upgrade; signal-event reboot
I also dropped and recreated the funambol database between attempts of the ./bin/install
Adelaide - Australia

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SOGO for Sme
« Reply #71 on: May 06, 2010, 10:13:28 AM »
but this is one of the things I ended up doing:
Code: [Select]
/sbin/e-smith/config setprop mysqld InnoDB enabled
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
signal-event post-upgrade; signal-event reboot
I guess they are needed because the install script does not use socket based connections, but connections to a port (3306 I guess) as well as requiring the InnoDB table engine which is not available on SME Server by default. Is that not in the documentation somewhere?
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 #72 on: May 06, 2010, 10:48:35 AM »
InnoDB is definitely needed and I suspect the networking thing as well. It works however without having to specify the 3306 port number in the JDBC connection setup.

The thing I am not sure/clear on is that the MySQL documentation http://wiki.contribs.org/MySQL indicates that just the expand of the template and the restart of the service is required to activate these options.

I could not get it to work however and after I did a post-upgrade and reboot it allowed me do the install and the access to the MySQL database was successful. But due to this confusion I left the expand & restart statements in the Wiki description instead of the post-upgrade/reboot.
« Last Edit: May 06, 2010, 10:50:34 AM by Marco Hess »
Adelaide - Australia

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: SOGO for Sme
« Reply #73 on: May 06, 2010, 06:53:35 PM »
The thing I am not sure/clear on is that the MySQL documentation http://wiki.contribs.org/MySQL indicates that just the expand of the template and the restart of the service is required to activate these options.
It should, if not it is worth a bug report to investigate what is/went wrong.
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 #74 on: May 07, 2010, 03:50:04 AM »
I made some minor updates and re-sequenced some parts of the recipe in  http://wiki.contribs.org/Funambol and upto item 14 everything should install without a hitch when followed by the letter (cut and past from the webpage into your terminal screen is easiest).

Have yet to confirm the final SOGo integration bits but feel free to have a go.

Cheers,

Marco
« Last Edit: May 07, 2010, 05:46:59 AM by Marco Hess »
Adelaide - Australia