Users

users@lists.roundcube.net

6 participants
2896 discussions

Roundcube can't catch last_insert_id of users table
by Daniel Jäger 24 Oct '09

24 Oct '09

Hi Folks, hope I'm right with my topic on this list. Go some weird problems with the auto_create_users feature. On the "first" Login there should be a new user created to the users table. But I can't login and the errors log gives me following. [24-Oct-2009 19:47:41 +0200]: PHP Error: Failed to create new user in / var/www/ispcp/gui/tools/webmail/program/include/rcube_user.php on line 452 (POST /webmail/?_task=&_action=login) [24-Oct-2009 19:47:41 +0200]: PHP Error: Failed to create a user record. Maybe aborted by a plugin? (POST /webmail/?_task=&_action=login) If I go to the Line 452 and look at the source I see that this condition returns a false and so the error is pushed: if ($user_id = $dbh->insert_id('users')) So in the end I don't get the Insert ID of the created user back. But the Server does the insert correctly - there are now about 17 entries of the same mail address in the table. If I try to echo the $dbh->insert_id('users') value, its null. But if I do the insert manually and do a SELECT LAST_INSERT_ID(); it works... so I don't really see whats the point?! Has anyone of you experienced the same? All other Logs (imap, SQL) dont signalise me that there would be something wrong. At the end my Config of MySQL and PHP. Got PHP 5.3,0, self compiled with: './configure' \ '--with-pear=/usr/local/lib/php' \ '--sysconfdir=/etc/php5' \ '--with-config-file-path=/etc/php5' \ '--with-libxml-dir' \ '--with-pcre-regex' \ '--with-mysql' \ '--with-mysqli' \ '--with-zlib' \ '--with-zlib-dir' \ '--with-gd' \ '--with-png-dir' \ '--with-xpm-dir' \ '--enable-gd-native-ttf' \ '--with-gdbm' \ '--enable-ftp' \ '--with-mcrypt' \ '--enable-calendar' \ '--enable-wddx' \ '--with-jpeg-dir' \ '--enable-bcmath' \ '--enable-shmop' \ '--with-pdo-mysql' \ '--with-mhash' \ '--with-openssl' \ '--with-xsl' \ '--with-ldap' \ '--with-ldap-sasl' \ '--enable-dom' \ '--with-curl' \ '--with-iconv' \ '--with-freetype-dir' \ '--with-bz2' \ '--with-gettext' \ '--enable-exif' \ '--enable-mbstring=all' \ '--with-kerberos' \ '--with-sqlite' \ '--enable-zip' \ '--enable-sockets' \ '--enable-shared' \ '--enable-sqlite-utf8' \ '--enable-soap' \ MySQL is 5.0.51a-24+lenny2 - standard debian package Best regards Daniel Jäger _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

problem with login after upgrade to 0.3 (password crypted?)
by Giorgio Volpe 23 Oct '09

23 Oct '09

I've just upgraded from 0.2 to 0.3 I'can no more log in ... Activating $rcmail_config['imap_debug'] = true; I can see in the log file <log_dir>/imap that rc sends to the IMAP server the password not as is but " crypted(?) and the server refuses it [23-Oct-2009 23:02:23 +0200]: C: cp01 CAPABILITY [23-Oct-2009 23:02:23 +0200]: S: * CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS [23-Oct-2009 23:02:23 +0200]: S: cp01 OK CAPABILITY completed [23-Oct-2009 23:02:23 +0200]: C: a001 LOGIN "spa" "î`ovG" [23-Oct-2009 23:02:30 +0200]: S: a001 NO Login failed. "î`ovG" is not my password! If I telent the server with the plain real password it logs in!? /etc/roundcube# telnet localhost 143 Trying 127.0.0.1... Connected to movifvg. Escape character is '^]'. * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready. Copyright 1998-2008 Double Precision, Inc. See COPYING for distribution information. a001 login "spa" "realplainpasswd" a001 OK LOGIN Ok. Any help? thanks giorgio _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Tiago Gomes convidou você para abrir uma conta de e-mail do Google
by Tiago Gomes 20 Oct '09

20 Oct '09

