Re: (RADIATOR) Radiator + Oracle Bug?

2003-07-21 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Wesley - > > If the SQL database access times out, Radiator by default will wait 10 > minutes before trying again. > > You can adjust the Timeout and FailureBackoffTime parameters in the > AuthBy SQL clause. > > See sections 6.28.4 and 6.28.5 in the Radiator 3.6 r

Re: (RADIATOR) Database support fault tolerance

2003-06-30 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Dan - > > It would be fairly simple to have Radiator write to a flat file for > accounting, and then have a cron job or similar load the data into the > database periodically. You will find a simple utility to do this in the > file "goodies/radimportacct". > > reg

Fwd: Re: (RADIATOR) Database support fault tolerance

2003-06-30 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Dan - > > It would be fairly simple to have Radiator write to a flat file for > accounting, and then have a cron job or similar load the data into the > database periodically. You will find a simple utility to do this in the > file "goodies/radimportacct". I was h

(RADIATOR) Database support fault tolerance

2003-06-30 Thread Dan Melomedman
Our users are getting sick and tired due to RADIUS service unavailability every time something happens to the network where the database server sits, or the database server itself. To remind, we use LDAP for authentication, and SQL Server for sessions/logging. LDAP has been great, where database co

(RADIATOR) Two miniscule timestamp patches

2003-02-13 Thread Dan Melomedman
I need to log to stdout without the timestamp (because I use multilog for automatic rotation and TAI timestamps), so here is NoTimestamp. Hope it's okay to send to the mailing list, and it's useful to someone. --- Log.pm Wed May 22 22:03:18 2002 +++ /usr/local/lib/perl5/site_perl/5.8.0/Radius

Re: (RADIATOR) Concurrent access in SessDBM.

2003-02-07 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Dan - > > DBM locking is not supported and we find that most Radiator users have > an SQL database for billing and customer management already, so an SQL > session database (which supports locking, multiple access, etc.) tends > to make more sense. Hi Hugh. We us

(RADIATOR) Concurrent access in SessDBM.

2003-02-07 Thread Dan Melomedman
Would it be feasable to add locking to SessDBM such that we have multiple readers and one writer to the DBM file? The session database doesn't need any relational features, and the related bloat and bugs. Look at what it takes just to set up a reliable database connection. === Archive at http://www

Re: (RADIATOR) Rodopi & Radiator

2003-02-06 Thread Dan Melomedman
Tim Jung wrote: > I am still stuck if anyone has any suggestions. First, you need to be asking these questions on the FreeTDS mailing list. Other than that, I would compile sqsh against the FreeTDS library, and use sqsh to log in with the SQL Server account and database to verify access. You can a

Re: (RADIATOR) FreeTDS & DBD-Sybase Install

2003-02-05 Thread Dan Melomedman
Tim Jung wrote: > I found this out from the author of the DBD::Sybase module. He posted this > to the FreeTDS mailing list back in October 2002. He is specifically > talking about the errors that are generated when you run the 'make test' > option on the DBD::Sybase module using FreeTDS. > > So it

Re: (RADIATOR) Different NASes, same realms

2003-02-04 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Dan - > > The best way to do this sort of thing is like this: > > # define Client clauses > > > Identifier Ascend-Type-A > . > > > AuthBy Auth-Ascend-Type-A > .. > Ouch, I missed client identifiers in the documentation. Are ther

(RADIATOR) Different NASes, same realms

2003-02-04 Thread Dan Melomedman
We are getting into compatibility problems with different Ascend NASes from our providers, which requires us to run different AuthBy for each. Since we use them with the same realms, what is the best way to differentiate NASes? Rewrite realms to something weird like realm.com-provider in the s? An

Re: (RADIATOR) radiator stops ...

2003-02-03 Thread 'Dan Melomedman'
> > Hmm ... I guess the answer is YMMV, then. > > To anyone looking for solutions like this, I would say that Easysoft were > very helpful getting their stuff up and running, and your best bet is > probably to try both. It was certainly better than Openlink, and I believe > their pricing is more

Re: (RADIATOR) radiator stops ...

2003-02-03 Thread 'Dan Melomedman'
Matthew Trout wrote: > > Of course Easysoft OOB is even better as far as > > compatibility/reliability are concerned, albeit at a higher cost. > > You're kidding, right? > > In production use, Easysoft is absolutely lovely bar for one minor 'feature' > (at least in the version I had) - if the NT

Re: (RADIATOR) radiator stops ...

2003-01-30 Thread Dan Melomedman
Matthew Trout wrote: > I'd suggest dumping openlink as well; it's overpriced and the windows side > (last time I had to suffer it) was far from production-grade reliability. If > you're trying to connect to an MS SQL Server from *n?x, I've found FreeTDS > (www.freetds.org) to be far superior, and a

(RADIATOR) GlobalVar

2003-01-27 Thread Dan Melomedman
I am tidying up my configuration files, and I find that GlobalVars don't work everywhere. I look at the documentation, and it doesn't tell me where they do not work. Variables like LDAP passwords and filters that I found by trial and error do not work. LDAP host does work, but then, in the log file

