Failed to hash the Delphix user password for dSource "/var/lib/mysql".

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • In Progress

IN one windows desktop host I have created a two environments,1source and 1target environment on virtual box  ... I have installed delphix on virtualbox on another windows desktop host...I am able to ping and telnet to source and target environments...

delphix ip: 10.6.120.188

delphix_source:10.6.120.86

delphix_target ip: 10.6.120.223

I have added the environment to delphix successfully...but when I try to create a dsource I throws the below error

ERROR:

DB_SYNC job for "Sources/taas_source" failed due to an error during execution: Failed to hash the Delphix user password for dSource "taas_source".
Make sure the source host "10.6.120.86" is accessible, the server "/var/lib/mysql" is running and try the operation again.
alert.jobs.failed.object
1819: Your password does not satisfy the current policy requirements

Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Official Response
Can you login to both of those linux VM's as the delphix user via SSH?
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
ya I can login..
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

we are able to connect to Linux vms via putty from the host and also other machines in the host network

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Official Response
are you able to remotely connect to the source mysql database  as the dbuser you are specifying in Delphix (i.e from the Linux target to the mysql db on the linux source)?
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
yes..using MySQL client in target VM we are able to connect to MySQL server in source VM. The usedID we have used is the same userID what we are trying from Delphix Engine
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
Adam, is it possible for you to review our environment over webex. It may be useful to figure out if something wrongly configured. Kindly let us know
Photo of Iwan Sutardji

Iwan Sutardji, Employee

  • 140 Points 100 badge 2x thumb
Prakash, looks like the password you created doesn't comply with requirement -- perhaps it's too short or doesn't have combination of alphanumeric. Recreate your password and give it another whirl.
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

source db credentials

dbusername:delphix

password:Delphix@123

target db credentials

dbusername:delphix

dbpassword:Delphix@123

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
try a password without @ in it?
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
can we use something like  Target_123 for password...special character is it allowed....?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Sure. I was just asking for you to try something without an @ in it to see if that was the cause. _ is fine.
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
Run SnapSync for database "/var/lib/mysql".
25 s





Port 3306 is not available on host "10.6.120.168" for target "/var/tmp/delphix_toolkit/564dcdab-3237-8761-3a4a-e30a38404f7c-staging-51/datafile". Provide a different port or shut down the application using it and try the operation again.
Port 3306 is not available on host "10.6.120.168" for target "/var/tmp/delphix_toolkit/564dcdab-3237-8761-3a4a-e30a38404f7c-staging-51/datafile".
Provide a different port or shut down the application using it and try the operation again.
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

in staging port I had tried giving 3306 and 3333 numbers... but iam getting the above error

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
If you have the default mysqld service running, then port 3306 is in use. Just out of habit, I use 3307 for my staging port. Delete your dSource, and try again with port 3307
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
I tried with 3434 port it throwed the below error




Failed to hash the Delphix user password for dSource "/var/lib/mysql". Make sure the source host "10.6.120.164" is accessible, the server "/var/lib/mysql" is running and try the operation again.
Failed to hash the Delphix user password for dSource "/var/lib/mysql".
Make sure the source host "10.6.120.164" is accessible, the server "/var/lib/mysql" is running and try the operation again.
1819: Your password does not satisfy the current policy requirements
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

source db password is : Source_123

target db password is : Target_123

Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
I have tried with 3307 also..it throwed the above error
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
can you come to webex session now..so that I can show the environment which I setted up...?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
I cannot. This morning is jammed for me, and I have to catch a flight soon. 
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
What version of MySQL, what version of Operating System, and what version of Delphix?
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
thank you...I am going through it...I will get back to you after trying it....
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

Server version: 5.7.16-log MySQL Community Server (GPL)

OS version: CentOS Linux release 7.2.1511 (Core)

delphix version:4.3.3.0


Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb

Hi adam,we have tired through the day we are unable to solve the issue..it is throwing the same issue..we need your help to resolve the issue


Failed to hash the Delphix user password for dSource "/var/lib/mysql". Make sure the source host "10.6.120.164" is accessible, the server "/var/lib/mysql" is running and try the operation again.
Failed to hash the Delphix user password for dSource "/var/lib/mysql".
Make sure the source host "10.6.120.164" is accessible, the server "/var/lib/mysql" is running and try the operation again.
1819: Your password does not satisfy the current policy requirements

(Edited)
Photo of prakash

prakash

  • 1,010 Points 1k badge 2x thumb
Adam when you will be available for the WebEx session....?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
I'll send you an email.