Estou usando o Gmail e acho que vale a pena conferir. Isto é um convite para você criar uma conta. ----------------------------------------------------------------------- Tiago Gomes convidou você para abrir uma conta grátis do Gmail. Para aceitar esse convite e abrir sua conta, visite http://mail.google.com/mail/a-cb6ed28a0f-b0447f0e64-ba8cd8f00546bfa3 Uma vez criada a sua conta, Tiago Gomes será notificado do seu novo endereço de e-mail para que vocês possam manter contato através do Gmail! Caso você ainda não tenha ouvido falar do Gmail, trata-se de um novo serviço de webmail com recurso de pesquisa. O Gmail tem: - Mais de 2.700 megabytes (dois gigabytes) de armazenamento grátis - Recurso de pesquisa Google para procurar instantaneamente qualquer mensagem - Organização automática de mensagens e respostas correspondentes em forma de "conversas" - Proteção eficaz contra spam baseada em tecnologia de ponta do Google - Zero anúncios grandes e inoportunos; só pequenos anúncios em texto e páginas relacionadas ao conteúdo das suas mensagens Para saber mais sobre o Gmail antes de se inscrever, visite: http://mail.google.com/mail/help/intl/pt_BR/benefits.html Continuamos a trabalhar constantemente para melhorar o Gmail, por isso, às vezes pediremos seus comentários e sugestões. Esperamos que você goste do Gmail. E ele vai ficar cada vez melhor. Obrigado, A Equipe do Gmail (Se você clicar nos URLs desta mensagem e eles não funcionarem, copie-os e cole-os na barra de endereços de seu navegador.) _______________________________________________ List info: http://lists.roundcube.net/users/

2 1

Date Sorting Acting Up in IMAP Folders
by Keith Schonrock 15 Oct '09

15 Oct '09

I am using the SVN trunk version (3044) of Roundcube and I am seeing some weird behavior with Roundcube in my IMAP folders. I am not having any performance issues, but I am getting messages out of order. I basically want to have the newest messages at the top of the list and then go backward from there in reverse order by date. (i.e. newest -> oldest). I am seeing that behavior for most messages, but the ones from the past 1/2 month or so are showing up at the end of the list when they should be at the top of the list. I recently moved all my mail (via Thunderbird) from Thunderbird folders to IMAP folders. The dates listed in the date column are all correct, but could the sorting dates have gotten messed up? Any way to check this and correct it? Thanks for any ideas or assistance. _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

Roundcube + Active directory
by bely junior 13 Oct '09

13 Oct '09

Hi , I am trying to configure roundcube to query the address book directly in AD. my conf below. main.inc.php $rcmail_config['ldap_public']['Intra'] = array( 'name' => 'Intra', 'hosts' => array('ip domain controler'), 'port' => 3268, 'base_dn' => 'DC=dominio,DC=com', 'bind_dn' => 'user(a)dominio.com', 'bind_pass' => '12345', 'search_fields' => array('mail', 'cn'), 'name_field' => 'cn', 'email_field' => 'mail', 'surname_field' => 'sn', 'firstname_field' => 'givenName', 'scope' => 'sub', 'filter' => '(mail=*)', 'fuzzy_search' => true ); but when I try to see the address book for roundcube returns the following error: Internal Server Error somebody have idea about this ? sorry my bad english. thanks. -- Bely Silva Junior _______________________________________________ List info: http://lists.roundcube.net/users/

3 3

Roundcube + Active directory
by bely junior 13 Oct '09

13 Oct '09

Hi , I am trying to configure roundcube to query the address book directly in AD. my conf below. main.inc.php $rcmail_config['ldap_public']['Intra'] = array( 'name' => 'Intra', 'hosts' => array('ip domain controler'), 'port' => 3268, 'base_dn' => 'DC=dominio,DC=com', 'bind_dn' => 'user(a)dominio.com', 'bind_pass' => '12345', 'search_fields' => array('mail', 'cn'), 'name_field' => 'cn', 'email_field' => 'mail', 'surname_field' => 'sn', 'firstname_field' => 'givenName', 'scope' => 'sub', 'filter' => '(mail=*)', 'fuzzy_search' => true ); mas quando tento consultar os catalogo de endereços pelo roundcube retorna o seguinte erro : erro interno do servidor somebody have ideia about this ? thanks. -- Bely Silva Junior _______________________________________________ List info: http://lists.roundcube.net/users/

2 1

Help Troubleshooting Caching Problem
by Aaron C. de Bruyn 12 Oct '09

12 Oct '09

