Thank yo to replay, Diane.
Yes i use sql1.conf local host mysql db and sql2.conf to mysql server on the same subnet.
 
Alan, i use fedora 1 and on this system this is the last freeradius server version. Is this version 0.9.3-1.1 not stable?
 
Michel
 
----- Original Message -----
Sent: Sunday, January 09, 2005 6:34 PM
Subject: RE: Freeradius on two Mysql servers?

Just a tought

 

If you copy your sql2.conf over from the first server , did you change the IP  addres in the sql2.conf on the second server ?

sql1.conf refer to localhost so it is OK on both server.

 

   # Connect info

        server = "xxx.xxx.xxx.xxx"

        login = "radius"

        password = "xxxxxx"

 

 

diane

-----Original Message-----
From: Michel van Dop [mailto:[EMAIL PROTECTED]
Sent:
Sunday, January 09, 2005 10:34 AM
To: [email protected]
Subject: Freeradius on two Mysql servers?

 

Hello,

I wan to run TWO MySQL (3.23.58-4) servers and have FreeRadius (0.9.3-1.1) fall over between them, i do something like this: duplicate your sql.conf and edit the second copy to reflect connecting to your backup server ; then name the files something like sql1.conf and sql2.conf ; in radiusd.conf change and duplicate the include line for sql.conf to include sql1.conf and sql2.conf instead ; in the 'authorize' section of radiusd.conf change the 'sql' entry to a 'group' one, like this:

        $INCLUDE  ${confdir}/sql1.conf
        $INCLUDE  ${confdir}/sql2.conf
#    sql
  group {
    sql1 {
      fail  = 1
      notfound = return
      noop  = 2
      ok  = return
      updated = 3
      reject = return
      userlock = 4
      invalid = 5
      handled = 6
    }
    sql2 {
      fail  = 1
      notfound = return
      noop  = 2
      ok  = return
      updated = 3
      reject = return
      userlock = 4
      invalid = 5
      handled = 6
    }
  }
Jan  9 13:29:37 radius02 radiusd: Sun Jan  9 13:29:37 2005 : Info: Starting - reading configuration files ...
[Failed]
Can any one tell me to get this running? On one db is working fine. The second db is the same db version and tabel.
Thanks, 
Michel
 
 

Reply via email to