Re: [RCU] Shell script to modify user preferences

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