PDA

View Full Version : Roundcube doesnt save language, identities and timezone settings.


maxx
12th June 2006, 15:06
Hello Folks.

Roundcube doesnt save / remember my settings that I change.

I change language, timezone and identities and press save. After logout and login the settings are back to default..

What is wrong?

- M

alex916
12th June 2006, 15:32
same problem, also address book isn't saved.
There isn't database in mysql and in the installation file i think to remember that it could be.

falko
12th June 2006, 17:23
Roundcube is still in alpha or beta state, so this might cause your problems...

alexnz
18th June 2006, 07:29
yeah neither for me its not saving my address book detials or new identities

i have created the roundcube mysql database + filled it with the appriopriate tables and configured the db.inc.php and main.inc.php file too read the mysql databse but web i log into webmail its still not saving new identities or address book?

can anyone help out?

lorello
18th June 2006, 22:58
I'm useing Roundcube on my ISPConfig box and I'm very happy of it. I'm useing mysql to store user preferences and it works.

Have you tested your mysql connection to specified db?
Have you switched 'auto_create_option' to TRUE?

Try setting debug_level to 4 (show) and see if some error appear on the page when you set some preference.

alexnz
20th June 2006, 01:28
okay i have checkrf all the settings

when i save the user information it does write the data too mysql database, but it still not displaying the information when i log out and log back in agian???

i get no errors with the logfile or the value set too 4 .... im completely stumped! ive been over the cfg files a few times now and now i cant figure how why its not reading the information!

please someone help!

here is my cfg files:



<?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:pass@localhost/roundcube';
// 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
?>





<?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'] = 4;

// 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;

// 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;

// 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'] = '/etc/postfix/virtusertable';

// 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'] = 30;

// check client IP in session athorization
$rcmail_config['ip_check'] = TRUE;

// the default locale setting
$rcmail_config['locale_string'] = 'en';

// 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';

// add this user-agent to message headers when sending
$rcmail_config['useragent'] = 'RoundCube Webmail';

// use this name to compose page titles
$rcmail_config['product_name'] = 'RoundCube Webmail';

// only list folders within this path
$rcmail_config['imap_root'] = '';

// 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
$rcmail_config['default_imap_folders'] = array('INBOX', 'Drafts', 'Sent',
'Junk', 'Trash');

// default sort col
$rcmail_config['message_sort_col'] = 'date';

// default sort order
$rcmail_config['message_sort_order'] = 'DESC';

// Set TRUE if deleted messages should not be displayed
// This will make the application run slower
$rcmail_config['skip_deleted'] = FALSE;

// 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('hosts' =>
array('directory.verisign.com'),
* 'port' => 389,
* 'base_dn' => '',
* 'search_fields' => array('Email' => 'mail', 'Name' => 'cn'),
* 'name_field' => 'cn',
* 'mail_field' => 'mail',
* 'scope' => 'sub',
* 'fuzzy_search' => 0);
*/


