Previous 1 2 3 Next 178 Replies Latest reply: Oct 29, 2013 8:07 PM by davidh
pilbaraecho Level 1 (0 points)

In 10.7 server, we had a great filter for vacation messages built into webmail.

Users could configure this quite easily.


I can't find either webmail or vacation messages in Mountain Lion Server 10.8.


Any solutions?



Mac OS X (10.7), 10.7 Server
  • levindenboer1975 Level 1 (0 points)

    Good question! We would like to know also if this is possible?

  • mopedpan Level 1 (0 points)

    Hi pilbaraecho,


    webmail has gone, you have to install Rouncube by yourself ... :-(


    and vaction messages have to be configured manually, have a look at this thread:


  • redshift82r Level 2 (325 points)

    Hi pilbaraecho,


    maybe some more help.


    I installed Roundcube 0.7.2 yesterday. and enabled the managesieve plugin which enables vacation messages and other rules. Sieve is still enabled by default within dovecot on 10.8.  Theres a little bit of config to do but its not too bad.  Let me know if I can help.



  • mopedpan Level 1 (0 points)

    Hi redshift,


    which database you are using? postgres or mysql? I have difficulties with postgres adding user and tables ...

  • redshift82r Level 2 (325 points)

    Actually to give a bit more info .......



    I set up a seperate domain for the webmail - created a dns host entry - and created its own site in Websites (as an SSL site for extra security).  You copy the extracted roundcube archive and place it at the top level of your newly created site.


    Follow the install instructions. I used postgres but you can use mysql if you have it installed.  I tried an update from 0.5.1 but that didn't work.


    This is what you should type for the postgres setup under OS X.


    If you get an error with createing the user - i.e. it exists - dont worry! If roundcubemail exists as a database , just use another name  ( and remember it fotr the rest of the roundube install process, or drop the db.




    To use Roundcube with PostgreSQL support you have to follow these

    simple steps, which have to be done as the postgres system user (or

    which ever is the database superuser): for OS X 10.8, thats "_postgres"


    $ sudo createuser -U _postgres -d -s roundcube  (creates a superuser roll called roundcube in postgres)

    $ sudo createdb -O roundcube -E UNICODE roundcubemail

    $ sudo psql -U roundcube -d roundcubemail


    roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password';

    roundcubemail =# \c - roundcube

    roundcubemail => \i /"your path to webmail"/SQL/postgres.initial.sql

    roundcubemail => \q  (\? for help - \q to quit)




    You'll have to paste and save some install data as it asks you to. - do this - these are the files we'll change as required.

    Don't worry about testing (connecting to IMAP or SMTP within the install process as we have to change a couple of things to get it to work yet!

    settings to


    Under Server App - choose Mail and change the auth settings to Custom - and include cleartext.


    Nearly there!!

    in /your path to webmail/config/ - change these lines




    $rcmail_config['default_host'] = '';

    $rcmail_config['imap_auth_type'] = LOGIN;

    $rcmail_config['smtp_auth_type'] = 'LOGIN';

    $rcmail_config['login_autocomplete'] = 1;

    $rcmail_config['login_lc'] = true;

    $rcmail_config['plugins'] = array('managesieve','autologon');


    in /your path to webmail/config/ - check this line:


    $rcmail_config['db_dsnw'] = 'pgsql://roundcube:password@localhost/roundcubemail';  (postgres owner :password@localhost/databasename (these are the postgres role, password and databasename you set up above)


    I've just seen a question come through - so I'll add this now and in the next post take you through the managesieve setup!

  • redshift82r Level 2 (325 points)

    OK - part two - to get managesieve plugin configured in Roundcube



    In this file:


    your path to webmail/plugins/managesieve/  make the following changes


    // managesieve server port

    $rcmail_config['managesieve_port'] = 4190;


    $rcmail_config['managesieve_host'] = '';



    // authentication method. Can be CRAM-MD5, DIGEST-MD5, PLAIN, LOGIN, EXTERNAL

    // or none. Optional, defaults to best method supported by server.

    $rcmail_config['managesieve_auth_type'] = LOGIN;


    // default contents of filters script (eg. default spam filter)

    $rcmail_config['managesieve_default'] = '/var/lib/dovecot/sieve/default.sieve';



    // The name of the script which will be used when there's no user script

    $rcmail_config['managesieve_script_name'] = '';



    // Sieve RFC says that we should use UTF-8 endcoding for mailbox names,

    // but some implementations does not covert UTF-8 to modified UTF-7.

    // Defaults to UTF7-IMAP

    $rcmail_config['managesieve_mbox_encoding'] = 'UTF-8';



    // I need this because my dovecot (with listescape plugin) uses

    // ':' delimiter, but creates folders with dot delimiter

    $rcmail_config['managesieve_replace_delimiter'] = '';



    // disabled sieve extensions (body, copy, date, editheader, encoded-character,

    // envelope, environment, ereject, fileinto, ihave, imap4flags, index,

    // mailbox, mboxmetadata, regex, reject, relational, servermetadata,

    // spamtest, spamtestplus, subaddress, vacation, variables, virustest, etc.

    // Note: not all extensions are implemented

    $rcmail_config['managesieve_disabled_extensions'] = array();



    // Enables debugging of conversation with sieve server. Logs it into <log_dir>/sieve

    $rcmail_config['managesieve_debug'] = true;



    // Script name extension used for scripts including. Dovecot uses '.sieve',

    // Cyrus uses '.siv'. Doesn't matter if you have managesieve_kolab_master disabled.

    $rcmail_config['managesieve_filename_extension'] = '.sieve';



    // List of reserved script names (without extension).

    // Scripts listed here will be not presented to the user.

    $rcmail_config['managesieve_filename_exceptions'] = array();



    In yourpathto webmail/plugins/managesieve/managesieve.php




         * Loads configuration, initializes plugin (including sieve connection)


        function managesieve_start()




    If you dont change this line, it wont load the config file we changed above!




    And thats it!


    Remember that you can't test vacation rules by sending a message to yourself - it has to be a different address to be responded to  I had to read deep into the doco to find out why I wasnt triggering my vacation response!!


    Good luck from Down Under 

  • levindenboer1975 Level 1 (0 points)

    When installing Roundcube, what to fill in by the MySQL settings. Do you have to install first the MySQL binary software?


    Because we get this error:

    Check DB config

    DSN (write):  NOT OK(MDB2 Error: connect failed)

    Make sure that the configured database exists and that the user has write privileges



  • redshift82r Level 2 (325 points)

    You have to set up A database , whether Postgres or MySQL.  Use Postgres with the instructions I've given or read the MySQL install instructions in the Install document under the top roundcube directory.



  • redshift82r Level 2 (325 points)

    Not sure if it was obvious from my reply.." but , if you don't have MySQL already installed , probably safer to go with the apple installed Postgres :)

  • redshift82r Level 2 (325 points)

    Addendum - if you want to drop the existing roundcube db from Postgres, use:


    sudo drop -U _postgres roundcubemail

  • redshift82r Level 2 (325 points)

    Addendum 2


    If you want to start afresh from a Lion Server migration, you can also drop the roundcube role from a Lion Migrationn with:


    sudo dropper -U _postgres roundicube

  • redshift82r Level 2 (325 points)

    Flippin' auto spell on iPad ..... Try ...... sudo dropuser .......not sudo dropper ..... Also

    Anyone this helps, I'd be interested to hear back from!

  • mopedpan Level 1 (0 points)

    Hi redshift,


    I followed your instructions, but I didn't manage to get a database connection ... on commandline it works, but in roundcube I get still an connection error ... any ideas?



  • redshift82r Level 2 (325 points)

    Ok, so any more information you can provide would be helpful.  Where is it that you are getting no connection?

    Is it at the Roundcube installation screen?.

Previous 1 2 3 Next