##
## The database schemas are available at:
##
-## doc/examples/*.sql
+## raddb/sql/DB/ippool.sql
##
## $Id$
#########################################
## SQL instance to use (from sql.conf) ##
+ ##
+ ## If you have multiple sql instances, such as "sql sql1 {...}",
+ ## use the *instance* name here: sql1.
#########################################
sql-instance-name = "sql"
# pool-key = "%{Calling-Station-Id}"
################################################################
- ## Uncomment the appropriate config file for your SQL dialect ##
+ #
+ # WARNING: MySQL has certain limitations that means it can
+ # hand out the same IP address to 2 different users.
+ #
+ # We suggest using an SQL DB with proper transaction
+ # support, such as PostgreSQL, or using MySQL
+ # with InnoDB.
+ #
################################################################
- # $INCLUDE sql/mysql-ippool-dialup.conf
- $INCLUDE sql/postgresql-ippool-dialup.conf
-
-
+ #
+ # Use the same database as configured in the "sql" module, "database"
+ # configuration item. Change the "postgresql" name below to be the
+ # same as the "database" field of the SQL module referred to in the
+ # "sql-instance-name", above.
+ #
+$INCLUDE sql/postgresql/ippool.conf
+
## Logging configuration. (Comment out to disable logging)
sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \
(did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"