ISPconfig3 + Sogo ?

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

  1. i-chat

    i-chat New Member

    Hi has anyone ever tried to intergrate Sogo: 'http://www.sogo.nu' with ISPconfig 'preferable with as mutch intergration as possible' Sogo is a reather neat opensource groupware solution running on both rpm and deb based distributions and it intergrates nicely with lots of email/pim clients like thunderbird and MS Outlook.

    I feal that it would grately benefit any 'budget or not-so-budget webhoster to be able to provide any superb alternative Microsoft Exchange by either hosting there own, (or leasing from another service provider).

    I feel that this could end up being a feature that diferents you from many other webhosts (specialy those off the shelve plesk hosts you get today).

    since im not experience in running isp config im starting this thread to talk bout this and maybe toghether find 'the perfect' debian ispconfig dns imap smtp (i have not installed pop3 since ages) and sogo install....


    what do you guys think, ????
     
  2. falko

    falko Super Moderator ISPConfig Developer

    I haven't tried Sogo, so I can't tell anything about it...
     
  3. i-chat

    i-chat New Member

    basicly is a set of data providers wih a online frontend client for webmail calendaring and other 'exchange-like' stuf it is based on ical (aple, mozilla others) and groepdav, syncML (via plugins) etc .... basis authentication seems to be mail based (courier and maybe others) and it used potgres or other db's (also mysql) of its data storage...

    iirc it can auth against ldap

    thats as mutch usefull info i can find about now as ive worked with it be fore but never implemented it myself...
     
  4. germinator

    germinator New Member

    SOGo seems like a very nice piece of software ... i am going to set it up on my development machine sometime next week at get back with a test result
     
  5. beyerservice

    beyerservice Member HowtoForge Supporter

    hey. i have tried that too, but it didn't work like i expected.
    configuration is done with strange config files (GNustep) and authentication only works with LDAP and i don't what to install another authentication server (mysql DB works fine for me). so i skipped that.
    Can you tell us, how it works or maybe write some nice howto?
     
  6. i-chat

    i-chat New Member

    well in trueth ive only yet used it as part of Ebox (now called zentyal) so i cant really share all to mutch info as to how and iff its fully cmpatible with ISPconfig,

    the fact of the matter ist that a 'groupware' addon will be a verry outstanding feature that many other pannels dont have.

    wheter it be sogo, egroupware or other matters not that mutch at all as long as its well-intergrated and proficiently compatible with the most used clients both desktop (outlook / thunderbird / evolution) webbased (ajax) and mobile (android / symbian / iphoneOS )

    so if this particular thing isn't going to work (or work easily thatn lets move on to somthing else... ?) i dont know,

    im hoping to get my hands on a decent testmachine pretty soon...
     
  7. d1sk0

    d1sk0 New Member

    Authentication against RDBMS *is* possible

    Not true. I'm using authentication against a view in PostgreSQL. Just use something like


    <key>SOGoUserSources</key>
    <array>
    <dict>
    <key>canAuthenticate</key>
    <string>YES</string>
    <key>id</key>
    <string>directory</string>
    <key>isAddressBook</key>
    <string>YES</string>
    <key>type</key>
    <string>sql</string>
    <key>userPasswordAlgorithm</key>
    <string>md5</string>
    <key>viewURL</key>
    <string>mysql://user:pass@host/db_name/table_or_view_name</string>
    </dict>
    </array>


    HTH,

    Andreas
     
  8. beyerservice

    beyerservice Member HowtoForge Supporter

    thank you. thats something im searching for. ill try that.
    can you post me your hole settings? im not happy with that config-tool...
    (want one *.conf file :)
     
  9. d1sk0

    d1sk0 New Member

    Example Config

    I'm not familiar with this forum stuff, so this post could look better… However this should get you going.

    Your DB needs at least 2 tables and 1 view (can also be a table, but you want integration with ISPConfig, don't you?). Actually my system is based on PostgreSQL, but shouldn't be that different with MySQL.


    Table "public.sogo_folder_info"
    Column | Type | Modifiers
    ------------------+-------------------------+------------------------------------------------------------------------
    c_folder_id | integer | not null default nextval('sogo_folder_info_c_folder_id_seq'::regclass)
    c_path | character varying(255) | not null
    c_path1 | character varying(255) | not null
    c_path2 | character varying(255) |
    c_path3 | character varying(255) |
    c_path4 | character varying(255) |
    c_foldername | character varying(255) | not null
    c_location | character varying(2048) | not null
    c_quick_location | character varying(2048) |
    c_acl_location | character varying(2048) |
    c_folder_type | character varying(255) | not null
    Indexes:
    "sogo_folder_info_pkey" PRIMARY KEY, btree (c_path)


    Table "public.sogo_user_profile"
    Column | Type | Modifiers
    ------------+------------------------+-----------
    c_uid | character varying(255) | not null
    c_defaults | text |
    c_settings | text |
    Indexes:
    "sogo_user_profile_pkey" PRIMARY KEY, btree (c_uid)



    Table "public.sogo_view"
    Column | Type | Modifiers
    ------------+------------------------+-----------
    c_uid | character varying(255) | not null
    c_name | character varying(255) | not null
    c_password | character varying(255) | not null
    c_cn | character varying(255) | not null
    mail | character varying(255) | not null


    Contents of /home/sogo/GNUstep/Defaults/.GNUstepDefaults:

    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE plist PUBLIC "-//GNUstep//DTD plist 0.9//EN" "http://www.gnustep.org/plist-0_9.xml">
    <plist version="0.9">
    <dict>
    <key>NSGlobalDomain</key>
    <dict/>
    <key>sogod</key>
    <dict>
    <key>OCSFolderInfoURL</key>
    <string>mysql://user:pass@host/db_name/sogo_folder_info</string>
    <key>OCSSessionsFolderURL</key>
    <string>mysql://user:pass@host/db_name/sogo_sessions_folder</string>
    <key>SOGoACLsSendEMailNotifications</key>
    <string>YES</string>
    <key>SOGoAppointmentSendEMailNotifications</key>
    <string>YES</string>
    <key>SOGoDraftsFolderName</key>
    <string>Drafts</string>
    <key>SOGoFoldersSendEMailNotifications</key>
    <string>YES</string>
    <key>SOGoIMAPServer</key>
    <string>localhost</string>
    <key>SOGoLanguage</key>
    <string>German</string>
    <key>SOGoMailDomain</key>
    <string>your-domain.tld</string>
    <key>SOGoProfileURL</key>
    <string>mysql://user:pass@host/db_name/sogo_user_profile</string>
    <key>SOGoSentFolderName</key>
    <string>Sent</string>
    <key>SOGoTimeZone</key>
    <string>Europe/Berlin</string>
    <key>SOGoTrashFolderName</key>
    <string>Trash</string>
    <key>SOGoUserSources</key>
    <array>
    <dict>
    <key>canAuthenticate</key>
    <string>YES</string>
    <key>id</key>
    <string>directory</string>
    <key>isAddressBook</key>
    <string>YES</string>
    <key>type</key>
    <string>sql</string>
    <key>userPasswordAlgorithm</key>
    <string>md5</string>
    <key>viewURL</key>
    <string>mysql://user:pass@host/db_name/sogo_user_view</string>
    </dict>
    </array>
    </dict>
    </dict>
    </plist>


    HTH,

    Andreas
     
  10. beyerservice

    beyerservice Member HowtoForge Supporter

    thank. you. i am testing this with ZEG in virtualbox.
     
  11. FlobbyDisk

    FlobbyDisk New Member HowtoForge Supporter

    Hi,

    I´m also interested in combining sogo and ispconfig, at the moment i have a small sogo server with mysql user-db to get some experience with sogo...

    i used this howto http://wiki.debian.org/SOGo to set up the sogo server...

    there was a thread on the sogo mailing list https://inverse.ca/sogo/lists/arc/users/2010-11/msg00080.html


    it might be possible to build a sync script between the ispconfig mail-user-db and the sogo-user db or even use the ipconfig table directly in sogo...

    there might be a problem with the different md5 used by sogo and ispconfig.... a password-hash generated in ispconfig looks different than the hash for the same password in sogo...

    FlO
     
  12. beyerservice

    beyerservice Member HowtoForge Supporter

    thank you so much! That did it.
    now i have to test some integration so ispconfig. but i thing we need some cron job whos updating sql tables in sogo/ispconfig.

    if got another problem here:
    Accessing https://sogo.vandervlis.nl/SOGo/dav/paul/Contacts/personal/ im getting wrong password message?

    my be that has something to to with this settings:
    i have to change my proxy settings so port:81.

    Update: changing port to something above 1024 worked now.
     
    Last edited: May 6, 2011
  13. Turbanator

    Turbanator Member HowtoForge Supporter

    Did anybody get SoGo fully running with ISPC3?....and willing to put a HowTo together?
     
  14. beyerservice

    beyerservice Member HowtoForge Supporter

    what would be great!
     
  15. FlobbyDisk

    FlobbyDisk New Member HowtoForge Supporter

    Hi,

    in the german forum there´s also a thread http://www.howtoforge.de/forum/allgemein-11/groupware-bzw-kalender-und-kontakt-funktion-4920/

    i have looked at the latest sogo 1.3.9 install documentation, and sogo now seems to support sha as encryption algorithm. theres also a bug report for it http://www.sogo.nu/bugs/view.php?id=1014 and http://www.sogo.nu/bugs/view.php?id=1197 for changing passwd


    does anyone know if ispconfig uses also sha for its mailuserpasswords??
    is there a documentation of the database-tables?


    mFg
    FlO
     
  16. dynamind

    dynamind Member

  17. sjswarts

    sjswarts New Member

    Does this mean SOGo is like a Horde system?
    Horde is quite good but doesn't integrate with Outlook.
     
  18. FlobbyDisk

    FlobbyDisk New Member HowtoForge Supporter

    I dont know Horde,
    but you can use SOGo as an Exchange replacement. you can connect Outlook to a sogo server without any plugin in Exchange Mode either directly or via outlook over https...
    The setup for this exchange compatibility is a little bit complicated, you need to setup samb4 and the user database has to be inside the samba ldap directory....
     
  19. sjswarts

    sjswarts New Member

    Cheers FlobbyDisk (classic name)...

    I figured that would be the case.
    Would anyone be willing to make a How to for ISPConfig 3.0.5 and SOGo?

    That would be the ultimate setup.
     
  20. psykosen

    psykosen New Member

    Sctip to add SOGo to ISPConfig

    hey there i have created a small script to add SOGo into ispconfig.
    so fare all my test are good but only on debian,
    you can find it here.
    http://cmjscripter.net/files/scripts/ispc/ISPC-SOGO-debian.sh

    have say sice work with the new ISPConfig 3.0.5, nice to see multi php conf..
    second sorry for my bad english.. :rolleyes:

    now since SOGo have a LOT of possibilities, and option the script is by fare complete but it sets up what your need to use it..

    when you run the script it wil add sogo mirror to your source.list
    install the gnupg key and install SOGo for use w. MySQL
    it give you a few options when running it,
    it wil also alter your ispconfig user to allow CREATE VIEW.
    it supports multi domains.
    creates i basic plugin for ispconfig to create the SOGo config file and creates the needed views in order to use your mail addr to login.
    one thing you need to know before running the script is that is NOT testing on a production server, AND SOGo automatic creates 3 tables per. user that login, so your ispconfig db will quickly become a large one (i'm working on a better solution for it.)

    besides installing SOGo you have the following files added
    /usr/local/ispconfig/server/plugins-available/sogo_config_plugin.php
    /usr/local/ispconfig/server/conf/sogo.conf-templ

    Adminitrator is [email protected]"
    if postmaster mail addr is not added go add it and login to SOGo to start administrat the domain
    Enable SOGo logins by update/delete or add a mail domain and the plugin wil do the rest...

    Regards.
    Christian

    ps. i love to here if the script is a piece of **** or something you can use but need some fixes
     

Share This Page