RE: Segmentation fault on Freeradius
Thanks everybody, it is now working. I found the error in the SQL_INIT_SOCKET function which closes the socket in case it fails to perform an OCILogon to the DB. I've just commented this line and it is now working fine. I'll submit this to the development list for more clarification and fix. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Segmentation fault on Freeradius
At first glance, this appears to be barfing because it's trying to contact the absent server with OCIErrorGet to find out why it can't contact the server As a test, try putting 'return msgbuf;' on line 48, right after the memset call. You'll get no error text in your logs, but if that fixes it then we've possibly hit a segfaulting bug in liboracleclient... I did that test, but I've got the error right after trying to execute the alt_start_query, which is updating the radacct table for start packet. It'd be worth checking the values of the parameters to OCIErrorGet to confirm they're what we'd expect... I think the command in GDB is 'print oracle_sock-errHandle' and the like... Mind you, I don't know the meaning of the parameters to OCIErrorCode anyway... It may just need some parameter checking before OCIErrorCode is called. Anyway, the reason it doesn't failover is because this segfault comes on the line before the module returns RLM_MODULE_FAIL, which I expect would trigger the failover. So with the 'return' inserted as described above, it should failover fine. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius snmp and MIBS problem
I've configured the Freeradius to work with snmp. I discovered that I only get snmp response on some of the MIBS but not the others. Does Freeradius treat or manipulate all MIBS, if yes, why I cannot get reply for such MIB: radiusAccServTotalInvalidRequests, I am getting replies only on radiusAccServTotalRequests, radiusAccServUpTime, radiusAccServResetTime and radiusAccClientTable. Appreciate your help. Regards Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation fault on Freeradius
rlm_sql_oracle #1 Sun Aug 3 07:12:30 2003 : Debug: rl_next: returning NULL Sun Aug 3 07:12:30 2003 : Debug: Waking up in 5 seconds... Sun Aug 3 07:12:30 2003 : Error: rlm_sql_oracle: Oracle logon failed: 'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory ' Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): Failed to connect DB handle #1 Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): reconnect failed, database down? Segmentation Fault Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Reading Freeradius MIBS
Dear all I've configured the Freeradius to work with snmp in order to plot some graphical diagrams on MRTG, But I've faced a small problem, which I believe I am mistaken somewhere. I discovered that I only get snmp response on some of the MIBS but not the others, I've tried to dig into the code, I've also found that it did not add on to some MIBs, that's why I needed some clarification. Does Freeradius treat or manipulate all MIBS, if yes, why I cannot get reply for such MIB: radiusAccServTotalInvalidRequests, I am getting replies only on radiusAccServTotalRequests, radiusAccServUpTime, radiusAccServResetTime and radiusAccClientTable. Appreciate your help. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation fault in SQL accounting with ORACLE
rlm_sql_oracle #1 Sun Aug 3 07:12:30 2003 : Debug: rl_next: returning NULL Sun Aug 3 07:12:30 2003 : Debug: Waking up in 5 seconds... Sun Aug 3 07:12:30 2003 : Error: rlm_sql_oracle: Oracle logon failed: 'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory ' Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): Failed to connect DB handle #1 Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): reconnect failed, database down? Segmentation Fault Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation fault in the Accounting
: rlm_sql (sql2): Attempting to connect rlm_sql_oracle #1 Sun Aug 3 07:12:30 2003 : Debug: rl_next: returning NULL Sun Aug 3 07:12:30 2003 : Debug: Waking up in 5 seconds... Sun Aug 3 07:12:30 2003 : Error: rlm_sql_oracle: Oracle logon failed: 'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory ' Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): Failed to connect DB handle #1 Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): reconnect failed, database down? Segmentation Fault Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius MIBS
Dear all I've configured the Freeradius to work with snmp in order to plot some graphical diagrams on MRTG, But I've faced a small problem, which I believe I am mistaken somewhere. I discovered that I only get snmp response on some of the MIBS but not the others, I've tried to dig into the code, I've also found that it did not manipulate some MIBs, that's why I needed some clarification. Does Freeradius treat or manipulate all MIBS, if yes, why I cannot get reply for such MIB: radiusAccServTotalInvalidRequests, I am getting replies only on radiusAccServTotalRequests, radiusAccServUpTime, radiusAccServResetTime and radiusAccClientTable. Appreciate your help. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Segmentation fault
Thanks for the reply and sorry for being late, it took me a while to run
the server with gdb, any how here is the output of the gdb, I've went
further more with that and I've compared the program (rlm_sql_oracle)
for Version 0.7.1 (which was working perfect for accounting in case the
primary DB goes down) and Version 0.9, both of them lokk the same for
the function causing the segmentation fault.
Any help would be appreciated.
Start of the output of gdb
Tue Aug 12 10:40:04 2003 : Debug: radius_xlat: 'INSERT into RADACCT
(RadAcctId, 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('', '3790948411', '', 'eim1', '',
'194.170.127.204', '1234', 'Async', TO_DATE('2003-08-12
10:40:04','-mm-dd hh24:mi:ss'), '', '0', '', '', '', '0', '0', '',
'2305809', '', 'Framed-User', 'PPP', '', '0', '0')'
Tue Aug 12 10:40:04 2003 : Debug: rlm_sql (sql2): Reserving sql socket
id: 2
Tue Aug 12 10:40:04 2003 : Error: rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
Tue Aug 12 10:40:04 2003 : Debug: rlm_sql (sql2): Attempting to connect
rlm_sql_oracle #2
Tue Aug 12 10:40:04 2003 : Debug: rl_next: returning NULL
Tue Aug 12 10:40:04 2003 : Debug: Waking up in 5 seconds...
Tue Aug 12 10:40:04 2003 : Error: rlm_sql_oracle: Oracle logon failed:
'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
exist SVR4 Error: 2: No such file or directory '
Tue Aug 12 10:40:04 2003 : Error: rlm_sql (sql2): Failed to connect DB
handle #2
Tue Aug 12 10:40:04 2003 : Error: rlm_sql (sql2): reconnect failed,
database down?
Program received signal SIGSEGV, Segmentation fault.
[Switching to LWP 7]
sql_error (sqlsocket=0x1ba880, config=0x196d50) at sql_oracle.c:49
49 OCIErrorGet((dvoid *) oracle_sock-errHandle, (ub4) 1,
(text *) NULL,
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb) bt
#0 sql_error (sqlsocket=0x1ba880, config=0x196d50) at sql_oracle.c:49
#1 0xfee430b0 in rlm_sql_accounting (instance=0x193ed0,
request=0x1f8de8) at rlm_sql.c:793
#2 0x0001da5c in module_post_auth ()
#3 0x0001db44 in modcall ()
#4 0x0001daa0 in module_post_auth ()
#5 0x0001dbdc in modcall ()
#6 0x0001daa0 in module_post_auth ()
#7 0x0001dbdc in modcall ()
#8 0x00017b50 in rad_accounting ()
#9 0x00015614 in rad_respond ()
#10 0x0001fb88 in radius_xlat ()
(gdb)
Regards
---
Yasser Ahmed Hosny
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Segmentation fault
I am submitting my reply again, can anyone help me please with this
case, it is really important
Thanks for the reply and sorry for being late, it took me a while to run
the server with gdb, any how here is the output of the gdb, I've went
further more with that and I've compared the program (rlm_sql_oracle)
for Version 0.7.1 (which was working perfect for accounting in case the
primary DB goes down) and Version 0.9, both of them lokk the same for
the function causing the segmentation fault.
Any help would be appreciated.
=
Start of the output of gdb
Tue Aug 12 10:40:04 2003 : Debug: radius_xlat: 'INSERT into RADACCT
(RadAcctId, 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('', '3790948411', '', 'eim1', '',
'194.170.127.204', '1234', 'Async', TO_DATE('2003-08-12
10:40:04','-mm-dd hh24:mi:ss'), '', '0', '', '', '', '0', '0', '',
'2305809', '', 'Framed-User', 'PPP', '', '0', '0')'
Tue Aug 12 10:40:04 2003 : Debug: rlm_sql (sql2): Reserving sql socket
id: 2
Tue Aug 12 10:40:04 2003 : Error: rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
Tue Aug 12 10:40:04 2003 : Debug: rlm_sql (sql2): Attempting to connect
rlm_sql_oracle #2
Tue Aug 12 10:40:04 2003 : Debug: rl_next: returning NULL
Tue Aug 12 10:40:04 2003 : Debug: Waking up in 5 seconds...
Tue Aug 12 10:40:04 2003 : Error: rlm_sql_oracle: Oracle logon failed:
'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
exist SVR4 Error: 2: No such file or directory '
Tue Aug 12 10:40:04 2003 : Error: rlm_sql (sql2): Failed to connect DB
handle #2
Tue Aug 12 10:40:04 2003 : Error: rlm_sql (sql2): reconnect failed,
database down?
Program received signal SIGSEGV, Segmentation fault.
[Switching to LWP 7]
sql_error (sqlsocket=0x1ba880, config=0x196d50) at sql_oracle.c:49
49 OCIErrorGet((dvoid *) oracle_sock-errHandle, (ub4) 1,
(text *) NULL,
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb)
(gdb) bt
#0 sql_error (sqlsocket=0x1ba880, config=0x196d50) at sql_oracle.c:49
#1 0xfee430b0 in rlm_sql_accounting (instance=0x193ed0,
request=0x1f8de8) at rlm_sql.c:793
#2 0x0001da5c in module_post_auth ()
#3 0x0001db44 in modcall ()
#4 0x0001daa0 in module_post_auth ()
#5 0x0001dbdc in modcall ()
#6 0x0001daa0 in module_post_auth ()
#7 0x0001dbdc in modcall ()
#8 0x00017b50 in rad_accounting ()
#9 0x00015614 in rad_respond ()
#10 0x0001fb88 in radius_xlat ()
(gdb)
Regards
--
Yasser Ahmed Hosny
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation fault
): Released sql socket
id: 2
Sun Aug 3 07:12:01 2003 : Debug: modcall[accounting]: module sql2
returns ok
Sun Aug 3 07:12:01 2003 : Debug: modcall: group redundant returns ok
Sun Aug 3 07:12:01 2003 : Debug: modcall: group accounting returns ok
Sending Accounting-Response of id 163 to xxx.xxx.xxx.xxx:38499
Sun Aug 3 07:12:01 2003 : Debug: Finished request 0
Sun Aug 3 07:12:01 2003 : Debug: Going to the next request
Sun Aug 3 07:12:01 2003 : Debug: Thread 1 waiting to be assigned a
request
Sun Aug 3 07:12:06 2003 : Debug: --- Walking the entire request list
---
Sun Aug 3 07:12:06 2003 : Debug: Threads: total/active/spare threads =
5/0/5
Sun Aug 3 07:12:06 2003 : Debug: Waking up in 1 seconds...
Sun Aug 3 07:12:07 2003 : Debug: --- Walking the entire request list
---
Sun Aug 3 07:12:07 2003 : Debug: Cleaning up request 0 ID 163 with
timestamp 3f2c7d81
Sun Aug 3 07:12:07 2003 : Debug: Nothing to do. Sleeping until we see
a request.
The debug output after accounting DB shutdown:
rad_recv: Accounting-Request packet from host xxx.xxx.xxx.xxx:38501,
id=164, length=79
Sun Aug 3 07:12:30 2003 : Debug: Thread 2 assigned request 1
Sun Aug 3 07:12:30 2003 : Debug: --- Walking the entire request list
---
Sun Aug 3 07:12:30 2003 : Debug: Threads: total/active/spare threads =
5/1/4
Sun Aug 3 07:12:30 2003 : Debug: Waking up in 5 seconds...
Sun Aug 3 07:12:30 2003 : Debug: Thread 2 handling request 1, (1
handled so far)
User-Name = test
NAS-IP-Address = xxx.xxx.xxx.xxx
NAS-Port = 0
NAS-Port-Type = Async
Service-Type = Framed-User
Framed-Protocol = PPP
Acct-Session-Id = 379094841
Acct-Status-Type = Start
Acct-Delay-Time = 0
Sun Aug 3 07:12:30 2003 : Debug: modcall: entering group preacct
Sun Aug 3 07:12:30 2003 : Debug: modcall[preacct]: module
preprocess returns noop
Sun Aug 3 07:12:30 2003 : Debug: rlm_realm: No '@' in User-Name =
test, looking up realm NULL
Sun Aug 3 07:12:30 2003 : Debug: rlm_realm: No such realm NULL
Sun Aug 3 07:12:30 2003 : Debug: modcall[preacct]: module suffix
returns noop
Sun Aug 3 07:12:30 2003 : Debug: modcall[preacct]: module files
returns noop
Sun Aug 3 07:12:30 2003 : Debug: modcall: group preacct returns noop
Sun Aug 3 07:12:30 2003 : Debug: modcall: entering group accounting
Sun Aug 3 07:12:30 2003 : Debug: radius_xlat:
'/app/experimental/free-0.9/local/var/log/radius/radacct/xxx.xxx.xxx.xxx
/detail-20030803'
Sun Aug 3 07:12:30 2003 : Debug: rlm_detail:
/app/experimental/free-0.9/local/var/log/radius/radacct/%{Client-IP-Addr
ess}/detail-%Y%m%d expands to
/app/experimental/free-0.9/local/var/log/radius/radacct/xxx.xxx.xxx.xxx/
detail-20030803
Sun Aug 3 07:12:30 2003 : Debug: modcall[accounting]: module detail
returns ok
Sun Aug 3 07:12:30 2003 : Debug: modcall: entering group redundant
Sun Aug 3 07:12:30 2003 : Debug: radius_xlat: 'test'
Sun Aug 3 07:12:30 2003 : Debug: rlm_sql (sql2): sql_set_user escaped
user -- 'test'
Sun Aug 3 07:12:30 2003 : Debug: radius_xlat: 'INSERT into RADACCT
(RadAcctId, 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('', '379094841', '', 'test', '',
'xxx.xxx.xxx.xxx', '0', 'Async', TO_DATE('2003-08-03
07:12:30','-mm-dd hh24:mi:ss'), '', '0', '', '', '', '0', '0', '',
'', '', 'Framed-User', 'PPP', '', '0', '0')'
Sun Aug 3 07:12:30 2003 : Debug: rlm_sql (sql2): Reserving sql socket
id: 1
Sun Aug 3 07:12:30 2003 : Error: rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
Sun Aug 3 07:12:30 2003 : Debug: rlm_sql (sql2): Attempting to connect
rlm_sql_oracle #1
Sun Aug 3 07:12:30 2003 : Debug: rl_next: returning NULL
Sun Aug 3 07:12:30 2003 : Debug: Waking up in 5 seconds...
Sun Aug 3 07:12:30 2003 : Error: rlm_sql_oracle: Oracle logon failed:
'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
exist SVR4 Error: 2: No such file or directory '
Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): Failed to connect DB
handle #1
Sun Aug 3 07:12:30 2003 : Error: rlm_sql (sql2): reconnect failed,
database down?
Segmentation Fault
Can anyone help in this regard?
Regards
Yasser Ahmed Hosny
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re:Unprintable characters in the password
1, (1 handled so far) User-Name = user101 User-Password = [EMAIL PROTECTED] NAS-IP-Address = xxx.xxx.xxx.xxx NAS-Port = 0 NAS-Port-Type = Async Service-Type = Framed-User Framed-Protocol = PPP Sun Jul 27 11:52:36 2003 : Debug: modcall: entering group authorize Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module preprocess returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module chap returns noop Sun Jul 27 11:52:36 2003 : Debug: rlm_realm: No '@' in User-Name = user101, looking up realm NULL Sun Jul 27 11:52:36 2003 : Debug: rlm_realm: No such realm NULL Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module suffix returns noop Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 152 Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 171 Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 183 Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module files returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module mschap returns noop Sun Jul 27 11:52:36 2003 : Debug: modcall: entering group redundant Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'user101' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): sql_set_user escaped user -- 'user101' Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'SELECT id,user_id,Attribute,pwd_Value, op FROM user_profile_new WHERE user_id = 'user101' AND Status = 'W' AND NVL(CALLING_STATION_ID, '041234567') = '041234567' ORDER BY id' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): Reserving sql socket id: 0 Sun Jul 27 11:52:36 2003 : Error: rlm_sql: The 'op' field for attribute 'Crypt-Password = cUTAc33b3ghLs' is NULL, or non-existent. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect. Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: '' Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'SELECT 0 id,User_id,Attribute_name,Attribute_Value, '' op FROM user_Attributes_new WHERE User_id = 'user101'' Sun Jul 27 11:52:36 2003 : Error: rlm_sql: The 'op' field for attribute 'Port-Limit = 1' is NULL, or non-existent. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: unknown attribute Unisphere-Egress-Policy-Name Sun Jul 27 11:52:36 2003 : Error: rlm_sql (sql1): Error getting data from database Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: '' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): Released sql socket id: 0 Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module sql1 returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall: group redundant returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall: group authorize returns ok Sun Jul 27 11:52:36 2003 : Debug: rad_check_password: Found Auth-Type System Sun Jul 27 11:52:36 2003 : Debug: auth: type Crypt Sun Jul 27 11:52:36 2003 : Debug: auth: Failed to validate the user. Sun Jul 27 11:52:36 2003 : Debug: WARNING: Unprintable characters in the password. ? Double-check the shared secret on the server and the NAS! Sun Jul 27 11:52:36 2003 : Debug: Delaying request 1 for 1 seconds Sun Jul 27 11:52:36 2003 : Debug: Finished request 1 Sun Jul 27 11:52:36 2003 : Debug: Going to the next request Sun Jul 27 11:52:36 2003 : Debug: Thread 2 waiting to be assigned a request Sun Jul 27 11:52:41 2003 : Debug: --- Walking the entire request list --- Sun Jul 27 11:52:41 2003 : Debug: Threads: total/active/spare threads = 5/0/5 Sending Access-Reject of id 163 to 194.170.195.10:44607 Sun Jul 27 11:52:41 2003 : Debug: Waking up in 1 seconds... Sun Jul 27 11:52:42 2003 : Debug: --- Walking the entire request list --- Sun Jul 27 11:52:42 2003 : Debug: Cleaning up request 1 ID 163 with timestamp 3f2384c4 Sun Jul 27 11:52:42 2003 : Debug: Nothing to do. Sleeping until we see a request. Appreciate your kind help. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re:Unprintable characters in the password
= user101 User-Password = [EMAIL PROTECTED] NAS-IP-Address = xxx.xxx.xxx.xxx NAS-Port = 0 NAS-Port-Type = Async Service-Type = Framed-User Framed-Protocol = PPP Sun Jul 27 11:52:36 2003 : Debug: modcall: entering group authorize Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module preprocess returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module chap returns noop Sun Jul 27 11:52:36 2003 : Debug: rlm_realm: No '@' in User-Name = user101, looking up realm NULL Sun Jul 27 11:52:36 2003 : Debug: rlm_realm: No such realm NULL Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module suffix returns noop Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 152 Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 171 Sun Jul 27 11:52:36 2003 : Debug: users: Matched DEFAULT at 183 Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module files returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module mschap returns noop Sun Jul 27 11:52:36 2003 : Debug: modcall: entering group redundant Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'user101' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): sql_set_user escaped user -- 'user101' Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'SELECT id,user_id,Attribute,pwd_Value, op FROM user_profile_new WHERE user_id = 'user101' AND Status = 'W' AND NVL(CALLING_STATION_ID, '041234567') = '041234567' ORDER BY id' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): Reserving sql socket id: 0 Sun Jul 27 11:52:36 2003 : Error: rlm_sql: The 'op' field for attribute 'Crypt-Password = cUTAc33b3ghLs' is NULL, or non-existent. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect. Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: '' Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: 'SELECT 0 id,User_id,Attribute_name,Attribute_Value, '' op FROM user_Attributes_new WHERE User_id = 'user101'' Sun Jul 27 11:52:36 2003 : Error: rlm_sql: The 'op' field for attribute 'Port-Limit = 1' is NULL, or non-existent. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect. Sun Jul 27 11:52:36 2003 : Error: rlm_sql: unknown attribute Unisphere-Egress-Policy-Name Sun Jul 27 11:52:36 2003 : Error: rlm_sql (sql1): Error getting data from database Sun Jul 27 11:52:36 2003 : Debug: radius_xlat: '' Sun Jul 27 11:52:36 2003 : Debug: rlm_sql (sql1): Released sql socket id: 0 Sun Jul 27 11:52:36 2003 : Debug: modcall[authorize]: module sql1 returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall: group redundant returns ok Sun Jul 27 11:52:36 2003 : Debug: modcall: group authorize returns ok Sun Jul 27 11:52:36 2003 : Debug: rad_check_password: Found Auth-Type System Sun Jul 27 11:52:36 2003 : Debug: auth: type Crypt Sun Jul 27 11:52:36 2003 : Debug: auth: Failed to validate the user. Sun Jul 27 11:52:36 2003 : Debug: WARNING: Unprintable characters in the password. ? Double-check the shared secret on the server and the NAS! Sun Jul 27 11:52:36 2003 : Debug: Delaying request 1 for 1 seconds Sun Jul 27 11:52:36 2003 : Debug: Finished request 1 Sun Jul 27 11:52:36 2003 : Debug: Going to the next request Sun Jul 27 11:52:36 2003 : Debug: Thread 2 waiting to be assigned a request Sun Jul 27 11:52:41 2003 : Debug: --- Walking the entire request list --- Sun Jul 27 11:52:41 2003 : Debug: Threads: total/active/spare threads = 5/0/5 Sending Access-Reject of id 163 to 194.170.195.10:44607 Sun Jul 27 11:52:41 2003 : Debug: Waking up in 1 seconds... Sun Jul 27 11:52:42 2003 : Debug: --- Walking the entire request list --- Sun Jul 27 11:52:42 2003 : Debug: Cleaning up request 1 ID 163 with timestamp 3f2384c4 Sun Jul 27 11:52:42 2003 : Debug: Nothing to do. Sleeping until we see a request. Appreciate your kind help. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Unprintable characters in the password
Dear All, I'm working with Freeradius ver 0.8.1 and I've compiled it on 64-bit architecture on Sun Solaris 8. While trying to test the RADIUS server with the radclient program (compiled on 64-bit), it worked fine, but while to test the Radius server with an older compiled version of Radclient (32-bit), it gives me the following error: WARNING: Unprintable characters in the password. ? Double-check the shared secret on the server and the NAS! I am sure of the secret key between the NAS and the Freeradius are the same. Even I've tried to use NTRadping test utility to test the Radius server, but still same results. Does this mean that I need to change my entire NAS servers to send a 64-bit request or something similar? I have almost 60 NAS servers in my life setup with different brands, which means that I cannot do that? Appreciate your help, it is urgent. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: fopen problem with Freeradius
Thanks for the reply. I've increased the two parameters, but I am still getting the fopen() limitation for 256 files and I cannot open any new files and the Process do not start. I need to clarify my whole setup. First I have around 500.000 dialup users that will use my setup and I have around 60 NAS servers (Different brands). Also, it is important to mention that I am running 6 RADIUS servers distributed in two locations (3 in location A and 3 in location B). The whole purpose behind this setup is that any location can handle the whole traffic in case the other Location fails. We expect to have around 80 to 100 calls per second for the whole setup, so that's why we've come up with these numbers of DB connections below. As an answer to the slowness of the DB, I am not expecting this to happen. We have well structured and indexed Oracle DB working at the backend. My question is, did anyone run with such setup before, and how he/she overcame this opening file limitation, also, how it is performing? Regards Yasser Ahmed Hosny Dear All, I am running Freeradius Ver. 0.8.1 on a Sun Solaris machince Ver. 8 and connecting to 4 Oracle Databases (different machines) for Authentication and Accounting (along with Fail-over). My setup is as follows: 100 connections for Primary Authentication. 100 connections for Secondary Authentication. 100 connections for Primary Accounting. 100 connections for Secondary Accounting. Once I start the Freeradius process, I can open only 253 connections out of 400 and I got the following error: Mon Jul 14 08:39:16 2003 : Error: Failed creating PID file /usr/local/var/run/radiusd/radiusd.pid: Too many open files And the process did not start. I've tried to change some system parameters, but I've realized that I can only change the parameter controlling the open files and not fopen, which is used by Freeradius. I'll appreciate your help in advance. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
fopen problem with Freeradius
Dear All, I am running Freeradius Ver. 0.8.1 on a Sun Solaris machince Ver. 8 and connecting to 4 Oracle Databases (different machines) for Authentication and Accounting (along with Fail-over). My setup is as follows: 100 connections for Primary Authentication. 100 connections for Secondary Authentication. 100 connections for Primary Accounting. 100 connections for Secondary Accounting. Once I start the Freeradius process, I can open only 253 connections out of 400 and I got the following error: Mon Jul 14 08:39:16 2003 : Error: Failed creating PID file /usr/local/var/run/radiusd/radiusd.pid: Too many open files And the process did not start. I've tried to change some system parameters, but I've realized that I can only change the parameter controlling the open files and not fopen, which is used by Freeradius. I'll appreciate your help in advance. Regards --- Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Serious error with accounting - help needed
I am Freeradius 0.8.1 and I am writing accounting records to an Oracle DB ver 8i. If the Database is down, the Freeradius give a segmentation fault error and it dies also. I've tried also to point to another database as a fail-over option, but the same results were encountered. Worth to mention that if I am using the same scenario (database fail-over) with Authentication the Freeradius did not fail. Can anyone help in this regard? Regards Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius MIBS
Did anyone in that list have the Freeradius MIBS working under Solaris 2.8? If yes, please help. Regards Yasser Ahmed Hosny - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation Fault with Accounting
, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay,
AcctStopDelay) values('', '3790948411', '', 'eim1', '',
'194.170.127.204', '1234', 'Async', TO_DATE('2003-06-10
13:41:40','-mm-dd hh24:mi:ss'), '', '0', '', '', '', '0', '0', '',
'2305809', '', 'Framed-User', 'PPP', '', '0', '0')'
Tue Jun 10 13:41:40 2003 : Debug: rlm_sql (sql2): Reserving sql socket
id: 3
Tue Jun 10 13:41:40 2003 : Error: rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
Tue Jun 10 13:41:40 2003 : Debug: rlm_sql (sql2): Attempting to connect
rlm_sql_oracle #3
Tue Jun 10 13:41:40 2003 : Debug: --- Walking the entire request list
---
Tue Jun 10 13:41:40 2003 : Debug: Nothing to do. Sleeping until we see
a request.
Tue Jun 10 13:41:40 2003 : Error: rlm_sql_oracle: Oracle logon failed:
'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
exist SVR4 Error: 2: No such file or directory '
Tue Jun 10 13:41:40 2003 : Error: rlm_sql (sql2): Failed to connect DB
handle #3
Tue Jun 10 13:41:40 2003 : Error: rlm_sql (sql2): reconnect failed,
database down?
Segmentation Fault
Regards
Yasser Ahmed Hosny
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Segmentation Fault for accounting
, AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay,
AcctStopDelay) values('', '3790948411', '', 'eim1', '',
'194.170.127.204', '1234', 'Async', TO_DATE('2003-06-10
13:41:40','-mm-dd hh24:mi:ss'), '', '0', '', '', '', '0', '0', '',
'2305809', '', 'Framed-User', 'PPP', '', '0', '0')'
Tue Jun 10 13:41:40 2003 : Debug: rlm_sql (sql2): Reserving sql socket
id: 3
Tue Jun 10 13:41:40 2003 : Error: rlm_sql_oracle: execute query failed
in sql_query: ORA-03113: end-of-file on communication channel
Tue Jun 10 13:41:40 2003 : Debug: rlm_sql (sql2): Attempting to connect
rlm_sql_oracle #3
Tue Jun 10 13:41:40 2003 : Debug: --- Walking the entire request list
---
Tue Jun 10 13:41:40 2003 : Debug: Nothing to do. Sleeping until we see
a request.
Tue Jun 10 13:41:40 2003 : Error: rlm_sql_oracle: Oracle logon failed:
'ORA-01034: ORACLE not available ORA-27101: shared memory realm does not
exist SVR4 Error: 2: No such file or directory '
Tue Jun 10 13:41:40 2003 : Error: rlm_sql (sql2): Failed to connect DB
handle #3
Tue Jun 10 13:41:40 2003 : Error: rlm_sql (sql2): reconnect failed,
database down?
Segmentation Fault
Regards
Yasser Ahmed Hosny
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Oracle Database Failover
Dear All, I've tried the oracle database fail over option; it worked fine with me in case the database is down, but in case the network is down or the database server is not reachable, the fail over option is not working and the request is discarded. Is there a way to track this in order to implement it in the fail over? Regards - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius training
Dear All, I am running Freeradius 0.7.1, I wonder if is there is any firm that provides technical training on that RADIUS, so that it could be easier to start with administrating and managing that vital process. Also, Ive realized that there exists a RADIUS book that was published recently. Does that book provide any technical information that help? Thanks YH
Segmentation Fault
dear all, I am freeradiusd 0.5 on Solaris 8 and authenticating users from an oracle DB ver 8.1.7. I am applying stress test by creating a script, that push authentication requests to the radius in a loop of 100 requests in the background as follows: #!/usr/bin/ksh i=0 while [ 1 ] do i=`expr $i + 1` radclient radius_ip_address auth test -x test_auth1 radclient radius_ip_address auth test -x test_auth2 radclient radius_ip_address auth test -x test_auth3 radclient radius_ip_address auth test -x test_auth4 radclient radius_ip_address auth test -x test_auth5 radclient radius_ip_address auth test -x test_auth6 radclient radius_ip_address auth test -x test_auth7 radclient radius_ip_address auth test -x test_auth8 radclient radius_ip_address auth test -x test_auth9 radclient radius_ip_address auth test -x test_auth10 if [ $i == 10 ] then exit 0 fi done After running some request I've started to get the following message in the Radiusd Debug: Mon Sep 2 16:28:18 2002 : Error: Discarding new request from client development:50119 - ID: 84 due to live request 18 Sometimes later the Radius crashed with a segmentation fault error. Can someone help on this? Regards --- Yasser Ahmed Hosny Project Manager Tel: 971-4-2025597, 2940299 EIM/EtisalatMob: 971-50-8136791 PO Box: 1150Fax: 971-4-2958485 Dubai, UAE E-mail: [EMAIL PROTECTED] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
