Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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..

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..

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!