Hello Matt -
We will need to see a copy of your configuration file (no secrets), together with a trace 4 debug from Radiator showing the packet dumps and what is happening.
regards
Hugh
On 13/12/2003, at 6:36 AM, Matt Simmons wrote:
Hello all,
I'm having what may be a quite easily fixed problem, but if it is, I am
missing something, I think. I am running Radiator on a Slackware Linux
machine, connecting to a Windows 2000 server with Microsoft SQL 2000, and the
database is a Platypus database. When I run Radiator then test it, with
! ~$ radpwtst -user testuser -password foo
It authenticates perfectly well. The only issue is that the Radius server
gives the following message during the process:
DBD::ODBC::db do failed: [unixODBC][Microsoft][ODBC SQL Server Driver][SQL
Server]Line 2: Incorrect syntax near ')'. (SQL-42000)(DBD: Execute immediate
failed err=-1) at /usr/lib/perl5/site_perl/5.8.0/Radius/SqlDb.pm line 219.
Fri Dec 12 14:18:25 2003: ERR: do failed for 'insert into radiusdat
(username, callstart, callend, sessid , )
values ('testuser', 'Dec 12, 2003 14:01', 'Dec 12, 2003 14:18',
'00001234' , )': [unixODBC][Microsoft][ODBC SQL Server
Driver][SQL Server]Line 2: Incorrect syntax near ')'. (SQL-42000)(DBD:
Execute immediate failed err=-1)
I'm not a Perl hacker, barely a perl programmer, but it looks like it's expecting more arguements than it's getting.
insert into radiusdat (username, callstart, callend, sessid , )
looks like it needs something else. Looking at the code,
219:$rc = $Radius::SqlDb::handles{$self->{dbname}}->do 220: ($q, @bind_values);
Without delving for days into code, can any one point me in the right
direction as to where the problem might lie? Code / Configuration / User
;-)
Thanks everybody!
--Matt
P.S. If you don't recieve a reply to a reply right away, I'm going for holiday
overseas, and I can't promise I'll have a workable net connection. Thanks!
-- ------------------- Matt Simmons Assistant Network Administrator 304.580.8080x5007 Fibernet LLC
=== 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?
-- 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