Re: (RADIATOR) Auth-Type and LDAP

2003-01-27 Thread Dan Melomedman
Enrique Diez wrote: > Hi All, > I would like to know if there is an LDAP-Attribute (customized or > standarized) in order to define the kind of authentication required for an > user entry. > For example, a user LDAP entry can be validated by the Radiator Radius > Server via /etc/unix/password or a

Re: (RADIATOR) Connecting from linux to SQL 2000

2002-12-27 Thread Dan Melomedman
Matthew Hobbs wrote: > Currently I'm using DBI:Sybase on Mandrake 8.2 to connect to MS SQL 6.5 > All works well > Looking at FreeTDS (0.6) its says it can connect to SQL 2000 using DBI::Sybase > is this true ? This is a question for the FreeTDS list. I just tried FreeTDS 0.53, with TDS version set

Re: (RADIATOR) MySQL + Radiator = Hang

2002-12-27 Thread Dan Melomedman
Tony Bunce wrote: > We have radiator setup on two servers using a MS SQL server for user > authentication and mysql for accounting. If you're using unixODBC 2.2.3 or earlier, upgrade. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email

Re: (RADIATOR) Re: (RADAR) RADAR without X

2002-12-10 Thread Dan Melomedman
> StatsLog clause. And if you want a tool to restart Radiator > automatically and let you know why it did so, you should use the > "restartWrapper" utility provided in the goodies directory for this > purpose. See the relevant sections of the Radiator 3.4 reference manual. Another (very conveni

(RADIATOR) Sessions

2002-12-04 Thread Dan Melomedman
Hi. Our Radiator needs to authenticate more that one service from the same realm. We need to guarantee that a user can get one session per each service with the same account, but only one session. For example, once a user has authenticated for dial-up, he wants to use a VPN client - one more sessio

Re: (RADIATOR) Mac OS X Questions

2002-10-12 Thread Dan Melomedman
Marcel Brown wrote: > A few more questions regarding Mac OS X and MS SQL access > > If connecting to MS SQL from ODBC on UNIX requires an ODBC driver, > where can I get a driver? Do people here have experience with this on > Mac OS X? > > I keep reading that DBD-Sybase is compatible with MS-SQL

Re: (RADIATOR) radiator stop without a reason

2002-09-05 Thread Dan Melomedman
Paulo Sousa wrote: > > Dan > > I'm currently use libdbd-sybase-perl (that depends freetds), running > debian GNU/Linux woody 3.0 :) > Do u know how i can resolve that??? Not yet. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[

Re: (RADIATOR) SQL Server Connection Handling

2002-09-05 Thread 'Dan Melomedman'
Patrick Muldoon(NOC) wrote: > We use DBD::Sybase with FreeTDS to connect to MSSQL Server 2000 from > FreeBSD, and it works great, have never had any trouble. > > What version of FreeTDS are you using? > > You can also do some debugging with FreeTDS to see if it is the one > hanging. > http://w

Re: (RADIATOR) SQL Server Connection Handling

2002-09-05 Thread Dan Melomedman
Mike McCauley wrote: > Hi Dan, > > OK, > > here is a new version of SqlDb.pm that implements a new DisconnectAfterQuery > flag. This will cause AuthBy SQL and other SQL users to disconnect after > every SQL 'do' and after every 'getOneRow'. > > Let me know how you go. > > Cheers. > Thanks

Re: (RADIATOR) radiator stop without a reason

2002-09-05 Thread Dan Melomedman
Paulo Sousa wrote: > > > Hi Dan > > I'm using a linux box that auths on M$ SQL Server. :) > > Paulo Sousa > We have exactly the same problem. You are using FreeTDS? === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTE

Re: (RADIATOR) radiator stop without a reason

2002-09-04 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Paul - > > I will need to know what hardware/sorftware platform you are using and I > will need to see a copy of your configuration file (no secrets) together > with a trace 4 debug showing what is happening. I will also need to know > what version of Radiator you

Re: (RADIATOR) SQL Server Connection Handling

2002-08-29 Thread Dan Melomedman
Mike McCauley wrote: > On Wed, 28 Aug 2002 08:32, Hugh Irvine wrote: > > Hello Dan - > > > > I would have to suggest that you use a more sensible database. > > Of course that there might be other reasons that prevent you from doing that. > > I am a bit puzzled though: I would normally expect Rad

Re: (RADIATOR) SQL Server Connection Handling

2002-08-27 Thread Dan Melomedman
Mike McCauley wrote: > Its a first for me too. > I could conceive of a 'DisconnectAfterQuery' flag that would disconnect after > every SQL query was finished, but Im reluctant to add it since I dont think > it would be widely useful, and when it was used it would significantly slow > things dow

Re: (RADIATOR) SQL Server Connection Handling

2002-08-26 Thread Dan Melomedman
Hugh Irvine wrote: > > Hello Dan - > > Can you please tell me what database you are using and what platform? > > thanks > > Hugh I thought SQL Server implied MS SQL Server :). This is FreeBSD. Anyway, we need connect-log-disconnect behavior instead of the current implementation. === Archive a

