[RCU] Reset RC settings to default

absolutely_free at libero.it absolutely_free at libero.it
Wed Oct 11 20:20:47 CEST 2017


Hi,

yes I did. But I don't know pretty much RC internals :)

After next user's login, will his user_id be recreated?

In case, is it necessary to manually modify contacts table to make address book working again for specific user?


Thank you very much

> 
>     Il 11 ottobre 2017 alle 10.55 Reindl Harald <h.reindl at thelounge.net> ha scritto:
> 
>     Am 11.10.2017 um 10:50 schrieb absolutely_free at libero.it:
> 
>         > > 
> >         is there a way to reset RC settings for some user?
> > 
> >         I am using RC 1.1.9 with MySQL backend
> > 
> >     > 
>     did you even try to look at the database?
>     just delete the database record for the user
> 
>     MariaDB [roundcube_db]> show fields from users;
>     +----------------------+------------------+------+-----+---------------------+----------------+
>     | Field | Type | Null | Key | Default
>     | Extra |
>     +----------------------+------------------+------+-----+---------------------+----------------+
>     | user_id | int(10) unsigned | NO | PRI | NULL
>     | auto_increment |
>     | username | varchar(128) | NO | MUL | NULL
>     | |
>     | mail_host | varchar(128) | NO | | NULL
>     | |
>     | created | datetime | NO | | 1000-01-01
>     00:00:00 | |
>     | last_login | datetime | YES | | NULL
>     | |
>     | language | varchar(5) | YES | | NULL
>     | |
>     | preferences | longtext | YES | | NULL
>     | |
>     | failed_login | datetime | YES | | NULL
>     | |
>     | failed_login_counter | int(10) unsigned | YES | | NULL
>     | |
>     +----------------------+------------------+------+-----+---------------------+----------------+
>     9 rows in set (0.00 sec)
> 
>     MariaDB [roundcube_db]> select * from users where
>     username='h.reindl at thelounge.net';
>     +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+
>     | user_id | username | mail_host | created |
>     last_login | language | preferences
> 
>     | failed_login | failed_login_counter |
>     +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+
>     | 1 | h.reindl at thelounge.net | 127.0.0.1 | 2012-03-03 01:50:57 |
>     2017-09-24 21:44:54 | de_DE |
>     a:10:{s:11:"client_hash";s:32:"5b9d50d7dc8b4ffecc3b348d1c96cc04";s:11:"search_mods";a:5:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:4:"Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:6:"Drafts";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:5:"gmail";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:5:"INBOX";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}}s:16:"message_sort_col";s:4:"date";s:18:"message_sort_order";s:4:"DESC";s:9:"list_cols";a:7:{i:0;s:7:"threads";i:1;s:7:"subject";i:2;s:4:"from";i:3;s:4:"date";i:4;s:4:"size";i:5;s:10:"attachment";i:6;s:8:"priority";}s:22:"preview_pane_mark_read";i:5;s:10:"keep_alive";i:60;s:10:"prettydate";b:0;s:9:"junk_mbox";s:4:"junk";s:20:"default_imap_folders";a:5:{i:0;s:5:"INBOX";i:1;s:6:"Drafts";i:2;s:4:"Sent";i:3;s:4:"junk";i:4;s:5:"Trash";}}
>     | NULL | NULL |
>     +---------+------------------------+-----------+---------------------+---------------------+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+----------------------+
>     1 row in set (0.00 sec)
> 
>     MariaDB [roundcube_db]>
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20171011/f0d98d42/attachment.html>


More information about the users mailing list