Users October 2018

users@lists.roundcube.net

20 participants
15 discussions

Duplicated insert's for sessions in log's
by Jorge Bastos 17 Oct '18

17 Oct '18

Howdy, I've seen in the logs this info, and i'd like to know what triggers it. Would it be the same user logged in more than one place? (well the sessid should be different for sure) Was the user that closed the browser and opened it again in the same page? Another reason? To handle this what would be the best option, insert it using insert ignore or replace? Or should it be like this? Oct 17 18:33:36 fastweb roundcube: <i43tda9m> DB Error: [1062] Duplicate entry 'i43tda9m0k8a0dukdshmvoettq' for key 'PRIMARY' (SQL Query: INSERT INTO `session` (`sess_id`, `vars`, `ip`, `changed`) VALUES ('i43tda9m0k8a0dukdshmvoettq', 'dGVtcHxiOjE7bGFuZ3VhZ2V8czo1OiJwdF9QVCI7cmVxdWVzdF90b2tlbnxzOjMyOiJQYVZnYkx Za2dzQVJTbHlzN2VkT1VWTkJSN3lodFR2NiI7', '148.71.229.58', now())) in /home/hosting/dbbbbg.pt/webmail/program/lib/Roundcube/rcube_db.php on line 543 (GET /webmail/?_task=mail&_action=get&_mbox=INBOX&_uid=56841830&_token=d6qQ2Yvet5 ke0DMZEdqWzLZwVemCu2Y5&_part=5&_embed=1&_mimeclass=image)

1 0

unsubscribe
by jsmosc 08 Oct '18

08 Oct '18

unsubscribe

2 1

can't login after upgrade
by Meaulnes Legler ＠ roundcube 08 Oct '18

08 Oct '18

hello again I'm still having login problems on different sites on my webserver. On several sites, I upgraded from version 1.2.4 to 1.3.7 and since then, a login attempt says « _/*!*\_ Login failed ». Users at sites running RoundCube 1.2.4 have no problems. A.L.E.C. said, I should fix the database. How can I do this? I couldn't find any instructions online... Thank you and best regards _~_ '¿') `-´ Meaulnes Legler Zurich, Switzerland +41\0 44 260 16 60

5 9

Re: [RCU] can't login after upgrade
by Meaulnes Legler ＠ roundcube 08 Oct '18

08 Oct '18

On 08.10.18 14:37, Reindl Harald wrote: > Am 08.10.18 um 14:06 schrieb Meaulnes Legler@roundcube: >> _2nd question:_ how can I get more specific error messages as just a >> lapidary « _/!\_ Login failed » ? > have you ever considered to look at your maillog? > roundcube is just a client yes I did, it just says logged in and logged out. 502# less /var/log/maillog | grep username Oct 8 14:32:12 blue2 dovecot: imap-login: Login: user=, method=PLAIN, rip=94.103.xx.xx, lip=94.103.xx.xx, mpid=32040, secured, session=Oct 8 14:32:12 blue2 dovecot: imap(username): Logged out in=29 out=496 503# so I guess the login was correct but the session obviously doesn't last... > when you see no conenction your config is wrong, when you see > connections you see also what fails yeah well no clue why the session doesn't stay alive. Thank you and best regards _~_ '¿') `-´ Meaulnes Legler Zurich, Switzerland +41\0 44 260 16 60

1 0

Getting organization from ldap/AD into identity.
by Neil Price 04 Oct '18

04 Oct '18

This is what I've done. Seems to work. Hope it helps someone without crashing everything. Debian stretch standard package. --- /usr/share/roundcube/plugins/new_user_identity/new_user_identity.php.orig 2018-10-03 09:40:46.814463985 +0200 +++ /usr/share/roundcube/plugins/new_user_identity/new_user_identity.php 2018-10-04 15:08:42.176370477 +0200 @@ -33,8 +33,10 @@ if (count($results->records) == 1) { $user_name = is_array($results->records[0]['name']) ? $results->records[0]['name'][0] : $results->records[0]['name']; $user_email = is_array($results->records[0]['email']) ? $results->records[0]['email'][0] : $results->records[0]['email']; + $user_org = is_array($results->records[0]['organization']) ? $results->records[0]['organization'][0] : $results->records[0]['organization']; $args['user_name'] = $user_name; + $args['user_org'] = $user_org; $args['email_list'] = array(); if (!$args['user_email'] && strpos($user_email, '@')) { @@ -70,9 +72,8 @@ $identities = $this->rc->user->list_emails(); $ldap_entry = $this->lookup_user_name(array( 'user' => $this->rc->user->data['username'], - 'host' => $this->rc->user->data['mail_host'], + 'host' => $this->rc->user->data['mail_host'] )); - foreach ((array) $ldap_entry['email_list'] as $email) { foreach ($identities as $identity) { if ($identity['email'] == $email) { --- /usr/share/roundcube/program/lib/Roundcube/rcube_user.php.orig 2016-11-27 18:08:58.000000000 +0200 +++ /usr/share/roundcube/program/lib/Roundcube/rcube_user.php 2018-10-04 15:17:32.542990608 +0200 @@ -630,7 +630,7 @@ $user_name = $data['user_name']; $user_email = $data['user_email']; $email_list = $data['email_list']; - + $user_org = $data['user_org']; if (empty($email_list)) { if (empty($user_email)) { $user_email = strpos($data['user'], '@') ? $user : sprintf('%s@%s', $data['user'], $mail_domain); @@ -667,6 +667,7 @@ $record['user_id'] = $user_id; $record['standard'] = $standard; + $record['organization'] = $user_org; $plugin = $rcube->plugins->exec_hook('identity_create', array('login' => true, 'record' => $record));

1 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Users October 2018