Users

users@lists.roundcube.net

4 participants
2921 discussions

Error upgrading from Version 0.1-beta2 to Version 0.1-rc1
by Zadikem, Travis 02 Oct '07

02 Oct '07

New to the list. I am trying to upgrade from from Version 0.1-beta2 to Version 0.1-rc1 and am receiving the following error when running the mysql.update.sql script. Can someone please tell me how to fix this. thanks! SQL query: ALTER TABLE `messages` DROP `body` , DROP INDEX `cache_key` , ADD `structure` TEXT, ADD UNIQUE `uniqueness` ( `user_id` , `cache_key` , `uid` ) ; MySQL said: <http://dev.mysql.com/doc/mysql/en/error-messages-server.html> #1062 - Duplicate entry '4-INBOX.msg-390' for key 2 and here is the script that was supplied to upgrade: -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-beta and 0.1-beta2 ALTER TABLE `messages` DROP `body`, DROP INDEX `cache_key`, ADD `structure` TEXT, ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`); ALTER TABLE `identities` ADD `html_signature` tinyint(1) default 0 NOT NULL; -- Uncomment these lines if you're using MySQL 4.1 or higher ALTER TABLE `users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, CHANGE `username` `username` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_ general_ci NOT NULL, CHANGE `alias` `alias` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_genera l_ci NOT NULL; _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

blank page
by c o 02 Oct '07

02 Oct '07

