I have set in config/main.inc.php :
$rcmail_config['timezone'] = 'America/New_York';
And /etc/php.ini:
; Defines the default timezone used by the date functions
; http://www.php.net/manual/en/datetime.configuration.php#ini.date.timezone
date.timezone = "America/New_York"
However, whenever a user logs into Roundcube (and gets a new record in
the database with no user-specific preferences yet), they are still
seeing the date/times of messages in the Inbox as UTC.
I have to login as that user, go to their user-specific settings and set
the timezone to the "(GMT -5:00) Eastern Time" choice in the drop-down
menu for the timezone.
Does Roundcube not understand 'America/New_York'?
For the moment I've resorted to setting a default value for that field
in the database so that new users end up in the EST timezone as a default.
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I had problem with this user logged in, the login is k2r8ne(a)domain.com
log error roundcube:
[11-Aug-2011 14:57:12] MDB2 Error: unknown error (-1): _doQuery: [Error
message: Could not execute statement]
[Last executed query: SET NAMES iso-8859-1]
[Native code: 1115]
[Native message: Conjunto de caracteres 'iso' desconhecido]
[11-Aug-2011 14:57:12 -0300]: DB Error: MDB2 Error: unknown error Query:
_doQuery: [Error message: Could not execute statement] [Last executed query:
SET NAMES iso-8859-1] [Native code: 1115] [Native message: Conjunto de
caracteres 'iso' desconhecido] in
/www/roundcubemail/program/include/rcube_mdb2.php on line 642 (POST
/webmail/?_task=login&_action=login)
[11-Aug-2011 14:57:12] MDB2 Error: constraint violation (-3): _doQuery:
[Error message: Could not execute statement]
[Last executed query: EXECUTE
mdb2_statement_mysql_745c23f46228824963c0c2bd2ce109b4f660a2a34 USING @0, @1,
@2, @3]
[Native code: 1062]
[Native message: Entrada 'k2r8ne(a)domain.com-mail.domain.com' duplicada para
a chave 2]
[11-Aug-2011 14:57:12 -0300]: DB Error: MDB2 Error: constraint violation
Query: _doQuery: [Error message: Could not execute statement] [Last executed
query: EXECUTE
mdb2_statement_mysql_745c23f46228824963c0c2bd2ce109b4f660a2a34 USING @0, @1,
@2, @3] [Native code: 1062] [Native message: Entrada '
k2r8ne(a)domain.com-mail.domain.com' duplicada para a chave 2] in
/www/roundcubemail/program/include/rcube_mdb2.php on line 642 (POST
/webmail/?_task=login&_action=login)
[11-Aug-2011 14:57:12 -0300]: PHP Error: Failed to create new user in
/www/roundcubemail/program/include/rcube_user.php on line 472 (POST
/webmail/?_task=login&_action=login)
[11-Aug-2011 14:57:12 -0300]: PHP Error: Failed to create a user record.
Maybe aborted by a plugin? in /www/roundcubemail/program/include/rcmail.php
on line 747 (POST /webmail/?_task=login&_action=login)
version roundcube: 0.5.1
the user login perfect in squirrelmail
Marlon
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I have several domains hosted on my box. At the moment, I am logging on
with username@domain scheme, but I'd like to be able to login with the
username scheme. I've already configured the drop-down with the mail
servers. A row from my database looks like this
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
| username | password |
name | maildir | quota | local_part |
domain | created | modified | active |
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
| bilgi(a)bilgisayarciniz.org | x | bilgisayarciniz |
bilgisayarciniz.org/bilgi/ | 0 | bilgi | bilgisayarciniz.org |
2011-04-10 11:28:58 | 2011-06-22 13:15:09 | 1 |
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
1 row in set (0.00 sec)
and the related line in main.inc.php looks like this
$rcmail_config['virtuser_query'] = "SELECT username FROM postfix.mailbox
WHERE local_part = '%u'";
How should I change the virtuser_query?
Regards,
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I want to decrease the check-recent interval to 10s. I have looked around in the config file and set the following values:
//sec
$rcmail_config['keep_alive'] = 12;
//min
$rcmail_config['session_lifetime'] = 10;
//sec
$rcmail_config['min_keep_alive'] = 10;
I also understood that the users preferences override these settings in the configfile so I changed the following as well.
In programs/steps/settings/save_prefs.inc:
'keep_alive' => isset($_POST['_keep_alive']) ? intval($_POST['_keep_alive'])*10 : $CONFIG['keep_alive'],
Changing 60 to 10 would, in my opinion, let me choose between 10, 30 och 50 seconds interval for check recent
(Because the select-list in the gui has 3 values: 1,3 and 5).
But this doesn't work for me. It still checks every 1min, even after restart of apache2.
Is there anywhere else I need to change to get my desired interval?
Kind Regards
Erik
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I have several domains hosted on my box. At the moment, I am logging on
with username@domain scheme, but I'd like to be able to login with the
username scheme. I've already configured the drop-down with the mail
servers. A row from my database looks like this
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
| username | password |
name | maildir | quota | local_part |
domain | created | modified | active |
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
| bilgi(a)bilgisayarciniz.org | x | bilgisayarciniz |
bilgisayarciniz.org/bilgi/ | 0 | bilgi | bilgisayarciniz.org |
2011-04-10 11:28:58 | 2011-06-22 13:15:09 | 1 |
+---------------------------+------------------------------------+-----------------+----------------------------+-------+------------+---------------------+---------------------+---------------------+--------+
1 row in set (0.00 sec)
and the related line in main.inc.php looks like this
$rcmail_config['virtuser_query'] = "SELECT username FROM postfix.mailbox
WHERE local_part = '%u'";
How should I change the virtuser_query?
Regards,
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hey, i want to ask you, in the contact list has another list at the left side called: Teams (Personal address book).
How i can erase that so cannot appear?
Thank you very much.
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi there
Under "settings" I went to "preferences" tab and in "user
interface" I changed interface skin from default to aerosat (my service
provider). Now I am unable to change back to default because when I go
into settings and preferences, the list with user interface does not
appear. How do I change back to default? Please help me in simple
language as I am not a computer whiz.
Regards
Tony Klootwyk
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I would like to know how to forward several messages (that I have
already received) to another user without repeating the forward command
for
each of them.
Giorgio Capon
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
I'm testing password plugin using poppassd. I'm just wondering if there's a
way I can set rules such as there should be numbers or characters in the New
Password. Without numbers or characters, change password will fail. There
are already password minimum length so I think what I want is possible its
just that I'm not a php programmer and don't know how will I implement it.
Thanks,
Nelson
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
hi,
just installed postfix and roundcube. i can see my emails in postfix,
but roundcube shows only the sent ones. my inbox in roundcube is
empty.
any ideas?
thx
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi everybody,
I'm running roundcube on a shared webserver of a hosting service which
brings a question to my mind concerning security:
The hosting provider gives login credentials to its customers which are
all hosted at the same domain (e.g. customer12(a)provider.com). As
roundcube allows direct login to IMAP accounts I am afraid that other
customers are able to login to "my" roundcube installation with their
email-adress e.g. customer256(a)provider.com.
Is it possible to protect a roundcube installation so that only
specified logins are enabled?
So I want to be able to login with my account customer12(a)provider.com
but want to prevent other customers of the same domain @provider.com to
use roundcube.
Simply I would do this with a .htaccess-file but a more elegant way
would be preferable, I guess.
Thank you!
Bea
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
I just recently setup roundcube and now playing with it. I have two folders
Sent and Sent Items. But RC treat Sent Items also as Sent. So in RC, there
is 2 Sent folder. Is there a way I could display Sent and Sent Items in the
Folder pane?
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi folks
I would appreciate some ideas of where to look to try and solve my problem.
I am setting up a new server (have RoundCube installed on my old server and
has been working perfectly for over 2 years).
I have run the install on Debian Squeeze using aptitude, including
'roundcube', 'roundcube-core' and 'roundcube-mysql'.
The database has been created and contains 6 tables.
I have Apache2 and MySQL5 running and they seem to be working fine.
In my browser I type http://server-url/roundcube and the login page appears.
I enter "postmaster" as the username and the password but I get the message
"Login failed"
In the "syslog" I get messages that indicate the IMAP login was successful
(to Dovecot), however it immediately logs out:
> Apr 19 23:10:41 ds5683 dovecot: imap-login: Login: user=<postmaster>,
> method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
> Apr 19 23:10:41 ds5683 dovecot: IMAP(postmaster): Disconnected: Logged out
> bytes=39/443
>
In the roundcube "errors" log (the php log file) I get messages indicating
the database connection may not be working as in these:
> [19-Apr-2011 23:05:10 +1000]: PHP Error: Failed to create new user in
> /usr/share/roundcube/program/include/rcube_user.php on line 451 (POST
> /roundcube/?_task=&_action=login)
> [19-Apr-2011 23:05:10 +1000]: PHP Error: Failed to create a user record.
> Maybe aborted by a plugin? (POST /roundcube/?_task=&_action=login)
>
However in the database there are actually records being created in the
'users' table:
user_id username mail_host alias created last_login language preferences 1
postmaster localhost 2011-04-19 23:22:23 2011-04-19 23:22:23 en_US *NULL*
There's data in the 'session' table also:
sess_id created changed ip vars mm6ld61j9ekan5fief4ocikig3 2011-04-19
23:22:23 2011-04-19 23:22:23 122.148.149.28
language|s:5:"en_US";auth_time|i:1303219343;temp|b...
The Apache log shows me a little more detail about the error but essentially
indicates that the database error was an attempt to add a duplicate primary
key:
> [Tue Apr 19 23:10:23 2011] [error] [client 122.148.149.28] MDB2 Error:
> constraint violation (-3): _doQuery: [Error message: Could not execute
> statement]\n[Last executed query: EXECUTE
> mdb2_statement_mysql_3d2cec1a51699f95fdead7b1b9c2cc9f52dd15da3 USING @0, @1,
> @2]\n[Native code: 1062]\n[Native message: Duplicate entry
> 'mm6ld61j9ekan5fief4ocikig3' for key 'PRIMARY']\n
>
The question is why is RoundCube trying to add a duplicate entry... what is
making it think it needs to add this user again???
If somebody can point me in the right direction as to what I should be
looking for that would be really helpful.
I've Googled all over the place and while there are a few articles about
this problem of creating new users there was no definitive solution, and
none of the suggestions offered seemed to help me at all. I tried looking
for security issues but couldn't find any. Found some table fields that
were not supposed to be 'null' and allowed them to be hoping that this may
solve the problem as one website suggested, but again no luck.
Cheers
Murray
--
Murray Collingwood
Focus Computing
p +61 415 24 26 24
http://www.focus-computing.com.au
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
People,
Firstly, thanks to the developers for a really nice product!
I have made the switch from Squirrelmail to RoundCubeMail for (remote)
webmail - which is a nice improvement. I have also bitten the bullet
and also switched from Thunderbird (for local mail) as well even though
there are a few features that I am missing because I think the
advantages of having a single mail client again (and one that has a SQL
DB for it's data) outweighs the disadvantages. I have been using RCM
heavily for some days now and am quite impressed but here are the
features I am missing from TB (I know some are already recognised as
wish list items but I thought I would repeat them to add weight to their
status). In the order I discovered them:
- a facility for inserting a text file into the body text
- a header lines editor
- show ALL of the items in the mail items pane ( increase max from 200
-> 999?)
- facility to open (as opposed to save) PDFs
- facility to list only folders with unread mails
- facility to automatically add new addressees to Address Book from
outgoing mails
- keyboard shortcuts
- RSS feeds (this seems to have been discussed on the fora a bit but
does not seem to be properly available?)
And also a question: Can plugins be written in Ruby? (I supposed I
should read the plugin stuff . .)
Thanks,
Phil.
--
Philip Rhoades
GPO Box 3411
Sydney NSW 2001
Australia
E-mail: phil(a)pricom.com.au
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
trying to set up the vacation-plugin wit ldap-backend I'm
stuck. Accessing the page I get an error "Fehler bei der Verarbeitung",
which means something like "Processing error".
Preliminaries:
Only the admin can (and shall) change data in the directory tree.
the User-Dn is build like
uid=user(a)example.com,ou=example.com,ou=virtualmail,dc=hanns,dc=de
(The Mail-Address is used for the attributes mail and uid)
Here's my ldap-configuration from plugins/vacation (comments stripped
for readability)
,----[ plugins/vacation/config.inc.php ]
| $rcmail_config['vacation_ldap_host'] = '127.0.0.1';
| $rcmail_config['vacation_ldap_port'] = 389;
| $rcmail_config['vacation_ldap_starttls'] = true;
| $rcmail_config['vacation_ldap_version'] = 3;
| $rcmail_config['vacation_ldap_basedn'] = 'ou=virtualmail,dc=hanns,dc=de';
| $rcmail_config['vacation_ldap_binddn'] = 'cn=Manager,dc=hanns,dc=de';
| $rcmail_config['vacation_ldap_bindpw'] = 'totallysecret';
| $rcmail_config['vacation_ldap_attr_email'] = 'mail';
| $rcmail_config['vacation_ldap_attr_emaillocal'] = 'mailhost';
| $rcmail_config['vacation_ldap_attr_emaildomain'] = 'mailsource';
| $rcmail_config['vacation_ldap_attr_vacationenable'] = 'vacationActive';
| $rcmail_config['vacation_ldap_attr_vacationenable_value_enabled'] = 'TRUE';
| $rcmail_config['vacation_ldap_attr_vacationenable_value_disabled'] = 'FALSE';
| $rcmail_config['vacation_ldap_attr_vacationstart'] = 'vacationStart';
| $rcmail_config['vacation_ldap_attr_vacationend'] = 'vacationEnd';
| $rcmail_config['vacation_ldap_attr_vacationsubject'] = null;
| $rcmail_config['vacation_ldap_attr_vacationmessage'] =
| 'vacationInfo';
| $rcmail_config['vacation_ldap_attr_vacationkeepcopyininbox'] = null;
| $rcmail_config['vacation_ldap_attr_vacationkeepcopyininbox_value_enabled'] = null;
| $rcmail_config['vacation_ldap_attr_vacationkeepcopyininbox_value_disabled'] = null;
| $rcmail_config['vacation_ldap_attr_vacationforwarder'] =
| 'vacationForward';
| $rcmail_config['vacation_ldap_search_base'] =
| 'uid=%username,dc=%email_domain,ou=virtualmail,dc=hanns,dc=de';
| $rcmail_config['vacation_ldap_search_filter'] = '(objectClass=CourierMailAccount)';
| $rcmail_config['vacation_ldap_search_attrs'] = array ('vacationActive', 'vacationInfo');
| $rcmail_config['vacation_ldap_modify_dns'] = array ( 'dc=Manager,dc=hanns,dc=de');
| $rcmail_config['vacation_ldap_modify_ops'] = array(
| array ('replace' => array(
| $rcmail_config['vacation_ldap_attr_vacationenable'] => '%vacation_enable',
| $rcmail_config['vacation_ldap_attr_vacationmessage'] => '%vacation_message',
| $rcmail_config['vacation_ldap_attr_vacationforwarder'] => '%vacation_forwarder'
| )
| )
| );
`----
I'm in doubt, if I've set the right values for example in
$rcmail_config['vacation_ldap_search_base'] and
$rcmail_config['vacation_ldap_modify_dns']
By now, I don't see any activity in the ldap-Log, when I access the
vacation page.
Probably someone can have a look at the configuration and give me a
hint, where to start searching for my mistake.
Any help appreciated.
Hanns
--
"Who is General Failure? And why is he reading my harddisk?"
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Am 08.06.2011 13:56, schrieb Andreas Dick:
> On Wed, 08 Jun 2011 13:26:59 +0200, Tobi wrote:
>> Hi
>>
>> I have a strange problem with the latest version of RC-mail. When trying
>> to login I always get a "no connection error" for the given
>> default_host. I set the logging values all to true, but there is not one
>> line in ./logs/errors But for every login attempt I get lines in
>> ./logs/sql
>> strange thing is that a testscript with fsockopen() on port 143 returns
>> a valid pointer. As well telnet mymailserver 143 returns the greeting
>> string from my dovecot server. All other clients than RC-mail in the
>> same subnet can easy connect to the dovecot server. Just RC "thinks"
>> there is an error.
>> Does anyone have an idea in which direction I can dig further?
> looks like the access rights of logs/ ... have you changed owner and
> group of this directorry to the one of the webserver? (and as well tmp/ )
> Andreas
Hi
thanks for the hint with owner. I just had group set to the group the
webserver is running under. After I set the webserver user as owner as
well I got a bunch of PHP-Notices in the file. But nothing that looks
like a real error. If I set the error_reporting back to E_ERROR then I
get nothing in the errors file. I checked my dovecots logs as well, not
a trace of a connection try of RC. Firewalls on both machines are not
running.
I tried the local LAN IP of my mailserver as default_host as well as the
hostname, did not make any difference.
I have no clue where this request is "blocked" but I guess that it must
be somewhere within RC as I'm pretty sure the requests never reach my
mailserver which is in the same subnet than the webserver. At least I
cannot find anything in the mailserver logs.
I tried ssl connections on port 993 as well as normal requests on port
143. Nothing works.
Anymore ideas where to look further?
Thanks + cheers
tobi
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi
I have a strange problem with the latest version of RC-mail. When trying
to login I always get a "no connection error" for the given
default_host. I set the logging values all to true, but there is not one
line in ./logs/errors But for every login attempt I get lines in ./logs/sql
strange thing is that a testscript with fsockopen() on port 143 returns
a valid pointer. As well telnet mymailserver 143 returns the greeting
string from my dovecot server. All other clients than RC-mail in the
same subnet can easy connect to the dovecot server. Just RC "thinks"
there is an error.
Does anyone have an idea in which direction I can dig further?
Thanks
tobi
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
People,
I have installed:
roundcubemail-0.3.1-2.fc13.noarch
and I have followed all the suggestions from the INSTALL doc and from a
number of web pages but I still get the message:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
I can tell from the lack of stuff in the PG logs that no connection is
even attempted. The only thing I haven't tried is rebooting the server
but that shouldn't be necessary?
I am looking to replace Squirrelmail for remote mail access and perhaps
Thunderbird for local access - as long as I don't don't lose too much
functionality . .
Suggestions appreciated!
Thanks,
Phil.
--
Philip Rhoades
GPO Box 3411
Sydney NSW 2001
Australia
E-mail: phil(a)pricom.com.au
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello folks,
We just published a new bugfix release that fixes two important issues
in the IMAP communication which prevented sent messages from being
saved in version 0.5.2.
It's recommended to update all productive installations of Roundcube
with this new release. See http://trac.roundcube.net/wiki/Changelog
for details.
Best regards,
Thomas
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Dear Roundcube users and lovers,
We're happy to announce another release of the Roundcube webmail
suite. This service update brings some more bug fixes and stability
improvements and it includes an updated version of the TinyMCE editor
which is now supposed to work correctly in IE9.
It is considered stable and we recommend to update all existing
Roundcube installation with this release. For a complete list of
changes see http://trac.roundcube.net/wiki/Changelog. Packages can be
downloaded from the usual place: http://roundcube.net/download
Have fun and happy easter,
Thomas
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I'm trying to install roundcube from svn; this is what I get when I try to
login (the login fails):
DB Error in /var/www/[redacted]/program/include/rcube_mdb2.php (718): MDB2
Error: constraint violation Query: _doQuery: [Error message: Could not execute
statement] [Last executed query: EXECUTE
mdb2_statement_mysql_3415882471425ebb3058fd14a2a2528d2e740add6 USING @0, @1,
@2] [Native code: 1062] [Native message: Duplicate entry
'SJlwEcZI3UdK6f7r3,HcfYWdgsEJn2ghSoE6xWj7' for key 'PRIMARY']
I've set $rcmail_config['debug_level'] to 15 for this.
A backtrace indicates this originates in the shutdown routine
(debug_backtrace() slightly trimmed for brevity):
[0] => Array
[file] => /var/www/webmail2.ii.nl/program/include/rcube_mdb2.php
[line] => 301
[function] => _add_result
[1] => Array
[file] => /var/www/webmail2.ii.nl/program/include/rcube_mdb2.php
[line] => 219
[function] => _query
[2] => Array
[file] => /var/www/webmail2.ii.nl/program/includ/rcube_session.php
[line] => 181
[function] => query
[3] => Array
[function] => db_write
[class] => rcube_session
[4] => Array
[file] => /var/www/webmail2.ii.nl/program/include/rcmail.php
[line] => 1164
[function] => session_write_close
[5] => Array
[function] => shutdown
This is the only error I see (besides a lot of notices and strict errors when
I set error_reporting to E_ALL); does anyone have a pointer where to start
looking?
thanks,
Mrten.
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi there,
At some point I upgrade RC to the 0.5.2. Additionally, mysql was
upgraded to 5.1.57-1~dotdeb.1 from the dotdeb repos for Debian Squeeze.
There were no problems to report, until someone tried to change his
password, and the logs spat out this:
May 25 12:03:53 srv22 roundcube: PHP Parse error: syntax error,
unexpected T_VARIABLE in /web/rc/plugins/password/config.inc.php on line 19
May 25 12:03:53 srv22 roundcube: PHP Parse error: syntax error,
unexpected T_VARIABLE in /wev/rc/plugins/password/config.inc.php on line 19
The apparently offending line in this plugin is:-
$rcmail_config['password_require_nonalpha'] = false;
If I comment it out it just complains about the next line.
Has anyone seen this, so that I might mend it?
Best regards, S
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e