Re: Got a problem - mysql and radius table

[Blake]

Scott Edwards wrote:
On Apr 2, 2005 11:33 AM, Blake <[EMAIL PROTECTED]> wrote:
 

Scott Edwards wrote:
   

and just sits there trying to start.... I look at the mysql process
table and it shows that the user has logged in and is "reading from net"
       

TCP or Unix socket, it's still a network connection. humm... maybe try
switching to TCP?
     

Scott,
I think that it is using tcp. I have tried connecting to another mysql
server from the same machine with the same results.
   

 

How do I know if it's tcp? 
   

TCP for remote (and sometimes local) connections, and unix sockets
(most always) localy.
 

Where is the settings?
   

sql.conf
Thanks,
Scott Edwards
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 

I don't see the option in sql.conf.  Here is what I do have
sql {
       driver = "rlm_sql_mysql"
       server = "localhost"
       login = "sqladmin"
       password = "***"
       radius_db = "radius"
       acct_table1 = "radacct"
       acct_table2 = "radacct"
       postauth_table = "radpostauth"
       authcheck_table = "radcheck"
       authreply_table = "radreply"
       groupcheck_table = "radgroupcheck"
       groupreply_table = "radgroupreply"
       usergroup_table = "usergroup"
       deletestalesessions = yes
       sqltrace = no
       sqltracefile = ${logdir}/sqltrace.sql
       num_sql_socks = 5
       connect_failure_retry_delay = 60
       sql_user_name = "%{User-Name}"
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM 
${authcheck_table} WHERE Username = '%{SQL-User-Name}' $
authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM 
${authreply_table} WHERE Username = '%{SQL-User-Name}' $
authorize_group_check_query = "SELECT 
${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${$
authorize_group_reply_query = "SELECT 
${groupreply_table}.id,${groupreply_table}.GroupName,${groupreply_table}.Attribute,${$
accounting_onoff_query = "UPDATE ${acct_table1} SET AcctStopTime='%S', 
AcctSessionTime=unix_timestamp('%S') - unix_$

       accounting_update_query = "UPDATE ${acct_table1} \
        SET FramedIPAddress = '%{Framed-IP-Address}', \
        AcctSessionTime = '%{Acct-Session-Time}', \
        AcctInputOctets = '%{Acct-Input-Octets}', \
        AcctOutputOctets = '%{Acct-Output-Octets}' \
        WHERE AcctSessionId = '%{Acct-Session-Id}' \
        AND UserName = '%{SQL-User-Name}' \
        AND NASIPAddress= '%{NAS-IP-Address}'"
       accounting_update_query_alt = "INSERT into ${acct_table1} 
(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddre$
       accounting_start_query = "INSERT into ${acct_table1} 
(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, N$
       accounting_start_query_alt  = "UPDATE ${acct_table1} SET 
AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}$
       simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPAddress, CallingS$
     group_membership_query = "SELECT GroupName FROM ${usergroup_table} 
WHERE UserName='%{SQL-User-Name}'"
      postauth_query = "INSERT into ${postauth_table} (id, user, pass, 
reply, date) values ('', '%{User-Name}', '%{User-P$
       readclients = yes
}


Any help?
-Blake-
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html