[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freeradius-users
Subject:    Possible non-critical bugs (maybe even OT)
From:       "Andrew Melnikov" <nimnul () un ! com ! ua>
Date:       2001-07-31 16:31:22
[Download RAW message or body]

Hello everybody!

Is this the right place for bug reports and feature request? Or it's better
to go to developers' list?

I use freeradius for 2 days (latest snapshot) and I found some sessions
without disconnection time. I tried to investigate the situation and found
this:

1. There ARE stop records for these sessions in detail log but there are NO
update

2. There are a lot of error messages in radius.log. They are divided into
three categories. b) is the most important for me

a) When I get garbage over modem link (e.g. noisy line) I get something like
this. It seems that quoting/escaping in SQL queries doesn't work well:

Sun Jul 29 08:52:01 2001 : Debug: rlm_sql: Reserving sql socket id: 4
Sun Jul 29 08:52:01 2001 : Debug: SELECT IDUser, Login, 'Crypt-Password',
Passwd FROM Account.PPPUsers WHERE Login =
']C:BVukwmqTK9m<1UX\\'/pHY3Ma$.Xe<>(jt#iQCHnJesQ<)Nq%\\'GE
2]$>9~0>A2,T&&J}?%\\'3^-Do?|V>`T1]E@<\\\\\\\\Bzn?A*k(zhk*:w:TgO`\\\\\\\\.*W\
\\\\\\\.Gdf,|e[x_R\\;\\'h-\\"shG@H&_BQ,rJnkp#FzuY[T
Sun Jul 29 08:52:01 2001 : Error: MYSQL Error: Cannot get result
Sun Jul 29 08:52:01 2001 : Error: MYSQL Error: You have an error in your SQL
syntax near '' at line 1
Sun Jul 29 08:52:01 2001 : Error: rlm_sql_getvpdata: database query error
Sun Jul 29 08:52:01 2001 : Error: rlm_sql:  SQL query error; rejecting user
Sun Jul 29 08:52:01 2001 : Debug: rlm_sql: Released sql socket id: 4

... (another fragment of  log)

Sun Jul 29 11:54:15 2001 : Debug: rlm_sql: Reserving sql socket id: 4
Sun Jul 29 11:54:15 2001 : Debug: SELECT IDUser, Login, 'Crypt-Password',
Passwd FROM Account.PPPUsers WHERE Login = 'G\\'m7=`Z';
Sun Jul 29 11:54:15 2001 : Error: MYSQL Error: Cannot get result
Sun Jul 29 11:54:15 2001 : Error: MYSQL Error: You have an error in your SQL
syntax near 'm7=`Z'' at line 1
Sun Jul 29 11:54:15 2001 : Error: rlm_sql_getvpdata: database query error
Sun Jul 29 11:54:15 2001 : Error: rlm_sql:  SQL query error; rejecting user
Sun Jul 29 11:54:15 2001 : Debug: rlm_sql: Released sql socket id: 4

b) I need to disconnect users in ip-up (I use portslave+patched pppd). So I
just kill pppd in ip-up with SIGHUP. Everything except rlm_sql works fine.
Portslave sends stop-record to radiusd, radiusd puts the record into details
log file. Only rlm_sql says
"Stop packet with zero session length." and doesn't write stop info to DB.
The problem is that such empty sessions are normal for me and I want these
ones to be closed.

Sun Jul 29 16:27:50 2001 : Debug: rlm_sql: Reserving sql socket id: 4
Sun Jul 29 16:27:50 2001 : Error: rlm_sql:  Stop packet with zero session
length.  (user 'pavel', nas '192.168.2.1')
Sun Jul 29 16:27:50 2001 : Debug: rlm_sql: Released sql socket id: 4

c) I don't think this is error message, but I want someone to confirm that
this is a normal behaviour:

Sun Jul 29 10:35:35 2001 : Auth: Invalid user:
[7C@cN[.JMH+;F;S&u%vvj9OX@z).ys["<.<=]/(~;p#pP4x{O(l=0M-h+De`BW%6o'VY1/l!JW$
]z"/r^]P5TIJ~^&wIP|rOrgX3jx=] (from nas local port 15)

With best regards, Andrew

P.S. If someone wants to invite me to install some non-freeradius radiusd or
to tell something not related to the topic of my message - please, don't do
it! I wrote to the list several times (about another problems) but every
time someone replied to me with such message and I never got real reply. So
if you want to tell me something very interesting, but not about empty
sessions - please do it in direct email to me, not in this mail-list :)



[prev in list] [next in list] [prev in thread] [next in thread]