RoundCube

[nveid]

Whats the possibility of extending ISPConfig to handle other webmail based software, such as roundcube inparticular?

[falko]

You can build software packages for ISPConfig that integrate into ISPConfig, and that can be installed using the Update Manager. For instructions, have a look here:
http://www.howtoforge.com/wiki/index.php/Building_Packages_%28.pkg_files%29

or unzip the webmail package (the .pkg is a simple zip file) and have a look at its contents.

Of course, you could also simply create a web site in ISPConfig and install your webmail in that web site and give your customers the URL. :)

[web-worlds]

Falko,

I tried to follow the link, but I get a Access denied page ?

Thanks,
Web-worlds

[till]

We had to remove the wiki due to too much spamming attempts. I will publish the instructions on the ISPConfig development page in the next few days.

[juampi]

Whats the possibility of extending ISPConfig to handle other webmail based software, such as roundcube inparticular?

Hi!
I see the project and it's cool.
I will make some test on RoundCube with the pkg.

Regards,
JP

[juampi]

Hi!
I see the project and it's cool.
I will make some test on RoundCube with the pkg.

Regards,
JP

Well, the RoundCube is now in alpha version.
Be careful, don't install in a server in production.

JP

[juampi]

Now RoundCube is Beta Version: 0.1 I tried with ISPConfig and it work fine. I only could validate username, not username@domain. But I think that is possible, RoundCube can read a virtusertable. I am going to try to find a solution!

Regards,
JP

[sbecker]

any progress on this? I'd like to use RoundCube!

[paulrobert_a]

As for getting RoundCube in a ISPConfig pkg, I'm not sure as the wiki is still down... but for those having trouble getting this working within their ISPConfig setup, this may be of some help ;)

Follow the instructions from Paul Stamatiou's article (http://www.paulstamatiou.com/2005/10/29/how-to-setup-roundcube-webmail-on-your-server/).

After that all that's required is to configure the main.inc.php (http://www.archtree.net/main.inc.phps) file for ISPConfig.


<?php

/*
+-----------------------------------------------------------------------+
| Main configuration file |
| |
| This file is part of the RoundCube Webmail client |
| Copyright (C) 2005, RoundCube Dev. - Switzerland |
| Licensed under the GNU GPL |
| |
+-----------------------------------------------------------------------+

*/

$rcmail_config = array();


// system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace
$rcmail_config['debug_level'] = 1;

// enable caching of messages and mailbox data in the local database.
// this is recommended if the IMAP server does not run on the same machine
$rcmail_config['enable_caching'] = FALSE;

// lifetime of message cache
// possible units: s, m, h, d, w
$rcmail_config['message_cache_lifetime'] = '10d';

// automatically create a new RoundCube user when log-in the first time.
// a new user will be created once the IMAP login succeeds.
// set to false if only registered users can use this service
$rcmail_config['auto_create_user'] = TRUE;

// the mail host chosen to perform the log-in
// leave blank to show a textbox at login, give a list of hosts
// to display a pulldown menu or set one host as string.
// To use SSL connection, enter ssl://hostname:993
$rcmail_config['default_host'] = 'localhost';

// TCP port used for IMAP connections
$rcmail_config['default_port'] = 143;

// This domain will be used to form e-mail addresses of new users
// Specify an array with 'host' => 'domain' values to support multiple hosts
$rcmail_config['mail_domain'] = '';

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';

// Query to resolve user names and e-mail addresses from the database
// %u will be replaced with the current username for login.
// The query should select the user's e-mail address as first col
$rcmail_config['virtuser_query'] = '';

// use this host for sending mails.
// to use SSL connection, set ssl://smtp.host.com
// if left blank, the PHP mail() function is used
$rcmail_config['smtp_server'] = 'localhost';

// SMTP port (default is 25; 465 for SSL)
$rcmail_config['smtp_port'] = 25;

// SMTP username (if required) if you use %u as the username RoundCube
// will use the current username for login
$rcmail_config['smtp_user'] = '';

// 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'] = '';

// SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
// best server supported one)
$rcmail_config['smtp_auth_type'] = '';

// Log sent messages
$rcmail_config['smtp_log'] = TRUE;

// these cols are shown in the message list
// available cols are: subject, from, to, cc, replyto, date, size, encoding
$rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size');

// relative path to the skin folder
$rcmail_config['skin_path'] = 'skins/default/';

// use this folder to store temp files (must be writebale for apache user)
$rcmail_config['temp_dir'] = 'temp/';

// use this folder to store log files (must be writebale for apache user)
$rcmail_config['log_dir'] = 'logs/';

// session lifetime in minutes
$rcmail_config['session_lifetime'] = 30;

// check client IP in session athorization
$rcmail_config['ip_check'] = TRUE;

// the default locale setting
$rcmail_config['locale_string'] = 'en';

// use this format for short date display
$rcmail_config['date_short'] = 'D H:i';

// use this format for detailed date/time formatting
$rcmail_config['date_long'] = 'd.m.Y H:i';

// add this user-agent to message headers when sending
$rcmail_config['useragent'] = 'RoundCube Webmail';

// use this name to compose page titles
$rcmail_config['product_name'] = 'RoundCube Webmail';

// only list folders within this path
$rcmail_config['imap_root'] = '';

// store sent message is this mailbox
// leave blank if sent messages should not be stored
$rcmail_config['sent_mbox'] = 'Sent';

// move messages to this folder when deleting them
// leave blank if they should be deleted directly
$rcmail_config['trash_mbox'] = 'Trash';

// display these folders separately in the mailbox list
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash');

// default sort col
$rcmail_config['message_sort_col'] = 'date';

// default sort order
$rcmail_config['message_sort_order'] = 'DESC';

// Set TRUE if deleted messages should not be displayed
// This will make the application run slower
$rcmail_config['skip_deleted'] = FALSE;

// path to a text file which will be added to each sent message
// paths are relative to the RoundCube root folder
$rcmail_config['generic_message_footer'] = '';

// this string is used as a delimiter for message headers when sending
// leave empty for auto-detection
$rcmail_config['mail_header_delimiter'] = NULL;

// in order to enable public ldap search, create a config array
// like the Verisign example below. if you would like to test,
// simply uncomment the Verisign example.
/**
* example config for Verisign directory
*
* $rcmail_config['ldap_public']['Verisign'] = array('hosts' => array('directory.verisign.com'),
* 'port' => 389,
* 'base_dn' => '',
* 'search_fields' => array('Email' => 'mail', 'Name' => 'cn'),
* 'name_field' => 'cn',
* 'mail_field' => 'mail',
* 'scope' => 'sub',
* 'fuzzy_search' => 0);
*/


/***** these settings can be overwritten by user's preferences *****/

// show up to X items in list view
$rcmail_config['pagesize'] = 40;

// use this timezone to display date/time
$rcmail_config['timezone'] = 0;

// daylight savings are On
$rcmail_config['dst_active'] = TRUE;

// prefer displaying HTML messages
$rcmail_config['prefer_html'] = TRUE;

// show pretty dates as standard
$rcmail_config['prettydate'] = TRUE;

// end of config file
?>


When your finished you'll be able to login via your email address as well as your username.

Download my own CVS Snapshot 07 April '06 (http://www.archtree.net/rcmail-cvs-070406.tar).

[till]

Thanks for the RoundCube installation instructions.

As for getting RoundCube in a ISPConfig pkg, I'm not sure as the wiki is still down...

We had to remove thr wiki due to massive spam problems.

The package building instructions are avalable in the forum:

http://www.howtoforge.com/forums/showthread.php?t=3178

[paulrobert_a]

Thanks, I might just try my hand at creating a RC pkg :)

