Connection to SMTP fails under IPv4
Article ID: 145489
Updated On:
Products
Issue/Introduction
Connection to SMTP fails after upgrade to v12.1 or higher when the environment only accepts IPv4 communication and IPv6 is disabled.
U00050029 The SMTP client cannot connect to the SMTP server 'LOCALHOST', error code '111', error description: 'Connection refused'.
This happens after an upgrade to v12.1 or higher
Another way this has presented itself is:
System going down, WPs dropping and unable to come back up. The messages in the log file may show something like:
20200609/110606.021 - U00011619 Processing SRVQUERY inquiry from 'FQDN.here.com'. F-Addr = 'FQDN.here.com', BTable = 'MQ1CP001', Index = '0000000005'
20200609/110606.052 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.099 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.114 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.161 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
20200609/110606.177 - U00005118 Program error: Database access via key 'RH_AH_Idnr' with value 0 in module 'UCUREP'.
and a database=3, tcp/ip=2 trace could show:
20200609/110606.380 - STRT UCUVAR OPC: 0209 entry='ucuvar' user-idnr=0000000005 client=0000000000 varname='UC_CLIENT_SETTINGS' wert=' ' text= typ='C' gb-name='FREI' gb-w='SMTP_LOGIN'
20200609/110606.380 - U00009909 TRACE: (BINDPAR: OVW_OH_Idnr ) 00007FFCA9C7A36C 000004
00000000 24000000 >$...<
20200609/110606.380 - >36<
20200609/110606.380 - U00009909 TRACE: (BINDPAR: OVW_VValue ) 00007FFCA9C7A370 000010
00000000 534D5450 5F4C4F47 494E >SMTP_LOGIN<
20200609/110606.380 - select max(datalength(case when OVW_Value1 is Null then cast('0' as varchar(1)) else OVW_Value1 end)), max(datalength(case when OVW_Value2 is Null then cast('0' as varchar(1)) else OVW_Value2 end)), max(datalength(case when OVW_Value3 is Null then cast('0' as varchar(1)) else OVW_Value3 end)), max(datalength(case when OVW_Value4 is Null then cast('0' as varchar(1)) else OVW_Value4 end)), max(datalength(case when OVW_Value5 is Null then cast('0' as varchar(1)) else OVW_Value5 end)) FROM OVW WHERE OVW_OH_Idnr = ? AND OVW_VValue = ?
20200609/110606.380 - U00009909 TRACE: (BINDPAR: OVW_OH_Idnr ) 00007FFCA9C7A36C 000004
00000000 24000000 >$...<
20200609/110606.380 - >36<
20200609/110606.380 - U00009909 TRACE: (BINDPAR: OVW_VValue ) 00007FFCA9C7A370 000010
00000000 534D5450 5F4C4F47 494E >SMTP_LOGIN<
20200609/110606.380 - SELECT TOP 1 OVW_OH_IDNR,OVW_VVALUE,OVW_OH_CLIENT,OVW_VRNAME,OVW_Value1,OVW_Value2,OVW_Value3,OVW_Value4,OVW_Value5 FROM OVW WHERE OVW_OH_Idnr = ? AND OVW_VValue = ?
20200609/110606.380 - UCUDB32 SLBL RET 0000 HSTMT: 0000000000B9E210 VALUE: 0000000000000032 ALL: 0.00181 DB: 0.00129 ODBC: 0.00033 UDB: 0.00019
20200609/110606.380 - UCUDB32 READ RET 0001 HSTMT: 0000000000B9E210 VALUE: 0000000000000000 ALL: 0.00038 DB: 0.00038 ODBC: 0.00000 UDB: 0.00000
20200609/110606.380 - UCUDB32 CLST RET 0000 HSTMT: 0000000000B9E210 VALUE: 0000000000000000 ALL: 0.00032 DB: 0.00000 ODBC: 0.00031 UDB: 0.00001
20200609/110606.380 - U00009909 TRACE: (PRIMKEY: OVW_OH_Idnr ) 00007FFCA9C7A36C 000004
00000000 24000000 >$...<
20200609/110606.380 - >36<
20200609/110606.380 - U00009909 TRACE: (PRIMKEY: OVW_VValue ) 00007FFCA9C7A370 000010
00000000 534D5450 5F4C4F47 494E >SMTP_LOGIN<
20200609/110606.380 - UCUDB32 CPTC RET 0000 HSTMT: 0000000000000000 VALUE: 0000000000000000 ALL: 0.00003 DB: 0.00000 ODBC: 0.00000 UDB: 0.00003
20200609/110606.380 -
20200609/110606.380 - EXIT UCUVAR RET: 0000000000 TIME: 0000,00498 RETTEXT=' ' varname='UC_CLIENT_SETTINGS' wert=' ' text=' ' typ='C' gb-name='FREI' gb-w='SMTP_LOGIN''
20200609/110606.380 - EXIT UCUECS RET: 0000000000 TIME: 0000,00936 RETTEXT=', VALUE='
20200609/110606.380 - STRT UCUOHC OPC: 0204 oh-idnr=0000000000 client=1000 oh-name='' cache-size=0000000000
20200609/110606.380 - EXIT UCUOHC RET: 0000000001 TIME: 0000,00001 RETTEXT='' oh-idnr=0000000000 client=1000 oh-name='' cache-size=0000524288 deleteflag=00000 otype=''''
20200609/110606.380 - STRT UCUOHC OPC: 0204 oh-idnr=0000000000 client=0000 oh-name='' cache-size=0000000000
20200609/110606.380 - EXIT UCUOHC RET: 0000000001 TIME: 0000,00000 RETTEXT='' oh-idnr=0000000000 client=0000 oh-name='' cache-size=0000524288 deleteflag=00000 otype=''''
20200609/110606.380 - STRT UCMAIL OPC: 0003 server=smtp.FQDN.com [email protected]
Environment
Release : v12.1 / v12.2 / v12.3
Component : AUTOMATION ENGINE
Cause
Resolution
Workaround:
- It sometimes works to comment the IPv6 address in /etc/hosts
- Another workaround is to use an IP address rather than fully qualified domain name in the STMP_SERVER setting in UC_CLIENT_SETTINGS
- This may need to be done through a direct update to the database if the system is not running
Solution:
Update to a fix version listed below or a newer version if available.
Fix version:
Component(s): Automation Engine
Automation.Engine 12.3.1 - Available
Automation.Engine 12.1.7 - Available
Automation.Engine 12.2.5 - Available
Automation.Engine 12.2.3 HF3 - Available
Feedback
