Re: sql problem or config?

2002-05-10 Thread Victor Sanchez
tray tu put in sql.conf # Print all SQL statements when in debug mode (-x) sqltrace = yes CHANGE sqltracefile = ${logdir}/sqltrace.sql and run radiusd with debug mode -x and log all, verify that the database in mysql exist and user and pass is correct Victor Sanchez -

mysql problem

2002-05-10 Thread Patrick Chan
Title: mysql problem Hi all, I have a user table just have two fields: Username, Password Can I use SQL only for authentication with these two fields? and use users file for authorization (radreply)? Because our client are unwilling to modify their database, they just have a table

Re: limit the access according to the call identifier

2002-05-10 Thread Aleksandr Kuzminsky
On Thu, 9 May 2002, Chris Parker wrote: DEFAULT Auth-Type := Reject, Calling-Station-Id = 5551212 Reply-Message = Your Phone Number Is Banned Well, but some auth-requests hasn't attribute Calling-Station-Id, if phone number is unknown. Will be such user accessed? -Chris --

Re: *****SPAM***** USR Netserver problems!!!!

2002-05-10 Thread Omollo Benson -Chief Technology Officer
Does anyone in this list have refurbished USR Netserver?, Please contact me off the list. Omollo Benson [EMAIL PROTECTED] Oops, caught by the Reply-To header. Sorry everyone. Roy - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List

Re: *****SPAM***** USR Netserver problems!!!!

2002-05-10 Thread surd
Dear sir: I think you have read my mail sent to the mail list. You have known my strange problem I met. I even suspect whether my USR Netserver is normal or not. Can you help me? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: limit the access according to the call identifier

2002-05-10 Thread Chris Parker
At 12:58 PM 5/10/2002 +0300, Aleksandr Kuzminsky wrote: On Thu, 9 May 2002, Chris Parker wrote: DEFAULT Auth-Type := Reject, Calling-Station-Id = 5551212 Reply-Message = Your Phone Number Is Banned Well, but some auth-requests hasn't attribute Calling-Station-Id, if phone number is

Re: multiple auth module instances and users file

2002-05-10 Thread Alan DeKok
Frank Cusack [EMAIL PROTECTED] wrote: Which does the trick. Should the first setup work and I'm just not configuring it correctly? ISTM it should b/c if you specify unix it's somewhat unclear which instance you're getting (well, I imagine you are getting the one without any instance name).

Re: mysql problem

2002-05-10 Thread Alan DeKok
Patrick Chan [EMAIL PROTECTED] wrote: I have a user table just have two fields: Username, Password Can I use SQL only for authentication with these two fields? and use users file for authorization (radreply)? Yes. That's why the SQL queries come from a configuration file, so you can

Re: problems with users after upgrading...

2002-05-10 Thread Chris Parker
At 11:27 AM 5/10/2002 -0400, Aamer Akhter wrote: Hello, I just make the newest freeradius with the default settings, and something seems to have changed. Under the old freeradius this was working fine. What version are you upgrading from? Here is the output from -X: rad_recv: Access-Request

MySql accounting help

2002-05-10 Thread Michael Klatsky
Good afternoon- I have just configured freeradius .5, using ldap auth. That part works just fine. However, I wish to use mysql for accounting only. Upon startup, the log shows a successful connection to the mysql server/database: rlm_sql: Driver rlm_sql_mysql loaded and linked rlm_sql:

Cisco auth-proxy support?

2002-05-10 Thread Ben Hockenhull
Hi, I'm trying to configure cisco's auth-proxy support on FreeRADIUS 0.5, and I'm not sure where to begin. Does anyone know if this feature is supported? I've done a bit of reasearch and it seems that i might need a custom dictionary file for this. Thanks Ben -- Ben Hockenhull [EMAIL

Re: MySql accounting help

2002-05-10 Thread Michael Klatsky
Yes- that's what this output is from. I am not at the point where I am going to receive packets from a NAS yet. This is the ouptut of radclient. Below is the command line I used, along with the test file contents. radclient -f test -x localhost acct secret test: User-Name = testuser

Re: MySql accounting help

2002-05-10 Thread Alan DeKok
Michael Klatsky [EMAIL PROTECTED] wrote: This is the ouptut of radclient. Below is the command line I used, along with the test file contents. radclient -f test -x localhost acct secret test: User-Name = testuser User-Password = password Acct-Status-Type = Start You need

Re: MySql accounting help

2002-05-10 Thread Michael Klatsky
Alan- Excellent- thanks for this information. I now am able to send/test accounting packets. Rudimentary right now- but I'll be working it this weekend. Here is the result of a test packet: Sending Accounting-Request of id 140 to 127.0.0.1:1813 User-Name = testuser

Re: *****SPAM***** USR Netserver problems!!!!

2002-05-10 Thread Vector
talk to tim bragg. He goes by 'totalcontrolsales' on ebay and he is always posting stuff there. He sold me some quad modem cards, with the software to flash them to v.90 for $15/piece. Not bad. vec - Original Message - From: Omollo Benson -Chief Technology Officer [EMAIL PROTECTED]

Re:PAM module and realm

2002-05-10 Thread Buschel, Alejandro
Alan, I meant to define a parameter realm.name in the server file, like the IP and the port. Would you be willing to make this change? If not, could you give me an idea on how to get it done. I am not a developer but there are people here that will work on the source code. Any changes will be

Re: IPPOOL

2002-05-10 Thread Ben Casado
Guys; Every so often I need to reboot the server because the system accepts the requests, authenticates the users, but it doesn't assign anymore addresses. The client dies as ppp cannot complete. Any suggestions Ben

Re: PAM module and realm

2002-05-10 Thread Alan DeKok
Buschel, Alejandro [EMAIL PROTECTED] wrote: Alan, I meant to define a parameter @realm.name in the server file, like the IP and the port. Would you be willing to make this change? I probably don't have much time to spare, sorry. If not, could you give me an idea on how to get it done. I am

Re: Any plans for making Simultaneous-Use SQL aware?

2002-05-10 Thread Alan DeKok
Chris A. Kalin [EMAIL PROTECTED] wrote: I'll keep pounding on this for the next few days but I will absolutely not feel bad if someone who's a faster and more capable programmer were to take this by the horns and make this work better than I'll probably be able to do. :) Where should I

Re: Complete list of user check-items?

2002-05-10 Thread Alan DeKok
Carter, Darren - Sydney [EMAIL PROTECTED] wrote: Documentation question: Is there a complete(ish) list of attributes that are available as check-items anywhere? I have spent quite a lot of time trawling the lists, FAQs, bundled documentation and man pages, but the best reference that I

Users file

2002-05-10 Thread Andrew J Bostaph
Is the users file only read one time (at startup)? Do I need to kill -HUP the process every time I add a user? Thanks, Andrew - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: problems with users after upgrading...

2002-05-10 Thread Chris Parker
At 05:56 PM 5/10/2002 -0400, Aamer Akhter wrote: Chris, still problems. can you also CC me on the reply directly? I have to cut and past from the archive currently.. At 11:27 AM 5/10/2002 -0400, Aamer Akhter wrote: Hello, I just make the newest freeradius with the default settings, and

Re: problems with users after upgrading...

2002-05-10 Thread Aamer Akhter
thanks Chris. I deleted the old files and started over. it took some redoing but it works fine now. thanks for all your help. Quoting Aamer Akhter ([EMAIL PROTECTED]): Chris, still problems. can you also CC me on the reply directly? I have to cut and past from the archive currently..

RE: mysql problem

2002-05-10 Thread Patrick Chan
Title: RE: mysql problem But the radcheck table does not have the field Attribute and no table usergroup, radgroupcheck, radreply, radgroupreply When I dial to the modem pool, no error message is shown even debug mode is enabled, and the authentication is fail. -Original