2 Independent MYSQL schemas for 2 independent groups of users

Stefan Paetow Stefan.Paetow at jisc.ac.uk
Thu Aug 13 09:33:50 CEST 2015


> 1. In radiusd.conf, should I also duplicate each of this for a separate
>    sql instance?
>    $INCLUDE sql/mysql/counter.conf
>    $INCLUDE sqlippool.conf

Only if they are different for the two instances.

> 2. In file sql/mysql/counter.conf, there are lines
>    sqlcounter dailycounter {
>        sqlmod-inst = sql
>    }
>    So do I have to replace the sql entry with sqlinst2 etc?

You might need to define a second sqlcounter instance...

> 4. In the sites-available/default or virtual-server file, there is an entry
>    sqlippool
>    How should I handle this to match a multiple mysql instances scenario?

Yes, I suppose you would need to duplicate the instances, yes. Although I think in the longer run (if you end up with several, not just two, virtual servers for multiple clients), this is not workable, and you'll have to look at alternatives (like amending the schema to be able to figure out which server they're using).

:-)

Stefan Paetow
Moonshot Industry & Research Liaison Coordinator

t: +44 (0)1235 822 125
gpg: 0x3FCE5142
xmpp: stefanp at jabber.dev.ja.net
skype: stefan.paetow.janet
Lumen House, Library Avenue, Harwell Oxford, Didcot, OX11 0SG

jisc.ac.uk

Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc’s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800.
Jisc Collections and Janet Ltd. is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under Company No. number 2881024, VAT No. GB 197 0632 86. The registered office is: Lumen House, Library Avenue, Harwell, Didcot, Oxfordshire, OX11 0SG. T 01235 822200.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 496 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20150813/b6c8887d/attachment.sig>


More information about the Freeradius-Users mailing list