SQL Cleanups (Was: Duplicate requests in a session)

[Peter Nixon]

On Thu 31 Aug 2006 18:48, Guy Fraser wrote:
> On Thu, 2006-08-31 at 07:33 -0400, Alan DeKok wrote:
> > Peter Nixon <listuser at peternixon.net> wrote:
> > > This makes sense to me. I think it should be for 2.0 though as changing
> > > the name of fields in a DB schema will break compatibility.
> >
> >   I'm not set on changing the name.  If it's a problem, we can leave
> > it as-is.
> >
> > > One of my pet peeves is that the mysql config file is called "sql.conf"
> > > which tends to confuse non-mysql users the first time around. This
> > > should be renamed to mysql.conf (oraclesql.conf should be renamed to
> > > oracle.conf also)
> >
> >   Let's fix that.
> >
> > > I think it may even be a good idea to make a raddb/sql/*.conf
> > > structure,= either that or maybe we should name the files
> > > sql.mysql.conf, sql.postgresl.conf etc. This then allows
> > > sqlippool.mysql.conf also.  (Alternatively the sqlipool config
> > > should go inside the existing sql config files.)
> >
> >   Sure.  We can also split the sql.conf file into:
> >
> >   sql.conf - global SQL things to the site, which does
> >      driver = postgresql
> >      trace files...
> >      $INCLUDE sql/postgresql.conf
> >
> >   for any postgres-specific things.
>
> That sounds interesting. It would likely make it easier to provide
> some alternate configuration files for the different types of
> radius installs like :
>
> sql/postgresql-dialup.conf
> sql/postgresql-wireless.conf
> sql/postgresql-voip.conf
>
> Providing these along with the appropriate schema files, could
> significantly reduce the problems for new adopters. I believe
> most of these versions are available in scattered locations
> around the net. I am only doing using it for dialup, so I have
> not done much research into the other configs.


Reorganisation of the SQL config files. Hold onto your hat.
CVS: ----------------------------------------------------------------------
CVS: Enter Log.  Lines beginning with `CVS:' are removed automatically
CVS:
CVS: Committing in .
CVS:
CVS: Modified Files:
CVS:    sql.conf
CVS: Added Files:
CVS:    sql/mssql-dialup.conf sql/mysql-dialup.conf
CVS:    sql/oracle-dialup.conf sql/postgresql-dialup.conf
CVS:    sql/postgresql-voip-postpaid.conf
CVS: Removed Files:
CVS:    mssql.conf oraclesql.conf pgsql-voip.conf postgresql.conf
CVS: ----------------------------------------------------------------------

Have fun :-)

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-devel/attachments/20060901/198d618b/attachment.pgp>