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>
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @laxmi_narayanb8
Open the pg admin and run this query.
create extension pgcrypto;
Let me know if that works..
Hello @laxmi_narayanb8
Open the pg admin and run this query.
create extension pgcrypto;
Let me know if that works..
Thanks Manoj. This works!!
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies