I need help with the proper syntax of my INSERT
Statement.
I have spoken to the support staff of my RADIUS
Vendor they stated that enable to support SHA
The Coolum for password has to have the encrypted
password prefixed with {SHA} not just the hash
I need to include the literal string of {SHA} plus
the hash, see below.
Quote from support
"When you select a user password from the table Radius will then retrieve:"
{SHA}15346b593c4d0cf05fb6e67a5669d852e6550481
This one encrypts the whole string "{SHA}"'smith'
mysql> INSERT INTO user_profile (userid,password,alias,profile)
-> VALUES ('bob',SHA1("{SHA}"'smith'),'max',default);
Query OK, 1 row affected (0.00 sec)
This one pukes
mysql> INSERT INTO user_profile (userid,password,alias,profile)
-> VALUES ('bob',("{SHA}"SHA1'smith'),'max',default);
ERROR 1064 You have an error in you SQL syntax
This one has a could mismatch
mysql> INSERT INTO user_profile (userid,password,alias,profile)
-> VALUES ('bob',"SHA",HA1'smith'),'max',default);
Please help I'm new to SQL and it's syntax flow.
Thanks
Jeff Stout
CSG Systems, Inc.
303-200-3204
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
