Hello,
I'm experiencing a quite high load (for a webmail interface) on our
server with roundcube 0.5.1. The old server was an Opteron Single Core
CPU with 2.2 GHz and only 1 GB RAM. It had a load of >30, but it was
old. So I moved the webmail to a newer server with Opteron Dual Core and
8 GB RAM, but the load is still very high (around 15).
What's the reason for this? Is it normal? I mean: roundcube is very AJAX
heavy, is it due to the IMAP connection pools, frequent polls etc.? I
don't know how many users are connection concurrently, but it shouldn't
be more than 50.
Kind regards
Marten
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
We use postfixadmin and have a mailbox_postdeletion_script which does the
job of "removing" the actual maildir (though we don't delete, we move it
aside for a couple of weeks, so we can help folks restore when they've
made mistakes.) That script also does some cleanup on the roundcubemail
database -- and I want to enhance it to similarly not actually delete
users roundcube data, but just mark the del columns -- Then we
can periodically use the roundcube/bin/cleandb.sh script to make the
removal permanent.
My question is, not all tables have the del column, like the root of all
tables: the users table. (Also the contactgroups table -- but it looks
like the cleandb.sh script might deal with that??) So what exactly is
recommend db maintenance when removing a mailbox?
I was looking at doing something like::::::
SELECT user_id FROM users WHERE username LIKE '$ARGV'
UPDATE identities SET del=1 WHERE user_id = '$user_id'
DELETE FROM cache WHERE user_id = '$user_id'
UPDATE contacts SET del=1 WHERE user_id = '$user_id'
UPDATE contactgroups SET del=1 WHERE user_id = '$user_id'
DELETE FROM messages WHERE user_id = '$user_id'
??DELETE FROM users WHERE username = '$ARGV' LIMIT 1??
This last line is where I get stuck because I don't really want to delete
it, but there is no del column to mark. . .
Any input much appreciated ;)
Ben
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
I was doing today a small exercise to see the status of branch 0.5.x
I am looking for the bugs we know that release have, and we have fixed
but didn't released in 0.5.1 yet
i have made a query into trac:
http://trac.roundcube.net/query?status=closed&type=Bugs&type=Bug
+Patches&version=!
svn-trunk&resolution=fixed&milestone=0.6-beta&col=id&col=summary&col=milestone&col=status&col=type&col=priority&col=component&order=priority
the filter i have chosen for this small exercise didn't include any bug
that the original version was svn-trunk, and didn't check for closed
tickets in 'later' milestone; only ticket which type is a
Bug/BugPatches, fixed and closed in the next milestone (0.6-beta).
that brings to me 7 patches:
- Ticket #1487784 Fixed in r4543.
- Ticket #1485975 Done in r4547.
- Ticket #1487664 Fixed in r4551
- Ticket #1487673 Fixed in r4433.
- Ticket #1487775 Fixed in r4535
- Ticket #1487785 Fixed in r4540
- Ticket #1487789 Fixed in r4556.
After doing a svn copy on my Working copy and reviewing each .diff, only
one (r4433) was applied to tags/roundcubemail/v0.5.1 but the others not
yet and they are fixing interesting things for production environment.
pending fixes are:
- Ticket #1487784 Fixed in r4543 !
- Ticket #1485975 Done in r4547 !
- Ticket #1487664 Fixed in r4551 !
- Ticket #1487775 Fixed in r4535 !
- Ticket #1487785 Fixed in r4540 !
- Ticket #1487789 Fixed in r4556 !
those changes can be applied to 0.5.1 and get a more stable 0.5.x
version available for production.
Can we get a release 0.5.2 with these patches applied?
regards
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hey all, could someone explain what the idea is with the svn branches? I see Alec is doing updates of 0.5 from trunk patches. Does this mean there is a supported 0.5 branch, that will include most bugfixes from trunk? If one wanted to follow an svn repo to stay current, would you suggest following a branch, or trunk?
Regards,
Cor
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
I'm writing a little filter extension to get spam out of the way.
My MTA writes ***SPAM*** in the subject line if this is the case.
As far as I can see I followed the rules for plugins, activated it,
but : no go.
This is the code :
<?php
class incoming_filter extends rcube_plugin
{
public $task = 'mail';
function init()
{
$this->add_hook('message_load', array($this,'header'));
}
function header($args)
{
$text = trim($args->headers['subject']);
$pos = stristr($text, "SPAM");
if($pos == 0)
return $args;
$rcmail = rcmail::get_instance();
if (($junk_mbox = $rcmail->config->get('junk_mbox')) && $mbox !=
$junk_mbox) {
$rcmail->output->command('move_messages', $junk_mbox);
}
}
}
?>
Can anybody point me in the direction what i'm doing wrong ???
Thanks in advance,
Steven
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi
You were introducing (better) CSRF protection in RC 0.5.1. In RC 0.5 we were able to provide our own custom login forms (on a different domain) for Roundcube. In 0.5.1 those forms no longer work, probably due to the missing "_token" POST request param. We're getting redirected to the login form right after submitting the login credentials.
We provide both "_user" and "_pass" input fields but are not able to provide the hidden "_token" field as this token gets generated by RC.
Example login form that works perfectly under RC 0.5:
https://my.onlime.ch/index/webmail
Is there any workaround for this in RC 0.5.1? I couldn't find any hints about custom login forms in your Wiki.
Thanks!
Regards, Philip
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi
Labels in Khmer updated
Cheers,
Sengtha
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/re/PdGv3lGD/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
Is there any translation tool for Managesieve plugin?
How can I translate the Managesieve plugin?
Regards,
DC
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Or am I missing something?
Because users just had addresses in their addressbooks, without filing
them under contact groups, then 0.5 shows empty addressbooks with queries
like:
SELECT * FROM contactgroups WHERE del<>1 AND user_id='23' ORDER BY name
Seems like there's some mysql Fu that needs to happen to put each users's
contacts into a contactgroup. . .
Ben
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
attachment contains Russian translation.
Anton
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/vU/BPcbA4vc/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hello Devs,
I use the Roundcube and I like so much, but in 0.5.1 version have a change in rcube_user.php which causes problems in the users table with many records:
SELECT * FROM users WHERE mail_host = '----' AND BINARY username = '---';
This query is too slow when we have more than 200000 records, because using like this the index is not used. I did some tests and the best way is using BINARY before the username(variable of login):
SELECT * FROM users WHERE mail_host = '----' AND username = BINARY '---';
In this case, in "users"."username" have index for use and query is more fast.
Regards,
Thiago Coutinho
obs: The tests were made by Francisco Freire and Thiago Coutinho.
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
slovak translation update labels.inc
Martin
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/RS/pZUugGaU/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Slovak translation update messages.inc
Martin
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/FS/1ymcmn8o/messages.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi
Update of Russian labels.inc
--
Regards,
Nikolay.
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/df/jywWHtiF/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
> I have installed roundcube 0.5 and it works very well
>, but at the moment only with the imap login credentials.
> I have another mysql database with all active email addresses and imap login names.
> So i activate the plugin "virtuser_qery" and add the line ...
> to my main.inc.php file.
> I have also activated the sql logging, but all sql query's i can see goes to the
> roundcube database. my other database would not be asked. :(
okay, hit me. my fault. I misunderstand the plugin until now. It works good. But my problem still alive. I am looking for a sql plugin who looks for the mailbox name if I type in the E-Mail Adress. For Squirrelmail it is virtusertable. Has everybody build the same for roundcube?
Tanks 4 your help :-)
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hello Roundcube lovers
The just released update fixes some bugs discovered with the 0.5
stable version and also improves security by preventing some possible
CSRF attacks. This includes an optional referer check which is yet
disabled by default. If you trust HTTP Referer headers you can enable
it in config with $rcmail_config['referer_check'] = true;
Furthermore IDNA support has now been improved and some visual
glitches in IE and Safari have been resolved. Thanks again to all
reporters and pathc contributors!
We recommend to update all existing Roundcube installation with this
release. It can be downloaded from http://roundcube.net/download
and a complete list of changes is available here:
http://trac.roundcube.net/wiki/Changelog
Best wishes,
Thomas
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
I'm trying to debug one of my plugins. Since changes in the core to ldap
address book groups it can't work with them anymore. I don't have an ldap
address book myself and the example on in the config file doesn't appear to
have any groups. Does anyone know of a public ldap address book with groups
I could use for my testing?
Thanks,
Phil
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi Mark,
> If this set up can be of use for testing your plugin and you can wait
> till tomorrow I can give you the details.
>
That would be great, thanks.
Phil
>
>
> ------Original Message------
> From: Phil Weir
> Sender: dev-bounces+mark=katmoda.com(a)lists.roundcube.net
> To: dev(a)lists.roundcube.net
> Subject: [RCD] public ldap addressbook with groups
> Sent: Feb 8, 2011 19:06
>
> Hi,
>
> I'm trying to debug one of my plugins. Since changes in the core to
> ldap
> address book groups it can't work with them anymore. I don't have an
> ldap
> address book myself and the example on in the config file doesn't
> appear to
> have any groups. Does anyone know of a public ldap address book with
> groups
> I could use for my testing?
>
> Thanks,
>
> Phil
>
> _______________________________________________
> List info: http://lists.roundcube.net/dev/
> BT/34d81ff9
>
> -------------------
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
hello,
it_IT updated labels.inc file
--
bye,
emilio
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/kC/gWKGT9xy/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi list,
I'm having issues with a custom dev for markasjunk2 plugin.
I want to access the header X-DSPAM-Signature using the following code:
------
// get dspam signature header (%s macro)
if(preg_match("/%s/",$command)){
$MESSAGE = new rcube_message($uid);
$dspam_signature = $MESSAGE->get_header('x-dspam-signature');
file_put_contents('/tmp/mark_dspam', "uid=$uid;
signature=$dspam_signature\n");
$command = str_replace('%s', $dspam_signature,$command);
}
------
And all I get is an empty string instead of the header's value:
------
# cat /tmp/mark_dspam
uid=25; signature=
------
If I try to fetch the header 'subject' instead of x-dspam-signature, it
works alright.
In the email, this header is present :
------
Date: Mon, 07 Feb 2011 15:16:48 -0500
From: Julien...
User-Agent: Mozilla...
MIME-Version: 1.0
To: julien...
Subject: spam
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-DSPAM-Result: Innocent
X-DSPAM-Processed: Mon Feb 7 21:16:55 2011
X-DSPAM-Confidence: 0.9899
X-DSPAM-Improbability: 1 in 9809 chance of being spam
X-DSPAM-Probability: 0.0000
X-DSPAM-Signature: 4d50533749761795657448
------
I can't use the imap_init hook because the code is located in the
'cmd_learn.php' driver and not in the main function (it's on purpose).
How can I access this header ?
Thanks,
julien
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
I’ve attached an updated Swedish localization of labels.inc.
Regards,
Jonas Nasholm
Bitfuse Network
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/L8/d2vnzwkY/sv_SE.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi people!
this is a (may be) stupid question for someone, but for me is what i
need now and don't know where to find info:
how can i download the 0.5.1 dev branch ?
i get only stables and trunk, but not found how to get 0.5.1
thanks!!
Charly
--
Carlos Pasqualini <charly(a)setionline.com.ar>
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
I love roundcube!
--
Alessio Leonarduzzi
tel +393405403068 fax +3904321841022
mail alessio.leonarduzzi(a)gmail.com
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/YK/Dyytkv6X/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Gmail has an interesting (labs-only) feature when the tab is "pinned"
in Chrome - the favicon displays a counter of unread email, which makes
pinning your mail tab a very easy way to tuck it away but still
unobtrusively notify of new mail. See:
http://news.softpedia.com/news/Gmail-Unread-Messages-Icon-Now-in-Labs-18057…
I also keep both gmail and roundcube open all day - this would be a
PERFECT feature to add.
Any other interest out there?
Mark Miller
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi folks,
Is there a new or recommended way to get the real server name? We used
to use env:servername, but that appears to have been removed at some
point. I couldn't find a 'new way,' but I didn't want to write a plugin
just for that yet without checking.
Thanks!
--
Martin B. Smith
smithmb(a)ufl.edu - (352) 273-1374
CNS/Open Systems Group
University of Florida
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/uf/w9J+tf3q/smime.p7s
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
hi,
can someone shed some light on the main.inc.php config option
$rcmail_config['login_lc'] = false;
i have only lower case login names (login = full email address)
and stumbled over the problem that, somewhere along the way to 0.5
final, my users created Office(a)domain.at or kathrin.Maier(a)domain.tld
a user now now tried to log in via "office(a)domain.at" and got an
error because "Office(a)domain.at" already existed.
Office(a)domain.at worked without any problem.
i do not quite understand if i need this to be true or false.
what i want: forced lowercase for at least all roundcube usernames.
thanks,
raoul
--
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc. email. r.bhatia(a)ipax.at
Technischer Leiter
IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at
Barawitzkagasse 10/2/2/11 email. office(a)ipax.at
1190 Wien tel. +43 1 3670030
FN 277995t HG Wien fax. +43 1 3670030 15
____________________________________________________________________
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Labels and messages updated.
Cheers,
Barbara
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/3Y/aCryd8s5/sl_SI.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
hi,
is there an auto-magic cleanup for "temp_dir"?
if so, is there any way to fine tune this (e.g. after x days?)
if not, how about implementing such a maintenance job?
thanks,
raoul
--
____________________________________________________________________
DI (FH) Raoul Bhatia M.Sc. email. r.bhatia(a)ipax.at
Technischer Leiter
IPAX - Aloy Bhatia Hava OG web. http://www.ipax.at
Barawitzkagasse 10/2/2/11 email. office(a)ipax.at
1190 Wien tel. +43 1 3670030
FN 277995t HG Wien fax. +43 1 3670030 15
____________________________________________________________________
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Dear all
My name is Sengtha Chay.
I have finished to translate Roundcude to Khmer.
Please help to update it.
Regards,
Sengtha
Khmer translation for Roundcube
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/sr/rnYSxNPn/kh_KH.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi all,
I updated Japanese Translation for plugin.
Please check attached files.
Regards,
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/U5/QCnrVucn/roundcubewebmail-plu.gz
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Translation update for European Portuguese (pt_PT) for "labels.inc" and
"messages.inc" with the new labels and messages.
Regards,
DC
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/g3/5QM38KuU/messages.inchttp://detached.gigo.com/rc/g3/5QM38KuU/labels.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
I´ve attached updated German localizations of labels.inc and messages.inc
Best Regards,
Ralf Scholle
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
I’ve attached updated Swedish localizations of labels.inc and messages.inc.
Regards,
Jonas Nasholm
Bitfuse Network
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/tw/JB3QvquQ/sv_SE.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi
Please update Azerbaijani language.
Files: labels.inc and messagec.inc
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/ut/j6kYaavh/Azerbaijani_for_RC.rar
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
hello,
in attach the updated italian (it_IT) translations file from roundcube
(created with the online http://translator.roundcube.net/ tool);
I also 'attach' many thanks all the developers for the great software
and the outstanding speed in patching and adding new features!
PS in order to send this e-mail to the dev mlist (as suggested on the
online translator tool) I had to subscribe to the list, otherwise it
bounced me the mail back with this error:
Recipient address rejected: Please wait 5 minutes after you subscribe to
dev(a)lists.roundcube.net before attempting to post; or
subscribe/resubscribe at http://lists.roundcube.net
--
bye,
emilio((a)antispam.it)
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/aH/QcAJx6TH/labels.inchttp://detached.gigo.com/rc/aH/QcAJx6TH/messages.inc
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80