rlm_sql_getvpdata: database query error

[Giuseppe Parlato]

It is an upgrade, so firewall can't be the problem

Giuseppe

----- Original Message ----- 
From: "Chris Carver" <ccarver at pennswoods.net>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Friday, May 19, 2006 8:28 PM
Subject: Re: rlm_sql_getvpdata: database query error


> No access-requests are making it to your radius server then.  You need to 
> make sure your client is pointed at it properly or that you don't have 
> your radius server firewalled.
>
> Chris Carver
> Network Engineer
>
> Giuseppe Parlato wrote:
>
>> 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
>>
>
> - 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
>
>