Dev

dev@lists.roundcube.net

4296 discussions

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

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