I'm looking for a little guidance troubleshooting a caching problem. I have an old linux box (2 GHz / 512 MB RAM) setup for a client running postfix, dovecot, and roundcube. They ran RoundCube 0.2 for a year without reporting any issues. I recently upgraded them to RoundCube 0.3 (which they love by the way) and they started reporting this strange issue: UserA would login, check their mail, read/reply and delete everything in their inbox. UserA would stay logged in throughout the day. At some point, a new message or messages would arrive for UserA. According to the mail logs, the message(s) would be correctly delivered into UserA's inbox via Dovecot's deliver app. UserA would not see the message in RC. UserA would try hitting send/receive, switch to different folders and then back to the inbox, and even logging out/logging back in. The message would still not show up in RC. At some point, one of two things happens that resolves the issue: * UserA waits for a while (a few minutes to a few days) and the message suddenly appears. * UserA sends a new message to someone (anyone) and after it's sent the missing message(s) immediately show up in their inbox. A few things I have checked: * Not on an NFS filesystem. Mail is stored on a local ext3 partition. * While UserA is not seeing the new messages, I have verified the messages actually exist and have the correct permissions on the filesystem. * cleared the 'cache', 'messages', and 'session' tables in the RC database. * Mail logs definitely show messages arriving and being delivered even though I can't see the message in RC. * If I have both RC and Thunderbird open at the same time, I can see the message immediately in Thunderbird, but not RC. Disabling RC's caching via $rcmail_config['enable_caching'] = FALSE; fixes the problem and prevents it from happening again. I'm stumped on the next step. I have no problem leaving caching disabled because none of our users have more than 100 messages in any one folder and RC is running on the same machine that dovecot is running on. But I would like to figure out if this is something I screwed up, or maybe something in the RC code. Any pointers on what to check next? (I'm not that familiar with the RC code, but I can do some PHP hacking/debugging if needed.) Thanks for everyone's hard work by the way. RoundCube is the best open source webmail app I have ever used. -A _______________________________________________ List info: http://lists.roundcube.net/users/

2 1

Why is roundcube connecting over TLS, even though configuration is set to not do TLS?
by Russell Jones 11 Oct '09

11 Oct '09

It appears that roundcube is connecting to the local SMTP server over TLS, even though I explicitly set it to not use SSL or TLS: // 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/TLS connection, enter hostname with prefix ssl:// or tls:// $rcmail_config['default_host'] = 'localhost'; Postfix logs showing the TLS connection being established, example.com replacing the innocent domains: Oct 11 01:20:26 server2 postfix/smtpd[12765]: connect from localhost.localdomain[127.0.0.1] Oct 11 01:20:26 server2 postfix/smtpd[12765]: setting up TLS connection from localhost.localdomain[127.0.0.1] Oct 11 01:20:26 server2 postfix/smtpd[12765]: TLS connection established from localhost.localdomain[127.0.0.1]: TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits) Oct 11 01:20:26 server2 postfix/smtpd[12765]: 7D1563BD48: client=localhost.localdomain[127.0.0.1], sasl_method=LOGIN, sasl_username=russell(a)example.com Oct 11 01:20:26 server2 postfix/cleanup[12769]: 7D1563BD48: warning: header Subject: asdasddsa from localhost.localdomain[127.0.0.1]; from=<russell(a)example.com> to=<rjones(a)example.com> proto=ESMTP helo=<www.example.com> I think it's great and all that it is so ambitious, but I was really hoping it would do what I told it to do :) What am I missing here? _______________________________________________ List info: http://lists.roundcube.net/users/

3 2

problem with old old stable version 0.1.1
by fakessh＠fakessh.eu 09 Oct '09

09 Oct '09

Hi all Hi list my linux box is CentOS 5.3 it is properly updated I use the old old stable version 0.1.1 of roundcubemail , which is contained in the deposit EPEL I preferred to continue using the version contained in the official repositories of CentOS I configure a user roundcubemail on my mysql server Here are the commands that I have applied to the server mysql mysql -u roundcubemail -p create database roundcubemail; GRANT SELECT, INSERT, UPDATE, DELETE ON roundcubemail.* TO 'roundcubemail'@'localhost' IDENTIFIED BY '*****'; FLUSH PRIVILEGES; quit I applied a small patch personal // application constants define('RCMAIL_VERSION', '0.1.1'); define('RCMAIL_CHARSET', 'UTF-8'); define('JS_OBJECT_NAME', 'rcmail'); // define global vars $OUTPUT_TYPE = 'html'; $INSTALL_PATH = dirname(__FILE__); $MAIN_TASKS = array('mail','settings','addressbook','logout'); if (empty($INSTALL_PATH)) $INSTALL_PATH = './'; else $INSTALL_PATH .= '/'; //This is the little patch that clears the session cookie if ( isset($_COOKIE['session']) and !empty($_COOKIE['session'] )) { setcookie('session'); unset($_COOKIE['session']); //sureté } //This is the little patch that clears the session cookie my problem is that I see appear the login page I enter all data but I do not understand why I can not fit into the webmail thanks for all your feedback SL nb : 'Buddha' peace themselve _______________________________________________ List info: http://lists.roundcube.net/users/

1 0

roundcube + AD
by bely junior 09 Oct '09

09 Oct '09

My Mailserver (Debian/postfix/dovecot) use authentication against Active Directory, but I had installed roundcubemail and I wonder if it is possible to fill in the fields with the identity data from AD? thanks -- Bely Silva Junior _______________________________________________ List info: http://lists.roundcube.net/users/

3 4

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users