Expand my Community achievements bar.

SOLVED

MTA service missing

Avatar

Level 1

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>

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @laxmi_narayanb8 

 

Open the pg admin and run this query.

 

create extension pgcrypto;

Let me know if that works..


     Manoj
     Find me on LinkedIn

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hello @laxmi_narayanb8 

 

Open the pg admin and run this query.

 

create extension pgcrypto;

Let me know if that works..


     Manoj
     Find me on LinkedIn

Avatar

Administrator

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!



Sukrity Wadhwa