Password format to insert delivery server directly in to database

[shub]

Hi,

I have a requirement in which I have to directly insert SMTP server into the database but I am facing an issue with a password like I tried using inserting plain password/md5/based64 it didn't work. Also, I tried looking in for the code but can't find one.

Can you please point me to the code where I can find the format in which the password is getting stored if it is with the salt or can let me know about the encoding?

Thanks,
Shub

 

[Vpul Shah]

Hi,

Can you insert same SMTP server from application and see how its showing in Database. Then you can apply same directly.

 

[twisted1919]

Can you please point me to the code where I can find the format in which the password is getting stored if it is with the salt or can let me know about the encoding?

The password is encrypted, you can look into /apps/common/components/db/behaviors/RemoteServerPasswordHandlerBehavior.php to see how we do it. We're using https://github.com/phpseclib/phpseclib so you can easily replicate this functionality.

 

[shub]

Thanks, yes after drilling down for few hours we got to that file and were able to replicate that functionality.

 

[twisted1919]

@shub - sorry for the late reply, but i am glad you have solved it.