Hello Ernest - On Fri, 15 Sep 2000, Ernest G. Wilson II wrote: > First, let me say I am very happy with Radiator, > awesome product and very versatile. We have no problem > getting Radiator to connect to a MySQL server. > We have FreeBSD v4.1 and installed/compiled the latest DBI > and the latest DBD:MySQL from the CPAN archive. > We installed the latest MySQL server and ran your included > script that creates a radiator database and puts in the correct > fields and sample data. We have Radiator working great off the > MySQL data source on our test machine. > > This is where my hell starts: > ----------------------------- > I am getting frustated. > I can't seem to get Radiator on FreeBSD 4.1 to do anything with a Microsoft > SQL Server 7.0. > > 1.) Can you please provide an overview of steps needed to correctly make > FreeBSD > with Radiator authenticate to a Microsoft SQL data source? > Here are the steps I have tried: > a) Install FreeBSD > b) Install Radiator and MD5 > c) Install DBI > d) Install FreeTDS (although maybe not correctly) > e) Install DBD:Sybase (although maybe not correctly) > f) I launched the radius server using a version of the sample platypus.cfg > Are the above steps correct? What steps would you take? > > 2.) Can you provide more detailed instructions on compiling and using > FreeTDS? > > 3.) Can you provide more detailed instructions on compiling and using > DBD:Sybase? > > 4.) Our goal is to eventually connect to a microsoft SQL server with a > Platypus database. > For our test environment I am using a Microsoft SQL server 7.0 > and I created a database named radius and a user called root and a password. > I cannot however create the correct tables and fields and populate with > sample > data since I do not know the layout that Radiator wants. Is it the same > as the database that the sample script created on my MySQL server? > I can't seem to use your example and script to create the database > correctly as I did for MySQL, this doesnt work in FreeBSD for me: > isql -Uuser -Ppassword -Sserver -i sybaseCreate.sql > This is a somewhat convoluted problem area, so let me try to explain a few things regarding connections from Perl/*NIX to MS-SQL. There are several different ways to do this, with only DBI as the common element (and MS-SQL of course). 1. FreeTDS FreeTDS (ftp://freetds.internetcds.com/pub/freetds_dbd/) is a DBD module that will talk TDS protocol to MS-SQL. Note that this module is only partially implemented and is quite incomplete. There are also some problems with recent versions not running properly - see the following FAQ entry: http://www.open.com.au/radiator/faq.html#77 2. DBD-Sybase The DBD-Sybase module will talk to the Sybase client libraries installed on the same machine as Perl and DBI. As MS-SQL was originally an OEM version of Sybase, this works very well and is normally the preferred option on a system that supports Sybase (such as the free Linux version) where at least the Sybase client libraries must be installed. As far as I know however there is not a version for FreeBSD. Note also that the first release of MS-SQL 7 had a bug that broke Sybase connectivity and you will need to install a recent service pack to fix it. 3. DBD-ODBC Alternatively, you can use an ODBC driver, but again I don't know if there is one for FreeBSD. There is a commercial ODBC driver available here (with an indication that there is a FreeBSD version), but it is fairly expensive: http://www.openlinksw.com/ 4. DBD-Proxy DBD-Proxy is probably the preferred method to use for FreeBSD. DBD-Proxy involves a proxy client on the FreeBSD host talking to a proxy server on the MS-SQL host. You can download the DBD-Proxy module from CPAN. The DBD-Proxy server is part of the DBI release. You will need to install and configure DBD-Proxy on the FreeBSD host (there is an example in "radius.cfg" in the distribution), and install and configure Perl, DBI and associated modules on the MS-SQL host (there are only versions for ActivePerl 5.005 on the ActiveState site). This is a fairly complicated process, but it is the most flexible. If you have any more questions, please ask.... hth 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.
