- Dev - Roundcube mailing lists

PHP <-> MySQL interaction
by Darren Austin 22 Dec '05

22 Dec '05

Hi, I recently downloaded roundcube (CVS-20051216 version) and had some problems with installation. After a few hours of debugging, I found the problem and just wanted to give people a heads-up regarding this issue as i'm sure it's going to bite a few others :) My set up: Apache 1.3.34 PHP 4.4.1 MySQL 4.1.16 The problem I was experiencing was that every time I attempted to load roundcube I was getting the following errors: DB Error in /path/to/roundcube/program/include/rcube_db.inc (67): DB Error: connect failed Fatal error: Call to undefined function: query() in /path/to/roundcube/program/include/rcube_db.inc on line 151 After several hours of profanity thinking that i'd buggered up the DSN specification, I enabled MySQL's logging to see what exactly was being sent to the server from roundcube and why the connection was being refused. I discovered that this problem has _nothing_ to do with roundcube but is due to the interaction between newer versions of MySQL and PHP. Since MySQL version 4.1.1 there has been a new hashing algorithm used to store database user passwords in MySQL. Unfortunately, the version of DB in roundcube (and the current version in PEAR) do not have the capability to send database user passwords in the new hashed format. The mysqli extension in PHP5 (apparently) doesn't suffer this problem. The MySQL manual details several ways to correct this issue, but the least intrusive seems to be to "degrade" the password for just the roundcube database user to the old style hashing format, which PHP can use to authenticate. Of course, this can be done for any other databases which need to be accessed from PHP when used with MySQL => 4.1.1. The full details of the other options are available in the manual, but the quick fix is: # mysql -u root -p mysql Enter password: <blah> mysql> SET PASSWORD FOR 'roundcube'@'localhost' = OLD_PASSWORD('new_password'); mysql> quit You'll (obviously) need to change the details for the roundcube user to the user for your database and set "new_password" to a, well, new password :) The above should be done after the MySQL table set up as detailed in the INSTALL file. Once the password "degrade" is done, roundcube should connect without problems. I hope this info helps stop someone else spending a couple of hours trying to figure out the problem! Anyway, great work on the application guys.. kicks squirrelmail in the balls for look and feel :) Cheers, Darren. -- Ubuntu (Noun): I can't figure out how to configure Slackware.

2 1

Locale setting
by Darren Austin 22 Dec '05

22 Dec '05

Hi, I think I may have found a bug in the setting of the default locale for new users, but i'm not sure if it's a bug or has been done intentually for some reason :) In program/include/main.inc, line 84 there is: $_SESSION['user_lang'] = substr($CONFIG['locale_string'], 0, 2); This prevents the setting of locales which have more than 2 letters in their name (eg, en_GB). I have changed this line to: $_SESSION['user_lang'] = $CONFIG['locale_string']; in my version and it seems to be working without issue. Was there any specific reason that a sub-string of the entire locale was being set? If not, it might be worth making the above change in the next version :) Cheers, Darren. -- Ubuntu (Noun): I can't figure out how to configure Slackware.

1 0

messages table
by Lic. Martin Marques 22 Dec '05

22 Dec '05

What does the messages table exactly store? I'm looking at it's contents and it looks like it puts there good part of the mail headers, plus some other information. -- 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

5 8

Just few ideas
by nicolas.deblais 21 Dec '05

21 Dec '05

Hi all! I did not find any informations about this on the documentation I read on the site, so there is some things which will be nice to be included in RoundCube: - some mass selection links. For example: All | None | Read | Unread | ..., - some buttons which allow us to change the status of several mails in one click (as Mark as read etc.). In ohter words, these ideas are very common things, but actually I cannot switch to RoundCube from Squirrelmail because of some points like this. And is it possible to reload the folder list when mails are moved from a folder to another one? These questions are probably not very important, or are already on the roadmap. Thanks, Nicolas Deblais PS: I am French, so please consider my english leniently!

3 3

Strange problem
by Joshua Bugeja 21 Dec '05

21 Dec '05

Hi all, I'm experiencing a strange problem with attachments. From the computer where the web/mail server resides I can add as many attachments as I want. >From any other computer I can only add one attachment. On the next one I get an "Access is denied" error in line 1502, char 7. I am using Windows XP, HmailServer 1.42 (latest beta) and roundcube cvs-20051216. Any possible solutions? Regards, Joshua Bugeja

1 0

Feature Request
by Craig Whitmore 20 Dec '05

20 Dec '05

When viewing the "Sent Items" it shows the Person your've send it to rather than the From Address (which is always yourself) Thanks Craig

1 0

Bug in Identity Editor
by Craig Whitmore 20 Dec '05

20 Dec '05

