webmail roundcube with sqlite : possible to change settings for all email users ?

Markif

• April 29, 2022 13:19

Hello There are default settings in /usr/local/cpanel/base/3rdparty/roundcube/config/config.inc.php and /usr/local/cpanel/base/3rdparty/roundcube/config/defaults.inc.php but if I don't make a mistake they are only used for creating a new user sqlite db /home/USER/etc/DOMAIN/EMAIL.rcube.db Is it possible to change some options in already existing sqlite db profiles without loosing what the mailusers have already set in it. For example : changing the default language without having to go in all webmail interfaces :) I've found treads about this but it applies to the time where it was a mysql database, but I did not find examples for sqlite db I've seen there is a script to "rebuild" the sqlite db, but does this not erase what user has already put in it ? Thanks !

• 

  cPRex Jurassic Moderator

  • April 29, 2022 18:44

  Hey there! I don't have any ready-made tools to perform that type of work. Since each user has a unique profile, this is typically done at the user level. You may find the following article helpful for working with SQLite databases in general while you explore solutions for this issue:

  0
• 

  Markif

  • April 29, 2022 21:28

  Thanks for the link. The language data is stored in the "users" table of the sqlite db. witch has a simple structure If "preferences" is a serialized array, the "language" field, is separate and directly accessible. So this did work Seems I can't include code here, so a link to a simple script as base

  0

Please sign in to leave a comment.