Thank you! This will come in very handy!;)

Sent from my iPhone

On 19.11.2012, at 17:59, Thomas Bruederli thomas@roundcube.net wrote:

Hello

As this was asked quite a few times on the mailing lists and the forum, we now added a utility to help you changing settings stored in user preferences: bin/moduserprefs.sh

Usage: moduserprefs.sh [--user=user-id] pref-name [pref-value|--delete] --user User ID in local database --delete Unset the given preference

If for example you want to reset all your user's message listing order, simply execute

$ bin/userprefs.sh message_sort_col date

Beside changing user prefs you can also unset them and make all users fall back to the default value from the global configuration:

$ bin/userprefs.sh skin --delete

This new utility is currently only available in git-master but will be part of the upcoming 0.9-beta release.

I hope this helps to make a sysadmins life a bit easier...

Cheers, Thomas

---

Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users

Jordi Llonch wrote:

This will be very interesting to migrate users into a new machine.

It will be possible also to --export, --import? And user's address book?

No, that can easily be done with plain SQL.

The reason to create this script was the fact that user settings are stored as PHP-serialized string in the database and thus cannot be changed using SQL commands directly.

~Thomas

2012/11/20 Tache Madalin <niladam@gmail.com mailto:niladam@gmail.com>

Thank you! This will come in very handy!;)

Sent from my iPhone

On 19.11.2012, at 17:59, Thomas Bruederli <thomas@roundcube.net
<mailto:thomas@roundcube.net>> wrote:

> Hello
>
> As this was asked quite a few times on the mailing lists and the
forum, we
> now added a utility to help you changing settings stored in user
> preferences: bin/moduserprefs.sh
>
> Usage: moduserprefs.sh [--user=user-id] pref-name [pref-value|--delete]
> --user   User ID in local database
> --delete Unset the given preference
>
> If for example you want to reset all your user's message listing order,
> simply execute
>
> $ bin/userprefs.sh message_sort_col date
>
> Beside changing user prefs you can also unset them and make all users
fall
> back to the default value from the global configuration:
>
> $ bin/userprefs.sh skin --delete
>
> This new utility is currently only available in git-master but will
be part
> of the upcoming 0.9-beta release.
>
> I hope this helps to make a sysadmins life a bit easier...
>
> Cheers,
> Thomas
>
>
>
> _______________________________________________
> Roundcube Users mailing list
> users@lists.roundcube.net <mailto:users@lists.roundcube.net>
> http://lists.roundcube.net/mailman/listinfo/users
_______________________________________________
Roundcube Users mailing list
users@lists.roundcube.net <mailto:users@lists.roundcube.net>
http://lists.roundcube.net/mailman/listinfo/users

---

Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users

Cor Bosman wrote:

...

No, that can easily be done with plain SQL.

The reason to create this script was the fact that user settings are stored as PHP-serialized string in the database and thus cannot be changed using SQL commands directly.

Has there ever been a thought to change that into a key/value pair instead? Or would that create too much of a conversion hassle and maybe load on the db?

The values of user prefs itself can be complex structures instead of simple values. This makes it quite difficult to map them into SQL tables. Furthermore I prefer one read of one record instead of complex joins over multiple tables and iteration over hundreds of rows.

~Thomas