AW: (RADIATOR) SQL-Recovery file ... only numerical values

Hugh Irvine hugh at open.com.au
Wed Nov 9 14:40:29 CST 2005


Hello Martin, Hello Jason -

Mike and I are discussing this problem at the moment and we will post  
a followup later today.

regards

Hugh


On 10 Nov 2005, at 05:57, Martin Wallner wrote:

> Jason, all....
>
> yep, that's the same problem I'm encountering. I was NOT faking a  
> broken SQL server, the SQL-Server was (for Radiator) broken (can't  
> connect), and I get always only the integers in the insert-string.
>
> The thing is, _not_ loosing the Data is _vital_ for our setup... I  
> can and have worked around anything else what comes up on this  
> table: double, triple, n-time, delayed, too long delayed (don't  
> ask :-), mangles (THANKS, CISCO :-<), loss of clients, anything,  
> but we _have to_ have _ALL_ and _ANY_ Accounting Records, and  
> scribbling it into a plain text log is not an option (not with 48  
> Mil entries a month you would have to crosscheck)
>
> I sniffed a bit around in the code, and, as far I could say - and I  
> couldn't verify it until yet - _maybe_ it's a thing of currently  
> NOT escaping the quotes for the strings when you use 'print'  as  
> you do in the sub for the write to the SQLRecoveryFile .... _maybe_  
> the solution would be to forget the actual quote and set it  
> together for the SQLFile from scratch (but that could have timing  
> issues)...
>
> I wasn't able to test it, and I probably wont be able for the next  
> weeks due to a hefty work scedule, I would have to take down one of  
> my production servers for testing, so please, if anyone could do  
> this, I think a lot of people here would very much appreciate it.
>
> =mw=
>
>
> Von: owner-radiator at open.com.au im Auftrag von L. Jason Godsey
> Gesendet: Di 08.11.2005 19:32
> An: radiator at open.com.au
> Betreff: Re: (RADIATOR) SQL-Recovery file ... only numerical values
>
>
> I'd like to see SQLRecoveryFile properly documented.
>
> SQLRecoveryFile is for the most part not useable for PostgreSQL and
> MySQL.
>
> Here is my original post on the subject:
> http://www.open.com.au/archives/radiator/2004-03/msg00162.html
>
> I haven't received a work around yet.
>
> L. Jason Godsey
>
>
> --- Martin Wallner <Martin.Wallner at eunet.co.at> wrote:
>
> > Hi list,
> >
> > I'm a bit stuck here....
> >
> > We are using PostGresql (8) to store (among other things) our
> > accounting info.
> >
> > Last week we had to take down the SQL-Server for a short  
> maintainance
> > cycle, after finishing this, I wanted to restore the accounting data
> > that was stored in the SQL-Restore-File, which was created like it
> > was set up to.
> >
> > Boy, was I surprised when I found out that only the 'integer' and
> > 'bigint' variables were actually filled out in the statements, but
> > not the strings ... and, besides that, that the syntax for the
> > 'insert' statements was not completely correct (missing semicolon at
> > the end)?.... Any ideas what happened here? Maybe 'declare' in the
> > AcctColumnDef that it's a string? But why does it work then when the
> > db-connection is on?
> >
> > It was good that this was happening in a controlled maintainance
> > cycle, so the data loss was negligable.
> >
> > Any ideas?
> >
> > ------------------------- config AuthSQL -----------------
> > <AuthBy SQL>
> >    Identifier SQLAccounting
> >    AuthSelect
> >
> > # primary database on SQL2, ONLY DB to put Accounting on,
> > # missed entries due to error will be handled by SQLRecoveryFile
> >    DBSource dbi:Pg:dbname=radius;host=172.27.0.92
> >    DBUsername radius
> >    DBAuth xxxxxx
> >    AccountingTable accounting
> >    AcctColumnDef   USERNAME,User-Name
> >    AcctColumnDef   TIME_STAMP,Timestamp,integer
> >    AcctColumnDef   ACCTSTATUSTYPE,Acct-Status-Type
> >    AcctColumnDef   ACCTDELAYTIME,Acct-Delay-Time,integer
> >    AcctColumnDef   ACCTINPUTOCTETS,Acct-Input-Octets,integer
> >    AcctColumnDef   ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> >    AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
> >    AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
> >    AcctColumnDef   ACCTTERMINATECAUSE,Acct-Terminate-Cause
> >    AcctColumnDef   NASIDENTIFIER,NAS-Identifier
> >    AcctColumnDef   NASPORT,NAS-Port,integer
> >    AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
> >    AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
> >    AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
> >    AcctColumnDef   ACCTINPUTPACKETS,Acct-Input-Packets,integer
> >    AcctColumnDef   ACCTOUTPUTPACKETS,Acct-Output-Packets,integer
> >    AcctColumnDef   ACCTMULTISESSID,Acct-Multi-Session-Id
> >    AcctColumnDef   ACCTLINKCOUNT,Acct-Link-Count,integer
> >    AcctColumnDef   PORT_NR,NAS-Port,integer
> >    AcctColumnDef   ACCTAUTHENTIC,Acct-Authentic,integer
> >    AcctColumnDef   NASIPADDR,NAS-IP-Address
> >    AcctColumnDef   LOGIN_HOST,Login-IP-Host
> >    AcctColumnDef   LOGIN_SERVICE,Login-Service,integer
> >    AcctColumnDef   USER_SERVICE_TYPE,Service-Type,integer
> >    AcctColumnDef   FRAMED_PROTOCOL,Framed-Protocol,integer
> >    AcctColumnDef   NASPORTTYPE,NAS-Port-Type
> >    Description Generic Accounting
> >    SQLRecoveryFile %L/sqlrecovery-%y-%m-%d.sql
> > #        AcctLogFileName /var/log/radiator/radacct/radius.acct
> > </AuthBy>
> >
> > ------------------------- output found in SQL-Recovery
> > ------------------
> > insert into accounting
> >
> (ACCTAUTHENTIC,ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTINPUTPACKETS,ACCTOUTP 
> UTOCTETS,ACCTOUTPUTPACKETS,ACCTSESSIONI
> >
> D,ACCTSESSIONTIME,ACCTSTATUSTYPE,FRAMEDIPADDRESS,FRAMED_PROTOCOL,NASIP 
> ADDR,NASPORT,NASPORTTYPE,PORT_NR,TIME_STAMP,USERNAME,USER_SERV
> > ICE_TYPE) values
> > (1,5,193088,8681,117254,7329,,37485,,,1,,1345,,1345,1128708835,,2)
> > insert into accounting
> >
> (ACCTAUTHENTIC,ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTINPUTPACKETS,ACCTOUTP 
> UTOCTETS,ACCTOUTPUTPACKETS,ACCTSESSIONI
> >
> D,ACCTSESSIONTIME,ACCTSTATUSTYPE,FRAMEDIPADDRESS,FRAMED_PROTOCOL,NASIP 
> ADDR,NASPORT,NASPORTTYPE,PORT_NR,TIME_STAMP,USERNAME,USER_SERV
> > ICE_TYPE) values
> > (1,0,2161317,19212,11639864,19004,,3870,,,1,,334,,334,1128708840,,2)
> > insert into accounting
> >
> (ACCTAUTHENTIC,ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTINPUTPACKETS,ACCTOUTP 
> UTOCTETS,ACCTOUTPUTPACKETS,ACCTSESSIONI
> >
> D,ACCTSESSIONTIME,ACCTSTATUSTYPE,FRAMEDIPADDRESS,FRAMED_PROTOCOL,NASIP 
> ADDR,NASPORT,NASPORTTYPE,PORT_NR,TIME_STAMP,USERNAME,USER_SERV
> > ICE_TYPE) values
> >
> (1,5,12843276,186390,129036554,208643,,352488,,,1,,490,,490,1128708835 
> ,,2)
> > --------------------------------------------------------
> >
> > regards
> > Martin Wallner (=mw=)
> >
> > -----
> > Eunet Telekom GmbH                    e-mail  
> 'martin.wallner at eunet.co.at
> > vorm. Nextra Österreich                       e-mail  
> 'martin.wallner at nextranet.at'
> > vorm. ViP EDV-Dienstleistungs GesmbH  e-mail 'hostmaster at vip.at'
> > vorm. Gramtel Austria GmbH.           e-mail 'hostmaster at gramtel.at'
> > Systems                                       RIPE:     WM355-RIPE
> > Nussdorfer Lände 23                   NicAT:    WM503823-NICAT
> > 1190 Wien, Vienna, Austria            Tel. +43 (0) 59 1 59 - 1354
> >
> > --
> > Archive at http://www.open.com.au/archives/radiator/
> > Announcements on radiator-announce at open.com.au
> > To unsubscribe, email 'majordomo at open.com.au' with
> > 'unsubscribe radiator' in the body of the message.
> >
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list