Re: Problem with accounting insert into Oracle
/etc/raddb/certs was copied too! How to regenerate the certificates ? In general, how to install a copy of a radius server to another box ? For my SQL problem, any idea ? Thanks all AL Le 13 août 2012 à 18:35, John Dennis a écrit : On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote: I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all ! What about your /etc/raddb/certs? Did you copy that too? If so you may have problems if the server cert does not match the new machine. I don't think that's would account for a SQL error, but you do need to be careful with just copying things around. The other difference is that I switch from Fedora 14 to CentOS 6.3. AL http://mobiquithings.com/ Le 13 août 2012 à 17:28, John Dennis a écrit : On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote: It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ? Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them. -- John Dennis jden...@redhat.com mailto:jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ http://www.redhat.com/carveoutcosts/ -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
Aurélien Lafranchise wrote: I have the same error for every request in dialup.conf (STOP, START, UPDATE). The database connection is working well but I have: [sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string not properly terminated with sqltrace on you can see the mistake at the end. The request seems to be truncated: Yes. You can't put infinie amounts of data into the SQL query. The limit is ~2K or so. Any idea ? Is there a global option for the maximum number of characters for a request ? It's limited in the SQL module. You've edited the configuration to log tons of data. This generally isn't useful, or necessary. Fix that, or edit the SQL module to allow more than 2K of data in the expansion. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
It seems that Freeradius is getting stuck when inserting hex chain. Does that
remind something to someone ?
AL
Le 13 août 2012 à 13:42, Aurélien Lafranchise a écrit :
Hi,
I have the same error for every request in dialup.conf (STOP, START, UPDATE).
The database connection is working well but I have:
[sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string
not properly terminated
with sqltrace on you can see the mistake at the end. The request seems to be
truncated:
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, IMSI_3GPP, ChargingID_3GPP, PDPType_3GPP,
ChargingGwAddress_3GPP, GPRSNegotiatedQoSprofile_3GPP, SGSNAddress_3GPP,
GGSNAddress_3GPP, IMSIMCCMNC_3GPP, GGSNMCCMNC_3GPP, NSAPI_3GPP,
SessionStopIndicator_3GPP, SelectionMode_3GPP, ChargingCharacteristics_3GPP,
ChargingGwIPv6Address_3GPP, SGSNIPv6Address_3GPP, GGSNIPv6Address_3GPP,
IPv6DNSServers_3GPP, SGSNMCCMNC_3GPP, TeardownIndicator_3GPP, IMEISV_3GPP,
RATType_3GPP, MSTimeZone_3GPP, CamelChargingInfo_3GPP, PacketFilter_3GPP,
NegotiatedDSCP_3GPP, AllocateIPType_3GPP) VALUES('', 'D4090646343006F3',
'64e5c1c4162df0d5', '447937700458', '', '10.100.100.3', '', 'Ethernet',
NULL, TO_DATE('2012-08-13 11:35:27','-mm-dd hh24:mi:ss'), '74',
'RADIUS', '', '', '679' + ('0' * 4294967296), '83' + ('0' *
4294967296), 'internet.mbqt.net', '447937700458', 'User-Request',
'Framed-User', 'GPRS-PDP-Context', '10.73.248.60', '0', '0',
'234507089001283', '875562739', '0', '', '98-1B631F', '80.10.0.97',
'212.9.6.70', '23450', '', '5', '255', '0', '0800', '', '', '', '', '20801',
'', '', '2', ';
but in the dialup.conf file it is ok:
accounting_stop_query_alt = INSERT into ${acct_table2} (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, IMSI_3GPP,
ChargingID_3GPP, PDPType_3GPP, ChargingGwAddress_3GPP,
GPRSNegotiatedQoSprofile_3GPP, SGSNAddress_3GPP, GGSNAddress_3GPP,
IMSIMCCMNC_3GPP, GGSNMCCMNC_3GPP, NSAPI_3GPP, SessionStopIndicator_3GPP,
SelectionMode_3GPP, ChargingCharacteristics_3GPP, ChargingGwIPv6Address_3GPP,
SGSNIPv6Address_3GPP, GGSNIPv6Address_3GPP, IPv6DNSServers_3GPP,
SGSNMCCMNC_3GPP, TeardownIndicator_3GPP, IMEISV_3GPP, RATType_3GPP,
MSTimeZone_3GPP, CamelChargingInfo_3GPP, PacketFilter_3GPP,
NegotiatedDSCP_3GPP, AllocateIPType_3GPP) \
VALUES('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',
'%{SQL-User-Name}', '%{Realm}', \
'%{NAS-IP-Address}', '%{NAS-Port-Id}', '%{NAS-Port-Type}', NULL,
TO_DATE('%S','-mm-dd hh24:mi:ss'), \
'%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', \
'%{Acct-Input-Octets}' + ('%{%{Acct-Input-Gigawords}:-0}' *
4294967296), \
'%{Acct-Output-Octets}' + ('%{%{Acct-Output-Gigawords}:-0}' *
4294967296), \
'%{Called-Station-Id}', '%{Calling-Station-Id}',
'%{Acct-Terminate-Cause}', '%{Service-Type}', \
'%{Framed-Protocol}', '%{Framed-IP-Address}', '0',
'%{Acct-Delay-Time:-0}', '%{3GPP-IMSI}', '%{3GPP-Charging-ID}',
'%{3GPP-PDP-Type}', '%{3GPP-Charging-Gateway-Address}',
'%{3GPP-GPRS-Negotiated-QoS-profile}', '%{3GPP-SGSN-Address}',
'%{3GPP-GGSN-Address}', '%{3GPP-IMSI-MCC-MNC}', '%{3GPP-GGSN-MCC-MNC}',
'%{3GPP-NSAPI}', '%{3GPP-Session-Stop-Indicator}', '%{3GPP-Selection-Mode}',
'%{3GPP-Charging-Characteristics}', '%{3GPP-Charging-Gateway-IPv6-Address}',
'%{3GPP-SGSN-IPv6-Address}', '%{3GPP-GGSN-IPv6-Address}',
'%{3GPP-IPv6-DNS-Servers}', '%{3GPP-SGSN-MCC-MNC}',
'%{3GPP-Teardown-Indicator}', '%{3GPP-IMEISV}', '%{3GPP-RAT-Type}',
'%{3GPP-MS-TimeZone}', '%{3GPP-Camel-Charging-Info}',
'%{3GPP-Packet-Filter}', '%{3GPP-Negotiated-DSCP}',
'%{3GPP-Allocate-IP-Type}')
Any idea ? Is there a global option for the maximum number of characters for
a request ?
Cheers
Aurélien Lafranchise
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
Aurélien Lafranchise wrote: Could you be more precise on where to increase the 2K limit ? All over the place in rlm_sql.c and sql.c. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
Ok, it is what I thought. It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ? AL Aurélien Lafranchise wrote: Could you be more precise on where to increase the 2K limit ? All over the place in rlm_sql.c and sql.c. Alan DeKok. Le 13 août 2012 à 14:47, Aurélien Lafranchise a écrit : Hi Alan, Thanks for the answer. I need all these data so it is not a clean problem. But I will disable sqltrace when everything will be ok. Could you be more precise on where to increase the 2K limit ? Cheers, AL Aurélien Lafranchise wrote: I have the same error for every request in dialup.conf (STOP, START, UPDATE). The database connection is working well but I have: [sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string not properly terminated with sqltrace on you can see the mistake at the end. The request seems to be truncated: Yes. You can't put infinie amounts of data into the SQL query. The limit is ~2K or so. Any idea ? Is there a global option for the maximum number of characters for a request ? It's limited in the SQL module. You've edited the configuration to log tons of data. This generally isn't useful, or necessary. Fix that, or edit the SQL module to allow more than 2K of data in the expansion. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote: It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ? Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them. -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all ! The other difference is that I switch from Fedora 14 to CentOS 6.3. AL Le 13 août 2012 à 17:28, John Dennis a écrit : On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote: It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ? Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them. -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Problem with accounting insert into Oracle
On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote: I have installed a new linux and it is a fresh install. I copied /etc/raddb from one box to another that's all ! What about your /etc/raddb/certs? Did you copy that too? If so you may have problems if the server cert does not match the new machine. I don't think that's would account for a SQL error, but you do need to be careful with just copying things around. The other difference is that I switch from Fedora 14 to CentOS 6.3. AL http://mobiquithings.com/ Le 13 août 2012 à 17:28, John Dennis a écrit : On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote: It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh install 2.1.12-3. Any idea ? Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the server will try to load them. -- John Dennis jden...@redhat.com mailto:jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ http://www.redhat.com/carveoutcosts/ -- John Dennis jden...@redhat.com Looking to carve out IT costs? www.redhat.com/carveoutcosts/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
