Postfix file for mysql/mariadb on localhost instead of 127.0.0.1

I have updated debian to bookworm and the mariadb database with cluster jail (ISPConfig is at the current version 3.2.11), which communicates with the various nodes in ipv6, no longer accepts calls on 127.0.0.1 but only on localhost (or on :: ).

Is there any possibility to have all postfix config files (eg mysql-virtual_uids.cf etc) querying the database point to host=localhost instead of host=127.0.0.1 for future ISPConfig updates as well?

Or do you recommend acting on mariadib by unlocking access to 127.0.0.1?

Thanks a lot

 

That is, for example, I copy the mysql-virtual_uids.cf file containing all the settings plus my modification to host = localhost in the /usr/local/ispconfig/server/conf-custom/install/ folder (and so on for all the other modified files ) and at the next ISPConfig upgrade will I find the changes already made?

I ask Till for confirmation because I want to be sure of this new mechanism which also applies to the much more delicate dovecot.conf in the configuration for email synchronization between two servers.

Thanks a lot

 

For example, this is the code of the mysql-virtual_gids.cf.master file contained in the install/tpl folder of the ISPConfig tar.gz file

Code:

user = {mysql_server_ispconfig_user}
password = {mysql_server_ispconfig_password}
dbname = {mysql_server_database}
hosts = {mysql_server_ip}
query = SELECT gid FROM mail_user WHERE email = '%s' AND postfix = 'y' AND server_id = {server_id}
           AND EXISTS (SELECT domain_id FROM mail_domain WHERE domain = SUBSTRING_INDEX('%s', '@', -1) AND active = 'y' AND server_id = {server_id})

And this is the code from the same file modified with host = localhost which I have to put in the folder /usr/local/ispconfig/server/conf-custom/install/

Code:

user = {mysql_server_ispconfig_user}
password = {mysql_server_ispconfig_password}
dbname = {mysql_server_database}
hosts = localhost
query = SELECT gid FROM mail_user WHERE email = '%s' AND postfix = 'y' AND server_id = {server_id}
           AND EXISTS (SELECT domain_id FROM mail_domain WHERE domain = SUBSTRING_INDEX('%s', '@', -1) AND active = 'y' AND server_id = {server_id})

It's right?

Thanks a lot