Hi All,
Have posted a question similar to this before, does anyone else see
freeradius crashing while/during running sql queries?
Freeradius is running on redhat 8.0 (same thing happens on freebsd 5.3 as
well).
MySQL is running on redhat 8.0 (was previously running on freebsd 5.1 -
where same thing happened)
Im going insane trying to figure out why it crashes. I've tried everything I
can think of.
Here's some output from radiusd -X - Crashes in both single user mode, and
threaded mode.
modcall: group accounting returns ok for request 321
Sending Accounting-Response of id 245 to 192.168.0.33:35486
Proxy-State = 0x3132
Proxy-State = 0x30
Finished request 321
Going to the next request
Waking up in 2 seconds...
rad_recv: Access-Request packet from host 192.168.0.33:35486, id=152,
length=281
X-Ascend-PPP-VJ-1172 = 0x41555448454e544943415445
User-Password = "mene26"
User-Name = "nokisiiopu"
Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a:0010032733"
Service-Type = Framed-User
Framed-Protocol = PPP
Called-Station-Id = "0870906700"
NAS-Port-Type = Virtual
NAS-Port = 5492101
NAS-Port-Id =
"ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a"
NAS-IP-Address = 210.55.233.12
NAS-Identifier = "MDR-IP02E"
X-Ascend-Handle-IPX = 0x6e6f6b697369696f7075
X-Ascend-Netware-timeout = 0x636f6e636570746e6574
Proxy-State = 0x30
rad_rmspace_pair: User-Name now 'nokisiiopu'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 322
modcall[authorize]: module "preprocess" returns ok for request 322
modcall[authorize]: module "chap" returns noop for request 322
modcall[authorize]: module "mschap" returns noop for request 322
rlm_realm: No '@' in User-Name = "nokisiiopu", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 322
radius_xlat: 'nokisiiopu'
rlm_sql (sql): sql_set_user escaped user --> 'nokisiiopu'
rlm_sql (sql): Reserving sql socket id: 9
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
STRCMP(Username, 'nokisiiopu') = 0 ORDER BY id'
rlm_sql (sql): User found in radcheck table
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE
STRCMP(Username, 'nokisiiopu') = 0 ORDER BY id'
radius_xlat: 'SELECT GroupName FROM usergroup WHERE UserName='nokisiiopu''
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
STRCMP(usergroup.Username, 'nokisiiopu') = 0 AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql (sql): User found in group KOLnokisiiopu
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
STRCMP(usergroup.Username, 'nokisiiopu') = 0 AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql (sql): Released sql socket id: 9
modcall[authorize]: module "sql" returns ok for request 322
modcall: group authorize returns ok for request 322
rad_check_password: Found Auth-Type Local
auth: type Local
auth: user supplied User-Password matches local User-Password
Login OK: [nokisiiopu] (from client telecomproxy1 port 5492101)
Processing the post-auth section of radiusd.conf
modcall: entering group post-auth for request 322
rlm_sql (sql): Processing sql_postauth
radius_xlat: 'nokisiiopu'
rlm_sql (sql): sql_set_user escaped user --> 'nokisiiopu'
radius_xlat: 'INSERT into radpostauth (id, user, pass, reply, date) values
('', 'nokisiiopu', 'mene26', 'Access-Accept', NOW())'
rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id, user,
pass, reply, date) values ('', 'nokisiiopu', 'mene26', 'Access-Accept',
NOW())
rlm_sql (sql): Reserving sql socket id: 8
rlm_sql (sql): Released sql socket id: 8
modcall[post-auth]: module "sql" returns ok for request 322
modcall: group post-auth returns ok for request 322
Sending Access-Accept of id 152 to 192.168.0.33:35486
Service-Type := Framed-User
Framed-Protocol := PPP
Proxy-State = 0x30
Finished request 322
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
rad_recv: Accounting-Request packet from host 192.168.0.33:35486, id=74,
length=311
X-Ascend-PPP-VJ-1172 = 0x4c41535f41434354
X-Ascend-PPP-VJ-1172 = 0x4c41535f41434354
Acct-Status-Type = Start
User-Name = "nokisiiopu"
Event-Timestamp = "Feb 8 2005 11:00:35 NZDT"
Acct-Delay-Time = 0
NAS-Identifier = "MDR-IP02E"
Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a:0010032733"
NAS-IP-Address = 210.55.233.12
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = None
Framed-IP-Address = 202.150.98.132
Framed-IP-Netmask = 255.255.255.255
Called-Station-Id = "0870906700"
Calling-Station-Id = "9833"
NAS-Port-Type = Virtual
NAS-Port = 5492101
NAS-Port-Id =
"ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a"
Acct-Authentic = RADIUS
X-Ascend-Handle-IPX = 0x6e6f6b697369696f7075
X-Ascend-Netware-timeout = 0x
Proxy-State = 0x3132
Proxy-State = 0x30
rad_rmspace_pair: User-Name now 'nokisiiopu'
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 323
modcall[preacct]: module "preprocess" returns noop for request 323
rlm_acct_unique: Hashing 'NAS-Port = 5492101,Client-IP-Address =
192.168.0.33,NAS-IP-Address = 210.55.233.12,Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a:0010032733",User
-Name = "nokisiiopu"'
rlm_acct_unique: Acct-Unique-Session-ID = "1686574eff6d3be2".
modcall[preacct]: module "acct_unique" returns ok for request 323
rlm_realm: No '@' in User-Name = "nokisiiopu", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[preacct]: module "suffix" returns noop for request 323
modcall[preacct]: module "files" returns noop for request 323
modcall: group preacct returns ok for request 323
Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 323
radius_xlat: 'nokisiiopu'
rlm_sql (sql): sql_set_user escaped user --> 'nokisiiopu'
radius_xlat: '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('erx
ip:210.55.234.48:192.168.251.242:1e59:325:7f15:69a:1b270d0a:0010032733',
'1686574eff6d3be2', 'nokisiiopu', '', '210.55.233.12', '5492101', 'Virtual',
'2005-02-08 10:59:06', '0', '0', 'RADIUS', '', '', '0', '0', '0870906700',
'9833', '', 'Framed-User', 'PPP', '202.150.98.132', '0', '0')'
rlm_sql (sql): Reserving sql socket id: 7
rlm_sql (sql): Released sql socket id: 7
modcall[accounting]: module "sql" returns ok for request 323
modcall: group accounting returns ok for request 323
Sending Accounting-Response of id 74 to 192.168.0.33:35486
Proxy-State = 0x3132
Proxy-State = 0x30
Finished request 323
Going to the next request
Cleaning up request 317 ID 97 with timestamp 4207e4a8
Waking up in 1 seconds...
--- Walking the entire request list ---
Cleaning up request 318 ID 141 with timestamp 4207e4a8
Waking up in 1 seconds...
--- Walking the entire request list ---
Cleaning up request 319 ID 128 with timestamp 4207e4a9
Cleaning up request 320 ID 217 with timestamp 4207e4a9
Cleaning up request 321 ID 245 with timestamp 4207e4a9
Waking up in 1 seconds...
rad_recv: Accounting-Request packet from host 192.168.0.33:35486, id=72,
length=367
X-Ascend-PPP-VJ-1172 = 0x4c41535f41434354
X-Ascend-PPP-VJ-1172 = 0x4c41535f41434354
Acct-Status-Type = Alive
User-Name = "areesa"
Event-Timestamp = "Feb 8 2005 11:00:38 NZDT"
Acct-Delay-Time = 0
NAS-Identifier = "MDR-IP02E"
Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.239:338a:393:73fc:ff:900e1407:0010029943"
NAS-IP-Address = 210.55.233.12
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Compression = None
Framed-IP-Address = 202.150.98.73
Framed-IP-Netmask = 255.255.255.255
Called-Station-Id = "0870306700"
Calling-Station-Id = "3942"
Acct-Input-Gigawords = 0
Acct-Input-Octets = 4029846
Acct-Output-Gigawords = 0
Acct-Output-Octets = 4603784
ERX-Input-Gigapkts = 0
Acct-Input-Packets = 25666
ERX-Output-Gigapkts = 0
Acct-Output-Packets = 23678
NAS-Port-Type = Virtual
NAS-Port = 5489322
NAS-Port-Id =
"ip:210.55.234.48:192.168.251.239:338a:393:73fc:ff:900e1407"
Acct-Authentic = RADIUS
Acct-Session-Time = 3600
X-Ascend-Handle-IPX = 0x617265657361
X-Ascend-Netware-timeout = 0x
Proxy-State = 0x3132
Proxy-State = 0x30
rad_rmspace_pair: User-Name now 'areesa'
Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 324
modcall[preacct]: module "preprocess" returns noop for request 324
rlm_acct_unique: Hashing 'NAS-Port = 5489322,Client-IP-Address =
192.168.0.33,NAS-IP-Address = 210.55.233.12,Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.239:338a:393:73fc:ff:900e1407:0010029943",User-
Name = "areesa"'
rlm_acct_unique: Acct-Unique-Session-ID = "0251186e4bcefdb2".
modcall[preacct]: module "acct_unique" returns ok for request 324
rlm_realm: No '@' in User-Name = "areesa", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[preacct]: module "suffix" returns noop for request 324
modcall[preacct]: module "files" returns noop for request 324
modcall: group preacct returns ok for request 324
Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 324
radius_xlat: 'areesa'
rlm_sql (sql): sql_set_user escaped user --> 'areesa'
radius_xlat: 'UPDATE radacct ? SET FramedIPAddress = '202.150.98.73', ?
AcctSessionTime = '3600', ? AcctInputOctets = '4029846', ? AcctOutputOctets
= '4603784' ? WHERE AcctSessionId = 'erx
ip:210.55.234.48:192.168.251.239:338a:393:73fc:ff:900e1407:0010029943' ? AND
UserName = 'areesa' ? AND NASIPAddress= '210.55.233.12''
rlm_sql (sql): Reserving sql socket id: 6
radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime,
AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets,
CalledStationId, CallingStationId, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay) values('erx
ip:210.55.234.48:192.168.251.239:338a:393:73fc:ff:900e1407:0010029943',
'0251186e4bcefdb2', 'areesa', '', '210.55.233.12', '5489322', 'Virtual',
DATE_SUB('2005-02-08 10:59:09',INTERVAL (3600 + 0) SECOND), '3600',
'RADIUS', '', '4029846', '4603784', '0870306700', '3942', 'Framed-User',
'PPP', '202.150.98.73', '0')'
rlm_sql (sql): Released sql socket id: 6
modcall[accounting]: module "sql" returns ok for request 324
modcall: group accounting returns ok for request 324
Sending Accounting-Response of id 72 to 192.168.0.33:35486
Proxy-State = 0x3132
Proxy-State = 0x30
Finished request 324
Going to the next request
--- Walking the entire request list ---
Cleaning up request 323 ID 74 with timestamp 4207e4aa
Cleaning up request 322 ID 152 with timestamp 4207e4aa
Waking up in 3 seconds...
rad_recv: Access-Request packet from host 192.168.0.33:35486, id=47,
length=275
X-Ascend-PPP-VJ-1172 = 0x41555448454e544943415445
User-Password = "680430"
User-Name = "yvoyuhua"
Acct-Session-Id = "erx
ip:210.55.234.48:192.168.251.234:1e5c:110:7f18:6c4:2291d0a:0010032736"
Service-Type = Framed-User
Framed-Protocol = PPP
Called-Station-Id = "0870906700"
NAS-Port-Type = Virtual
NAS-Port = 5492103
NAS-Port-Id =
"ip:210.55.234.48:192.168.251.234:1e5c:110:7f18:6c4:2291d0a"
NAS-IP-Address = 210.55.233.12
NAS-Identifier = "MDR-IP02E"
X-Ascend-Handle-IPX = 0x79766f7975687561
X-Ascend-Netware-timeout = 0x636f6e636570746e6574
Proxy-State = 0x30
rad_rmspace_pair: User-Name now 'yvoyuhua'
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 325
modcall[authorize]: module "preprocess" returns ok for request 325
modcall[authorize]: module "chap" returns noop for request 325
modcall[authorize]: module "mschap" returns noop for request 325
rlm_realm: No '@' in User-Name = "yvoyuhua", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall[authorize]: module "suffix" returns noop for request 325
radius_xlat: 'yvoyuhua'
rlm_sql (sql): sql_set_user escaped user --> 'yvoyuhua'
rlm_sql (sql): Reserving sql socket id: 5
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
STRCMP(Username, 'yvoyuhua') = 0 ORDER BY id'
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 8192 (LWP 8086)]
0x400ea8e1 in sql_userparse (first_pair=0xbfffc88c, row=0x818f690) at
sql.c:359
359 if (((row[3][0] == '\'') ||
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