If you have & or ! (their might be others) in a Signature it will not save. Seems like it is not quoting it correctly when putting it into the database. Thanks Craig

1 0

db.inc.php
by Martin Marques 20 Dec '05

20 Dec '05

I found some lines in this file. Particularly the ones that give information on the table names and sequence names in the case of PostgreSQL. Are they really necesary? Shouldn't we use the default table names that are in the SQL/* files? And also, does RC use the PG sequences explicitly? -- 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

3 3

Hit a BUG
by Martin Marques 19 Dec '05

19 Dec '05

Hi all, just hit a BUG. I'm trying to track it down, but so far I'm still looking at it. The error comes in the DB: Dec 19 17:37:54 mail postgres[12376]: [6-1] ERROR: la columna "body" es de tipo text pero la expresiÃ³n es de tipo boolean Dec 19 17:37:54 mail postgres[12376]: [6-2] HINT: NecesitarÃ¡ reescribir la expresiÃ³n o aplicarle una conversiÃ³n de tipo. Sorry about having the error in spanish, but that's how the server is configured. Basically it says that it can't put a boolean value in the text column "body". I got to program/steps/mail/func.inc at line 1204 the variable $msg_source gets there with a value of false. Will keep looking, but I wanted to report it. -- 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

1 0

Bugtraq posting....
by Chris Largret 19 Dec '05

19 Dec '05

This full-path disclosure showed up on BugTraq a couple hours ago. Just in case you missed it, you can find a copy here: http://www.securityfocus.com/archive/1/419706/30/0/threaded -- Chris Largret <http://daga.dyndns.org>

4 4

Error "constraint violation" ....
by Christian Ista 19 Dec '05

19 Dec '05

Hello, This morning, I'm trying to access my webmail and surprise after connexion .... I have plenty off this error : DB Error in /home/cista/www/webmail/program/include/rcube_db.inc (283): DB Error: constraint violation Query: INSERT INTO messages (user_id, del, cache_key, idx, uid, subject, `from`, `to`, cc, date, size, headers) VALUES ('2', 0, 'INBOX.msg', '875', '2740', '', NULL, 'ml(a)cista.be', '', FROM_UNIXTIME(1134846156), '1378', 'O:14:\"iilbasicheader\":23:{s:2:\"id\";s:3:\"875\";s:3:\"uid\";s:4:\"2740\";s:7:\"subject\";s:0:\"\";s:4:\"from\";N;s:2:\"to\";s:11:\"ml(a)cista.be\";s:2:\"cc\";s:0:\"\";s:7:\"replyto\";s:0:\"\";s:11:\"in_reply_to\";s:0:\"\";s:4:\"date\";N;s:9:\"messageID\";s:7:\"mid:875\";s:4:\"size\";s:4:\"1378\";s:8:\"encoding\";s:0:\"\";s:5:\"ctype\";s:0:\"\";s:5:\"flags\";s:0:\"\";s:9:\"timestamp\";d:1134846156;s:1:\"f\";N;s:4:\"seen\";b:0;s:7:\"deleted\";b:0;s:6:\"recent\";b:0;s:8:\"answered\";b:0;s:4:\"junk\";N;s:12:\"internaldate\";s:20:\"17-Dec-2005 21:02:36\";s:8:\"is_reply\";N;}') [nativecode=1048 ** Column 'from' cannot be null] javascript:handleSend(); Envoyer Thanks,

2 1

Error on Login: Field 'preferences' doesn't have a default value
by Roland Müller 18 Dec '05

18 Dec '05

