3.45. <AuthBy EMERALD4>

<AuthBy EMERALD4> authenticates users from the Emerald version 4 database from IEA website Opens in new window. It also stores accounting and logs to the Emerald 4 SQL database.
Tip
There is a sample Radiator configuration file for Emerald 4 in goodies/emerald4.cfg in your Radiator distribution.
NOTICE
<AuthBy EMERALD> for Emerald versions older than Emerald 4 is still distributed with Radiator but will be removed in a future Radiator release.
<AuthBy EMERALD4> understands also the same parameters as <AuthBy SQL>. For more information, see Section 3.41. <AuthBy SQL>.

3.45.1. AuthSelect

AuthSelect This optional parameter from AuthBy SQL is pre-configured or Emerald 4 and need not be altered. Defaults to
AuthSelect exec RadGetUser %0, NULL

3.45.2. ConcurrencyControl

This optional flag controls whether to apply Simultaneous-Use limits to each user. Defaults to false.

3.45.3. TimeBanking

This optional flag control whether Time Banking limits are to be enforced. Defaults to false.

3.45.4. HonourServers

This optional flag controls whether this module will use the Emerald Servers list as an additional source of Radius Client addresses. ClientQuery is used to fetch the client list. Defaults to false.

3.45.5. HonourServerPortAccess

This optional flag controls whether this module will enforce time-based access limits for certain NAS ports. PortAccessQuery is used to fetch details of port restrictions. Defaults to false.

3.45.6. HonourDNISGroups

This optional flag controls whether this module will enforce limits on Called-Station-Id. DNISGroupQuery is used to fetch details of permitted groups. Defaults to false.

3.45.7. HonourRoamServers

This optional flag Controls whether RoamQuery will be used to get roaming restrictions. Defaults to false.

3.45.8. DNISGroupQuery

SQL query used to fetch DNIS Groups. This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:
DNISGroupQuery select dn.DNISNumber from AccountTypes a, \
DNISNumbers dn where a.AccountType="%0" and \
a.DNISGroupID=dn.DNISGroupID \
and dn.DNISNumber="%1"

3.45.9. PortAccessQuery

SQL query used to fetch permitted ports This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:
PortAccessQuery select sa.StartTime, sa.StopTime, \
sa.MaxSessionLength from Servers s, ServerAccess sa, \
AccountTypes at\
where s.IPAddress="%{Client:Name}" \
and s.ServerID = sa.ServerID \
and (sa.Port=%0 or sa.Port=9214328)\
and sa.AccountTypeID=at.AccountTypeID\
and at.AccountType="%1"\
order by sa.Port

3.45.10. RadUserQuery

SQL query used to fetch user attributes This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:
RadUserQuery exec RadGetConfigs %0

3.45.11. ClientQuery

SQL query used to fetch RADIUS client details This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:
ClientQuery select IPAddress, Secret, Community, ServerID \
from Servers

3.45.12. RoamQuery

SQL query used to fetch roaming restrictions This parameter is preconfigured for Emerald 4, and should not need to be changed. Defaults to:
RoamQuery exec RadRoamCache