Roundcube integration/module for ispconfig 3

Discussion in 'Feature Requests' started by Thorfinity, Apr 10, 2009.

  1. Thorfinity

    Thorfinity New Member

    hi

    I have tried ispconfig 2 and loved roundcube.

    Is it possible to integrate it with Ispconfig 3

    Thx a lot
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    Roundcube works fine wirh ISPConfig 3 as any webmail client with pop3 or imap support odes. Just create a nwe website e.g. webmail.yourdomain.com and you can install the normal roundcube version from the rouncube website in this website and it will work with ispconfig.
     
  3. yancho

    yancho New Member

    Is it possible to change mail user password from roundcube webmail interface?
     
  4. Horfic

    Horfic Member

    No, not in the Standard Package!
    YOu would have to fine a password changer patch or write your own patch.
     
  5. Horfic

    Horfic Member

    Here, I made quick a password changer script.

    Just read the Install.txt
     

    Attached Files:

  6. yancho

    yancho New Member

    Horfic, thank you very much! I owe you a beer :)
     
  7. Horfic

    Horfic Member

    Anytime you are in Austria.

    When you have any questions, just ask.

    PS: When you want, I can give you now a verison which also includes Autoreply.
     
    Last edited: Apr 12, 2009
  8. gjcomputer

    gjcomputer ISPConfig Developer ISPConfig Developer


    i would like to have this version, i also appreciate this
     
  9. Horfic

    Horfic Member

    Good here you go.
    The Password Changer + Autoreply.

    PS: The "with" Version also includes a extended Addressbook.
    PPS: For further interest look here: Link
     

    Attached Files:

    Last edited: Apr 14, 2009
  10. edge

    edge Active Member Moderator HowtoForge Supporter

    Hmm I keep getting a DATABASE ERROR: CONNECTION FAILED!
    Here is what I've done.

    1) Downloaded roundcubemail-0.2.1.tar.gz - Stable release from http://roundcube.net/downloads
    2) Downloaded your "ISPConfig3_for_0.2.1_with" file
    3) Uploaded roundcubemail-0.2.1.tar.gz, and "un" tar xvfz roundcubemail-0.2.1.tar.gz
    4) Unziped your ISPConfig3_for_0.2.1_with, and uploaded the files in the directorys to the corresponding ones from roundcubemail
    5) Renamed the db.inc.php.dist to db.inc.php and main.inc.php.dist to main.inc.php
    6) changed the line $rcmail_config .... (in db.inc.php) to $rcmail_config['ispconfig_db'] = 'mysql://ispconfig:password@localhost/dbispconfig';
    (note that as password in the above line I used the one found in /usr/local/ispconfig/interface/lib/config.inc.php, and that the password is (md5?) encrypted)

    Now when accessing my domain/roundcubemail I get a DATABASE ERROR: CONNECTION FAILED!

    Did I miss something here?
     
    Last edited: Apr 14, 2009
  11. Horfic

    Horfic Member

    I missed something. The SQL Code you have to add to your roundcube database.
    SO SORRRRRYYY!
    Code:
    # ----------------
    #
    # Database Additions for contact multiple emails
    # Run in PhpMyAdmin on the database that holds the RC Contacts table. Change the table name rc_contacts to your contacts table name:
    #
     ALTER TABLE `contacts` ADD `global_contact` TINYINT(1) NOT NULL default '0';
     ALTER TABLE `contacts` ADD `firm` VARCHAR(128) NOT NULL ;
     ALTER TABLE `contacts` ADD `position` VARCHAR(50) NOT NULL ;
     ALTER TABLE `contacts` ADD `p_tel` VARCHAR(30) NOT NULL ;
     ALTER TABLE `contacts` ADD `p_fax` VARCHAR(30) NOT NULL ;
     ALTER TABLE `contacts` ADD `p_mob` VARCHAR(20) NOT NULL ;
     ALTER TABLE `contacts` ADD `p_address` TEXT NOT NULL;
     ALTER TABLE `contacts` ADD `w_tel` VARCHAR(20) NOT NULL ;
     ALTER TABLE `contacts` ADD `w_fax` VARCHAR(20) NOT NULL ;
     ALTER TABLE `contacts` ADD `w_mob` VARCHAR(20) NOT NULL ;
     ALTER TABLE `contacts` ADD `w_address` TEXT NOT NULL;
     ALTER TABLE `contacts` ADD `notice` TEXT NOT NULL;
     ALTER TABLE `contacts` ADD `email2` VARCHAR(128) NOT NULL ;
     ALTER TABLE `contacts` ADD `email3` VARCHAR(128) NOT NULL ;
     ALTER TABLE `contacts` ADD `email4` VARCHAR(128) NOT NULL ;
    # -------------------------------------------------------------  
    But your problem sounds like that you didn't install Roundcube correctly yet. PLEASE READ THE INSTALL FROM ROUNDCUBE.

    PS: The Adressbook comes from Link
     
    Last edited: Apr 15, 2009
  12. edge

    edge Active Member Moderator HowtoForge Supporter

    Okay got it sort of working.
    I did do the install as mentioned in the install, but I replaced the "$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';" with the one from you!
    I should have read your install.txt better as it is saying " Edit the file {Place to roundcubefolder}/config/db.inc.php and add before ?>"

    Anyway. I needed to remove the .htaccess file as it was giving my server a hard time with "ERROR 500 - Internal Server Error!".
    Did you also needed to remove the .htaccess file to make RoundCube work on ISPconfig3?

    An other two things that do not work for me are the Autoreply (it will give me a 500 error when trying to access the page) and changing the password.
    I do see the password page, but when I hit "save" I get (like the Autoreply) a 500 error, and the password does also not get changed.

    I'm sure it's me!

    PS. I did add the new tables to the roundcube DB.
     
  13. Horfic

    Horfic Member

    No I didn't had to remove the .htaccess file.
    I created a sym link to my roundcube folder which is on my debian server at /usr/share/webmail/

    I'm at the moment not at home and I will look for a solution as soon I'm at home. Should be tomorrow.

    PS: I Use FastCGI php for my server and try to change the ip of the domain to a xxx.xxx.xxx.xxx or to *. ISPConfig seems to have here problems. Maybe that helps.
     
    Last edited: Apr 15, 2009
  14. edge

    edge Active Member Moderator HowtoForge Supporter

    FastCGI php did fix the .htaccess problem.
    I do still have the other two problems.

    I'll have a go at it later today again.
     
  15. edge

    edge Active Member Moderator HowtoForge Supporter

    Okay. Small update.

    I got it all working!
    For some reason the password that I got the 1st time from "/usr/local/ispconfig/interface/lib/config.inc.php" did not match at all in what I used in "/config/db.inc.php"
    I'm 100% sure that I did put in the correct password, but again it did not match at all when I had a new look today!

    I did do an apt-get update and apt-get upgrade today, but this could not have caused this problem!

    Anyway. RoundCube (and the extra two options) are now working great!

    Thank you.
     
  16. Horfic

    Horfic Member

    I'm glad it is working for you.:)

    I have already the solution to make the installation easier. The solution is the remote framework, but until it isn't finished, I get forced to use my own way to change the settings. So that users don't have to wait. :cool:

    PS: For further development look at LINK

    TO EDGE: I would like to know which settings php you had selected other than FastCGi, so I rese.arch that issue
     
    Last edited: Apr 16, 2009
  17. edge

    edge Active Member Moderator HowtoForge Supporter

    At the moment I've set my PHP to FastCGI.
    I'll give the other options a test run later today.

    Once again thank you for your help and contribution.
     
  18. edge

    edge Active Member Moderator HowtoForge Supporter

    Okay. Done some more testing.

    RoundCube with the .htaccess as is will only work in Fast-CGI PHP mode.
    Any of the other options (CGI / Mop-PHP and SuPHP) will give an ERROR 500 - Internal Server Error!
     
    Last edited: Apr 16, 2009
  19. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Did you check the Apache error logs?
     
  20. Horfic

    Horfic Member

    I think it has something to do with the htaccess file, which trys to change some php settings with php flag.
     

Share This Page