Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: alefattorini on March 02, 2010, 05:33:37 PM

Title: SOGO for Sme
Post by: alefattorini on March 02, 2010, 05:33:37 PM
We have made rpm for Sme, install notes here:
http://smeserver.nethesis.it/sogo/

What's sogo?
http://www.scalableogo.org

Your Comments Are Appreciated
Title: Re: SOGO for Sme
Post by: kevinb on March 02, 2010, 08:40:32 PM
WOOHOO !!!!
 
I have been waiting for this day!
 
Unfortunately it will be several weeks before I can test this.
 
Alessio, do you want to create a Wiki entry for this? If not I will.
 
How do you authenticate? LDAP? SQL?
 
What database do you use? SME Mysql? Postgresql?
 
Thanks,
 
Kevin
Title: Re: SOGO for Sme
Post by: Stefano on March 02, 2010, 09:09:47 PM
WOOHOO !!!!
 
I have been waiting for this day!
 
Unfortunately it will be several weeks before I can test this.
 
Alessio, do you want to create a Wiki entry for this? If not I will.
 
How do you authenticate? LDAP? SQL?
 
What database do you use? SME Mysql? Postgresql?
 
Thanks,
 
Kevin

Kevin, Alessio forgot to say that the rpms are only for SME8 :-)
Title: Re: SOGO for Sme
Post by: alefattorini on March 03, 2010, 09:20:00 AM
Kevin, Alessio forgot to say that the rpms are only for SME8 :-)
Title: Re: SOGO for Sme
Post by: daniel on March 03, 2010, 05:37:16 PM
Working on setting up sogo on my test 8beta4 server. 

Found these problems so far with the instructions at http://smeserver.nethesis.it/sogo/
The Sogo repo BaseURL didn't work, I had to manually change it from http://inverse.ca/downloads/SOGo/RHEL5/$basearch to http://inverse.ca/downloads/SOGo/RHEL5/i386 in order to see the rpms.

#yum install smeserver-sogo --enablerepo=nethsme --enablerepo=sogo

This shows 18 packages to install but before they start installing I get this message
Package sope49-cards-1.2.1-1.e15.i386.rpm is not signed

No further installation occurs.

I did follow the procedure
# wget http://smeserver.nethesis.it/releases/RPM-GPG-KEY-nethesis
# rpm --import RPM-GPG-KEY-nethesis

Do I need another key from the sogo server to make this install work?  What next?

Title: Re: SOGO for Sme
Post by: alefattorini on March 03, 2010, 06:03:30 PM
Sorry, "GPGCheck no" for sogo repository, they'are not signed. I have fixed it

# db yum_repositories set sogo repository \
      BaseURL http://inverse.ca/downloads/SOGo/RHEL5/$basearch \
      EnableGroups yes \
      GPGCheck no \
      Name "Inverse SOGo Repository" \
      Visible yes \
      status disabled
Title: Re: SOGO for Sme
Post by: daniel on March 03, 2010, 07:23:16 PM
Thank you, that took care of the install issue.  I now have a SOGo install on my test server.  My issue now is it will not let me login with any of the two test users I have in the system. 
I have e-smith-ldap-5.2.0-3.el5.sme.noarch installed, so if SOGo is using LDAP I must have something set wrong.  I checked the mysql SOGo databases to see if I could figure out what username and password I could login with, there is no data in the sogo user profile table.

I'm at a loss as to how to authenticate into SOGo and go from here.  What can I check next?
Title: Re: SOGO for Sme
Post by: daniel on March 03, 2010, 07:29:15 PM
Further Information.
I checked my messages log and found this each time I try to login.
Mar  3 13:26:55 linux slapd[4275]: conn=2 fd=11 ACCEPT from IP=127.0.0.1:60798 (IP=0.0.0.0:389)
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=0 BIND dn="cn=root,dc=charton-mgmt,dc=com" method=128
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=0 BIND dn="cn=root,dc=charton-mgmt,dc=com" mech=SIMPLE ssf=0
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=0 RESULT tag=97 err=0 text=
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=1 SRCH base="dc=charton-mgmt,dc=com" scope=2 deref=0 filter="(uid=danielr)"
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=1 SRCH attr=dn
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=1 SEARCH RESULT tag=101 err=32 nentries=0 text=
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=2 UNBIND
Mar  3 13:26:55 linux slapd[4275]: conn=2 fd=11 closed

I'm guessing LDAP is working, just giving back an error that SOGo won't accept. 
Title: Re: SOGO for Sme
Post by: cactus on March 03, 2010, 09:24:52 PM
Mar  3 13:26:55 linux slapd[4275]: conn=2 op=1 SEARCH RESULT tag=101 err=32 nentries=0 text=
LDAP might be working but error code 32 normally means no entry found, hence nentries is set to zero as well.

Perhaps your filter is incorrect as I am not sure if the username is stored in the uid field, or your search DN is incorrect.
Title: Re: SOGO for Sme
Post by: daniel on March 03, 2010, 10:41:00 PM
Thanks Cactus,

Looks like I have an LDAP issue.  I've installed the latest e-smith-LDAP with
# yum install e-smith-ldap --enablerepo=smetest --enablerepo=smeupdates-testing --exclude=*+ldap
I also installed the phpldapadmin.  This tells me"    ?    dc=charton-mgmt,dc=com  This base entry does not exist.Create it? "  Of course create won't do anything but I would assume I have a problem with LDAP in V8beta4 somewhere based on that message.   I'll have to do some more testing to see where the LDAP issue is.    Does anyone know of any quick commands to see if LDAP is working right on SME8Beta4.  I'm not an expert on LDAP, yet.    :)
Title: Re: SOGO for Sme
Post by: cactus on March 04, 2010, 07:24:05 AM
Code: [Select]
yum install e-smith-ldap --enablerepo=smetest --enablerepo=smeupdates-testing --exclude=*+ldap
Why did you exclude other related (and most likely needed) *+ldap packages?
Title: Re: SOGO for Sme
Post by: Daniel B. on March 04, 2010, 07:29:53 AM
Because the *+ldap packages are not needed anymore to get basic LDAP auth working in SME8. See http://bugs.contribs.org/show_bug.cgi?id=5720.

Regards.
Title: Re: SOGO for Sme
Post by: daniel on March 04, 2010, 01:05:28 PM
I was following the wiki instructions
http://wiki.contribs.org/LDAP
Title: Re: SOGO for Sme
Post by: daniel on March 04, 2010, 04:16:29 PM
Not sure why, but today after adding a new user in SME, LDAP is working to where SOGo is authenticating to LDAP for all existing users.   Thanks to Alessio for the contrib and howto.  Now once we get a good outlook connector to SOGo then we have a good exchange replacement contender.
Title: Re: SOGO for Sme
Post by: Stefano on March 04, 2010, 04:25:01 PM
Not sure why, but today after adding a new user in SME, LDAP is working to where SOGo is authenticating to LDAP for all existing users.   Thanks to Alessio for the contrib and howto.  Now once we get a good outlook connector to SOGo then we have a good exchange replacement contender.

a little OT but: AFAIK the project of a outlook connector for SOGO is aborted.. I read in the SOGO's ML that the choice is funambol 
Title: Re: SOGO for Sme
Post by: kevinb on March 04, 2010, 09:01:42 PM
I believe Zidelook (?) was the Outlook plugin (paid) that worked with Groupdav and thus SOGO.
 
I have not been impressed with stability of the Funambol Outlook and Thunderbird plugins.
 
The real jewel here is the use of Thunderbird with the SOGO connector. TB users can share contacts and calendars rather simply and it has been pretty robust. SOGO and Thunderbird are a pretty good free replacement for Exchange and Outlook.
 
Kevin
Title: Re: SOGO for Sme
Post by: alefattorini on March 05, 2010, 09:21:03 AM
Thank you, that took care of the install issue.  I now have a SOGo install on my test server.  My issue now is it will not let me login with any of the two test users I have in the system. 
I have e-smith-ldap-5.2.0-3.el5.sme.noarch installed, so if SOGo is using LDAP I must have something set wrong.  I checked the mysql SOGo databases to see if I could figure out what username and password I could login with, there is no data in the sogo user profile table.

I'm at a loss as to how to authenticate into SOGo and go from here.  What can I check next?

you need e-smith-ldap-5.2.0-5.sme
5.2.0-10.el5.sme is better :-)
Title: Re: SOGO for Sme
Post by: alefattorini on March 05, 2010, 09:58:23 AM
a little OT but: AFAIK the project of a outlook connector for SOGO is aborted.. I read in the SOGO's ML that the choice is funambol

No connector :-( only funambol.
Title: Re: SOGO for Sme
Post by: alefattorini on March 05, 2010, 10:01:09 AM
I have modified the notes

Update ldap

# yum update e-smith-ldap --enablerepo=smeupdates-testing

Smeserver 8 iso will have e-smith-ldap-5.2.0-19, then we don't create any dependencies
Title: Re: SOGO for Sme
Post by: soprom on March 07, 2010, 05:59:15 PM

Thanks for this great contribution!
Title: Re: SOGO for Sme
Post by: byte on March 09, 2010, 02:02:53 PM
Just a few notes to add:

After adding the repos you need to run:

signal-event yum-modify

before:

yum --enablerepo=nethsme install smeserver-sogo

Otherwise yum will complain about no repo found "nethsme"

And from SME Server 8b5 you don't need to do:

yum update e-smith-ldap --enablerepo=smeupdates-testing

Interesting contrib otherwise, thanks.
Title: Re: SOGO for Sme
Post by: Daniel B. on March 09, 2010, 02:52:42 PM
Hi.

Where can we find the srpm for smeserver-sogo ?

The contrib works, but I'd like to send some patches to enhance it (there's some security issue).

Regards.
Title: Re: SOGO for Sme
Post by: alefattorini on March 11, 2010, 09:26:04 AM
Just a few notes to add:

After adding the repos you need to run:

signal-event yum-modify

....

Thanks for notes, i have updated.
Title: Re: SOGO for Sme
Post by: tec on March 11, 2010, 10:26:06 PM
Thanks for adding the source rpm to your repo :)
Title: Re: SOGO for Sme
Post by: alefattorini on March 12, 2010, 09:18:09 AM
Thanks for adding the source rpm to your repo :)

You're welcome.
Title: Re: SOGO for Sme
Post by: byte on March 12, 2010, 04:43:52 PM
Hi,

What connectors are you all using with TB as the SOGo connector isn't compatible with TB 3.0.3 (only TB 2.0) and the Outlook Funambol Sync Client is too unstable.

Do you only use the web front as your mail/calender client ?

Thanks.
Title: Re: SOGO for Sme
Post by: alefattorini on March 12, 2010, 05:25:36 PM
Hi,

What connectors are you all using with TB as the SOGo connector isn't compatible with TB 3.0.3 (only TB 2.0) and the Outlook Funambol Sync Client is too unstable.

Do you only use the web front as your mail/calender client ?

Thanks.

We are using TB 2.0 and we'll wait for 3 version.
Title: Re: SOGO for Sme
Post by: guggel on March 12, 2010, 10:07:39 PM
Thats great stuff!

