Dialupadmin and Mysql 5.0.18

[Paolo Pellicori]

Hi, Questions: 

 I have upgrade mysql from ver 4 to 5.0.18 but
dialupadmin it does not work more: (  

 

how I can resolve?

 

Regards

 






- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

R: R: SQL.conf new query

[Paolo Pellicori]

I have append the query to the existing ones, but without it turns out to
you.

  postauth_mac_query = "INSERT into ${authcheck_table}  (UserName,
Attribute, op, Value) VALUES ('%{SQL-User-Name}'', 'Calling-Station-Id',
':=', '%{Calling-Station-Id}')"

postauth_query = "INSERT into ${postauth_table} (id, user, pass,
reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"

in the log of start you come only loaded the postauth_query:

sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE
UserName='%{SQL-User-Name}'"
 sql: connect_failure_retry_delay = 60
 sql: simul_count_query = ""
 sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName,
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol
FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
 sql: postauth_table = "radpostauth"
 sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"

it does not appear and consequently it does not work: ( 

Solutions?

Regards



Inviato: giovedì 26 gennaio 2006 18.41
A: FreeRadius users mailing list
Oggetto: Re: R: SQL.conf new query 

> I would like to build a new query to insert
> user's MAC address into radcheck table, as users log-out (accounting-stop
> packet). 

  Just append the query to the existing ones.

  Alan DeKok.
- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

SQL.conf new query

[Paolo Pellicori]

hello, type is possible to insert one new query in
the rows sql.conf this:

 

postauth_query = "INSERT into ${postauth_table}
(id, user, pass, reply, date) values ('', '%{User-Name}',
'%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())"

 

modified in this way with name postauth_query_mac:

 

  postauth_query_mac = "INSERT into
${authcheck_table}  (UserName, Attribute, op, Value) VALUES
('%{SQL-User-Name}', 'Calling-Station-Id', ':=', '%{Calling-Station-Id}' where
UserName != '%{SQL-User-Name}'and Attribute != 'Calling-Station-Id'
)"

 

where I can find the rows for invocare the new
query?  Thanks

 

Regards






- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html