/***** 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'] = 0;

// daylight savings are On
$rcmail_config['dst_active'] = TRUE;

// prefer displaying HTML messages
$rcmail_config['prefer_html'] = TRUE;

// show pretty dates as standard
$rcmail_config['prettydate'] = TRUE;

// end of config file
?>



what am i missing? why isnt she reading the DB?

alexnz
20th June 2006, 01:48
okay figured something out

when i login with web1_new1 i can see address book stuff i have added and identities....

but when i login with the alias new@dns.strangled.netnone of the information appears ....

i think its a user linking issue with the postfix/db/roundcube?


can anyone help?

Hans
20th June 2006, 11:43
I do not recommend to use RoundCube for a production environment at this moment.
It is still in developement.
I had a look at it some time ago and there are still bugs like:

Settings which are not saved
Incompatible with some browsers like Opera.
You see this incompatibility for example when you use the CC or BCC option.
And unfortunately some other things i do not know.

Some bugs are fixed already in the developement version already,
but this bugfixes are not included in the RoundCube version which is available in the package for ISPConfig.

The userinterface is really nice, but that is it at this moment.
Matter of time...

Hans

maxx
20th June 2006, 18:32
Im still using Uebimiau. But in the future I would like to see search feature on Cube.

- M

lorello
27th June 2006, 00:58
when i save the user information it does write the data too mysql database, but it still not displaying the information when i log out and log back in agian???

How you know the db is updated?
Have you seen some record in db?

wr19026
27th June 2006, 18:21
Longer term it would make sense to push for an IMAP based webmail client. RoundCube *would* be great although Squirrelmail prepackaged with some of the options (seen it for VHCS) looks pretty great too.

fofan
1st September 2006, 13:06
i have same problem with roundcube mail
after configuring and creating mysql connection and database , its successfully changing database record of identites but every time u log on its creating new identity with user@www.domain.com
how does roundcube handle where to get username and email for initial login and database, looks like its taking those infro from somewhere else than database

falko
2nd September 2006, 17:18
I think it's guessing the email address from the username you use to log in + the server's hostname. I don't know RoundCube, but I think you can set the sender address somewhere, just as you do in any normal email client such as Outlook.

fofan
5th September 2006, 20:07
I have gone thru all the problems you were getting, with no automatic folders creation, and the biggest, which was non acceptable for my users, the www which was keep coming in contact info.

I will describe here my workarround, so at least you should not spend the same time which I did on it.

The problem comes from Round Cube, which is looking into the mail server alias file (my case postfix). There, ISPConfig has set up the first alias prefixed with www, as your default host name was configured.
Now, everytime when you will log in without www user@domain.com, RoundCube will assume that you are a new user, and will open a new account in it's database (all the user settings are automatically saved in RoundCube database). If you will try loggin in with user@www.domain.com, you will see that the settings for contact will be saved and next time you will log in , you will have the same thing. Moreover, everytime you will log in with different aliases, you will get different settings saved for each of them .
After I digged through ISPConfig forum, I found out that the problem with aliases will be there till some next release, where you will be able to select your aliases type (with or without hostname). Then, our problems will be completed sort out.
Till then, what you can do, and what I did, was, creating a separate aliases file, only for rouncube, where you will put the usernames, exactly in the way you need them.
Ex of entry in roundcube_alias
user@domain.com web1_user
After you will have the file, you should change the value of $rcmail_config['virtuser_file'] in /home/admispconfig/ispconfig/web/roundcubemail/config/main.inc.php.
The only problem which you will still have, it will be adding one new alias for each user newly created on your system. The advantage is that you can have users with pop3/imap and users with webmail access .
If I was not clear enough, I am available for questions.

Cheers,
Dan

Found thats here (http://www.howtoforge.com/forums/showthread.php?t=2081&page=4&highlight=virtusertable)

and its looks like no way yet to make roudcube working properly, automatic creating accounts and saving settings with ISPConfig yet, so we are back to UebiMail :-( realy dificult to use it after clear and butifull interface of roundcube, waiting for next releases of roundcube :-)

fofan
5th September 2006, 21:13
I'm installed SuirrelMail from .pkg, and its working perfect , does anybody know where to get templates for it ?

falko
6th September 2006, 20:05
I found a website that sells SquirrelMail templates... Not sure if that is what you want...

veroxii
8th January 2007, 18:05
I've fixed this roundcube issue btw, for anyone who's interested. (the roundcube pkg installation you can download from the main download site). The problem was that roundcube would lookup your username from the email address only after checking whether your settings are in the database. Weird and obviously a bug.

Goto /home/admispconfig/ispconfig/web/roundcubemail/program/include/main.inc

Search down to find the function called "rcmail_login"

Find the following piece of code:


// query if user already registered
$sql_result = $DB->query("SELECT user_id, username, language, preferences
FROM ".get_table_name('users')."
WHERE mail_host=? AND (username=? OR alias=?)",
$host,
$user,
$user);

// user already registered -> overwrite username
if ($sql_arr = $DB->fetch_assoc($sql_result))
{
$user_id = $sql_arr['user_id'];
$user = $sql_arr['username'];
}

// try to resolve email address from virtuser table
if (!empty($CONFIG['virtuser_file']) && strstr($user, '@'))
$user = rcmail_email2user($user);



And change it to:


// try to resolve email address from virtuser table
if (!empty($CONFIG['virtuser_file']) && strstr($user, '@'))
$user = rcmail_email2user($user);

// query if user already registered
$sql_result = $DB->query("SELECT user_id, username, language, preferences
FROM ".get_table_name('users')."
WHERE mail_host=? AND (username=? OR alias=?)",
$host,
$user,
$user);

// user already registered -> overwrite username
if ($sql_arr = $DB->fetch_assoc($sql_result))
{
$user_id = $sql_arr['user_id'];
$user = $sql_arr['username'];
}



Look at it carefully, we're moving the bottom block of code upwards.

Once that done, it should work. If you're still having problems, make sure /home/admispconfig/ispconfig/web/roundcubemail/config/main.inc.php is correctly configured. Specifically for my CentOS 4.4 system I had to change the following line:


$rcmail_config['virtuser_file'] = '/etc/mail/virtusertable';


Hope that helps people out. Now you can login with the user name, or the email address, and the preferences are saved perfectly across both. :-)

Cheers,
-V

lorello
8th January 2007, 19:22
thanks for your effort :)

LumpyOne
26th June 2007, 02:52
Veroxii, you're a hero! This made RoundCube something worth using. I posted a link to your post over in the Roundcube.net forums too.

till
26th June 2007, 09:49
Thanks. Moved the thread to the Tipps & Tricks forum.

Hans
26th June 2007, 15:13
Personally, i do not think that this whole issue was a RoundCube bug.
I use RoundCube for almost one year now on my servers and i can confirm that there where only problems when RoundCube was still in an early beta fase.

I think that the problem was, that the RoundCube package provided by ISPConfig has been built on an older version then the latest release, which is 0.1-RC1.

If you make the modifications within the main.inc.php file as describes here: http://www.howtoforge.com/roundcube_webmail_ispconfig, all should work fine.
To login with the emailaddress as well you should only change the line:

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '';

into:

// Path to a virtuser table file to resolve user names and e-mail addresses
$rcmail_config['virtuser_file'] = '/etc/postfix/virtusertable';

On http://www.ispconfig.org/downloads.htm, i would like to see the software version, so it's clear where packages are built on.

Hans
4th July 2007, 23:20
In the mean time Till has published my new RoundCube 0.1-rc1.1 package at http://www.ispconfig.org/downloads.htm. He also mentioned the version of the software, so it's clear on which version the package is based on.
Thanks for that Till!

With this version of RoundCube a lot of problems are solved.

Have a look at this thread for update instructions:
http://www.howtoforge.com/forums/showthread.php?t=2081&page=15&highlight=roundcube

Have a look at this thread as well for adapting the login screen to your needs: http://www.howtoforge.com/forums/showthread.php?t=13844&highlight=roundcube

planet_fox
8th July 2007, 00:14
I have see new version

RoundCube 0.1-rc1 2007/07/03

We have now released the 0.1-rc1 package without any third party libraries. The package only contains the core source files which are all licensed under the Gnu GPL. This release is..

Hans
8th July 2007, 10:01
I know that the 0.1-rc1 pure GPL version has been released.

I wonder if it is necesarry to build a new RounCube package for ISPConfig for this version, because of it's different requirements and it's also based on 0.1-rc1. When an ISPConfig server has been setup according "The perfect setup" you should install additional software as well, otherwise the RoundCube package will not function.

The RoundCube 0.1-rc1 pure GPL version requirements are:

* The Apache Webserver
* .htaccess support allowing overrides for DirectoryIndex
* PHP Version 4.3.1 or greater including
- PCRE (perl compatible regular expression)
- Mcrypt (supporting Triple DES)
- libiconv
- Multibyte String (mbstring)
- Database driver for either MySQL, Postgres or SQLite
* php.ini options:
- error_reporting E_ALL & ~E_NOTICE (or lower)
- file_uploads on (for attachment upload features)
- memory_limit (increase as suitable to support large attachments)
* The PEAR framework with the following packages installed
- DB (1.7.11)
- Mail_Mime (1.3.1)
- Net_SMTP (1.2.10)
* A MySQL or PostgreSQL database engine or the SQLite extension for PHP
* A database with permission to create tables

Did you know that RoundCube is also available as Debian (unstable) package?
Have a look here: http://packages.debian.org/unstable/web/roundcube

planet_fox
8th July 2007, 12:23
I have yesterday install, it works.Have same Probleme with virtualuser file from postfix. I don't know what ahve till planning for the new structure of this file.
Roundcube do when i set in config the mailuser to info@www.mymail.org set.
I have yesterday idee I make a cronjob make a copy of this file all 60min and than remove all "www" .I don`t konw can I do.

till
8th July 2007, 12:40
If you do not want to have the @www.domain.com records in this file, just set the website to external mailserver. But do not set the co-domain with empty hostname to external mailserver.

The result is that you get email for @domain.com but not for @www.domain.com anymore and no lines for @www.domain.com are listed in the virtusertable file.

planet_fox
8th July 2007, 13:37
Ok I do morning testing. Thanks

dmit
12th July 2007, 13:54
There is a simple trick to get rid of both those annoying problems - roundcube not saving prefs and having user@WWW.domain.tld as default identity.

The RoundCube package for ISPConfig has all the patches from http://www.howtoforge.com/roundcube_webmail_ispconfig applied, except this one:

> When a user login with the email address for the first time, within
> RoundCubes the identities section, the e-mail address will be displayed like:
> username@www.domain.tld. As we want the email address to be displayed
> like username@domain.tld do the following:

> Change the line within /program/include/main.inc file from:
> $line = trim($line);
> to:
> $line = trim(str_replace("www.", "", $line));

Once you patch this yourself you will not only have default user identity like user@domain.tld, but also all user preferences will be saving without a problem as well.

I think this patch should be included in the ISPConfig RoundCube package by default. ;)

What should be implemented as well is to acquire the full user name from ISPConfig database. Right now, RoundCube when patched as explained in the howto, takes user info from postfix virtusertable file. But the username there is in the form of:

user@domain.tld web1_user

Although the ISPConfig database has the full user name as well. So as far as I see there are two options:

1) patch the ISPConfig postfix configuration module so the full user name is added to virtusertable in the form of:

user@domain.tld web1_user #Firstname Surname

and patch RoundCube accordingly so it would use this commented info instead of web1_user.

2) Patch RoundCube to acquire the info from ISPConfig database directly.

Hans
12th July 2007, 14:23
:confused: The current RoundcubeWebmail 0.1-rc1.1 package contains line $line = trim(str_replace("www.", "", $line)); already ! Check it by yourself within the main.inc file at line 670.

dmit
12th July 2007, 14:35
:confused: The current RoundcubeWebmail 0.1-rc1.1 package contains line $line = trim(str_replace("www.", "", $line)); already ! Check it by yourself within the main.inc file at line 670.

??????????? :eek:

Heh! I have downloaded the RoundCube.pkg file today from http://www.ispconfig.org/downloads/RoundCube.pkg (just followed the link from http://www.howtoforge.com/roundcube_webmail_ispconfig HOWTO). I just didn't check, if it is the last version or not. But looks like the one from http://www.ispconfig.org/downloads/roundcubemail.pkg is different. :cool:

I don't know which one is newer, but the hint above worked for me with no problem. Try to uninstall the package and reinstall again from http://www.ispconfig.org/downloads/RoundCube.pkg then check again.

Hans
12th July 2007, 14:59
In the mean time i've corrected the URL within my howto here: http://www.howtoforge.com/roundcube_webmail_ispconfig

Probably there are more versions stored at ispconfig/downloads ...

http://www.ispconfig.org/downloads/roundcubemail.pkg

and a previous package:

http://www.ispconfig.org/downloads/RoundCube.pkg

http://www.ispconfig.org/downloads/roundcubemail.pkg is the right URL!

Thanks for your information.

dmit
12th July 2007, 15:05
In the mean time i've corrected the URL within my howto here: http://www.howtoforge.com/roundcube_webmail_ispconfig

Probably there are more versions stored at ispconfig/downloads ...


But what was the reason for this? The previous one worked just fine except this small issue. But as I see this new package has it's own bugs which are not addressed yet. May be you should put both of the links there with small explanation?..

Hans
12th July 2007, 15:26
Within my howto at URL http://www.howtoforge.com/roundcube_webmail_ispconfig i mentioned the package at URL http://www.ispconfig.org/downloads/RoundCube.pkg based on RoundCube 0.1 Beta 2.

Recently, I updated the RoundCube package because of the new RC1 release and to solve some problems. I could not know that Till published my latest package to a different URL. (http://www.ispconfig.org/downloads/roundcubemail.pkg).

If it was published to the same URL, the link within my howto was still correct.

As far as i know, the RC1 version works very nice on my servers and problems with this new package are not reported yet within the forums.