I tried Sogo on debian and ubuntu, makes me :(

In my hopelesness i searched google for hours, and find this thread. I installed SME 8beta5 in VM, touch the repositories and... it works!

Thank u so much! It makes me living with laughing...again :D

guggel

Title: Re: SOGO for Sme
Post by: stephen noble on March 13, 2010, 09:42:12 AM
added to wiki

http://wiki.contribs.org/Sogo

I've switched from zarafa to sogo, thanks
Title: Re: SOGO for Sme
Post by: alefattorini on March 15, 2010, 09:13:07 AM
added to wiki

http://wiki.contribs.org/Sogo

I've switched from zarafa to sogo, thanks

thank you, great news!
Title: Re: SOGO for Sme
Post by: mdo on March 16, 2010, 06:09:11 AM
What is the best place to discuss testing progress (and issues)?

Any activity like adding a calendar, changing access lists, etc. seems to generate a system email to inform of the change (very nice). These 'system emails'  here all have a small syntax error which makes the email undeliverable. E.g.

Final-Recipient: rfc822; "Susanne Doerner <susanne"@ht.co.nz
Should be: "Susanne Doerner" <susanne@ht.co.nz>

Final-Recipient: rfc822; "Michael Doerner <michael"@ht.co.nz
Should be: "Michael Doerner" <michael@ht.co.nz>

These are ldap address book entries (users on this SME server) and the " (double quote) must be generated somewhere I believe when pulling the information  out of the ldap directory?

Has any other tester seen this?


Title: Re: SOGO for Sme
Post by: stephen noble on March 16, 2010, 06:32:00 AM
yes, it's such an obvious error i'm assuming the next release will fix it
I emailed the maintainer
Title: Re: SOGO for S
Post by: mdo on March 16, 2010, 10:23:05 AM
Is this the right place for suggestions?

Alessio (many thanks for your work on this contrib!),

The parameter
displayName = "Utenti Locali";
is set in the template /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10defaults

Most will want to customise that name and I wonder what is the best way to allow for this?

It is currently part of one template fragment with many important settings and I would hesitate to copy this fragment over and to the custom-templates for that address book name change. Ideally this single setting could become a DB setting in the future?
Title: Re: SOGO for Sme
Post by: stephen noble on March 16, 2010, 12:05:18 PM
could we use LDAP
is this a neutral term
Title: Re: SOGO for Sme
Post by: alefattorini on March 16, 2010, 02:49:41 PM
What is the best place to discuss testing progress (and issues)?


I think that the best place is sogo mailing list, and sogo bugzilla.
I send your question to sogo ML, if you want next time you can send directly
Thanks
Title: Re: SOGO for S
Post by: alefattorini on March 16, 2010, 03:04:03 PM
Is this the right place for suggestions?

Alessio (many thanks for your work on this contrib!),

The parameter
displayName = "Utenti Locali";
is set in the template /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10defaults

Most will want to customise that name and I wonder what is the best way to allow for this?


It is currently part of one template fragment with many important settings and I would hesitate to copy this fragment over and to the custom-templates for that address book name change.

yes, it's the best way. Sorry for the mistake. "LDAP" can be a good choice, or "Local" for local users.

Quote
Ideally this single setting could become a DB setting in the future?

Yes, i make a list of possibile DB setting for the next release.
Title: Re: SOGO for Sme
Post by: kevinb on March 16, 2010, 05:25:39 PM
Nice work Alessio!
 
I finally got this installed and all went well.
 
I setup the TB SOGO connector and am able to push exensions to clients automatically. When I get a chance I'll update the WIKI on this.
 
I am looking forward to the DB settings.
 
Kevin
Title: Re: SOGO for Sme
Post by: Bud on March 17, 2010, 04:58:44 AM
Guys will this work on SME 7.4 or only on SME 8+

Sorry if the question has already been answered
Title: Re: SOGO for Sme
Post by: mdo on March 17, 2010, 05:04:03 AM
This will work only from SME8 beta 5 on, no chance for SME 7.x
Title: Re: SOGO for Sme
Post by: alefattorini on March 17, 2010, 09:46:35 AM
Guys will this work on SME 7.4 or only on SME 8+

Sorry if the question has already been answered

Hi Bud only SME8, we have tried but there are some problem :-)
Title: Re: SOGO for Sme
Post by: byte on March 17, 2010, 10:58:59 AM
Has anyone got the tasks working with funambol and the funambol-sogo-connector ? I have the contacts and calendar working with Outlook flawlessly at the moment but the tasks are not updated after you complete the task, for example I create a task in outlook XP (2002) sync which goes ok but once I have completed the task outlook throws a pop up window saying:

"Warning: Some items were not correctly saved in Outlook"

Probably a question for the sogo ml but thought I'd ask here as well.

Thanks
Title: Re: SOGO for Sme
Post by: kevinb on March 19, 2010, 05:38:32 AM
Well this is interesting ...
 
I was working. Then I did a "yum update" and the kernal and a few others updated and then I could not login to SOGO. I removed and reinstalled SOGO and now I get a "Service Temporarily Unavailable" and can't get to the login screen.
 
Any ideas? Anyone else see this?
 
Thanks, Kevin
Title: Re: SOGO for Sme
Post by: alefattorini on March 19, 2010, 09:16:17 AM
Well this is interesting ...
 
I was working. Then I did a "yum update" and the kernal and a few others updated and then I could not login to SOGO. I removed and reinstalled SOGO and now I get a "Service Temporarily Unavailable" and can't get to the login screen.
 

sogod is running?
what in /var/log/sogo/sogo.log?

I ask you to use sogo ML for question that not regards smeserver-sogo

http://www.scalableogo.org/en/support/community.html
sogo@opengroupware.org
Title: Re: SOGO for Sme
Post by: soprom on March 20, 2010, 05:28:00 PM
Log says "Scanner initialised with nil string"

Also, with a /etc/init.d/sogod restart is says:
Code: [Select]
Restarting Scalable OpenGroupware.Org (Inverse edition):
2010-03-20 12:26:49.190 sogod[4632] File NSDictionary.m: 634. In [GSMutableDictionary -initWithContentsOfFile:] Contents of file '/home/sogo/GNUstep/Defaults/.GNUstepDefaults' does not contain a dictionary
<0x0x99f7508[SOGoStartupLogger]> No configuration found. SOGo will not work properly.
  sogo                                                     [  OK  ]

Title: Re: SOGO for Sme
Post by: kevinb on March 20, 2010, 08:03:35 PM
Hello Alessio,
 
I reinstalled SME8b5, yum update and installed SOGo and all went well. Since this beta on beta software I do not think it would be worth while to track down issues now.
 
Everyone, I updated the WIKI with instuctions on how to setup the Thunderbird Integrator.
 
Kevin
Title: Re: SOGO for Sme
Post by: soprom on March 20, 2010, 10:55:24 PM
yum remove and then yum install didn't solved the problem.
Title: Re: SOGO for Sme
Post by: kevinb on March 20, 2010, 11:18:53 PM
soprom, can you post your file "/home/sogo/GNUstep/Defaults/.GNUstepDefaults" ?
Title: Re: SOGO for Sme
Post by: soprom on March 21, 2010, 02:42:16 AM
Here it goes...

Code: [Select]
/*
 * ------------------------------------------------------------
 *        !!DO NOT MODIFY THIS FILE!!
 * 
 *  Manual changes will be lost when this file is regenerated.
 *
 *  Please read the developer's guide, which is available
 *  at http://www.contribs.org/development/
 *
 *  Copyright (C) 1999-2006 Mitel Networks Corporation
 * ------------------------------------------------------------
 */
{
    NSGlobalDomain = {
    };
    sogod = {
        NGUseUTF8AsURLEncoding = YES;
        OCSFolderInfoURL = "mysql://sogo:qjraB.e8xgvPqgt....FLSq+sGhpYjthgL@localhost/sogo/sogo_folder_info";
        SOGoACLsSendEMailNotifications = YES;
        SOGoAppointmentSendEMailNotifications = YES;
        SOGoAppointmentSendEMailReceipts = YES;
        SOGoAuthenticationMethod = LDAP;
        SOGoDraftsFolderName = Drafts;
        SOGoFoldersSendEMailNotifications = YES;
        SOGoIMAPServer = localhost;
        SOGoMailDomain = sophieromano.com;
        SOGoMailingMechanism = sendmail;
        SOGoProfileURL = "mysql://sogo:qjraB.e8xgvPqgtQffu+QiXEF....hpYjthgL@localhost/sogo/sogo_user_profile";
        SOGoSMTPServer = localhost;
        SOGoSentFolderName = Sent;
        SOGoSuperUsernames = (
            admin
        );
        SOGoTimeZone = America/Montreal;
        SOGoTrashFolderName = Trash;
        SOGoUserSources = (
            {
                CNFieldName = cn;
                IDFieldName = uid;
                UIDFieldName = uid;
                baseDN = "dc=sophieromano,dc=com";
                bindDN = "cn=root,dc=sophieromano,dc=com";
                bindFields = uid;
                bindPassword = "Oj....n6lTrSP";
                canAuthenticate = YES;
                displayName = "Utenti Locali";
                hostname = localhost;
                id = directory;
                isAddressBook = YES;
                port = 389;
                type = ldap;
            }
        );
        WOMessageUseUTF8 = YES;
        WOParsersUseUTF8 = YES;
        WOPort = 20000;
        WOUseRelativeURLs = YES;
    };
}

oops... I'll need to change mysql password.
Title: Re: SOGO for Sme
Post by: kevinb on March 21, 2010, 09:02:31 PM
Hi Sophie, I do not see anything wrong in your file. I am at a loss. Sorry
Title: Re: SOGO for Sme
Post by: alefattorini on March 22, 2010, 09:28:44 AM
yum remove and then yum install didn't solved the problem.

Do you have modified .GNUstepDefaults manually? Don't do this, you should use "defaults write.." command as described in documentation. I think that there is some sintax problem. You can try
expand-template /home/sogo/GNUstep/Defaults/.GNUstepDefaults
/etc/init.d/sogod restart

Search in google site:mail.opengroupware.org
or ask in sogo@opengroupware.org
Title: Re: SOGO for Sme
Post by: alefattorini on March 22, 2010, 09:29:58 AM
Hello Alessio,
Everyone, I updated the WIKI with instuctions on how to setup the Thunderbird Integrator.
 
Kevin

Thank you very much, good work!
Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 03:35:26 PM
Do you have modified .GNUstepDefaults manually?

I just realized that the template /etc/e-smith/templates/home/sogo/GNUstep/Defaults is now empty!
So is /home/sogo/GNUstep/Defaults probably because of the expand-template.

That should explain the errors but why did it disappeared, I don't know!
Title: Re: SOGO for Sme
Post by: alefattorini on March 22, 2010, 03:59:50 PM
I just realized that the template /etc/e-smith/templates/home/sogo/GNUstep/Defaults is now empty!
So is /home/sogo/GNUstep/Defaults probably because of the expand-template.

That should explain the errors but why did it disappeared, I don't know!

Happens, sometimes when you edit .GNUstepDefaults manually (with user not-sogo or with bad sintax) . You should use properly commands or expand template.
Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 04:21:59 PM
trying to repair sogo:

# remove sogo
yum -y remove smeserver-sogo sogo
mysql -e "drop user sogo;"
mysql -e "drop database sogo;"
rm -rfd /home/sogo
config delete sogod
signal-event post-upgrade; signal-event reboot; exit

# reinstall sogo
yum -y install smeserver-sogo --enablerepo=nethsme --enablerepo=sogo
signal-event post-upgrade; signal-event reboot; exit

# checking
After these steps, there is nothing in
/etc/e-smith/templates/home/sogo/GNUstep/Defaults
/home/sogo/GNUstep/Defaults
Title: Re: SOGO for Sme
Post by: Daniel B. on March 22, 2010, 04:26:33 PM
The config file for sogo is hidden:

/home/sogo/GNUstep/Defaults/.GNUstepDefaults

And the templates are in /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/

