FW: Install - Freeradius can't connect to MySQL

[Chris Carver]

According to your output it is definitely connecting.  5 open 
connections to the mysql db is the default configuration.  If you look 
in etc/raddb/sql.conf you'll see the variable 'num_sql_socks = 5'   This 
is what controls the number of open connections.

Chris Carver
Network Engineer

Cliff Hayes wrote:
> Hello again,
>
> This may shed some light on the situation.  When I run in debug mode with -x
> option, it looks like it may be connecting.  Am I interpreting the output
> correctly?  If so, is it normal to connect 5 times?
>
> Cliff
>
> 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 root 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 files
> Module: Instantiated files (files)
> 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.
>
> -----Original Message-----
> From: freeradius-users-bounces+chayes=afo.net at lists.freeradius.org
> [mailto:freeradius-users-bounces+chayes=afo.net at lists.freeradius.org]On
> Behalf Of Cliff Hayes
> Sent: Wednesday, June 07, 2006 2:28 PM
> To: freeradius-users at lists.freeradius.org
> Subject: Install - Freeradius can't connect to MySQL
>
>
> Hello,
>
> Warning - newbie installing Freeradius.
>
> I get this in the radius.log even though the sql.conf has the correct
> host/user/password (and I can access MySQL from the command line using the
> same login criteria):
>
> Wed Jun  7 14:01:52 2006 : Info: rlm_sql_mysql: Starting connect to MySQL
> server for #0
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql_mysql: Couldn't connect socket to
> MySQL server root at localhost:radius
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql_mysql: Mysql error 'Can't connect
> to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
> Wed Jun  7 14:01:52 2006 : Error: rlm_sql (sql): Failed to connect DB handle
> #0
> Wed Jun  7 14:01:52 2006 : Info: Ready to process requests.
>
> Thanks,
>
> Cliff
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>