Mailuser interface

Discussion in 'Plugins/Modules/Addons' started by Horfic, Aug 23, 2009.

?

Would you like to see a mailuser interface for Roundcube & Squirrelmail?

  1. Yes

    217 vote(s)
    98.6%
  2. No

    3 vote(s)
    1.4%
  1. centosarus

    centosarus New Member

    Horfic,

    Looking forward to the new release. The current one has been working so great.

    Thanks for all you're doing.

    Centosarus
     
  2. Horfic

    Horfic Member

    Below are the installation instructions for the Mailuser plugins for Roundcube mail 0.3.x and 0.4.x combined with ISPconfig 3.

    Table of contents
    • Installation instructions
    • Troubleshooting and FAQ
      • (SOAP) Errors
      • Subversion (SVN)
      • Support
      • Other
    • Current Plugins Status
      • Current plugins included
      • Current languages supported
    • Disclaimer


    Installation instructions
    Assuming you have already installed Roundcube, follow the instructions below. If not, please download and install roundcube from http://roundcube.net/.

    1.
    Make sure you are using the latest stable ISPconfig. (Currently 3.0.2.2)
    If you want forwarding and/or autoselect plugin working, you need at least ISPConfig 3.0.3 Beta.

    2.
    Go to your ISPconfig panel and add a new remote user. (Tab "servers" > "Remote users")

    Tick
    • Mail Domain Functions
    • Mail User Functions
    • Mail Alias Functions
    • Mail User Whitelist Functions
    • Mail User Blacklist Functions
    • Mail Spamfilter User Functions
    • Mail Spamfilter Policy Functions
    • Mail Fetchmail Functions
    • Mail User Filter Functions
    • Client Functions
    • Server Functions

    3. (OPTIONAL IF ABOVE DOESN'T WORK!)
    Go to PHPmyAdmin and execute the following MySQL-query on your ispconfig database. Don't forget to edit the remote username in the query.
    Code:
    UPDATE `remote_user` SET `remote_functions` = 'mail_domain_get,mail_domain_add,mail_domain_update,mail_domain_delete;mail_user_get,mail_user_add,mail_user_update,mail_user_delete;mail_alias_get,mail_alias_add,mail_alias_update,mail_alias_delete;mail_forward_get,mail_forward_add,mail_forward_update,mail_forward_delete;mail_spamfilter_whitelist_get,mail_spamfilter_whitelist_add,mail_spamfilter_whitelist_update,mail_spamfilter_whitelist_delete;mail_spamfilter_blacklist_get,mail_spamfilter_blacklist_add,mail_spamfilter_blacklist_update,mail_spamfilter_blacklist_delete;mail_spamfilter_user_get,mail_spamfilter_user_add,mail_spamfilter_user_update,mail_spamfilter_user_delete;mail_policy_get,mail_policy_add,mail_policy_update,mail_policy_delete;mail_fetchmail_get,mail_fetchmail_add,mail_fetchmail_update,mail_fetchmail_delete;mail_user_filter_get,mail_user_filter_add,mail_user_filter_update,mail_user_filter_delete;client_get,client_get_id,client_add,client_update,client_delete;server_get' WHERE `remote_user`.`remote_username` = '<<REMOTE USERNAME>>' LIMIT 1 ;
    4.
    Note that the SVN version is the most up-to-date version of the plugins and should at any time be preferred over the archived form. Old (archived) versions which are online can harm or misconfigure your system and are NOT supported!

    Now download the latest ispconfig3-plugin package for roundcube.

    FOR ROUNDCUBE 0.3.x
    Commands to install per SVN:

    Make sure you're in your Roundcube root directory.
    Code:
    cd plugins
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube/branches/roundcube3/ .
    Don't forget the "." (period) at the end of the second command, or it could be creating a directory called "/roundcube3/". Obviously, this is not what we want.

    Commands if one uses SVN to update:

    Make sure you're in your Roundcube root directory.
    Code:
    cd plugins
    Code:
    svn up .
    Don't forget the "." (period) at the end of the second command, or it could be creating a directory called "/roundcube3/". Obviously, this is not what we want.

    FOR ROUNDCUBE 0.4.x
    Commands to install per SVN:

    Make sure you're in your Roundcube root directory.
    Code:
    cd plugins
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube/branches/roundcube4/ .
    Don't forget the "." (period) at the end of the second command, or it could be creating a directory called "/roundcube4/". Obviously, this is not what we want.

    Commands if one uses SVN to update:

    Make sure you're in your Roundcube root directory.
    Code:
    cd plugins
    Code:
    svn up .
    Don't forget the "." (period) at the end of the second command, or it could be creating a directory called "/roundcube4/". Obviously, this is not what we want.

    6.
    Copy the file "./ispconfig3_account/config/config.inc.php.dist" to "./ispconfig3_account/config/config.inc.php".

    7.
    In the configfile of the "ispconfig3_account" (/plugins/ispconfig3_account/config/config.inc.php) fill in your details:
    PHP:
    <?php
    $rcmail_config
    ['remote_soap_user'] = '<<REMOTE USERNAME>>';
    $rcmail_config['remote_soap_pass'] = '<<REMOTE PASSWORD>>';
    $rcmail_config['soap_url'] = 'http://<<YOUR SERVER>>:8080/remote/';

    ?>
    Change the port (set to "8080" by default) if necessary and please note that when using SSL to access ISPconfig panel, use "https://" instead of "http://".

    For example, if your username is "Santa", your password is "Claus", your server's domain is "christmas.com" (Or you can use an IP), your ISPconfig panel is accessed through port 1111, and you are not using SSL, your configuration would be:
    PHP:
    <?php
    $rcmail_config
    ['remote_soap_user'] = 'Santa';
    $rcmail_config['remote_soap_pass'] = 'Claus';
    $rcmail_config['soap_url'] = 'http://christmas.com:1111/remote/';

    ?>
    8.
    If you are just using one server for mail, don't use the autoselect plugin
    In the configfile of roundcube (/config/main.inc.php) look for this:
    PHP:
    // List of active plugins (in plugins/ directory)
    $rcmail_config['plugins'] = array();
    If other plugins are already enabled, add the following plugins to the array:
    Code:
    , "ispconfig3_account", "ispconfig3_autoreply", "ispconfig3_autoselect", "ispconfig3_pass", "ispconfig3_spam", "ispconfig3_fetchmail", "ispconfig3_filter", "ispconfig3_forward", "ispconfig3_wblist"
    Otherwise, replace it with the following:
    PHP:
    // List of active plugins (in plugins/ directory)
    $rcmail_config['plugins'] = array("ispconfig3_account""ispconfig3_autoreply""ispconfig3_autoselect""ispconfig3_pass""ispconfig3_spam""ispconfig3_fetchmail""ispconfig3_filter""ispconfig3_forward""ispconfig3_wblist");
    Any plugins that you want disabled, are to be removed from this line. For instance, if you do not wish to have "ispconfig3_pass" (password changer) enabled, omit ""ispconfig3_pass", ". It would then look like this:
    PHP:
    // List of active plugins (in plugins/ directory)
    $rcmail_config['plugins'] = array("ispconfig3_account""ispconfig3_autoreply""ispconfig3_autoselect""ispconfig3_spam""ispconfig3_fetchmail""ispconfig3_filter""ispconfig3_forward""ispconfig3_wblist");
    9.
    A new tab ("Accounts") should now be visible on your settings page in Roundcube, displaying all plugins enabled in step 8.

    Good luck!


    Troubleshooting and FAQ
    (SOAP, Roundcube) Errors:
    Q: I get an error "Soap Error: DTD Not Supported".
    A: Your soap url is set wrong. Please refer to steps 7 of the instructions.

    Q: I get an error "Soap Error no client with id $client_id found" when applying settings.
    A: Please refer to http://howtoforge.com/forums/showpost.php?p=214526&postcount=29 for a workaround for this problem. (Warning: Code modifications are NOT supported, this is just a workaround until this problem is solved. Use at your own risk!)

    Q: I get an error "Soap Error: you do not have permission to access this function roundcube" when using the plugins.
    A: You probably haven't configured the permissions for the remote ISPconfig user yet. Please refer to steps 2 and 3 of the instructions.

    Q: I get an error "Soap error : The login failed, username and password was wrong" when using the plugins.
    A: You probably haven't configured the permissions for the remote ISPconfig user yet. Please refer to step 2 of the instructions.

    Q: I'm getting an error "Soap Error: No user with username <yourusername> found." when applying settings using the plugins.
    A: Your remote user doesn't exist. Please refer to step 2 of the instructions.

    Q: I get an error "Wrong Version" when you try to use the spam plugin.
    A: You probably use than ISPConfig 3.0.3 Beta or higher. Please open the file {ROUNDCUBE PLUGIN DIR}/ispconfig3_spam/ispconfig3_spam.php.
    Change this on line 80
    Code:
    $update = $this->soap->mail_spamfilter_user_update($session_id, $spam_user[0]['id'], $uid, $params);
    to this
    Code:
    $update = $this->soap->mail_spamfilter_user_update($session_id, $uid, $spam_user[0]['id'], $params);
    Q: I get an error "SERVICE CURRENTLY NOT AVAILABLE! Error No. [524]" when using the plugins.
    A: There's a plugin enabled that is not available, please refer to step 8 of the instructions and check if only available plugins are in the array. If neccessary, delete any entries that are not available in your /plugins/ directory.

    Q: After I installed all plugins, I can't login.
    A: The autoselect feature will only work with ISPConfig 3.0.3 Beta or higher. So please disable it or upgrade ISPConfig.

    Subversion (SVN):
    Q: The SVN command co and up won't work for me.
    A: Try using the SVN commands checkout and update instead of co and up respectively.

    Q: SVN is not creating any folders.
    A: Check if the issued SVN command ends with a ".". Refer to step 4 of the instructions.

    Q: I've used an archived form of the plugins before but now I want to update using SVN.
    A: Refer to http://howtoforge.com/forums/showpost.php?p=217976&postcount=97

    Support:
    Q: Will the plugins be supported in my language?
    A: Please check language support below.

    Q: Is ISPconfig x.x.x or Roundcube x.x.x also supported?
    A: Currently only versions of these programs mentioned in the instructions are supported. Feel free to edit the plugin code to fit it to your own needs though.

    Other:
    Q: After I changed some settings using the plugins, changes don't immediately take effect.
    A: ISPConfig3 is using a Cronjob which runs every minute. So every change; password, autoreply, spamfilter, etc. takes effect after 1 min.

    Q: Can I make a function/plugin request?
    A: Feel free to do so. Please leave your comments/request in this topic.

    Q: Do you guys get paid for all this?
    A: Erm... No... just enjoy... Thanks would be nice. (Especially to Horfic since he did all the hard work... I just get to write about it :D)


    Current Plugins Status (As last updated instructions revision 100)
    Current plugins included:
    • Account overview (ispconfig3_account)
    • Fetchmail management (ispconfig3_fetchmail)
    • Autoreply management (ispconfig3_autoreply)
    • Spamfilter settings management (ispconfig3_spam)
    • Password management (ispconfig3_pass)
    • Mail User Filter management (ispconfig3_filter)
    • Forward management (ispconfig3_forward)
    • Black- and Whitelist management (ispconfig3_wblist)
    • Mail User Filter management (ispconfig3_filter)
    • Autoselect Mailserver (ispconfig3_autoselect)

    Current languages supported:
    • Brazilian Portuguese (pt_BR)
    • English (en_US)
    • German (de_DE)
    • French (fr_FR)
    • Italian (it_IT)
    • Polish (pl_PL)
    • Hungarian (hu_HU)
    • Dutch (nl_NL) (Gets currently translated)
    • Slovenian (sl_SI)
    • Spanish (es_ES)
    • Swedish (sv_SE)
    • Russian (ru_RU)

    Complete - One missing or incomplete - Two or more missing or incomplete

    If you can translate in any language not mentioned above, please post your translation in this topic. It will be uploaded to the SVN repository as soon as possible. A clean english language file can be found in the /plugins/ispconfig3_*/localization folders of each plugin. Thanks in advance for the effort made!


    Disclaimer
    Neither of the authors of the different parts of the plugins or the installation instructions are responsible for any harm/damage done to your system or any other problems as a result of using these plugins downloaded in either the SVN or any other copy otherwise obtained. By downloading and using the plugins, you agree to the fact that usage of the plugins, it's individual language packs, configuration files and installation instructions is at your sole risk and no responsibility can be taken by any of the authors.

    However if any problems do somehow emerge, please do feel free to ask for help in this topic and we'll see what we can do for you!
     
    Last edited: Oct 27, 2010
  3. HyperAtom

    HyperAtom New Member

    thanks for your latest release horfic. I am getting a bug shown in this screenshot. The logo seems to overlap your interface.

    [​IMG]

    Im using firefox 4 beta2 and will test other browsers soon.
     
  4. Horfic

    Horfic Member

    Which Roundcube version are you using?
    Did you installed the right one for your version?
     
  5. HyperAtom

    HyperAtom New Member

    0.4beta, yes I installed the correct one. I tested on stable firefox but still the same.

    Here is what I did,

    rm -rf ./.svn
    removed all previous plugins for mailuser interface
    then did your instructions

    Would be interesting to see if this is a problem with my setup or the interface itself.
     
  6. mats

    mats New Member

    When I enable the plugins I cant login anymore, it says connection to imap server failed. when I remove the plugins again for the main config I can login again.

    With roundcube 0.4
     
  7. HyperAtom

    HyperAtom New Member

    I also had this problem
     
  8. Horfic

    Horfic Member

    As I said, the autoselect and forward plugin need at least ISPConfig 3.0.3 Beta.

    The problem with the login comes from the autoselect plugin.

    PS: The 0.4 Version is just tested with the stable version of roundcube 0.4.
     
    Last edited: Aug 9, 2010
  9. Wojtek1

    Wojtek1 New Member

    in spam plugin localization don't work.
    if i change en_US.inc - work fine, but if another language file - without effect
    ispc 3.0.2.2 / rc 0.3
     
  10. Horfic

    Horfic Member

    You guys having problems to read?

    Look at the release post!!! For the language, atm is just Brasilien, English and German fully localized. All other languages are one partly implemented.
     
  11. Wojtek1

    Wojtek1 New Member

    every other plugins after translating work fine, i was translate myself ...
    every without spam.
    i'm not blind

    if You wish i send You full translation in Polish UTF-8 encoded.
     
    Last edited: Aug 9, 2010
  12. HyperAtom

    HyperAtom New Member

    Horfic, I updated roundcube to 0.4 stable and all is well.

    Although I can't login with that autocomplete plugin enabled.

    thanks :)
     
  13. Horfic

    Horfic Member


    Yes you can send them to me, or just attach them to your post. I will have a look, why your polish translation isn't working. Althougth switching to german, english or brasilien is working for me.

    PS: A lot of people having still trouble to read, especially, how to install this plugins.^^
     
  14. admins

    admins Member

    Hi horfic

    Thanks for your great work!

    If I wan't to download the files via svn the server gives following anser:
    Code:
    svn: Der Server hat einen unerwarteten Rückgabewert (405 Method Not Allowed) in Antwort auf die Anfrage PROPFIND für »/ispconfig3_roundcube3/trunk« zurückgeliefert
    
    Why does your server not allow :
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube3/trunk/ .
    Thanks an greets to austria from Switzerland :)
    adminst
     
  15. Horfic

    Horfic Member

    @Wojtek1 - As you see the user admins didn't read the post^^

    @admins - because we changed the repository url

    This is wrong!
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube3/trunk/ .
    Right would be even this for Roundcube 0.3.x
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube/branches/rouncube3/ .
    or this for Roundcube 0.4.x
    Code:
    svn co http://svn.web-wack.at/ispconfig3_roundcube/branches/rouncube4/ .
    PS: Greetings back!
     
  16. admins

    admins Member

    Hi

    I've tested with the newest roundcube 4 and ispc 3.0.2.2


    Modul Spamfilter: It's will good when we see the SPAM TAG2 level
    Modul Autoresponder: I think for the customer is not clear in wich format he must put in. It easyer with drop down


    For the rest: ist really good. And the implementation of the automatic language - perfect

    admins
     
    Last edited: Aug 11, 2010
  17. Wojtek1

    Wojtek1 New Member

    ok, here is updated polish translation for current Horfic plugin.
    is tested with ISPC3.0.2.2 and RC0.3.1
     

    Attached Files:

  18. HyperAtom

    HyperAtom New Member

    everything is working for me except the forwarding plugin.

    roundcube is 0.4 stable

    latest ispconfig3 release

    when clicking on the forwarding tab I get

    Soap error: function 'server_get' doesn't exist.
     
  19. Horfic

    Horfic Member

    Please refer to the "Release Post", I wrote there that the forwarding and autoselect will only work with ISPConfig 3.0.3 Beta or higher!!!!
     
  20. 007007

    007007 New Member

    where I have to install roundcube, usr/share/ or var/www/ ? what chmod ? root:root ?

    i have debian
     

Share This Page