No need to remove/re-install if something went wrong (hey, we're not running windows do we ? ;))

A simple
Code: [Select]
signal-event sogo-modify
Should put the configuration back to normal.

Regards
Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 04:31:08 PM
Ok for hidden files. I see them now.

I applied signal-event sogo-modify but it's a no-go...

Logs say:
SOGo watchdog[4337] unable to get status of descriptor 2 - Mauvais descripteur de fichier (bad file descriptor)

Scanner initialised with nil string


Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 04:43:24 PM

/etc/init.d/sogod status says
sogod est mort mais le fichier pid existe
(sogo is dead but pid file still exists)
Title: Re: SOGO for Sme
Post by: alefattorini on March 22, 2010, 05:02:58 PM
/etc/init.d/sogod status says
sogod est mort mais le fichier pid existe
(sogo is dead but pid file still exists)

ps ax | grep sogod

/etc/init.d/sogod stop

ps ax | grep sogod
is there any pid? kill it and start again
Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 05:14:44 PM
No change...

ps ax | grep sogod
 4789 pts/0    S+     0:00 grep sogod

cat /var/run/sogo/sogo.pid
4696

/etc/init.d/sogod status
sogo is dead but pid file still exists

rm -f /var/run/sogo/sogo.pid
/etc/init.d/sogod status
sogod is stopped

/etc/init.d/sogod start
sogod: SOGo watchdog[4916] unable to get status of descriptor 2 - Mauvais descripteur de fichier

/etc/init.d/sogod stop
sogo not running

/etc/init.d/sogod status
sogo is dead but pid file still exists

cat /var/run/sogo/sogo.pid
4916
Title: Re: SOGO for Sme
Post by: soprom on March 22, 2010, 05:17:48 PM
..deleted...
Title: Re: SOGO for Sme
Post by: byte 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.
Title: Re: SOGO for Sme
Post by: alefattorini 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
Title: Re: SOGO for Sme
Post by: byte 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.
Title: Re: SOGO for Sme
Post by: daniel 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.
Title: Re: SOGO for Sme
Post by: Marco Hess 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
Title: Re: SOGO for Sme
Post by: daniel 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!


Title: Re: SOGO for Sme
Post by: Marco Hess 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. :-(

Title: Re: SOGO for Sme
Post by: daniel 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 (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

Title: Re: SOGO for Sme
Post by: Marco Hess 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.
Title: Re: SOGO for Sme
Post by: daniel 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.
Title: Re: SOGO for Sme
Post by: Marco Hess 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
Title: Re: SOGO for Sme
Post by: cactus 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?
Title: Re: SOGO for Sme
Post by: Marco Hess 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.
Title: Re: SOGO for Sme
Post by: cactus 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.
Title: Re: SOGO for Sme
Post by: Marco Hess 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
Title: Re: SOGO for Sme
Post by: daniel 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. 
Title: Re: SOGO for Sme
Post by: Marco Hess 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.
Title: Re: SOGO for Sme
Post by: Marco Hess 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');


Title: Re: SOGO for Sme
Post by: cactus 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.
Title: Re: SOGO for Sme
Post by: Marco Hess 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.
Title: Re: SOGO for Sme
Post by: daniel 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.
Title: Re: SOGO for Sme
Post by: byte 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.
Title: Re: SOGO for Sme
Post by: byte 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
Title: Re: SOGO for Sme
Post by: Marco Hess 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.

Title: Re: SOGO for Sme
Post by: cactus 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
Title: Re: SOGO for Sme
Post by: byte 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.
Title: Re: SOGO for Sme
Post by: byte 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.
Title: Re: SOGO for Sme
Post by: cactus 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?
Title: Re: SOGO for Sme
Post by: kevinb 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 (https://username:password@hostname/SOGo/dav/%NAME%/freebusy.ifb) to pass credentials?
 
Kevin
Title: Re: SOGO for Sme
Post by: byte 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 (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!
Title: Re: SOGO for Sme
Post by: Joeg1484 on May 21, 2010, 07:25:35 AM
Hey all,

Having trouble with installing this...

Fresh install of 8b5. Followed Wiki to a tee and when I run yum, I get this:

Code: [Select]
memcached-1.4.2-1.el5.i386 from sogo has depsolving problems
  --> Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (sogo)
Error: Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (sogo)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

Any ideas?

Thanks!

Joe
Title: Re: SOGO for Sme
Post by: mdo on May 21, 2010, 08:29:24 AM
There is a discussion about this here: http://forums.contribs.org/index.php/topic,46012.0/topicseen.html

Another idea is to apply all available updates (Sme + CentOS) and then try again.
Michael
Title: Re: SOGO for Sme
Post by: kg66 on May 21, 2010, 10:19:07 AM
Hi Joeg1484

got the same issue here....

my workaround:

do a manual install of libevent-1.1a. you can find it via rpmfind or google or just take the link below (it worked for me)

wget ftp://mirror.switch.ch/pool/3/mirror/centos/5.4/os/i386/CentOS/libevent-1.1a-3.2.1.i386.rpm (http://ftp://mirror.switch.ch/pool/3/mirror/centos/5.4/os/i386/CentOS/libevent-1.1a-3.2.1.i386.rpm)
yum localinstall libevent-1.1a-3.2.1.i386.rpm

after
signal-event yum-modify

then you can install smeserver-sogo package

yum install smeserver-sogo --enablerepo=nethsme --enablerepo=sogo

hope that helps

kg66



Title: Re: SOGO for Sme
Post by: Joeg1484 on May 21, 2010, 04:58:01 PM
Hi Joeg1484

got the same issue here....

my workaround:

do a manual install of libevent-1.1a. you can find it via rpmfind or google or just take the link below (it worked for me)

wget ftp://mirror.switch.ch/pool/3/mirror/centos/5.4/os/i386/CentOS/libevent-1.1a-3.2.1.i386.rpm (http://ftp://mirror.switch.ch/pool/3/mirror/centos/5.4/os/i386/CentOS/libevent-1.1a-3.2.1.i386.rpm)
yum localinstall libevent-1.1a-3.2.1.i386.rpm

after
signal-event yum-modify

then you can install smeserver-sogo package

yum install smeserver-sogo --enablerepo=nethsme --enablerepo=sogo

hope that helps

kg66

Yeah, this worked... However, 2 more questions:

1. After installing the libevent rpm, SME wants to upgrade it to something like 1.4. Will this pose  a problem.
2. When I try to access my sogo from outside the network, it lets me log in, but then redirects me to a site internal and I loose connection. Is there a way to specify global access fro this?

Thanks!

Joe
Title: Re: SOGO for Sme
Post by: Stefano on May 21, 2010, 05:21:01 PM
1. After installing the libevent rpm, SME wants to upgrade it to something like 1.4. Will this pose  a problem.

just exclude it with --exclude=libevent in the yum command
Title: Re: SOGO for Sme
Post by: Joeg1484 on July 17, 2010, 05:33:48 PM
Anyone have an idea on how to change the default domain that SOGo resolves to...

Here is my problem... I have a local domain joeman1.local and an external mail domain mail.joeman1.com. When I try to access SOGo from mail.joeman1.com, it tries to redirect to joeman1.local and this fails from outside my network.

I tried to expand the template 10defaults to point my domain to the external and ran the expand-template command, but it is still trying to redirect https to the local domain.

Any workarounds for this?

Thanks!
Joe
Title: Re: SOGO for Sme
Post by: edform on July 20, 2010, 06:09:27 PM
Anyone have an idea on how to change the default domain that SOGo resolves to...

Here is my problem... I have a local domain joeman1.local and an external mail domain mail.joeman1.com. When I try to access SOGo from mail.joeman1.com, it tries to redirect to joeman1.local and this fails from outside my network.

I tried to expand the template 10defaults to point my domain to the external and ran the expand-template command, but it is still trying to redirect https to the local domain.

Any workarounds for this?

I think you have a fundamental misunderstanding of the way in which SME server should be set up. It isn't like a Windows server where you set the domain on the server to joeman1.local and then tell the exchange server to act as the mailhost for joeman1.com. An SME server is expected to be the authoritative mailhost for your domain name. When you set it up you actually give the system your fully qualified domain name as its domain - in your case joeman1.com.

If this gives problems because you have joeman1.com hosted by an ISP you can use the 'Hostnames and addresses' facility in the server manager to change the locations of the various domain entities from 'Self and the IP address of your server' to 'Remote and the correct IP address for your ISP's facilities'.

You might also need to alter the email settings away from the standard SMTP in and out to take account of your arrangements with your ISP.

Ask again if you need any more details.

Ed Form
Title: Re: SOGO for Sme
Post by: Joeg1484 on July 20, 2010, 07:41:52 PM
I think you have a fundamental misunderstanding of the way in which SME server should be set up. It isn't like a Windows server where you set the domain on the server to joeman1.local and then tell the exchange server to act as the mailhost for joeman1.com. An SME server is expected to be the authoritative mailhost for your domain name. When you set it up you actually give the system your fully qualified domain name as its domain - in your case joeman1.com.

If this gives problems because you have joeman1.com hosted by an ISP you can use the 'Hostnames and addresses' facility in the server manager to change the locations of the various domain entities from 'Self and the IP address of your server' to 'Remote and the correct IP address for your ISP's facilities'.

You might also need to alter the email settings away from the standard SMTP in and out to take account of your arrangements with your ISP.

Ask again if you need any more details.

Ed Form

LOL, yeah, I have spent more time in the Windows trenches than in the Linux trenches as of late, so you are correct on that aspect. I was wondering about the domain setup when I was installing, so I decided to just go with what i know.

I did figure out how to modify the config files to get it to work, but I was thinking about renaming my server to joeman1.com as that is how my domain is setup. Its not hosted though my ISP, although I use dyndns.org to keep my ip address up to date.

Do you have or know of a process where I can rename my server correctly? Or should I just rebuild it with the correct naming?

Thanks for the help!

Joe
Title: Re: SOGO for Sme
Post by: edform on July 20, 2010, 07:52:04 PM

Do you have or know of a process where I can rename my server correctly? Or should I just rebuild it with the correct naming?

Just login to the server console as 'admin' with the root pasword and you'll get a menu. The second item in the menu is 'Configure this server' and that opens exactly the same dialogue as you went through when you first set the server up. At the end of the questions you get to reboot and the server reconfigures itself as you have just told it.

Ed Form
Title: Re: SOGO for Sme
Post by: Joeg1484 on July 20, 2010, 08:44:25 PM
Wonderful!!! I will give it a go when I get home.

Thanks so much!

Joe
Title: Re: SOGO for Sme
Post by: edform on July 20, 2010, 10:28:09 PM
We have made rpm for Sme, install notes here:
http://smeserver.nethesis.it/sogo/
Your Comments Are Appreciated

I ran into a problem using this rpm which hasn't been reported to this thread; so here goes...

I ran the install on my SME 8b5, Server only machine following your howto and solving the various glitches as I went along. I finished up with an install that didn't work properly. I could raise the SOGo login screen with http://hostname/SOGo and, using a valid username/password combination, the system plainly authenticated the user because the URL changed to https://hostname.domain/SOGo/so/username/Mail, but the system did not display the page.

I then reasoned that the URL was incorrect for my install, so I changed the URL to "https://hostname/SOGo/so/username/Mail/View" and up came the correct screen. Most of the functionality of SOGo worked but logging out and then logging back in didn't work and changing the URL back to the one with no domain name did not produce the correct screen until the workstation had been logged out and back in.

It is pretty obvious that the rpm does not produce a working SOGo system on a 'Server only' SME machine so I added a second network card to my server and reconfigured it as a Dedicated Server and Gateway. Once that was complete the unchanged SOGo install began working perfectly using http://hostname.doman-name/SOGo or https://hostame.domain-name/SOGo as the calling URL.

These problems may be caused by the fact that the 'Server-only' install was not the DHCP master for the network or it may be that the rpm is not sufficiently explicit in setting the hostname and domain name information in the configuration files.

Since I now know that the rpm works fine - with a couple of glitches that need modifications to the instructions - I'd be happy to settle for the fact that it works perfectly on a Server and Gateway.

I'll publish a complete Howto shortly including all of the extra steps needed to make it work.

Ed Form
Title: Re: SOGO for Sme
Post by: alefattorini on July 22, 2010, 05:30:51 PM
>  the rpm is not sufficiently explicit in setting the hostname and domain name information in the configuration files.

Yes, this is the problem. If NethService isn't your dns, you should configure your DNS server for resolve IP_SME = hostname = hostname.domain
Bye
Title: Re: SOGO for Sme - damage to SME update system
Post by: edform on July 27, 2010, 06:50:56 PM
I've discovered that the 'Software Installer' function in server manager has failed repeatedly since I installed SOGo. The culprit is the libevent dependency which I cured while installing SOGo by downloading the rpm libevent-1.1a-3.el4.i386.rpm and installing it.

Now, when I run the software installer in the server manager the updates fail with the message...

---> Package yum.noarch 0:3.2.22-26.el5.centos set to be updated
--> Finished Dependency Resolution
memcached-1.4.2-1.el5.i386 from installed has depsolving problems
  --> Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (installed)
Error: Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (installed)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.
yum update apr-util.i386 at.i386 audit-libs-python.i386 audit-libs...

Does this mean that SME 8 is dependent on a specific version of this package and can't update properly without it?

If this is the case I'll report it as a bug.

Ed Form
Title: Re: SOGO for Sme
Post by: Joeg1484 on July 27, 2010, 07:29:24 PM
I ran into the same issue, so what I do for now is when I going in to update my server, I simply unselect the libevent package and select the others. This will allow the server to get all the other updates but not the broken one.

Until this is resolved, it will get your machine updated.

Hope this helps!

Joe
Title: Re: SOGO for Sme
Post by: edform on July 27, 2010, 10:04:48 PM
I ran into the same issue, so what I do for now is when I going in to update my server, I simply unselect the libevent package and select the others. This will allow the server to get all the other updates but not the broken one.

Until this is resolved, it will get your machine updated.

Hope this helps!

Joe

Worked perfectl;y. Well done!

Ed Form
Title: Re: SOGO for Sme - damage to SME update system
Post by: byte on July 28, 2010, 12:50:21 PM
If this is the case I'll report it as a bug.

http://bugs.contribs.org/show_bug.cgi?id=5947
Title: Re: SOGO for Sme
Post by: riff on September 02, 2010, 07:43:56 AM
Hi!

This project is awesome! Just what I have been waiting for!

However, has anyone worked out how to turn on the spell check? ( I can't spell to save myself)  I can't seem to find any information on how to, I can see they have included it in the CKEDITOR, but as to turn it on baffles me! I though I would ask here before logging this with Sogo themselves.

Riff.
Title: Re: SOGO for Sme
Post by: alefattorini on September 13, 2010, 04:57:03 PM
We have release new smeserver-sogo rpm and smeserver-sogo-thunderbird for auto-create sogo addon.
You can install/update it follow this doc http://wiki.contribs.org/Sogo
For thundirbird you can download and install only sogo-integrator from https://smeserver.domain/sogo-plugins, i shouldn't modify integrator with smeserver dns, it's complete.
Can anyone test it ?
Thank you
Title: Re: SOGO for Sme
Post by: macwunder on February 02, 2011, 03:42:33 AM
Been a while since any posts to this topic... Is it still alive?

I installed this latest RPM to my 8b6 SME machine. There are still dependency issues with memcached (regarding libevent-1.1a.so.1) which I resolved by installing compat-libevent-11a-3.2.1-1... After that, smeserver-sogo and sogo installed without a hitch.

I am having troubles getting DAV to work. After install, post-upgrade and reboot, apache does not listen on port 8843, and it doesn't appear to have included any VirtualHost for that port. Any pointers how I can get that functionality working? I'm all Apple hardware, and don't need any Funambol stuff here...

Also, with the latest SOGo releases (1.3.5a) a new parameter needs to be added to the .GNUstepDefaults file:

OCSSessionsFolderURL = "mysql://sogo:{$sogod{'DbPassword'}}@localhost/sogo/sogo_sessions_folder";

This avoids having to login every minute or so...

Fine work, Alessio! Please help me get the DAV stuff working?

Regards;
Jeff
Title: Re: SOGO for Sme
Post by: macwunder on February 02, 2011, 09:53:45 PM
Well... to answer my own question and to document for posterity...  :D

I ended up adding three config template fragments in /etc/e-smith/templates/etc/httpd/conf/httpd.conf/:

35SSL00Listen8843, which has the contents:
    Listen 0.0.0.0:8843

80NameVirtualHostsDAV, which has the contents:
    NameVirtualHost 0.0.0.0:8843

80VirtualHostsDAVSSL, which has the contents:
    <VirtualHost 0.0.0.0:8843>
      ServerName { $SystemName }.{ $DomainName }
      SSLEngine On
      ProxyRequests Off
      SetEnv proxy-nokeepalive 1
      ProxyPreserveHost On
      ProxyPassInterpolateEnv On
      ProxyPass /principals http://127.0.0.1:20000/SOGo/dav/ interpolate
      ProxyPass /SOGo/dav/ http://127.0.0.1:20000/SOGo/dav/ interpolate
      ProxyPass / http://127.0.0.1:20000/SOGo/dav/ interpolate

    <Proxy http://127.0.0.1:20000>
      RequestHeader set "x-webobjects-server-port" "8843"
      RequestHeader set "x-webobjects-server-name" "{ $SystemName }.{ $DomainName }:8843"
      RequestHeader set "x-webobjects-server-url" "https://{ $SystemName }.{ $DomainName }:8843"
      RequestHeader set "x-webobjects-server-protocol" "HTTP/1.0"
      RequestHeader set "x-webobjects-remote-host" "127.0.0.1"
      AddDefaultCharset UTF-8
      Order allow,deny
      Allow from all
    </Proxy>
    </VirtualHost>

Performed signal-event sogo-modify, and all is working on the DAV front with my Macs and iPhones.
Title: Re: SOGO for Sme
Post by: alefattorini on February 03, 2011, 09:08:37 AM
> I have been trying to use your smeserver-sogo contribution on my SME 8 beta 6 machine and am having troubles getting the dav functionality to work. I installed as per the Contribs Wiki, with the exception of having to take care of a missing dependency where memcached needed libevent-1.1a.so.1, which I eliminated by installing compat-libevent-11a-3.2.1-1.el5 for i386. After that I could install as per the wiki for smeserver-sogo.
>
> After install (yum installed SOGo version 1.3.5a) I had the problem of getting booted from the login, so added the following line to /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10defaults:
>    OCSSessionsFolderURL = "mysql://sogo:{$sogod{'DbPassword'}}@localhost/sogo/sogo_sessions_folder";
> Then signal-event sogo-modify; /etc/rc7.d/S85sogod restart
> That took care of the sessions problem introduced with sogo 1.3.5

Yes, but i have test smeserver package only with 1.3.3. I'll use this soon

>
> When I port scan the machine, I notice that apache is not listening on 8843 (dav ssl), so I added a template fragment to add "Listen 8843", and added "NameVirtualHost 0.0.0.0:8843" to 80NameVirtualHosts fragment. Also tried adding an additional fragment to specify the VirtualHost on port 8843, but when I try to browse that location, I get permission errors.
>
> Can you offer any assistance?

Sorry but i see that you have answer to yourself

Do you need for cardav support in apple addressbook and iphone?

> Many thanks, ond good job on the integration!
> Jeff

Thanks to you"
Title: Re: SOGO for Sme
Post by: macwunder on February 03, 2011, 01:44:09 PM
Yes, but i have test smeserver package only with 1.3.3. I'll use this soon
Oh, I see. Well, I found your contrib so late that I had no choice.  :lol:

I am glad I put my modified GNUstepDefaults template in templates-custom.

Do you need for cardav support in apple addressbook and iphone?
Yes, this is required for CardDAV and CalDAV native support in Mac OS and iOS. If you want all this to work outside your local network, there will need to be a firewall pinhole that has to be opened, as well:

config set DAV service TCPPort 8843 access public status enabled
signal-event remoteaccess-update

Have you thought about creating an admin panel for this so some things could be customized in the SME Server GUI?

Regards;
Jeff
Title: Re: SOGO for Sme
Post by: edform on March 11, 2011, 09:39:32 PM
I installed this very interesting contribution today and it looks ideal for the circumstances in the office of a client that I still look after. I've noticed a set of bugs however which I thought I'd ask about here because I think they may be related to the browser I'm using rather than bugs in the SME contribution or SOGo itself.

I'm running the application in the K-Meleon browser with all of the menus and toolbars hidden so as to give the impression that the application is a native Windows program and to avoid using the system browser - users shut their browsers down after a surfing session and then find that they've also closed their email program as well!!!

After a while I find that clicking to bring up a dialogue - writing a new email for example - brings up a new SOGo login screen instead. I also find that the program seems to go to sleep so that controls no longer respond - I cannot remove the tick against a shared calendar for example - and it is possible that this is tied up with the other problem.

Woops! I just found out that the same thing occurs in both IE8 and Firefox so it looks like it's not a browser issue.

Has anyone any ideas about this?

Ed Form
Title: Re: SOGO for Sme
Post by: macwunder on March 12, 2011, 04:31:55 AM
Hi Ed;

Se my post a couple times up about having to add the new sessions parameter to the SOGo config. That will take care of that.

Jeff
Title: Re: SOGO for Sme
Post by: edform on March 12, 2011, 08:36:45 AM
Hi Ed;

Se my post a couple times up about having to add the new sessions parameter to the SOGo config. That will take care of that.

Jeff

I searched for the .GNUstepDefaults file and came up with 5 results so I checked them all out and it looked like the correct place to put this parameter was in the /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10defaults file. I added it after the line beginning OCSFolderInfoURL... near the top of the file. I then restarted the server and logged back in to SOGo. The problem of going to sleep had not been cured.

Have I done the wrong thing?

Ed Form

Title: Re: SOGO for Sme
Post by: edform on March 12, 2011, 10:41:29 AM
I've found more misbehaviour in this application.

If you create a subfolder of the inbox and then try to delete it, you'll find that it has become a subfolder of Trash which is normal but it cannot be deleted from Trash. If you log in to Horde it can be deleted but it keeps on coming back when you log  in again.

What's worse is that it keeps on coming back as a subfolder of inbox when you log back into SOGo.

It looks as though this application isn't ready for use in working systems.

Ed Form
Title: Re: SOGO for Sme
Post by: macwunder on March 12, 2011, 04:01:47 PM
Perform signal-event sogo-modify at the command line to expand the template. That will write the changes to the SOGo config file and restart sogod. Probably better to put custom template changes into the templates-custom folders, in case anything Alessio updates will overwrite your customizations.

Sounds like you need to spend some time in the SME docs...  :-)

I don't have any suggestion for the sub-folder. I haven't had the same issue, but that would be an issue to take up in the SME forums.

Regards;
Jeff
Title: Re: SOGO for Sme
Post by: edform on March 12, 2011, 10:24:52 PM
Perform signal-event sogo-modify at the command line to expand the template. That will write the changes to the SOGo config file and restart sogod.

I restarted the machine after modifying the template; surely that expands all the templates?

Quote
Probably better to put custom template changes into the templates-custom folders, in case anything Alessio updates will overwrite your customizations.

I'd have done that except that I don't understand the language the templates are written in. It looks to me from the way the 10default template fragment is laid out that the indented list of parameters defined is enclosed by opening, and presumably at some point later closing instructions, but I have no idea how to add a line from another template that will be treated as part of that parameter list. I'm fully aware how to build the the folder structure in templates-custom and how to number a template fragment so that it will get lumped into the resulting file with the fragments from templates, but what the new fragment should look like is not in the SME docs - at least in any part of the SME docs that a non-programmer like me would ever read.

For the benefit of others, and perhaps as a hint to Alessio for future versions of his contrib, this is what the beginning of my /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10default template fragment now looks like...

\{
    NSGlobalDomain = \{
    \};
    sogod = \{
        NGUseUTF8AsURLEncoding = YES;
        OCSFolderInfoURL = "mysql://sogo:{$sogod{'DbPassword'}}@localhost/sogo/sogo_folder_info";
        OCSSessionsFolderURL = "mysql://sogo:{$sogod{'DbPassword'}}@localhost/sogo/sogo_sessions_folder";
        SOGoACLsSendEMailNotificat..........

I can confirm that it works perfectly and has made SOGo into a most useful add-on for the SME server. I have a set of shared diaries open on my desktop as I write and they have remained active for some hours now with no sign of the earlier tendency to go to sleep.

Quote
Sounds like you need to spend some time in the SME docs...  :-)

Believe me, over the last 10 years or so I've put quite a bit of time and effort into that.

Quote
I don't have any suggestion for the sub-folder. I haven't had the same issue, but that would be an issue to take up in the SME forums.

I'll raise this as a separate issue but you might care to create a subfolder and try to delete it to see if you have the same issue.

Ed Form
Title: Re: SOGO for Sme
Post by: Stefano on March 13, 2011, 09:22:36 AM
I suggest you to check the sogo's ML too
Title: Re: SOGO for Sme
Post by: edform on March 13, 2011, 12:13:58 PM
I suggest you to check the sogo's ML too

I have been doing some reading around those lists, looking in particular for mention of folder conflicts between cohabiting groupwares and there is mention of conflicts between SOGo and Sqirrelmail. There is no doubt in my mind now that Horde and SOGo don't like being on the same machine - let me describe what I have seen...

During the period when my installation of SOGo was 'going to sleep' I tried to make a subfolder of the inbox with the name 'contribs.org.' This was a mistake because it actually gave me two nested subfolders called 'contribs' and 'org' with 'org' below 'contribs.' After realising the mistake I tried to delete the lowest level folder, 'org', and, as with all email programs, this moved it to become a subfolder of 'trash.' When I emptied 'trash' it refused to delete 'org' with a 'cannot delete' message.

I then closed SOGo and loaded Horde where I could apparently delete the contents of 'Trash', but when I did this 'Trash' itself disappeared. So I closed Horde and re-opened SOGo to find that the three level folder structure 'inbox-contribs-org' was back and if I asked the system to delete the subfolders it said they could not be deleted.

After generally kicking and punching the system for a while I lost my patience and dropped the SOGo database using PHPMyAdmin before using 'yum reinstall' to put smeserver-sogo back. I logged back in as various users and rebuilt the sharing settings I had used in the initial install which gave me a nice clean mail setup in my own username - inbox with no subfolders. Then I closed SOGo down and reopened it and my three-level, 'inbox-contribs-org', folder structure was back with undeletable subfolders!!!

Horde and SOgo do not appear to preside over the same mail system safely.

Is it possible to turn horde off, or is this a bug that needs to be tracked down?

Tomorrow afternoon I will reinstall my 8b6 server from scratch and go round the loop again to see if this behaviour is reproducible.

Ed Form
Title: Re: SOGO for Sme
Post by: mdo on March 13, 2011, 06:16:53 PM
Quote
Is it possible to turn horde off,

In server-manager/E-mail you can set webmail access to disabled (I think this is actually the default setting after a fresh installation).

When you install Sogo on a server with webmail disabled, the Sogo contrib takes care of the webmail URL and Sogo starts when you point your browser to https://servername/webmail - a very nice way to replace horde for your existing users (if you want to do) who are used to "webmail" usage and that URL.
Title: Re: SOGO for Sme
Post by: edform on March 13, 2011, 07:25:57 PM
In server-manager/E-mail you can set webmail access to disabled (I think this is actually the default setting after a fresh installation).

When you install Sogo on a server with webmail disabled, the Sogo contrib takes care of the webmail URL and Sogo starts when you point your browser to https://servername/webmail - a very nice way to replace horde for your existing users (if you want to do) who are used to "webmail" usage and that URL.

I've just started to reinstall my 8b6 server and I'll try this approach when it's up.

Ed Form
Title: Re: SOGO for Sme
Post by: edform on March 13, 2011, 11:32:09 PM
I've now reinstalled my server from scratch - bare metal to fully configured server with PHPMyAdmin, sme-unjunkmgr and sogo all installed and running in 2 hours - what other distribution could that be done in?? Good old SME.

I left webmail disabled in the server manager and, as MDO indicated, SOGo becomes webmail automatically. Very cool!

But! The problem with folders still persists. I made a subfolder of inbox called contribs and then deleted it which made it a subfolder of Trash. When I tried to empty trash it said it could not be emptied. There is a problem here which I'll buglist with the SOGo people and here if it has been entered in the lists.

Ed Form
Title: Re: SOGO for Sme
Post by: edform on March 14, 2011, 07:46:14 AM
...The problem with folders still persists. I made a subfolder of inbox called contribs and then deleted it which made it a subfolder of Trash. When I tried to empty trash it said it could not be emptied. There is a problem here which I'll buglist with the SOGo people and here if it has been entered in the lists.

On further experiment I found a work-round. Moved some mail to Trash and then tried 'empty trash. It worked and took the errant folder with it. So it isn't possible to delete a folder from the trash unless there is other mail in Trash at the time.

Ed Form
Title: Re: SOGO for Sme
Post by: Stefano on March 14, 2011, 09:54:14 AM
On further experiment I found a work-round. Moved some mail to Trash and then tried 'empty trash. It worked and took the errant folder with it. So it isn't possible to delete a folder from the trash unless there is other mail in Trash at the time.

Ed Form

this should be reported in SOGo ML and bugtracker
Title: Re: SOGO for Sme
Post by: edform on March 14, 2011, 10:34:24 AM
this should be reported in SOGo ML and bugtracker

I tried to report this and some other stuff into the Sogo bugtracker this morning and the sign-up routine fell over and put up a load of code in red at the top of the screen, so I cannot post into their bugs at the moment.

I went back and tried to sign up again and the system knew that my suggested screen name had been used, so perhaps the sign-up did work and they are just a bit slow sending out the activation emails.

On another subject to do with SOGo: the live demo shows extra facilities that would be really cool to incorporate into the SME install. If we can run Seive on our servers [Dovecot Pigeonhole?] there are a few lines that need to be added to the config file that will incorporate filtering as a dialogue at the bottom of the Mail Preferences page of the webmail interface. There is also a spell checker, a vacations dialogue and a forwarding dialogue for the preferences but the forums are less informative on what is needed to build those in.

With those items folded into the SME install this contribution would come closer than anything else I've yet seen to giving SME the groupware facilities needed to make it a complete small office server. The best feature is how much faster and slicker it is than the standard php based products. The horde-style diary sharing and overlaying is a real plus; for small offices it is infinitely superior to the Outlook/Exchange model of voluntary email notification of diary items.

I look forward to future developments of this promising contribution.

Ed Form

Title: Re: SOGO for Sme
Post by: edform on March 14, 2011, 04:50:27 PM
I tried to report this and some other stuff into the Sogo bugtracker this morning and the sign-up routine fell over and put up a load of code in red at the top of the screen, so I cannot post into their bugs at the moment.

Folders bug now reported in SOGo bug system.

Ed Form
Title: Re: SOGO for Sme
Post by: Stefano on March 14, 2011, 05:09:59 PM
please, report here the reference (even if to an external bugtracker)

Thank you
Title: Re: SOGO for Sme
Post by: edform on March 14, 2011, 06:18:55 PM
please, report here the reference (even if to an external bugtracker)

Thank you

Bug number in SOGo Mantis Bug Tracker for Folder deletion problem is 0001189

Ed Form
Title: Re: SOGO for Sme
Post by: roto_sky on March 30, 2011, 11:06:04 PM
Hi, i'm newbee here, so sorry if it's not the right topic.
I read all (maybe all) about Sogo in several forum but i cannot find any info for complete synchro.
Explain : SME 8b6 (fresh install and updated) + opnvpn-bridge and openvpn-client + ddclient

I install SOGo => ok it works perfectly (disabled horde), i received emails => ok
I try to install Funambol (V9.0.0) => Ok test on funambol/ds =>ok
I add module android on my cell phone (HTC) => i can synchronise the both (cell <=> Funambol) but anything in Sogo.
I have already install 2 times and check all (i hope)!!! But i cannot find the end of tunnel.
Somebody applies already this solution ? Maybe i forget another module or ...
Have you links to test, follow or explain it? I'm dry

Cordialement

ps: i'm french, sorry for my english.
Title: Re: SOGO for Sme
Post by: misnerspace on July 06, 2011, 10:06:13 AM
Would it be possible to include the following in the SME server wiki?

After install (yum installed SOGo version 1.3.5a) I had the problem of getting booted from the login, so added the following line to /etc/e-smith/templates/home/sogo/GNUstep/Defaults/.GNUstepDefaults/10defaults:
>    OCSSessionsFolderURL = "mysql://sogo:{$sogod{'DbPassword'}}@localhost/sogo/sogo_sessions_folder";
> Then signal-event sogo-modify; /etc/rc7.d/S85sogod restart
> That took care of the sessions problem introduced with sogo 1.3.5

I had the same problem today
Title: Re: SOGO for Sme
Post by: cactus on July 06, 2011, 05:59:03 PM
Would it be possible to include the following in the SME server wiki?
Yes, you can apply for an account (http://wiki.contribs.org/Help:Contents) and do it yourself. The wiki is a collaborative initiative.
Title: Re: SOGO for Sme
Post by: misnerspace on July 07, 2011, 01:04:35 AM
Hi Cactus,

I am more that willing to contribute so I have requested to join the documentation team.
Title: Re: SOGO for Sme
Post by: gregswallow on October 23, 2011, 04:15:39 AM
SOGo 2.0 rpms for EL5 were just made available today it seems - anyone interested in developing that as a contrib can check this bug report - http://bugs.contribs.org/show_bug.cgi?id=6767
Title: Re: SOGO for Sme
Post by: macwunder on October 28, 2011, 03:38:45 PM
Given the recent goof by Inverse regarding missing packages in the sogo repository, to avoid updating only parts of a working install I would suggest changing the update command in the wiki to:

yum --enablerepo=sogo update sogo

Running the command as it is yesterday updated my sope49 packages, but the sogo 1.39 packages are missing... leaving me with a missing linked library and a non-functional sogod.
Title: Re: SOGO for Sme
Post by: perelandra on November 17, 2011, 04:21:44 PM
If the problem has not been solved yet (bricked sogo after update to 1.3.9), be sure to update all sope packages by
Code: [Select]
yum update sogo sope49-gdl1-contentstore sope49-cards --enablerepo=sogo --disablerepo=epel
Yum will also update gnustep-base and gnustep-make.

This will cause sogod to stop after a reboot; so be sure to modify create and expand the following template:

/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/85SOGoAccess

Code: [Select]
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
cp /etc/e-smith/templates/etc/httpd/conf/httpd.conf/85SOGoAccess /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/85SOGoAccess

Now edit the newly created template wit your favorite editor like mc or pico, e.g.
Code: [Select]
pico -w /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/85SOGoAccess
In this file the paths in the final two blocks of the template are important! Please compare them with your file!

Some lines:
Quote
Alias /.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                       
Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                   
Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                       
AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2                                                                                                                                       
                                                                                                                                                                                                                                               
<Directory "/usr/lib/GNUstep/SOGo/WebServerResources/">                                                                                                                                                                                         
    AllowOverride None                                                                                                                                                                                                                         
    Options +ExecCGI -Includes                                                                                                                                                                                                                 
    Order allow,deny                                                                                                                                                                                                                           
    Allow from all                                                                                                                                                                                                                             
</Directory>       

The complete and working content:
Code: [Select]
# SOGo Groupware                                                                                                                                                                                                                               
{                                                                                                                                                                                                                                               
    $sogoStatus = $sogod{'status'} || "disabled";                                                                                                                                                                                               
    $webmailStatus = $imp{'status'} || "disabled";                                                                                                                                                                                             
                                                                                                                                                                                                                                               
    $OUT = "";                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                               
    if (($webmailStatus eq 'disabled') and ($sogoStatus eq 'enabled')) {                                                                                                                                                                       
        $OUT = "Redirect /webmail https://${SystemName}.${DomainName}/SOGo";                                                                                                                                                                   
    }                                                                                                                                                                                                                                           
}                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                               
Redirect /sogo https://{$SystemName}.{$DomainName}/SOGo                                                                                                                                                                                         
                                                                                                                                                                                                                                               
ProxyPass /SOGo http://127.0.0.1:{$sogod{'TCPPort'}}/SOGo                                                                                                                                                                                       
ProxyPassReverse /SOGo http://127.0.0.1:{$sogod{'TCPPort'}}/SOGo                                                                                                                                                                               
                                                                                                                                                                                                                                               
<Location /SOGo>                                                                                                                                                                                                                               
        order deny,allow                                                                                                                                                                                                                       
        deny from all                                                                                                                                                                                                                           
        allow from all                                                                                                                                                                                                                         
        SSLRequireSSL on                                                                                                                                                                                                                       
        RequestHeader set "x-webobjects-server-url" "https://{$SystemName}.{$DomainName}/SOGo"                                                                                                                                                 
</Location>                                                                                                                                                                                                                                     
                                                                                                                                                                                                                                               
Alias /.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                       
Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                   
Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/                                                                                                                                                                       
AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2                                                                                                                                       
                                                                                                                                                                                                                                               
<Directory "/usr/lib/GNUstep/SOGo/WebServerResources/">                                                                                                                                                                                         
    AllowOverride None                                                                                                                                                                                                                         
    Options +ExecCGI -Includes                                                                                                                                                                                                                 
    Order allow,deny                                                                                                                                                                                                                           
    Allow from all                                                                                                                                                                                                                             
</Directory>                                                                                                                                                                                                                                   
                   

Tell your server to

Code: [Select]
expand-template /etc/httpd/conf/httpd.conf
sv t httpd-e-smith
service sogod start

If this still won't solve your problem, chown the folowing folders to sogo:sogo

/home/sogo
/var/run/sogo
/var/log/sogo (you may also delete older logfiles in this directory if you re-installed sogo)

Did I miss something?
Title: Re: SOGO for Sme
Post by: Stefano on November 17, 2011, 04:26:09 PM

Did I miss something?


yes.. that you'd never edit fragments in /etc/e-smith/templates/* tree.. you should create the same dir structure in /etc/e-smith/templates-custom, copy there your fragment and modify accordingly to your needs.. in this way your modifications will survive a server update..

HTH
Title: Re: SOGO for Sme
Post by: perelandra on November 17, 2011, 04:33:02 PM
yes.. that you'd never edit fragments in /etc/e-smith/templates/* tree..

Thanks! Very good advice!

Will the template in /etc/e-smith/templates/ stay after I copied it to templates-custom or may I delete it?
Title: Re: SOGO for Sme
Post by: Stefano on November 17, 2011, 04:43:43 PM
you should keep the original file in /etc/e-smith/templates/
Title: Re: SOGO for Sme
Post by: janet on November 17, 2011, 09:54:08 PM
perelandra

Quote
Will the template in /etc/e-smith/templates/ stay after I copied it to templates-custom or may I delete it?

NEVER delete or modify the original templates in /etc/e-smith/templates/
The copied template in /etc/e-smith/templates-custom can be modified (and deleted when no longer required).

By retaining the original templates, your system can be reverted to default settings quite easily and quickly, eg in the event your custom template modifications cause the server to malfunction or even not work at all.

Please read this tutorial for some further understanding.
http://wiki.contribs.org/Template_Tutorial
Essentially (by design) the custom template (with the same name) will override the main template
Title: Re: SOGO for Sme
Post by: perelandra on November 18, 2011, 11:19:08 AM
Edited post #135 to comply with the rules of SME template system
Title: Re: SOGO for Sme
Post by: janet on November 18, 2011, 06:39:23 PM
perelandra

Also better as a standard best practice to use pico -w to avoid unintended line wrapping problems
ie
Code: [Select]
pico -w /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/85SOGoAccess
Title: Re: SOGO for Sme
Post by: cactus on November 19, 2011, 11:45:51 AM
Code: [Select]
mkdir /etc/e-smith/templates-custom/etc/
mkdir /etc/e-smith/templates-custom/etc/httpd/
mkdir /etc/e-smith/templates-custom/etc/httpd/conf/
mkdir /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
Just a tip: this can all be done in a one liner:
Code: [Select]
mkdir -p /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/
Title: Re: SOGO for Sme
Post by: perelandra on November 19, 2011, 11:48:20 AM
Thanks! This thread is a very good learning tutorial - for me! :-)
Title: Re: SOGO for Sme
Post by: lerry on November 22, 2011, 04:09:30 PM
I have some problem with SOGo 13.9 with SMEServer 8b6. I followed the guide in the previous post with no luck. Maybe i miss somethink. When i look at httpd_error.log i found this line when i try to access the SOGo page:

[error] [client 192.168.0.132] client denied by server configuration: /usr/lib/GNUstep/System, referer: https://192.168.0.9/SOGo/

I take a look to /usr/lib/GNUstep but i didn't find any System directory or file! Also the main page of SOGo haven't any css or image loaded.

Someone can help me?

Thanks in advice!
Title: Re: SOGO for Sme
Post by: Gary Douglas on November 23, 2011, 03:28:46 PM
I have installed today, and resolved the issue;  The paths have changed in this version, 85SOGoAccess still has the old paths.

IN;  /etc/e-smith/templates/etc/httpd/conf/httpd.conf/85SOGoAccess

the PATH should be; /usr/lib/GNUstep/

------------------------------------------------------------------------------

# SOGo Groupware
{
    $sogoStatus = $sogod{'status'} || "disabled";
    $webmailStatus = $imp{'status'} || "disabled";

    $OUT = "";

    if (($webmailStatus eq 'disabled') and ($sogoStatus eq 'enabled')) {
        $OUT = "Redirect /webmail https://${DomainName}/SOGo";
    }
}

Redirect /sogo https://{$DomainName}/SOGo

ProxyPass /SOGo http://127.0.0.1:{$sogod{'TCPPort'}}/SOGo
ProxyPassReverse /SOGo http://127.0.0.1:{$sogod{'TCPPort'}}/SOGo

<Location /SOGo>
   order deny,allow
   deny from all
   allow from all
   SSLRequireSSL on
   RequestHeader set "x-webobjects-server-url" "https://{$DomainName}/SOGo"
</Location>

Alias /.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2

<Directory "/usr/lib/GNUstep/SOGo/WebServerResources/">
    AllowOverride None
    Options +ExecCGI -Includes
    Order allow,deny
    Allow from all
</Directory>
Title: Re: SOGO for Sme
Post by: daniel on November 23, 2011, 04:22:10 PM
Is this installation of SOGO also using the openchange link for MS Outlook and other activesync clients?  I'm curious how well it works.  Thanks.

 http://www.openchange.org/ (http://www.openchange.org/)
Title: Re: SOGO for Sme
Post by: Stefano on November 23, 2011, 04:26:23 PM
no, because openchange (and SOGo 2) needs samba4
Title: Re: SOGO for Sme
Post by: Mat78 on November 23, 2011, 10:52:49 PM
Hi,

I've installed Sogo 1.3.9 as per wiki.

Everythings works well if I use a web browser but if I try to use thunderbird there is an error and i'm not able to use SOGo Integrator.

Is it a known problem or is there a way to solve the problem?

TIA
Title: Re: SOGO for Sme
Post by: cactus on November 23, 2011, 11:00:16 PM
Everythings works well if I use a web browser but if I try to use thunderbird there is an error and i'm not able to use SOGo Integrator.
It would be a lot easier if you were to also tell us the exact error message, now you leave us guessing which makes it hard to help you. We do not have a crystal ball...
Title: Re: SOGO for Sme
Post by: ilconte on November 24, 2011, 05:53:45 PM
i have problem in install sogo on sme server 8 beta 6
Title: Re: SOGO for Sme
Post by: ilconte on November 24, 2011, 06:51:39 PM
i have tried this :yum update sogo sope49-gdl1-contentstore sope49-cards --enablerepo=sogo --disablerepo=epel
but receve this error

No Packages marked for Update
 and sogo is down
Title: Re: SOGO for Sme
Post by: janet on November 24, 2011, 10:14:31 PM
ilconte

see http://wiki.contribs.org/Sogo
It has a different procedure to that which you are using
Title: Re: SOGO for Smehttp://forums.contribs.org/Themes/core/images/bbc/quote.gif
Post by: Mat78 on November 25, 2011, 12:51:03 AM
Quote
It would be a lot easier if you were to also tell us the exact error message, now you leave us guessing which makes it hard to help you. We do not have a crystal ball...

When I turn on my test server I get this messages in SOGo Log:

Nov 25 00:00:15 sogod [2914]: version 1.3.9 (build root@vizzini.openchange.local 201110291437) -- starting
Nov 25 00:00:15 sogod [2914]: vmem size check enabled: shutting down app when vmem > 384 MB
Nov 25 00:00:23 sogod [2914]: <0x0x98cab94[SOGoProductLoader]> SOGo products loaded from '/usr/lib/GNUstep/SOGo':
Nov 25 00:00:23 sogod [2914]: <0x0x98cab94[SOGoProductLoader]>   Mailer.SOGo, AdministrationUI.SOGo, MailerUI.SOGo, SchedulerUI.SOGo, Contacts.SOGo, Appointments.SOGo, MainUI.SOGo, CommonUI.SOGo, PreferencesUI.SOGo, ContactsUI.SOGo, MailPartViewers.SOGo
Nov 25 00:00:27 sogod [2914]: <0x0x998715c[WOWatchDog]> listening on 127.0.0.1:20000
Nov 25 00:00:27 sogod [2914]: <0x0x998715c[WOWatchDog]> watchdog process pid: 2914
Nov 25 00:00:27 sogod [2914]: <0x0x3745a0[WOWatchDogChild]> watchdog request timeout set to 10 minutes
Nov 25 00:00:27 sogod [2914]: <0x0x998715c[WOWatchDog]> preparing 1 children
Nov 25 00:00:27 sogod [2914]: <0x0x998715c[WOWatchDog]> child spawned with pid 3227

And this is my messages log:

Nov 25 00:19:26 testserver slapd[2525]: conn=0 fd=13 ACCEPT from IP=127.0.0.1:41831 (IP=0.0.0.0:389)
Nov 25 00:19:26 testserver slapd[2525]: conn=0 op=0 BIND dn="" method=128
Nov 25 00:19:26 testserver slapd[2525]: conn=0 op=0 RESULT tag=97 err=0 text=
Nov 25 00:19:26 testserver slapd[2525]: conn=0 op=1 SRCH base="ou=groups,dc=testserver,dc=local" scope=2 deref=0 filter="(cn=admin)"
Nov 25 00:19:26 testserver slapd[2525]: conn=0 op=1 SRCH attr=dn
Nov 25 00:19:26 testserver slapd[2525]: conn=1 fd=16 ACCEPT from IP=127.0.0.1:41832 (IP=0.0.0.0:389)
Nov 25 00:19:26 testserver slapd[2525]: conn=1 op=0 BIND dn="" method=128
Nov 25 00:19:26 testserver slapd[2525]: conn=1 op=0 RESULT tag=97 err=0 text=
Nov 25 00:19:26 testserver slapd[2525]: conn=1 op=1 SRCH base="ou=users,dc=testserver,dc=local" scope=2 deref=0 filter="(uid=admin)"
Nov 25 00:19:26 testserver slapd[2525]: conn=1 op=1 SRCH attr=dn
Nov 25 00:19:26 testserver slapd[2525]: conn=0 op=1 SEARCH RESULT tag=101 err=0 nentries=0 text=
Nov 25 00:19:26 testserver slapd[2525]: conn=1 op=1 SEARCH RESULT tag=101 err=0 nentries=1 text=
Nov 25 00:19:26 testserver slapd[2525]: conn=2 fd=18 ACCEPT from IP=127.0.0.1:41833 (IP=0.0.0.0:389)
Nov 25 00:19:26 testserver slapd[2525]: conn=2 op=0 BIND dn="uid=admin,ou=users,dc=testserver,dc=local" method=128
Nov 25 00:19:26 testserver slapd[2525]: conn=2 op=0 BIND dn="uid=admin,ou=Users,dc=testserver,dc=local" mech=SIMPLE ssf=0
Nov 25 00:19:26 testserver slapd[2525]: conn=2 op=0 RESULT tag=97 err=0 text=
Nov 25 00:19:26 testserver slapd[2525]: conn=2 op=1 UNBIND
Nov 25 00:19:26 testserver slapd[2525]: conn=2 fd=18 closed

On thunderbird side everything seems to work correctly (there is nothing in Thunderbird Error Consol) but I can't use "Sogo-Integrator" advantage (shared folder, shared calendar).
Title: Re: SOGO for Sme
Post by: alefattorini on December 01, 2011, 05:03:20 PM
My diff for smeserver.sogo.rpm for 1.3.9 is:


Code: [Select]
diff --git a/root/etc/e-smith/templates/etc/httpd/conf/httpd.conf/85SOGoAccess b/root/etc/e-smith/templates/etc/httpd/conf/h
index ff781fc..2921b88 100644
--- a/root/etc/e-smith/templates/etc/httpd/conf/httpd.conf/85SOGoAccess
+++ b/root/etc/e-smith/templates/etc/httpd/conf/httpd.conf/85SOGoAccess
@@ -11,12 +11,12 @@ ProxyPassReverse /SOGo http://127.0.0.1:{$sogod{'TCPPort'}}/SOGo
        RequestHeader set "x-webobjects-server-url"  "https://%\{REQUEST_HOST\}e/SOGo"
 </Location>
 
-Alias /.woa/WebServerResources/ /usr/GNUstep/System/Library/SOGo/WebServerResources/
-Alias /SOGo.woa/WebServerResources/ /usr/GNUstep/System/Library/SOGo/WebServerResources/
-Alias /SOGo/WebServerResources/ /usr/GNUstep/System/Library/SOGo/WebServerResources/
-AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/GNUstep/System/Library/SOGo/$1.SOGo/Resources/$2
+Alias /.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
+Alias /SOGo.woa/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
+Alias /SOGo/WebServerResources/ /usr/lib/GNUstep/SOGo/WebServerResources/
+AliasMatch /SOGo/so/ControlPanel/Products/(.*)/Resources/(.*) /usr/lib/GNUstep/SOGo/$1.SOGo/Resources/$2
 
-<Directory "/usr/GNUstep/System/Library/SOGo/WebServerResources/">
+<Directory "/usr/lib/GNUstep/SOGo/">
     AllowOverride None
     Options +ExecCGI -Includes
     Order allow,deny

 
Title: Re: SOGO for Sme
Post by: alefattorini on December 13, 2011, 12:04:38 PM
We have update this http://smeserver.nethesis.it/sogo/
with smeserver-sogo rpm for 1.3.9 (is compatible with 1.3.10 and 11 too)
Title: Re: SOGO for Sme
Post by: ilconte on December 13, 2011, 06:38:57 PM
when install sogo my sme return this error :

memcached-1.4.2-1.el5.i386 from sogo has depsolving problems
  --> Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (sogo)
Error: Missing Dependency: libevent-1.1a.so.1 is needed by package memcached-1.4.2-1.el5.i386 (sogo)


why?
Title: Re: SOGO for Sme
Post by: macwunder on December 13, 2011, 06:47:29 PM
Install compat-libevent-11a-3.2.1-1.el5.rf.i386.rpm

Available here:
http://apt.sw.be/redhat/el5/en/i386/rpmforge/RPMS/compat-libevent-11a-3.2.1-1.el5.rf.i386.rpm

Download and use "Yum localinstall compat-libevent-11a-3.2.1-1.el5.rf.i386.rpm"

That will take care of that old dependency...
Title: Re: SOGO for Sme
Post by: mdo on December 13, 2011, 08:43:42 PM
We have update this http://smeserver.nethesis.it/sogo/
with smeserver-sogo rpm for 1.3.9 (is compatible with 1.3.10 and 11 too)

Many Thanks for the update which avoids all manual changes. Worked very well here (now on Sogo version 1.3.11).
Michael
Title: Re: SOGO for Sme
Post by: ilconte on December 13, 2011, 11:05:35 PM
oki have installed sogo but i receve other error :

/usr/sbin/sogod: error while loading shared libraries: libgnustep-base.so.1.20: cannot open shared object file: No such file or directory

sogo not loaded
Title: Re: SOGO for Sme
Post by: mdo on December 13, 2011, 11:27:22 PM
I suspect you have not all required rpms installed (which normally works automatically if you follow the install/update instructions in the Wiki).

Did you follow them correctly? http://wiki.contribs.org/Sogo (http://wiki.contribs.org/Sogo)

Maybe run again (should not harm):
 
yum install smeserver-sogo --enablerepo=nethsme --enablerepo=sogo
yum update --disablerepo=* --enablerepo=sogo
/etc/rc7.d/S85sogod restart
Title: Re: SOGO for Sme
Post by: moo2 on August 09, 2012, 11:32:54 AM
Hi,

and thanks for your work for making sogo install possible even for people like me :)

Actually I'm planing to install sogo on sme 8.0. But I have some questions left.

Is it possible to use/install the current 1.3.17 Version of sogo, or would it be 1.3.11 like postet in this thread a few month ago?

The Sogo website says (for debian) that it offers gpg signed packages now.
Quote
Since 2011-07-14, the builds are signed.  In order to verify their signature, our GPG public key has to be added into apt keyring. To do so, run the following commands:

sudo apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4
sudo apt-get update
From that point, apt-get should not complain about package signatures anymore.

So, could I change the installation described in the wiki the way, signed packages goes.
I mean would it work if I copy&paste their key into a file and save it as "RPM-GPG-KEY-sogo"
and than change the wiki guide a bit - into:

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

rpm --import RPM-GPG-KEY-sogo

Or do I have an error in my "plan"?
Title: Re: SOGO for Sme
Post by: _alex on August 09, 2012, 12:08:16 PM
You should follow the wiki by the book.
Title: Re: SOGO for Sme
Post by: moo2 on August 09, 2012, 12:38:20 PM
Yes but the book is old, maybe there was no gpg key back then, when it was written...
Title: Re: SOGO for Sme
Post by: _alex on August 09, 2012, 12:45:01 PM
Old? It actually is less than 2 months old.
Title: Re: SOGO for Sme
Post by: moo2 on August 09, 2012, 02:58:59 PM
Then please tell me, why not use gpg when it is available?

Or tell me that it won't work with gpg - but only telling "do as it written down" is a no answer of any of my questions.
Title: Re: SOGO for Sme
Post by: _alex on August 09, 2012, 03:05:50 PM
Because someone is maintaining a SME server specific SOGo repository, that's why.

Basically, follow the wiki, You'll get help and support, do otherwise and be on your own.
Title: Re: SOGO for Sme
Post by: perelandra on August 09, 2012, 08:42:24 PM
1.3.17 will work if you follow the wiki.

Though on Mac OS X 10.8 carddav is broken.
Title: Re: SOGO for Sme
Post by: perelandra on August 27, 2012, 06:03:11 PM
There was a bug filed in the SOGO bug tracker which describes, how to solve the problems when using Mac OS X Mountain Lion 10.8:

http://www.sogo.nu/bugs/bug_view_advanced_page.php?bug_id=1957

Could the dev of the sogo-smeserver contrib please have a look into that? Your help would be very appreciated!
Title: Re: SOGO for Sme
Post by: miroj on April 14, 2013, 06:54:36 PM
Hi, I have successfully installed SOGo 2.0.5 on SME 8 with all updates. I was using the wiki guidance on SOGo contrib. Everything went well, in the mails I can use Cyrillic but I can't within the calendar. Everything in Cyrillic goes in ????. The browser char set is set to UTF-8, as well I was adding the AddDefaultCharset UTF-8 as proposed in http://forums.contribs.org/index.php?topic=48792.0

All other is working like a charm, integration with Thunderbird+Lightning+Connector+Integrator, the same is with Evolution 3.4.2, but in all cases I do have issues with Cyrillic support within the calendar.

What I'm missing?
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 23, 2013, 12:49:28 AM
I am wondering if I am missing something here. I have set up Sogo using the wiki instructions but am unable to login. I tried using the passwd modification suggestion but was still unsuccessful.

Am I correct to assume that the current Mail user accounts should automatically work in SOGo?

Any guidance would be appreciated.

Thank you.
Title: Re: SOGO for Sme
Post by: stephdl on May 23, 2013, 07:26:49 AM
I am wondering if I am missing something here. I have set up Sogo using the wiki instructions but am unable to login. I tried using the passwd modification suggestion but was still unsuccessful.

Am I correct to assume that the current Mail user accounts should automatically work in SOGo?

Any guidance would be appreciated.

Thank you.
did you apply this workaround  ? did you restart the sogo service or eventually restart the server
http://wiki.contribs.org/Sogo#Login_doesn.27t_operate
because i had the same behaviour before to make the trick and when i wrote and apply it i'm now  able to log in sogo
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 23, 2013, 02:29:00 PM
did you apply this workaround  ? did you restart the sogo service or eventually restart the server
http://wiki.contribs.org/Sogo#Login_doesn.27t_operate
because i had the same behaviour before to make the trick and when i wrote and apply it i'm now  able to log in sogo

Yes I have made the modifications as noted but still get a Wrong username or password error when trying to login with my username and password (which does work for horde etc).


Title: Re: SOGO for Sme
Post by: stephdl on May 23, 2013, 09:14:30 PM
What about this sogo log, can you try to log and paste the latter lines of this log.

Code: [Select]
less /var/log/sogo/sogo.log
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 24, 2013, 03:11:00 AM
What about this sogo log, can you try to log and paste the latter lines of this log.

Code: [Select]
less /var/log/sogo/sogo.log

May 23 07:32:50 sogod [3298]: <0x0x9ef05dc[SOGoCache]> Using host(s) 'localhost' as server(s)
2013-05-23 07:32:51.191 sogod[3298] Note(SoObject): SoDebugKeyLookup is enabled!
2013-05-23 07:32:51.192 sogod[3298] Note(SoObject): SoDebugBaseURL is enabled!
2013-05-23 07:32:51.192 sogod[3298] Note(SoObject): relative base URLs are enabled.
2013-05-23 07:32:51.963 sogod[3298] WOCompoundElement: pool embedding is on.
2013-05-23 07:32:51.963 sogod[3298] WOCompoundElement: id logging is on.
192.168.1.231 - - [23/May/2013:07:32:51 GMT] "GET /SOGo HTTP/1.1" 302 0/0 1.052 - - 2M
2013-05-23 07:32:52.964 sogod[3298] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
192.168.1.231 - - [23/May/2013:07:32:53 GMT] "GET /SOGo/ HTTP/1.1" 200 3889/0 1.108 11838 67% 1M
May 23 07:32:55 sogod [3298]: <0x0xa1e6dec[LDAPSource]> <NSException: 0x9f28484> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "cn=jsmith,ou=groups,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: <0x0xa1d6d74[LDAPSource]> <NSException: 0xa1ea964> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "uid=jsmith,ou=users,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: SOGoRootPage Login from '192.168.1.231' for user 'jsmith' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
192.168.1.231 - - [23/May/2013:07:32:55 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/63 0.387 - - 448K
64.56.140.60 - - [23/May/2013:09:25:24 GMT] "GET /SOGo HTTP/1.1" 302 0/0 0.002 - - 0
2013-05-23 09:25:24.880 sogod[3298] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
64.56.140.60 - - [23/May/2013:09:25:24 GMT] "GET /SOGo/ HTTP/1.1" 200 3871/0 0.017 11814 67% 24K
May 23 09:25:41 sogod [3298]: <0x0xa1e6dec[LDAPSource]> <NSException: 0xa21a31c> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "cn=jsmith,ou=groups,dc=ourfamilyslife,dc=com"; }
May 23 09:25:41 sogod [3298]: <0x0xa1d6d74[LDAPSource]> <NSException: 0xa2f4174> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "uid=jsmith,ou=users,dc=ourfamilyslife,dc=com"; }
May 23 09:25:41 sogod [3298]: SOGoRootPage Login from '64.56.140.60' for user 'jsmith' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
64.56.140.60 - - [23/May/2013:09:25:41 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/83 0.004 - - 0
May 23 09:25:43 sogod [3298]: <0x0xa1e6dec[LDAPSource]> <NSException: 0xa2160ac> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "cn=jsmith,ou=groups,dc=ourfamilyslife,dc=com"; }
May 23 09:25:43 sogod [3298]: <0x0xa1d6d74[LDAPSource]> <NSException: 0x9ef05c4> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "uid=jsmith,ou=users,dc=ourfamilyslife,dc=com"; }
May 23 09:25:43 sogod [3298]: SOGoRootPage Login from '64.56.140.60' for user 'jsmith' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0
64.56.140.60 - - [23/May/2013:09:25:43 GMT] "POST /SOGo/connect HTTP/1.1" 403 34/83 0.004 - - 0

Hopefully that sheds some light on things...
Title: Re: SOGO for Sme
Post by: stephdl on May 24, 2013, 04:29:02 PM
I have tested on another SME virtual to validate the howto and it works
https://gist.github.com/anonymous/5643880

So these have to work on your sme :p...
2 questions

do you have done the signal-event command after the sogo and memcached installation
 from epel and sogo/nethsme repository ?
do you have restart the sogo service after you have made the trick which concerns /etc/passwd ?

Otherwise you could try to remove all packages installed and install the again.
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 24, 2013, 04:34:58 PM
I have tested on another SME virtual to validate the howto and it works
https://gist.github.com/anonymous/5643880

So these have to work on your sme :p...
2 questions

do you have done the signal-event command after the sogo and memcached installation
 from epel and sogo/nethsme repository ?
do you have restart the sogo service after you have made the trick which concerns /etc/passwd ?

Otherwise you could try to remove all packages installed and install the again.

I did the signal-event commands after each of the installs. I used the restart command on the sogo service, tested then stopped and started, tested then rebooted computer.

This is the second install attempt of SOGo as the original ended the same way. But I only uninstalled and reinstalled SOGo not memcached. Would memcached affect SOGo in such a fashion???
Title: Re: SOGO for Sme
Post by: stephdl on May 24, 2013, 04:53:25 PM
Is it a a sme8 ?
32 or 64 ?

can you past the return of this command to see if another contrib could make a mess

/sbin/e-smith/audittools/newrpms
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 24, 2013, 04:57:30 PM
Is it a a sme8 ?
32 or 64 ?

can you past the return of this command to see if another contrib could make a mess

/sbin/e-smith/audittools/newrpms

Yes it is SME 8 i386 install that was initially started at 8b6 and just upgraded to its present state over the years.

I will have to get the output of that command in about 7 hours as I will not be near it again until then.

I appreciate your help.
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 25, 2013, 08:21:31 AM
Is it a a sme8 ?
32 or 64 ?

can you past the return of this command to see if another contrib could make a mess

/sbin/e-smith/audittools/newrpms

Loaded plugins: fastestmirror, protect-packages, smeserver
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ca.planethoster.net
 * smeaddons: mirror.canada.pialasse.com
 * smeos: mirror.canada.pialasse.com
 * smeupdates: mirror.canada.pialasse.com
 * updates: centos.mirror.rafal.ca
Extra Packages
dimp-h3.noarch                       1.1.6-1.el5.sme                   installed
epel-release.noarch                  5-4                               installed
gnustep-base.i386                    1.23.0-1                          installed
gnustep-make.i386                    2.6.1-1                           installed
jdk.i586                             2000:1.6.0_23-fcs                 installed
jre.i586                             1.6.0_22-fcs                      installed
kronolith-h3.noarch                  2.3.5-1.el5.sme                   installed
libffi.i386                          3.0.10-1                          installed
libmemcached.i386                    0.34-1                            installed
memcached.i386                       1.4.5-1.el5                       installed
mimp-h3.noarch                       1.1.3-1.el5.sme                   installed
mnemo-h3.noarch                      2.2.4-1.el5.sme                   installed
nag-h3.noarch                        2.3.6-1.el5.sme                   installed
rpmforge-release.i386                0.5.2-2.el5.rf                    installed
smeserver-dimp.noarch                1.0-2.el5.sme                     installed
smeserver-kronolith.noarch           2.2-13.el5.sme                    installed
smeserver-mimp.noarch                1.1-3.el5.sme                     installed
smeserver-mnemo.noarch               2.2-5.el5.sme                     installed
smeserver-nag.noarch                 2.2-8.el5.sme                     installed
smeserver-sogo.noarch                0.6-1.el5.nh                      installed
sogo.i386                            2.0.5a-1.el5                      installed
sogo-tool.i386                       2.0.5a-1.el5                      installed
sope49-appserver.i386                4.9-20130416_1664.el5.1           installed
sope49-cards.i386                    2.0.5a-1.el5                      installed
sope49-core.i386                     4.9-20130416_1664.el5.1           installed
sope49-gdl1.i386                     4.9-20130416_1664.el5.1           installed
sope49-gdl1-contentstore.i386        2.0.5a-1.el5                      installed
sope49-gdl1-mysql.i386               4.9-20130416_1664.el5.1           installed
sope49-ldap.i386                     4.9-20130416_1664.el5.1           installed
sope49-mime.i386                     4.9-20130416_1664.el5.1           installed
sope49-sbjson.i386                   2.3.1-20130416_1664.el5.1         installed
sope49-xml.i386                      4.9-20130416_1664.el5.1           installed
sun-javadb-client.i386               10.5.3-0.2                        installed
sun-javadb-common.i386               10.5.3-0.2                        installed
sun-javadb-core.i386                 10.5.3-0.2                        installed
sun-javadb-demo.i386                 10.5.3-0.2                        installed
sun-javadb-docs.i386                 10.5.3-0.2                        installed
sun-javadb-javadoc.i386              10.5.3-0.2                        installed
Title: Re: SOGO for Sme
Post by: stephdl on May 25, 2013, 09:42:50 AM
I do not know what it is doing in your server, really it could operate...  :???:

Stefano do you  have an idea as i know that you play much more as me with SOGO ?

I assume that your server is up to date.
Title: Re: SOGO for Sme
Post by: Stefano on May 25, 2013, 12:30:16 PM
Code: [Select]
192.168.1.231 - - [23/May/2013:07:32:51 GMT] "GET /SOGo HTTP/1.1" 302 0/0 1.052 - - 2M
2013-05-23 07:32:52.964 sogod[3298] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
192.168.1.231 - - [23/May/2013:07:32:53 GMT] "GET /SOGo/ HTTP/1.1" 200 3889/0 1.108 11838 67% 1M
May 23 07:32:55 sogod [3298]: <0x0xa1e6dec[LDAPSource]> <NSException: 0x9f28484> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "cn=jsmith,ou=groups,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: <0x0xa1d6d74[LDAPSource]> <NSException: 0xa1ea964> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "uid=jsmith,ou=users,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: SOGoRootPage Login from '192.168.1.231' for user 'jsmith' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

it seems like your ldap server is down.. check the service and ldap's logs
Title: Re: SOGO for Sme
Post by: Parsival1973 on May 25, 2013, 06:41:20 PM
Code: [Select]
192.168.1.231 - - [23/May/2013:07:32:51 GMT] "GET /SOGo HTTP/1.1" 302 0/0 1.052 - - 2M
2013-05-23 07:32:52.964 sogod[3298] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
192.168.1.231 - - [23/May/2013:07:32:53 GMT] "GET /SOGo/ HTTP/1.1" 200 3889/0 1.108 11838 67% 1M
May 23 07:32:55 sogod [3298]: <0x0xa1e6dec[LDAPSource]> <NSException: 0x9f28484> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "cn=jsmith,ou=groups,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: <0x0xa1d6d74[LDAPSource]> <NSException: 0xa1ea964> NAME:LDAPException REASON:operation bind failed: Can't contact LDAP server (0xFFFFFFFF) INFO:{login = "uid=jsmith,ou=users,dc=ourfamilyslife,dc=com"; }
May 23 07:32:55 sogod [3298]: SOGoRootPage Login from '192.168.1.231' for user 'jsmith' might not have worked - password policy: 65535  grace: -1  expire: -1  bound: 0

it seems like your ldap server is down.. check the service and ldap's logs

ldap log

2013-05-25 10:54:07.755795500 @(#) $OpenLDAP: slapd 2.3.43 (Jul 12 2012 04:02:16) $
2013-05-25 10:54:07.755799500    mockbuild@builder10.centos.org:/builddir/build/BUILD/openldap-2.3.43/openldap-2.3.43/build-servers/servers/slapd
2013-05-25 10:54:07.755801500 /etc/openldap/schema/rfc2739.schema: line 32: Duplicate attributeType: "1.2.840.113556.1.4.478"
2013-05-25 10:54:07.755802500 slapd stopped.
2013-05-25 10:54:07.755803500 connections_destroy: nothing to destroy.

Now after seeing this I found and looked at the slapd.conf file and it has "include /etc/openldap/schema/rfc2739.schema" listed twice. I am wondering if this might be the problem. It appears there was a rfc27739 include file under templates for slapd.conf as well as kronolith entry with an include for the same rfc2739.schema. I moved the rfc one to another location, did a signal -event post upgrade and reboot and that seemed to have fixed everything.

SOGo now works beautifully.

A big thanks to stephdl and Stefano for helping me with this.
Title: Re: SOGO for Sme
Post by: stephdl on May 27, 2013, 03:31:27 PM
a big thank too it was a pleasure...but all reward goes to stefano who has seen the errors.

Can you document this error in the wiki page as we can find it the next time, please.
Title: Please do not attach further posts on different arguments concerning SOGo!!!
Post by: nicolatiana on May 27, 2013, 03:33:14 PM
Please do not attach other posts in this topic on different arguments concerning SOGo!!!
New issue ----> New topic and, if needed, BugTracker.
This is helpful for all users when searching within the Wiki.
 
Many thanks in advance  8) .
 
Nicola