Error connecting to MySQL database for Data Deploy on OD UI using DAS

I am not able to connect to the database coz of some userID & password relevant issue,workin on TS6.5.

DAS: login : sa
DAS: login timeout=3
DAS: Connecting to the database...
DAS: Try connecting using jdbc:mysql://10.76.118.189:3306/nikhil...
DAS: SQL failure
DAS: ERROR:ERROR: Could not connect to[jdbc:mysql://10.76.118.189:3306/nikhil]
*******************************************************
DAS: SQLException occured in JdbcCheckup:MakeConnection()
DAS: Exception Message: Access denied for user 'sa'@'punitp54710d.ad.infosys.com' (using password: YES)
DAS: Vendor Error Code: 1045
DAS: SQL state: 28000
DAS: *******************************************************
DAS: *******STACK TRACE*************
java.sql.SQLException: Access denied for user 'sa'@'punitp54710d.ad.infosys.com' (using password: YES)
//skipped//
DAS: ERROR:Could not connect to [10.76.118.189:3306/nikhil]
DAS: ERROR:Unable to connect to 10.76.118.189:3306/nikhil
DAS: ERROR:TDbAgent constructor failed.
DAS: Error occured in TDbSchemaSynchronizer
DAS: ERROR:TDbSchemaSynchronizer create failure.
DAS: Stat for group [template]:
DAS: -----------------------------------
DAS: Rows inserted : 0
DAS: Rows updated : 0
DAS: Rows deleted : 0
DAS: Rows failed : 0
DAS: Rows rolled back : 0
DAS: Rows skipped : 0
DAS: -----------------------------------
DAS: Rollback database [10.76.118.189:3306/nikhil]...
DAS: Deployment[basearea]
DAS: Started : Fri Mar 16 11:56:21 IST 2007
DAS: Finished: Fri Mar 16 11:56:21 IST 2007
DAS:
### IWDataDeploy FAILED ###

Here is a copy of the database.xml file:

name="mysql-db"
jdbc-driver = "com.mysql.jdbc.Driver"
protocol-url = "jdbc:mysql"
db = "10.76.118.189:3306/nikhil"
user = "sa"
password = "sa"
vendor = "RDBMS"
max-id-length = "30"/>

Configuration File is attached for reference

Find more posts tagged with

Comments

CRB

is this the first time you are trying to get it working? or you had it working and now you are experiencing this problem?

i dont have much to say about DD but i can try Smiley Happy

:
if it is the first time, you are trying it out, it might be a problem with the username and password... or it might be a problem with port 3306?
can you connect without using the deployment configs to your database from where DD is running ?

also your question solved an issue i had thanks Smiley Very Happy

Bill Klish

Did you add access inside mysql for sa access from server punitp54710d.ad.infosys.com? If not, you need to add access within mysql. As a security restriction and basic mysql setup you need to provide users and addresses where they will be connecting from, otherwise access will be deined.

mridul

Nikhil,
Please re-check when you were creating the mysql database whether you have enable to check box for "Remote Access". I don't remember the exact option, but I have faced this same error and hence suggesting you to try the same.