No requests are hitting your radius server. Look at the last line,
'ready to process requests.' Its not processing anything. You need to
make sure the access-request packets from the client are making their
way to the server. Well, you can be sure they're not if thats all thats
showing in radiusd -X. You need to figure out why
Chris Carver
Network Engineer
Giuseppe Parlato wrote:
tail -f /usr/local/var/log/radius/radius.log
Fri May 19 20:52:29 2006 : Info: Using deprecated naslist file.
Support for this will go away soon.
Fri May 19 20:52:29 2006 : Info: rlm_exec: Wait=yes but no output
defined. Did you mean output=none?
Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Driver
rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked
Fri May 19 20:52:29 2006 : Info: rlm_sql (sql): Attempting to connect
to [EMAIL PROTECTED]:/Bill <mailto:[EMAIL PROTECTED]:/Bill>
Fri May 19 20:52:29 2006 : Info: Ready to process requests.
Fri May 19 20:54:01 2006 : Info: Using deprecated naslist file.
Support for this will go away soon.
Fri May 19 20:54:01 2006 : Info: rlm_exec: Wait=yes but no output
defined. Did you mean output=none?
Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Driver
rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked
Fri May 19 20:54:01 2006 : Info: rlm_sql (sql): Attempting to connect
to [EMAIL PROTECTED]:/Bill <mailto:[EMAIL PROTECTED]:/Bill>
Fri May 19 20:54:01 2006 : Info: Ready to process requests.
I have freeradius -> unixODBC -> sql server
----- Original Message -----
*From:* Giuseppe Parlato <mailto:[EMAIL PROTECTED]>
*To:* FreeRadius users mailing list
<mailto:[email protected]>
*Sent:* Friday, May 19, 2006 7:43 PM
*Subject:* Re: rlm_sql_getvpdata: database query error
Now I do not have that error, I started radiusd -x end:
Starting - reading configuration files ...
Using deprecated naslist file. Support for this will go away soon.
Module: Loaded exec
rlm_exec: Wait=yes but no output defined. Did you mean output=none?
Module: Instantiated exec (exec)
Module: Loaded expr
Module: Instantiated expr (expr)
Module: Loaded PAP
Module: Instantiated pap (pap)
Module: Loaded CHAP
Module: Instantiated chap (chap)
Module: Loaded MS-CHAP
Module: Instantiated mschap (mschap)
Module: Loaded DIGEST
Module: Instantiated digest (digest)
Module: Loaded System
Module: Instantiated unix (unix)
Module: Loaded eap
rlm_eap: Loaded and initialized type md5
rlm_eap: Loaded and initialized type leap
rlm_eap: Loaded and initialized type gtc
rlm_eap: Loaded and initialized type mschapv2
Module: Instantiated eap (eap)
Module: Loaded preprocess
Module: Instantiated preprocess (preprocess)
Module: Loaded realm
Module: Instantiated realm (suffix)
Module: Loaded files
Module: Instantiated files (files)
Module: Loaded SQL
rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc)
loaded and linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/Bill
<mailto:[EMAIL PROTECTED]:/Bill>
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #0
rlm_sql (sql): Connected new DB handle, #0
rlm_sql (sql): starting 1
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #1
rlm_sql (sql): Connected new DB handle, #1
rlm_sql (sql): starting 2
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #2
rlm_sql (sql): Connected new DB handle, #2
rlm_sql (sql): starting 3
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #3
rlm_sql (sql): Connected new DB handle, #3
rlm_sql (sql): starting 4
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #4
rlm_sql (sql): Connected new DB handle, #4
rlm_sql (sql): starting 5
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #5
rlm_sql (sql): Connected new DB handle, #5
rlm_sql (sql): starting 6
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #6
rlm_sql (sql): Connected new DB handle, #6
rlm_sql (sql): starting 7
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #7
rlm_sql (sql): Connected new DB handle, #7
rlm_sql (sql): starting 8
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #8
rlm_sql (sql): Connected new DB handle, #8
rlm_sql (sql): starting 9
rlm_sql (sql): Attempting to connect rlm_sql_unixodbc #9
rlm_sql (sql): Connected new DB handle, #9
Module: Instantiated sql (sql)
Module: Loaded detail
Module: Instantiated detail (detail)
Module: Loaded radutmp
Module: Instantiated radutmp (radutmp)
Initializing the thread pool...
Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
...after that just nothing !
----- Original Message -----
*From:* Giuseppe Parlato <mailto:[EMAIL PROTECTED]>
*To:* FreeRadius users mailing list
<mailto:[email protected]>
*Sent:* Friday, May 19, 2006 7:01 PM
*Subject:* rlm_sql_getvpdata: database query error
I upgraded freeradius from 1.0.1 to 1.1.1 and I get the
following error:
rlm_sql_getvpdata: database query error
can anyone help me please?
Giuseppe
------------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date:
18/05/2006
------------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date:
18/05/2006
------------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
