Re: MySQL MSSQL

2007-04-25 Thread Alan DeKok 
[EMAIL PROTECTED] wrote:
 Have anybody of you manage to configure freeradius to pull authorization
 iformation from MySQL and MSSQL (via ODBC/freetds) at the same time??

  Have you listed two instances of the SQL module?  See
doc/configurable_failover for examples.

 But, is there a way to configure a failover to ask MSSQL and then MySQL and
 have both modules running at the same time??

  Yes.

  Configure the modules as:

  sql mssql {
... configuration ...
  }
  sql mysql {
... configuration ...
  }

  And then refer to them as mssql or mysql, and never sql.

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

RE: MySQL MSSQL

2007-04-25 Thread info 

Thanks a lot, my erroe was thay I was still using sql for mysql as soon as
I define mysql and mssql separetely it worked, now I have

mssql + mysql + userfiles + password + NIS

all 5 methods working at the same time

Thanks a lot!

-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En
nombre de Alan DeKok
Enviado el: Miércoles, 25 de Abril de 2007 02:40 a.m.
Para: FreeRadius users mailing list
Asunto: Re: MySQL  MSSQL

[EMAIL PROTECTED] wrote:
 Have anybody of you manage to configure freeradius to pull authorization
 iformation from MySQL and MSSQL (via ODBC/freetds) at the same time??

  Have you listed two instances of the SQL module?  See
doc/configurable_failover for examples.

 But, is there a way to configure a failover to ask MSSQL and then MySQL
and
 have both modules running at the same time??

  Yes.

  Configure the modules as:

  sql mssql {
... configuration ...
  }
  sql mysql {
... configuration ...
  }

  And then refer to them as mssql or mysql, and never sql.

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html