Don't work freeradius with MySQL.

[tnt at kalik.co.yu]

Debug with capital X ==> radiusd -X.

Ivan Kalik
Kalik Informatika ISP


Dana 23/1/2008, "mohsen rahmanian" <rahmanian60 at gmail.com> piše:

>Hi dears,
>
>I install freeradius, MySQL on Ubuntu 7 and work correctly with file
>authentication, but where follow "http://wiki.freeradius.org/SQL_HOWTO"
>instruction don't get any response. my output when run 'freeradius -x'  are:
>****
>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 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 SQL
>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
>rlm_sql (sql): Attempting to connect to radius at localhost:/radius
>rlm_sql (sql): starting 0
>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
>rlm_sql_mysql: Starting connect to MySQL server for #0
>rlm_sql (sql): Connected new DB handle, #0
>rlm_sql (sql): starting 1
>rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
>rlm_sql_mysql: Starting connect to MySQL server for #1
>rlm_sql (sql): Connected new DB handle, #1
>rlm_sql (sql): starting 2
>rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
>rlm_sql_mysql: Starting connect to MySQL server for #2
>rlm_sql (sql): Connected new DB handle, #2
>rlm_sql (sql): starting 3
>rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
>rlm_sql_mysql: Starting connect to MySQL server for #3
>rlm_sql (sql): Connected new DB handle, #3
>rlm_sql (sql): starting 4
>rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
>rlm_sql_mysql: Starting connect to MySQL server for #4
>rlm_sql (sql): Connected new DB handle, #4
>Module: Instantiated sql (sql)
>Module: Loaded Acct-Unique-Session-Id
>Module: Instantiated acct_unique (acct_unique)
>Module: Loaded detail
>Module: Instantiated detail (detail)
>Module: Loaded radutmp
>Module: Instantiated radutmp (radutmp)
>Module: Loaded sql_log
>Module: Instantiated sql_log (sql_log)
>Initializing the thread pool...
>Listening on authentication *:1812
>Listening on accounting *:1813
>Ready to process requests.
>****
>
>debug msg are:
>
>#####
>rad_recv: Access-Request packet from host 192.168.1.7:1500, id=2, length=45
>        User-Name = "fred"
>        CHAP-Password = 0xdd72a5e140beedbac0d9088eb9a4fb1bce
>  rlm_chap: Setting 'Auth-Type := CHAP'
>rad_recv: Access-Request packet from host 192.168.1.7:1500, id=2, length=45
>rad_recv: Access-Request packet from host 192.168.1.7:1500, id=2, length=45
>#####
>
>I add my client IP (192.168.1.7) on clients.conf and naslist and insert a
>record in nas table .
>I use NTRadPing for test FreeRadius.
>
>Why?
>--
>Best Regards
>Rahmanian
>
>