[paulrobert_a]

Here is the Package for RoundCube 0.1 (CVS 07 April '06) - 1.05MB
Mirror 1 (http://www.archtree.net/RoundCube.pkg)
Mirror 2 (http://www.abarobert.f2s.com/RoundCube.pkg)

Package also contains Red & Blue themes.

To uninstall run the following :
rm -rf /home/admispconfig/ispconfig/web/roundcubemail
rm -rf /home/admispconfig/ispconfig/web/tools/tools/roundcubemail
rm /home/admispconfig/ispconfig/web/roundcubemail.tar

[provell]

Hey,

Oke, hope you don't mind if tap in to this tread.
But this is just what I was waiting for in conjunction with ISPCONFIG.

I'l skip the UebiMiau pakage and pray this is stable enough.
The look en feel of this is great!!!

Thanks!!

Rgds Edo

[chrno]

Hi paulrobert_a,

Quick question, do I need to uninstall webmail before installing your roundcube?

The installation works fine. I was able to load up the roundcube login page. But it just keeps timing out and loads a blank page when I try to login using a valid username and password. Any ideas?

Many thanks!

chrno

[falko]

Quick question, do I need to uninstall webmail before installing your roundcube?

Unless the roundcube pkg also uses the directory /home/admispconfig/ispconfig/web/webmail, you don't need to uninstall Uebimiau.

[tom]

Here is an new old little bug from ISPC.

ISPC puts a wrong sender address in roundcubemail. So an mail like:
admin@.bla.top becomes admin@www.bla.top.


tom

[falko]

ISPConfig does not have configure RoundCube so if it's a bug it must be in RoundCube, not ISPConfig. But I guess this is just a configuration issue.

[tom]

ISPConfig does not have configure RoundCube so if it's a bug it must be in RoundCube, not ISPConfig. But I guess this is just a configuration issue.

But where to configure?

tom

[falko]

I don't know the RoundCube package, but I guess there must be a configuration file somewhere (maybe config.php, config.inc.php or something like that). Maybe you can also configure this through the RoundCube web interface.

[CyberCam]

I've installed RoundCube and it's up and running all good, except for one thing... I can not move any e-mails to the trash?? Any ideas why?

[till]

As far as i know, roundcube is still in alpha state, so dont expect all functions to work.

[CyberCam]

ok I'll continue to use uebimiau webmail client until this is up to par. Thanks!

[Hans]

I have RoundCube up and running here on my “Perfect Debian Sarge system” and looks very nice!
The last couple of weeks I have tried Horde & Squirrelmail, because the Uebimiau project looks very dead. Although RoundCube is still in Beta, it looks very good with an active community as well.
At the moment, I have Roundcube running parallel with Uebimiau, but when there is a stable version available, I switch over! So I made my choice!

What I did was the following:
I created a website within ISPConfig with SSL and MySQL enabled.
I downloaded RoundCube within this website and extracted it.
Changed the filenames db.inc.php.dist into db.inc.php and main.inc.php.dist in main.inc.php
I changed the timezone, login, password and databasename within the file db.inc.php as described here:
http://www.paulstamatiou.com/2005/10/29/how-to-setup-roundcube-webmail-on-your-server/
I created a new main.inc.php file for ISPConfig according paulrobert_a ‘s instruction in this thread.

There is a possiblility to login with username@domain.tld and only username without @domain.tld as well.

I had a problem within Roundcube (wrong timestamps for the e-mails), but in the meantime that is solved.

Tip: within the latest CVS version, there are more languages and themes available.

Although Roundcube has nothing to do with ISPConfig, also here is the username@www.domain.com problem. (The identity of the mailboxuser is not username@domain.tld as it should be).
Maybe Roundcube copies the name@www.domain.tld identity from the server somehow.

If they add more functionality/stability, Roundcube has a great future!

Hans

[till]

The last couple of weeks I have tried Horde & Squirrelmail, because the Uebimiau project looks very dead.

Seems as the UebiMiau project has awakened again :)

http://www.uebimiau.org/

[Hans]

That’s good to know Till, I hope the community will survive, because it is a nice webmail.
By the way, I have a small problem with Uebimiau, the timestamps of the e-mails are 1 hour to early. I have decribed it here:

Is there a solution for this?

Hans

[falko]

There were some other guys with this time problem, but I think they couldn't solve it. I have never had problems with Uebimiau's time.

UPDATE: I've just found this: http://www.howtoforge.com/forums/showthread.php?t=1420&highlight=uebimiau+time :)

[Hans]

Falko,

thanks for your reply, but i have that 64 bit fix already installed.
That fixes the notation on 64 bit systems.

I do not know why the timestamps are 1 hour to early yet but i hope i will find out soon.

Hans

[edge]

... Although Roundcube has nothing to do with ISPConfig, also here is the username@www.domain.com problem. (The identity of the mailboxuser is not username@domain.tld as it should be).
Maybe Roundcube copies the name@www.domain.tld identity from the server somehow.
Hans

Hans,

Did you / anyone ever find a fix for this?

I can change the name@www.domain.tld to name@domain.tld within roundcubemai > Personal Settings > Identities , but as soon as I logout, and back in again it's back to name@www.domain.tld!

[jnolla]

Installed through the Tool in Ispconfig, but can't receive? I can send!

Any help?

[falko]

Only with Roundcube? Can you recieve emails with a normal email client like Thunderbird or Outlook?

[firthusa]

I installed RoundCube through the Update feature and it seemed to install fine. I created some email accounts and went to tools and clicked on the RoundCube button however I cannot login. In fact it just sits there spinning and eventually times out. It does this on both IE & FireFox and neither give me any errors... they just sit there and spin. I'm running a fresh install of Debian following the tutorials on this site. Any advice would be greatly appreciated.

[till]

Any error messages in the mail.log?

Did you try the username and the email address for login?

[botum]

I installed RoundCube through the Update feature and it seemed to install fine. I created some email accounts and went to tools and clicked on the RoundCube button however I cannot login. In fact it just sits there spinning and eventually times out. It does this on both IE & FireFox and neither give me any errors... they just sit there and spin. I'm running a fresh install of Debian following the tutorials on this site. Any advice would be greatly appreciated.
You can solve this by sending a first email to the account, so the folder INBOX will be created.

Then you might have problems with Trash folder...

I solved the trash problem (standalone roundcube, not with ISPC) whith this patch.

http://trac.roundcube.net/trac.cgi/ticket/1471594

[jockstrap]

I had 2 problems after my install;

1) could not move files to trash - the code fix link posted by BOTUM above fixed that.

2) was putting a www. infront of the domain when sending emails. You could change this in preferences but when you logged back in it reverted back. This is fixed if you login as the real userid - ie: web1_username instead of using the email address to login with. Well, seems to work ok for me anyway.

[danbogos]

I had 2 problems after my install;

1) could not move files to trash - the code fix link posted by BOTUM above fixed that.

2) was putting a www. infront of the domain when sending emails. You could change this in preferences but when you logged back in it reverted back. This is fixed if you login as the real userid - ie: web1_username instead of using the email address to login with. Well, seems to work ok for me anyway.

I have gone thru all the problems you were getting, with no automatic folders creation, and the biggest, which was non acceptable for my users, the www which was keep coming in contact info.

I will describe here my workarround, so at least you should not spend the same time which I did on it.

