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@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.