Re: Got a problem - mysql and radius table - more output from debuging mode

[Blake]

Here is the last few lines from radiusd -X output:
sql: accounting_stop_query_alt = INSERT into radacct (AcctSessionId, 
AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, 
AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, 
ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, 
CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, 
FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) 
values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', 
'%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', 
'%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + 
%{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', 
'%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', 
'%{Acct-Output-Octets}', '%{Called-Station-Id}', 
'%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', 
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')
sql: group_membership_query = SELECT GroupName FROM usergroup WHERE 
UserName='%{SQL-User-Name}'
sql: connect_failure_retry_delay = 60
sql: simul_count_query = 
sql: simul_verify_query = SELECT RadAcctId, AcctSessionId, UserName, 
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, 
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND 
AcctStopTime = 0
sql: postauth_table = radpostauth
sql: postauth_query = INSERT into radpostauth (id, user, pass, reply, 
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', 
'%{reply:Packet-Type}', NOW())
sql: safe-characters = 
@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /
rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and 
linked
rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/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
Segmentation fault

If that helps
-Blake-
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Got a problem - mysql and radius table - more output from debuging mode

[Scott Edwards]

On Apr 2, 2005 4:27 PM, Blake [EMAIL PROTECTED] wrote:
 Here is the last few lines from radiusd -X output:
 
 AcctStopTime = 0
 sql: postauth_table = radpostauth
 sql: postauth_query = INSERT into radpostauth (id, user, pass, reply,
 date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
 '%{reply:Packet-Type}', NOW())
 sql: safe-characters =
 @abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /
 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
 linked
 rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/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
 Segmentation fault
 
 If that helps
 
 -Blake-

Happens every time?  What release of freeradius? (upgrade if you're
not on the latest, start over, and continue if it's still doing this)

Recompile with gdb debugging support+symbols (if not present), and try
running under gdb.  Provide the output from the full backtrace when
you encounter the segfault.

(gdb) bt full

I'd suggest filing a bug report with this information. (I don't think
it'll do much good to post it here).

Thank you,



Scott Edwards
-- 
Daxal Communications - http://www.daxal.com
Surf the USA - http://www.surfthe.us

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