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','yyyy-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
