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 xxxx@xxx:/Bill <mailto:xxxx@xxx:/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 xxxx@xxxx:/Bill <mailto:xxxx@xxxx:/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:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *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 xxxxx@xxxx:/Bill <mailto:xxxxx@xxxx:/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:gparlato@tnet.it> *To:* FreeRadius users mailing list <mailto:freeradius-users@lists.freeradius.org> *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