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: freeradius-users-bounces+info=mazone.info@lists.freeradius.org [mailto:freeradius-users-bounces+info=mazone.info@lists.freeradius.org] 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 info@mazone.info 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