ISPconfig3 + Sogo ?

Discussion in 'Tips/Tricks/Mods' started by i-chat, Jan 27, 2011.

  1. Turbanator

    Turbanator HowtoForge Supporter

    I see sogo 2.0.5 is released.
    Since I'm running Lenny and it had to be compiled...what do you recommend for performing the "upgrade" from 2.0.4b?

    btw, I still haven't touched the outlook/thunderbird stuff but will do so soon. I may need to upgrade to Squeeze though in order for it to work since I think samba 4 is required.
     
  2. Turbanator

    Turbanator HowtoForge Supporter

    So I reinstalled from your latest ISP-SOGO.sh w/update 7 (super job by the way) on a multiserver setup
    server 1: lenny 64: web, dns, mysql
    server 2: squeeze 64: mail (courier)

    Problem: I can't send emails outside the server/domain.
    I get the error:
    Warning
    Cannot send message: all recipients are invalid.

    I know you had notes on multiserver and I thought I did the correct steps, but maybe not.

    Any help would be greatly appreciated.

    This is step 1, then I'll move Sogo fully to Squeeze with samba 4 and get openchange working.
     
  3. psykosen

    psykosen New Member

    i can't say what the problem is, but it might be a sql lookup error,
    it sounds like a problem with sogo so your best bet is to search the sogo support/faq on the error there is a few others that had that error

    if it's a problem with the auto generated config file for sogo let me now, else i can't be of much help.
     
  4. Turbanator

    Turbanator HowtoForge Supporter

    I think I got it.

    .GNUstepDefaults was missing

    <key>SOGoSMTPAuthenticationType</key>
    <string>PLAIN</string>
     
  5. sjswarts

    sjswarts New Member

    Would it be correct in assuming that you have successfully setup ISPConfig 3 multi-server with SOGo implemented alongside?

    If so is that the full setup? Meaning that it has Openchange, Samba4, etc? Or is the cut down version supplying only the Web interface, which in turn is similar to the Roundcube setup?
     
  6. Turbanator

    Turbanator HowtoForge Supporter

    Currently only the web interface.

    I won't be able to attempt a full openchange/samba4 setup which will include moving the web interface to another server for a few weeks.
     
  7. Turbanator

    Turbanator HowtoForge Supporter

    Update on sogo in multiserver setup.
    server1 = ispc, web, dns, mysql
    server2 = mail, web, sogo, mysql

    Since ispc and users are on server1, in order to get sogo to work on server2, I had to create the sogodb and the views on server1 so that they could grab the ispc users info into the view. Then on server2, instead of creating views, I created a FEDERATED table on the server1_view. This way sogo would look at the table (thinking it was the view), which would actually talk to server1_view which would grab ispc users info.

    I don't know if this is the best way, but it's better than duplicating all ispc data on both servers.

    I'm still testing any drawbacks and glitches before I attempt openchange.
     
  8. forgefan

    forgefan New Member

    hi turbanator,
    have you had further progress with this?
    thanks.
     
  9. Turbanator

    Turbanator HowtoForge Supporter

    I have it working as I showed in the previous email. I installed funambol but decided not to go that route with openchange due to complaints of glitches. Instead I went with straight sogo connector for my TB users and webdav collaborator by Bynari bynari.net for Outlook users. It's not the best setup, but it works for me since I don't have may outlook users. Other than me not using it to the fullest, Sogo webmail is awesome and blows roundcube away.

    I would love some insight from someone who is using funambol and openchange with this though.
     
  10. Konflikted

    Konflikted New Member

    Just wanted to ask you did you create just the Views that are created for each mail domain or did you create a view based on each table in the sogodb?
     
  11. Turbanator

    Turbanator HowtoForge Supporter

    Only on the mail domains themselves.

    Just remember the trick is that server 1 has the Views, whereas Server 2 (mail server) has Federated tables on the Views...like a view of a View.
     
  12. Konflikted

    Konflikted New Member

    Thanks

    Works almost perfectly. Had to do some googling because I am an SQL Novice but I got it working pretty well. I can't think of any way that this could be improved on at least for multi-server environment.

    Oh and I went through the Openchange/Samba/Blah Blah Blah SOGo configuration and it isn't worth the trouble. When they promised Native Outlook I assumed that they were referring to a full MAPI type setup but not the case and after going through the setup I have come to the conclusion that it doesn't seem fit for a host-type setup its more for an enterprise environment or a soho office.

    Thanks so much for the information.

    Eric.
     
  13. misterm

    misterm HowtoForge Supporter

    Demo

    hello
    Happy New Year 2014
    Do you have a demo that shows how ispc 3 and OpenChange?
    Login to with Outlook?
    thank you
    cordially
    Mz
     
  14. Turbanator

    Turbanator HowtoForge Supporter

    I believe there is a youtube demo on the sogo.nu website. I never got openchange working and didn't really need it.
     

Share This Page