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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
/*
* 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;
-- create example pools
SELECT pool_add( poolName := 'DHCP' );
SELECT pool_add( poolName := 'PPPoE' );
SELECT pool_add( poolName := 'reserved' );
-- create example regions
SELECT region_add( regionName := 'Anchorage' );
SELECT region_add( regionName := 'Soldotna' );
SELECT region_add( regionName := 'Fairbanks' );
SELECT region_add( regionName := 'No where' );
-- create example NAS clients
SELECT nas_add( nasName := 'br1.cwc', regionName := 'Anchorage' );
SELECT nas_add( nasName := 'bras.eng', regionName := 'Anchorage' );
SELECT nas_add( nasName := 'br1.sol', regionName := 'Soldotna' );
-- Create example netblocks
SELECT netblock_add
( netAddress := '209.193.4.0/28',
poolName := 'DHCP',
regionName := 'Soldotna',
netActive := TRUE,
addIpEntries := TRUE
);
SELECT netblock_add
( netAddress := '209.193.4.0/29',
poolName := 'DHCP',
regionName := 'Soldotna',
netDesc := 'Reserved for engineering test accounts',
netActive := FALSE,
addIpEntries := TRUE
);
SELECT netblock_add
( netAddress := '209.193.4.16/28',
poolName := 'DHCP',
netActive := TRUE,
addIpEntries := TRUE
);
SELECT netblock_add
( netAddress := '209.193.4.32/28',
poolName := 'DHCP',
regionName := 'Anchorage',
netActive := FALSE,
addIpEntries := TRUE
);
SELECT netblock_add
( netAddress := '209.193.4.48/28',
poolName := 'DHCP',
regionName := 'Fairbanks',
netActive := FALSE,
addIpEntries := TRUE
);
-- create example explicit IP reservations
SELECT ip_assign
( assignIp := '209.193.4.8/32',
assignNas := 'br1.sol',
assignUser := 'jdoe8@acsalaska.net',
assignSess := 'aqaqqaasdqweaasdqa8'
);
SELECT ip_assign
( assignIp := '209.193.4.9/32',
assignNas := 'br1.sol',
assignUser := 'jdoe9@acsalaska.net',
assignSess := 'qweadszcxqweasdzcx9'
);
SELECT ip_assign
( assignIp := '209.193.4.10/32',
assignNas := 'br1.sol',
assignUser := 'jdoe10@acsalaska.net'
);
SELECT ip_assign
( assignIp := '209.193.4.11/32',
assignNas := 'br1.sol',
assignUser := 'jdoe11@acsalaska.net'
);
SELECT ip_assign
( assignIp := '209.193.4.12/32',
assignNas := 'br1.sol',
assignUser := 'jdoe12@acsalaska.net'
);
SELECT ip_assign
( assignIp := '209.193.4.13/32',
assignNas := 'br1.sol',
assignUser := 'jdoe13@acsalaska.net'
);
-- add missing IP addresses to netblock
SELECT ip_add_network( ipNetwork := '209.112.192.0/19' );
SELECT ip_add_network( ipNetwork := '209.112.128.0/18' );
/* end of sql */
|