The problem comes from Round Cube, which is looking into the mail server alias file (my case postfix). There, ISPConfig has set up the first alias prefixed with www, as your default host name was configured.
Now, everytime when you will log in without www user@domain.com, RoundCube will assume that you are a new user, and will open a new account in it's database (all the user settings are automatically saved in RoundCube database). If you will try loggin in with user@www.domain.com, you will see that the settings for contact will be saved and next time you will log in , you will have the same thing. Moreover, everytime you will log in with different aliases, you will get different settings saved for each of them :).
After I digged through ISPConfig forum, I found out that the problem with aliases will be there till some next release, where you will be able to select your aliases type (with or without hostname). Then, our problems will be completed sort out.
Till then, what you can do, and what I did, was, creating a separate aliases file, only for rouncube, where you will put the usernames, exactly in the way you need them.
Ex of entry in roundcube_alias
user@domain.com web1_user
After you will have the file, you should change the value of $rcmail_config['virtuser_file'] in /home/admispconfig/ispconfig/web/roundcubemail/config/main.inc.php.
The only problem which you will still have, it will be adding one new alias for each user newly created on your system. The advantage is that you can have users with pop3/imap and users with webmail access ;).
If I was not clear enough, I am available for questions.

Cheers,
Dan

[wr19026]

Can anyone tell me if (and how) the problem with RoundCube (installed from the pkg) not saving preferences is fixed?

[falko]

Did you have a look here? http://www.howtoforge.com/forums/showthread.php?t=4843&highlight=roundcube+preferences

I've never installed Roundcube because it's still in alpha or beta stage...

[wr19026]

I have and it's not real easy to understand (for me anyway :)) So as much as I'd like to be able to use RoundCube, I guess that UebiMiau is my webmail client of choice for now.

Having said that, does anyone have a more recent version of UebiMiau in pkg format? My understanding is that UM now also supports IMAP which I'm really looking for.

I've seen the thread on UM updates but no follow up (as in Ï have done it and you can get the package here") ....

[jockstrap]

Can anyone tell me if (and how) the problem with RoundCube (installed from the pkg) not saving preferences is fixed?

Hi - as my post above says...

Preferences for me ARE being saved if users login with their system user name and NOT their email address..

In ispconfig - I opted to remove the webx_ userid prefix. so each user gets a username like joesmith...

If they log into roundcube with "joesmith" and NOT "joesmith@domain" then everything is fine with saving preferences.

I have not setup many users yet, so try it and see if it works ok for you...

The only problem I seeming to have now is that AUTORESPONDER is not working properly. It chooes to work one or twice then stop ???? seems it may be sending the response to admispconfig@localhost but not sure why yet!

[till]

The only problem I seeming to have now is that AUTORESPONDER is not working properly. It chooes to work one or twice then stop ????

I guess you tested the autoresponder several times from your account? The aotoresponder stores the email addresses where it sends the message so every account will get the message only one time to avaoid message loops.

seems it may be sending the response to admispconfig@localhost but not sure why yet!

That is not the autoresponder message, the messages to admispconfig are for statistic generation, dont try to redirect these messages to another account!

[jockstrap]

Thanks Till,

That explains a lot now... :)

two more questions;

1) How long before the same email account can send an email and receive another auto response ?

2) is there anywhere in the scripts that I can maybe disable this feature so they always get replies ???

Cheers - Jockstrap

[falko]

2) is there anywhere in the scripts that I can maybe disable this feature so they always get replies ???

Have a look at /root/ispconfig/scripts/lib/classes/ispconfig_procmail.lib.php and search for the string ".vacation.cache".

[jockstrap]

Falko,

That file didn't really help but I found that if I removed the -D option in formail in the autoresponder.rc.master template and then removed the existing .vacation.cache file from the users Maildir directory - this did the trick.

I changed autoresponder.rc.master as follows;

changed --> | formail -rD 8192 .vacation.cache
to --> | formail -r 8192 .vacation.cache

This means now that an autoreply will always be sent - even if to the same email again.

FYI - for anyone else who may want to disable the "send once" autoresponder feature.

[falko]

http://www.howtoforge.com/forums/showpost.php?p=33317&postcount=5 :)

[jockstrap]

http://www.howtoforge.com/forums/showpost.php?p=33317&postcount=5 :)

Thanks Falko - I was also wondering how that should happen. Will be a nice fix :)

[TobiasTM]

I´ve found the solution of one of the known problems with RoundCubeMail.

Look here: http://www.howtoforge.com/forums/showthread.php?t=5710

Maybe it´s possible that this can be fixed in one of the next versions of ISPConfig in Maildir-Mode (by automatic creating an additional folder named "trash" when a new email-account were created)?

[falko]

Maybe it´s possible that this can be fixed in one of the next versions of ISPConfig in Maildir-Mode (by automatic creating an additional folder named "trash" when a new email-account were created)?
We didn't make the RoundCube .pkg. It was made by someone else (we only put it on the ISPConfig web site), and he used the normal RoundCube download so it's still a problem the RoundCube developers should fix.

[TobiasTM]

No - what I mean is the following:

If you use Maildir and create a new user in ISPConfig, there will be created some folders. Right ?

Why not one folder more with the name "Trash" ?
Or does it give there some config-files where I can set this options ?

[till]

No - what I mean is the following:

If you use Maildir and create a new user in ISPConfig, there will be created some folders. Right ?

No, not by ISPConfig. The folders where created by postfix.

Why not one folder more with the name "Trash" ?
Or does it give there some config-files where I can set this options ?

Please have a look here:

http://www.howtoforge.com/forums/showthread.php?t=5722

[TobiasTM]

Okay - I´m sorry - but I didn´t know it until now :D

[AlecWeb]

Hi!

I found a very simple and easy hack to remove the www. from www.myhost.tld for mailadresses

Just edit the following line in /home/admispconfig/ispconfig/web/roundcubemail/program/include/main.inc on line 551

from
$line = trim($line);
to
$line = trim(str_replace("www.", "", $line));

PS: This only works for new users that aren't yet in the roundcube database

[wr19026]

Thanks! This works nicely. And after initial setup it also works for users who have already been using RoundCube mail before.

[hahatoday]

Hi,

I have ISPconfig 2.2.5 and lastet roundcube mail downloaded from ISPConfig page.

I have faced the problem with the following scenario:

1. A (a@yahoo.com) sent an email with attachement to B(a user of roundcube webmail)

3. When B forward the mail to others, the attachement gone !????...

I have tried many scenarios, and found that this problem only happened to Yahoo mail, others like gmail and hotmails are ok.

Any help would be appreciated.....

Thanks!

[falko]

Does this happen only with RoundCube, or also other webmail packages or email clients? Are you on a dynamic IP address?

[letic]

For info roundcube 0.1beta2 has been released : http://sourceforge.net/forum/forum.php?forum_id=598788

See http://www.roundcube.net/

I don't know who initally did the pkg, or if somebody could update it.

I will look into it as well when I will have a bit more time, to see how it was build and if I can make a new version.

[Hans]

THat's a good plan!
It would be nice if the .pkg will be updated soon.
By the way it would be nice if the date is mentioned on the ISPConfig website, same as we do for Uebimiau. Then we recognise if it is updated or still not.

[Ben]

I'm already working on it...

[paulrobert_a]

Hey folks,

Sorry for not keep up with this thread, I'm the creator of this package, I've got a updated pkg file available but comes with a health warning, I haven't tested it at all! So be warned :)

I've included 3 more themes and modified main.inc as AlecWeb has suggested

