mysql default install schema (Matt Manjos)

[Matt Manjos]

Thank you, it loaded into the database fine.


On 7/17/06, Kun Niu <haoniukun at gmail.com> wrote:
> Hi Matt,
>
> Here is the db_mysql.gz I copied from /usr/share/doc/freeradius/examples
> You can make some minor changes if you get warning when installing.
> Hope you good luck.:)
>
> ###########################################################################
> #  db_mysql.sql                     rlm_sql - FreeRADIUS SQL Module       #
> #                                                                         #
> #     Database schema for MySQL rlm_sql module                            #
> #                                                                         #
> #     To load:                                                            #
> #         mysql -uroot -prootpass radius < db_mysql.sql                   #
> #                                                                         #
> #                                   Mike Machado <mike at innercite.com>     #
> ###########################################################################
> #
> # Table structure for table 'radacct'
> #
>
> CREATE TABLE radacct (
>   RadAcctId bigint(21) NOT NULL auto_increment,
>   AcctSessionId varchar(32) NOT NULL default '',
>   AcctUniqueId varchar(32) NOT NULL default '',
>   UserName varchar(64) NOT NULL default '',
>   Realm varchar(64) default '',
>   NASIPAddress varchar(15) NOT NULL default '',
>   NASPortId int(12) default NULL,
>   NASPortType varchar(32) default NULL,
>   AcctStartTime datetime NOT NULL default '0000-00-00 00:00:00',
>   AcctStopTime datetime NOT NULL default '0000-00-00 00:00:00',
>   AcctSessionTime int(12) default NULL,
>   AcctAuthentic varchar(32) default NULL,
>   ConnectInfo_start varchar(32) default NULL,
>   ConnectInfo_stop varchar(32) default NULL,
>   AcctInputOctets bigint(12) default NULL,
>   AcctOutputOctets bigint(12) default NULL,
>   CalledStationId varchar(50) NOT NULL default '',
>   CallingStationId varchar(50) NOT NULL default '',
>   AcctTerminateCause varchar(32) NOT NULL default '',
>   ServiceType varchar(32) default NULL,
>   FramedProtocol varchar(32) default NULL,
>   FramedIPAddress varchar(15) NOT NULL default '',
>   AcctStartDelay int(12) default NULL,
>   AcctStopDelay int(12) default NULL,
>   PRIMARY KEY  (RadAcctId),
>   KEY UserName (UserName),
>   KEY FramedIPAddress (FramedIPAddress),
>   KEY AcctSessionId (AcctSessionId),
>   KEY AcctUniqueId (AcctUniqueId),
>   KEY AcctStartTime (AcctStartTime),
>   KEY AcctStopTime (AcctStopTime),
>   KEY NASIPAddress (NASIPAddress)
> ) ;
>
> #
> # Table structure for table 'radcheck'
> #
>
> CREATE TABLE radcheck (
>   id int(11) unsigned NOT NULL auto_increment,
>   UserName varchar(64) NOT NULL default '',
>   Attribute varchar(32)  NOT NULL default '',
>   op char(2) NOT NULL DEFAULT '==',
>   Value varchar(253) NOT NULL default '',
>   PRIMARY KEY  (id),
>   KEY UserName (UserName(32))
> ) ;
>
> #
> # Table structure for table 'radgroupcheck'
> #
>
> CREATE TABLE radgroupcheck (
>   id int(11) unsigned NOT NULL auto_increment,
>   GroupName varchar(64) NOT NULL default '',
>   Attribute varchar(32)  NOT NULL default '',
>   op char(2) NOT NULL DEFAULT '==',
>   Value varchar(253)  NOT NULL default '',
>   PRIMARY KEY  (id),
>   KEY GroupName (GroupName(32))
> ) ;
>
> #
> # Table structure for table 'radgroupreply'
> #
>
> CREATE TABLE radgroupreply (
>   id int(11) unsigned NOT NULL auto_increment,
>   GroupName varchar(64) NOT NULL default '',
>   Attribute varchar(32)  NOT NULL default '',
>   op char(2) NOT NULL DEFAULT '=',
>   Value varchar(253)  NOT NULL default '',
>   prio int unsigned NOT NULL default '0',
>   PRIMARY KEY  (id),
>   KEY GroupName (GroupName(32))
> ) ;
>
> #
> # Table structure for table 'radreply'
> #
>
> CREATE TABLE radreply (
>   id int(11) unsigned NOT NULL auto_increment,
>   UserName varchar(64) NOT NULL default '',
>   Attribute varchar(32) NOT NULL default '',
>   op char(2) NOT NULL DEFAULT '=',
>   Value varchar(253) NOT NULL default '',
>   PRIMARY KEY  (id),
>   KEY UserName (UserName(32))
> ) ;
>
>
> #
> # Table structure for table 'usergroup'
> #
>
> CREATE TABLE usergroup (
>   id int(11) unsigned NOT NULL auto_increment,
>   UserName varchar(64) NOT NULL default '',
>   GroupName varchar(64) NOT NULL default '',
>   PRIMARY KEY  (id),
>   KEY UserName (UserName(32))
> ) ;
>
> #
> # Table structure for table 'radpostauth'
> #
>
> CREATE TABLE radpostauth (
>   id int(11) NOT NULL auto_increment,
>   user varchar(64) NOT NULL default '',
>   pass varchar(64) NOT NULL default '',
>   reply varchar(32) NOT NULL default '',
>   date timestamp(14) NOT NULL,
>   PRIMARY KEY  (id)
> ) ;
>
> ######################################################################
> #
> #  The next two tables are commented out because they are not
> #  currently used in the server.
> #
>
> #
> # Table structure for table 'dictionary'
> #
> #CREATE TABLE dictionary (
> #  id int(10) DEFAULT '0' NOT NULL auto_increment,
> #  Type varchar(30),
> #  Attribute varchar(64),
> #  Value varchar(64),
> #  Format varchar(20),
> #  Vendor varchar(32),
> #  PRIMARY KEY (id)
> #);
>
> #
> # Table structure for table 'nas'
> #
> CREATE TABLE nas (
>   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)
> );
>
>
> > Date: Sun, 16 Jul 2006 18:50:03 -0400
> > From: "Matt Manjos" <mattdev121 at gmail.com>
> > Subject: mysql default install schema
> > To: freeradius-users at lists.freeradius.org
> > Message-ID:
> >        <3a1455400607161550q12f1809ex1e5058ee4192433a at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> >
> > Hello, it's my first install of freeradius using mysql for auth and I
> > must be going mental because I can't seem to find the default schema
> > to import into sql.
> >
> > I'm using freeradius-1.1.1 on gentoo, and i've looked in
> > /usr/share/doc/freeradius-1.1.1/sql.schemas and all of the source code
> > (/src/modules/rlm_sql/drivers/rlm_sql_mysql) and I still can't seem to
> > find it anywhere.
> >
> > Where do I get the default schema from?
> >
> > Many Thanks,
> > Matt
> >
> >
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>