I have been configurating broadworks VSA into freeradius, but i still having problems on startup: freeradius -X FreeRADIUS Version 2.1.10, for host x86_64-pc-linux-gnu, built on Nov 14 2010 at 21:12:30 Copyright (C) 1999-2009 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including files in directory /etc/freeradius/modules/ including configuration file /etc/freeradius/modules/inner-eap including configuration file /etc/freeradius/modules/logintime including configuration file /etc/freeradius/modules/exec including configuration file /etc/freeradius/modules/preprocess including configuration file /etc/freeradius/modules/wimax including configuration file /etc/freeradius/modules/digest including configuration file /etc/freeradius/modules/realm including configuration file /etc/freeradius/modules/checkval including configuration file /etc/freeradius/modules/files including configuration file /etc/freeradius/modules/detail including configuration file /etc/freeradius/modules/cui including configuration file /etc/freeradius/modules/expr including configuration file /etc/freeradius/modules/sqlcounter_expire_on_login including configuration file /etc/freeradius/modules/mac2vlan including configuration file /etc/freeradius/modules/ippool including configuration file /etc/freeradius/modules/pap including configuration file /etc/freeradius/modules/detail.log including configuration file /etc/freeradius/modules/opendirectory including configuration file /etc/freeradius/modules/perl including configuration file /etc/freeradius/modules/otp including configuration file /etc/freeradius/modules/sradutmp including configuration file /etc/freeradius/modules/attr_filter including configuration file /etc/freeradius/modules/policy including configuration file /etc/freeradius/modules/smbpasswd including configuration file /etc/freeradius/modules/smsotp including configuration file /etc/freeradius/modules/detail.example.com including configuration file /etc/freeradius/modules/attr_rewrite including configuration file /etc/freeradius/modules/mac2ip including configuration file /etc/freeradius/modules/radutmp including configuration file /etc/freeradius/modules/ldap including configuration file /etc/freeradius/modules/pam including configuration file /etc/freeradius/modules/always including configuration file /etc/freeradius/modules/linelog including configuration file /etc/freeradius/modules/echo including configuration file /etc/freeradius/modules/ntlm_auth including configuration file /etc/freeradius/modules/krb5 including configuration file /etc/freeradius/modules/passwd including configuration file /etc/freeradius/modules/chap including configuration file /etc/freeradius/modules/etc_group including configuration file /etc/freeradius/modules/expiration including configuration file /etc/freeradius/modules/sql_log including configuration file /etc/freeradius/modules/acct_unique including configuration file /etc/freeradius/modules/dynamic_clients including configuration file /etc/freeradius/modules/counter including configuration file /etc/freeradius/modules/mschap including configuration file /etc/freeradius/modules/unix including configuration file /etc/freeradius/eap.conf including configuration file /etc/freeradius/sql.conf including configuration file /etc/freeradius/sql/postgresql/broadsoft.conf /etc/freeradius/sql/postgresql/broadsoft.conf[204]: Line too long Errors reading /etc/freeradius/radiusd.conf There are some limits for VSA attributes for sql.conf ? Here is my broadsoft.conf: root@bravo:/etc/freeradius/sql/postgresql# cat broadsoft.conf accounting-request = "INSERT INTO ${acct_table1} \ (Radius-Encoding-Version,Record-id, \ Service-provider,Type,Direction, \ Calling-Number,Calling-Presentation-Indic,Called-Number, \ Start-Time,Answer-Indic, \ Answer-Time,Release-Time,Termination-Cause, \ Network-Type,Dialed-Digits, \ Call-Category,Network-Call-Type,Network-Translated-Number, \ Network-Translated-Group,Releasing-Party,Route, \ Codec, \ Spare-29, \ Spare-31,Department,Account-Code, \ Authorization-Code,Original-Called-Number, \ Redirecting-Number, \ Charge-Indic,Type-Of-Network, \ VP-Calling-Invoke-Time,Local-Callid,Remote-Callid, \ Charging-Vector-Orig, \ Charging-Vector-Term,Acc-Per-Call-Invoke-Time,Acc-Per-Call-Fac-Result, \ Acb-Act-Invoke-Time,Acb-Act-Fac-Result,Acb-Deact-Invoke-Time, \ Acb-Deact-Fac-Result,Call-Park-Invoke-Time,Call-Park-Fac-Result, \ Call-Park-Retr-Invoke-Time,Call-Park-Retr-Fac-Result,Call-Pickup-Invoke-Time, \ Call-Pickup-Fac-Result,Directed-Call-Pickup-Invoke-Time,Directed-Call-Pickup-Fac-Result, \ Dpubi-Invoke-Time,Dpubi-Fac-Result,Cancel-Cwt-Per-Call-Invoke-Time, \ Cancel-Cwt-Per-Call-Fac-Result,Cfa-Act-Invoke-Time,Cfa-Act-Fac-Result, \ Cfa-Deact-Invoke-Time,Cfa-Deact-Fac-Result,Cfb-Act-Invoke-Time, \ Cfb-Act-Fac-Result,Cfb-Deact-Invoke-Time,Cfb-Deact-Fac-Result, \ Cfna-Act-Invoke-Time,Cfna-Act-Fac-Result,Cfna-Deact-Invoke-Time, \ Cfna-Deact-Fac-Result,Clid-Delivery-Per-Call-Invoke-Time,Clid-Delivery-Per-Call-Fac-Result, \ Clid-Blocking-Per-Call-Invoke-Time,Clid-Blocking-Per-Call-Fac-Result,Cot-Invoke-Time, \ Cot-Fac-Result,Direct-Vm-Xfer-Invoke-Time,Direct-Vm-Xfer-Fac-Result, \ Dnd-Act-Invoke-Time,Dnd-Act-Fac-Result,Dnd-Deact-Invoke-Time, \ Dnd-Deact-Fac-Result,Sac-Lock-Invoke-Time,Sac-Lock-Fac-Result, \ Sac-Unlock-Invoke-Time,Sac-Unlock-Fac-Result,Flash-Call-Hold-Invoke-Time, \ Flash-Call-Hold-Fac-Result,Last-Number-Redial-Invoke-Time,Last-Number-Redial-Fac-Result, \ Return-Call-Invoke-Time,Return-Call-Fac-Result,Sd100-Programming-Invoke-Time, \ Sd100-Programming-Fac-Result,Sd8-Programming-Invoke-Time,Sd8-Programming-Fac-Result, \ Clear-Mwi-Invoke-Time,Clear-Mwi-Fac-Result, \ Other-Party-Name,Other-Party-Name-Pres-Indic,Moh-Deact-Invoke-Time, \ Moh-Deact-Fac-Result,Push-to-Talk-Invoke-Time,Push-to-Talk-Fac-Result, \ Diversion-Inhibitor-Invoke-time, \ Diversion-Inhibitor-Fac-Result,Trunk-Group-Name \ InstantGroupCall-Invoke-Time,InstantGroupCall-Related-Callid, \ CustomRingback-Invoke-Time,AHR-Invoke-Time, \ Related-CallId,Related-CallId-Reason, \ Transfer-Invoke-Time,Transfer-Result,Transfer-Related-CallId, \ Codec-Usage, \ Vmb-Act-Invoke-Time,Vmb-Act-Fac-Result,Vmb-Deact-Invoke-Time, \ Vmb-Deact-Fac-Result,Vmna-Act-Invoke-Time,Vmna-Act-Fac-Result, \ Vmna-Deact-Invoke-Time,Vmna-Deact-Fac-Result,Vma-Act-Invoke-Time, \ Vma-Act-Fac-Result,Vma-Deact-Invoke-Time,Vma-Deact-Fac-Result, \ No-Answer-Set-Invoke-Time,No-Answer-Set-Fac-Result,Clid-Blocking-Act-Invoke-Time, \ Clid-Blocking-Act-Fac-Result,Clid-Blocking-Deact-Invoke-Time,Clid-Blocking-Deact-Fac-Result, \ Call-Waiting-Act-Invoke-Time,Call-Waiting-Act-Fac-Result,Call-Waiting-Deact-Invoke-Time, \ Call-Waiting-Deact-Fac-Result, \ Cfnrc-Act-Invoke-Time, \ Cfnrc-Act-Fac-Result,Cfnrc-Deact-Invoke-Time,Cfnrc-Deact-Fac-Result, \ Q850-Cause,Dialed-Digits-Context,Called-Number-Context, \ Network-Translated-Number-Context,Calling-Number-Context, \ Call-Parked-Invoke-Time,BA-Related-Call-Id,Acr-Act-Invoke-Time, \ Acr-Act-Fac-Result,Acr-Deact-Invoke-Time,Acr-Deact-Fac-Result, \ Received-Calling-Number \ AOC-Activation-Time, \ AOC-Result,AS-Call-Type,Scf-Act-Invoke-Time,Scf-Act-Fac-Result,Scf-Deact-Invoke-Time,Scf-Deact-Fac-Result, \ Cfa-Inter-Invoke-Time,Cfa-Inter-Fac-Result, \ Cfna-Inter-Invoke-Time,Cfna-Inter-Fac-Result, \ Cfb-Inter-Invoke-Time,Cfb-Inter-Fac-Result,CBF-Auth-Code, \ Return-Call-Number-Deletion-Invoke-Time, \ Return-Call-Number-Deletion-Fac-Result, \ Generic-Attribute) VALUES ('%{BWAS-Radius-Encoding-Version}', \ '%{BWAS-Record-id}', \ '%{BWAS-Service-provider}', \ '%{BWAS-Type}', \ '%{BWAS-Direction}', \ '%{BWAS-Calling-Number}', \ '%{BWAS-Calling-Presentation-Indic}', \ '%{BWAS-Called-Number}', \ '%{BWAS-Answer-Indic}', \ '%{BWAS-Answer-Time}', \ '%{BWAS-Release-Time}', \ '%{BWAS-Termination-Cause}', \ '%{BWAS-Network-Type}', \ '%{BWAS-Dialed-Digits}', \ '%{BWAS-Call-Category}', \ '%{BWAS-Network-Call-Type}', \ '%{BWAS-Network-Translated-Number}', \ '%{BWAS-Network-Translated-Group}', \ '%{BWAS-Releasing-Party}', \ '%{BWAS-Route}', \ '%{BWAS-Codec}', \ '%{BWAS-Spare-29}', \ '%{BWAS-Spare-31}', \ '%{BWAS-Department}', \ '%{BWAS-Account-Code}', \ '%{BWAS-Authorization-Code}', \ '%{BWAS-Original-Called-Number}', \ '%{BWAS-Redirecting-Number}', \ '%{BWAS-Charge-Indic}', \ '%{BWAS-Type-Of-Network}', \ '%{BWAS-VP-Calling-Invoke-Time}', \ '%{BWAS-Local-Callid}', \ '%{BWAS-Remote-Callid}', \ '%{BWAS-Charging-Vector-Orig}', \ '%{BWAS-Charging-Vector-Term}', \ '%{BWAS-Acc-Per-Call-Invoke-Time}', \ '%{BWAS-Acc-Per-Call-Fac-Result}', \ '%{BWAS-Acb-Act-Invoke-Time}', \ '%{BWAS-Acb-Act-Fac-Result}', \ '%{BWAS-Acb-Deact-Invoke-Time}', \ '%{BWAS-Acb-Deact-Fac-Result}', \ '%{BWAS-Call-Park-Invoke-Time}', \ '%{BWAS-Call-Park-Fac-Result}', \ '%{BWAS-Call-Park-Retr-Invoke-Time}', \ '%{BWAS-Call-Park-Retr-Fac-Result}', \ '%{BWAS-Call-Pickup-Invoke-Time}', \ '%{BWAS-Call-Pickup-Fac-Result}', \ '%{BWAS-Directed-Call-Pickup-Invoke-Time}', \ '%{BWAS-Directed-Call-Pickup-Fac-Result}', \ '%{BWAS-Dpubi-Invoke-Time}', \ '%{BWAS-Dpubi-Fac-Result}', \ '%{BWAS-Cancel-Cwt-Per-Call-Invoke-Time}', \ '%{BWAS-Cancel-Cwt-Per-Call-Fac-Result}', \ '%{BWAS-Cfa-Act-Invoke-Time}', \ '%{BWAS-Cfa-Act-Fac-Result}', \ '%{BWAS-Cfa-Deact-Invoke-Time}', \ '%{BWAS-Cfa-Deact-Fac-Result}', \ '%{BWAS-Cfb-Act-Invoke-Time}', \ '%{BWAS-Cfb-Act-Fac-Result}', \ '%{BWAS-Cfb-Deact-Invoke-Time}', \ '%{BWAS-Cfb-Deact-Fac-Result}', \ '%{BWAS-Cfna-Act-Invoke-Time}', \ '%{BWAS-Cfna-Act-Fac-Result}', \ '%{BWAS-Cfna-Deact-Invoke-Time}', \ '%{BWAS-Cfna-Deact-Fac-Result}', \ '%{BWAS-Clid-Delivery-Per-Call-Invoke-Time}', \ '%{BWAS-Clid-Delivery-Per-Call-Fac-Result}', \ '%{BWAS-Clid-Blocking-Per-Call-Invoke-Time}', \ '%{BWAS-Clid-Blocking-Per-Call-Fac-Result}', \ '%{BWAS-Cot-Invoke-Time}', \ '%{BWAS-Cot-Fac-Result}', \ '%{BWAS-Direct-Vm-Xfer-Invoke-Time}', \ '%{BWAS-Direct-Vm-Xfer-Fac-Result}', \ '%{BWAS-Dnd-Act-Invoke-Time}', \ '%{BWAS-Dnd-Act-Fac-Result}', \ '%{BWAS-Dnd-Deact-Invoke-Time}', \ '%{BWAS-Dnd-Deact-Fac-Result}', \ '%{BWAS-Sac-Lock-Invoke-Time}', \ '%{BWAS-Sac-Lock-Fac-Result}', \ '%{BWAS-Sac-Unlock-Invoke-Time}', \ '%{BWAS-Sac-Unlock-Fac-Result}', \ '%{BWAS-Flash-Call-Hold-Invoke-Time}', \ '%{BWAS-Flash-Call-Hold-Fac-Result}', \ '%{BWAS-Last-Number-Redial-Invoke-Time}', \ '%{BWAS-Last-Number-Redial-Fac-Result}', \ '%{BWAS-Return-Call-Invoke-Time}', \ '%{BWAS-Return-Call-Fac-Result}', \ '%{BWAS-Sd100-Programming-Invoke-Time}', \ '%{BWAS-Sd100-Programming-Fac-Result}', \ '%{BWAS-Sd8-Programming-Invoke-Time}', \ '%{BWAS-Sd8-Programming-Fac-Result}', \ '%{BWAS-Clear-Mwi-Invoke-Time}', \ '%{BWAS-Clear-Mwi-Fac-Result}', \ '%{BWAS-Other-Party-Name}', \ '%{BWAS-Other-Party-Name-Pres-Indic}', \ '%{BWAS-Moh-Deact-Invoke-Time}', \ '%{BWAS-Moh-Deact-Fac-Result}', \ '%{BWAS-Push-to-Talk-Invoke-Time}', \ '%{BWAS-Push-to-Talk-Fac-Result}', \ '%{BWAS-Diversion-Inhibitor-Invoke-time}', \ '%{BWAS-Diversion-Inhibitor-Fac-Result}', \ '%{BWAS-Trunk-Group-Name}', \ '%{BWAS-InstantGroupCall-Invoke-Time}', \ '%{BWAS-InstantGroupCall-Related-Callid}', \ '%{BWAS-CustomRingback-Invoke-Time}', \ '%{BWAS-AHR-Invoke-Time}', \ '%{BWAS-Related-CallId}', \ '%{BWAS-Related-CallId-Reason}', \ '%{BWAS-Transfer-Invoke-Time}', \ '%{BWAS-Transfer-Result}', \ '%{BWAS-Transfer-Related-CallId}', \ '%{BWAS-Codec-Usage}', \ '%{BWAS-Vmb-Act-Invoke-Time}', \ '%{BWAS-Vmb-Act-Fac-Result}', \ '%{BWAS-Vmb-Deact-Invoke-Time}', \ '%{BWAS-Vmb-Deact-Fac-Result}', \ '%{BWAS-Vmna-Act-Invoke-Time}', \ '%{BWAS-Vmna-Act-Fac-Result}', \ '%{BWAS-Vmna-Deact-Invoke-Time}', \ '%{BWAS-Vmna-Deact-Fac-Result}', \ '%{BWAS-Vma-Act-Invoke-Time}', \ '%{BWAS-Vma-Act-Fac-Result}', \ '%{BWAS-Vma-Deact-Invoke-Time}', \ '%{BWAS-Vma-Deact-Fac-Result}', \ '%{BWAS-No-Answer-Set-Invoke-Time}', \ '%{BWAS-No-Answer-Set-Fac-Result}', \ '%{BWAS-Clid-Blocking-Act-Invoke-Time}', \ '%{BWAS-Clid-Blocking-Act-Fac-Result}', \ '%{BWAS-Clid-Blocking-Deact-Invoke-Time}', \ '%{BWAS-Clid-Blocking-Deact-Fac-Result}', \ '%{BWAS-Call-Waiting-Act-Invoke-Time}', \ '%{BWAS-Call-Waiting-Act-Fac-Result}', \ '%{BWAS-Call-Waiting-Deact-Invoke-Time}', \ '%{BWAS-Call-Waiting-Deact-Fac-Result}', \ '%{BWAS-Cfnrc-Act-Invoke-Time}', \ '%{BWAS-Cfnrc-Act-Fac-Result}', \ '%{BWAS-Cfnrc-Deact-Invoke-Time}', \ '%{BWAS-Cfnrc-Deact-Fac-Result}', \ '%{BWAS-Q850-Cause}', \ '%{BWAS-Dialed-Digits-Context}', \ '%{BWAS-Called-Number-Context}', \ '%{BWAS-Network-Translated-Number-Context}', \ '%{BWAS-Calling-Number-Context}', \ '%{BWAS-Call-Parked-Invoke-Time}', \ '%{BWAS-BA-Related-Call-Id}', \ '%{BWAS-Acr-Act-Invoke-Time}', \ '%{BWAS-Acr-Act-Fac-Result}', \ '%{BWAS-Acr-Deact-Invoke-Time}', \ '%{BWAS-Acr-Deact-Fac-Result}', \ '%{BWAS-Received-Calling-Number}', \ '%{BWAS-AOC-Activation-Time}', \ '%{BWAS-AOC-Result}', \ '%{BWAS-AS-Call-Type}', \ '%{BWAS-Scf-Act-Invoke-Time}', \ '%{BWAS-Scf-Act-Fac-Result}', \ '%{BWAS-Scf-Deact-Invoke-Time}', \ '%{BWAS-Scf-Deact-Fac-Result}', \ '%{BWAS-Cfa-Inter-Invoke-Time}', \ '%{BWAS-Cfa-Inter-Fac-Result}', \ '%{BWAS-Cfna-Inter-Invoke-Time}', \ '%{BWAS-Cfna-Inter-Fac-Result}', \ '%{BWAS-Cfb-Inter-Invoke-Time}', \ '%{BWAS-Cfb-Inter-Fac-Result}', \ '%{BWAS-CBF-Auth-Code}', \ '%{BWAS-Return-Call-Number-Deletion-Invoke-Time}', \ '%{BWAS-Return-Call-Number-Deletion-Fac-Result}', \ '%{BWAS-Generic-Attribute}')" Guilherme Domingues
Guilherme Domingues wrote:
I have been configurating broadworks VSA into freeradius, but i still having problems on startup:
The "line too long" message is because you've edited the configuration in a way that doesn't make sense.
There are some limits for VSA attributes for sql.conf ?
Inserting 100's of attributes in one SQL statement doesn't make sense. Don't do that. Alan DeKok.
participants (2)
-
Alan DeKok -
Guilherme Domingues