Primary (http://www.archtree.net/RoundCube0.1-beta2.pkg) download
Secondary (http://myweb.tiscali.co.uk/archtech/RoundCube0.1-beta2.pkg) download

Once I've got a free minute I'll test this out on my ISPConfigVM.

[paulrobert_a]

Just tested in ISPConfigVM, everything seems to be in working order.

Installed & logged in no problem
AlecWeb's suggestion seems to be working too

[letic]

Hey Paul !!

Thanks a lot for that ! :)

I just installed it and all went flawlessly except for the display names that go back to the ISPConfig default (webX_user). But everything else works fine !

This interface is really amazing now with the search and the spelling checks !

[Ben]

@letic: Did you upgrade or just a fresh install?

[paulrobert_a]

oh! yeah when upgrading you'll need to save your original database file otherwise it'll be overwritten with the default one. Sorry about that!

[jockstrap]

PaulRobert - Love it! Thanks heaps...

The only problem I seems to have atm is the "Return Receipt" does not seem to work for me - but this could be my network? But did not work for gmail account either?

Do you know if it should working or still a bug?

[paulrobert_a]

Hi jockstrap,

I'm sorry I don't use that function, you'll need to check with the roundcube forums (http://roundcubeforum.net/) for that.

[edge]

Thanks for the update paulrobert_a, but I still having lots of problems with RoundCube.

1) When going to the Folders option it's listing all the folders of the directory

http://www.showthatimage.com/vip/00223231/folders.gif

2) When doing a spellcheck, it's giving me an error was encountered on the server. Please try again later.

http://www.showthatimage.com/vip/00223231/spelling.gif

3) After the spellcheck error an extra button gets added.
(in this example I've done the spellcheck 2 times)

http://www.showthatimage.com/vip/00223231/extra-buttons.gif


Please note that I'm using IE7 (beta)... So this migh be causing problem 2 and 3.

[letic]

@Ben

Upgrade but I think Paul already answered for me :)

@edge

I try here but couldn't reproduce the issue you're reporting... I think you should ask on the roundcube forums instead.

[jockstrap]

@paul robert...

Sorry - must be my network, i tried from work tonight and reply received ok...
Thanks..

[wr19026]

After the upgrade I only see 2 languages: English (GB) and English (UK).

How can I get additional language packs (specifically, Dutch and German) installed? Also, I can't find the different themes or new functionality that is mentioned.....

So I reverted back to the version on the ISPConfig download page.

Still, this probably is one of the most interesting webmail clients available so I definitely want to update it!

[edge]

I think that in problem 1. It's because it's the main (administrator) email account.

The 3rd problem is I think IE7 (beta) that is causing the error.

I'll give it a go later with IE6.

[paulrobert_a]

After the upgrade I only see 2 languages: English (GB) and English (UK).

How can I get additional language packs (specifically, Dutch and German) installed? Also, I can't find the different themes or new functionality that is mentioned.....

So I reverted back to the version on the ISPConfig download page.

Still, this probably is one of the most interesting webmail clients available so I definitely want to update it!
Hi wr19026,

Sorry this was my fault, I've used my installed copy to re-create the pkg file, since I'm the only user, I didn't require the other languages. I've now updated the pkg to include all the languages contained within the roundcube tar file. Just re-download the pkg (http://www.howtoforge.com/forums/showpost.php?p=36861&postcount=58)

As for the skins, you need to change your 'main.inc.php' to whatever skin you want to run. There should be 6 to choose from, blue, BlueTabby, default, icandy2, red, white.

[Hans]

I think that in problem 1. It's because it's the main (administrator) email account.

The 3rd problem is I think IE7 (beta) that is causing the error.

I'll give it a go later with IE6.

I have installed RoundCube v0.1-beta2 according the "how to" at URL http://paulstamatiou.com/2005/10/29/how-to-setup-roundcube-webmail-on-your-server/

(So NOT with the pkg file for ISPConfig).

I have to say that everything is functioning very fine with this version!
I can not confirm that all file(folders) are visible as on your server.
Only when i login with the administrator account of a domain the vacation and vaction.cache are visible.

[Tenaka]

I tried pauls how to as well, but all I get on the main page is a very blank page. btw. I had to delete the .htaccess as that gave me a server error...

p.s. no errors inside /var/log/apache/error.log no mysql error, mysql data is correct.

###edit###
SOLVED
some eerrors seemed to have occured when executing the sql => DB

[wr19026]

Hi wr19026,

Sorry this was my fault, I've used my installed copy to re-create the pkg file, since I'm the only user, I didn't require the other languages. I've now updated the pkg to include all the languages contained within the roundcube tar file. Just re-download the pkg (http://www.howtoforge.com/forums/showpost.php?p=36861&postcount=58)

As for the skins, you need to change your 'main.inc.php' to whatever skin you want to run. There should be 6 to choose from, blue, BlueTabby, default, icandy2, red, white.

Great, thanks!

Just one additional question though: the page titel says: welcome to digital servitude.com webmail portal

Where do I change this? I tried changing the config file rcmail_config['product_name'] but that's already set to RoundCube Mail

Also, what I really like is the nnotice on the login screen that tells you "Username should include your domain (ie user@digitalservitude.com)"

What file do I need to modify to personalize that?

[Tenaka]

I found a thread http://roundcubeforum.net/forum/index.php?topic=232.0 where one attempt to allow automatic account creation is described, would this be possible with a system like ispconfig which uses real system users and not virtual users?

[till]

I found a thread http://roundcubeforum.net/forum/index.php?topic=232.0 where one attempt to allow automatic account creation is described, would this be possible with a system like ispconfig which uses real system users and not virtual users?

I think this will be posiible when you use the ISPConfig remoting framework.

[yfastud]

Hi edge, did you solve the problem yet? I didn't get the same problem, but the spellcheck didn't work at all no matter in IE or FF (Firefox). Please, post the solution if any. Thanks in advance.










Thanks for the update paulrobert_a, but I still having lots of problems with RoundCube.

1) When going to the Folders option it's listing all the folders of the directory

http://www.showthatimage.com/vip/00223231/folders.gif

2) When doing a spellcheck, it's giving me an error was encountered on the server. Please try again later.

http://www.showthatimage.com/vip/00223231/spelling.gif

3) After the spellcheck error an extra button gets added.
(in this example I've done the spellcheck 2 times)

http://www.showthatimage.com/vip/00223231/extra-buttons.gif


Please note that I'm using IE7 (beta)... So this migh be causing problem 2 and 3.

[wr19026]

Other observation: (apart from page title and login screen not being anonymous); when I log in and want to go to Preferences it takes me back to the login screen and when I'm trying to log in it tells me that there already is an active session.

So I changed back to the version on the ISPConfig website until the next pkg is available.

And another question: where is the RC preferences information stored? I can't see a seperate database with phpmyadmin but after removing RC and reinstalling it (using the pkgs) it still recognizes my preferences.

[wr19026]

It appears that the "customized" page name and login screen are part of the BlueTabby skin.

[paulrobert_a]

Hey Folks,

I've updated the roundcube package again, this one is from SVN rev 334, this rev includes database changes, and an updated BlueTabby theme.

For those you wish to maintain their current database, please back it up, replace the one from the package and manually update the sqlite database yourself.

Please don't contact me for support, I only created the package. For all support queries, please direct them to the roundcube forums (http://www.roundcubeforum.net/).

Thanks!

The Download (http://www.archtree.net/RoundCube0.1-beta2-334.pkg)

[falko]

Thanks a lot! :)

[schmidtedv]

Nice :-) ...had errors in IE with attachments loading up...zip-files where broken, but now it seems to work...only the email-button seems to have a damaged icon...

[schmidtedv]

...actually, by taking the last package you still would have to use some modification in config/main.inc.php to set it from "en" to "de" if you prefer german...and, because these are missing, localization/index.inc shouldlook like this:

$Id: index.inc 323 2006-08-23 21:36:37Z thomasb $

*/

$rcube_languages = array(
'de_DE' => 'Deutsch (DE)',
'en_US' => 'English (US)'
);
$rcube_language_aliases = array(
'de' => 'de_DE',
'en' => 'en_US'
);
$rcube_charsets = array();

