Newbie here,
My setup is GNU GK, Free radius and MySQL.
I have authentication and accounting working. What I would like is to do
time of day routing. With radius I can use "%H" which is hour stamp in 24
hour clock. Combined with "%{Called-Station-Id}" I should be able to
re-write the dialed number string using MYSQL and radius.
Something like this:
"SELECT id, Time, Attribute, DestNum, op FROM ${timecheck_table} WHERE Time
= "%H" AND DestNum = "%{Called-Station-Id}" ........... order by id"
That is as far as I have gotten what I am missing is the syntax to use for
the rest of my radius string that queries the SQL table.
What I am hoping to be able to do is rewrite 604 NXX XXXX to 999 604 NXX
XXXX for hours 08 to 17 and for the rest of the hours re-write 604 NXX XXXX
to 997 604 NXX XXXX
Any help or suggestions for this would be greatly appreciated.
Regards Tim
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
