FW: MSSQL using unixodbc and truncation of characters

[Franks Andy (RLZ) IT Systems Engineer]

Just as an aside - is the rlm_sql_freetds module deprecated - it doesn't
have any config or make related stuff in the git clone I downloaded for
2.2 .. only one file - sql_freetds.c. I was hoping to try it and
possibly the iodbc driver as well instead of odbc, unless I'm off on the
wrong track
Thanks
Andy

-----Original Message-----
From:
freeradius-users-bounces+andy.franks=sath.nhs.uk at lists.freeradius.org
[mailto:freeradius-users-bounces+andy.franks=sath.nhs.uk at lists.freeradiu
s.org] On Behalf Of Franks Andy (RLZ) IT Systems Engineer
Sent: 12 June 2013 18:51
To: FreeRadius users mailing list
Subject: RE: MSSQL using unixodbc and truncation of characters

I'm using unixodbc and freetds with rlm_sql_unixodbc. 
It's odd because the built-in isql query tool reports back correctly,
leading me to the potentially incorrect assumption that it was something
in rlm_sql_unixobdc.
I'll see if I can try v3 out tomorrow, may be fixed there. If so, I'm
not sure whether it's appropriate for a production environment?
Also, I haven't tried iodbc but will have a go if it's likely to fix the
issue.
Thanks
Andy

-----Original Message-----
From:
freeradius-users-bounces+andy.franks=sath.nhs.uk at lists.freeradius.org
[mailto:freeradius-users-bounces+andy.franks=sath.nhs.uk at lists.freeradiu
s.org] On Behalf Of Alan DeKok
Sent: 12 June 2013 18:35
To: FreeRadius users mailing list
Subject: Re: MSSQL using unixodbc and truncation of characters

Franks Andy (RLZ) IT Systems Engineer wrote:
> Hi Aaran,
>   2.2.1 version. It's similar to this : 
> http://lists.freeradius.org/pipermail/freeradius-users/2009-May/038010
> .h
> tml
> same truncation to 4 digits, but that may be a coincidence. 
> Any ideas?

  It's likely the same issue.

  My suspicion is that there's something wrong with the underlying SQL
driver.  Which one are you using?  rlm_sql_iodbc?

  Alan DeKok.
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html