rlm_sql_getvpdata: database query error

[Chris Carver]

Use tcpdump on the radius server to see if packets are being received.  
If they are not, you need to find the reason why.  A networking issue, 
not a freeradius issue.

tcpdump port 1812

Chris Carver
Network Engineer

Giuseppe Parlato wrote:

> 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
>>
>>
>
> - List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html