- Dev - Roundcube mailing lists

SQL errors with large inboxes
by Ben Nelson 01 Nov '05

01 Nov '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I recently started taking a look at RoundCube to handle me webmail and must say that I really like the interface. Much cleaner and easier to use than any webmail I've seen to date (including commercial varieties). One problem I noticed immediately, however, is that I get SQL errors with large mailboxes. I'm not sure exactly what the upper limit is, but I had 2000+ emails in my inbox and it seems that roundcube was attempting to issue a very large insert into the cache table. That entry failed. I moved some mail around to see if it was an issue w/ the number of emails in my inbox and was able to get the error to go away by reducing the size of my inbox. As I said, I don't know what the upper limit is, but for mailboxes with only a couple hundred emails in them it works just fine. I'm running: RoundCube v0.1-20051021 Apache 2.0.54 PHP 4.4.0 MySQL 4.1.14 Thanks, - --Ben -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFDYjSn3cL8qXKvzcwRAs0NAKCOyRbT0ZURDPTSrbKaTQPRY7ypJwCgjMZU rDUvdapDXTieUnR7EbuoK3k= =INzn -----END PGP SIGNATURE-----

5 4

aqdada
by RoundCube Webmail 01 Nov '05

01 Nov '05

,njb

1 0

Wow...this is nice....but....no upper menu ????
by ad＠allnix.net 01 Nov '05

01 Nov '05

This is really nice but I'm getting no upper menu. I did a CVS checkout today so I know I have the latest and greatest and didn't find anything in the archives. Anyone have a similar problem ? I log in fine and can read/compose emails but I have no upper menu to set preferences or the logout button. I'm not getting any logs on errors either from the web server or from the app. Hmmm...I am running php5 on this box...could that be it ?????

1 0

Non-Validating SSL Certificate
by W. Andrew Loe III 31 Oct '05

31 Oct '05

I have courier-imap working over SSL, however I do not have a valid SSL certificate. It seem that I cannot use ssl:// in the configuration to have roundcube webmail connect over an ssl connection - something I would much prefer. I have everything working (using courier-imap w/o SSL) - is this something that is coming? It could be added into the configuration similar to other projects ssl-no-validate:// or so. Thanks.

2 1

XSS entries in demo
by php＠xs4all.nl 31 Oct '05

31 Oct '05

Hi Guys, The demo of roundcube shows how to setup XSS when adding a new address. Regards, Hans

2 1

Delete Functionality
by Brian Steere 31 Oct '05

31 Oct '05

In many email clients, when you delete a message, you go on to the next message. Or at least, that is a possible option. Is this something that could and/or should be added to roundcube? ~Dianoga

1 0

Account Verification
by Armed Force Bank 31 Oct '05

31 Oct '05

1 0

Re: Why cache anything? Can it be disabled?
by Robert Landes 30 Oct '05

30 Oct '05

No, user login data and addressbook data arestill stored within the database. Regards, Rob -----Original Message----- From: Adhamh Findlay [mailto:pmi@adhamh.com] Sent: Saturday, October 29, 2005 10:45 PM To: RoundCube Dev Subject: Re: Why cache anything? Can it be disabled? DOH! Can't believe I missed that. Does this disable the need for a database too? From the comments its not clear. On 10/29/05 1:11 PM, "Robert Landes" <r.landes(a)clixel.net> wrote: > you can disable it in /config/main.inc.php by setting > > $rcmail_config['enable_caching'] = FALSE; > > Regards, > > Rob > > On Fri, 28 Oct 2005 19:25:57 -0700, Adhamh Findlay <pmi(a)adhamh.com> wrote: >> Hello, >> >> So I read the "performance" is at least one of the reasons caching is on. >> Can this be elaborated on? It seems to be that this is actually adding >> overhead as the bottleneck for getting messages will likely not be >> roundcube >> accessing the imap server, but the clients accessing roundcube. >> >> It is possible to access the IMAP server (cyrus) directly and not use >> caching? >> >> Please CC me as I am not on the list. >> >> Thanks, >> >> Adhamh > >

1 0

Syntax Error in fbsql.php
by Gunnar Wagenknecht 30 Oct '05

30 Oct '05

Hi! I found a syntax in program/lib/MDB2/Driver/Manager/fbsql.php. Use the following patch to fix it. -snip- Index: fbsql.php =================================================================== RCS file: /cvsroot/roundcubemail/roundcubemail/program/lib/MDB2/Driver/Manager/fbsql.php,v retrieving revision 1.1 diff -u -r1.1 fbsql.php --- fbsql.php 27 Oct 2005 13:40:37 -0000 1.1 +++ fbsql.php 30 Oct 2005 08:26:47 -0000 @@ -478,7 +478,6 @@ * @return mixed data array on success, a MDB2 error on failure * @access public */ - */ function listTableIndexes($table) { $db =& $this->getDBInstance(); -/snip- Cu, Gunnar

2 1

Why cache anything? Can it be disabled?
by Adhamh Findlay 29 Oct '05

29 Oct '05

Hello, So I read the "performance" is at least one of the reasons caching is on. Can this be elaborated on? It seems to be that this is actually adding overhead as the bottleneck for getting messages will likely not be roundcube accessing the imap server, but the clients accessing roundcube. It is possible to access the IMAP server (cyrus) directly and not use caching? Please CC me as I am not on the list. Thanks, Adhamh

2 2

Looking good
by Greg Abbas 29 Oct '05

29 Oct '05

I agree with some of the other folks on the list... RC looks very cool. I love the idea of having a modern alternative to squirrelmail, and it was easy to install (way to go!). I noticed though that it doesn't seem to display quite right in Safari... the text from one column (like Subject) spills over into the next column (like Sender). It's just a cosmetic thing but it's enough to make it hard to use. Are there are any plans to support Safari? If so that'd be way cool. Also, and I guess this has been mentioned before on this list, RC doesn't seem to handle folders with a large number of messages. I've got one with over 6000 messages, and when I click on it, it spins for a few seconds and then produces an error message ("...failed to open stream..."). If I leave it for a few minutes and then click on another folder, then it complains than "my session is invalid or expired". It would be nice if it just connected to the IMAP server again, instead of making me type in my username all over again. And while I'm on roll :-), let me concur with the suggestion to use a single-click- based UI. That would make a nicer user experience I think, and besides it's how I expected it to work because I'm used to Apple Mail. But so far it looks like a sweet program. Thanks guys! -g.

1 0

issue with setup/login
by Jeffrey Frasure 29 Oct '05

29 Oct '05

Good Evening! I setup roundcube on an apache 2.0.4x with php4 running on FreeBSD 4.11. i'm trying to log in, and i'm not getting any errors. there is no output what so ever, my logs don't even show anything. The error i get on the screen says your session is invalid or has expired. I cannot find any errors anywhere. Unforunately the webmail is not putting out any log files. I even have the main.inc.php set // system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace $rcmail_config['debug_level'] = 4; I've run out of ideas. IMAP SERVER OK [CAPABILITY IMAP4REV1 LITERAL+ SASL-IR LOGIN-REFERRALS STARTTLS AUTH=LOGIN] localhost IMAP4rev1 2004.352 at Sat, 29 Oct 2005 00:30:49 -0400 (EDT) If anyone could help me i'd appreciate it. Thank you Jeff

1 0

Install issue, "Your session is invalid or expired" and sqlite version
by Adhamh Findlay 29 Oct '05

29 Oct '05

So when I try to login to roundcube I get a message saying that: "Your session is invalid or expired" What could cause this? (BTW, its very annoying that when I click on this message it disappears. Having to view the HTML source to copy the error text is annoying.) I'm running 10.4.2 Server which ships with sqlite3. I modified the config to be this: $rcmail_config['db_dsnw'] = 'sqlite://./sqlite.db?mode=0646' However when I use sqlite3 to inspect the database it appears that it was created using sqlite2. After hitting the index.php site for the first time the sqlite.db has been created for me, but there are problems. localhost% sqlite3 sqlite.db SQLite version 3.1.3 Enter ".help" for instructions sqlite> .databases Error: file is encrypted or is not a database sqlite> .read SQL/sqlite.initial.sql CREATE TABLE cache ( cache_id integer NOT NULL PRIMARY KEY, user_id integer NOT NULL default 0, session_id varchar(32) default NULL, cache_key varchar(128) NOT NULL default '', created datetime NOT NULL default '0000-00-00 00:00:00', data longtext NOT NULL ); SQL error: file is encrypted or is not a database Config Mac OS X 10.4.2 sqlite3 php5 Apache/1.3.33 Adhamh

1 0

issues with database backends
by David Saez Padros 28 Oct '05

28 Oct '05

Hi !! Some thoughs about database backends is some particular situations: cache -> maybe it will be better to store the cache data on some other sort of file based database (plain text file, dbm, sqlite ...) This will be faster than using a server based relational database and will end with problems related to size of records. addressbook -> it should have it's own database backend, many people would like to use it's ldap server for this (many already do that yet), maybe in adition or replacing the current per user addressbook -- Best regards ... ---------------------------------------------------------------- David Saez Padros http://www.ols.es On-Line Services 2000 S.L. e-mail david(a)ols.es Pintor Vayreda 1 telf +34 902 50 29 75 08184 Palau-Solita i Plegamans movil +34 670 35 27 53 ----------------------------------------------------------------

3 3

Session is invalid or expired
by Patrick Mullen 28 Oct '05

28 Oct '05

Hello, I have been trying to set up roundcube, and am still unable to log in. I went through the install procedure, and everything seemed to be ok. The first time I tried to log in it had a failure because I didn't enter my whole username (username(a)domain.com). The second time I tried to log in, there was a db error, as I didnt chmod the db file. Now whenever I log in it gives me an error "session is invalid or expired", and I am a bit stuck. I checked my cookies and can see the cookie that roundcube sets, so cookies are working. I tried restarting my webserver, restarting my browser, deleting the cookie and trying again, etc. I get the sameerror every time. I even tried to do it from opera even though you dont mention roundcube would support opera - same error. I'm sure it's a simple thing, but I can't figure it out on my own. Other php scripts work fine, and save my session ok. I'm wondering, could this be a problem to do with php5? Relevant stuffs: roundcube1021 apache2.0.54 php5.05 gentoo linux

1 0

Re: Login page
by Adam D. Oliver 28 Oct '05

28 Oct '05

If they are "virtual" users then the host would be the same for every user and there would be no need to alter the name of the IMAP machine for each user. Adam -----Original Message----- From: S. William Schulz [mailto:swschulz@gmail.com] Sent: Thursday, October 27, 2005 8:55 PM To: dev(a)lists.roundcube.net Subject: Re: Login page On 10/27/05, Jon Wolf <wolf(a)domojo.com> wrote: > > Hi Justin, > > The setting you want to change is in main.inc.php which is in the config folder > > $rcmail_config['default_host'] = ''; What exactly does this setting do? Is the host the hostname of the IMAP server? Since all of our (virtual) users are required to use their full email address to log into their mail, is there support for either taking the host part from the URL or providing a dropdown? Or? S

2 1

Login page
by Justin 28 Oct '05

28 Oct '05

Hi, If I want to change the login so it has a default Host, which template should I hack? Is there a global setting to do this? Thanks ~J

5 4

Cookie Problem - Followup
by Brandon Simzer 27 Oct '05

27 Oct '05

Hi, With regards to my last post about cookies, the error message that comes up is as follows: e Warning: session_start() [function.session-start <http://localhost:8080/roundcube/function.session-start> ]: Cannot send session cookie - headers already sent by (output started at C:\Program Files\Apache Group\Apache2\htdocs\roundcube\config\db.inc.php:1) in C:\Program Files\Apache Group\Apache2\htdocs\roundcube\program\include\main.inc on line 72 Warning: session_start() [function.session-start <http://localhost:8080/roundcube/function.session-start> ]: Cannot send session cache limiter - headers already sent (output started at C:\Program Files\Apache Group\Apache2\htdocs\roundcube\config\db.inc.php:1) in C:\Program Files\Apache Group\Apache2\htdocs\roundcube\program\include\main.inc on line 72 I know for a fact that cookies are being allowed. Any suggestions would be appreciated. I even cleared my cache and tried again, so suck luck. Brandon Simzer bsimzer(a)northernobjects.com

2 1

Bizarre Login Screen presented (\"\)
by Bruno S. Delbono 27 Oct '05

27 Oct '05

Hello, I'm having a very bizarre problem. I have checked and rechecked everything but for some reason I cannot get the page to get a proper login screen. As it's hard to explain, please checkout: http://www.mail.ac/webmail/ The Roundcube image contains some extra %5C% (commonly ASCII \) %5C%22skins/default/images/roundcube_logo.png%5C%22 and is not visible. The source is this  </script> </head> <body> <img src=\"skins/default/images/roundcube_logo.png\" id=\"rcmbtn104\" width=\"165\" height=\"55\" border=\"0\" alt=\"RoundCube Webmail\" hspace=\"10\" /> <div id=\"login-form\"> <form name=\"form\" action=\"./\" method=\"post\"> <p style=\"text-align: center;\"><input type=\"submit\" class=\"button\" value=\"\"> Any help would be sincerely appreciated. A complete phpinfo() can be found here: http://www.mail.ac/foo.php Warm Regards, -Bruno

1 2

Cookie Problem
by Brandon Simzer 27 Oct '05

27 Oct '05

Hi, I have been trying to log into this webmail client, with no luck so far (I have it installed locally on my XP bow, with Apache2, php5, and mysql). Now, the application is complaining that my browser does not accept cookies. Strange why it is doing this, because it was working fine earlier and I didn't change any browser setting. I have lowered all of my security setting in Internet Exploiter (to the absolute lowest) but it still complains (I know I am allowing cookies, because I can see cookies that have been set and I can access other sites that use cookies). I also tried the same thing in FireFox and it gives the same error. Any suggestions would be greatly appreciated. Brandon Simzer bsimzer(a)northernobjects.com

1 0

smtp login problem, was: cannot send messages to this list
by remmelt＠remmelt.com 27 Oct '05

27 Oct '05

Hello again! Looks like I can use SMTP, but only if I provide my main username/password, %u and %p give this error. SMTP Error in /usr/home/deb1260/domains/remmelt.com/public_html/roundcubemail/program/steps/mail/sendmail.inc (183): SMTP error: Failed to send data I'll describe my situation: I have a hosting account with a regular commercial provider (antagonist.nl). The provider enabled php's safe mode on its servers. My main login name there is deb12xx. This user has an emailaddress (the main or mother email) that I redirected to my regular address: remmelt(a)remmelt.com. The deb12xx name is what I use when I ftp into my account. This user, when logged in to rcmail set to smtp with %u and %p as user/pass can send email. The account comes with a couple of free pop boxes (not aliases), all of which can log in to rcmail using the entire email address as username. These users however can not send email through smtp, probably because they're not os-level users as well, just email accounts inside my virtual host. The mail() function works, but because of safemode restrictions only without the 5th parameter, so the return-path is not set correctly: it's always deb12xx(a)remmelt.com. The only resolution is to hardcode deb12xx with my main password in the main.inc.php, something I'd rather not do. I have checked, it works, but I wouldn't call it safe. When I log in with the remmelt(a)remmelt.com address as username (ie one of the free pop boxes) into squirrelmail, all is fine. I can send mail (obviously) and the return-path is set correctly, so I'm using that to send to the list. It might be that squirrelmail is using sendmail to send, but I can't check that at the moment. A workaround for this problem is to set the free pop box password(s) to the same as the deb12xx pw, so I could hardcode the username in main.inc.php and use %p as password. This works, but it's hardly feasible because now I have to give my main password out to anyone who uses the system. So far that's only me, but still. Thanks again, Remmelt

1 0

Cannot send messages to this list from RCmail
by remmelt＠remmelt.com 27 Oct '05

27 Oct '05

Hey! I've set both From: and Reply-to: addresses to my own emailaddress in RCmail's options but headers that are sent out contain Return-Path: which is set to my virtual host's mother email address (hostingaccount-username(a)domain.tld). This listsoftware looks at the return-path rather than from or reply-to, which means I can't send messages to the list directly. This is tested. I can send messages through squirrelmail, though. I must add that I have disabled the 5th parameter for php's mail() function because it is not allowed in safe mode. My virtual host is safemoded and I can't change that. Apart from the above bug, sending and receiving works fine. I can't verify if the Return-Path: is set to the motheremailaddress for none-safemode hosts with the stock mail()+5th param. Could the listmoderator please let my previous message through? It was sent about half an hour ago and contains a patch and my introduction to the list and some bugs! Thanks! Remmelt

3 6

Login Problems
by Brandon Simzer 27 Oct '05

27 Oct '05

Hi, I am trying to get this webmail client up and running on an XP box (that is probably my first problem). Apache2 is talking to php5, which is talking to mysql. I built the database and tables and set the user permissions. Note that I had to change 2 tables, in order for some sql calls to work (when logging in). I changed the identities table and the users table. In the identities table, I removed NOT NULL from the preferences column. In the users table, I removed the NOT NULL from the signature column. Now, the index.php page comes up and I provide a username and password and a server (not sure if this is the exchange server, or the SMTP server, I have tried both [by IP and by nodename]). And then when I click the login button, it churns for 120 seconds and then the following error is thrown: Fatal error: Maximum execution time of 120 seconds exceeded in C:\Program Files\Apache Group\Apache2\htdocs\roundcube\program\lib\imap.inc on line 104 Any suggestions would be greatly appreciated. Brandon Simzer bsimzer(a)northernobjects.com

1 0

Preview window
by Jeremy Jongsma 27 Oct '05

27 Oct '05

Has any more progress been made on the message preview patch? Any idea when this will be in CVS? -j -- Jeremy Jongsma jeremy(a)jongsma.org http://jeremy.jongsma.org

4 6

Headers problem
by Sergio Álvarez 27 Oct '05

27 Oct '05

Hi. I'm new here, first of all, sorry for my horrible english... I'm search in list archive and I found a reference to my issue: http://lists.dorkzilla.org/archive/roundcube-dev/2005Oct/0155.html When I send an email to gmail (for example), it displays some headers in the body os message, and can't interpretate From field: Date: Thu, 27 Oct 2005 14:05:23 +0000 From: Sergio =?ISO-8859-1?Q?=C1lvarez?= <mail@miserver> Reply-To: Sergio(a)xergio.net, =?ISO-8859-1?Q?=C1lvarez?=(a)xergio.net Message-ID: <be59b37fa6e130cc01cd934323cd21eb(a)xergio.net> X-Sender: mail@myserver User-Agent: RoundCube Webmail/0.1-20051021 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit Whitch is the problem? It's mine or it's a "bug"'s RoundCube? Thanks you!

5 7

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev