lists.freeradiu
s.org] On Behalf Of Alan DeKok
Sent: 13 June 2013 16:02
To: FreeRadius users mailing list
Subject: Re: MSSQL using unixodbc and truncation of characters
Franks Andy (RLZ) IT Systems Engineer wrote:
> (by the way is there a nice way to get shot of all these ansi escape
> codes fro
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
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)
Inv
On 13 Jun 2013, at 13:56, Arran Cudbard-Bell 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 select support to
>
> 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
FreeRADIUS Development Team
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.htm
Ok, so I've compiled 3 from scratch with support for the freetds and unixodbc
modules. I have some issues :
Using the unixodbc driver that was working before gives me this now :
rlm_sql (sql_postauth_lan0): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc)
loaded and linked
rlm_sql (sql_postauth
lf 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"
wrote:
> Just as an aside - is the rlm_sql_freetds module deprecat
On 12 Jun 2013, at 19:20, "Franks Andy \(RLZ\) IT Systems Engineer"
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 to try it and
> po
rs 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_uni
reeradius-users-bounces+andy.franks=sath.nhs.uk@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.
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 suspi
h.nhs...@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 Sy
On 12 Jun 2013, at 17:47, "Franks Andy \(RLZ\) IT Systems Engineer"
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
FreeRADIUS Development Team
-
List info/subscribe/unsubscribe? See http://
On 12 Jun 2013, at 17:42, Franks Andy (RLZ) IT Systems Engineer
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 Cudbard-Bell
FreeRADIUS Dev
Sorry, FR version 2.2.1.
Thanks
andy
_
From: Franks Andy (RLZ) IT Systems Engineer
Sent: 12 June 2013 17:43
To: freeradius-users@lists.freeradius.org
Subject: MSSQL using unixodbc and truncation of characters
Hi all,
I may again being doing
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.
iSQL works fine and I can do a query thus :
Select NetworkCardID from Audit_NetworkCard where
macaddress='00:14:22:53:de:58'
+--+
| Netw
16 matches
Mail list logo
