I use MySQL DB and the hotspot table structure was defined in the previous posts.
However, what file must I modified for RADIUS program read hotspot table in the MySQL DB?
>From: Kostas Kalevras <[EMAIL PROTECTED]>
>Reply-To: freeradius-users@lists.freeradius.org
>To: freeradius-users@lists.freeradius.org
>Subject: RE: questions about the clients.conf file
>Date: Sat, 26 Feb 2005 02:15:40 +0200 (EET)
>
>On Fri, 25 Feb 2005, Luca Lafranchi list wrote:
>
>>Thanks for Q1...
>>
>>And for Q2: I have analized the file sql " db_mysql.sql"
>>The table "nas" isn't imported on mysql, because have a syntax
>>error.
>>I can't set the "id" field to DEFAULT '0' if is NOT NULL and
>>AUTO_INCREMENT
>>!!!
>>
>>The same error for dictionary table
>
>Fixed, thanks. The dictionary table is not used so don't bother with
>it.
>
>>
>>#
>># Table structure for table 'nas'
>>#
>>CREATE TABLE nas (
>>
>>
>> id int(10) DEFAULT '0' NOT NULL auto_increment,
>>
>>change to
>>
>> id int(10) NOT NULL auto_increment,
>>
>>
>> nasname varchar(128) NOT NULL,
>> shortname varchar(32),
>> type varchar(30) DEFAULT 'other',
>> ports int(5),
>> secret varchar(60) DEFAULT 'secret' NOT NULL,
>> community varchar(50),
>> description varchar(200) DEFAULT 'RADIUS Client',
>> PRIMARY KEY (id),
>> KEY nasname (nasname)
>>);
>>
>>
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED] On Behalf Of
>>Thor
>>Spruyt
>>Sent: venerd?, 25. febbraio 2005 19:08
>>To: freeradius-users@lists.freeradius.org
>>Subject: Re: questions about the clients.conf file
>>
>>Q1: split the internet in half: 0.0.0.0/1 and 128.0.0.0/1
>>Q2: read sql docs and configuration files
>>
>>----- Original Message -----
>>From: Lists
>>To: freeradius-users@lists.freeradius.org
>>Sent: Friday, February 25, 2005 5:34 PM
>>Subject: questions about the clients.conf file
>>
>>
>>Hi,
>>I have two questions about the clients.conf file:
>>
>>_ when I define a client on this file, I need to write the ip or
>>the
>>hostname or a network... it's possible to enable all client to
>>execute an
>>AAA request (it's for testing) ?
>>
>>_ it's possible to move the clients.conf informations to a Mysql
>>table ?
>>
>>Thank you
>>Luca
>>
>>
>>
>>
>>
>>
>>
>>-
>>List info/subscribe/unsubscribe? See
>>http://www.freeradius.org/list/users.html
>>
>>
>>-
>>List info/subscribe/unsubscribe? See
>>http://www.freeradius.org/list/users.html
>>
>
>--
>Kostas Kalevras Network Operations Center
>[EMAIL PROTECTED] National Technical University of Athens, Greece
>Work Phone: +30 210 7721861
>'Go back to the shadow' Gandalf
>
>- List info/subscribe/unsubscribe? See
>http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
