2 Independent MYSQL schemas for 2 independent groups of users

[Stefan Paetow]

> I have gone through many information but none of them tells which file
> or conf are responsible for 2 independent sql instances.

You use the sql.conf file in /etc/raddb - Make a copy of it, call it... sql-instance2.conf.

In sql-instance2.conf, modify the "sql {" line to say "sql sqlinst2 {"

Tweak it to fit your second instance.

In radiusd.conf, search for the line "$INCLUDE sql.conf" (it should be uncommented). Duplicate the line, change the second one to "$INCLUDE sql-instance2.conf".

In the second virtual server, instead of 'sql', use 'sqlinst2'.

That should do it.

:-)

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/20150812/13fde10b/attachment.sig>