New Attribute
Hi everybody How can define blank attribute for attr_rewrite result Can any one show me with example - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How Attr_rewrite works
Hiii everbody
I asked how is attr_write fuction works
I wrote
In radius.config
attr_rewrite MyCalledStationId {
attribute = Cisco-AVPair
# may be "packet", "reply", or "config"
searchin = packet
searchfor = "gw-rxd-cdn=ton:2,npi:1,#:"
replacewith = ""
ignore_case = no
new_attribute = yes
max_matches = 1
# ## If set to yes then the replace string will be appended to
the original string
append = no
}
But how can i assing to new attribute the attr_rewrite result
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Multiple Accounting Stop packet and rlm_sql (on Mysql)
I have a same problem but i fixed
You can fix this problem with addingAcctSessionId = '%{AcctSessionId}
and AcctUniqueId='%{ AcctUniqueId} to WHERE segment at your sql query
Iyi Calismalar
Saygilarimla
Ugur GUNCER
Sistem Yoneticisi
Telebizz Tel. ve Int. Hizm.
Office = +90 212 347 6959
Gsm = +90 544 535 9737
Fax = +90 212 347 6949
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of emy emy
> Sent: Monday, September 20, 2004 6:26 PM
> To: [EMAIL PROTECTED]
> Subject: Multiple Accounting Stop packet and rlm_sql (on Mysql)
>
> Hi,
>
> i'm using freeradius with rlm_sql module, and all work
> correctly except when
> Our NAS send multiple accountig stop packets to radius
> reguarding the same session. This couse problem because
> AcctStopTime was updated every time a stop packet arrives,
> and i must save only AcctStopTime sended the first Time. I
> have tryed to change acct_stop_query adding to WHERE condition this:
> accounting_stop_query = "UPDATE ${acct_table} SET
> AcctStopTime = '%S', \
> AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets
> = '%{Acct-Input-Octets}', \
> AcctOutputOctets = '%{Acct-Output-Octets}',
> AcctTerminateCause = '%{Acct-Terminate-Cause}', \
> AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop =
> '%{Connect-Info}' \
> WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName
> = '%{SQL-User-Name}'\
> AND NASIPAddress = '%{NAS-IP-Address}' and AcctStopTime = 0"
>
> Adding control for acctstoptime=0, but with this condition
> all acct-stop packet recived after the first ,execute the
> accounting_stop_query_alt query, and create on radacct
> duplicate session (no good).
>
> Any Ideas?
>
> Thanks to all
> Amy
>
> _
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
BEGIN:VCARD
VERSION:2.1
N:Guncer;Ugur
FN:Ugur Guncer ([EMAIL PROTECTED])
ORG:Telebizz Internet Hizmetleri
TITLE:Sistem Yoneticisi
TEL;WORK;VOICE:+90 (212) 347 69 59
TEL;CELL;VOICE:+90 (532) 748 29 78
TEL;WORK;FAX:+90 (212) 347 69 49
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5;Mecidiyeko=
y, Istanbul;;80290;T=FCrkiye
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5=0D=0AMecidiy=
ekoy, Istanbul 80290=0D=0AT=FCrkiye
URL;WORK:http://www.telebizz.org.uk
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20040422T084832Z
END:VCARD
Me again im stuck
Hi alan
How can i define attribute in a dictionary.
I define wit some values but i cant take the called number
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Alan
> DeKok
> Sent: Friday, September 10, 2004 9:17 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Cant Get Called Number
>
> "Ugur GUNCER" <[EMAIL PROTECTED]> wrote:
> > I tried to get called number from Cisco-AVPair attribute
> > with
> > , '%{Cisco-AVPair}',
>
> There are multiple Cisco-AVPair attributes in the packet, and 1.0.0
> can only look at the first. In the current CVS snapshots, see
> 'doc/variables.txt' for how to refer to 1 of N attributes in a packet.
>
> > And
> > %{gw-rxd-cdn=ton:2,npi:1,#:},
>
> If you have "cisco_with_vsa_hack" set, and "gw-rxd-cdn" is defined
> as an attribute in one of the dictionaries, then %{gw-rxd-cdn} should
> work to get the whole value of the attribute.
>
> 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
RE: Cant Get Called Number
Hi alan
How can i define attribute in a dictionary.
I define wit some values but i cant take the called number
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of Alan DeKok
> Sent: Friday, September 10, 2004 9:17 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Cant Get Called Number
>
> "Ugur GUNCER" <[EMAIL PROTECTED]> wrote:
> > I tried to get called number from Cisco-AVPair attribute
> > with
> > , '%{Cisco-AVPair}',
>
> There are multiple Cisco-AVPair attributes in the packet,
> and 1.0.0 can only look at the first. In the current CVS
> snapshots, see 'doc/variables.txt' for how to refer to 1 of N
> attributes in a packet.
>
> > And
> > %{gw-rxd-cdn=ton:2,npi:1,#:},
>
> If you have "cisco_with_vsa_hack" set, and "gw-rxd-cdn" is
> defined as an attribute in one of the dictionaries, then
> %{gw-rxd-cdn} should work to get the whole value of the attribute.
>
> Alan DeKok.
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
BEGIN:VCARD
VERSION:2.1
N:Guncer;Ugur
FN:Ugur Guncer ([EMAIL PROTECTED])
ORG:Telebizz Internet Hizmetleri
TITLE:Sistem Yoneticisi
TEL;WORK;VOICE:+90 (212) 347 69 59
TEL;CELL;VOICE:+90 (532) 748 29 78
TEL;WORK;FAX:+90 (212) 347 69 49
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5;Mecidiyeko=
y, Istanbul;;80290;T=FCrkiye
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Akinci Bayiri=0D=0ASokak No:13 Cevre Apt. =0D=0AB Blok Daire: 5=0D=0AMecidiy=
ekoy, Istanbul 80290=0D=0AT=FCrkiye
URL;WORK:http://www.telebizz.org.uk
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20040422T084832Z
END:VCARD
Cant Get Called Number
Hi Every,
I have a problem with getting called number
Here is my radius debug log
Acct-Session-Id = "0006AFF5"
Calling-Station-Id = "5357879878"
Called-Station-Id = "35"
h323-setup-time = "h323-setup-time=*09:20:26.801 UTC Thu Apr 11
2002"
h323-gw-id = "h323-gw-id=Ankara."
h323-conf-id = "h323-conf-id=31AAF1CC 4C6411D6 B9600011 20312620"
h323-call-origin = "h323-call-origin=originate"
h323-call-type = "h323-call-type=VoIP"
Cisco-AVPair = "h323-incoming-conf-id=31AAF1CC 4C6411D6 B9600011
20312620"
Cisco-AVPair = "subscriber=RegularLine"
Cisco-AVPair = "session-protocol=cisco"
Cisco-AVPair = "gw-rxd-cdn=ton:2,npi:1,#:5922112925"
I cant get called number (5922112925 )
Here is my sql.conf accounting queries
These are standart queries
accounting_onoff_query = "UPDATE ${acct_table1} SET AcctStopTime='%S',
AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime),
AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDela
y = %{Acct-Delay-Time} WHERE AcctSessionTime=0 AND AcctStopTime=0 AND
NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress
= '%{Framed-IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND
UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-
Address}' AND AcctStopTime = 0"
accounting_start_query = "INSERT into ${acct_table1} (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, Acct
Authentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctSto
pDelay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-I
nfo}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '',
'%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',
'%{Acct-Delay-Time}', '0')"
accounting_start_query_alt = "UPDATE ${acct_table1} SET
AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}',
ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId =
'%{Acct-Session-Id}'
AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND
AcctStopTime = 0"
accounting_stop_query = "UPDATE ${acct_table2} SET AcctStopTime =
'%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets =
'%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}',
AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay =
'%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE
AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND
NA
SIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
accounting_stop_query_alt = "INSERT into ${acct_table2} (RadAcctId,
AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, A
cctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, Acct
StopDelay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
'%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0
} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}',
'%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
I tried to get called number from Cisco-AVPair attribute
with
, '%{Cisco-AVPair}', '%{Calling-Station-Id}',
And
%{gw-rxd-cdn=ton:2,npi:1,#:}, '%{Calling-Station-Id}',
But i cant get called number
Anyone have a idea for this problem
Thanks for all helps
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Accounting Duplicate
Hi all, I have a problem with accounting. My problem is duplicate Anyone have a idea Here is my Radius debug log and sql.conf file linux:/var/log # radiusd -Xx Mon Sep 6 14:12:29 2004 : Info: Starting - reading configuration files ... Mon Sep 6 14:12:29 2004 : Debug: reread_config: reading radiusd.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/proxy.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/clients.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/snmp.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/sql.conf Mon Sep 6 14:12:29 2004 : Debug: main: prefix = "/usr" Mon Sep 6 14:12:29 2004 : Debug: main: localstatedir = "/var" Mon Sep 6 14:12:29 2004 : Debug: main: logdir = "/var/log/radius" Mon Sep 6 14:12:29 2004 : Debug: main: libdir = "/usr/lib/freeradius" Mon Sep 6 14:12:29 2004 : Debug: main: radacctdir = "/var/log/radius/radacct" Mon Sep 6 14:12:29 2004 : Debug: main: hostname_lookups = no Mon Sep 6 14:12:29 2004 : Debug: main: max_request_time = 30 Mon Sep 6 14:12:29 2004 : Debug: main: cleanup_delay = 5 Mon Sep 6 14:12:29 2004 : Debug: main: max_requests = 1024 Mon Sep 6 14:12:29 2004 : Debug: main: delete_blocked_requests = 0 Mon Sep 6 14:12:29 2004 : Debug: main: port = 0 Mon Sep 6 14:12:29 2004 : Debug: main: allow_core_dumps = no Mon Sep 6 14:12:29 2004 : Debug: main: log_stripped_names = no Mon Sep 6 14:12:29 2004 : Debug: main: log_file = "/var/log/radius/radius.log" Mon Sep 6 14:12:29 2004 : Debug: main: log_auth = no Mon Sep 6 14:12:29 2004 : Debug: main: log_auth_badpass = no Mon Sep 6 14:12:29 2004 : Debug: main: log_auth_goodpass = no Mon Sep 6 14:12:29 2004 : Debug: main: pidfile = "/var/run/radiusd/radiusd.pid" Mon Sep 6 14:12:29 2004 : Debug: main: user = "radiusd" Mon Sep 6 14:12:29 2004 : Debug: main: group = "radiusd" Mon Sep 6 14:12:29 2004 : Debug: main: usercollide = no Mon Sep 6 14:12:29 2004 : Debug: main: lower_user = "no" Mon Sep 6 14:12:29 2004 : Debug: main: lower_pass = "no" Mon Sep 6 14:12:29 2004 : Debug: main: nospace_user = "no" Mon Sep 6 14:12:29 2004 : Debug: main: nospace_pass = "no" Mon Sep 6 14:12:29 2004 : Debug: main: checkrad = "/usr/sbin/checkrad" Mon Sep 6 14:12:29 2004 : Debug: main: proxy_requests = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: retry_delay = 5 Mon Sep 6 14:12:29 2004 : Debug: proxy: retry_count = 3 Mon Sep 6 14:12:29 2004 : Debug: proxy: synchronous = no Mon Sep 6 14:12:29 2004 : Debug: proxy: default_fallback = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: dead_time = 120 Mon Sep 6 14:12:29 2004 : Debug: proxy: post_proxy_authorize = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: wake_all_if_all_dead = no Mon Sep 6 14:12:29 2004 : Debug: security: max_attributes = 200 Mon Sep 6 14:12:29 2004 : Debug: security: reject_delay = 1 Mon Sep 6 14:12:29 2004 : Debug: security: status_server = no Mon Sep 6 14:12:29 2004 : Debug: main: debug_level = 0 Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading dictionary Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading naslist Mon Sep 6 14:12:29 2004 : Info: Using deprecated naslist file. Support for this will go away soon. Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading clients Mon Sep 6 14:12:29 2004 : Info: Using deprecated clients file. Support for this will go away soon. Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading realms Mon Sep 6 14:12:29 2004 : Debug: radiusd: entering modules setup Mon Sep 6 14:12:29 2004 : Debug: Module: Library search path is /usr/lib/freeradius Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded expr Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated expr (expr) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded PAP Mon Sep 6 14:12:29 2004 : Debug: pap: encryption_scheme = "crypt" Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated pap (pap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded CHAP Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated chap (chap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded MS-CHAP Mon Sep 6 14:12:29 2004 : Debug: mschap: use_mppe = yes Mon Sep 6 14:12:29 2004 : Debug: mschap: require_encryption = no Mon Sep 6 14:12:29 2004 : Debug: mschap: require_strong = no Mon Sep 6 14:12:29 2004 : Debug: mschap: passwd = "(null)" Mon Sep 6 14:12:29 2004 : Debug: mschap: authtype = "MS-CHAP" Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated mschap (mschap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded System Mon Sep 6 14:12:29 2004 : Debug: unix: cache = no Mon Sep 6 14:12:29 2004 : Debug: unix: passwd = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: shadow = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: group = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: radwtmp = "/var/log/radius/radwtmp" Mon Sep 6 14:12:29 2004 : Debug: unix: usegroup = no Mon Sep 6 14:12:29 2004 :
Accounting Duplicate
Hi all, I have a problem with inserting accounting datas. Anyone have a idea Here is my Radius debug log and sql.conf file linux:/var/log # radiusd -Xx Mon Sep 6 14:12:29 2004 : Info: Starting - reading configuration files ... Mon Sep 6 14:12:29 2004 : Debug: reread_config: reading radiusd.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/proxy.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/clients.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/snmp.conf Mon Sep 6 14:12:29 2004 : Debug: Config: including file: /etc/raddb/sql.conf Mon Sep 6 14:12:29 2004 : Debug: main: prefix = "/usr" Mon Sep 6 14:12:29 2004 : Debug: main: localstatedir = "/var" Mon Sep 6 14:12:29 2004 : Debug: main: logdir = "/var/log/radius" Mon Sep 6 14:12:29 2004 : Debug: main: libdir = "/usr/lib/freeradius" Mon Sep 6 14:12:29 2004 : Debug: main: radacctdir = "/var/log/radius/radacct" Mon Sep 6 14:12:29 2004 : Debug: main: hostname_lookups = no Mon Sep 6 14:12:29 2004 : Debug: main: max_request_time = 30 Mon Sep 6 14:12:29 2004 : Debug: main: cleanup_delay = 5 Mon Sep 6 14:12:29 2004 : Debug: main: max_requests = 1024 Mon Sep 6 14:12:29 2004 : Debug: main: delete_blocked_requests = 0 Mon Sep 6 14:12:29 2004 : Debug: main: port = 0 Mon Sep 6 14:12:29 2004 : Debug: main: allow_core_dumps = no Mon Sep 6 14:12:29 2004 : Debug: main: log_stripped_names = no Mon Sep 6 14:12:29 2004 : Debug: main: log_file = "/var/log/radius/radius.log" Mon Sep 6 14:12:29 2004 : Debug: main: log_auth = no Mon Sep 6 14:12:29 2004 : Debug: main: log_auth_badpass = no Mon Sep 6 14:12:29 2004 : Debug: main: log_auth_goodpass = no Mon Sep 6 14:12:29 2004 : Debug: main: pidfile = "/var/run/radiusd/radiusd.pid" Mon Sep 6 14:12:29 2004 : Debug: main: user = "radiusd" Mon Sep 6 14:12:29 2004 : Debug: main: group = "radiusd" Mon Sep 6 14:12:29 2004 : Debug: main: usercollide = no Mon Sep 6 14:12:29 2004 : Debug: main: lower_user = "no" Mon Sep 6 14:12:29 2004 : Debug: main: lower_pass = "no" Mon Sep 6 14:12:29 2004 : Debug: main: nospace_user = "no" Mon Sep 6 14:12:29 2004 : Debug: main: nospace_pass = "no" Mon Sep 6 14:12:29 2004 : Debug: main: checkrad = "/usr/sbin/checkrad" Mon Sep 6 14:12:29 2004 : Debug: main: proxy_requests = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: retry_delay = 5 Mon Sep 6 14:12:29 2004 : Debug: proxy: retry_count = 3 Mon Sep 6 14:12:29 2004 : Debug: proxy: synchronous = no Mon Sep 6 14:12:29 2004 : Debug: proxy: default_fallback = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: dead_time = 120 Mon Sep 6 14:12:29 2004 : Debug: proxy: post_proxy_authorize = yes Mon Sep 6 14:12:29 2004 : Debug: proxy: wake_all_if_all_dead = no Mon Sep 6 14:12:29 2004 : Debug: security: max_attributes = 200 Mon Sep 6 14:12:29 2004 : Debug: security: reject_delay = 1 Mon Sep 6 14:12:29 2004 : Debug: security: status_server = no Mon Sep 6 14:12:29 2004 : Debug: main: debug_level = 0 Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading dictionary Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading naslist Mon Sep 6 14:12:29 2004 : Info: Using deprecated naslist file. Support for this will go away soon. Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading clients Mon Sep 6 14:12:29 2004 : Info: Using deprecated clients file. Support for this will go away soon. Mon Sep 6 14:12:29 2004 : Debug: read_config_files: reading realms Mon Sep 6 14:12:29 2004 : Debug: radiusd: entering modules setup Mon Sep 6 14:12:29 2004 : Debug: Module: Library search path is /usr/lib/freeradius Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded expr Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated expr (expr) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded PAP Mon Sep 6 14:12:29 2004 : Debug: pap: encryption_scheme = "crypt" Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated pap (pap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded CHAP Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated chap (chap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded MS-CHAP Mon Sep 6 14:12:29 2004 : Debug: mschap: use_mppe = yes Mon Sep 6 14:12:29 2004 : Debug: mschap: require_encryption = no Mon Sep 6 14:12:29 2004 : Debug: mschap: require_strong = no Mon Sep 6 14:12:29 2004 : Debug: mschap: passwd = "(null)" Mon Sep 6 14:12:29 2004 : Debug: mschap: authtype = "MS-CHAP" Mon Sep 6 14:12:29 2004 : Debug: Module: Instantiated mschap (mschap) Mon Sep 6 14:12:29 2004 : Debug: Module: Loaded System Mon Sep 6 14:12:29 2004 : Debug: unix: cache = no Mon Sep 6 14:12:29 2004 : Debug: unix: passwd = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: shadow = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: group = "(null)" Mon Sep 6 14:12:29 2004 : Debug: unix: radwtmp = "/var/log/radius/radwtmp" Mon Sep 6 14:12:29 2004 : Debug: unix: usegroup = no Mon Sep 6 14:12:29 2004 : Debu
Logging Problem with mysql
Hi Every, I have a problem with logging with mysql İm looking my db and i saw like these to many lines with "AcctStartTime -00-00 00:00:00 " RadAcctIdAcctSessionId AcctUniqueIdUserName Realm NASIPAddressNASPortId NASPortType AcctStartTime AcctStopTimeAcctSessionTime AcctAuthentic ConnectInfo_start ConnectInfo_stop AcctInputOctets AcctOutputOctetsCalledStationId CallingStationId AcctTerminateCause ServiceType FramedProtocolFramedIPAddress AcctStartDelay AcctStopDelay 1453654 7AADmatmazel 213.139.215.129 191 Async -00-00 00:00:00 2004-05-03 13:10:151802RADIUS 21600/24000 V34=2B/V42bis/LAPM = 849 40105922115017 03225156441 Session-Timeout Framed-User PPP 192.168.0.400 20 How can i found the problem and how can i fix ? Waiting your helps Thanks For all your Helps - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
ATTENTION INCLUDING WORM VIRUS (RE: unknown)
ATTENTION INCLUDING WORM VIRUS > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > Sent: Sunday, March 21, 2004 10:46 AM > To: [EMAIL PROTECTED] > Subject: unknown > > i wait for a reply! > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Mysql Error Message and Postgresql Question
Hi
Im my radius server gives "Mysql check_error : 1054 received "message after
user authorization procc.
What is it mean
My usergroup table is empty !!!
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
radius_xlat: 'dark'
rlm_sql (sql): sql_set_user escaped user --> 'dark'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'dark' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'dark' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
rlm_sql (sql): Released sql socket id: 4
And my second question is
im exporting detail to mysql
But i want to export detail to postgresql
At same time with mysql
i edit my
Radius.conf . Like this
# Include another file that has the SQL-related configuration.
# This is another file solely because it tends to be big.
#
# The following configuration file is for use with MySQL.
#
# For Postgresql, use: ${confdir}/postgresql.conf
# For MS-SQL, use: ${confdir}/mssql.conf
#
$INCLUDE ${confdir}/sql.conf
$INCLUDE /usr/local/radiusd/etc/raddb/postgresql.conf
# Write a 'utmp' style log file, of which users are currently
# logged in, and where they've logged in from.
#
And postgresql.conf like this
# Connect info
server = "localhost"
login = "puser"
password = "ppass"
# Database table configuration
radius_db = "pdata_db"
But in postgres radacct table is empty
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Error Message and question
Hi
Im my radius server gives "Mysql check_error : 1054 received "message after
user authorization procc.
What is it mean
My usergroup table is empty !!!
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
radius_xlat: 'dark'
rlm_sql (sql): sql_set_user escaped user --> 'dark'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'dark' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
Username = 'dark' ORDER BY id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'dark' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: MYSQL check_error: 1054 received
rlm_sql_getvpdata: database query error
rlm_sql (sql): Released sql socket id: 4
And my second question is
im exporting detail to mysql
But i want to export detail to postgresql
At same time with mysql
i edit my
Radius.conf . Like this
# Include another file that has the SQL-related configuration.
# This is another file solely because it tends to be big.
#
# The following configuration file is for use with MySQL.
#
# For Postgresql, use: ${confdir}/postgresql.conf
# For MS-SQL, use: ${confdir}/mssql.conf
#
$INCLUDE ${confdir}/sql.conf
$INCLUDE /usr/local/radiusd/etc/raddb/postgresql.conf
# Write a 'utmp' style log file, of which users are currently
# logged in, and where they've logged in from.
#
And postgresql.conf like this
# Connect info
server = "localhost"
login = "puser"
password = "ppass"
# Database table configuration
radius_db = "pdata_db"
But in postgres radacct table is empty
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