?>


Well and finally the de_DE package (...korrigiert und erweitert) would be in the attachment :-)


...hm, then, at last you might have to take a look in the default-skin-buttons-folder, if all png's an the gif-file are ok, three of mine where broken, so I took them from one of the other, similar skins

[Tenaka]

can someone tell me how to prevent users from editing their sending email addresses under identities? I just want them to be stuck to the one I gave them, not experimenting with this feature...

[sushestvo]

I have latest (R 334) package installed.
But a lot of times I experience one problem (other users as well), and actually had it in previous version before this update (i thought it would help, but it didn't). When I read some emails - it just kicks me out saying my Session is invalid or expired. If I try to log back in, it won't let me saying the same thing, after N amount of tries I will get in - but after a while it will again kick me out w/o any errors (I assume it doesn't have time to show them, kicks me out too fast).
Anyone else experienced this? It makes it totally impossible to read emails :(

[schmidtedv]

hm, the only time I have this problem is right after updating...my easiest way for that was to reboot server (might not be necessary, but didn't disturb to do so). After this the sessions seemed to work correct.

[sushestvo]

anyone else experienced this?
I don't really want to reboot the server if it's not gonna solve the problem (especially after each update) as it's in production and a lot of people will be pissed =)
But if I have to, then I have to/... just wanna make sure it will solve it.

[schmidtedv]

...it might...with me, there was the problem, that I actually couldn't log in after updating...it showed me everytime that my session was expired. So that might be a bit different to your problem in that case...

[damir]

I have the same issues. I switched to another webmail application.

Have u guys tried to reboot ? Can u confirm is it works after the reboot.

[Ben]

I don't really think that reboot itself will help, but more the fact that all services are shut down and started up again.
But roundcube only uses apache + mod_php (or other php implementation) and eventually mySQL if you not use sqli. So restarting apache and depending on your configuration restarting mysql as well should be fine....

[Hans]

Hi all,

Today i've posted a "how to" to setup RoundCube webmail in the webspace of your choice running on port 80. This is an alternative for the RoundCube webmail package which can be downloaded at http://www.ispconfig.org/

I guess, it will be available soon in the How to section of HowtoForge.

[falko]

I've just published it here: http://www.howtoforge.com/roundcube_webmail_ispconfig

(Sorry, it took a little bit longer this time...)

[Hans]

Falko, i can imagine that you are always very busy... You're incredibly fast again! Thanks :)

[paulrobert_a]

Hey Folks,

It's been a while since I've updated this so here goes again, SVN rev 361.

For those you wish to maintain their current database, please back it up, replace the one from the package and manually update the sqlite database yourself.

Please don't contact me for support, I only created the package. For all support queries, please direct them to the roundcube forums (http://www.roundcubeforum.net/).

Thanks!

The Download (http://www.archtree.net/RoundCube0.1-beta2-361.pkg)

[till]

Thanks for the update :)

[3cwired_com]

Hi all,

Today i've posted a "how to" to setup RoundCube webmail in the webspace of your choice running on port 80. This is an alternative for the RoundCube webmail package which can be downloaded at http://www.ispconfig.org/

I guess, it will be available soon in the How to section of HowtoForge.

Hi, I host several websites, and I'd like to have all of the domains login via

http://webmail.domain1.com
http://webmail.domain2.com
http://webmail.domain3.com

etc, can I just install it once, and make it work, or does this installer only work for one domain name. I don't want to have to configure each domain names email one by one, if I don't have to, and I don't want to use the default port 81, is there another way around this, that eliminates port 81 altogether.

[falko]

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=7309&highlight=webmail+port

[3cwired_com]

Thanks I got it setup now, just had a few issues, but I think I resolved em all.

[cousin]

hey guys,
i have been workin my way through ISPConfig and roundcube for quite a while, well every thing is ok except the problem of the identities.

You c, if i have a domain (e.g. host.domain.tld), and my email is user@domain.tld
roundcube would read it as user@host.domain.tld.

i think i passed a solution for this by Alex, but the problem is; that solution is only convenient for www hosts, so for other subdomains this wont work, and also its inconvenent to manually add the hosts eash time i create a new one.

i've read your posts and many blame roundcube for that, but i actually think its ISPConfig, as it adds host.domain.tld to /etc/postfix/virtusertable, and then roundcube would fetch the email from the file; acctually it fetches the first one that matches the username.

you can check it your self, i couldnt make a patch since i havent any experience with ISPConfig source files and i have no time to check the source; so please if anyone could track this down, i will be very thankful for him :D

thnx guyz

[till]

There is no bug at all, just a incompatibility between roundcube and ISPConfig. The virtusertable file written by ISPConfig is correct, as it uses the main domain incl. hostname of the website as first email domain.

[Hans]

I have to say that i do not have any problems with Roundcube beta2, which is set up according my howto at http://www.howtoforge.com/roundcube_webmail_ispconfig.

[LukaszP]

If I install Roundcube from package, what database is use?

[falko]

ISPConfig's database.

[LukaszP]

I think so, but I can't find it... what names have table?

[falko]

You can find the name of the database in /home/admispconfig/ispconfig/lib/config.inc.php.

[danbogos]

Hey Folks,

It's been a while since I've updated this so here goes again, SVN rev 361.
The Download (http://www.archtree.net/RoundCube0.1-beta2-361.pkg)

Hi Guys,

I have installed the latest package (link provided above), but I cannot use it. Login and incoming e-mail works fine, but the outgoing mails are not sent out. The reason: the sender will be empty, it looks like roundcube cannot fetch the contact details from the database.

From roundube logs:
"[08-Jan-2007 09:37:03 +0100] DB Error: DB Error: unknown error Query: 1 ** SELECT identity_id, name, email, signature, html_signature FROM identities WHERE user_id='2' AND del<>1 ORDER BY "standard" DESC, name ASC [nativecode=sqlite_query() [<a href='function.sqlite-query'>function.sqlite-query</a>]: no such column: html_signature] in /home/admispconfig/ispconfig/web/roundcubemail/program/include/rcube_db.inc on line 501"

My question: do I need to do any extra settings to the one made automatically by inserting the package into ispconfig? As far as I saw, roundcube is using by default sqllite database, do I still need to create something in mysql?

Thxs in advance for your time!

Cheers,
Dan

[falko]

From roundube logs:
"[08-Jan-2007 09:37:03 +0100] DB Error: DB Error: unknown error Query: 1 ** SELECT identity_id, name, email, signature, html_signature FROM identities WHERE user_id='2' AND del<>1 ORDER BY "standard" DESC, name ASC [nativecode=sqlite_query() [<a href='function.sqlite-query'>function.sqlite-query</a>]: no such column: html_signature] in /home/admispconfig/ispconfig/web/roundcubemail/program/include/rcube_db.inc on line 501"

I've never used RoundCube, so I don't know how it works, but it seems that the html_signature column is missing in one of the database tables.

[danbogos]

I've never used RoundCube, so I don't know how it works, but it seems that the html_signature column is missing in one of the database tables.

Thxs Falko for your fast reply. Got it now, it looks like there is necessary to alter the table identities as update process (http://trac.roundcube.net/trac.cgi/wiki/FAQ).

Maybe paulrobert_a will do this in the package so the other users should not experience the same fault I had. By the way there is a new release already available on RoundCube site.


Cheers,
Dan Bogos

[DaRKNeSS666NL]

Maybe paulrobert_a will do this in the package so the other users should not experience the same fault I had. By the way there is a new release already available on RoundCube site.



I was wondering if it's possible to name the package acording to the version, so we know what version we install or have installed.

DaRKNeSS

[paulrobert_a]

Hey Folks,

Another update, RoundCube SVN rev 461.

Database alterations require database to be replaced, unless you do the changes manually.
*RoundCube FAQ (http://trac.roundcube.net/trac.cgi/wiki/FAQ)* Thanks danbogos

Please don't contact me for support, I only created the package. For all support queries, please direct them to the roundcube forums (http://www.roundcubeforum.net/).

Thanks!

The Download (http://www.archtree.net/RoundCube0.1-beta2-461.pkg)

[paulrobert_a]

I was wondering if it's possible to name the package acording to the version, so we know what version we install or have installed.

DaRKNeSS

Hey DaRKNeSS,

I'm not entirely sure what exactly you mean, as all the rc packages have names with the SVN rev number attached.

e.g.
RoundCube0.1-beta2-461.pkg
RoundCube0.1-beta2-361.pkg

[DaRKNeSS666NL]

Hee I am seeing that now, strange I know fur sure I heve downloaded twice an roundcube.pkg pakage. Mabey I did something wrong.:confused:

DaRKNeSS

[paulrobert_a]

Hee I am seeing that now, strange I know fur sure I heve downloaded twice an roundcube.pkg pakage. Mabey I did something wrong.:confused:

DaRKNeSS

Hey DaRKNeSS,

I know the ISPConfig website has it as 'RoundCube.pkg' and I have it as this for beta 1 on page 2 of this thread, along with a mirror... mibbie it was that, that caused the confusion?

All well, I was curious to see what the name scheme was going to be :(

;)

[s2angel]

I have not seen anyone resolve or know if this is resolved..

I also am running debian with todays verion(whatever it is ) of roundcube pkg from ispconfig website and am unable to recieve any emails now!

Installed through the Tool in Ispconfig, but can't receive? I can send!

Any help?


Seems alike all my accounts are not recieving any emails

weird everything was working then I go and add roundcube and its like they don't even make it to the server.. can someone help me?!

The logs don't seem to show much..
In the mean time I am going to go look around if I can and try to see what roundcube changed.. .. can roundcube actualy stop emails from coming in?

Note I made a change to make my users logins be domain.com_username

Not sure if this effects things

[DaRKNeSS666NL]

sounds like your port 25 is blocked by your isp.

[s2angel]

sounds like your port 25 is blocked by your isp.


I wish it was something that simple..

but that was not it..

Turns out I selected maildir

What is maildir exactly..??

and how do I get the mail put back into the mail where it normaly was /var/mail in single files??

aargh! Though its nobodies falut but ine.. always read ahead.. and read about what you don't understand!

for 9am till now I had mail going there cause I selected maildir so I could access the webmail..

I would still like to know how I can run both at the same time!..


As I analized the logs mail was being deliverd fine.. so it made no sence (it was just saving it someplace else!)

But as soon as it stopped coming in I went through the painfull process of elimination everything I had done
eventualy unclicking the maildir check I placed earlier this morning! and testing a email account!)

Maybe someone can explain maildir or point to a link or possibly explain how I can have pop accounts and webmail
I look forward to the responce time will tell .. in the mean time I will start searching the fourms and the google for maildir info

I still can't get outlook users to get email yet wither.. just thunderbird with tls enabled

Joe

[3cwired_com]

I believe maildir, is used when you are using the other webmail clients, and it facilitates the process, by putting peoples mails in separate folders. You might have to go to advanced in outlook and select authentication. I did notice that check box when I was poking around. I did however manage to set up my outlook and its working well so far.

[schmidtedv]

...if anyone would like to use the mailfunctioning Spellcheck...there are missing files in all roundcube versions...here are mine, for the actual 0.1beta2.2 release, this includes the changes for compose.inc to include the files into the compose-window! Just replase, if you are using this version, otherwise you have to do the changes manually :-)

After that spellcheck is working!!

[letic]

Hey Paul !

Could you please repost the last Roundcube package ? The link to you website is down http://www.archtree.net/RoundCube0.1-beta2-461.pkg after some Googling I saw that you moved you page to http://www.archtree.co.uk but http://www.archtree.co.uk/RoundCube0.1-beta2-461.pkg link to nowhere.

Could you please repost it ? I always use the update function of ISPConfig so I have no backup of it (yes it is a bad idea ;) )

Thanks in advance
Cheers
LeTic

[damir]

Does anyone have latest .pkg of roundcube, besides the one on ispconfig.com?

Kind regards

[paulrobert_a]

Yeah sorry for the delay, here is the new home for the Roundcube package.

http://area51.archtechnologies.net/RoundCube0.1-beta2-461.pkg

Paul-Robert

Hey Paul !

Could you please repost the last Roundcube package ? The link to you website is down http://www.archtree.net/RoundCube0.1-beta2-461.pkg after some Googling I saw that you moved you page to http://www.archtree.co.uk but http://www.archtree.co.uk/RoundCube0.1-beta2-461.pkg link to nowhere.

Could you please repost it ? I always use the update function of ISPConfig so I have no backup of it (yes it is a bad idea ;) )

Thanks in advance
Cheers
LeTic

[radim_h]

Hello!

i'd like to run Roudcube outside ISPconfig (on site under regular Apache instance, configured in /etc/httpd/https.conf, not just https://admin.mysite.tld/roundcube )
because i'd like to use rewrites as descibed in http://www.howtoforge.com/forums/showthread.php?t=4964 (originally for Squirrell)
so all customers can use it as http://mail.anyuserdomain.tld
------------
<VirtualHost 192.168.1.1:80>
ServerName mail.*:80
ServerAdmin webmaster@domain.com
DocumentRoot /var/www/webmail
RewriteEngine On
RewriteCond %{HTTP_HOST} ^webmail..+..+$ [NC]
RewriteCond %{HTTP_HOST} !^mail.domain.com$
RewriteRule ^(.*)$ https://webmail.domain.com$1 [R=301]
</VirtualHost>
---------------------

i just copied directory /home/admispconfig/ispconfig/web/roundcubemail to /var/www/webmail , changed permissions for apache (also tried chmod 777 to be sure there is no problem with permissions)

but i'm still getting message:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

http error log record is : [Tue Apr 10 22:46:51 2007] [error] an unknown filter was not added: PHP
But php is working on the site


I'm i missing something important??

Thanks for any pointer

Radim

[Hans]

This howto might help you:
http://www.howtoforge.com/roundcube_webmail_ispconfig

Just install it within your /webfolder if you do not want a sepearate site like http://roundcube.yourdomain.com/ :)

[radim_h]

thanks for links.
I'm just still not getting why configuration copied from .pkg for ISPconfig doesn't work under different apache virtual host name.
I did same thing with squirrelmail and it worked...

[Hans]

I did not create the .pkg, so i can not give you the right answer.
You have an alternative now to get it working.

[radim_h]

everything works now, thanks!

just missing one thing, is it possible to create imap subfolders in Roundcube?

[aqua]

Hello:

I want to update roundcube to the latest pkg package. Many people complained that the sender field was empty, and many pointed to the roundcube's FAQ, which states that this table must be altered

ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';


Falko pointed out that Roundcube uses ispconfig's db, which is the default one for me, db_ispconfig.

I looked inside db_ispconfig, but i cannot find a table called identities.

I also looked at the current installation of roundcube, in:

/home/admispconfig/ispconfig/web/roundcubemail/config/db.inc.php

and found the lines:

$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';

which means roundcube is using the sqlite database. I am confused now. Which database should I update? and what does this db store anyway?

Thanks,
aqua

[ADM]

I have a working ISPConfig install and installed roundcube from http://area51.archtechnologies.net/RoundCube0.1-beta2-461.pkg

I'm unable to login, this is mail.log line:
imapd: chdir Maildir: No such file or directory

I login with webNN_name and password
I view a file inside /var/mail that is webNN_name

Any hint?


EDIT:
My fault, it was not enabled Maildir in Management -> Server -> Settings -> Email

[radim_h]

Not Existing Maildir format (mast be enabled in postfix or your mailserver) ?
Have you sent some mail into your mailbox? I'm not sure, but maybe mailbox si created with first incomming message.. Welcome message for new user can be set in ISPConfig

[radim_h]

Hello:

I want to update roundcube to the latest pkg package. Many people complained that the sender field was empty, and many pointed to the roundcube's FAQ, which states that this table must be altered

ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';


Falko pointed out that Roundcube uses ispconfig's db, which is the default one for me, db_ispconfig.

I looked inside db_ispconfig, but i cannot find a table called identities.

I also looked at the current installation of roundcube, in:

/home/admispconfig/ispconfig/web/roundcubemail/config/db.inc.php

and found the lines:

$rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646';
// postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail';
// sqlite example: 'sqlite://./sqlite.db?mode=0646';

which means roundcube is using the sqlite database. I am confused now. Which database should I update? and what does this db store anyway?

Thanks,
aqua


Thank you,
ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';
did help me with My Roundube, but it is for Roundcube working with Mysql.
The installation is very easy, just read README.

[radim_h]

Well readme doesn't work for everything :)

I changed users logging to dovecot and postfix as decribed here:
http://www.howtoforge.com/forums/showthread.php?t=12308,
So users can set login in email clients in formatr user@domain.tld, which is great
But now i can't log into Roudcube, it stil translating user@domain.tld to domain.tld_user format, so it cant log into imap server
(imap-login: Disconnected: user=<_mydomain.cz_test>)

When i change main.inc.php line
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';
to
$rcmail_config['virtuser_file'] = ' '; or uncomment this line

it is still sending to dovect login "domain.tld_user" so no one can log into webmail

what should i change in config to make roudcube use email adresses for login to dovecot and translate it from /etc/postfix/virtusertable ???

[radim_h]

all what was needed is

change
// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';

to
// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '';

[Hans]

On 18-5-2007 RoundCube RC1 is available.

For more info have a look here:
http://www.roundcube.net/

[samuch]

Anyone created a package for or successfully installed RC1 for ISPConfig? I'd be interested in upgrading to fix some of the bugs and wondered how smooth it was installing.

Thanks!

[razor7]

Hello..have installed Rouncube addon downloaded from ISPConfig website but can not access...

User web1_martin
MAil martin@mgsconectiva.....


Please advise...

[Hans]

Please check if you have enabled the Maildir format.
You can check this within ISPConfig under Management > Server > Settings > Email.

Remember that the mailbox will be created when the first mail arrives.

[Martin1982]

Everytime I'm in Roundcube mail and click to open an email it returns to the login screen saying that my session has expired. Although I've only been busy for about 20 seconds after logging in (and I guess the auto-refresh on the inbox should also keep the session alive).
I use the latest pkg from this thread.

[Hans]

I have found out that the current RoundCube package provided by ISPConfig has been built on 13-4-2006 and and was based on RoundCube version 1.0 beta1.

Due some problems, which still occur with this version, i decided to create a new RoundCube package for ISPConfig today, which is based on the latest and most stable version, which is RC1.1.

I did some modifications, which means that:

- you are able to use webmail across different servers by using the loginname/password & servername.
- login with the loginname/password & e-mailaddress/password on the localhost / local server only
- within the identities screen, the @www.domain.tld has been changed automaticly into @domain.tld after a first login on.

If you want to login with the loginname/password only, within the file main.inc.php, you can change the line:

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';

into:

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '';

I mention this because a login with the e-mailaddress/loginname is not possible across other servers then your localhost.

Today i will send the package to Till and i hope that he can publish it on http://www.ispconfig.org.

It would be nice if the RoundCube version is mentioned as well. (RC1.1.).

This package can be installed with the update manager within ISPConfig.

After installing the package, the RoundCube URL can be found here:
http://anydomainonyourserver.tld:81/roundcubemail/

[till]

Thanks, I will publish the package today on ISPConfig.org and mention the version number too.

[letic]

Sorry to contradict you guys but I think people might be confused by your version number. The latest roundcube version is v0.1-rc1.

I guess that's the one you were speaking about Hans.

Anyway I'm off installing this new version and will give you feedback if I have any issues.

Thanks a lot for that :)
LeTic

[Hans]

The correct RoundCube version must be: 0.1-rc1.1

Sorry for the mistake.

[mtuser]

I just installed roundcube new package.

sender disappears in roundcube. nothing can be sent.

error shows from webdeveloper extension

Error: uncaught exception: [Exception... "Index or size is negative or greater than the allowed amount" code: "1" nsresult: "0x80530001 (NS_ERROR_DOM_INDEX_SIZE_ERR)" location: "https://www.mtuser.com:81/roundcubemail/program/js/app.js Line: 1750"]

log in with: webxx_xx
password:
server: localhost

I installed pkg but not remove old roundcube pkg. Is this problem?
So how can I fix it?

[Hans]

I use RoundCube, with MySQL for quiet some time now without any problems.
It do not use the package version for ISPConfig, because, i installed it manually according my howto here: http://www.howtoforge.com/roundcube_webmail_ispconfig

The packet version does not make use of MySQL but SQLite and i found out, that RoundCube with SQLite behaves different then the MySQL version.
It looks more unstable.

Within the RoundCube documentation is mentioned that replacing with the new version is recommended, so i do advise to remove the old RoundCube version first.

I think the can't send problem has to do something with the database and the update proccess.
Please also have a look here: http://roundcubeforum.net/forum/index.php?topic=1817.msg7245
(It describes exactly what happens).

See also this ticket:
http://trac.roundcube.net/trac.cgi/ticket/1484430
Which tells that you can try to dump the SQLite database and do a fresh reinstall again.
Hope that works!

I made the new package, because of my good experience with RoundCube and because of some bugs in the older package.

It's not my intention to cause problems but to make the package better.
If you want to reinstall the older package again (based on the beta version), you can download it here:
http://www.ispconfig.bb-hosting.org/downloads/roundcubemail.pkg

[Hans]

Today i have posted a new package to Till by e-mail.

I did a modification for the sqlite database.
Everything works for me with this version! :)
I hope it will available soon on www.ispconfig.org so you can use it as well.

[payne]

Everytime I'm in Roundcube mail and click to open an email it returns to the login screen saying that my session has expired. Although I've only been busy for about 20 seconds after logging in (and I guess the auto-refresh on the inbox should also keep the session alive).
I use the latest pkg from this thread.

Same problem :confused: Also i noticed that this problem is only with opera ant IE,with firefox it's fine.

[till]

I just uploaded the latest package from Hans to ispconfig.org.

[Hans]

To be sure, today i did some tests again with the new RoundCube package based on 0.1-rc1.1
Everything looks fine for me on Debian Etch with ISPConfig 2.2.14.
I am happy about this and i hope other users can confirm their good experience as well.

It must be said that the right initialisation of the correct database is very important, otherwise problems do occur.

For information only:
For sqlite, RoundCube comes with two files to create the database called sqlite.db.
The location of this database is within /home/admispconfig/ispconfig/web/roundcubemail/

The names of the files, which where necessary to create sqlite.db are:
1) sqlite.initial.sql
2) sqlite.update.sql