Hi, I have installed rc the latest from the website. I just get a blank page. My error log says: [02-Oct-2007 12:07:27] PHP Fatal error: Call to a member function on a non-object in /home/brentadv/public_html/rc/program/include/rcube_db.inc on line 366 [02-Oct-2007 12:35:45] PHP Fatal error: Call to a member function on a non-object in /home/brentadv/public_html/rc/program/include/rcube_db.inc on line 366 [02-Oct-2007 12:36:45] PHP Fatal error: Call to a member function on a non-object in /home/brentadv/public_html/rc/program/include/rcube_db.inc on line 366 Line 366 says: return "now()"; :s but I don't think it's that. Also I couldn't work out how to do this in cpanel. I have already set up my database with correct username and pass. Database Setup While we're uploading (or after we're done) we have one final step to do before we can start using Roundcube. We need to set up our database. Open your website control panel. You first need to create a database and user with the information we decided earlier. Then add that user to the database. Next we execute the SQL file found in the "/SQL/" directory in Roundcube that is named: "*.initial.sql" where * is your database backend type (mySQL, PostgreSQL, SQLite). For example with mysql enter the following code on the command line: mysql --user=(your_db_user_name) -p (your_db_name) < mysql.initial.sql = -- Powered By Outblaze _______________________________________________ List info: http://lists.roundcube.net/dev/ www.danda.org.uk DANDA - Developmental Adult Neuro-Diversity Association = -- Powered By Outblaze _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Roundcube performance again
by Felipe Neuwald 28 Sep '07

28 Sep '07

Hi Folks, I disabled persistent db-connections and IMAP cache, as you can see: db.inc.php: // use persistent db-connections $rcmail_config['db_persistent'] = FALSE; main.inc.php: // enable caching of messages and mailbox data in the local database. // this is recommended if the IMAP server does not run on the same machine $rcmail_config['enable_caching'] = FALSE; Again, my server performance hangs with a lot of httpd process, but now after something about 15 hours of working. Any idea of how can I solve this? PS: I'll install apache-top to understand better what's happening. Thanks, Felipe Neuwald. _______________________________________________ List info: http://lists.roundcube.net/users/

1 1

Roundcube performance
by Felipe Neuwald 27 Sep '07

27 Sep '07

Hi Folks, I'm running roundcube-0.1.20070902 on a FreeBSD 6.2-STABLE system. This is an email system with something about 3k users, and I was using squirrelmail as my webmail system. Yesterday, I migrated my webmail system to roundcube, but, when I have something about 1 hour of user, the system hangs with a lot of httpd processes. I had to back my webmail system to squirrelmail to get my system working again. Does anybody knows why this is happening? Here is my confs: db.inc.php: <?php /* +-----------------------------------------------------------------------+ | Configuration file for database access | | | | This file is part of the RoundCube Webmail client | | Copyright (C) 2005, RoundCube Dev. - Switzerland | | Licensed under the GNU GPL | | | +-----------------------------------------------------------------------+ */ $rcmail_config = array(); // PEAR database DSN for read/write operations // format is db_provider://user:password@host/databse // currentyl suported db_providers: mysql, sqlite $rcmail_config['db_dsnw'] = 'mysql://roundcube:xxx@localhost/roundcube'; // postgres example: 'pgsql://roundcube:pass@localhost/roundcubemail'; // sqlite example: 'sqlite://./sqlite.db?mode=0646'; // PEAR database DSN for read only operations (if empty write database will be used) // useful for database replication $rcmail_config['db_dsnr'] = ''; // database backend to use (only db or mdb2 are supported) $rcmail_config['db_backend'] = 'db'; // maximum length of a query in bytes $rcmail_config['db_max_length'] = 512000; // 500K // use persistent db-connections $rcmail_config['db_persistent'] = TRUE; // you can define specific table names used to store webmail data $rcmail_config['db_table_users'] = 'users'; $rcmail_config['db_table_identities'] = 'identities'; $rcmail_config['db_table_contacts'] = 'contacts'; $rcmail_config['db_table_session'] = 'session'; $rcmail_config['db_table_cache'] = 'cache'; $rcmail_config['db_table_messages'] = 'messages'; // you can define specific sequence names used in PostgreSQL $rcmail_config['db_sequence_users'] = 'user_ids'; $rcmail_config['db_sequence_identities'] = 'identity_ids'; $rcmail_config['db_sequence_contacts'] = 'contact_ids'; $rcmail_config['db_sequence_cache'] = 'cache_ids'; $rcmail_config['db_sequence_messages'] = 'message_ids'; // end db config file ?> main.inc.php: <?php /* +-----------------------------------------------------------------------+ | Main configuration file | | | | This file is part of the RoundCube Webmail client | | Copyright (C) 2005, RoundCube Dev. - Switzerland | | Licensed under the GNU GPL | | | +-----------------------------------------------------------------------+ */ $rcmail_config = array(); // system error reporting: 1 = log; 2 = report (not implemented yet), 4 = show, 8 = trace $rcmail_config['debug_level'] = 1; // enable caching of messages and mailbox data in the local database. // this is recommended if the IMAP server does not run on the same machine $rcmail_config['enable_caching'] = TRUE; // lifetime of message cache // possible units: s, m, h, d, w $rcmail_config['message_cache_lifetime'] = '10d'; // automatically create a new RoundCube user when log-in the first time. // a new user will be created once the IMAP login succeeds. // set to false if only registered users can use this service $rcmail_config['auto_create_user'] = TRUE; // the mail host chosen to perform the log-in // leave blank to show a textbox at login, give a list of hosts // to display a pulldown menu or set one host as string. // To use SSL connection, enter ssl://hostname:993 $rcmail_config['default_host'] = 'localhost'; // TCP port used for IMAP connections $rcmail_config['default_port'] = 143; // Automatically add this domain to user names for login // Only for IMAP servers that require full e-mail addresses for login // Specify an array with 'host' => 'domain' values to support multiple hosts $rcmail_config['username_domain'] = 'cepatec.org.br'; // This domain will be used to form e-mail addresses of new users // Specify an array with 'host' => 'domain' values to support multiple hosts $rcmail_config['mail_domain'] = ''; // Path to a virtuser table file to resolve user names and e-mail addresses $rcmail_config['virtuser_file'] = ''; // Query to resolve user names and e-mail addresses from the database // %u will be replaced with the current username for login. // The query should select the user's e-mail address as first col $rcmail_config['virtuser_query'] = ''; // 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'] = 'localhost'; // 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'] = ''; // Log sent messages $rcmail_config['smtp_log'] = TRUE; // these cols are shown in the message list // available cols are: subject, from, to, cc, replyto, date, size, encoding $rcmail_config['list_cols'] = array('subject', 'from', 'date', 'size'); // relative path to the skin folder $rcmail_config['skin_path'] = 'skins/default/'; // use this folder to store temp files (must be writebale for apache user) $rcmail_config['temp_dir'] = 'temp/'; // use this folder to store log files (must be writebale for apache user) $rcmail_config['log_dir'] = 'logs/'; // session lifetime in minutes $rcmail_config['session_lifetime'] = 10; // check client IP in session athorization $rcmail_config['ip_check'] = false; // Use an additional frequently changing cookie to athenticate user sessions. // There have been problems reported with this feature. $rcmail_config['double_auth'] = false; // this key is used to encrypt the users imap password which is stored // in the session record (and the client cookie if remember password is enabled). // please provide a string of exactly 24 chars. $rcmail_config['des_key'] = 'rcmail-!24ByteDESkey*Str'; // the default locale setting $rcmail_config['locale_string'] = 'pt_BR'; // use this format for short date display $rcmail_config['date_short'] = 'D H:i'; // use this format for detailed date/time formatting $rcmail_config['date_long'] = 'd.m.Y H:i'; // use this format for today's date display $rcmail_config['date_today'] = 'H:i'; // add this user-agent to message headers when sending $rcmail_config['useragent'] = 'RoundCube Webmail/0.1b'; // use this name to compose page titles $rcmail_config['product_name'] = 'RoundCube Webmail'; // only list folders within this path $rcmail_config['imap_root'] = ''; // store draft message is this mailbox // leave blank if draft messages should not be stored $rcmail_config['drafts_mbox'] = 'Drafts'; // store spam messages in this mailbox $rcmail_config['junk_mbox'] = 'Junk'; // store sent message is this mailbox // leave blank if sent messages should not be stored $rcmail_config['sent_mbox'] = 'Sent'; // move messages to this folder when deleting them // leave blank if they should be deleted directly $rcmail_config['trash_mbox'] = 'Trash'; // display these folders separately in the mailbox list. // these folders will automatically be created if they do not exist $rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent', 'Junk', 'Trash'); // protect the default folders from renames, deletes, and subscription changes $rcmail_config['protect_default_folders'] = TRUE; // Set TRUE if deleted messages should not be displayed // This will make the application run slower $rcmail_config['skip_deleted'] = FALSE; // Set true to Mark deleted messages as read as well as deleted // False means that a message's read status is not affected by marking it as deleted $rcmail_config['read_when_deleted'] = TRUE; // When a Trash folder is not present and a message is deleted, flag // the message for deletion rather than deleting it immediately. Setting this to // false causes deleted messages to be permanantly removed if there is no Trash folder $rcmail_config['flag_for_deletion'] = TRUE; // Make use of the built-in spell checker. It is based on GoogieSpell. $rcmail_config['enable_spellcheck'] = TRUE; // For a locally installed spellcheker, specify the URI to call it, for example: // 'http://' . $_SERVER['HTTP_HOST'] . '/spellchecker.php?lang=' // Leave empty to use the Google spell checking service, what means // that the message content will be sent to Google in order to check spelling $rcmail_config['spellcheck_uri'] = ''; // These languages can be selected for spell checking. // Configure as a PHP style hash array: array('en'=>'English', 'de'=>'Deutsch'); // Leave empty for default set of Google spell check languages $rcmail_config['spellcheck_languages'] = NULL; // path to a text file which will be added to each sent message // paths are relative to the RoundCube root folder $rcmail_config['generic_message_footer'] = ''; // this string is used as a delimiter for message headers when sending // leave empty for auto-detection $rcmail_config['mail_header_delimiter'] = NULL; // in order to enable public ldap search, create a config array // like the Verisign example below. if you would like to test, // simply uncomment the Verisign example. /** * example config for Verisign directory * * $rcmail_config['ldap_public']['Verisign'] = array( * 'name' => 'Verisign.com', * 'hosts' => array('directory.verisign.com'), * 'port' => 389, * 'base_dn' => '', * 'bind_dn' => '', * 'bind_pass' => '', * 'search_fields' => array('mail', 'cn'), // fields to search in * 'name_field' => 'cn', // this field represents the contact's name * 'email_field' => 'mail', // this field represents the contact's e-mail * 'surname_field' => 'sn', // this field represents the contact's last name * 'firstname_field' => 'gn', // this field represents the contact's first name * 'scope' => 'sub', // search mode: sub|base|list * 'filter' => '', // used for basic listing (if not empty) and will be &'d with search queries. ex: (status=act) * 'fuzzy_search' => true); // server allows wildcard search */ // don't allow these settings to be overriden by the user $rcmail_config['dont_override'] = array(); // list of configuration option names that need to be available in Javascript. $rcmail_config['javascript_config'] = array('read_when_deleted', 'flag_for_deletion'); // try to load host-specific configuration $rcmail_config['include_host_config'] = FALSE; /***** these settings can be overwritten by user's preferences *****/ // show up to X items in list view $rcmail_config['pagesize'] = 40; // use this timezone to display date/time $rcmail_config['timezone'] = -3; // daylight savings are On $rcmail_config['dst_active'] = TRUE; // prefer displaying HTML messages $rcmail_config['prefer_html'] = TRUE; // compose html formatted messages by default $rcmail_config['htmleditor'] = TRUE; // show pretty dates as standard $rcmail_config['prettydate'] = TRUE; // default sort col $rcmail_config['message_sort_col'] = 'date'; // default sort order $rcmail_config['message_sort_order'] = 'DESC'; // save compose message every 300 seconds (5min) $rcmail_config['draft_autosave'] = 300; // default setting if preview pane is enabled $rcmail_config['preview_pane'] = FALSE; // don't let users set pagesize to more than this value if set $rcmail_config['max_pagesize'] = 200; // end of config file ?> Thanks, Felipe Neuwald. _______________________________________________ List info: http://lists.roundcube.net/users/

2 7

I new in Roundcube
by Juan Fernando Pardo 27 Sep '07

27 Sep '07

Hi, I'm new in Roundcube. I Download and install roundcubemail-0.1-rc1.1. I have some questions. 1. In Internet Explorer, the screen i see bad. Not in Mozilla Firefox. 2. In some html mails, i cant see the images. 3. When i want see an .jpg attach, it open a window with caracters and not the picture. 4. How download an atach? 5. In compose Windows, i cant compose in HTML, only text plain. Thanks. _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

roundcubemail on Freebsd 6.2/AMD64
by Juan C. Crespo R. 25 Sep '07

25 Sep '07

Dears Does anyone of you tried to use roundcubemail with dbmail 2.5, apache 2.2.4. php 5.2.3 ? on FreeBSD 6.2 AMD64? I did try with I386 and works perfectly but in 64Bits I doesn't work :( this are the logs console [24-Sep-2007 21:57:23 -0400]: * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #31 [24-Sep-2007 22:01:38 -0400]: * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #31 [24-Sep-2007 22:02:14 -0400]: * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #31 [24-Sep-2007 22:04:53 -0400]: * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #31 [24-Sep-2007 22:07:18 -0400]: * CAPABILITY IMAP4 IMAP4rev1 AUTH=LOGIN ACL NAMESPACE CHILDREN SORT QUOTA THREAD=ORDEREDSUBJECT UNSELECT cp01 OK CAPABILITY completed Tried PLAIN: Resource id #31 If any one of you knows how to make it work I will appreciated it..!! Thanks and regards _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Menu buttons grayed out
by Peter Guthrie 24 Sep '07

24 Sep '07

Hi, I just installed v0.1-rc1 on Solaris 10 and after falling into a few of the common pitfalls (all solved by searching the archives) I've hit a brick wall. Initially I setup roundcube on a non-secure http port and had everything working perfectly. I then moved it to https and although I can login, see my email messages and read them I can't do much else as all the buttons above the message list are grayed out and inactive. Any ideas? There is a certificate error with my https site which I'm still trying to track down, could that be related? Seems unlikely as I would have thought that it would have blocked all access if it was a serious problem. I get the same result with both Firefox 2.0.0.7 and IE7. Peter _______________________________________________ List info: http://lists.roundcube.net/users/

3 4

New User
by Paul Tansom 22 Sep '07

22 Sep '07

Hi, I've just installed Roundcube after recommendation from my local LUG and have, so far, been very impressed. I'm sending this email for a few reasons: 1. So I can get an email with the headers and configure my procmail setup for the list :) 2. To say well done, keep it up, and 'hi' 3. To mention an odd bug, or possibly a bug, that I found on install The problem I have with it is that I'm not at all sure whether I can repeat it, but I have had the same thing on two installs so far. The install went fine, as per the instructions on the site and all worked fine. On the first install I then amended the install to allow logging into two different servers (with nice text, not the server name in the drop down), but for the second this wasn't done. I've only done the bare minimum in the way of changes from the default config files, and haven't explored any settings not necessary to configure to get it working - database details, mail servers, etc. After my first couple of logins to test the system out I started getting a login failed error, and I could not get rid of this by changing the login account, password or server - it failed in every case. Since it was late I left things until the following day, but when I tried logging in again it went without a hitch, and has done for all subsequent logins. That was the first install, the second one went pretty much the same (bar not adding in a second server to log into). I left the server and kept trying to login again on and off over the period of about and hour give or take, and got an error every time (after the initial successful logins). Again I had to leave the server for a few hours, and when I returned all was fine, and has been since. I'm not really expecting a fix for this, since I seem to be unable to repeat it (although it may happen again on another new install), but thought it worth noting. My setup on both was Debian stable patched up to date, using Exim4 for the MTA, Dovecot for the IMAP access, Apache2 for the web server and mySQL for the backend database - oh, and PHP5. Anyway, my next piece of work is to look into adjusting the page title and adding to the Roundcube logo on the web pages - not to remove reference to Roundcube, but to make it clear that it is my webmail system. I'll dig through the docs and code and ask any questions if I get stuck :) -- Paul Tansom | Aptanet Ltd. | http://www.aptanet.com/ | 023 9238 0001 ====================================================================== Registered in England | Company No: 4905028 | Registered Office: Crawford House, Hambledon Road, Denmead, Waterlooville, Hants, PO7 6NU _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

html > txt conversion
by Zbigniew Szalbot 22 Sep '07

22 Sep '07

Dear all, The new release of RC fixed some important errors but I find one new. That is I have set up that the default message fromat is HTML. When I want to switch to txt (as now) I cannot do it. RC displays an error message, the conversion is never completed and I have to close the browser as no button then works. Operating System : FreeBSD, Server : Apache/1.3.39 (Unix) PHP/5.2.4 , MYSQL Version : 5.0.45, PHP Safe Mode : Off Anyone else also experiencing this or is it only me? Thanks! Zbigniew Szalbot _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Folder's not reflecting new messages
by Erik Osterman 21 Sep '07

21 Sep '07

If I send an email to an account, it appears Round Cube doesn't update it's message cache. Even if I log out and back in again, the message never appears in the Inbox. Further more, if I drag a message into another folder, the message count increases (visually), but I don't see the message appear in the folder. Seems like the two are related. Best, Erik _______________________________________________ List info: http://lists.roundcube.net/users/

2 5

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users