need help on MySQL error:1289(--openssl missing)

[sarma]

Hi friends,

I am using MySQL 5.0.24a on Linux.

When I try to use des_encrypt() function, I am getting the warning like des_encrypt() is disabled and You need MySQL built with '--with-openssl' to have it working.

To be specific, Output is

Error (Code 1289): The 'des_encrypt' feature is disabled; you need MySQL built with '--with-openssl' to have it working.

can u please help me out, how to resolve this problem.

Thanks in advance


regards
sarma

[sashi]

Hi friends,

I am using MySQL 5.0.24a on Linux.

When I try to use des_encrypt() function, I am getting the warning like des_encrypt() is disabled and You need MySQL built with '--with-openssl' to have it working.

To be specific, Output is

Error (Code 1289): The 'des_encrypt' feature is disabled; you need MySQL built with '--with-openssl' to have it working.

can u please help me out, how to resolve this problem.

Thanks in advance


regards
sarma

Hi there,

This error means that you need to re-compile your mysql server with openssl feature enable. Please check out more details at MYSQL site, hope it helps. Good luck & Take care.

[sarma]

Hi there,

This error means that you need to re-compile your mysql server with openssl feature enable. Please check out more details at MYSQL site, hope it helps. Good luck & Take care.

Thanks shashi.

I re-compiled with --openssl option and encountered same error. So I decided to use aes_encrypt() and aes_decrypt() functions instead of des_encrypt() and des_decrypt().

Anyways thanks shashi.

regards
sarma