(RADIATOR) Access SQL 2000 from Solaris 8
Hugh Irvine
hugh at open.com.au
Fri May 24 12:43:51 CDT 2002
Hello -
Another option for you may be to use a commercial ODBC driver, which is what
some of our customers do (due to the problems with FreeTDS).
Until your database connectivity is working properly, there is nothing that
Radiator will be able to use the database for.
You might also consider running a copy of Radiator on the SQL host and
proxying radius requests to it. Then you can run DBD-ODBC directly.
regards
Hugh
On Sat, 25 May 2002 01:48, Sysadmin wrote:
> I took Mike's approach first and installed
> freetds 0.53 with DBD-Sybase 0.94
> I set my sybase variable to /usr/local/freetds,
> added extra_libs
> EXTRA_LIBS= -ltli (as per the CONFIG file)
> and added my platypus server to the freetds.conf file.
>
> Compiling DBD-Sybase and doing the make test showed a lot of failures.
>
>
> PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib
> -I/usr/local/lib/perl5/5.6.1/i86pc-solaris -I/usr/local/lib/per
> l5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0;
> runtests @ARGV;' t/*.t
> t/autocommit........dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-4
> Failed 3/4 tests, 25.00% okay
> t/base..............ok
> t/exec..............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-9
> Failed 8/9 tests, 11.11% okay
> t/fail..............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-13
> Failed 12/13 tests, 7.69% okay
> t/login.............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-3
> Failed 2/3 tests, 33.33% okay
> t/main..............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-14
> Failed 13/14 tests, 7.14% okay
> t/nsql..............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-4
> Failed 3/4 tests, 25.00% okay
> t/place.............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-11
> Failed 10/11 tests, 9.09% okay
> t/xblob.............dubious
> Test returned status 0 (wstat 11, 0xb)
> DIED. FAILED tests 2-6
> Failed 5/6 tests, 16.67% okay
> Failed Test Status Wstat Total Fail Failed List of Failed
> ---------------------------------------------------------------------------
>----- t/autocommit.t 0 11 4 3 75.00% 2-4
> t/exec.t 0 11 9 8 88.89% 2-9
> t/fail.t 0 11 13 12 92.31% 2-13
> t/login.t 0 11 3 2 66.67% 2-3
> t/main.t 0 11 14 13 92.86% 2-14
> t/nsql.t 0 11 4 3 75.00% 2-4
> t/place.t 0 11 11 10 90.91% 2-11
> t/xblob.t 0 11 6 5 83.33% 2-6
> Failed 8/9 test scripts, 11.11% okay. 56/69 subtests failed, 18.84% okay.
> *** Error code 2
> make: Fatal error: Command failed for target `test_dynamic'
>
>
>
> I also got errors on my freetds install:
>
> root at mail/opt/freetds-0.53% make check
> Making check in include
> Making check in src
> Making check in tds
> Making check in unittests
> make t0001 t0002 t0003 t0004 t0005 t0006
> `t0001' is up to date.
> `t0002' is up to date.
> `t0003' is up to date.
> `t0004' is up to date.
> `t0005' is up to date.
> `t0006' is up to date.
> make check-TESTS
> t0001.c: Testing login, logout
> PASS: t0001
> t0002.c: Test basic submit query, results
> PASS: t0002
> t0003.c: Testing DB change -- 'use tempdb'
> PASS: t0003
> t0004.c: Test large (>512 bytes) queries
> tds_process_result_tokens() returned TDS_FAIL for long query
> FAIL: t0004
> t0005.c: Test large (>512 bytes) replies
> PASS: t0005
> t0006.c: Test SYBREAL, SYBFLT8 values
> PASS: t0006
> ===================
> 1 of 6 tests failed
> ===================
> *** Error code 1
> make: Fatal error: Command failed for target `check-TESTS'
> Current working directory /opt/freetds-0.53/src/tds/unittests
> *** Error code 1
> make: Fatal error: Command failed for target `check-am'
> Current working directory /opt/freetds-0.53/src/tds/unittests
> *** Error code 1
> make: Fatal error: Command failed for target `check-recursive'
> Current working directory /opt/freetds-0.53/src/tds
> *** Error code 1
> make: Fatal error: Command failed for target `check-recursive'
> Current working directory /opt/freetds-0.53/src
> *** Error code 1
> make: Fatal error: Command failed for target `check-recursive'
>
>
>
>
> I did the make install on both for kicks. I setup my AuthBy PLATYPUS and
> tried a
> test user, but it causes radiator to died. Setting Trace to 5 doesn't
> show anything useful. Should I be focusing on getting all these tests to
> run cleanly, or is it normal for certain ones to fail?
>
> Thanks
>
> On Fri, 24 May 2002, Hugh Irvine wrote:
> > Hello -
> >
> > You might also consider using the DBD-Proxy approach and I will forward
> > you a related piece of mail from Mike as well.
> >
> > Otherwise have a look at the archive site and do a search.
> >
> > regards
> >
> > Hugh
> >
> > On Fri, 24 May 2002 05:58, Sysadmin wrote:
> > > Hello,
> > > I've taken on the challege of getting my Solaris 8 x86 server talking
> > > to my W2K server running SQL 2000. I've read through the FAQ and still
> > > have a few questions before I start installing. I would like to do it
> > > with the freeware products available if possible. I was looking at
> > > freetds and DBD-sybase. The radiator faq talks about sql 2000, but
> > > from the freetds faq, it
> > > says sql 2000 is not fully supported and to use TDS 7.0. I'm confused
> > > about the different formats. Will TDS 7.0 actuall work with sql 2000?
> > > I'm going to be interfacing with the accounting package Platypus.
> > > Once these two packages (and any other dependant packages) are
> > > installed, I should just be able to configure radiator's config file to
> > > AuthBy PLATYPUS with the correct information?
> > > Is anyone else runs solaris 8 x86 with radiator and sql 2000?
> > >
> > > Thanks
> > >
> > >
> > >
> > > ===
> > > 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.
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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