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