MTA service missing

Avatar

Avatar
Level 1
laxmi_narayanb8
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
laxmi_narayanb8
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
laxmi_narayanb8
Level 1

19-07-2021

Hi,

 

I am getting MTA service missing message on my system. When I start the MTA service using command line I get below error message.

C:\windows\system32>nlserver start mta@lax
13:51:18 > Application server for Adobe Campaign Classic (7.0 19.1 build 9032@d3b452f) of 01/07/2021
13:51:18 > Launching task 'mta@lax' ('nlserver mta -tracefile:mta@lax -instance:lax -detach -tracefilter:nlmta') in a new process
13:51:18 > Application server for Adobe Campaign Classic (7.0 19.1 build 9032@d3b452f) of 01/07/2021
13:51:18 > Starting main MTA (pid=9836, tid=7340)...
13:51:19 > Starting 1 connection(s) on pool 'default lax' (PostgreSQL, server='localhost', login='lax_usr:lax_db')
13:51:19 >>> PGS-220000 PostgreSQL error: ERROR: function digest(text, unknown) does not exist
LINE 1: SELECT encode(digest($1, 'md5' ), 'hex')
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT encode(digest($1, 'md5' ), 'hex')
CONTEXT: PL/pgSQL function md5digest(text) line 3 at RETURN
(iRc=-2006)
13:51:19 >>> WDB-200001 SQL statement 'SELECT Md5Digest(:#(1)#) FROM XtkOption O0' could not be executed.
Param(0)=test (iRc=-2006)
13:51:19 >>> XSV-350184 Function 'Md5Digest' cannot be accessed. Check that the database was installed. (iRc=-53)
13:51:19 > Stopping main MTA (pid=9836, tid=7340)...

 

Please find the config details and kindly help to make to work.

ServerConf.xml

<mailExchanger mxAddress="127.0.0.1" mxPort="25"/>

<dnsConfig localDomain="mail.local" nameServers="127.0.0.1" retry="4" timeout="5000"/>

<relay address="mail.local" port="25"/>

 

Config-lax.xml

 

<?xml version='1.0'?>
<serverconf>
<shared>
<dataStore hosts="*" lang="en-US" uploadWhitelist="(?i).*\.(jpg|jpeg|png|favicon|xml|gif|bmp|txt|tab|csv|css|htm|html|zip|pdf|ppt|pptx|xls|xlsx|doc|docx|odt|p12)">
<dataSource name="default">
<dbcnx encrypted="1" login="lax_usr:lax_db" password="@1lMYXwlKNERexI3jMXP5Zw=="
provider="PostgreSQL" server="localhost"/>
</dataSource>
</dataStore>
<module defaultNameSpace="lax"/>
<urlPermission/>
</shared>

<mta autoStart="true" statServerAddress="localhost:8080">
<child>
<smtp>
<IPAffinity name="default,mid.default,dev.default,test.default">
<!-- For dev instances, if you need a default IP (not recommended), use address="0.0.0.0" -->
<IP address="0.0.0.0" heloHost="" publicId="" weight="1"/>
</IPAffinity>
</smtp>
</child>
</mta>

<stat autoStart="true"/>
<wfserver autoStart="true"/>
<inMail autoStart="false"/>
<sms autoStart="false"/>
<interactiond autoStart="false"/>

<web>
<redirection IMSOrgId="" databaseId="uFE80000000000000194170DE3E427DBD0017CED9"
trackingPassword="@8bOGYvHNf6UXDMupa16cKQ=="/>
<relay/>
</web>

<securityZone name="public">
<securityZone name="vpn">
<!-- Add customer specifc IPs here, HTTPS access will be mandatory to login
<subNetwork name="Cus1" mask="x.x.x.x/y"/>
-->
</securityZone>
</securityZone>
</serverconf>

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

129 likes

Total Posts

329 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

129 likes

Total Posts

329 posts

Correct reply

104 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

19-07-2021

Hello @laxmi_narayanb8 

 

Open the pg admin and run this query.

 

create extension pgcrypto;

Let me know if that works..

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

181 likes

Total Posts

955 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

181 likes

Total Posts

955 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

28-07-2021

Hi @laxmi_narayanb8,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!