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

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) Inv

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 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

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 FreeRADIUS Development Team - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.htm

RE: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Franks Andy (RLZ) IT Systems Engineer
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

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" 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

RE: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Franks Andy (RLZ) IT Systems Engineer
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.

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 suspi

RE: MSSQL using unixodbc and truncation of characters

2013-06-12 Thread Franks Andy (RLZ) IT Systems Engineer
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

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" 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://

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 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

Re: MSSQL, bugs and a "patch"

2009-02-10 Thread Sebastian Heil
Hello, forget this mail. I worked with an old version of the schema. In the new version, the radpostauth-table is already there... Original-Nachricht > Datum: Tue, 10 Feb 2009 11:58:20 +0100 > Von: "Sebastian Heil" > An: freeradius-users@lists.freeradius.org > Betreff: MSSQL,

RE: MSSQL with IPPOOL

2008-09-24 Thread tnt
e} -> sqltestuser >rlm_sql (sql): sql_set_user escaped user --> 'sqltestuser' >++[sql] returns noop >Sending Access-Accept of id 8 to 172.16.1.5 port 4523 >Finished request 0. >Going to the next request >Waking up in 4.9 seconds. >Cleaning up request 0 ID 8 with ti

RE: MSSQL with IPPOOL

2008-09-24 Thread Xiaochen Jing
Going to the next request Waking up in 4.9 seconds. Cleaning up request 0 ID 8 with timestamp +10 Ready to process requests. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2008 4:04 PM To: FreeRadius users

Re: MSSQL with IPPOOL

2008-09-24 Thread tnt
What version is this? In current schema group membership table is radusergroup not usergroup. Post the whole debug. From this we can only say that data from radgroupcheck table didn't make it. The bit why is missing. Ivan Kalik Kalik Informatika ISP Dana 24/9/2008, "Xiaochen Jing" <[EMAIL PROTEC

Re: mssql to mysql migration

2007-04-27 Thread tnt
Opens fine for me. Ivan Kalik Kalik Informatika ISP Dana 27/4/2007, "satish patel" <[EMAIL PROTECTED]> piše: >it is not opening > > http://www.navicat.com/ > > >[EMAIL PROTECTED] wrote: http://www.navicat.com/ > >Ivan Kalik >Kalik Informatika ISP > > > > >Dana 26/4/2007, "satish patel" > piše:

Re: mssql to mysql migration

2007-04-27 Thread satish patel
it is not opening http://www.navicat.com/ [EMAIL PROTECTED] wrote: http://www.navicat.com/ Ivan Kalik Kalik Informatika ISP Dana 26/4/2007, "satish patel" pi¹e: >Dear > > I have running freeradius + mssql but now i wann put all databases in > mysql so i am gonn use mysql with

Re: mssql to mysql migration

2007-04-26 Thread tnt
http://www.navicat.com/ Ivan Kalik Kalik Informatika ISP Dana 26/4/2007, "satish patel" <[EMAIL PROTECTED]> piše: >Dear > > I have running freeradius + mssql but now i wann put all databases in > mysql so i am gonn use mysql with freeradius so is there any tool which > convert MSSQL

Re: MSSQL Querys -> No matching entry

2005-11-15 Thread Kristina Pfaff-Harris
On Tue, 15 Nov 2005, Fernando Brito wrote: > query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = > '00:11:7C:00:01:57' ORDER BY id > radius_xlat: 'SELECT > radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op > FROM rad

Re: mssql and authenticate_query

2005-09-16 Thread Nicolas Baradakis
Duane Cox wrote: > > > Why we're at it, why not change the example mssql.conf file to > > > remove all references to FreeTDS... That should resolve _a lot_ > > > of confusion... > > > > As always, patches are welcome. > > Is there a mantis page or bug tracker? There is a bugzilla here: http://b

Re: mssql and authenticate_query

2005-09-16 Thread Duane Cox
From: "Nicolas Baradakis" <[EMAIL PROTECTED]> > Duane Cox wrote: > > > Why we're at it, why not change the example mssql.conf file to > > remove all references to FreeTDS... That should resolve _a lot_ > > of confusion... > > As always, patches are welcome. Is there a mantis page or bug tracker

Re: mssql and authenticate_query

2005-09-16 Thread Nicolas Baradakis
Duane Cox wrote: > Why we're at it, why not change the example mssql.conf file to > remove all references to FreeTDS... That should resolve _a lot_ > of confusion... As always, patches are welcome. Nicolas Baradakis -- A: Yes. >Q: Are you sure? >>A: Because it reverses the logical flow of conv

Re: mssql and authenticate_query

2005-09-16 Thread Duane Cox
> > There is an "authenticate_query" variable defined in the stock mssql.conf > > If it's there, it's a big. It's there... I would assume it should be removed in CVS and/or logged in your bug tracking system. Do you have a mantis page? Why we're at it, why not change the example mssql.conf fi

Re: mssql and authenticate_query

2005-09-15 Thread Alan DeKok
"Duane Cox" <[EMAIL PROTECTED]> wrote: > There is an "authenticate_query" variable defined in the stock mssql.conf If it's there, it's a big. > I am beginning to think this entry is defunct or never implemented. > Am I right? If so, then I could remove that entry from my mssql.conf. Yes.

RE: mssql

2005-04-14 Thread Lucas Aimaretto
> > rlm_sql (sql): Driver rlm_sql_unixodbc (module > > rlm_sql_unixodbc) loaded and linked > > > > rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:1433/radius > > You have that use the name of de pc no the ip > > rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:1433/radius Th