Hello, I am getting this query error on login: *DB Error in d:\webserver\roundcube\program\include\rcube_db.inc (283):* DB Error: unknown error Query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'Roland', 'xmail.cc', '', 'de') [nativecode=1364 ** Field 'preferences' doesn't have a default value] *PHP Error in d:\webserver\roundcube\program\include\main.inc (448):* Failed to create new user I hope you can help me on this. Thanks in advance, Roland

1 1

Fresh installation on Windows: Corrupted HTML
by Roland Müller 17 Dec '05

17 Dec '05

Hello, I have installed RoundCube on Windows with MySQL 5.0 and PHP 5.1.1. Everything seems to be configured correctly. When I point my browser to the roundcube address, I am getting corrupted HTML. The HTML-source starts with: #login-form { margin-left: auto; margin-right: auto; margin-top: 50px; width: 350px; } .. As you can see, the <html>, <head> and some other tags are missing, so that the page cannot be rendered by any browser. After that style-definition, everything seems to be correct. Does anyone have an idea what's wrong and how I can fix this? Thank you in advance, Roland

1 0

Spam Assassin & public folders
by Nathan Monk 17 Dec '05

17 Dec '05

Hi all Two ideas that might find some traction. A button to make message as spam (cound invoke a the sa-learn command) and the second is a question is there a way to have a public folder also displayed? I have an IMAP Spam folder that users drag spam messages into. It would be grat to have this listed as well. Great software Nathan

1 0

webmail
by Andrew Croft 17 Dec '05

17 Dec '05

Hello, I make everything like on docs, and now my server show me this message: Fatal error: Call to undefined function preg_replace() in /var/www/localhost/htdocs/westernlux.com/program/include/main.inc on line 37 What is can be wrong? Thanks andrew

4 3

Fwd: Page Down, Page Up don't work
by Craig Webster 17 Dec '05

17 Dec '05

I think this one was meant for the list. Begin forwarded message: > From: Carey Drake <carey.drake(a)gmail.com> > Date: 17 December 2005 02:36:44 GMT > To: Craig Webster <craig(a)xeriom.net> > Subject: Re: [RoundCube Dev] Page Down, Page Up don't work > > On 12/16/05, Craig Webster <craig(a)xeriom.net> wrote: > On 16 Dec 2005, at 17:48, Thomas Bruederli wrote: > > This is because it's not a window or a frame but a DIV that > > scrolls. It depends on the browser you're using if it supports > > scrolling by keyboard and mouse scroll wheel. > > Can we perhaps capture these events with onClick and onKeypress > events? I'll have a go at doing this tomorrow if no one fancies a > try tonight. > > I had similar problems with Firefox 1.0.x, but FF 1.5 appears to > fix this. > > C. > Yours, Craig -- Craig Webster | t: +44 (0)131 516 8595 | e: craig(a)xeriom.net Xeriom.NET | f: +44 (0)709 287 1902 | w: http://xeriom.net

1 1

Page Down, Page Up don't work
by Martin Marques 16 Dec '05

16 Dec '05

Is something wrong with the message body box. When I select a message to see I can't scroll up or down with the page up and page down keys (arrows don't work else). I have to use the mouse scroll. Is this normal? 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

4 4

trash can and messages count not updating on delete
by Shaun Lloyd 16 Dec '05

16 Dec '05

l deleted contents on inbox/sent folder then deleted trash folder. However the trash (count) still showed a number and the messages count top right still showed a count as well.

1 0

Major updates - testing required
by Thomas Bruederli 16 Dec '05

16 Dec '05

Hi everybody After two days of intensive coding (now my girlfriend is offended) I finally rebuilt the caching mechanism which caused many problems and performance issues. Therefore a new database table (messages) was created. There also have been minor changes to the database so please check the SQL scripts. Together with the new caching process, server side sorting was also implemented. When showing the message list, only one page is retrieved from the server and cached.The message cache is complete, after every page has been loaded once. After that, RC attempts just to synchronize the changes. Even if the cache is not complete the loading time should decrease since there's only the message index transmitted and already cached headers will not be reloaded. For further development I will try to start a child process to fetch all message headers in the background but not making the interface wait for it. The new caching implementation is not tested well and that's why I would like the experienced RoundCube administrators and developers to try out the latest CVS. Because the public CVS repository updates several hours or days later, I added a snapshot here: http://prdownloads.sourceforge.net/roundcubemail/roundcubemail-cvs-20051203… I also reworked the database class and tested RoundCube with MySQL, SQLite and Postgres. All initial SQL scripts have been updated and RC should now work correctly with Postgres. Probably there could be some optimization with Postgres but I'm not very familiar with it. For all Postgres users out there, please test RoundCube and don't hesitate to post bugs or suggestions here. Last but not least, I have included the patch for signatures (thanks Craig) and added a drop-down with a charset selection when composing a message. I know that there are still some issues with character encoding especially when getting things over XMLHTTP. Well, that's it for the moment. Next I'll take care of the message searching functionality and after that I think we're ready for an official Beta release. Thanks for your patience! Thomas P.S. The MDB2 implementation is currently broken and the library is not included in the package.

21 42

Patch for default from_domain (via server variable)
by Shane R. Spencer 16 Dec '05

16 Dec '05

My users unfortunately would be sending email as username@localhost for a good 10 years before they read my email saying "Set up your identity so you don't look like an idiot". Either way I developed a small patch that creates the global config variable "from_domain" and is set to the servers variable MAILDOMAIN as in this example: <VirtualHost *> .. SetEnv MAILDOMAIN mydomain.com .. </VirtualHost> this modifies only the email portion of the identity creation functions, if no MAILDOMAIN it will revert to the default behaviour. Is this just a fixup in what would be a large patchset for better vhost setups? hopefully.

3 2

Fwd: Icons
by Craig Webster 16 Dec '05

16 Dec '05

