SQL results going ... wrong

Stefan Winter stefan.winter at restena.lu
Fri Apr 15 07:57:54 CEST 2011


Hi,

>> Thu Apr 14 15:43:07 2011 : Error: rlm_sql: Invalid operator
>> "?x�{?(�{?@�{?D�{?<�{?D�{?Z�{?]�{?v�{?swinter" for attribute +=
>> Thu Apr 14 15:43:07 2011 : Error: rlm_sql (sql-aai): Error getting data
>> from database
>> Thu Apr 14 15:43:07 2011 : Error: [sql-aai] SQL query error;
>> rejecting user
>>
>> Something looks like accessing memory where it better shouldn't.

> What character set encodings are you using for the database?
>
> I suspect the database is set UTF8 and your default character encoding
on the
> system you are developing FreeRadius is different.

This does definitely not look like a character encoding issue to me.
I've seen lots of these, and I'm using the same database structure all
around in our production setup. And the characters being transmitted are
all good old plain ASCII characters.

If you check the debug output against what's being sent, you'll see
striking mismatches; ' Invalid operator "..." for attribute +='

There is no attribute += - attributes are all "RESTENA-AAI-Attribute" -
which is defined in my dictionaries.

The quoted strange-string content contains my username swinter, but the
debug output says it considers this to be part of the "operator" column.
Sorry, but this is beyond character set badnesses. I'll run the same
test case with sql module debug on - maybe that sheds more light into
what's going wrong.

Stefan

-- 
Stefan WINTER
Ingenieur de Recherche
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 262 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20110415/366ccf09/attachment.pgp>


More information about the Freeradius-Users mailing list