(RADIATOR) SQL Server Connection Handling

2002-08-26 Thread Dan Melomedman
Hi. Is it possible to quickly disable persistent connections for SQL logging? Persistent connections do not work well with our SQL Server, since they time out. Short failure backoff times do not help either since I think any DB connection failure trips the RADIUS authentication code on the devices

Re: (RADIATOR) Memory leak in one of the modules or perl executable.

2002-07-23 Thread Dan Melomedman
Hugh Irvine writes: > > Hello Dan - > > Mike is travelling this week, but he will look at this when he returns. > > In the meantime, can you please tell me how you are testing? And could you > also send me the details of how you are testing and the outputs of "ps", > "top" or whatever you

(RADIATOR) Memory leak in one of the modules or perl executable.

2002-07-23 Thread Dan Melomedman
I noticed the perl process is growing linearly as the requests come in. Grows in size quite rapidly, eventually needs to be restarted. I suspected FreeTDS or OpenLDAP libraries (and these may too have leaks and probably do, but that testing is later). To see if it could be something else, I

Re: (RADIATOR) LDAP and CHAP

2002-07-16 Thread Dan Melomedman
Ayotunde Itayemi writes: > Hi, > > Depending on your patience, number of clients and time, you could get Mobius > Freeware's > w32crack - run it continuously for a few days after extracting the username > and encrypted This cannot help us, since we do not use NT user database. === Archive at

Re: (RADIATOR) LDAP and CHAP

2002-07-16 Thread Dan Melomedman
Hugh Irvine writes: > > Hello Dan - > > You can use CHAP with any database, however the password stored therein > *must* be in cleartext, as you can only use cleartext passwords with CHAP. > > regards > > Hugh The problem is all our dial-ups have hashed passwords, and returning them to

(RADIATOR) LDAP and CHAP

2002-07-15 Thread Dan Melomedman
Does Radiator allow CHAP passwords with LDAP databases? Thanks. === 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.

(RADIATOR) Our Interesting Requirement for Radiator

2002-05-15 Thread Dan Melomedman
Hi. Here's what required by our installation. We have our account entries in the LDAP directory. Every account can be authenticated using RADIUS for several services like VPN tunnels, dial-up etc. There needs to be an expirattion date for each type of service. IOW there's a different expiratio

(RADIATOR) Logging Active Handler

2002-05-02 Thread Dan Melomedman
Hi. I need to log active handler identifier to the SQL table. In other words, the handler where the failure occurs should be logged. What do I need to do? I read documentation, but it's not exactly clear to me as how to do it. -- History has shown that the road to injustice is frequently li

(RADIATOR) Failed Attempts, Time::HiRes

2002-04-30 Thread Dan Melomedman
Hi. A few questions: How to log failed attempts to an SQL database? The table will look something like this: Column_nameType Length Nullable -- - --- --- LoggedAt datetime 8yes User_Name

Re: (RADIATOR) Logging Accounting to SQL without SQL authentication

2002-04-27 Thread Dan Melomedman
Hugh Irvine writes: > > Identifier SQLAccounting > .. > AuthSelect > AccountingTable ACCOUNTING > AcctColumnDef . > .. > > > AuthByPolicy ContinueAlways > AuthBy SQLAccounting > AuthBy CheckLDAP > . > Thanks. It'

(RADIATOR) Logging Accounting to SQL without SQL authentication

2002-04-26 Thread Dan Melomedman
Hi. We want to log accounting to our SQL DB, but we are using LDAP DB for authentication. What can we do? doesn't mention AccountingTable functionality from . Thanks. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTEC

Re: (RADIATOR) radiator hanging itself...

2002-03-14 Thread Dan Melomedman
Check if it's blocked by a disk or a database. === 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.

Re: (RADIATOR) Weird realms

2002-03-13 Thread Dan Melomedman
Hugh Irvine writes: > > Hello Dan - > > You can either do what you describe (probably with a single global > RewriteUsername), or you can use Handlers with regular expressions. > > Ie. > > Which is more efficient rewrite and , or ? Thanks. === Archive at http://www.open.com.au/archiv

(RADIATOR) Weird realms

2002-03-13 Thread Dan Melomedman
We have a few realms like m_devn and devn. So they're prefixes, not suffixes after "@", but with ".". For example m_devn.dan. What's the best way to handle something like this? Rewrite them in the client interface config to something @m_devn?, then handle with later? === Archive at http://www

Re: (RADIATOR) Logging to MSSQL 7.0

2002-03-11 Thread Dan Melomedman
Hugh Irvine writes: > BTW - you say that Radiator is *almost* perfect - we would be keen to hear > any suggestions for improvements. > > regards > > Hugh Hi Hugh, : I'd like to be able to fork an external program, and pipe the log data to it for logging, instead of logging directly to a

(RADIATOR) Logging to MSSQL 7.0

2002-03-09 Thread Dan Melomedman
First, let me add my praise about this product to the already long list. We're evaluating Radiator. This is the best commercial server product I have ever dealt with, great job! Finally a RADIUS server that's almost, if not, perfect. Rock on! Anyway, we use FreeTDS for PHP scripts, and some t