When i created the sqlite.db database for the RoundCube package, i used the first file sqlite.initial.sql, which is ment for a fresh new install. The other one (sqlite.update.sql) is ment for an update from an earlier version of RoundCube, but i decided not to use that one anymore. (When used the sqlite.db, created with sqlite.update.sql for a fresh new installation, RoundCube did not work as it should.)

I realise that quiet a lot users, have installed the previous RoundCube package already and because i used sqlite.initial.sql, i think this are the best update instructions:

Update instruction:

Login to your server as root and perform the folowing commands:

rm -rf /home/admispconfig/ispconfig/web/roundcube*
rm -rf /home/admispconfig/ispconfig/web/tools/tools/roundcube
rm -rf /home/admispconfig/ispconfig/temp/roundcubemail

After that login to ISPConfig.
Goto ISP Manager > Update > URL: http://www.ispconfig.org/downloads/roundcubemail.pkg

Login into RoundCube:
Go to Tools and choose RoundCube within the structuretree within ISPConfig.

Alternative:
Login at URL: http://www.anydomainatyourserver.tld:81/roundcubemail

Happy RoundCube! :)

[letic]

Thanks a lot Hans for your post.

I upgraded my roundcube install today and told you I will keep you update of my testing.

I followed your advices and removed my previous install before installing your package. The install went smoothly (I'm using the sqllite version)

But I ran into some issues :
1. I always have this error in the logs :
[02-Jul-2007 12:17:49] PHP Warning: mb_convert_encoding() [<a href='function.mb-convert-encoding'>function.mb-convert-encoding</a>]: Illegal character encoding specified in /home/admispconfig/ispconfig/web/roundcubemail/program/include/main.inc on line 924

This is merely a warning and have no consequence on roundcube functionnality (or I couldn't find any)

2. With Iceweasel I keep returning to the login page randomly (when clicking on a message, going back to the inbox, or sometimes when doing no action at all). This is really weird and thought that it was related to this post : http://lists.roundcube.net/mail-archive/roundcube.dev/2007/06/54/ but this didn't seems to solve my issue. I have no problem with epiphany though...

I will let you know if I find any other issues but so far beside the very annoying session bug the package is working fine :)

Cheers
LeTic

[Hans]

@Letic

About to the login page again:
Because of the update, my favorite Opera browser had problems too.
After removing the "visited sites" under history within the browser, everything worked as it should.
I do not know about Firefox-like browsers, probably it helps you too to remove your old visits related to your RoundCube site.

About your error:
If MYSQL (utf-tables) by default using non-utf encoding to communicate with php (default-character- set is not utf-8), then roundcube is not working correctly.
I do not know this for SQLite. Do you use a non-utf characterset?

One more question:
Are you sure that you also did a fresh install with my latest package?
(I want to ask you this, because saturday 30-6-2007, i updated the package again).

[Ben]

did anyboday solve the problems of having "wrong identities" in rc, e.g.
w1_username@www.domain.com instead of myrealemailname@domain.com
even if logging in with myrealemailname@domain.com as user and having virtualusertable configured?
The problem is even if I add a new identitiy and set it as default, after a logout + login it completely disappeared... even deleting the "wrong" one does not help, cause it obviously gets recreated after relogin...
Seems to also be over all version, cause neither the stable nor the last from svn did help...

[Hans]

@Ben,

With this RoundCube package it is possible to login with the users' loginname+password across different servers.
It is also possible to login with the users'emailaddress@domain.tld+password on the localhost.

When you login for the 1st time (on localhost), with the emaladdress@domain.tld, the www (after @) will be removed for a correct notation.
When you login (on a different server, e.q. server1.domain.tld), with loginname+password, the result within the RoundCube identity-screen is: username@server1.domain.tld.

The only modifications i made to the original RoundCube files are also mentioned within my RoundCube howto here: http://www.howtoforge.com/roundcube_webmail_ispconfig

[Ben]

Ah great... and then the identity thing is working... nice work, thx ;)

