Re: MSSQL using unixodbc and truncation of characters

2013-06-13 Thread Arran Cudbard-Bell
I'm stuck, any ideas. Sorry to spam the mailing list so much but I've reached the limit of my knowledge on this one.. Ok, i'll take a closer took at it tonight. Arran Cudbard-Bell a.cudba...@freeradius.org FreeRADIUS Development Team - List info/subscribe/unsubscribe? See

Re: MSSQL using unixodbc and truncation of characters

2013-06-13 Thread Arran Cudbard-Bell
On 13 Jun 2013, at 13:56, Arran Cudbard-Bell a.cudba...@freeradius.org wrote: I'm stuck, any ideas. Sorry to spam the mailing list so much but I've reached the limit of my knowledge on this one.. Ok, i'll take a closer took at it tonight. Um, apparently the original author didn't add

RE: MSSQL using unixodbc and truncation of characters

2013-06-13 Thread Franks Andy (RLZ) IT Systems Engineer
Hi Aaran, The Sybase driver works for a simple select 123456, but then any real value gives, .e.g : rlm_sql (sql_test_mssql): Executing query: 'Select NetworkCardID from Audit_NetworkCard where macaddress='9C:B7:0D:84:0D:09'' Sybase Server message: number(208) severity(16) state(1) line(1)

Re: MSSQL using unixodbc and truncation of characters

2013-06-13 Thread Alan DeKok
Franks Andy (RLZ) IT Systems Engineer wrote: (by the way is there a nice way to get shot of all these ansi escape codes from the radius.log? It looks nice in -X mode, but not great back-end) See radiusd.conf, log subeection. Look for colourise. So I need to use an explicit sql call to set

Re: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Arran Cudbard-Bell
On 12 Jun 2013, at 17:42, Franks Andy (RLZ) IT Systems Engineer andy.fra...@sath.nhs.uk wrote: Hi all, I may again being doing something wrong but I’ve noticed an odd problem. I’ve connected up using the freetds libraries to an MSSQL server. What version are you using? Arran

Re: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Arran Cudbard-Bell
On 12 Jun 2013, at 17:47, Franks Andy \(RLZ\) IT Systems Engineer andy.fra...@sath.nhs.uk wrote: Sorry, FR version 2.2.1. Could you try version 3? I cleaned some of that code up a while back, it may be fixed. -Arran Arran Cudbard-Bell a.cudba...@freeradius.org FreeRADIUS Development Team

RE: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Franks Andy (RLZ) IT Systems Engineer
...@lists.freeradius.org [mailto:freeradius-users-bounces+andy.franks=sath.nhs.uk@lists.freeradiu s.org] On Behalf Of Arran Cudbard-Bell Sent: 12 June 2013 17:55 To: FreeRadius users mailing list Subject: Re: MSSQL using unixodbc and truncation of characters On 12 Jun 2013, at 17:42, Franks Andy (RLZ) IT Systems

Re: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Alan DeKok
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

Re: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Arran Cudbard-Bell
On 12 Jun 2013, at 19:20, Franks Andy \(RLZ\) IT Systems Engineer andy.fra...@sath.nhs.uk wrote: 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

RE: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Franks Andy (RLZ) IT Systems Engineer
Of Arran Cudbard-Bell Sent: 12 June 2013 20:19 To: FreeRadius users mailing list Subject: Re: MSSQL using unixodbc and truncation of characters On 12 Jun 2013, at 19:20, Franks Andy \(RLZ\) IT Systems Engineer andy.fra...@sath.nhs.uk wrote: Just as an aside - is the rlm_sql_freetds module deprecated