MySQLi encrypted login

Hello there

I am looking for the password encryption option in the MySQLi extension that used to exist in the old MySQL login - where would i find that please?
Also back in March Jason advised that the MySQLi extensions were planned to be integrated into the next Databridge release.

Do you have a roadmap for this next release yet?
Haven't seen any recent posts from Jason by the way - is he still with WebAssist?

Many thanks

If you own Data Bridge you will be able to use the encryption bindings with MySQLi to encrypt values while inserting or updating the database.

We don't have a public release date for the next version of Data Bridge.

Ray

Thank you for the reply.
I have tried that but the encryption bindings such as MD5 do not appear in the default list of available formats for me.
I tried to add it from the 'Security Assist' option but get the attached message.

Sorry if I am doing something wrong with this!

Thank you

I see... it appears the DMXZone Extension Manager doesn't properly add the formats to the formats.xml file, and our files aren't set up to self-install.

I can update them so that they will install using the method you tried without error in a future version... for now you will have to edit your xml file directly.

Go to your users configuration folder and find the file:
Configuration/ServerFormats/PHP_MySQL/Formats.xml

add this code:

<menu id="EncFormatSecurityAssist_PHP" name="SecurityAssist">
		<format title="Encryption - Crypt" file="WACryptEncryption" expression="&lt;\?\s*php\s*echo\s*WA_CryptEncryption\([^\r\n]*\);?\s*\?&gt;" func="WA_CryptEncryption" id="WACryptEncryption_PHP" />
		<format title="Decryption - Hash" file="WAHashDecryption" expression="&lt;\?\s*php\s*echo\s*WA_HashDecryption\([^\r\n]*\);?\s*\?&gt;" func="WA_HashDecryption" id="WAHashDecryption_PHP" />
		<format title="Encryption - Hash" file="WAHashEncryption" expression="&lt;\?\s*php\s*echo\s*WA_HashEncryption\([^\r\n]*\);?\s*\?&gt;" func="WA_HashEncryption" id="WAHashEncryption_PHP" />
		<format title="Encryption - MD5" file="WAMD5Encryption" expression="&lt;\?\s*php\s*echo\s*WA_MD5Encryption\([^\r\n]*\);?\s*\?&gt;" func="WA_MD5Encryption" id="WAMD5Encryption_PHP" />
		<format title="Decryption - RIJNDAEL" file="WARIJNDAELDecryption" expression="&lt;\?\s*php\s*echo\s*WA_RIJNDAELDecryption\([^\r\n]*\);?\s*\?&gt;" func="WA_RIJNDAELDecryption" id="WARIJNDAELDecryption_PHP" />
		<format title="Encryption - RIJNDAEL" file="WARIJNDAELEncryption" expression="&lt;\?\s*php\s*echo\s*WA_RIJNDAELEncryption\([^\r\n]*\);?\s*\?&gt;" func="WA_RIJNDAELEncryption" id="WARIJNDAELEncryption_PHP" />
		<format title="Encryption - SHA1" file="WASHA1Encryption" expression="&lt;\?\s*php\s*echo\s*WA_SHA1Encryption\([^\r\n]*\);?\s*\?&gt;" func="WA_SHA1Encryption" id="WASHA1Encryption_PHP" />
	</menu>

That will add the formats you need to your format list.

Ray

Perfect - thanks for your help.

Just noticed in case this crops up for you again that the behaviour didn't insert the include to the file ../webassist/security_assist/wa_md5encryption.php, into the page, although it DID make the physical folder itself under the site.

Steve