RoundCube

[DirectAdmin Support]

Hello,

For anyone interested, Martynas Bendorius has created us a roundcube install script. It's very quick and painless. It's being released as beta, so if there are any issues, please direct them to this thread and not our support email address.

To install it:cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.shOnce installed, you'll need to restart apache for the /roundcube alias to function. Note that roundcube uses mysql for it's data, so a da_roundcube database is created.

John

[WilcoOnline]

HI,

Hello,

For anyone interested, Martynas Bendorius has created us a roundcube install script. It's very quick and painless. It's being released as beta, so if there are any issues, please direct them to this thread and not our support email address.

To install it:cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.shOnce installed, you'll need to restart apache for the /roundcube alias to function. Note that roundcube uses mysql for it's data, so a da_roundcube database is created.

John

Very nice only got a error

[root@web02 ~]# cd /usr/local/directadmin/scripts
[root@web02 scripts]# wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
--00:38:12-- http://files.directadmin.com/services/all/roundcube.sh
=> `roundcube.sh'
Resolving files.directadmin.com... 199.237.54.170
Connecting to files.directadmin.com|199.237.54.170|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4,617 (4.5K) [application/x-sh]

100%[=================================================================================>] 4,617 --.--K/s

00:38:13 (34.19 KB/s) - `roundcube.sh' saved [4617/4617]

[root@web02 scripts]# chmod 755 roundcube.sh
[root@web02 scripts]# ./roundcube.sh
: bad interpreter: No such file or directory

and now?

[DirectAdmin Support]

I think he saved the file in windows format.. it has to be resaved in linux.. I'll try and mash it back into shape.
Ok, give it another try.

John

[Marshall]

Couple notes for freebsd 6.2, on lines 88, 89, 98 and 99 where it says /bin/mv --force [files] you need to change it to /bin/mv -f [files] or it will error saying mv: illegal option -- - Also mine had the weirdest thing, it had no da_admin or root password set for mysql so if you get permission errors about mysql, try running /usr/local/bin/mysqladmin -u root password 'new password' then /usr/local/directadmin/scripts/mysql.sh 'root mysql password' da_admin 'da_admin password you want' After that I ran the roundcube.sh script and it worked beautifully.

[gate2vn]

On CentOS 4.4, the script is working fine :)

[DirectAdmin Support]

updated the mv --force to mv -f.

Thanks,
John

[cyberneticos]

Instalation in Debian 3.1 went without errors, but keep getting "Login Failed" when trying to use it.

Any ideas ?

[smtalk]

I guess that the error is: IMAP Error: Could not connect to localhost at port 143 :)

If you want to see errors - edit /var/www/html/roundcube/config/main.inc.php and set debug level to 4.

[cyberneticos]

Thanks for that tip,

Now in debug mode 4 :

IMAP Error: Authentication for anthony@dominio-pruebass.com failed (LOGIN): "a001 NO LOGIN failed"

Any ideas?

Thanks

[smtalk]

toniramos, have you tried http://help.directadmin.com/item.php?id=18 ?

[cyberneticos]

I see that my problem is not related to your install script. Sorry about this folks. Wasn't my intention.

[SeLLeRoNe]

hi, just a stupid question from a noob :D what is roundcube?

Thanks

[smtalk]

RoundCube webmail is a web-based mail client like squirrelmail or uebimiau is. More info about RoundCube webmail: http://www.roundcube.net

[Maniak]

I was sure roundcube will meet the success. I'm happy that DA staff start to support roundcube, one of the largest french ISP also started to beta-test it for the whole portfolio of customers -> http://imp.free.fr/rc/

Thanks Martynas.

[quackweb]

Glad to see this script as many of our dedicated server clients have been demanding RoundCube and sometimes have difficulty doing it the long way. This will certainly help them install it more easily and help us with less support requests concerning RoundCube installation. It's scripts like these that make DirectAdmin and its community #1 in our book!

[jlasman]

Is RoundCube pure imap? Will it work interchangeably with IMAP mailboxes created with SquirrelMail?

Jeff

[DirectAdmin Support]

Yes, it's imap.. it should work with existing folders just like squirrelmail. You may need to tell RC to subscribe to the SM folders though.

John

[QuantumNet]

Anyone that has any respect for their customers will wait until this comes out of beta.... a quick browse of the roundcube forums will show you and abundance of problems from bugs to security holes. I have been following the roundcube project for a little over a year now. It is a very slow moving project and I dont expect it to be out of beta for another year or so.

[smtalk]

QuantumNet, RC1 should be released soon (in March or April).

[pucky]

How do users access RC from their control panels? I dont see a menu option being added for all the themes only an alias outside of the control panel.

[sullise]

Why not just use the ELS script to install it..I used that..worked fine.

[rldev]

It work like a charm for me. I have previously installed this. Will the install parameters be the same once integrated in DA? I am wondering if I should migrate the existing few users to the DA install version.

[kke]

After trying Roundcube..
Good & Nice features

But the email not showing Thai message (tis-620 encoding) correctly.

Uebimiau can showing 100% of email message in thai correctly (After modified 2 lines of code)
Only subject in UTF-8 that show as #9999#8888 but not big issue.

[dannygoh]

After trying Roundcube..
Good & Nice features

But the email not showing Thai message (tis-620 encoding) correctly.

Uebimiau can showing 100% of email message in thai correctly (After modified 2 lines of code)
Only subject in UTF-8 that show as #9999#8888 but not big issue.
You need to download additional language pack from roundcube website. I dont know is Thai is supported.

[JDiel]

This script works great running Debian 3.1

[freshmint]

How do users access RC from their control panels? I dont see a menu option being added for all the themes only an alias outside of the control panel.

This may help you.

http://www.directadmin.com/features.php?id=735

[Nobim.net]

After installation and a reboot of apache I got the folowing error:

SoftException in Application.cpp:297: GID of script "/var/www/html/roundcube//index.php" is smaller than min_gid
*** glibc detected *** double free or corruption (fasttop): 0x093979f0 ***
[Mon Mar 5 13:54:20 2007] [error] [client 62.177.220.226] Premature end of script headers: /var/www/html/roundcube//index.php
[Mon Mar 5 13:54:20 2007] [error] [client 62.177.220.226] File does not exist: /home/oele/domains/oele.org/public_html/500.shtml


For me the solution is to changen the owning user from root:root to apache:apache

Has anyone else had this problem?

[canreo]

gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
Directory /var/www/html/roundcubemail-0.1beta2 does not exist
I tried deleting the file and retrying the steps, but I still get the same error. Any ideas?

[smtalk]

Probably the server couldn't download all the roundcube file.

[smtalk]

Why not just use the ELS script to install it..I used that..worked fine.

ELS is using the same script.

[smtalk]

After installation and a reboot of apache I got the folowing error:

SoftException in Application.cpp:297: GID of script "/var/www/html/roundcube//index.php" is smaller than min_gid
*** glibc detected *** double free or corruption (fasttop): 0x093979f0 ***
[Mon Mar 5 13:54:20 2007] [error] [client 62.177.220.226] Premature end of script headers: /var/www/html/roundcube//index.php
[Mon Mar 5 13:54:20 2007] [error] [client 62.177.220.226] File does not exist: /home/oele/domains/oele.org/public_html/500.shtml


For me the solution is to changen the owning user from root:root to apache:apache

Has anyone else had this problem?

This is because of PHP as CGI. In this case you should edit its config or create a new user (e.g. roundcube) and chown all the RoundCube files to roundcube:roundcube. Using apache user is very insecure.

[canreo]

gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
Directory /var/www/html/roundcubemail-0.1beta2 does not exist
I tried deleting the file and retrying the steps, but I still get the same error. Any ideas?
Fixed. Had to go into the packages folder and delete "roundcubemail-0.1beta2.tar.gz".

[agnivo007]

works flawlessly on centos 4.4 vps

[aubergedunet]

If I want to delete the rouncube on my vps after I've installed with this scripts, how i do proceed ?

[smtalk]

1. rm -rf /var/www/html/roundcube*
2. Drop da_roundcube database
3. Remove /roundcube alias from /etc/httpd/conf/httpd.conf

[aubergedunet]

Thanks smtalk

[rldev]

What database doe this setup?

IS there a way to get it to subscribe to SM folders or data?

[smtalk]

It setups da_roundcube MySQL database. You can edit your configuration file for folders as INBOX.Drafts etc. (SquirrelMail model).

[djcronos]

- Installed flawlessly on CentOS 4.4 x64 (2 servers)

- Problems on CentOS 4.4 x86 (1 server)

