Hi all,
I did finally get it to work -- sort of. Instead of using AES_, I
used DES_ and everything worked fine. I did a little more digging and
found that DES_ is used when MySQL is set up with SSL. When on the
account section for the site, it's https://, so that must be it. But
my question now is, what is the difference between AES and DES?
Mark
On May 25, 2007, at 9:38 AM, Mark Wheeler wrote:
> Hi,
>
> I gave it a try and still the same syntax error. I can't see where
> there is a problem. Could it be the way the table is created in the
> database? I even made a test table with only the id and password and
> still got the error. Here's what it looks like for the insert and
> select statements.
>
> INSERT INTO test VALUES ('555',AES_ENCRYPT('123456789','fff'))
>
> SELECT `pid`, AES_DECRYPT(`passnum`, 'fff') AS `passnumdec` FROM
> `test` WHERE `pid` = '555'
>
> No luck. What am I missing?!
>
> Thanks,
>
> Mark
>
> On May 25, 2007, at 2:22 AM, Tiago Relvão wrote:
>
>> Your query seems OK, but it might be your password field. Maybe you
>> have to
>> use ``
>>
>> SELECT AES_DECRYPT(`password`, 'fff') AS `password_dec` FROM
>> `table_name`
>> WHERE `user_id` = '555'
>>
>> just a guess anyway... Tiago
>>
>> On 5/25/07, Mark Wheeler <[EMAIL PROTECTED]> wrote:
>>>
>>> Hi,
>>>
>>> I'm beating my head against a wall here. I can not figure out where
>>> the syntax error is! Can anyone give me a helpful hint, please?
>>> Here's how I encrypted it and how I am trying to decrypt it.
>>>
>>> INSERT INTO table_name VALUES ('555',AES_ENCRYPT('abcdefg', 'fff'))
>>>
>>> SELECT AES_DECRYPT(password, 'fff') AS password_dec FROM table_name
>>> WHERE user_id = 555
>>>
>>> I don't get an error when inserting (or updating) but when I try to
>>> decrypt, I get a syntax error. Where is it?
>>>
>>> Thanks very much for any help,
>>>
>>> Mark
>>>
>>>
>>
>>
>> [Non-text portions of this message have been removed]
>>
>>
>>
>> The php_mysql group is dedicated to learn more about the PHP/MySQL
>> web database possibilities through group learning.
>> Yahoo! Groups Links
>>
>>
>>
>
>
>
> The php_mysql group is dedicated to learn more about the PHP/MySQL
> web database possibilities through group learning.
> Yahoo! Groups Links
>
>
>
