Incorrect Template - mysql-virtual_outgoing_bcc.cf and .cf.master
Hi,
I have updated to ISPConfig-3.1.0.tar.gz - Stable Release.
Afterwards I was having problems with mysql-virtual_outgoing_bcc.cf trying to connect to SQL at loopback. My installation doesn't have any local SQL servers which would account for the failure.
Looking at the install template files within the .gz distribution file it would appear loopback is hard coded instead of using hosts = {mysql_server_database] variable.
in install/tpl folder
cat mysql-virtual_outgoing_bcc.cf
user = {mysql_server_ispconfig_user} password = {mysql_server_ispconfig_password} dbname = {mysql_server_database} table = mail_user select_field = sender_cc where_field = email additional_conditions = and postfix = 'y' and disabledeliver = 'n' and disables$ hosts = 127.0.0.1
cat mysql-virtual_outgoing_bcc.cf.master
user = {mysql_server_ispconfig_user} password = {mysql_server_ispconfig_password} dbname = {mysql_server_database} table = mail_user select_field = sender_cc where_field = email additional_conditions = and postfix = 'y' and disabledeliver = 'n' and disablesmtp = 'n' and sender_cc != '' hosts = 127.0.0.1
cat mysql-virtual_mailboxes.cf.master
user = {mysql_server_ispconfig_user} password = {mysql_server_ispconfig_password} dbname = {mysql_server_database} table = mail_user select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') where_field = login additional_conditions = and postfix = 'y' and server_id = {server_id} hosts = {mysql_server_ip}