Re: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Alan DeKok
Palmer J.D.F. wrote: > Further to my last foray onto the list regarding SoH, I'm looking to > commit the returned SoH info to the radius database using FreeRADIUS' > sql connection. It's just attributes. > I could be well off target here, but please humour me, so far I have... > > Created a ta

Re: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Arran Cudbard-Bell
On 2 Aug 2011, at 15:07, Alan DeKok wrote: > Palmer J.D.F. wrote: >> Further to my last foray onto the list regarding SoH, I'm looking to >> commit the returned SoH info to the radius database using FreeRADIUS' >> sql connection. > > It's just attributes. just use sql xlat... update request {

RE: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Palmer J.D.F.
> Palmer J.D.F. wrote: >> Further to my last foray onto the list regarding SoH, I'm looking to >> commit the returned SoH info to the radius database using FreeRADIUS' >> sql connection. > > It's just attributes. > Read raddb/sites-available/soh. The server runs an "authorize" > section. T

RE: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Palmer J.D.F.
> > Palmer J.D.F. wrote: > >> Further to my last foray onto the list regarding SoH, I'm looking to > >> commit the returned SoH info to the radius database using > FreeRADIUS' > >> sql connection. > > > > It's just attributes. > > just use sql xlat... > > update request { > Tmp-String-1 :=

Re: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Arran Cudbard-Bell
On 2 Aug 2011, at 15:44, Palmer J.D.F. wrote: >>> Palmer J.D.F. wrote: Further to my last foray onto the list regarding SoH, I'm looking > to commit the returned SoH info to the radius database using >> FreeRADIUS' sql connection. >>> >>> It's just attributes. >> >> just use sql

RE: Implementing SQL Insert/logging for SoH.

2011-08-02 Thread Palmer J.D.F.
> > Didn't think xlat could do inserts and updates? > > I wrote the patch to add the functionality and its been in the server > code for about the past three years :) Good stuff. :) The source of rlm_sql.c still states only ... "* sql xlat function. Right now only SELECTs are supported." W

Re: Implementing SQL Insert/logging for SoH.

2011-08-04 Thread Arran Cudbard-Bell
On 2 Aug 2011, at 16:09, Palmer J.D.F. wrote: >>> Didn't think xlat could do inserts and updates? >> >> I wrote the patch to add the functionality and its been in the server >> code for about the past three years :) > > Good stuff. :) > > The source of rlm_sql.c still states only ... > "*