Dev

dev@lists.roundcube.net

4296 discussions

High cpu overload
by Tiago Gomes 05 Jul '09

05 Jul '09

Hello everyone. sorry because my poor english congratulations to all the excellent project roundcube mail. I have one problem, I installed all versions for test, including svn / trunk (latest) and all creates overload on my server. High cpu load I'm using the services: Apache: Server version: Apache/2.2.6 (Unix) Server built: Jul 1 2009 20:41:05 * - -with-mpm=worker* Php: PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009 22:16:23) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies Mysql 5.0 SERVER load average info after 10 minutes then restart the apache server: *top - 16:48:25 up 6:24, 3 users, load average: 6.92, 2.89, 3.88* Tasks: 84 total, 2 running, 82 sleeping, 0 stopped, 0 zombie *Cpu(s): 98.1%us, 1.7%sy, 0.0%ni, 46.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st* Mem: 2076288k total, 1079936k used, 996352k free, 297020k buffers Swap: 498004k total, 0k used, 498004k free, 486532k cached PID USER PR NI VIRT RES SHR S *%CPU* %MEM TIME+ COMMAND 14103 www-data 20 0 564m 125m 3536 S *190* 6.2 6:28.57 httpd 14088 www-data 20 0 517m 89m 3464 S * 118* 4.4 10:45.10 httpd the log error log from round roundcube mail: Only: *[03-Jul-2009 16:48:08 -0300] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_501fd0fc317c477d1c729158644dc2c5bd5f1d12d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '2557-INBOX.msg-13334' for key 2] in /webhost/ webmail.atarde.com.br/program/include/rcube_mdb2.php on line 621 (GET /?_task=mail&_mbox=INBOX&_page=1) [03-Jul-2009 16:48:08] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_674a5a0876c6968d9d29cb5837c47123866f39a43 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '2557-INBOX.msg-13401' for key 2] * Can you Help me, ? Thank's -- ---------------------------------------------------------------- Tiago Gomes Pereira http://www.tiagogomes.eti.br LPI Certified LPI ID - LPI000129445 IT Service Management - ITIL FOUNDATION V2 ID - SR341901 algodas(a)gmail.com _______________________________________________ List info: http://lists.roundcube.net/dev/

2 2

updated pt_BR localization
by Denis Volpato Martins 05 Jul '09

05 Jul '09

Hi, I’ve attached the patch for the completed pt_BR localization. Att. - Denis --- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/Bf/a6SuCK11/pt_BR.patch Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< --- _______________________________________________ List info: http://lists.roundcube.net/dev/

1 0

Re: [RCD] High cpu overload
by till 04 Jul '09

04 Jul '09

