/etc/freeradius/3.0/mods-config/sql/ippool-dhcp/sqlite/schema.sql is in freeradius-config 3.0.12+dfsg-5+deb9u1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | CREATE TABLE radippool (
id int PRIMARY KEY,
pool_name varchar(30) NOT NULL,
framedipaddress varchar(30) NOT NULL,
nasipaddress varchar(30) NOT NULL DEFAULT '',
pool_key varchar(64) NOT NULL DEFAULT '',
calledstationid varchar(64),
callingstationid varchar(64) NOT NULL DEFAULT '',
expiry_time timestamp DEFAULT NULL,
username varchar(100)
);
-- Example of how to put IPs in the pool
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (1, 'local', '192.168.5.10');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (2, 'local', '192.168.5.11');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (3, 'local', '192.168.5.12');
-- INSERT INTO radippool (id, pool_name, framedipaddress) VALUES (4, 'local', '192.168.5.13');
|