Re: (RADIATOR) db do failed error
Hello Andrew - > > I'm running Radiator on a Debian box. I'm getting continuos screens of error > messages "DBD::mysql::db do failed. Duplicate Entry 63.112.159.254 - 1285 > for key 1 at /usr/local/lilb/site_perl/Radius/SqpDb.pm line 228 > > > This has been going on for days. Radiator is working but probably not at > full efficiency. > As the message says, Radiator is trying to insert a duplicate entry into the database. You should turn on trace 4 to see what is happening, ie. what are the contents of the packets that are causing this? Once you know what is causing the problem, you can fix it. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc. Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X. === 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.
(RADIATOR) db do failed error
--- Forwarded mail from [EMAIL PROTECTED] Date: Sat, 21 Oct 2000 03:40:41 +1000 (EST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from ["Andrew P. Kaplan" <[EMAIL PROTECTED]>] >From mikem Sat Oct 21 03:40:33 2000 Received: by oscar.open.com.au (8.9.0/8.9.0) id DAA08458 for [EMAIL PROTECTED]; Sat, 21 Oct 2000 03:40:32 +1000 (EST) >Received: from cshore.com ([63.237.136.110]) by perki.connect.com.au with ESMTP id EAA04553 (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Sat, 21 Oct 2000 04:13:34 +1100 (EST) Received: from cshore.com ([63.237.136.110]) by perki.connect.com.au with ESMTP id EAA04553 (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Sat, 21 Oct 2000 04:13:34 +1100 (EST) Received: from liszt ([63.112.159.203]) by cshore.com with SMTP (IPAD 2.5/64) id 2408800 ; Fri, 20 Oct 2000 13:07:07 -0400 Reply-To: <[EMAIL PROTECTED]> From: "Andrew P. Kaplan" <[EMAIL PROTECTED]> To: "Radiator" <[EMAIL PROTECTED]> Subject: db do failed error Date: Fri, 20 Oct 2000 13:08:08 -0400 Message-ID: <00dd01c03ab8$51a168e0$[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Content-Type: text/plain; charset="iso-8859-1" I'm running Radiator on a Debian box. I'm getting continuos screens of error messages "DBD::mysql::db do failed. Duplicate Entry 63.112.159.254 - 1285 for key 1 at /usr/local/lilb/site_perl/Radius/SqpDb.pm line 228 This has been going on for days. Radiator is working but probably not at full efficiency. Andrew P. Kaplan, CNE, MCSE+Internet, MCT, CCNA, CCDA CyberShore, Inc. -- Premium Internet Services -- http://www.cshore.com "I would remind you that extremism in the defense of liberty is no vice! And let me remind you also that moderation in the pursuit of justice is no virtue!" - Barry Goldwater ---End of forwarded mail from [EMAIL PROTECTED] -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory etc etc on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X === 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.
Re: (RADIATOR) db: do failed
On Jun 24, 4:41pm, John Vorstermans wrote: > Subject: (RADIATOR) db: do failed > Hi. > > Just installed the latest Radiator with all patches talking to an SQL > database. > > However we have suddenly started seeing these messages: > > [root@ankh etc]# DB::Synapse::dB do failed: Server message number=233 > severity=16 state=2 line=1 server=SOLOMON text=The column User Name in > table Calls may not be null. at /us/lib/perl5/site_perl/5.005/Radius/SQL.PM > line 228. > DB::Synapse::dB do failed: Server message number=233 severity=16 state=2 > line=1 server=SOLOMON text=The column User Name in table Calls may not be > null. at /us/lib/perl5/site_perl/5.005/Radius/SQL.PM line 228. > > Anyone have any idea what is causing this? Hmmm, looks like you are receiving some sort of accounting request which does not have a User-Name attribute in it, and your SQL database says that the user name column is not permitted to be null. Some NASs send very unusual accounting requests as a matter of course, but I have not heard of this. What sort of NAS do you have? Is it possible to get a Radiator log file at trace level 4, showing what the contents of the radius request that causes this? You may be able to turn off whatever these strange requests are, or else you may have to modifiy your SQL database so that NULL usernames are permitted in that table. > > We are using Auntly EMERALD. > > Cheers > John > > > > > -- > John Vorstermans. Actrix Networks Ltd, Wgtn, New Zealand. +64 4 801-6815 > > > > === > Archive at http://www.thesite.com.au/~radiator/ > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. >-- End of excerpt from John Vorstermans -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985 Fax +61 3 9598-0955 Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, NT, Rhapsody === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) db: do failed
Hi. Just installed the latest Radiator with all patches talking to an SQL database. However we have suddenly started seeing these messages: [root@ankh etc]# DB::Synapse::dB do failed: Server message number=233 severity=16 state=2 line=1 server=SOLOMON text=The column User Name in table Calls may not be null. at /us/lib/perl5/site_perl/5.005/Radius/SQL.PM line 228. DB::Synapse::dB do failed: Server message number=233 severity=16 state=2 line=1 server=SOLOMON text=The column User Name in table Calls may not be null. at /us/lib/perl5/site_perl/5.005/Radius/SQL.PM line 228. Anyone have any idea what is causing this? We are using Auntly EMERALD. Cheers John -- John Vorstermans. Actrix Networks Ltd, Wgtn, New Zealand. +64 4 801-6815 === Archive at http://www.thesite.com.au/~radiator/ To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.