blob: 601ac48f0ed85623e97a0dd160222449c27d8230 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
/*
* IP Engineering RADIUS Servers
*
* ippool-demo.sql - inserts demo data into RADIUS IP Pools database
*
* Usage: psql -f ippool-demo.sql radius_ippool
*
*/
SET ROLE radius_ippool;
SELECT pool_add( poolName := 'DHCP' );
SELECT pool_add( poolName := 'PPPoE' );
SELECT region_add( regionName := 'Anchorage' );
SELECT region_add( regionName := 'Soldotna' );
SELECT region_add( regionName := 'Fairbanks' );
SELECT nas_add( nasName := 'br1.cwc', regionName := 'Anchorage' );
SELECT nas_add( nasName := 'bras.eng', regionName := 'Anchorage' );
SELECT nas_add( nasName := 'br1.sol', regionName := 'Soldotna' );
INSERT INTO block ( poolId, regionId, net, description ) VALUES
( ( SELECT id FROM pool WHERE name LIKE 'dhcp' ),
( SELECT id FROM region WHERE name LIKE 'anchorage' ),
'209.112.156.0/23',
'Admin Blocks' ),
( ( SELECT id FROM pool WHERE name LIKE 'dhcp' ),
( SELECT id FROM region WHERE name LIKE 'anchorage' ),
'209.112.128.0/24',
'User Blocks' );
/* end of sql */
|
