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