Hello, I'm a new user of ML Server and I'd like to know how I can install a webmail such as Roundcube.

Please go to the Roundcube directory first - like in a previous post - because else the last step in Terminal (\i SQL/postgres.initial.sql) will not work I'm afraid.

I've tried MySQL for my current RoundCube install and I was pleasantly supprised how well the installation went. Please not that I did not use terminal to execute the MySQL commands, but instead used the free MySQLWorkbench program.

Yes, you need MySQL Server...

You can download it here: Download

It is a free version supposedly for Snow Leopard, but it worked for me 🙂

There is just one setting that you need to alter before Roundcube can connect to your mail server and that is enabling the plaintext authentication in the Mail section of server app by clicking Edit... next to Authentication:. I didn't feel like it, but if you don't it won't work, so I did it...

p.s. if the Authentication already reads Automatic there is a good chance it will already work, but I have not tried that...

oh hey Mark23,

You can get Roundcube 0.8.1 to work with CRAM-MD5 for IMAP and SMTP authentication.

in config folder just edit main.inc.php and make necesary changes at the following lines:

FOR IMAP

----------------------------

$rcmail_config['default_host'] = 'ssl://mail.yourserver.com';

// TCP port used for IMAP connections

$rcmail_config['default_port'] = 993;

// IMAP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use

// best server supported one)

$rcmail_config['imap_auth_type'] = 'CRAM-MD5';

FOR SMTP

-----------------------

$rcmail_config['smtp_server'] = 'tls://mail.yourserver.com';

// SMTP port (default is 25; use 587 for STARTTLS or 465 for the

// deprecated SSL over SMTP (aka SMTPS))

$rcmail_config['smtp_port'] = 587;

// SMTP username (if required) if you use %u as the username Roundcube

// will use the current username for login

$rcmail_config['smtp_user'] = '%u';

// SMTP password (if required) if you use %p as the password Roundcube

// will use the current user's password for login

$rcmail_config['smtp_pass'] = '%p';

// SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use

// best server supported one)

$rcmail_config['smtp_auth_type'] = 'CRAM-MD5';

----

I gave you the wrong link, sorry...

If you download the 10.6 DMG (you probably have 64 bit) from the following page, you'll have the right one: http://dev.mysql.com/downloads/mysql/

After opening/unpacking you should see three items which you must install all three by double clicking them:

the *.pkg files (2)

the MySQL.pane file

If you then start the server through the preference pane, you need to accept some things, but then it should show up and running 🙂

At the startup screen of Workbench choose New Connection... under SQL Development.

In the resulting screen, just give your connection a name, the defaults are already set) and click OK.

Now you can double click the new connection and an SQL editor opens.

In the field titles Query1 enter:

CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;

GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY '<yourpassword>';

Then choose the Execute (All or Selection) from the Query menu.

Now your database has been created, but it's still empty. For that we have the roundcube-dir/SQL/mysql.initial.sql SQL script.

In Workbench reload the schemas by clicking the reload symbol to the right of the word SCHEMAS in the blue sidebar.

Now double click roundcubemail to make it the default.

Now in the File menu item click Open SQL Script... and browse to and select the mysql.initial.sql file and execute it again.

The only thing that remains is to make sure your main.inc.php file has the right content by running the installer again.

Now the error should be gone...

Hi Alexis,

No offense to you or Mark23 but you seem to be making a mountain out of a molehill. I pointed you to step-by-step instructions for installing Roundcube in this thread -https://discussions.apple.com/thread/4153247

They are clear and repeatable reliable following use by a large number of people within the community. It took less than 30 minutes to get up and running.

What particular problems did you have following these steps?

Alexandre did receive the message about your thread almost at the beginning, but chose not to use it, maybe because he thinks it is a bit too technical? At this point I started step-by-step instructions and together we chose another path. Shouldn't we be allowed to chose?

I don't think Alexandre wishes to withhold you from getting point, but if he does want to experiment a little, to grasp the concept and explore beyond what you already chewed out, I think it is his right, please respect other wishes than your own.

Well, I'm in the same jungle!

Check DB config

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

Anyone?

Through a series of unfortunate events, I have gotten really really good at installing RoundCube on my ML server. I prefer using the built in PostgreSQL dbms for the repository. I will do a video and write up on it and post back here when done to help fellow hobbyists like myself. It really is very easy, I was able to do it following the install guide and getting a little creative.

Tony