Unfortunately the connect engine doesn't allow stored procedures or functions either.

I guess I will need to just script the changes and use the expect or some other cli based driver. Thanks.

I am trying to update multiple tables when someone changes their password. Because the second table is external via the connect engine in mariadb, I can't use a trigger to update it.
I have been trying to update the sql query to handle both updates, but it fails even thought the query is valid. Yes, I have disabled password encryption for the moment for troubleshooting.

Is there an easier way to have the password plugin run multiple queries or dealing with multiple dsn's?

$config['password_query'] = "UPDATE mailbox SET password=%P,plain_password=%p,passwordlastchange=NOW() WHERE username=%u;update email_data set password =%p where emailaddr=%u";

Mar  9 10:40:15 mail roundcube: <0f5vgmc9> DB Error: [1064] You have an error in your SQL syntax; check the manual that correspo
nds to your MariaDB server version for the right syntax to use near 'update email_data set password ='etstetst' where emailaddr='sup
ertest@domain...' at line 1 (SQL Query: UPDATE mailbox SET password='{PLAIN}etstetst',plain_password='etstetst',passwordlastchange=
NOW() WHERE username='supertest@domain.com' ;update email_data set password ='etstetst' where emailaddr='supertest@domain.com') in
 /opt/www/roundcubemail-1.6.5/program/lib/Roundcube/rcube_db.php on line 577 (POST /mail/?_task=settings&_action=plugin.password-sav
e)

The subscriptions_option plugin works fine for me. Lets confirm you setup.

You have added subscriptions_option to your `$config['plugins']` array. You have set `$config['use_subscriptions'] = false;` to disable the use of subscriptions and then you added `use_subscriptions` to your `$config['dont_override']` array to prevent the user from changing this setting?

If you are currently logged in your will need to logout and back in again once you have set `$config['use_subscriptions'] = false;`

I'll take a look at our IMAP server and see if there is a special-use IMAP extension. Would you mind expanding on how this might help Roundcube "check the box" automatically for folders which are not currently subscribed?

I don't know how much difference it will make to existing users but think of it like this. When a client connects to the server the server tells it "use x folder for deleted, y folder for junk, etc" the client will show those folder and use them as instructed rather than creating its own. The user can override it and configure the client to use the folders they want but its provides a default which would be the same across clients to save the user doing it manually.

you have an usual looking config file. it appears to have values from before and after version 1.6 see this announcement about the changes https://roundcube.net/news/2022/07/28/roundcube-1.6.0-released. may be because you are using both old and new names the backwards compatibility stuff is getting confused and giving unexpected results

Thanks for the quick response.

Hmmm, I do not see roundcube listed when I do a 'apt list --installed' or 'snap list'.

In any case, how do recommend a clean install restoring my config and db? I like standard and

I am thinking
 - backup, drop, install roundcube, and restore my postgresql roundcube database
 - save and restore all config files in /etc/roundube
 - anything in Apache?
 - anything else?

Here is what I have in /etc/roundcube

apache.conf
config.inc.php
config.inc.php.ucf-dist
config.old.php
debian-db.php
debian-db-roundcube.php
defaults.inc.php
defaults.inc.php.dpkg-dist
htaccess
lighttpd.conf
mimetypes.php
plugins