Re: Got a problem - mysql and radius table

Scott Edwards wrote:

>On Apr 2, 2005 11:33 AM, Blake <bmagic@cccwireless.net> 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}.GroupNa me,${groupcheck_table}.Attribute,${$
authorize_group_reply_query = "SELECT
${groupreply_table}.id,${groupreply_table}.GroupNa me,${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