[letic]

@Hans

Thanks again for your answer :)


About to the login page again:
Because of the update, my favorite Opera browser had problems too.
After removing the "visited sites" under history within the browser, everything worked as it should.
I do not know about Firefox-like browsers, probably it helps you too to remove your old visits related to your RoundCube site.

I can reproduce the issue on all Gecko based browser (even in Epiphany now) before and after removing the cache history. It's even doing it on a test pc on the first ever connection. Maybe a gecko related issue.


About your error:
If MYSQL (utf-tables) by default using non-utf encoding to communicate with php (default-character- set is not utf-8), then roundcube is not working correctly.
I do not know this for SQLite. Do you use a non-utf characterset?

Yes the locales are utf-8 on the server, don't know how sqlite is handling them though. Will need to check it out.


One more question:
Are you sure that you also did a fresh install with my latest package?
(I want to ask you this, because saturday 30-6-2007, i updated the package again).

Yes I installed it on the 2nd and according to Till post the package on the website was updated on the 30th

LeTic

[Hans]

@Letic,

What happens if you reboot your test-server and remove your browser history? Is it solved then? I will install Firefox too, to check what happens. Do you see any related issues within the RoundCube logs directory?

***EDIT***
In the mean time i've installed Firefox 2 as well and i must say that everything works as it should!

