cisco-vsa-hack *is* documented in sql howto:
http://wiki.freeradius.org/SQL_HOWTO#Additional_Snippets
Ivan Kalik
Kalik Informatika ISP
Dana 27/5/2008, "Evgeney Bakhtin" <zhekha@nsib.ru> piše:
If I execute a query:
SELECT id AS AttrID, 'zhekha2' AS Login, attr AS AttrName,
IPPhone.VoIP_GetAttrib('zhekha2','','',attr,'1','') AS AttrValue,':=' AS
Oper FROM IPPhone.Attrib WHERE op IS NULL AND service=1
I have:
# AttrID Login AttrName AttrValue
Oper
1 3 zhekha Session-Timeout 0
:=
2 4 zhekha h323-credit-time 0
:=
3 5 zhekha h323-billing-model 0
:=
4 7 zhekha Cisco-AVPair
h323-ivr-in=terminal-alias:zhekha,0921877; :=
5 9 zhekha XPGK_XROUTING_ROUTING
:=
But in freeradius log I have:
Sending Access-Accept of id 149 to 89.251.105.114 port 48099
Session-Timeout := "0"
h323-credit-time := "0"
h323-billing-model := "0"
Cisco-AVPair := "h323"
Finished request 10.
What I do wrong?