rlm_sql_getvpdata: database query error

Chris Carver ccarver at pennswoods.net
Fri May 19 21:44:30 CEST 2006


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




More information about the Freeradius-Users mailing list