Basic Mysql Config questions + IP+Nas_port questions

2001-10-22 Thread Fabrice LABORIE
Hi Guys, 1) Basic MySql Config Questions I am evaluating freeradius-0.3 ... * I managed to authenticate with a user in /usr/local/etc/raddb/users. Now I want to use MySql. * I have created a radius DB and created the tables as described in

Re: Basic Mysql Config questions + IP+Nas_port questions

2001-10-22 Thread Andrew Melnikov
* I have populated the tables with the following commands ( No other commands !!) insert into radcheck values ('','fablab','Password','LetMeIn'); I encrypt passwords with ENCRYPT(). I never tried to use plaintext passwords with mysql. insert into usergroup values ('','fablab','PPP');

Re: Users w/o shell accts can't authenticate..?

2001-10-22 Thread mike harrison
On Sun, 21 Oct 2001, Steve Cabito wrote: I hope this is an easy one: Users who have a shell (/bin/bash) authenticate OK. Users who don't (/bin/false) don't. 1. Put /bin/false in /etc/shells 2. run shadow passwords on ALL systems, especially those with shell access or web access. Run

Re: Oracle 8.1.6

2001-10-22 Thread aland
Ahsan Ali [EMAIL PROTECTED] wrote: I'm trying to get the current snapshot of freeradius to work with Oracle 8.1.6 (i) - are there any patches that need to be applied before compiling Oracle support in? I don't believe so. The latest CVS snapshot has a number of bugs fixed over 0.3, which

Re: huntgroups by client ip

2001-10-22 Thread aland
Mervyn Jack [EMAIL PROTECTED] wrote: The nation-wide provider of dial-up ports that we are renting some ports off, will not/cannot give us the NAS-IP-Address's that our customers calls may come in on. Due to the fact there are too many, and they may change. Can you do Huntgroup selections by

Re: Basic Mysql Config questions + IP+Nas_port questions

2001-10-22 Thread aland
Fabrice LABORIE [EMAIL PROTECTED] wrote: Question 1: If I want to use MySQL do I have to put data in the TABLE nas / TABLE dictionary or is it enough to have a working clients.conf ?? You should be able to use 'clients.conf'. Question 2: let's say that my base

Restarts?

2001-10-22 Thread Jason Lixfeld
Just wondering if this is normal: Mon Oct 22 12:01:59 2001 : Info: rlm_sql: Driver rlm_sql_mysql loaded and linked Mon Oct 22 12:01:59 2001 : Info: rlm_sql: Attempting to connect to freeradius@localhost:3306/radius Mon Oct 22 12:01:59 2001 : Info: rlm_sql: Driver rlm_sql_mysql loaded and linked

found script dicimport.pl but still cannot authenticate

2001-10-22 Thread Fabrice LABORIE
Dear Andrew, 1) ok .. I have found a script in icradius called ./scripts/dictimport.pl that did the import ... [ Note : you might have seen the answer I got from Alan that said I should not need it : You should be able to use 'clients.conf'. but you are right, I should take no risk :it

Re: SQL authorization with operatos

2001-10-22 Thread aland
Mitry Matyushkov [EMAIL PROTECTED] wrote: I'm looking for volunteers to check the patch which provides (as I suppose) operator support in SQL authorization mode. Look here: This looks reasonable to me, but I can't test it. If anyone else has success with it, I'll commit it. Otherwise,

Re: Problem using postgresql

2001-10-22 Thread aland
Graham Fountain [EMAIL PROTECTED] wrote: I am attempting to set up freeradius to use postgres, and after manually adding the path to the pgsql include and lib directories to make.inc i got the postgres modules to compile and install. but now when i try to start the radius server with

Re: Need Help setting up config

2001-10-22 Thread aland
Randy Perryman [EMAIL PROTECTED] wrote: How do I setup FreeRadius to authenticat MS-Chap across a Cisco 2620 VPN using pptp? Upgrade to the latest CVS version. Version 0.3 had problems which made it unable to do MS-CHAP authentication. Then, in the 'users' file, do: DEFAULT Auth-Type :=

Re: Modifying username before proxying?

2001-10-22 Thread aland
Brian Gordon [EMAIL PROTECTED] wrote: Modifying the username attribute by adding a @somedomain.com to the username before proxying it over to another radius server? This would be a very cool feature for us for a certain need. rlm_attr_rewrite may do this already. See raddb/radiusd.conf

Re: Modifying username before proxying?

2001-10-22 Thread Brian Gordon
I forgot to mention, I need to only occur when a user dials into a specific phone number. Brian - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 22, 2001 2:51 PM Subject: Re: Modifying username before proxying? Brian Gordon [EMAIL PROTECTED]

Re: found script dicimport.pl but still cannot authenticate

2001-10-22 Thread Joe Modjeski
- Original Message - From: Fabrice LABORIE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 22, 2001 9:29 AM Subject: found script dicimport.pl but still cannot authenticate Dear Andrew, 1) ok .. I have found a script in icradius called ./scripts/dictimport.pl

mysql size and performance radacct

2001-10-22 Thread Jeremy Kusnetz
Hi all, Not being a MySql guru, I figured I'd see if someone here had any thoughts to this issue. I'm developing freeradius with mysql support to replace our aging cistron radius, which is currently logging accounting data to flat files. Now I'm setting up freeradius with mysql support to

Re: Problem using postgresql

2001-10-22 Thread Graham Fountain
After much head scratching I got this sorted out. It wasn't a problem with ld.so.conf and locating the libraries etc like I thought it was (I don't know how many times i ran ldconfig etc etc). The long form of the problem is this I think there is a bug in ./configure that caused it to not

Re: mysql size and performance radacct

2001-10-22 Thread Chris Parker
At 07:52 PM 10/22/2001 -0400, you wrote: Hi all, Not being a MySql guru, I figured I'd see if someone here had any thoughts to this issue. I'm developing freeradius with mysql support to replace our aging cistron radius, which is currently logging accounting data to flat files. Now I'm setting