#########################################
## 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.
+ # support, such as PostgreSQL, or using MySQL
+ # with InnoDB.
#
################################################################
- # $INCLUDE sql/mysql/ippool.conf
- $INCLUDE sql/postgresql/ippool.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})"