rlm_sql_getvpdata: database query error

[Giuseppe Parlato]

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
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
Fri May 19 20:54:01 2006 : Info: Ready to process requests.


I have freeradius -> unixODBC -> sql server



  ----- Original Message ----- 
  From: Giuseppe Parlato 
  To: FreeRadius users mailing list 
  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
  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 
    To: FreeRadius users mailing list 
    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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060519/47f19d06/attachment.html>