OPTUS_ADS: While deploying the Admax Campaign, getting access denied exception.

Prerequisite:

Disable the IPtables of smb1 server.

[gsingh@optus-qa-smb1 ~]$ sudo /etc/init.d/iptables stop

Flushing firewall rules: [ OK ]

Setting chains to policy ACCEPT: filter [ OK ]

Unloading iptables modules: [ OK ]

------------------------------------------------------------------------------------------------

Soap request is attached .

-----------------------------------------------------------------------------------------------

SOAP response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body>

<ns2:deployCampaignsResponse xmlns:ns2="http://www.thesearchagency.com/AdMaxDeploymentService/">

<header>

<requestID>2</requestID>

<retryID>2</retryID>

</header>

<result>

<resultCode>queued</resultCode>

<resultString>queued</resultString>

</result>

</ns2:deployCampaignsResponse>

</soap:Body>

</soap:Envelope>

Listener shows access denied exception.

• • tail -f /tmp/jmslistener.out === detailed log attached===

2012-02-14 07:03:46.395 (4) [P3T1]: DataCache: Found key global-sesystem

2012-02-14 07:03:46.400 (2) [P3T1]: Exception [creating pooled Database]:java.sql.SQLException: Access denied for user 'spike'@'50-57-178-216.static.cloud-ips.com' (using password: YES)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2670)

at com.mysql.jdbc.Connection.<init>(Connection.java:1531)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at com.carldunham.jst.db.Database.init(Database.java:203)

at com.carldunham.jst.db.Database.<init>(Database.java:188)