I installed this patch and everything has been working great. I have not had any problems at all with it and I am no longer getting these errors in the logs. Thank you very much for the help.
Tim Jung Internet Gateway [EMAIL PROTECTED] ----- Original Message ----- From: "Mike McCauley" <[EMAIL PROTECTED]> To: "Tim Jung" <[EMAIL PROTECTED]>; "Hugh Irvine" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 26, 2003 6:17 PM Subject: Re: (RADIATOR) Radiator 3.5 & Rodopi 5.2sp3 > Hello Tim, > > > On Fri, 27 Jun 2003 05:16 am, Tim Jung wrote: > > Ok well if the stored procedure is what is expecting a numeric rather than > > char is there a way to tell Radiator to try to convert that field to a > > number before it passes it? I would assume that I can't simply change the > > database itself, and a lot of the Rodopi stored procedures are locked as > > well. > > > > Any suggestions as to what exactly to do would be much appreciated. > > You could try altering the insert query so that it munges the connect-info > field before insertion. > > But I have a better idea. > I have attached a new version of AuthRODOPI.pm for Radiator 3.6 that > integerifies the Connect-Info before insertion. > > Please let me know how you go with this. > Cheers. > > > > > Tim Jung > > System Admin > > Internet Gateway > > [EMAIL PROTECTED] > > > > > > ----- Original Message ----- > > From: "Mike McCauley" <[EMAIL PROTECTED]> > > To: "Hugh Irvine" <[EMAIL PROTECTED]>; "Tim Jung" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Wednesday, June 25, 2003 7:37 PM > > Subject: Re: (RADIATOR) Radiator 3.5 & Rodopi 5.2sp3 > > > > > Hello Tim, > > > > > > On Thu, 26 Jun 2003 09:57 am, Hugh Irvine wrote: > > > > Hello Tim - > > > > > > > > The message appears to be complaining about a data conversion from a > > > > string to a numeric. > > > > > > > > It is not obvious to me from the log which field is causing the > > > > problem, so you should check your database log to see exactly what is > > > > happening. You may need to adjust the column definition in the database > > > > to accomodate the data. > > > > > > Hugh is correct: your NAS is sending a string in a field that the Rodopi > > > stored procedure expects to be an integer. Its hard to be sure which one > > > > has > > > > > the problem, but I suspect that it might be the Connect-Info field, which > > > > in > > > > > this example is '45333/26400 V.90/V.42/V.42bis QC'. In my test Rodopi > > > database, the stored procedure expects a numeric() there, even though it > > > > does > > > > > nothing with it. > > > > > > Cheers. > > > > > > > regards > > > > > > > > Hugh > > > > > > > > On Thursday, Jun 26, 2003, at 08:33 Australia/Melbourne, Tim Jung wrote: > > > > > I was wondering if someone could tell me why I am getting these > > > > > errors from > > > > > time to time in the Radiator log on my Linux box? It looks like it is > > > > > getting data from the Remote Access server and isn't able to dump it > > > > > into > > > > > the MS-SQL database that Rodopi uses. > > > > > > > > > > Wed Jun 25 17:20:43 2003: ERR: do failed for 'exec > > > > > Interface_VircomDetails > > > > > '00138AEE', 'Jun 25, 2003 17:16', 'paulhostkoetter', '67.95.10.115', > > > > > 13777, > > > > > 'Framed-User', 'PPP', '64.48.129.119', '6367240300', > > > > > 'stl-01.cvx.algx.net:6000', > > > > > 'Stop', 0, 141096, 1550059, 1500, 3410, 4373, 'User-Request', > > > > > 'Async', '45333/26400 V.90/V.42/V.42bis QC', > > > > > '6367541208'': Server message number=8114 severity=16 state=1 line=0 > > > > > server=BILLINGprocedure=Interface_VircomDetailstext=Error converting > > > > > data > > > > > type varchar to numeric. > > > > > > > > > > I don't get this every single time, but I do seem to get it often > > > > > enough > > > > > that it is annoying and messes with keeping track of multiple logins > > > > > and > > > > > such. > > > > > > > > > > Let me know how to fix this or what I can do about it. Thanks. > > > > > > > > > > Tim Jung > > > > > System Admin > > > > > Internet Gateway > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > === > > > > > Archive at http://www.open.com.au/archives/radiator/ > > > > > Announcements on [EMAIL PROTECTED] > > > > > To unsubscribe, email '[EMAIL PROTECTED]' with > > > > > 'unsubscribe radiator' in the body of the message. > > > > > > > > NB: have you included a copy of your configuration file (no secrets), > > > > together with a trace 4 debug showing what is happening? > > > > > > -- > > > Mike McCauley [EMAIL PROTECTED] > > > Open System Consultants Pty. Ltd Unix, 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, EAP, TLS, > > > TTLS, PEAP etc on Unix, Windows, MacOS etc. > > > > > > === > > > Archive at http://www.open.com.au/archives/radiator/ > > > Announcements on [EMAIL PROTECTED] > > > To unsubscribe, email '[EMAIL PROTECTED]' with > > > 'unsubscribe radiator' in the body of the message. > > -- > Mike McCauley [EMAIL PROTECTED] > Open System Consultants Pty. Ltd Unix, 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, EAP, TLS, > TTLS, PEAP etc on Unix, Windows, MacOS etc. > === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
