>Hi,
>> And change the insert line with this line
>> postauth_query = "INSERT INTO ${postauth_table} (username, pass,
reply)
>> VALUES
>>
('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet-
>> Type}')"
>yes. but do you REALLY want to log peoples passwords into a nice
>databa
Hi,
> And change the insert line with this line
> postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply)
> VALUES
> ('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet-
> Type}')"
yes. but do you REALLY want to log peoples passwords into a nice
database? I've
I re and reread man unlang
And change the insert line with this line
postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply)
VALUES
('%{User-Name}','%{%{User-Password}:-%{Chap-Password}}','%{reply:Packet-
Type}')"
It's the value chap-password who's corrected. So for the fix, plea
>Hi,
>> So for this, now it's working. But I have nothing in radacct table
and even if I only keep the sql_log in the >>accounting section, i have
nothing in my sql-relay file.
>to get the sql-relay file you will need to call sql_log in the
accounting
>stanza and ensure that the sql_log is confi
Hi,
> So for this, now it's working. But I have nothing in radacct table and even
> if I only keep the sql_log in the accounting section, i have nothing in my
> sql-relay file.
to get the sql-relay file you will need to call sql_log in the accounting
stanza and ensure that the sql_log is config
I resolved some part of my question.
The post_auth part is now inserted in my sql database. What I modify is
In mssql.conf add these line
postauth_table = "radpostauth"
postauth_query = "INSERT INTO ${postauth_table} (username, pass, reply) VALUES
('%{User-Name}', '%{User-Password:-Chap-Password
Hi,
> Hi,
>
> I want to log accounting information and post-auth information in my sql
> database. I have an MSSQL database. In my accounting section I uncomment
> sql and sql_log. In post_auth section I uncomment sql and sql_log too.
> Here is the result I receive with debug mode
if you want to
7 matches
Mail list logo