cp: cannot stat `/var/www/html/roundcube/logs/*': No such file or directory
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
da_roundcube exists. Please remove the database if you want to do a fresh reinstall.
Editing roundcube configuration...
Roundcube has been installed successfully
RoundCube alias is already added to /etc/httpd/conf/httpd.conf


When I go to the URL, I get:


SERVICE CURRENTLY NOT AVAILABLE!

Error No. 1f4)


I would log in as root but I don't know root's MySQL password (DA set it up for us) so I can't drop the db and start over.

Any suggestions?

[freshmint]

- Installed flawlessly on CentOS 4.4 x64 (2 servers)

- Problems on CentOS 4.4 x86 (1 server)

cp: cannot stat `/var/www/html/roundcube/logs/*': No such file or directory
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
da_roundcube exists. Please remove the database if you want to do a fresh reinstall.
Editing roundcube configuration...
Roundcube has been installed successfully
RoundCube alias is already added to /etc/httpd/conf/httpd.conf


When I go to the URL, I get:


SERVICE CURRENTLY NOT AVAILABLE!

Error No. 1f4)


I would log in as root but I don't know root's MySQL password (DA set it up for us) so I can't drop the db and start over.

Any suggestions?

Your root's MySQL password is stored at /usr/local/directadmin/conf/mysql.conf

[djcronos]

Thanks. I removed the db, removed the alias (which I know wasn't necessary), and ran the script again - worked like a charm!

I think it was user error - I may have installed the script a while ago and forgot about it. I think rerunning the script again after it was installed might have messed it up.

Good work! I love Roundcube!

[gadgetsguy]

script is installed and running perfectly on 3 boxes, but it does not have a roundcube entry in the email section of the user control panel ... you access it by clicking squirrelmail ... this is somewhat confusing IMHO :confused:

[freshmint]

script is installed and running perfectly on 3 boxes, but it does not have a roundcube entry in the email section of the user control panel ... you access it by clicking squirrelmail ... this is somewhat confusing IMHO :confused:

That's because Roundcube it's not the "official" webmail in DirectAdmin. But check my previous post in this thread:

http://www.directadmin.com/forum/showpost.php?p=95301&postcount=26

[Maniak]

Hello,

I know it's not a technical forum, but since it's official, it can maybe concern more user than just only me.

I am using a special configuration for my Directadmin server. To make it short, I do run PHP4/5 for my customers using suPHP 0.6.2 and Apache 2.

Each user get a 2 php.ini file (one for PHP4, one for PHP5) and when the user upload some file it get's stored in /home/username/tmp (this directory is chmod 777).

My problem is that when a user use the webmail and try to attach a file to a mail (which means it's at uploaded somewhere) it doesn't work because they do access the webmail thru an alias /webmail make an alias to each user to /var/www/html/roundcube and so the upload doesn't work (no error on screen).

I have tried to change the path /temp with a full-path variable in the roundcube configuration, but it doesn't work better.


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

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

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

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

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



Doesn't work at all. But when I do access it thru no alias it works fine, for e.g. I do type the http://IP/roundcube/ it works fine.

I can still make a workaround that does forward the alias to the real url, but maybe I can also find a better way to do it ?

Thank you for any help !

[smtalk]

Maniak, what's the output of: grep roundcube /etc/httpd/conf/httpd.conf Do you have any problems like this with SquirrelMail or UebiMiau?

[gate2vn]

I got errror "Failed to send message" sometimes. No more log in apache log, or roundcube error log. Squirrelmail is just working fine.

the $rcmail_config['smtp_server'] is blank, so it uses php mail() functions. creating a simple page for testing and seeing the php mail() is working fine too. But sending message from roundcube gave me error.

Is there any idea?

[smtalk]

Maybe connection with imap gets broken or it can be because of its content.

[gate2vn]

as said, squirrelmail is working fine. So, I doubt the reason is from mail server. Trying to send by outlook: it's working fine too.

Might be something wrong in Roundcube, but not sure what it's

[smtalk]

Next month I'll include RoundCube RC1 with this script :) We will see if this helps.

[gate2vn]

hmm... something wrong between script and database. After deleting user from table users, logging in again (so the user can be added as a new user into the db), the message can be sent without any trouble

Do you have any idea why? it seems script doesnt want to read old data in Roundcube database anymore

[smtalk]

Script has been updated. 1 bug has been fixed (there are no "doubled" folders anymore) :) For those who want to delete Drafts, Sent and Junk folders (do not remove INBOX.Drafts, INBOX.Sent, INBOX.spam!) just do this and go to preferences in RoundCube webmail (this change will allow you to delete the folders):
# perl -pi -e 's/protect_default_folders'] = FALSE/protect_default_folders'] = TRUE/' /var/www/html/roundcube/config/main.inc.php
And after the changes (when needed folders are deleted):
# perl -pi -e 's/protect_default_folders'] = TRUE/protect_default_folders'] = FALSE/' /var/www/html/roundcube/config/main.inc.php

[rldev]

SM,
How would I update roundcube using this script?

[smtalk]

Just download it and run again :)

[rldev]

Any chance this will be included in the next couple of DA updates. Or are you waiting for the Official release?

[smtalk]

Maybe it will be included, but firstly RoundCube Release Candidate 1 should be released.

[miltongoh]

Hi,

When I enter the domain name hosted on my server with the alias /roundcube.

The error message is.

SERVICE CURRENTLY NOT AVAILABLE!
Error No. 1f4)

Anyone can help?

[smtalk]

miltongog, just run roundcube.sh script again.

[miltongoh]

[root@server scripts]# ./roundcube.sh
cp: `/var/www/html/roundcube/logs/errors' and `/var/www/html/roundcubemail-0.1beta2/logs/errors' are the same file
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
da_roundcube exists. Please remove the database if you want to do a fresh reinstall.
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
Editing roundcube configuration...
Roundcube has been installed successfully
RoundCube alias is already added to /etc/httpd/conf/httpd.conf


I got this after launching ./roundcube.sh. Does this seem correct?

[smtalk]

miltongoh, do this:
rm -rf /var/lib/mysql/da_roundcube
./roundcube.sh

[miltongoh]

I still got this.


[root@server scripts]# rm -rf /var/lib/mysql/da_roundcube
[root@server scripts]# ./roundcube.sh
cp: `/var/www/html/roundcube/logs/errors' and `/var/www/html/roundcubemail-0.1beta2/logs/errors' are the same file
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Inserting data to mysql and creating database/user for roundcube...
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: NO)
./roundcube.sh: line 74: -p1oT3QjNM: command not found
ERROR 1045 (28000): Access denied for user 'da_roundcube'@'localhost' (using password: YES)
Database created, da_roundcube password is 20um2hyj
Editing roundcube configuration...
Roundcube has been installed successfully
RoundCube alias is already added to /etc/httpd/conf/httpd.conf

[smtalk]

Please contact me by PM, I want to take a look at your server.

[miltongoh]

Really thanks smtalk for helping me! :)

[rldev]

Any way to get the "Disk Usage" meter to work in round cube to reflect the user's mailbox usage?

[zheka]

This may help you.

http://www.directadmin.com/features.php?id=735

Hi folks,

I still didn't understand how I could publish a hyperlink to the RoundCube on the user's page in the E-mail management section.
What do I have to add to the directadmin.conf file?

Eugene

[freshmint]

Hi folks,

I still didn't understand how I could publish a hyperlink to the RoundCube on the user's page in the E-mail management section.
What do I have to add to the directadmin.conf file?

Eugene

Add this to your directadmin.conf:

webmail_link=folder_which_has_roundcube

That way the webmail link on the header will point to http://www.yourdomain.com/folder_which_has_roundcube

[zheka]

Hi freshmint!

Thanks for a quick reply. You know, I tried to add it to my directadmin.conf. It didn't work. I mean there are no changes to the user's page. This is how this line looks in there:

webmail_link=/var/www/html/roundcube

roundcube is a symbolic link to roundcubemail-0.1beta2 folder. I guess it doesn't have to create any problem if we use symbolic links in the config file.

What bothers me is that I don't see any lines mapping webmail menu to squirrelmail and eubimiau in directadmin.conf. Does this mean that I have to edit the other file?

Eugene

[freshmint]

Hi freshmint!

Thanks for a quick reply. You know, I tried to add it to my directadmin.conf. It didn't work. I mean there are no changes to the user's page. This is how this line looks in there:

webmail_link=/var/www/html/roundcube

roundcube is a symbolic link to roundcubemail-0.1beta2 folder. I guess it doesn't have to create any problem if we use symbolic links in the config file.

What bothers me is that I don't see any lines mapping webmail menu to squirrelmail and eubimiau in directadmin.conf. Does this mean that I have to edit the other file?

Eugene

You're supposed to configure it with the folder name (or symbolink link, it works too) only, not the full path. For instance, if you have this symbolic link on your /var/www/html folder, you may access roundcube by http://www.yourdomain.com/roundcube (IF you have added this alias to your httpd.conf too, don't forget this!). That means you should add to your directadmin.conf this line:

webmail_link=roundcube

There's no configuration on your directadmin.conf by default, which means DirectAdmin will link to squirrelmail (DirectAdmin's default). You can't configure more than one webmail here, this configuration just change the webmail link on your header. The others webmails will still work if accessed by direct link.

Also, make sure you're using the latest directadmin version, this feature was "recently" added.

[zheka]

Ok, finally I got what you meant.
It works for me but whenever I click on the "Webmail" button at the top menu of the user's page. What I wanted to set is to have it appear as the third option at the Email Management section. Now it looks like this:

E-Mail Accounts
Catch-All E-Mail
Forwarders
Autoresponders
Vacation Messages
Spamassassin Setup

Mailing Lists
SPAM Filters
Webmail: Squirrelmail
Webmail: UebiMiau

I want to add one more line:

Webmail: RoundCube

Eugene

[freshmint]

Ok, finally I got what you meant.
It works for me but whenever I click on the "Webmail" button at the top menu of the user's page. What I wanted to set is to have it appear as the third option at the Email Management section. Now it looks like this:

E-Mail Accounts
Catch-All E-Mail
Forwarders
Autoresponders
Vacation Messages
Spamassassin Setup

Mailing Lists
SPAM Filters
Webmail: Squirrelmail
Webmail: UebiMiau

I want to add one more line:

Webmail: RoundCube

Eugene

That's on the templates. See file /usr/local/directadmin/data/skins/enhanced/user/show_domain.html, look for "squirrelmail" and you'll know what to do. :)

[zheka]

Thanks, freshmint.
Finally it worked. But it took me some time to figure that I don't have to define the variable similar to |LANG_WEBMAIL_SM|. This is the line to add:

<a href="|HTTP|://|HOSTNAME|/roundcube" target="_blank">Webmail: RoundCube</a><br>

Eugene

[jlasman]

Eugene, if you've changed the enhanced DA skin it may be overwritten by DA at any time. The right way to do this is to create your own skin, by copying the DA default skin. Then the skin won't be updated by DA, but you'll be responsible for keeping it updated as required.

Jeff

[h2d]

The next release (0.1-rc1) is scheduled for 18/05/2007

[smtalk]

h2d, yes, I know that ;)

[h2d]

h2d, yes, I know that ;)

It was for the benefit of everyone, not just yourself :)

[layer0]

v0.1-rc1 is released. :)

[smtalk]

Yes, I'm rewriting the script now, and I'm not at home now :) The script will be ready tomorrow or on Monday.

[cyberneticos]

I know this question might be a bit premiscous:

Not that this is RC-1 , will Directadmin look into including this as an optional webmail client?

[blueice]

Yes, I'm rewriting the script now, and I'm not at home now :) The script will be ready tomorrow or on Monday.
Hi, i have already change the script but the rc1 have some problems. At lease one major feature is missing (preview pane). So i recommended to wait some days until this fixed.

[smtalk]

I'm attaching the script for roundcube-rc1, it will be uploaded to DirectAdmin servers soon.

[blueice]

I'm attaching the script for roundcube-rc1, it will be uploaded to DirectAdmin servers soon.
you have test it and include preview panel? Or you use the first buggy version?

[smtalk]

bueice, what buggy version are you talking about?

[blueice]

bueice, what buggy version are you talking about?
one of the major features of this version is the preview pane. But this is missing in the rc1 version. I not know if it is just disabled in the config or something else happen but i hope it is very important feature.

[smtalk]

blueice, you can enable/disable everyhing what you want in the config file. This script isn't buggy at all and installs roundcube as it's written into install file of roundcube.

[Heuveltje]

Smtalk, thanx for the script,

can it also be used for updating or only installing?
just run it? or is there a special handle to do just an update?

i think blueice is talking about some problems as mentioned on the roundcubeforum.net where people have problems after installing a new version.

[smtalk]

Smtalk, thanx for the script,

can it also be used for updating or only installing?
just run it? or is there a special handle to do just an update?


Yes, with this script you can update roundcube webmail too, just run it again. :)

[Heuveltje]

When will the new script be available via directadmin-server?

when i wget it its the same as a while a go: the beta2 version

[DirectAdmin Support]

Hello,

Try now. I was updating it on the wrong server by mistake (we've recently got a new files.directadmin.com box)

John

[smtalk]

one of the major features of this version is the preview pane. But this is missing in the rc1 version. I not know if it is just disabled in the config or something else happen but i hope it is very important feature.

Preview pane and html editor are in CVS for testing the relatively experimental code, they're not included into the stable releases yet.

[Heuveltje]

Hello,

Try now. I was updating it on the wrong server by mistake (we've recently got a new files.directadmin.com box)

John

Update went fine now, thanx John

[Heuveltje]

after all it didn't went fine :(

i updated from beta2 to rc1 but now when im composing email the most above selectbox, containing sender, is empty.

How to solve?
Some DB update? or something else?
I checked the preferences and identity is just sitting there being fine.

Please advice.

[smtalk]

Try this in da_roundcube database:

ALTER TABLE `messages`
DROP `body`,
DROP INDEX `cache_key`,
ADD `structure` TEXT,
ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`);

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

ALTER TABLE `users`
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci,
CHANGE `username` `username` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CHANGE `alias` `alias` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

[Heuveltje]

How to get there?

[jlasman]

Martynas,

Where's the simple how-to for installing it? I want to put it on a new testbed.

Thanks.

Jeff

[smtalk]

jlasman, first page :) http://www.directadmin.com/forum/showpost.php?p=94678&postcount=1

[Heuveltje]

Where can i find the da_roundcube database with phpMyAdmin?
or whats the command line for updating table (via the file of /var/www/html/roundcube/SQL/mysql.update.sql)

Sorry, not an expert...

[smtalk]

Try:

cd /var/www/html/roundcube
mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` da_roundcube < SQL/mysql.initial.sql


And tell me if it works :) If not, try this one:

cd /var/www/html/roundcube
mysql --user=`grep "^user=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --password=`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` da_roundcube < SQL/mysql.update.sql

[Heuveltje]

thanx for yourfast reply.

This command seems to get me into mysql because after the command i recieve a prompt: >
The only way to exit is CTRL+C
But nothing changes

[smtalk]

I've just edited my post. Try now.

[Heuveltje]

Sorry, does not work, i get a prompt after typing the mysql -e etc.etc.
is that correct? How to escape?

[Heuveltje]

Is it an option to delete the database da_roundcube and do a full reinstall?

What do i lose when reinstalling the database? Does the mysql user also have to be removed? (since its made by roundcube.sh) if yes how?

Hope someone can help... Thought it would be an easy upgrade .....

[Heuveltje]

Fixed it, renamed the da_roundcube to da_roundc in the installer script. and ran it again.
If any one could tell me how to delete the databases i can do a "fresh" install

[smtalk]

You don't have to remove roundube user :) You can just delete the database or drop it's tables :)

[uguronur]

Hi,

My roundcube it was works good until this morning.
I try to check my mails..Try to login, gives me login faild..my login name and password is ok, cause i can get over the outlook from my laptop.

But I couldnt find why roundcube doesn't works..

Any one has a any idea for this..

Ugur Onur

My Cofigurations;
Centos 4.4
Php 4.4.6
DirectAdmin 1.29.7

[bashy]

Installed thanks

[onovoa]

..but is not working :confused: When I try to to login with my email account it says that "login failed". What else I need to do?? The account was created before rouncube was installed. Thanks. Octavio

[onovoa]

..but is not working :confused: When I try to to login with my email account it says that "login failed". What else I need to do?? The account was created before rouncube was installed. Thanks. Octavio

UHMM..IMAP error. :o

[22-Jun-2007 10:33:16 -0500] IMAP Error: Could not connect to localhost at port 143: Connection refused in on line 0

Is there any list of "dependencies" for roundcube?? what shoud I have installed before tryuing RC?
Thanks

Octavio

[smtalk]

http://help.directadmin.com/item.php?id=18

[transix]

I have installed roundcube on CentOS 4.x and it works perfect!

But I have a question, I made some folders in UebiMiau, but I don't see that same folders in Roundcube.
How can I get the UebiMiau folders to work in Roundcube?

Thanks in advance.

Mark

[smtalk]

It's not possible, you can just move them, but you can't use them both for UebiMiau and RoundCube. UebiMiau uses POP3 and RoundCube - IMAP, that's the main difference.

[jackc]

what does roundcube use mysql databse for? store emails?

[h2d]

what does roundcube use mysql databse for? store emails?

email contacts
personal settings
session management
and probably some other stuff

your emails will live in your Maildir directory not in the database.

[jackc]

ah, thanks!

[Petertje18]

How can I view on the DA index:

Webmail: Squirrelmail
Webmail: UebiMiau
Webmail: Roundcube

:)

(srry for my bad englisch:( )

[smtalk]

It's not included now, but it should be included into the future releases of DirectAdmin. For now you need to edit DirectAdmin skin files.

[Petertje18]

It's not included now, but it should be included into the future releases of DirectAdmin. For now you need to edit DirectAdmin skin files.
Yes, I know.
In which file can I do that?

[hostserver]

How i redirect the adredd of the old webmail ubimiau to rouncube

The adrees is domain.com/roundcube and i want in domain.com/webmail

and no more webmail ubimiau install in the server

Thanks :D

[smtalk]

cd /var/www/html
rm -rf webmail
ln -s roundcube webmail
chown -h webapps:webapps webmail

[cyberneticos]

Hello smtalk,

I have two problems with roundcube so far:

1st: Some (only a few) emails are not showing when I open them. I can see the text if I look at the source code, but when I open the email, like any user would do, I get no email text content.

2nd: I have been sent a few attachments, one being a .swf file, and I cannot download it. It seems as if it wants to download it in plain text format. I have tried clicking with the right mouse button and downloading it to my desktop and it seems like the file is corrupted. But if I open the same email in Outlook and download it , everything is correct.

¿ any suggestions ?

Thank you :)

[vod]

Hi All,

I just installed roundcube by using the provided roundcube.sh file downloaded from directadmin site. At the end of the installation, the script prompted me this error:

"chown -h webapps:webapps roundcube"
chown: `webapps:webapps': invalid user

Afterwards, i restarted apache, went to mydomain.com/roundcube/, tried to login with an exinsting email account and password (sales@mydomain.com), the screen just refreshed and show me the same login page. The only thing different is the url. once i entered username and password, the screen refreshed and showed me the url as below:
http://mydomain.com/roundcube/?_task=mail

Did a check using phpmyadmin, went into roundcube database, i saw 6 tables. 1 of the table is called USERS. Browsing the USERS table revealed that there are no users in there. The only entry is the email account that i attempted to login earlier on (sales@mydomain.com).

Any idea guys?

Thank you very much

[smtalk]

Hello smtalk,

I have two problems with roundcube so far:

1st: Some (only a few) emails are not showing when I open them. I can see the text if I look at the source code, but when I open the email, like any user would do, I get no email text content.

2nd: I have been sent a few attachments, one being a .swf file, and I cannot download it. It seems as if it wants to download it in plain text format. I have tried clicking with the right mouse button and downloading it to my desktop and it seems like the file is corrupted. But if I open the same email in Outlook and download it , everything is correct.

¿ any suggestions ?

Thank you :)

It could be your browser issue :) You should write to trac.roundcube.net.

[smtalk]

Hi All,

I just installed roundcube by using the provided roundcube.sh file downloaded from directadmin site. At the end of the installation, the script prompted me this error:

"chown -h webapps:webapps roundcube"
chown: `webapps:webapps': invalid user

Afterwards, i restarted apache, went to mydomain.com/roundcube/, tried to login with an exinsting email account and password (sales@mydomain.com), the screen just refreshed and show me the same login page. The only thing different is the url. once i entered username and password, the screen refreshed and showed me the url as below:
http://mydomain.com/roundcube/?_task=mail

Did a check using phpmyadmin, went into roundcube database, i saw 6 tables. 1 of the table is called USERS. Browsing the USERS table revealed that there are no users in there. The only entry is the email account that i attempted to login earlier on (sales@mydomain.com).

Any idea guys?

Thank you very much

Create webapps user and run the script again :)

[vod]

pardon my ignorance but how to create webapps user?

[vod]

I just did a " adduser webapps " and re-run the script roundcube.sh .

The result is the same. the same error persists.

Any help is greatly appreaciated.

Thank you

[Autogespot]

Hey,

Just installed roundcube. All went fine!

2 small problems.

When i go to mail.***.com it will go to mail.**.com/squirrelmail.But i want that it will go to rouncube. Any one know how to fix that?

2nd, when i open squirrelmail i created some folders. When i login in roundcube i can't see them. How can i mount these in roundcube?

Kind Regards

[sdible]

Hey,

Just installed roundcube. All went fine!

2 small problems.

When i go to mail.***.com it will go to mail.**.com/squirrelmail.But i want that it will go to rouncube. Any one know how to fix that?

2nd, when i open squirrelmail i created some folders. When i login in roundcube i can't see them. How can i mount these in roundcube?

Kind Regards

I'm not sure about the first problem, but the second is really easy. In roundcube, go to "Personal Settings" and click on the "Folders" tab. There, you should be able to subscribe to the folders you created.

[Autogespot]

It doesn't seems to work. When i go there i only see the default folders. :eek:

[Duboux]

Yes, it's imap.. it should work with existing folders just like squirrelmail. You may need to tell RC to subscribe to the SM folders though.

John
Is this still needed, and if so, how do we do this ?

[seachen]

Hello,

For anyone interested, Martynas Bendorius has created us a roundcube install script. It's very quick and painless. It's being released as beta, so if there are any issues, please direct them to this thread and not our support email address.

To install it:cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.shOnce installed, you'll need to restart apache for the /roundcube alias to function. Note that roundcube uses mysql for it's data, so a da_roundcube database is created.

John
after installed, and restart apache, what is the next step?
i have try http://www.mydomain.com/rcmail it was nothing.

[Duboux]

it's http://www.mydomain.com/roundcube

[yacenty]

is it possible to exchange current webmail - uebimail with rouncube? if yes, how?

thanks in advance,
br
YacentY

[jw00dy]

Yes, if you look in /var/www/html you will see that webmail is just a folder, you can rename that folder to something else, then simply create a new link to the round cube folder
# ln -s roundcubemail-0.1beat2 webmail
Then anyone that goes to http://www.domain.com/webmail will get roundcube

[yacenty]

there were some info that rc requries imap and uebimail pop3 - so will it work on my server?
sorry but I don't have experience with mail servers
thanks in advance
yacenty

[smtalk]

Both IMAP and POP3 are working on DirectAdmin servers by default.

[yacenty]

is it possible when I exchange webmail that my users will have still access to theirs emails? and other stuff?

[smtalk]

They won't miss their emails :)

[dan]

Ohh I like this :D That's really pretty!
Though, when installing, I got this message:

chown: webapps: Invalid argument

It seems to be working fine for me though. What does this command failing prevent it from doing, or what components won't work right without it (if any)?
Any ideas on a fix? I'd understand if it said something like "invalid user or group", but invalid argument? bit weird!!

[smtalk]

Do you have webapps user and group? :) CustomBuild adds it automatically, but roundcube.sh script does not :) It's not a big problem if you don't use PHP as CGI (by default it's installed as CLI).

[dan]

i don't, no.
i'm actually running custombuild now. i'd contemplated upgrading php to 5 manually, after reading a thread or 2, then read a lot about this custombuild app, which seems to do it all for me. so it's running right now :)
should get apache from 1.3.37 to 2.2 quite nicely. much needed!!

[jlasman]

They won't miss their emails :)
They might under certain conditions:
UebiMiau doesn't use standard IMAP folders, so if users have mail in other folders in UebiMiau besides the INBOX, those emails won't be visible to other webmail programs.

Jeff

[smtalk]

Yes, jlasman, you're right, they won't be visible, but they won't be missed :) (you'll still be able to login via UebiMiau). Thanks for the addition.

[yacenty]

Ok, I have roundcube running - seems to be nicer than uebimail,
I have one very small question - how to get it localized? I have localization pack from roundcube webpage but I don't where to put it in my box, could You help me?

thanks in advance
BR
YacentY

[freshmint]

Ok, I have roundcube running - seems to be nicer than uebimail,
I have one very small question - how to get it localized? I have localization pack from roundcube webpage but I don't where to put it in my box, could You help me?

thanks in advance
BR
YacentY

Look at your config file.

[energetic]

I have installed. Thanks for sharing

[smtalk]

You're welcome :) And that's not "sharing", that's "creating" :)

[Remco00]

From the RoundCube site:

RoundCube is going PHP 5

In order to force hosters to upgrade to PHP 5 we also support the the GoPHP5 initiative. This means that new versions released after February 5, 2008 will drop support for PHP 4.

[jlasman]

And for some stupid reason they believe they need to enforce hosters to upgrade to something? Who gives them that right?

Oh, their own arrogance.

Excuse me.

;)

Jeff

[smtalk]

jlasman, that's not bad, because there is no reason to support PHP4, PHP5 and PHP6. PHP4 is very different from PHP6, and it's very hard to support all of them. phpMyAdmin and many others are going to PHP5 too (http://gophp5.org/) (http://gophp5.org/%29). About us, DirectAdmin users - it depends on you, if you want - we will leave CustomBuild 1.1 with PHP4 support as an old one (but stable) script, it will install the latest versions of phpMyAdmin, RoundCube, SquirrelMail etc. (that supports PHP4). CustomBuild 1.2 will be only compatible with PHP5 and PHP6, and its applications.

[jlasman]

There's obviously no reason for you to support PHP4. Some of my clients depend on it. Unfortunately, I value my clients.

;)

Jeff

[sullise]

And for some stupid reason they believe they need to enforce hosters to upgrade to something? Who gives them that right?

Oh, their own arrogance.

Excuse me.

;)

Jeff

Guess M$ is arrogant for not supporting Windows 3.1 ;)

Simply put...it's their software. Problem with the world is that everyone thinks it revolves around them and if they are not ready to move forward, no one else should or that those who are are obligated to go out of their way to supply support for those who are not or refuse to.

[jlasman]

They can do what they want.

This:
In order to force hosters to upgrade to PHP 5 we also support the the GoPHP5 initiative.
bothered me; I find it arrogant.

Jeff

[nostromo]

Hello,

Thank you for this script.

I have encountered a small problem during initial install I'm hoping I can be helped with:

[root@server scripts]# ./roundcube.sh
cp: cannot stat `/var/www/html/roundcube/logs/*': No such file or directory
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Editing roundcube configuration...
Roundcube has been installed successfully.
[root@server scripts]#

The 2 CP errors I am unsure how to fix? I noticed a similiar error reported earlier in this thread and that an rm command was told be to used, but the error given was abit different to my own.

Any help appreciated.

T.

[h2d]

Given the software has not had an official full release i think they have every right.

[smtalk]

nostromo, everything is okay with these errors :) Script didn't found any temporary files and logs, so - it showed an error.

[smtalk]

Just a note: it is not beta anymore.

[gate2vn]

Not surre why, but I have just upgraded roundcube by using /usr/local/directadmin/scripts/roundcube.sh, then roundcube is not working good anymore. When trying to send out a message, the sender box is totally blank. I have to come back with the old version. Any idea to fix it?

[smtalk]

I think something is wrong with your MySQL database, if you don't have any important settings - try this:

mv /var/lib/mysql/da_roundcube /var/lib/mysql/da_roundcube_old
Then run the script again.

[nostromo]

nostromo, everything is okay with these errors :) Script didn't found any temporary files and logs, so - it showed an error.

Thanks smtalk.

It works beautifully.

T.

[aurigus]

Just wanted to say thanks for the automated RoundCube installer. Works great and is a lot nicer than the Ueibuiawhatever client.

Now to get a Roundcube Sieve plugin for filtering and a Spamassassin plugin to help manage spams.

[IT_Architect]

Now to get a Roundcube Sieve plugin for filtering and a Spamassassin plugin to help manage spams.This thread is an interesting read. I'm doing a new server. I'm torn between Nutsmail! and RoundCube. RoundCube uses the databases and has drag and drop. Nutsmail! is very nice looking, has a calendar, has message filtering, and anti-spam at the e-mail account level etc. I'll probably go Nutsmail! because the features, and I'm not convinced of RoundCube's stability based on posts I see around the web, and RoundCube is the slowest moving project I've ever seen. However, I'm certain I and customers would rather have RoundCube's richer, more Windows like environment. The unstandardized interface with check boxes, drop downs is annoying and unproductive once you're used to an intuitive and efficient CUA inspired drag and drop environment.

[IT_Architect]

I see a lot of people talking. Who's actually using this on a production server where people use it every day?

Where does this database get stored?

[RadMan]

I've owned a DA license for the past 6 months and despite it's shortcomings it's pretty good bang for your buck..

I also know that DA may put this issue on the back burner because it could very well be a problem that is being caused by RoundCube as it's 3rd party software... LOL

In any event I have a feeling there is a problem with RoundCube and I'm not sure how to correct it orrrrrrrr it may also be a glitch with the way DA handles email forwarding if in fact it does... :confused:

I have quite a few sites that are using less than 5 MB of disc space but I have one that is using up 95% of the 100MB that has been allocated to her because of stored emails.

Problem is, the email addresses that she is using are being forwarded to an address that the site owners ISP has created for her, BUT, Roundcube stores the forwarded mail in its database for some reason... :rolleyes:

One would think that all forwarded mail to an outside resource would bypass the default email program on the server completely. But it appears that it doesn't.

So now the other issue.. RoundCube is a SLUG!!!.... When logging in, it tries to upload all the emails that it has stored in the program PRIOR to allowing you access inside. I have one site that has 1622 emails stored in there and here I sit waiting for the software to open while it attempts to preload all the emails... (I can see the counter just a spinning in the bottom left hand corner of the screen)..

Now I want to try to delete all the duplicated garbage that is being stored... I select to delete 200 emails at a time.. I wait about 15 seconds while the emails are being selected.. I now want to move them to the trash bin.. I wait about 60 seconds while they get transferred into the trash bin.. Once transferred, I try to select another 200 emails to send to trash.. Cannot do it.. The page remains blank...

Now I go to the Trash bin and wait 30 seconds while it loads up.. I select all and wait another 10 seconds.. I hit delete and wait about 30 seconds while the 200 hundred emails get dumped..

Then I go back to the Inbox and start the process all over again..

It has now been 20 minutes and I still have 162 emails to delete..

Totally NOT impressed with this software at all...

Anybody got any ideas how DA can bypass the Default email program when forwarding mail to an outside resource????

Ed

[jlasman]

I have quite a few sites that are using less than 5 MB of disc space but I have one that is using up 95% of the 100MB that has been allocated to her because of stored emails.

Problem is, the email addresses that she is using are being forwarded to an address that the site owners ISP has created for her, BUT, Roundcube stores the forwarded mail in its database for some reason... :rolleyes:

One would think that all forwarded mail to an outside resource would bypass the default email program on the server completely. But it appears that it doesn't.
Is Roundcube storing it? Or is it being stored in the mailbox?

In DirectAdmin mailboxes and forwarders are independent of each other; if you have a forward and a mailbox, the mail will be both forwarded and stored in a mailbox. So if you only want the mail forwarded, remove the mailbox.
So now the other issue.. RoundCube is a SLUG!!!.... When logging in, it tries to upload all the emails that it has stored in the program PRIOR to allowing you access inside. I have one site that has 1622 emails stored in there and here I sit waiting for the software to open while it attempts to preload all the emails... (I can see the counter just a spinning in the bottom left hand corner of the screen)..

Now I want to try to delete all the duplicated garbage that is being stored... I select to delete 200 emails at a time.. I wait about 15 seconds while the emails are being selected.. I now want to move them to the trash bin.. I wait about 60 seconds while they get transferred into the trash bin.. Once transferred, I try to select another 200 emails to send to trash.. Cannot do it.. The page remains blank...

Now I go to the Trash bin and wait 30 seconds while it loads up.. I select all and wait another 10 seconds.. I hit delete and wait about 30 seconds while the 200 hundred emails get dumped..

Then I go back to the Inbox and start the process all over again..

It has now been 20 minutes and I still have 162 emails to delete..

Totally NOT impressed with this software at all...
Are you using mbox or Dovecot/Maildir? mbox (the way DirectAdmin is set up by default) stores all emails in one long file, and requires rewrites of the file every time an email is removed or moved. Dovecot and Maildir together (you can't have one without the other, at least not on DirectAdmin) put each email into it's own file, and should improve speed dramatically.
Anybody got any ideas how DA can bypass the Default email program when forwarding mail to an outside resource????
See above.

Jeff

[jca]

I tried to update to RC2 using this script and I got the following error:

ERROR 1142 (42000) at line 6 in file: 'SQL/mysql.update.sql': ALTER command denied to user 'da_roundcube'@'localhost' for table 'messages'

[smtalk]

jca, just run the script again, and I'm sure it will work :)

[jca]

It worked great. Thanks a lot

[smtalk]

You're more than welcome :) Happy using!

[RadMan]

Is Roundcube storing it? Or is it being stored in the mailbox?

In DirectAdmin mailboxes and forwarders are independent of each other; if you have a forward and a mailbox, the mail will be both forwarded and stored in a mailbox. So if you only want the mail forwarded, remove the mailbox.


Seems to me a simple "if statement" would/could solve any problems and those that wish to use a browser based email program could and those that wanted their email programs forwarded wouldn't have to worry about loss of disc space and duplicate emails...

Would also eliminate the need to eliminate the email program..



Are you using mbox or Dovecot/Maildir? mbox (the way DirectAdmin is set up by default) stores all emails in one long file, and requires rewrites of the file every time an email is removed or moved. Dovecot and Maildir together (you can't have one without the other, at least not on DirectAdmin) put each email into it's own file, and should improve speed dramatically.

See above.

Jeff
I'm using Dovecot/Maildir

Oh Yes.. I finally gave up trying to delete the emails and just increased the disc space for the sites that are gettting loaded up.. :mad:

Ed

[RadMan]

Martynas ..

Can you post the step by step process to update roundcube once you log in using Putty..

Thanks in advance.. :)

Ed

[jca]

Trying to beat Martynas

cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.sh

Same as for install, it automatically detects u already have it and updates everything. (I love the way Martynas scripts)

[RadMan]

Trying to beat Martynas

cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.sh

Same as for install, it automatically detects u already have it and updates everything. (I love the way Martynas scripts)

That's it???.. That's all I have to do???.. I don't have to restart anything?

Ed

[jca]

nothing, as easy and nice as it is.

Maybe to restart apache wouldn't be a bad idea. But I don't think it's necessary.

[RadMan]

nothing, as easy and nice as it is.

Maybe to restart apache wouldn't be a bad idea. But I don't think it's necessary.

Excellent.. Thank you and yes Martynas is good.. :)

Cheers..
Ed

[RadMan]

nothing, as easy and nice as it is.

Maybe to restart apache wouldn't be a bad idea. But I don't think it's necessary.


Seems ot be loading up a little faster now but now when I select 40 messages at a time and try to move them into the trash bin, it tells me it cannot do it.. All I get is "Cannot move the Message" ....

BUT, I can move them one at a time.. 1700 messages to go into the trash bin one at a time on one site.. :((((((((((((

[rldev]

I tried to update to RC2 using this script and I got the following error:

ERROR 1142 (42000) at line 6 in file: 'SQL/mysql.update.sql': ALTER command denied to user 'da_roundcube'@'localhost' for table 'messages'


I get the same error. I tried it several times. Seems to work.

[smtalk]

rldev, you got it because da_roundcube doesn't have "ALTER" permissions. It's fixed in CustomBuild 1.2, but not added to 1.1.

[RadMan]

rldev, you got it because da_roundcube doesn't have "ALTER" permissions. It's fixed in CustomBuild 1.2, but not added to 1.1.

I got the same error when I updated using this code:


cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.sh


Ed

[jlasman]

Seems to me a simple "if statement" would/could solve any problems and those that wish to use a browser based email program could and those that wanted their email programs forwarded wouldn't have to worry about loss of disc space and duplicate emails...

Would also eliminate the need to eliminate the email program..
I have no idea what you mean. Right now you create a forwarder if you want a forwarder, an email box if you want to read email on the server or with POP or IMAP, or both if you want both. I don't know what you mean about eliminating an email program.
I'm using Dovecot/Maildir

Oh Yes.. I finally gave up trying to delete the emails and just increased the disc space for the sites that are gettting loaded up.. :mad:
I use squirrelmail to delete huge amounts of email; I can tell it to display all the emails (it does that quickly when using Maildir), and then checking all and deleting them with one click.

I believe there's also a setting in DirectAdmin to delete all the emails in a mailbox.

Jeff

[RadMan]

I have no idea what you mean. Right now you create a forwarder if you want a forwarder, an email box if you want to read email on the server or with POP or IMAP, or both if you want both. I don't know what you mean about eliminating an email program.

Jeff
Dunno ho wto splain this any easier..

I own www.anysite.com

I create an account using DA..

I want an eamil address called support@anysite.com

I create a POP3 account with a username and a password

I want all mail that comes in for support@anysite.com forwarded to anysite@support.com

This is all fine and works just dandy..

Problem is somehow the mail goes through the default webmail program which duplicates and stores the emails that are being sent to support@anysite.com...

How do I stop the mail from being stored in RoundCube (default webmail program on server) and still maintain the forwarding function???..

[jca]

Why do you need to create the mail in the first place? you just need to create the forwarder.

[RadMan]

Why do you need to create the mail in the first place? you just need to create the forwarder.

Hi jca..

Huh????:confused:

You have to have an email address before you can forward it and in order to have an email address you have to create it in the DA admin panel...

Also, If I want to sendmail from Outlook or any other program, I have to have the ability create email accounts which require the following info..

Username: test@anysite.com
Password: xxxx
Pop3 Server: mail.anysite.com
Smtp Server: mail.anysite.com

Problem is, the minute I create an account, the default WEBMAIL program duplicates and stores the emails that are being passed through the server using up valuable disc space..

e.g.. You send me an email to test@anysite.com (anysite.com is hosted on my server and is administered using DA software). If I were to use ONLY the default WEBMAIL program all is fine.. The mail stops and is stored on the server and I log into RoundCube, check my mail and respond to those that I want to and delete the ones I don't. Don't get me wrong, It's OK for those that want to follow that procedure... THe problem arises when you have more than one website.. :)

Personally I don't like browser based email programs so I forward all mail that comes in for ALL my sites to an address my ISP created for me, which I administer via Outlook EXpress...

This way I don't have to keep logging into 20 different email programs on the server (one for each site I run), in order to check my mail for each domain name..

If I want to send mail from a specific domain name e.g. support@test.com, I create an account in Outlook so I don't have to reveal my primary email address when I send mail.. THe person responds by sending mail to support@test.com which is then passsed through the server and forwarded on to me.

Besides that, when using the forwarding feature in DA the mail has to pass through all the wonderful spam filters on the server thus blocking out all garbage that the spammers send before it gets to me...

Once a day I log into the server as admin click on "Mail Queue Administration" and bounce all the garbage that is being sent to all the email address's on the server.. I look forward to doing that on a daily basis LOL.. :D :D

Ed

[jca]

What if you make the following?

create just the forwarding and send the mail using the "default" account of directadmin as auth for outgoing mail?

Let's say you want all mail arriving to radman@mydomain.com go to radman@hotmail.com. Now your login to DA interface is ed, so you configure outlook to auth outgoing mails using username "ed" and your password, and create a forward so all incoming mail to radman@mydomain.com goes to radman@hotmail.com

It should work, yet I have never done that. From what I know if you make a forward it doesn't goes to the inbox as well, yet I don't use Dovecot/Maildir (yet)

[RadMan]

What if you make the following?

create just the forwarding and send the mail using the "default" account of directadmin as auth for outgoing mail?

Let's say you want all mail arriving to radman@mydomain.com go to radman@hotmail.com. Now your login to DA interface is ed, so you configure outlook to auth outgoing mails using username "ed" and your password, and create a forward so all incoming mail to radman@mydomain.com goes to radman@hotmail.com

It should work, yet I have never done that. From what I know if you make a forward it doesn't goes to the inbox as well, yet I don't use Dovecot/Maildir (yet)

jca..

I'll try it on a domain that I have sitting around but that format will not do my customers any good without getting involved in a lengthy description of "How to Forward Emails" ...


Ed

[QuantumNet]

Hi jca..

Huh????:confused:

You have to have an email address before you can forward it and in order to have an email address you have to create it in the DA admin panel...


No you dont have to have an email address in order to forward it. If you just create a forwarder the mail server will except mail for that account and forward it on.

If you have both a forwarder and an email account setup then both happens, both meaning local delivery and forwarding.


Also, If I want to sendmail from Outlook or any other program, I have to have the ability create email accounts which require the following info..

Username: test@anysite.com
Password: xxxx
Pop3 Server: mail.anysite.com
Smtp Server: mail.anysite.com


The customer could set up like this:
forwarder:
test@anysite.com -> customer@comcast.net

email account:
user name: customer@anysite.com

and configure outlook to send via this account but set the rply to address in outlook to be test@anysite.com


Problem is, the minute I create an account, the default WEBMAIL program duplicates and stores the emails that are being passed through the server using up valuable disc space..


First off Roundcube is not the default webmail client, squirrel mail is. Second round cube is beta and still has a lot of work before it should be used in production.

Third roundcube or whatever webmail client you use with the exception of Ubuntue does not store your emails anywhere, they simply check IMAP which IMAP is a maildir provided by dovecot.


e.g.. You send me an email to test@anysite.com (anysite.com is hosted on my server and is administered using DA software). If I were to use ONLY the default WEBMAIL program all is fine.. The mail stops and is stored on the server and I log into RoundCube, check my mail and respond to those that I want to and delete the ones I don't. Don't get me wrong, It's OK for those that want to follow that procedure... THe problem arises when you have more than one website.. :)

Personally I don't like browser based email programs so I forward all mail that comes in for ALL my sites to an address my ISP created for me, which I administer via Outlook EXpress...

This way I don't have to keep logging into 20 different email programs on the server (one for each site I run), in order to check my mail for each domain name..

If I want to send mail from a specific domain name e.g. support@test.com, I create an account in Outlook so I don't have to reveal my primary email address when I send mail.. THe person responds by sending mail to support@test.com which is then passsed through the server and forwarded on to me.


Okay this is just wierd, you are telling me in outlook you are creating mail accounts to send mail but dont want to have to check those accounts with outlook? You are not doing anything more than you already have done. I think you need to rethink your process here.

I can offer a solution for your needs, we use a product called Saeven|CRM formerly known as Auracle Support. We use this system to manage all our websites and all the email accounts on those websites get piped into specific categories. Each staff member we want to have access to specific email accounts can be granted those permissions. If it is just you well its a good way to keep track of everything. All emails are automatically delivered to your desktop in a nice little instant messenger like interface. I beleive free trials are available and the product is extremely affordable.


Besides that, when using the forwarding feature in DA the mail has to pass through all the wonderful spam filters on the server thus blocking out all garbage that the spammers send before it gets to me...


Saeven|CRM can add even more protection with spam.


Once a day I log into the server as admin click on "Mail Queue Administration" and bounce all the garbage that is being sent to all the email address's on the server.. I look forward to doing that on a daily basis LOL.. :D :D

Ed


Hmm sounds like there is a configuration issue that needs to be addressed if you have a daily mail queue build up.

[RadMan]

WOW.. QuantumNet Thanks for the expalantion..

6 months I've had this software and I was under the assumption that you had to create an email account before you could forward it.. LOL.. Just goes to show that you can be over 55 and stil learn something new every day... :)

Will delete the suggestion on the suggestion thread .. :p

[RadMan]

First off Roundcube is not the default webmail client, squirrel mail is. Second round cube is beta and still has a lot of work before it should be used in production.

Third roundcube or whatever webmail client you use with the exception of Ubuntue does not store your emails anywhere, they simply check IMAP which IMAP is a maildir provided by dovecot.


Thanks for the heads up... The fellow that installed DA when I first bought the server, highly recommended it and it wasn't up until a couple of days ago that I realized what a slug it really is when I started to delete the email messages it was storing... :(


Okay this is just wierd, you are telling me in outlook you are creating mail accounts to send mail but dont want to have to check those accounts with outlook? You are not doing anything more than you already have done. I think you need to rethink your process here.

Actually I just checked a couple of acconts that I have set up on outlook and email address that is actually sending the mail is the one my ISP gave me mail account name is hiding the actual sender... :)

Wiil see what happens when I actually create a pop3 account on the server and use the account information to set it up in Outlook..

Will be interesting to see if Roundcube still stores duplicates..

Ed

[RadMan]

Alrightee... Looks good.. No duplicate emails being stored but now its sending duplicate mail to the receiver.. :(

[jlasman]

Let's say you want all mail arriving to radman@mydomain.com go to radman@hotmail.com. Now your login to DA interface is ed, so you configure outlook to auth outgoing mails using username "ed" and your password, and create a forward so all incoming mail to radman@mydomain.com goes to radman@hotmail.com

It should work, yet I have never done that. From what I know if you make a forward it doesn't goes to the inbox as well, yet I don't use Dovecot/Maildir (yet)
I wouldn't do that with passwords unless I was using secure AUTH, since otherwise every time you sent email you'd be sending the main password for the domain in cleartext.

Also, if you had multiple users doing this each one would have the main password which they could use to change the site, make drastic changes, accidentally or purosely delete everything, etc.

You're right in that if you create a forwarder and not a mailbox the mail only goes to the forward address. I thought I'd made that clear; perhaps I wasn't as clear as I thought I was.

Jeff

[albyb]

Hello!

I have this problem when my client try to send a email with RC
on the sender email address is not the domain name but client@localhost!
how i can fix that?

Thanks!

[smtalk]

Edit /var/www/html/roundcube/config/main.inc.php and change localhost with your hostname.

[albyb]

Thanks,

The best way for me is leve blank on

/var/www/html/roundcube/config/main.inc.php

so evry client can choose the server name!

[jw00dy]

RC2 for me isn't very good. I can't delete any of the messages in my inbox with it.

[smtalk]

You should be able to do that (no problems for me at all).

[smtalk]

I tried to update to RC2 using this script and I got the following error:

ERROR 1142 (42000) at line 6 in file: 'SQL/mysql.update.sql': ALTER command denied to user 'da_roundcube'@'localhost' for table 'messages'


It's fixed in CustomBuild 1.1 too :)

[neo123]

i am using centos 4.4 and da. When i click folders in personal settings, i see a little screen with connection to imap server failed? Roundcube will log me out aswell after that message

howto fix that?

thanks

[chatwizrd]

Does roundcube have any sort of addon so I can have message filters. To do things like automatically move new emails to certain folders, delete certain email... etc

[rkoechel]

I installed roundcube and the script says it was installed successfully here is the output:


[root@server1 scripts]# ./roundcube.sh
cp: `/var/www/html/roundcube/logs/errors' and `/var/www/html/roundcubemail-0.1-r c2/logs/errors' are the same file
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Editing roundcube configuration...
Roundcube has been installed successfully.
Adding roundcube alias to /etc/httpd/conf/httpd.conf
You need to restart the httpd service if you want alias to work.

But when I try to access roundcube from a browser I just get a blank page.

Any Ideas on what I'm missing.

[tanfwc]

I installed roundcube and the script says it was installed successfully here is the output:


[root@server1 scripts]# ./roundcube.sh
cp: `/var/www/html/roundcube/logs/errors' and `/var/www/html/roundcubemail-0.1-r c2/logs/errors' are the same file
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Editing roundcube configuration...
Roundcube has been installed successfully.
Adding roundcube alias to /etc/httpd/conf/httpd.conf
You need to restart the httpd service if you want alias to work.

But when I try to access roundcube from a browser I just get a blank page.

Any Ideas on what I'm missing.

script tell you to restart httpd :)

/etc/init.d/httpd restart

[rkoechel]

script tell you to restart httpd :)

/etc/init.d/httpd restart


I did this previously it still didn't help.

[albatroz]

Has anybody tried to do so?
I would like to replace squirrelmail with roundcube in my next new VPS /roundcube a bit long a not-easy to write url, /webmail is better and roundcube deserves a better luck....

I wish they could use sqlite instead of MySQL to make the installation even easier.

[albatroz]

What IMAP scheme are you using mbox or Maildir.
If you have so many email messages you should use Maildir
(tip: read about Dovecot).


So now the other issue.. RoundCube is a SLUG!!!.... When logging in, it tries to upload all the emails that it has stored in the program PRIOR to allowing you access inside. I have one site that has 1622 emails stored in there and here I sit waiting for the software to open while it attempts to preload all the emails... (I can see the counter just a spinning in the bottom left hand corner of the screen)..

[Invader Zim]

On a new server install Roundcube looks great. So I thought I'd add it to our existing servers. I downloaded the install script and executed it. I got the following result:

(apollon|ttyp0) scripts # ./roundcube.sh
cat: /var/www/html/roundcube/index.php: No such file or directory
[: !=: unexpected operator
Editing roundcube configuration...
Roundcube has been installed successfully.


When I go to the roundcube url I get:

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

[smtalk]

Try this again:

cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
chmod 755 roundcube.sh
./roundcube.sh

[Dauser2007]

[root@host scripts]# cd /usr/local/directadmin/scripts
[root@host scripts]# wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
[root@host scripts]# chmod 755 roundcube.sh
[root@host scripts]# ./roundcube.sh
cp: cannot stat `/var/www/html/roundcube/logs/*': No such file or directory
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Editing roundcube configuration...
Roundcube has been installed successfully.
[root@host scripts]#

[albatroz]

I wish I could replace the default webmail app from squirrelmail to roundcube,
any idea of how to do so?

[smtalk]

http://www.directadmin.com/features.php?id=735

[jjma]

You could change the alias to point from squirrelmail to roundcube in the httpd.conf file:

Alias /squirrelmail /var/www/html/squirrelmail

to

Alias /squirrelmail /var/www/html/roundcube

Restart apache and it'll load roundcube.

Jon

[GXX]

Anyone seen this issue:

http://trac.roundcube.net/ticket/1484716

I just had a user ask me about it as he's seeing this strange delete problem in IE7.

[DarkSiZe]

Hello everbody i hava a error ! who can help my ?

[root@Server2 scripts]# cd /usr/local/directadmin/scripts
[root@Server2 scripts]# wget -O roundcube.sh http://files.directadmin.com/services/all/roundcube.sh
--19:34:54-- http://files.directadmin.com/services/all/roundcube.sh
=> `roundcube.sh'
Resolving files.directadmin.com... failed: Temporary failure in name resolution.

[smtalk]

Check your /etc/resolv.conf file. For now just try this:

cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://72.35.85.222/services/all/roundcube.sh
chmod 700 roundcube.sh
./roundcube.sh

[DarkSiZe]

Check your /etc/resolv.conf file. For now just try this:

cd /usr/local/directadmin/scripts
wget -O roundcube.sh http://72.35.85.222/services/all/roundcube.sh
chmod 700 roundcube.sh
./roundcube.sh




okay thats working alone 1 problem

i hava a error ! this my error


20:11:10 (127.59 MB/s) - `roundcube.sh' saved [4950/4950]

[root@Server2 scripts]# chmod 700 roundcube.sh
[root@Server2 scripts]# ./roundcube.sh

gzip: stdin: unexpected end of file
/bin/tar: Child returned status 1
/bin/tar: Error exit delayed from previous errors
Directory /var/www/html/roundcubemail-0.1-rc2 does not exist

who can help my plz ?

[smtalk]

Try: rm -rf /usr/local/directadmin/scripts/packages/roundcube*
Then run the script again.

[DarkSiZe]

i have fix it the tar.gz most removed on /usr/local/directadmin/scripts/packages/roundcube ;)

[byfobi]

Warning: ini_set() [function.ini-set]: SAFE MODE Restriction in effect. The script whose uid is 501 is not allowed to access logs/errors owned by uid 0 in /var/www/html/roundcubemail-0.1-rc2/program/include/main.inc on line 150

? Error

[SupermanInNY]

Warning: ini_set() [function.ini-set]: SAFE MODE Restriction in effect. The script whose uid is 501 is not allowed to access logs/errors owned by uid 0 in /var/www/html/roundcubemail-0.1-rc2/program/include/main.inc on line 150

? Error

Did you enabled Safe Mode in the php.ini?
If you have, it will break lots of things.
You should use safe mode in the PHP Safe Mode Configuration at the Admin Level per each website.
If you use the global safe mode in the php.ini it will not work for you.

-Alon.

[Sheldon]

[root@lelu ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [Mon Feb 11 22:42:53 2008] [warn] The Alias directive in /etc/httpd/conf/httpd.conf at line 179 will probably never match because it overlaps an earlier Alias.
[Mon Feb 11 22:42:53 2008] [warn] NameVirtualHost xx.xx.xx.xx:80 has no VirtualHosts
[Mon Feb 11 22:42:53 2008] [warn] NameVirtualHost xx.xx.xx.xx:443 has no VirtualHosts
[Mon Feb 11 22:42:53 2008] [warn] NameVirtualHost xx.xx.xx.xx:80 has no VirtualHosts
[Mon Feb 11 22:42:53 2008] [warn] NameVirtualHost xx.xx.xx.xx:443 has no VirtualHosts

What with the alias directive for roundcube? It works, but why this error?
I checked the httpd.conf file and there was includes to half a million different files? Which one should I look in.
Also where can I go to fix those nasty little warn errors? Which would be great if they were fixed in DA?

[GXX]

What's the alias entry on line 179?

[Sheldon]

# Alias for RoundCube webmail
Alias /roundcube /var/www/html/roundcube/

[GXX]

Check if you have another /roundcube alias like the one on line 179. If so, comment out the duplicate or incorrect one.

[Sheldon]

well yes, but I dont see that anywhere....

let me check the include files I guess

[Sheldon]

fixed thanks, yeah I had to find an include file

[Sheldon]

[root@tiko scripts]# sh roundcube.sh
cp: cannot stat `/var/www/html/roundcube/logs/*': No such file or directory
cp: cannot stat `/var/www/html/roundcube/temp/*': No such file or directory
Editing roundcube configuration...
Roundcube has been installed successfully.
/bin/chown: `webapps:webapps': invalid user


Now that on a different server :s ... this script is unrealiable.... same with the email admin panel addon by DA..

EDIT: Fixed, I had to add the webapps user manually, touch some files and rerun the installer

[GXX]

Why don't you try the roundcube install provided by custombuild? That has always worked for me.

http://www.directadmin.com/forum/showthread.php?t=19221

[bigboy]

mars# ./build roundcube
Can not install PHP4 and PHP5 as CLI.


install on customapache cannot read mail

[smtalk]

Edit options.conf and set php4_cli or php5_cli to no.

[bigboy]

change to options.conf
php4-cli=no

this error



mars# ./build php4-cli
Downloading php-4.4.8.tar.gz...
php-4.4.8.tar.gz 100% of 5497 kB 127 kBps 00m00s
Downloading php-4.4.8-mail-header.patch...
php-4.4.8-mail-header.patch 100% of 3487 B 13 MBps
Can not build PHP4 as CLI because it is not set in options.conf.

[smtalk]

It's said in CustomBuild FAQ that you can't have both versions as CLI (PHP4 as CLI and PHP5 as CLI).

[bigboy]

my os freeBSD 5.4

[smtalk]

OS doesn't matter :)

[Scormen]

Hello Sheldon,

I'm having the same problem now. What have you done to fix it? What was that included file?

Thanks,
Kris

[ssi.inc]

I can log into the Roundcube interface, receive email, read email, move and delete messages with no problem. However, when I compose email nothing happens when I send the message. The current compose page does not change in the slightest. It looks like I didn't press the send button.

The apache log has a new entry every time I press send though.

"exim abandoned: unknown, malformed, or incomplete option -f"

Can someone help me with this one?

ssi.inc

-EDIT-
Reinstalled as below. Roundcube mysql database must have been messed up because deleting that DB and reinstalling Roundcube solved the problem.

[Sheldon]

there is an include file in /etc/httpd/conf/extras for the aliases check there you should see a duplicate.

as for the sending mail issue, uninstall roundcube and reinstall it, however I doubt that will fix it. it seems more or less like an issue with exim. reinstall/upgrade exim to the latest version or better yet abandon exim for dovecot :D

[Scormen]

Sheldon, now is it working :) thanks.

[GXX]

seetharaman - I'd strongly advise you to edit that information out from your post.

In regards to receiving email, your nameservers do not appear to be correctly setup.

[SupermanInNY]

seetharaman

I strongly agree with GXX message:

Immediatly change the password/remove that user login info from the public forums. You are allowing hackers to abuse your server to send out emails. Not a very favorable thing from RBLs.

If you need assistance with specific issues and want to provide access to a system, use private messages or emails, but do not leave login info in public forums.

-Alon.

[jca]

Trying to update to roundcube 0.1 I get the following error:

--00:33:31-- http://files.directadmin.com/services/all/roundcube/roundcubemail-0.1.tar.gz
=> `/usr/local/directadmin/scripts/packages/roundcubemail-0.1.tar.gz'
Resolving files.directadmin.com... done.
Connecting to files.directadmin.com[72.35.85.222]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1,406,854 [application/x-gzip]

100%[====================================>] 1,406,854 478.54K/s ETA 00:00

00:33:34 (478.54 KB/s) - `/usr/local/directadmin/scripts/packages/roundcubemail-0.1.tar.gz' saved [1406854/1406854]

ERROR 1142 (42000) at line 6 in file: 'SQL/mysql.update.sql': ALTER command denied to user 'da_roundcube'@'localhost' for table 'messages'
Editing roundcube configuration...
Roundcube has been installed successfully.


Any ideas?

[SupermanInNY]

how can you tell which version is installed?
I don't see a Version number on my server. Where should I be looking?

-Alon.

[Sheldon]

a new version of DirectAdmin 0.1 stable was just released.

Wait for DA to directly acknowledge the update.

Ive forwarded a copy of the release notification to support@directadmin.com they will get it and im sure update the release package for DA making it easy to install.

[jca]

To be honest I got a list with all the installed versions of the software in my server... I updated from Roundcube v0.1-rc2

Maybe checking the readme from the roundcube folder or something will bring light. Or checking the "newest" tar.gz in the folder

[SupermanInNY]

To be honest I got a list with all the installed versions of the software in my server... I updated from Roundcube v0.1-rc2

Maybe checking the readme from the roundcube folder or something will bring light. Or checking the "newest" tar.gz in the folder

Is this in in response to 'what version is installed' ?

I'd expect a Version number to show on the webpage of the login page or the 'help--> about' .

Squirrlemail has it on the login page.

-Alon.

[Sichelia]

Hi,
there is the possibility to show in roundcube the "disk usage" for email ?

Thanks in advanced, Leonardo.

[jlasman]

I'm not sure where this thread is going ...

Are we asking that someone make changes to Roundcube?

Jeff