I think this was meant for the list :) Begin forwarded message: > From: Wojtek <subs(a)donkoyote.net> > Date: 15 December 2005 21:00:14 GMT > To: Craig Webster <craig(a)xeriom.net> > Subject: Re: Icons > > On 2005-12-15 20:59, Craig Webster wrote: >> On 15 Dec 2005, at 19:43, Stephen wrote: >>> That's a good suggestion too. I can see it becoming annoying >>> until the user gains the muscle memory to click the send icon. >>> I'm sure it would be far less annoying than clicking the back >>> arrow and losing the message though! >> >> Maybe we save it automatically as a draft and have a notice appear >> in the info panel telling the user that; we can avoid the popup >> completely while still saving the message. >> > Changing places for icons, and modifying send icon to something > more "send" looking, connected with a message like Craig proposed, > would be a good start. Another good thing could be placing a button > for saving composed message as draft. > > What do you think Thomas ? > > > regards > -- > Wojtek Yours, Craig -- Craig Webster | t: +44 (0)131 516 8595 | e: craig(a)xeriom.net Xeriom.NET | f: +44 (0)709 287 1902 | w: http://xeriom.net

3 3

Re: [PATCH-CVS 20051212] rcube_imap.inc: fixes fatal error on line 483
by Nicolas Zagulajew 16 Dec '05

16 Dec '05

Hi Well I finaly did the update correctly, had this error, patched as you said and I gives another error when reading messages: Parse error: parse error, unexpected T_OBJECT_OPERATOR in /home/www/roundcubemail/program/include/rcube_imap.inc on line 483 And I can't read any message.. I tried to correct, but I'm dreadful in php scripts. Nicolas -----Message d'origine----- De : Josh King [mailto:josh@dotmil.org] Envoyé : mardi 13 décembre 2005 06:57 À : dev(a)lists.roundcube.net Objet : [PATCH-CVS 20051212] rcube_imap.inc: fixes fatal error on line 483 Hi everyone, First off let me just say that I am *amazed* and very excited to have an app such as RoundCube available. My congrats to the developers! I was having an issue though. I'm running the latest CVS from tonight (12 Dec 2005) on Debian Sarge, Courier-IMAP 3.0.8, Postfix 2.1.5, Procmail 3.22, Apache 2.0.54, PHP 4.3.10, and MySQL 4.0.24 on a dedicated server. Everything worked beautifully except for one intermittant problem. The error I received was this: "Fatal error: Call to undefined function: get_message_cache_index() in /var/www/mail/program/include/rcube_imap.inc on line 483" The error came mainly on deep subdirs when trying to open a message, but occasionally happened within the Inbox as well. I have found a fix that works for me: Original: // cache is OK if ($cache_status>0) { $a_index = get_message_cache_index($cache_key, FALSE, $this->sort_field); return array_values($a_index); } Fix: // cache is OK if ($cache_status>0) { $a_index = this->get_message_cache_index($cache_key, FALSE, $this->sort_field); return array_values($a_index); } I'm not sure yet how you usually accept patches or fixes, so please let me know if there is a format you prefer. I attached one in diff -uNr formatting, and should be applied with -p1 from toplevel directory. I make no guarantees on the quality of this though, as I have only tested on one server. FWIW, is there somewhere I can read up on your procedures for submitting fixes? Thanks again! Josh King -- http://dotmiltech.com http://debianhomepage.org http://debcentral.org

2 2

RC with PHP5
by Martin Marques 16 Dec '05

16 Dec '05

I'm having lot's of problems witha server migration I just did which has PHP5 (the new server, the old one used PHP4) and Horde+IMP (which as I read, will not support PHP5 in older versions). The question is, is RC capable of working with PHP5 (I guess I will already be trying it when I get a responce, but wanted some opinions about the configuration). -- 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

3 3

Icons
by Wojtek 15 Dec '05

15 Dec '05

Hi I've noticed, that users who don't know roundcube yet, after composing email click on an arrow icon. Maybe it would be a good idea to change or put "send" icon on the "first place" ? regards -- Wojtek

4 5

PostgreSQL + Encoding
by Christian Kastner 15 Dec '05

15 Dec '05

Hello, I recently received an e-mail containing German umlauts (ä,ö,ü), which produced the following error when loading the message: DB Error in /var/www/webmail/program/include/rcube_db.inc (283): DB Error: unknown error Query: <snip> [nativecode=ERROR: invalid byte sequence for encoding "UNICODE": 0xfc7220] Apparently, the error is connected to the message's original encoding, which is: Content-Type: text/plain; charset="ISO-8859-1" I'm running Roundcube on Apache 2.0 with PostgreSQL 7.4 as a backend. I have not tested this error with the 8.0/8.1 releases yet. Any ideas?

3 2

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev