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 Message

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: 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 s

Re: problems with users after upgrading...

2002-05-10 Thread Aamer Akhter
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 something >seems to have changed. Under the old f

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: 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 th

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 sh

Re: Stripping realms

2002-05-10 Thread Alan DeKok
"Jason Lixfeld" <[EMAIL PROTECTED]> wrote: > With this configuration, the username is stripped as it should be, but I > get the following error in the log: ... > radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE > Username = '[EMAIL PROTECTED]' ORDER BY id' That's most li

Re: tables replication ...

2002-05-10 Thread Alan DeKok
Marco Steinacher <[EMAIL PROTECTED]> wrote: > This setup will only works if you only do non conflicting updates between the > tables. In other words, if you insert data in A and C, you should never > insert a row in A that may have a conflicting key with a row insert in C. > You should also n

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

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 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 sub

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: 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" User-Passwo

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 > > test: > > User-Name = testuser > User-Password = > Acct-Status-Type = Start You need Acct-Session

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 test: User-Name = testuser User-Password =

Re: MySql accounting help

2002-05-10 Thread Alan DeKok
Michael Klatsky <[EMAIL PROTECTED]> wrote: > So my question is- how can I test accounting? It doesn't appear to be > sending the info to mysql database, as this log entry shows: > ... > radius_xlat: 'rlm_sql: packet has no account status type. [user > 'testuser', nas '255.255.255.255']' Step

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 PROTECT

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: Attemptin

LOCAL target and username stripping

2002-05-10 Thread Veli-Matti Riepula
Hello all, I have found that when using LOCAL as auth/acct host in proxy.conf realm definitions, the username is not stripped. Is there a way to get it stripped somehow? Now my way around it is to point the host to 127.0.0.1 and use "nostrip" option, but this is not very elegant. Regards, Veli-M

Re: USR Netserver problems!!!!

2002-05-10 Thread Alan DeKok
=?gb2312?q?ruidan=20su?= <[EMAIL PROTECTED]> wrote: > my NAS is USR Netserver 8/16 Plus V.34/I-Modem and I am trying to > configure freeradius+Netserver. But I found a problem: > Authentication works nomally but accounting not. I use the debug > mode to run freeradius. From the debug output, I kno

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-Re

Re: PAM module and realm

2002-05-10 Thread Alan DeKok
"Buschel, Alejandro" <[EMAIL PROTECTED]> wrote: > Is it possible to define a realm for pam_radius_auth module? No. There is no 'realm' attribute which can go into a RADIUS packet. If you want to add '@realm.name' to the end of every user name, then you can edit the source of the module to a

problems with users after upgrading...

2002-05-10 Thread Aamer Akhter
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. Here is the output from -X: rad_recv: Access-Request packet from host 10.13.0.41:1645, id=109, length=79 User-Name = "as" P

PAM module and realm

2002-05-10 Thread Buschel, Alejandro
Is it possible to define a realm for pam_radius_auth module? Currently the only parameters are: server[:port] shared_secret timeout (s) Thanks, Alejandro Buschel - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Freeradius 0.5 with mysql...

2002-05-10 Thread Michael Klatsky
Lin- I believe adding /usr/lib/mysql into your /etc/ld.so.conf file and rerunnig ldconfig will do it. Michael On Fri, 2002-05-10 at 03:37, Houcheng wrote: > Dear all Freeradius users: > > I've installed freeradius 0.5 and mysql database on my linux, > and both run well. Now I try to log

Re: duplicate sessions and cleanup_delay

2002-05-10 Thread Alan DeKok
"Alexandre Strube" <[EMAIL PROTECTED]> wrote: > On Wed, 8 May 2002 18:22:26 -0300, Guillermo Schimmel wrote: > > > It is very important to us. Otherwise, what I intend to do is > > activate de uniq module and make an unique index in postgres so > > the database is going to reject the duplicated pa

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

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 na

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 >phon

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: *****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 >

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: [Oz-ISP] Portmaster 2E

2002-05-10 Thread Artur Hecker
hmmm, if it is important to you to keep your current configuration and for some reasons you don't want radius to listen on two ports, you could simply use a udp-proxy, i.e. a small simple programm which will copy ongoing packets from one udp-socket to another and vice versa... just search the ne

Freeradius 0.5 with mysql...

2002-05-10 Thread Houcheng
Dear all Freeradius users:       I've installed freeradius 0.5 and mysql database on my linux, and both run well. Now I try to log the accounting information into mysql database, so I modify the "sql.conf" and change the driver to "rlm_sql_mysql".   When I start the radiusd, it fails w

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 wi