---------------------------------------------------------------------------- --------------- Mike McCauley [EMAIL PROTECTED] Open System Consultants +61 3 9598 0985 Mike is travelling right now, and there may be delays in our correspondence. -----Original Message----- From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, December 07, 2000 5:10 AM Subject: BOUNCE [EMAIL PROTECTED]: Non-member submission from ["Jamie Orzechowski" <[EMAIL PROTECTED]>] >>From mikem Thu Dec 7 05:10:12 2000 >Received: by oscar.open.com.au (8.9.0/8.9.0) id FAA28623 > for [EMAIL PROTECTED]; Thu, 7 Dec 2000 05:10:12 +1100 (EST) >>Received: from mail.ripnet.com (mail.RipNET.com [206.47.98.3]) by perki.connect.com.au with ESMTP id EAA10097 > (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Thu, 7 Dec 2000 04:36:40 +1100 (EST) >Received: from mail.ripnet.com (mail.RipNET.com [206.47.98.3]) by perki.connect.com.au with ESMTP id EAA10097 > (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Thu, 7 Dec 2000 04:36:40 +1100 (EST) >Received: from tequilla ([192.168.0.24]) > by mail.ripnet.com (8.11.1/8.11.1) with SMTP id eB6HaR931704 > for <[EMAIL PROTECTED]>; Wed, 6 Dec 2000 12:36:27 -0500 >Message-ID: <000e01c05fab$4f7a10e0$1800a8c0@tequilla> >From: "Jamie Orzechowski" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >References: <news2mail-003a01c05f74$16a2d8b0$[EMAIL PROTECTED]> <a04320433b6540b0bf26d@[151.21.56.99]> >Subject: Logging Accounting requests >Date: Wed, 6 Dec 2000 12:38:13 -0500 >MIME-Version: 1.0 >Content-Transfer-Encoding: 7bit >X-Priority: 3 >X-MSMail-Priority: Normal >X-Mailer: Microsoft Outlook Express 5.50.4133.2400 >X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 >Content-Type: text/plain; > charset="iso-8859-1" > >Re: (RADIATOR) can not dialupI have just setup Radiator to log accounting >requests to an external database (MS SQL 6.5) > > >My Database table is setup in MS SQL 6.5 as the following > >USERNAME, varchar(50) >TIME_STAMP, varchar(20), NULLS >ACCTSTATUSTYPE, varchar(10), NULLS >ACCTINPUTOCTETS, int, NULLS >ACCTOUTPUTOCTETS, int, NULLS >ACCTSESSIONID, varchar(30), NULLS >ACCTSESSIONTIME, int, NULLS >FRAMEDIPADDRESS, varchar(22) >CALLINGSTATIONID, int, NULLS >CONNECTSPEED, varchar(15), NULLS > >It is logging the data correctly in the database but I am getting the >following error every second and I think some records are missing ... > >DBD::Sybase::db do failed: Server message number=170 severity=15 state=1 >line=4 server=RODOPI text=Line 4: Incorrect syntax near ','. at >/usr/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 259. > >Wed Dec 6 12:21:16 2000: DEBUG: do query is: insert into ACCOUNTING >(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, >ACCTSESSIONID, ACCTSESSIONTIME, FRAMEDIPADDRESS, CALLINGSTATIONID, >CONNECTSPEED) >values >('kroma', 'Dec 6, 2000 11:40:16', 'Stop', 1181, 649, '3902', 31, >'216.208.158.69', , '33600-BPS') > >any ideas how to correct this?? > >Here is my config > ><AuthLog FILE> > Identifier Logger > Filename %L/Failure.log > LogSuccess 1 > LogFailure 1 > SuccessFormat %l:UserID %U - SUCCESS > FailureFormat %l:UserID %U - FAILED - Attempted Password "%P" ></AuthLog> > ><AuthBy RODOPI> > Identifier CheckRODOPI > DBSource dbi:Sybase:rodopi > DBUsername Rodopi > DBAuth xxxxxxxxxxxxx ></AuthBy> > ><AuthBy SQL> > Identifier SQLAccounting > DBSource dbi:Sybase:rodopi > DBUsername spaminator > DBAuth xxxxxxxxxxx > DateFormat %b %e, %Y %H:%M:%S > > AccountingTable ACCOUNTING > AcctColumnDef USERNAME,User-Name > AcctColumnDef TIME_STAMP,Timestamp,integer-date > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer > AcctColumnDef ACCTSESSIONID,Acct-Session-Id > AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer > AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address > AcctColumnDef CALLINGSTATIONID,Calling-Station-Id,integer > AcctColumnDef CONNECTSPEED,Connect-Speed ></AuthBy> > ><Realm DEFAULT> >AcctLogFileName %L/detail >RewriteUsername s/^([^@]+).*/$1/ >RewriteUsername tr/A-Z/a-z/ >AuthByPolicy ContinueAlways >AuthBy CheckRODOPI >AuthBy SQLAccounting >AuthLog Logger ></Realm> > ><Realm ripnet.com> >AcctLogFileName %L/detail >RewriteUsername s/^([^@]+).*/$1/ >RewriteUsername tr/A-Z/a-z/ >AuthByPolicy ContinueAlways >AuthBy CheckRODOPI >AuthBy SQLAccounting >AuthLog Logger ></Realm> > > > === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