[Hans]

Yesterday, RoundCube 0.1-rc1 pure GPL has been released. :)
For more information: http://www.roundcube.net/

[letic]

@Hans

Thanks for the tip I couldn't restart the server but I restarted ISPConfig and since everything seems to be fine. Seems to be some cache issue I guess...

Anyway I wanted to test it a bit further before reporting back to you.

Everything seems to be working fine now.

Thanks a lot for your contribution ! :)

LeTic

[Hans]

Thanks for the report!

I received some questions how to change the server field at the login screen.
I gave my answer here: http://www.howtoforge.com/forums/showthread.php?t=13844

[Davide]

Following Han's instructions, I've succesfully updated roundcube package (MySQL version), and almost all is working OK.

The only problem I see is that if you login with e-mail+password, settings are not saved, and a new user and a new identity is created with each login. This make db grow with no control.
If you log in with loginname+password, everything is OK.

Is that a know problem or am I making something wrong?

Thank you!

[radim_h]

Following Han's instructions, I've succesfully updated roundcube package (MySQL version), and almost all is working OK.

The only problem I see is that if you login with e-mail+password, settings are not saved, and a new user and a new identity is created with each login. This make db grow with no control.
If you log in with loginname+password, everything is OK.

Is that a know problem or am I making something wrong?

Thank you!

I had the problem with identities no saved at March when installed Roundcube.
(but there wasn't problem with new identities creating at each login and it did not matter which way did you log into Roundcube)
There is probably problem in MySQL structure which still wasn't fixed.

This one helped me:

ALTER TABLE identities ADD `html_signature` tinyint( 1 ) NOT NULL default '0';

(log in to your phpMyAdmin, select your roundcube database, backup it first when something goes wrong and run the above query in SQL window)

[Ben]

@radim_h: reagrding the problem of saving the identities, this problem was fixed for me since chaning things mentioned here: http://www.howtoforge.com/roundcube_webmail_ispconfig
This worked for all Versions from SVN since 03.07. without changing / updateing the DB structure.

[Hans]

The next RoundCube version 0.1-rc2 will be released within ± 3 weeks.
Have a look here: http://trac.roundcube.net/trac.cgi/roadmap

When this version has been released, i will take care for a new package for ISPConfig again. :)
I will also adapt my howto here: http://www.howtoforge.com/roundcube_webmail_ispconfig to the new version.

Other projectnews (14-9-2007):
http://www.roundcube.net/

[gjcomputer]

Milestone: 0.1-rc2

Due in 14 hours (10/01/07)

[Hans]

RoundCube 0.1-RC2 has been released today.
I am busy with the new package for ISPConfig already. :)

***EDIT***
Have a look here: http://www.howtoforge.com/forums/showthread.php?t=16375&highlight=roundcube