Re: Radius reject the request
I install a new radius server as last,(for practice that know nothing
is mismatch)
and edit the correct "users" file, but radius reject me again.
Linux is so difficult :d
new debug output is attached.
The firewall is disabled.
Tanks and Best Regards
FreeRADIUS Version 2.1.12, for host i686-pc-linux-gnu, built on Jul 23 2012 at
10:00:08
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 /usr/local/etc/raddb/radiusd.conf
including configuration file /usr/local/etc/raddb/proxy.conf
including configuration file /usr/local/etc/raddb/clients.conf
including files in directory /usr/local/etc/raddb/modules/
including configuration file /usr/local/etc/raddb/modules/linelog
including configuration file /usr/local/etc/raddb/modules/ldap
including configuration file /usr/local/etc/raddb/modules/attr_filter
including configuration file /usr/local/etc/raddb/modules/digest
including configuration file /usr/local/etc/raddb/modules/counter
including configuration file /usr/local/etc/raddb/modules/smsotp
including configuration file /usr/local/etc/raddb/modules/cui
including configuration file /usr/local/etc/raddb/modules/chap
including configuration file /usr/local/etc/raddb/modules/detail
including configuration file /usr/local/etc/raddb/modules/mac2ip
including configuration file /usr/local/etc/raddb/modules/realm
including configuration file /usr/local/etc/raddb/modules/expiration
including configuration file /usr/local/etc/raddb/modules/exec
including configuration file /usr/local/etc/raddb/modules/unix
including configuration file /usr/local/etc/raddb/modules/ippool
including configuration file /usr/local/etc/raddb/modules/opendirectory
including configuration file
/usr/local/etc/raddb/modules/sqlcounter_expire_on_login
including configuration file /usr/local/etc/raddb/modules/checkval
including configuration file /usr/local/etc/raddb/modules/attr_rewrite
including configuration file /usr/local/etc/raddb/modules/detail.log
including configuration file /usr/local/etc/raddb/modules/policy
including configuration file /usr/local/etc/raddb/modules/radutmp
including configuration file /usr/local/etc/raddb/modules/preprocess
including configuration file /usr/local/etc/raddb/modules/detail.example.com
including configuration file /usr/local/etc/raddb/modules/sradutmp
including configuration file /usr/local/etc/raddb/modules/dynamic_clients
including configuration file /usr/local/etc/raddb/modules/redis
including configuration file /usr/local/etc/raddb/modules/rediswho
including configuration file /usr/local/etc/raddb/modules/smbpasswd
including configuration file /usr/local/etc/raddb/modules/files
including configuration file /usr/local/etc/raddb/modules/echo
including configuration file /usr/local/etc/raddb/modules/perl
including configuration file /usr/local/etc/raddb/modules/ntlm_auth
including configuration file /usr/local/etc/raddb/modules/wimax
including configuration file /usr/local/etc/raddb/modules/expr
including configuration file /usr/local/etc/raddb/modules/logintime
including configuration file /usr/local/etc/raddb/modules/always
including configuration file /usr/local/etc/raddb/modules/replicate
including configuration file /usr/local/etc/raddb/modules/otp
including configuration file /usr/local/etc/raddb/modules/pap
including configuration file /usr/local/etc/raddb/modules/mac2vlan
including configuration file /usr/local/etc/raddb/modules/acct_unique
including configuration file /usr/local/etc/raddb/modules/sql_log
including configuration file /usr/local/etc/raddb/modules/etc_group
including configuration file /usr/local/etc/raddb/modules/inner-eap
including configuration file /usr/local/etc/raddb/modules/passwd
including configuration file /usr/local/etc/raddb/modules/pam
including configuration file /usr/local/etc/raddb/modules/krb5
including configuration file /usr/local/etc/raddb/modules/mschap
including configuration file /usr/local/etc/raddb/modules/soh
including configuration file /usr/local/etc/raddb/eap.conf
including configuration file /usr/local/etc/raddb/policy.conf
including files in directory /usr/local/etc/raddb/sites-enabled/
including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel
including configuration file /usr/local/etc/raddb/sites-enabled/control-socket
including configuration file /usr/local/etc/raddb/sites-enabled/default
main {
allow_core_dumps = no
}
including dictionary file /usr/local/etc/raddb/dictionary
main {
name = "radiusd"
prefix = "/usr/local"
localstatedir = "/usr/local/var"
sbindir = "/usr/local/sbin"
logdir = "/usr/local/var/log/radius"
run_dir = "/usr/local/var/run/radiusd"
libdir = "/usr/local/lib"
rad
Re: sql returns fail for some stop requests
On 22 Jul 2012, at 11:56, Amir Tal wrote:
> Adding unique key to the database results in the following being returned
> from rlm_sql,
> What happen to accounting data when a duplicate entry is encountered?
> In addition, currently there is no scheduled clearing of the data in radacct
> table, wont this increase in occurrence?
>
> --
> [sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> shimoni
> [sql] sql_set_user escaped user --> 'shimoni'
> [sql] expand: %{Acct-Input-Gigawords} -> 0
> [sql] expand: %{Acct-Input-Octets} -> 0
> [sql] expand: %{Acct-Output-Gigawords} -> 0
> [sql] expand: %{Acct-Output-Octets} -> 0
> [sql] expand: %{Acct-Delay-Time} -> 12
> [sql] expand: UPDATE radacct SET acctstoptime = '%S',
> acctsessiontime= '%{Acct-Session-Time}', acctinputoctets=
> '%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',
> acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
> '%{%{Acct-Output-Octets}:-0}', acctterminatecause =
> '%{Acct-Terminate-Cause}', acctstopdelay = '%{%{Acct-Delay-Time}:-0}',
> connectinfo_stop = '%{Connect-Info}' WHERE acctsessionid =
> '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND
> nasipaddress = '%{NAS-IP-Address}' -> UPDATE radacct SET acctstoptime
> = '2012-07-22 02:03:28', acctsessiontime= '0', acctinputoctets
> = '0' << 32 | '0', acctoutputoctets = '0' << 32 | '0', acctterminatecause
> = 'User-Error', acctstopdelay = '12', connectinfo_stop = '' WHERE
> acctsessionid = 'erx
> ip:109.226.0.9:172.29.81.67:3280:96f8:1aa8:87fb:4d2:0062712021' AND username
> = 'shimoni' AND nasipaddress = '109.226.1.12'
> [sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
> rlm_sql_mysql: MYSQL check_error: 1062 received
> [sql] Couldn't insert SQL accounting STOP record - Duplicate entry
> 'c6d3d253355b3dcf' for key 2
> rlm_sql_mysql: MYSQL check_error: 1062 received
> rlm_sql_mysql: Cannot store result
> rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2'
> rlm_sql (sql): Released sql socket id: 11
> ++[sql] returns fail
> --
Can you please build against the current v2.1.x HEAD; the debug output doesn't
make sense when checking through the rlm_sql.c code. Could you also post your
dialup.conf file.
-Arran-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: sql returns fail for some stop requests
Amir Tal wrote: > Adding unique key to the database results in the following being > returned from rlm_sql, > > What happen to accounting data when a duplicate entry is encountered? It SHOULD run the normal query, followed by the "alt" query. > In addition, currently there is no scheduled clearing of the data in > radacct table, wont this increase in occurrence? Yes. Accounting is about storing data. If you want to delete data, it's one line of SQL. > [sql] Couldn't insert SQL accounting STOP record - Duplicate entry > 'c6d3d253355b3dcf' for key 2 > rlm_sql_mysql: MYSQL check_error: 1062 received > rlm_sql_mysql: Cannot store result > rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2' OK... it SHOULD run the "alt" query here, to UPDATE the record. > WARNING: Child is hung for request 5763411 in component module > . > WARNING: Child is hung for request 5763412 in component module > . And that's a problem. Your SQL database is slow. Fix it. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius down and shows Error: ASSERT FAILED modcall.c[106]: (p->type > MOD_SINGLE) && (p->type <= MOD_POLICY)
EasyHorpak.com wrote: > Sun Jul 22 06:25:05 2012 : Error: ASSERT FAILED modcall.c[106]: (p->type >> MOD_SINGLE) && (p->type <= MOD_POLICY) Upgrade. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: sql returns fail for some stop requests
Adding unique key to the database results in the following being returned from
rlm_sql,
What happen to accounting data when a duplicate entry is encountered?
In addition, currently there is no scheduled clearing of the data in radacct
table, wont this increase in occurrence?
--
[sql] expand: %{%{Stripped-User-Name}:-%{%{User-Name}:-DEFAULT}} -> shimoni
[sql] sql_set_user escaped user --> 'shimoni'
[sql] expand: %{Acct-Input-Gigawords} -> 0
[sql] expand: %{Acct-Input-Octets} -> 0
[sql] expand: %{Acct-Output-Gigawords} -> 0
[sql] expand: %{Acct-Output-Octets} -> 0
[sql] expand: %{Acct-Delay-Time} -> 12
[sql] expand: UPDATE radacct SET acctstoptime = '%S',
acctsessiontime= '%{Acct-Session-Time}', acctinputoctets=
'%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',
acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
'%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}',
acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop =
'%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username
= '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' ->
UPDATE radacct SET acctstoptime = '2012-07-22 02:03:28',
acctsessiontime= '0', acctinputoctets= '0' << 32 | '0',
acctoutputoctets = '0' << 32 | '0', acctterminatecause = 'User-Error',
acctstopdelay = '12', connectinfo_stop = '' WHERE acctsessionid =
'erx ip:109.226.0.9:172.29.81.67:3280:96f8:1aa8:87fb:4d2:0062712021' AND
username = 'shimoni' AND nasipaddress = '109.226.1.12'
[sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
rlm_sql_mysql: MYSQL check_error: 1062 received
[sql] Couldn't insert SQL accounting STOP record - Duplicate entry
'c6d3d253355b3dcf' for key 2
rlm_sql_mysql: MYSQL check_error: 1062 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'Duplicate entry 'c6d3d253355b3dcf' for key 2'
rlm_sql (sql): Released sql socket id: 11
++[sql] returns fail
--
[detail.moreshet] /var/log/radius/radacct/moreshet.relay expands to
/var/log/radius/radacct/moreshet.relay
[sql] expand: %{Acct-Delay-Time} -> 0
[detail.moreshet] expand: %t -> Sun Jul 22 02:03:34 2012
[sql] expand: UPDATE radacct SET acctstoptime = '%S',
acctsessiontime= '%{Acct-Session-Time}', acctinputoctets=
'%{%{Acct-Input-Gigawords}:-0}' << 32 | '%{%{Acct-Input-Octets}:-0}',
acctoutputoctets = '%{%{Acct-Output-Gigawords}:-0}' << 32 |
'%{%{Acct-Output-Octets}:-0}', acctterminatecause = '%{Acct-Terminate-Cause}',
acctstopdelay = '%{%{Acct-Delay-Time}:-0}', connectinfo_stop =
'%{Connect-Info}' WHERE acctsessionid = '%{Acct-Session-Id}' AND username
= '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}' ->
UPDATE radacct SET acctstoptime = '2012-07-22 02:03:34',
acctsessiontime= '0', acctinputoctets= '0' << 32 | '0',
acctoutputoctets = '0' << 32 | '0', acctterminatecause = 'User-Error',
acctstopdelay = '0', connectinfo_stop = '' WHERE acctsessionid = 'erx
ip:109.226.0.9:172.24.245.233:2653:c9e:101:e0ba:4d2:0062712040' AND username
= 'mosh19703' AND nasipaddress = '109.226.1.12'
[sql] expand: /var/log/radius/sqltrace.sql -> /var/log/radius/sqltrace.sql
[detail.moreshet] expand: /var/log/radius/radacct/moreshet.relay ->
/var/log/radius/radacct/moreshet.relay
[detail.moreshet] /var/log/radius/radacct/moreshet.relay expands to
/var/log/radius/radacct/moreshet.relay
[detail.moreshet] expand: %t -> Sun Jul 22 02:03:34 2012
++[detail.moreshet] returns ok
rlm_sql_mysql: MYSQL check_error: 1062 received
[sql] Couldn't insert SQL accounting ALIVE record - Duplicate entry
'923952cbd6569744' for key 2
rlm_sql_mysql: MYSQL check_error: 1062 received
rlm_sql_mysql: Cannot store result
rlm_sql_mysql: MySQL error 'Duplicate entry '923952cbd6569744' for key 2'
rlm_sql (sql): Released sql socket id: 27
++[sql] returns fail
--
Just wanted to state that I had started with the default provided configuration
files,
Alredy changed the rlm_sql source code, default SQL queries, default DB
structure.
There are still unclosed accounting packets existing.
Log shows a lot of warning messages:
rlm_sql (sql): Reserving sql socket id: 31
rlm_sql_mysql: query: UPDATE radacct SET acctstoptime = '2012-07-22
02:04:57', acctsessiontime= '0', acctinputoctets= '0' << 32 | '0',
acctoutputoctets = '0' << 32 | '0', acctterminatecause = 'User-Request',
acctstopdelay = '0', connectinfo_stop = '' WHERE acctsessionid = 'erx
ip:109.226.0.17:172.23.184.73:dd94:1847:fcca:a66:4d2:0051412783' AND username
= 'yali4780' AND nasipaddress = '109.226.1.20'
[sql] expand: %{Acct-Input-Gigawords} -> 0
[sql] expand: %{Acct-Input-Octets} -> 0
[sql] expand: %{Acct-Output-Gigawords} -> 0
[sql] expand: %{Acct-Output-Octets} -> 0
