RE: Assign IP based on CallingStationID.

2006-11-09 Thread John Longland
value - [mac adress] still get username ask ?! no connection. dunno, what's the idea behinf this query ? mac = username ? no username, auth is done true mac ? Cheers Collen John Longland wrote: > > authorize_check_query = "select id,UserName,Attribute,Value,op FROM >

RE: Assign IP based on CallingStationID.

2006-11-09 Thread John Longland
change anything in that. Some callingstationid is not friendly for my network (they should have only http traffic). That’s why I want to assign them IP from specific pool – I going to setup firewall rules for a such IPs. Any idea ? John Longland wrote: > > Yes, I have just done it. &g

RE: Assign IP based on CallingStationID.

2006-11-08 Thread John Longland
Title: RE: Assign IP based on CallingStationID. Yes, I have just done it. You need to change the sql-statement in /etc/raddb/sql.conf That is the autorize_check_query.Depending on how you use your tables, the query that I am using may or may not work. If you want I can give you the one th

CHAP on freeradius & mysql

2006-11-03 Thread John Longland
Title: CHAP on freeradius & mysql Hi all My freeradius server has been running for some time now and due to the users file getting a bit long, I decide to go with the mysql-database. I have my PAP-clients running on the new mysql-radius setup but my CHAP clients are still failing. When

RE: Database query failed: Table 'radius.radcheck' doesn't exist

2006-11-02 Thread John Longland
Title: RE: Database query failed: Table 'radius.radcheck' doesn't exist Dusan 1. I assume you did run the db_sql_mysql.sql  script to create the database schema ?? This will create the majority of the schema. 2. Did you run the sql-scripts in /usr/local/dialup_admin/sql ? They are execute

Calling Station ID ; mysql

2006-11-01 Thread John Longland
Title: Calling Station ID ; mysql Hi all !! I have been running Freeradius fro a while now ( Ver 1.0.1 ) and so far I have been using the "users" file. To be able to use dilaup-admin interface so that people with no linux experience can maintain the system, I had to switch to the mysql-data