Users May 2009

users@lists.roundcube.net

25 participants
23 discussions

Default Identity Issue: user@www.domain.com
by Jon 05 May '09

05 May '09

Hi All, I'm having an issue with an RC install on an ISPConfig system. When a new ISPConfig user is created, and that user logs into RC for the first time (auto-create is set to yes), that user's default identity in RC is user(a)www.domain.com. I don't mean that literally, the user and domain.com are replaced with the correct user and domain, but the 'www' appears. For those people who have their mail going to a different server than their web, this means that emails go out with incorrect from addresses set in them. It would be nice if everyone set their identities first, but they don't. I see a patch in the RC Trac from 2 years ago that forces new users to set their identities at first log in, but I'm hoping that something more intuitive or automatic has been introduced since then. I am very willing to accept that the reason RC is doing this is because of the way my Postfix is configured so if that is the case, please feel free to give me any information on what I may need to do there as well. Or at least tell me that's where the problem lies so I can go muck around with Postfix. Any help is appreciated. Thanks, Jon _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Re: [RCU] Login error
by Manuel Giorgini 05 May '09

05 May '09

[2009-05-05 12:11], A.L.E.C: >> I cannot modify postgres' configuration on the fly, because this is a >> production machine. How can I activate query debugging on RoundCube? > > $rcmail_config['sql_debug'] = true; Thank you. This is rather funny. This is what I do to reset the situation: === [ cut here ] ============================================= psql -U roundcube roundcubemail delete from session; delete from users; delete from identities; === [ cut here ] ============================================= Then I try logging in. If I do that with sql_debug = true, it works without any error, the first time and every other time after that. If I do that with sql_debug not set, it gives me the error I posted earlier on the first time; subsequently, it works. Another difference is that at every login, the table 'identities' stays empty when sql_debug is not set; but it does receive a new record (as I think it should), when sql_debug is set to true. I could be happy by just leaving sql_debug on the whole time, but I'm itchy at leaving SQL queries around, and it would end up occupying a lot of disk space. I would appreciate further assistance; if there is anything I can do just let me know. The error I receive on logs/errors is as follows: === [ cut here ] ============================================= [05-May-2009 12:31:59 +0200] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_pgsql_59831640a8cf52029e10ae35c84ad32bfd1b037f2 (text, text, text) AS INSERT INTO identities (user_id, del, standard, name, email) VALUES ($1, 0, 1, $2, $3)] [Native message: ERROR: column "user_id" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression.] === [ cut here ] ============================================= -- Cordialità / Best regards / Ĝis la / Parhain terveisin ------------------------------------------------------------------------ Manuel Giorgini <giorgini(a)interlogica.net>, Programmatore INTERLOGICA e-business solutions - http://www.interlogica.net Via Fusinato, 27 - IT 30171 Mestre VE - Italia - Unione Europea Tel +39 041 099 30 00 (6 linee r.a.) - Fax +39 041 099 30 49 ------------------------------------------------------------------------ --- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/d4/cp3N3Zlz/giorgini.vcf Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< --- _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

05 May '09

Hi all I just finished an installation of RC 0.2.1. I am using postgres 7.4.1 ; db install went smoothly, according to docs. I have this error on logs/errors when I connect for the first time: ==== [ cut here ] ====================================================== [05-May-2009 11:10:50 +0200] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_pgsql_5b0929dec7663e6f88ca030599ba8a998e3b74a83 (text, text, tex t) AS INSERT INTO identities (user_id, del, standard, name, email) VALUES ($1, 0, 1, $2, $3)] [Native message: ERROR: column "user_id" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression.] in [path]/program/include/rcube_mdb2.php on line 255 (POST [path]/?_task=&_action=login) ==== [ cut here ] ====================================================== Subsequent logins succeed. Maybe it's my fault but I am not sure of what went wrong. I would appreciate your help. Thanks. -- Cordialità / Best regards / Ĝis la / Parhain terveisin ------------------------------------------------------------------------ Manuel Giorgini <giorgini(a)interlogica.net>, Programmatore INTERLOGICA e-business solutions - http://www.interlogica.net Via Fusinato, 27 - IT 30171 Mestre VE - Italia - Unione Europea Tel +39 041 099 30 00 (6 linee r.a.) - Fax +39 041 099 30 49 ------------------------------------------------------------------------ --- 8< --- detachments --- 8< --- The following attachments have been detached and are available for viewing. http://detached.gigo.com/rc/59/wHVsxdQ1/giorgini.vcf Only click these links if you trust the sender, as well as this message. --- 8< --- detachments --- 8< --- _______________________________________________ List info: http://lists.roundcube.net/users/

2 3

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users May 2009