Oops... Btw, please CC the list (always). On Sat, Jul 4, 2009 at 10:50 PM, till<klimpong(a)gmail.com> wrote: > On Sat, Jul 4, 2009 at 10:09 PM, Tiago Gomes<algodas(a)gmail.com> wrote: >> yes, I do , but the cpu HIGH Over continued, any Idea ? it ´s normal ? > > I hope that means the database error is gone. ;-) > > In general, RoundCube doesn't cause high loads for me. I'd suggest you > run xdebug and generate some cachegrind files (through xdebug's > profiler) to figure out what is going on. There could be a number of > things slowing the webserver down. > > http://xdebug.org/docs/profiler > > Till > _______________________________________________ List info: http://lists.roundcube.net/dev/

1 0

Re: [RCD] Message archive plugin
by Roland Liebl 03 Jul '09

03 Jul '09

Is there a way to localize the "Archive" folder? Regards, Roland _______________________________________________ List info: http://lists.roundcube.net/dev/

3 2

Database Table for Plugins
by Roland Liebl 03 Jul '09

03 Jul '09

Hi all, I think it might be a good idea to have a database table for plugins. If plugins needs to store some values currently this is done mostly by using 'users' table 'preferences' field. I think it's better to have a separate table. The following structure should be flexible enough. ------------------------------------------------------ CREATE TABLE IF NOT EXISTS `plugins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `contact_id` int(11) DEFAULT NULL, `identity_id` int(11) DEFAULT NULL, `plugin` text, `key` text, `value` text, `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -------------------------------------------------------- Any comments are welcome. Regards, Roland _______________________________________________ List info: http://lists.roundcube.net/dev/

1 0

memory use
by Cor Bosman 29 Jun '09

29 Jun '09

Hi devs, just wondering if this is normal: Jun 29 16:36:03 roundcube-test roundcube: PHP Fatal error: Allowed memory size of 104857600 bytes exhausted (tried to allocate 17100392 bytes) in /data/WWW/roundcubemail-2493/program/lib/Net/SMTP.php on line 831 This is a 12MB attachment. That shouldnt be needing a total memory footprint of 100+ MB. I had to move our memory limit up to 200MB just to be able to send a 12MB attachment. Regards, Cor _______________________________________________ List info: http://lists.roundcube.net/dev/

1 0

One time ticket auth and imapproxy
by Robert King 26 Jun '09

26 Jun '09

Folks, I'm experiencing a very odd issue with a custom plug-in using the authenticate hook. Here at our university we use a Web based single sign on authentication called CAS (http://www.jasig.org/cas). I am trying to write a plug-in to allow CAS to work with Roundcube proxying a connection through imapproxy (http://www.imapproxy.org/). The normal operation for authentication for IMAP by CAS service is to get a one time use CAS ticket for every authentication. Since RC stores and reuses the initial password CAS cannot work in direction connection to the IMAP server. This is not an issue because when we proxy through imapproxy, it holds open the imap connection by password/username combination. So everything should be working great and superficially it seems okay, that is until you try and delete an e-mail. It seems that a delete will call the authenticate hook again and grab a new CAS ticket. The new CAS ticket breaks the imapproxy connection identifier because the password is now different. In turn this causes rc to have a "lost imap connection" error. The way I look at it I have 2 possibilities: 1. Figure a way out to only request the CAS ticket once in the plugin. I'm guessing do a check for existing ticket before requesting. This is the quick fix, but feels like a "duct tape" solution for what might be a larger issue in extending RC for alternative authentication mechanisms. 2. Extend RC so that instead of caching a password, it uses a password recall function that can has an exec handler for custom plug-ins $rcmail->auth->getpass() returns a clear text password and has an exec handler for password return. Default it would be an abstraction of the decrypt session password to keep current functionality The value with option two is it would allow plug-in authors to authenticate to peripheral services like managesieve with out limiting alternative authentication methods. I've included the current sort of working plugin for anyones interest. -- Robert King System Administrator Computing & Communications Memorial University --- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/BK/UGmCcQQp/casauth.php Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< --- _______________________________________________ List info: http://lists.roundcube.net/dev/

1 2

Password plugin and virtuser plugin ideas
by A.L.E.C 25 Jun '09

25 Jun '09

We have a few plugins for password change using different methods for saving new password, but all of them have the same UI. I think it would be better for localization and future maintenance to join them into one plugin with many drivers. We need one function for password change, so we can do this as simple as possible. Let's add drivers/ directory with files sql.php, sasl.php, etc. and config option 'password_driver'. So, everyone just could add his own driver function. My second idea is to create hooks for rcube_user's email2user and user2email functions. Then we could move current virtuser_* features into 'virtuser' plugin. This plugin should also work as password above with drivers for file, sql, or any callback. -- Aleksander 'A.L.E.C' Machniak http://alec.pl gg:2275252 LAN Management System Developer http://lms.org.pl Roundcube Webmail Developer http://roundcube.net _______________________________________________ List info: http://lists.roundcube.net/dev/

5 5

slow messages deleting - read_when_deleted being a performance killer
by darklight 24 Jun '09

24 Jun '09

Hi, one note before you continue reading: I'm not familiar with xdebug yet - so you may need to re-verify me findings. also this mail is not a wish to immediately fix some performance-lag, but more some info to the developers/project managers so they can plan correctly :) because I was interested.. I installed xdebug today [1] so.. I was cleaning up my mailbox and I deleted 200 messages (at once) according to firebug this took ~60 seconds which is quite much... then I did some tests... after checking xdebug's profiler output I found something strange: there were 745 queries made by rcube_mdb2->query (which calls _query and this calls the real MDB2 stuff...) 745 queries - and I just profiled the click on the delete button (NOTE: the at this point the messages were in folder X and now they were moved to "Trash") NOTE: there was one huge call to rcube_imap->set_flag() which is because I have $rcmail_config['read_when_deleted'] = TRUE; in my config maybe this can also be optimized (not sure if it can be - but this should have a lower prio) also read_when_deleted s a real performance-killer, I'll try to explain later small break here: as I had message caching enabled I wanted to check if really all messages were in my (MySQL) DB.. looked fine after like 10 seconds (deleting was still being done by roundcube) I refreshed the phpMyAdmin page... and what was that? now there were less messages in the table than before.. - even if they were just moved to "Trash" now.. I waited some seconds - and the row count started to rise again let's try to explain so many database queries (NOTE: keep in mind I had read_when_deleted enabled): when user deletes message 1 from mailbox X the following happens: * $IMAP->set_flag($uids, 'SEEN'); reads and deletes all messages from the caching table... that already makes 400 queries * (message being moved through IMAP) * (message being parsed through IMAP) * message being inserted into the cache table (in the DB) again - that makes another 200 queries -> we're at a total of 600 now plus some others (had no time yet to fully check this) now.. I'm pretty sure that set_flag kills so much performance because it removes the messages from the cache. wouldn't it be easier to just update the header column in the database? (ok, I see it's needed that you unserialize the field.. change some value, then serialize it again and I'm not sure if that costs even more time) also move_message() should do the same, currently it just gets the mail from the caching table and removes it from there (if it exists) - later it has to be inserted into the DB again I may do some more tests later.. feel free to suggest other parts which I could profile :) Regards, Martin [1] http://www.xdebug.org/docs/ _______________________________________________ List info: http://lists.roundcube.net/dev/

2 7

Updated galician translation
by David Garabana Barro 24 Jun '09

24 Jun '09

Hi I send the updated galician translation -- David Garabana Barro jabber & google talk ID: david(a)garabana.com Clave pública PGP/GPG: http://davide.garabana.com/pgp.html --- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/WW/8XM8kJhR/labels.inc http://detached.gigo.com/rc/WW/8XM8kJhR/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/

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev