HOWTO: Install Roundcube Webmail from SVN (was CVS) on FreeBSD
UPDATE3: The FreeBSD port is keeping up with this project very well, the current one is only 5 days old! I highly recommend going this route unless you’re a developer or someone who likes to get the bugs before anyone else! 
Thanks to Bernard for bringing this up.
UPDATE2: Roundcube now uses SVN (Subversion) for version control instead of CVS, I’ve updated all effected instructions.
UPDATE: Looking at the download page for Roundcube, I see that There’s also a Spanish version of Phil’s guide written by Daniel A. Rodriguez. ¡se ha traducido eso es lejano hacia fuera, yo! You can find the link here , I hope that helps. I would like to see more translations of HOWTOs in general, I wish there was a good Firefox plugin to translate pages (well) on the fly.
In all my years of running a mailserver at home, I’ve used quite a few different webmail apps to find the balance of functionality and style that I’ve been craving. This includes Horde/IMP, Squirrelmail, IlohaMail, OpenExchange, Hula (as well as a couple of others) but all were either lacking functionality, style, or readiness (Hula I’m looking at you). A few months ago I stubled across Roundcubemail, a webmail app which aims to provide an application-like user interface, which it does. When you can drag and drop mail to a folder, you know you’re dealing with something pretty new, and AJAX related. The smoothness and speed of refreshes when you switch folders (along with the ‘spinner’ at the top of the screen to give you needed feedback) is just a breath of fresh air.
Try out the demo to see what all the fuss is about if you’re looking for a LAMP based IMAP webmail solution. Time will tell, but this project’s out of the gate showing makes me think it’s going to be a great app. Let’s hope they keep the configuration and options to a sane amount, unlike other webmail apps (Horde/IMP, I’m looking at you), so they can keep their clean, non-bloated feel. Since I’ve installed it I’ve moved on to nightly rebuilds from CVS, so I thought I’d document the steps needed to run the latest CVS version of Roundcubemail on FreeBSD. While there is a FreeBSD port in the ports tree (mail/roundcube) it is far out of date, so the CVS version is recommended since there are so many changes happening day-to-day with it. Once running you should also join the dev@lists.roundcube.net mailing list to keep abreast of, and report any, bugs that need ironing out. This HOWTO assumes you have a webserver (www/apache2), a mail transport agent (mail/postfix), and an IMAP server (mail/dovecot) installed and working. I brought them up and tested them with Squirrelmail (mail/squirrelmail), since it’s almost as easy to setup and always “just works”. SO, without further babble, here’s my first (of many) HOWTOs on fak3r.com.
HOWTO: Install Roundcubemail from CVS SVN on FreeBSD
- NOTICE: This document assumes you already have a webserver running with PHP support, a mySQL database a Mail transport agent, an IMAP server and the Subversion client to check out the code.. My configuration consists of Apache2 (www/apache2), PHP 4 (lang/php-4), mySQL 4.x (database/mysql40-server), Postfix (mail/postfix) and Dovecot (mail/dovecot). Additionally this install was done on FreeBSD 6.0, but I see nothing specific that would stop the same procedure to allow Roundcubemail on 5.x, 4.x or even any Linux distribution. Feedback on this is welcome.
1) As root, change to the webroot of Apache
cd /usr/local/www/data-dist2) Login to the Sourceforge Roundcubemail CVS server (when prompted for a password, just press ENTER)
cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/roundcubemail login
2) Checkout Roundcubemail from the Sourceforge SVN server (when prompted, choose ‘p’ to accept the encrypted key permanantly)
svn checkout https://svn.roundcube.net/trunk3) Change into the roundcubemail directory
cd roundcubemail
3) Move the roundcubemail directory to your webroot, remove the ‘trunk’ directory, and then change into the roundcubemail directory
mv trunk/roundcubemail .
rm -rf trunk
cd roundcubemail4) Set permissions of the temp and logs dir so that the web user can read/write to them
chown -R www:www temp logs5) Create a database for storage of Roundcubemail data, replace $PASSWORD with the password you want the roundcube user to use to access mySQL
# mysql
> create database 'roundcubemail';
> GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost
IDENTIFIED BY '$PASSWORD';
> quit6) Import the inital Roundcubemail SQL
# mysql roundcubemail < SQL/mysql.initial.sql7) Change into the config directory
cd config 
Copy the config *php.dist files to *.php
cp db.inc.php.dist db.inc.php
cp main.inc.php.dist main.inc.php9) Modify the config files to suit your environment. In db.inc.php you only need to change the database definition line, add your password in place of $PASSWORD
$rcmail_config['db_dsnw'] = 'mysql://roundcube:PASSWORD@localhost/roundcubemail';Assuming your mailserver is running on the same physical box as the webserver, disable database caching
$rcmail_config['enable_caching'] = FALSE;define the host as localhost
$rcmail_config['default_host'] = 'localhost';define smtp as localhost
$rcmail_config['smtp_server'] = 'localhost';and increase the session lifetime from 5 to something more reasonable (optional)
$rcmail_config['session_lifetime'] = 30;Launch a web browser and point it to
http://some.url/roundcubemailThen login with a valid/existing IMAP username and password.
To debug problems just tail -f (or multitail if you’re cool like me) /var/log/maillog to see what’s happening behind the scenes. Consult the mailing lists for issues and feel free to give feedback below. Since this app is under heavy development I expect this HOWTO to change as the app does.
Tags: bsd, email, howto
Thanks for this nice HOWTO it’s great! Greetings Bastian
Thanks for the tutorial. Nice site.
No problem, thanks for the software, I love it. I’ll keep this HOWTO updated, and make changes as we go. First one will be to point out that there’s really nothing FreeBSD related…it should be full applicable to any Linux, save for the webroot path - which is different depending on what Linux distro you’ve installed Apache (or any other webserver) on. I *would* like to look into making a FreeBSD port of this though.
FreeBSD port already exists http://www.freebsd.org/cgi/ports.cgi?query=roundcube&stype=all
Yep, I saw that after I installed the RC milestone, and then moved to CVS. The thing is the port is quite old, and if you want the latest bug^H^H^H features, you want CVS. I figure I can give back more with bug reports and patches while it smooths out. Also I heard back from the RC ports maintainer, and he does plan on updating it once RC becomes more mature, so again, it looks like for now CVS is the way to go on this fantastic project.
Thanks for the web site. I will have to say there are a few more steps involved:
1) Install MySQL5 server (FreeBSD v5.4 comes with only MySQL4):
vi/usr/share/examples/cvsup/ports-supfile:
*default host=cvsup1.us.FreeBSD.org cvsup /usr/share/examples/cvsup/ports-supfile
Install PHP4 extensions:
cd /usr/ports/lang/php4-extensions
make distclean
make config (make sure to select MySQL support)
make install
2) Install Pear-DB extension — RoundCube uses this library:
cd /usr/ports/databases/pear-DB
make install
3) Install MySQL:
/usr/local/sbin/portupgrade mysql-client (if you have it currently installed)
pkg_delete -r mysql-client-4.0.26
cd /usr/ports/databases/mysql50-client
make
cd /usr/ports/databases/mysql50-server
make install
/usr/local/bin/mysql_install_db
chown -R mysql /var/db/mysql/
4) Edit the MySQL footprint (if you want to reduce the amount of memory consumed by MySQL, especially since Roundcube takes a lot of memory with the HTTP daemon)
vi /var/db/my.cnf:
[mysqld]
port = 3306
set-variable =
key_buffer=16K
set-variable =
max_allowed_packet=1M
set-variable =
thread_stack=64K
set-variable =
table_cache=4
set-variable =
sort_buffer=64K
skip-innodb
Enable MySQL to start:
vi /usr/local/etc/rc.d/mysqlserver.sh: :
${mysql_enable=”YES”}
5) Edit /usr/local/etc/php.ini:
include_path =”.:/php/includes:/usr/local/share/pear/”
error_reporting = E_ALL & ~E_NOTICE
(If you see this error message, it means that you haven’t setup the include_path correctly: DB Error in /var/www/html/roundcubemail/program/include/rcube_db.inc >>>(63):* DB Error: extension not found
6) Verify the PHP4 extensions are installed in
a) vi /usr/local/etc/php/extensions.ini:
extension=imap.so
extension=pcre.so
extension=session.so
b) pkg_info | grep php4
7) You also need to modify the Apache settings to ‘Allow Override All’ option to allow .htaccess.
GRANT USAGE ON *.* TO roundcube@localhost; GRANT USAGE ON *.* TO roundcube@’192.168.0.%’; GRANT USAGE ON *.* TO roundcube@’%.mydomain.com’; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER on roundcubedb.* TO roundcube’@'localhost’ IDENTIFIED BY ‘rcube’; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER on roundcubedb.* TO ’roundcube’@'168.0.1.%’ IDENTIFIED BY ‘rcube’; GRANT
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER on roundcubedb.* TO ’roundcube’@'%.mydomain.com’ IDENTIFIED BY ‘rcube’; create database roundcubedb; use roundcubedb; source mysql.initial.sql (this script is provided inside the SQL/ RoundCube directory) SET PASSWORD FOR roundcube@localhost = PASSWORD(’xxxx’); (set to whatever password)
Hope this helps. I hope this website updates to be more complete so other people don’t have as many issues with installing RoundCube! It’s a great client, but still needs a lot of work (especially to support multiple languages, since it currently has issues processing different character sets).
Hi, This is great! I need to know if anybody has a experience on working with Spamassasin plugin for Round cube. Since the Anti-SPAM solutions at various levels of mailing system makes this question mandatory to me. I was using squirrelmail all the time and now evaluating roundcube. The most important feature missing is that the user wide configuration changes for spam assassin. I feel this could be done only in the webmail interface. So any idea on what plugin or how to enable this function here ? Siva
Sivakumar I know for a fact this is not being addressed currently. I’m on the dev mailing list and currently work is progressing on caching, database tables and updates; all low level stuff. I used to run Squirrelmail, and had the plugin to allow users to modify their Spamassasin rules themselves, however no one really ever used them. Once I had SA trained and running Rules du jour nightly, I was confident it was doing it’s job and set the Spam thereshold to 5.0 and the SPAM thereshold to 10.0. There were never any mistakes as far as real mail counting as spam and only a few where it missed, usually by Anyway, long story short, I currently have Mailscanner -> Spamassain -> dcc -> Clamav set the same for all users and it’s been perfect. I’d suggest you either go that route, or leave Squirrelmail running alongside Roundcube and have them make SA or other changes via Squirrel. While there’s plenty that RoundCube *could* have, it’s still moving fast, but concentrating on a good base first, and I think that’s wise. Also, I’ve written an auto update script wich fetches the latest CVS for you, here: http://cryer.us/phil/code/roundcubemail
i had all the pre-require tool on my box, it took me 3minutes to install make this AMAZING webmail runs. Thanks a lot, this is a great job (and i say that for the roundcube project, and for the howto it self). Keep going guys.
is it possible to install this with lighttpd?
mercenary said: is it possible to install this with lighttpd? I’m sure it is, but I haven’t done it. I currently have Lighttpd running this blog via mod_proxy on Apache, but couldn’t you just install Lighttpd, have it running on :80 and then put the Roundcube directory under its docroot? I’ve been meaning to do this; move off of Apache and just onto Lighttpd, since I really don’t need/use any Apache specific stuff, and I can probably run a little cleaner with Light. I’ll repost here with a complete HOWTO Move from Apache -> Lighttpd once I get it done.
I’m using FreeBSD 6, mysql 5, apache 2.0.55, php 5.1, and I’m getting the following error: DB Error in /usr/local/www/forsythia/roundcube/program/include/rcube_db.inc (67): DB Error: not found Fatal error: Call to undefined method DB_Error::query() in /usr/local/www/forsythia/roundcube/program/include/rcube_db.inc on line 151 I’m using php5, I have pear-DB and php5-mysql installed. Anyone know what I’m missing? googling isn’t helping. My other PHP web apps (like squirrelmail) work fine. My php.ini includes the /usr/local/share/pear folder and here are the ports i have installed: php5-5.1.2 php5-bcmath-5.1.2 php5-bz2-5.1.2 php5-dom-5.1.2 php5-gd-5.1.2 php5-gettext-5.1.2 php5-imap-5.1.2 php5-mbstring-5.1.2 php5-mcrypt-5.1.2 php5-mhash-5.1.2 php5-mysql-5.1.2 php5-mysqli-5.1.2 php5-openssl-5.1.2 php5-pcre-5.1.2 php5-session-5.1.2 php5-simplexml-5.1.2 php5-sqlite-5.1.2 php5-xml-5.1.2 php5-zlib-5.1.2 pear-1.4.6 pear-Benchmark-1.2.4 pear-DB-1.7.6,1 pear-DB_DataObject-1.8.0 pear-DB_QueryTool-1.0.1 pear-Date-1.4.6 pear-Log-1.9.3 pear-Mail_Mime-1.3.1 pear-PHPUnit2-2.3.4 Any help would be greatly appreciated.
Okey I found my problem — I overlooked a permission db.inc.php. The ‘no method’ error threw me off so I didn’t even think it was trying to talk to my database. Doh!
Wow, that was easy. Worked on Gentoo, too. Only difference was the chown command needed to be apache:apache
what exactly was the permission you overlooked in db.inc.php? Saying you overlooked it doesn’t help if you don’t say what it was…
s said 118 days later: what exactly was the permission you overlooked in db.inc.php? Saying you overlooked it doesn’t help if you don’t say what it was… I really don’t know what he was talking about, from my doc there’s nothing to do with db.inc.php but modify the ‘connect’ line; no changes of permission on the file are required. Let me know if you’re getting an error with this and I can help further.
I was referring to sneeper. I’m still seeing DB errors and have absolutely no clue why. Followed the tutorial to a t, yet still keep getting: DB Error in /usr/local/www/roundcubemail/program/include/rcube_db.inc (104): DB Error: extension not found
s - check out the recommended setting above: 5) Edit /usr/local/etc/php.ini: include_path =”.:/php/includes:/usr/local/share/pear/” error_reporting = E_ALL & ~E_NOTICE
Yep, did that, still not making a difference. include_path = “.:/php/includes:/usr/local/lib/php:./includes:/usr/local/share/pear/”
also, fyi, when I did a portinstall pear these are the only packages that installed, I don’t know if something else is needed??: pear-1.4.6 PEAR framework for PHP pear-DB-1.7.6,1 PEAR Database Abstraction Layer
s I’m sorry, I just don’t see anything else that is missing, please post over on the new [Roundcube Forum](http://roundcubeforum.net/index.php) and we’ll see if anyone has an idea there. Also, I’m reinstalling my server with a fresh version of FreeBSD 6.0 so I can track binary security patches (Thanks to Cecil for freebsd-update and portsnap!) so I’ll see if I have the issue when installing from scratch. I had Horde/IMP on the old server, and that installs a TON of Pear apps, so perhaps I already had it.
s Check it out, it looks like you need to recompile PHP with mySQL support. A search on the forums for ‘DB Error: extension not found’ Gave me these two to look at: http://roundcubeforum.net/index.php?topic=73.0 http://roundcubeforum.net/index.php?topic=76.0 Let me know if that does/does not fix it for you.
Hi,, i have try to install Roundcubemail many times and still getting some error. i use Qmail as my MTA. every time i try to login with an email account, it just starts to open de next page that it supose to open but it never gets there, i get an error saying login failed! … any clue of what could be wrong??
HellBrO Can you list any errors in your logfiles? After you get this error do a: tail /var/log/messages and if you have it: tail /var/log/maillog and post the results for us to look at, it’s likely something small - is your mail server and IMAP server running? Can you login with any other mail clients?
Even though the FreeBSD port may be old, you can always install the port to get all of the pre-req’s and then update the actual roundcube source.
red - good call, that’s how I installed a web app I needed, even though I wanted to use the latest, svn, just like in this case.
fak3r,
Thanks for the concise guide.
I just installed roundcube (latest SVN) on my gentoo box using apache2/php5, postfix, courier-imap SSL, and postgres8 db. works flawlessly.
again, thanks for a clean and clear guide
FYI, the grant statement is slightly different for postgres:
#open the postgres cmd line to the template1 db (should exist in all postgres installs):
psql template1
#first create the user:
create user roundcube password ”
#then create the database:
create database roundcubemail
#last do the grants:
grant all privileges on database roundcubemail to roundcube;
pretty basic stuff, but it may come in handy to someone else.
Small update here, saw that in the FreeBSD ports, Roundcube has been updated to a snapshot from May of this year, which is much better. Still, since we released 0.1-Beta a few weeks back, that’d be the target I’d rather have. For those that want the quick fix, install the port like this:
While trying to install subversion on FreeBSD I get this [frowny face]
fetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/bdb/db-4.2.52.tar.gz: s
ize mismatch: expected 4073147, actual 3919271
=> Couldn’t fetch it - please try to retrieve this
=> port manually into /usr/ports/distfiles/bdb and try again.
*** Error code 1
Photar
Seems like you have a bad file from ports, delete the bdb file and start fresh like this:
cd /usr/ports/devel/subversion
rm -rf /usr/ports/distfiles/bdb*
make clean; make install clean
If that fails try:
pkg_add -r subversion
If *that* fails, please post any errors here, or feel to email me at fak3r @ fak3r . com - we can fix this
fak3r
hi guys, my prob is i can see the login page..but when i login with a valid account, i get a blank screen..when i see the log, it shows something like this:
PHP Fatal error: Call to undefined function: file_get_contents() in /var/www/html/roundcube/program/lib/utf8.class.php on line 87
any suggestions is highly appreciated!
@vnistelrooy
Do you have the permissions correct so that the webserver can read the correct files? If so, go into config.php and turn up the logging level — try 8, ten login again and take a look at what we get. Let me know.
fak3r
Use the version from the port.
The version is very complete and includes the CPanel patch. Furthermore it is regularly updated and patched.
There is no reason why you should use the svn version - unless you are developping and need to stay in sync !
Sincerly yours;
[quote comment="900"]Use the version from the port.
The version is very complete and includes the CPanel patch. Furthermore it is regularly updated and patched.[/quote]
Bernard
I am in complete agreement, I’ve used cron to update to SVN nightly for me to use on http://../roundcube-svn while I maintained http://../roundcube for user, which was done by me manually updating when a particulary stable version popped up. Now the port is following along better than I have been:
http://www.freshports.org/mail/roundcube/
The latest in the port is from 20061207 - just 5 days ago! Thank you for bringing this to my attention, I’ve made note of it on the top of this page so that others know as well that the port is the way to go. Glad this project has been so strong, and love that the port is keeping up!
f
I’ve installed RoundCube and it worked fine for one day. After that, I get a blank screen after I make my log in. Doesn’t matter which browser I use. Can anyone help me?
I liked very much…it’s a same not using it because such a thing…
Error log:
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/docmathn/public_html/email/index.php:1) in /home/docmathn/public_html/email/program/include/main.inc on line 89
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/docmathn/public_html/email/index.php:1) in /home/docmathn/public_html/email/program/include/main.inc on line 89
Warning: Cannot modify header information - headers already sent by (output started at /home/docmathn/public_html/email/index.php:1) in /home/docmathn/public_html/email/program/include/main.inc on line 97
Warning: Cannot modify header information - headers already sent by (output started at /home/docmathn/public_html/email/index.php:1) in /home/docmathn/public_html/email/program/include/rcube_shared.inc on line 132
Can you help me?
@Crazy F
What version are you running?
Is your db setup correctly? Check this one:
http://roundcubeforum.net/forum/index.php?topic=644.0
Otherwise check some other posts:
http://www.directadmin.com/forum/archive/index.php/t-10037.html
http://www.webhostingtalk.com/showthread.php?s=f3b2d5b573dd8b002a07c76e4f60d0bf&t=491087&page=2
Did you checkout this bug? I had an issue with something like this
http://roundcubeforum.net/forum/index.php?topic=644.0
If those fail, post your config/main.php.inc and php.ini file here or I would post to the RC mailing list, (I see you have a post on the forum) I’m sure someone there will have an answer. Honestly, I haven’t had to trouble shoot anything for so long, since it just works. Don’t give up, try that, and post again if you’re still having an issue.
fak3r
My version is roundcubemail-0.1beta2.
Yes I think the DB is ok…
Ok, I rebuilt from the current SVN, the latest/greatest, and I have that working too; but that beta should be functional, so I know it’s a setting you have somewhere. Let’s see, ya, if you couldn’t hit the DB you’d see something like:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Can you look at your php.ini, in mine I remember changing this line:
error_reporting = E_ALL
Outside of that, can you post your php.ini and main.config.inc? If you don’t want it public here, email it to me at fak3r at fak3r dot com and I’ll take a look. I’m still on the mailing list, but haven’t been too involved recently just due to not having the time, but I will get back into it since I’m back on the trunk.
fak3r
In my php.ini I’ve:
error_reporting = E_ALL & ~E_NOTICE
t’s almost working!!!!!!!!
Now I can log in but I can’t send msg!!!
Error log:
[05-Feb-2007 14:40:37 -0700] SMTP Error: SMTP error: Connection failed: Failed to connect socket: Connection refused
in /home/docmathn/public_html/email/program/steps/mail/sendmail.inc on line 253
I’ve tried some solutions that i’ve found in the forum but for now nothing is working…
Any sugestion?
It sounds as if you just need to tweak some settings in main.inc.php — the only thing I had to ’set’ in my setup as far as SMTP was the server’s hostname:
// use this host for sending mails.// to use SSL connection, set ssl://smtp.host.com
// if left blank, the PHP mail() function is used
$rcmail_config['smtp_server'] = ‘fak3r.com’;
This could be set as ‘localhost’ or your system’s FQDN which you could get via:
hostnameOutside of that, these should all stay the same as you see here, unless you need a login with your SMTP server:
// SMTP port (default is 25; 465 for SSL)$rcmail_config['smtp_port'] = 25;
// SMTP username (if required) if you use %u as the username RoundCube
// will use the current username for login
$rcmail_config['smtp_user'] = ”;
// SMTP password (if required) if you use %p as the password RoundCube
// will use the current user’s password for login
$rcmail_config['smtp_pass'] = ”;
// SMTP AUTH type (DIGEST-MD5, CRAM-MD5, LOGIN, PLAIN or empty to use
// best server supported one)
$rcmail_config['smtp_auth_type'] = ”;
Are you running everything on one server?
I’ve my site in a http://www.bluehost.com server.
The mail server is mail.mydomain.com.
I’ve no problem usung smtp in outlook or other aplications.
In the settings that you are talking about I’ve tried many options anda nothing works for now. I know it requires autentication and I’ve put the settings for autentica the user but don’t work.
My settings now are:
$rcmail_config['default_host'] = ‘mail.mydomain’;
$rcmail_config['default_port'] = 143;
$rcmail_config['username_domain'] = ‘mydomain’;
$rcmail_config['mail_domain'] = ‘mydomain’;
$rcmail_config['virtuser_file'] = ”;
$rcmail_config['virtuser_query'] = ”;
$rcmail_config['smtp_server'] = ‘mail.mydomain’;
// this is really my smtp server
$rcmail_config['smtp_port'] = 25;
$rcmail_config['smtp_user'] = ‘%u’;
$rcmail_config['smtp_pass'] = ‘%p’;
$rcmail_config['smtp_auth_type'] = ‘LOGIN’;
I’ve tried with the last 3 empty or a real user, but no results…
Any sugestion?
It’s WORKING!!!
I’ve changed for this:
// to use SSL connection, set ssl://smtp.host.com
// if left blank, the PHP mail() function is used
$rcmail_config['smtp_server'] = ’ssl://mail.mydomain’;
// SMTP port (default is 25; 465 for SSL)
$rcmail_config['smtp_port'] = 465;
And for now it’s working e look’s great!!!!
Thank you fak3r!!!!
http://www.DocMath.net
Great to hear Crazy F! Have fun with it, and feel free to join the mailing lists, or swing back by here if you have questions. Now all the cool kids have a roundcube/ directory, as well as a roundcube-svn/ directory so you can play with, test the new features. Currently the Preview Pane and some drag and drop features are showing up!
hi, all
just updated php5 on fbsd 6.2 and start having this error:
[28-Feb-2007 22:57:34] PHP Warning: preg_split() [function.preg-split]: Compilation failed: lookbehind assertion is not fixed length at offset 7 in /usr/local/www/roundcube/program/lib/DB/common.php on line 751
[28-Feb-2007 22:57:34] PHP Warning: Invalid argument supplied for foreach() in /usr/local/www/roundcube/program/lib/DB/common.php on line 756
[28-Feb-2007 22:57:34 -0600] DB Error: DB Error: mismatch Query: [DB Error: mismatch] in /usr/local/www/roundcube/program/include/rcube_db.inc on line 501
[28-Feb-2007 22:57:34] PHP Fatal error: Call to a member function fetchRow() on a non-object in /usr/local/www/roundcube/program/include/rcube_db.inc on line 368
I am running sqlite and not mysql.
any help, please?
thanks
I can’t log in with any user into Roundcube, I just bounce back to the same login screen without the “login failed” message.
I’m using dovecot 1.0rc24, Postfix 2.3.7 on a CentOS 4.2 Linux
I’m using sql auth on dovecot (IMAP Server) configuration, this is the dovecot-sql.conf file:
—-
driver = mysql
connect = host=localhost user=admin password=passwd dbname=manager
default_pass_scheme = PLAIN
password_query = SELECT password FROM emails WHERE account = ‘%n’ AND domain = ‘%d’ AND alias = 0
—–
I checked the database and the user is there.
The relevant configuration of dovecot (dovecot.conf) is:
—–
protocols = imap imaps pop3 pop3s # only set the services you want - the s stands for secure (ssl)
disable_plaintext_auth = no
#ssl:
ssl_disable = no
ssl_cert_file = /usr/share/ssl/s/Cert.pem
ssl_key_file = /usr/share/ssl/s/PrivateKey.pem
default_mail_env = maildir:/var/mail/%d/%n/
protocol pop3
{
pop3_uidl_format = %v.%u
}
auth default
{
mechanisms = plain login cram-md5 digest-md5
passdb sql
{
args = /usr/local/etc/dovecot-sql.conf
}
userdb static
{
args = uid=5000 gid=5000 home=/var/mail/%d/%n
}
socket listen
{
client
{
user = postfix
group = postfix
path = /var/spool/postfix/private/auth
mode = 0660
}
}
}
—–
Please I don’t understand why is not logging in, could someone help…?
Thanks in advanced….
@evs
Ican’t reproduce this, have you posted it to the Roundcube forums? Also, tell me exactly what PHP modules you have installed/enabled. Do a…
pkg_info | grep -i php
to determine the packages installed, and also go into the main php5 port and type:
make config
To get all the options. After that I can compare with what I have chosen.
@PBH
In your config file, turn the logging up, then look at the errors in /var/log/http-error.log and /var/log/maillog
cp db.inc.php.dist db.inc.php
cp main.inc.php.dist main.inc.php
saved my day, thanks a lot!
Quick question, while it had loads of promise, I see very little progress from Roundcube over the past year, and that’s a shame. Has anyone 1) seen progress in the SVN version (mine had nothing new that I could see) or 2) know of a fork of Roundcube (I’d love to see a re-interest in this client, with a new/fresh skin and some attention) or 3) a better solution altogether for a PHP/MySQL webmail app that is this light? That’s the thing, I see other UIs, but they’re tied to something like Tomcat or the like…that’s not what I want, I want a Roundcube like environment - that works 100% It’s just such a great piece of software it makes me want to get better at PHP and push it along. (note to self, I need to update the auto-RC subversion checkout script: http://www.fak3r.com/2006/05/31/roundcube-webmail-update-script/ - if there were actually changes in the code…this would pick them up! ;))
Since switching my email to a hosted service, I admittedly have not kept up with Roundcube, but the last time I played around with it (~9months back) it was pretty stagnant. However, checking it now, I see some progress, and an *AMAZING* theme for it called “MVision v2″: http://www.roundcubeforum.net/downloads.php?do=file&id=2
Wowser, that’s what I wanted, for some real web UI guys to get ahold of the client, has anyone use Roundcube recently? How is the project going? It had such a promising start.
Hello fak3r,
a very great tutorial about the roundcube. Thanks a lot for your support.
Leave your response!
commentary »
Total borrowing from the Federal Reserve
What’s wrong with this picture? Can you say debt? Good, how about recession? Notice the gray areas, those are recession periods, we’ll wait for ours to appear here. Who thought it could get this bad this quickly? Here’s the graph at the Federal Reserve for you to research. Enjoy
humor »
HOWTO: send commandline email with attachments
Are you like me, do you have scripts running on servers and you need to know what they know? If there’s output in a file you can sed/grep/awk info out of them and have them emailed to you, but if you don’t know specifically what you’re looking for you may need the entire file/log/whatever. [...]
O'RLY? »
Equal Rights for All
Here’s a great, recent News of the Weird article,”Roy Hollander filed a civil rights lawsuit against Columbia University in New York City in August, claiming that its “women’s studies” curriculum teaches a religion-like philosophy that oppresses men by blaming them for nearly all social problems. (When interviewed by the New York Daily News, Hollander declined [...]
twitter-tweets »
Army: Twitter could be a terrorist tool
Hmmm…so the Army has claimed that terrorists may be ‘tweeting’ along to plan and organize attacks. Well yeah, I guess they could use Gmail, Slashdot comments and other things the same way, it seems their claim is that since this is more ‘real time’ it could be a danger. Ok, oh, and they [...]
sponsors »
get a student loan fast - compare loans in 2 clicks. good credit required.
we read »
be social »
we support »
tag cloud »
apple bands barack barack obama beer bsd cds code debian dubya election email features gamer hacker health hillary howto iphone lighttpd linux music muzak networking newstudy obama open source phishing politics privacy quote religion rock and roll security spam tech terror the daily show tour tv varnish video games vote web wiiRandom Posts
Latest Video Post
Most Commented
Most Popular