Mercurial > hg > freeDiameter
annotate doc/app_acct.conf.sample @ 529:be646053706b
Removed the NON NULL constraint to ease updates
author | Sebastien Decugis <sdecugis@nict.go.jp> |
---|---|
date | Fri, 03 Sep 2010 16:50:04 +0900 |
parents | 1b3b9790e7cb |
children | 4cdf146f11d5 |
rev | line source |
---|---|
284
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
1 ####################### |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
2 # This file contains the description of configuration and general information about the |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
3 # "App_Acct" extension. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
4 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
5 # This extension provides a simple Diameter Accounting server. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
6 # The extension does receive the Accounting-Request message, then |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
7 # saves the contents of the AVP in a database, as configured here. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
8 # The data is not processed at all. The intent is that a dedicated |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
9 # application will then pull from this database and process the data (consolidate |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
10 # sessions, ...) |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
11 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
12 # In order to enable this extension, the main freeDiameter configuration file |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
13 # must contain the following declaration: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
14 # LoadExtension = "extensions/app_acct.fdx" : "/path/to/app_acct.conf" ; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
15 ####################### |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
16 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
17 ################# |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
18 ## Part I: AVP ## |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
19 ################# |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
20 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
21 # Configure here the AVPs that must be stored in the database. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
22 # The format is: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
23 # "AVP-dictionary-name" = { |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
24 # field = "db-field-name"; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
25 # required; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
26 # multi=N; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
27 # }; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
28 # Where: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
29 # AVP-dictionary-name: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
30 # The name of the AVP, such as "Session-Id". Only this field is mandatory. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
31 # field="...": |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
32 # The name of the field in the database where is AVP contents will be saved. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
33 # The default is that the field is named as the AVP-dictionary-name. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
34 # required: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
35 # By default, if the AVP is not in the Diameter message, it is not passed in |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
36 # the INSERT statement (will get NULL). If Required is specified for the AVP, |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
37 # an error is returned in the Diameter answer, and the data is discarded. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
38 # multi=N: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
39 # If an AVP may appear several times in a request, you may specify a number of |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
40 # occurrences to save in the database. The Nth first occurrences of the AVP |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
41 # will be saved in fields "db-field-name1", "db-field-name2", ... "db-field-nameN" |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
42 # |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
43 # In case the default behavior for an AVP is fine, you can use the short syntax: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
44 # "AVP-dictionary-name"; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
45 # |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
46 # Note that at the moment, GROUPED AVP are not supported. Also, only the top-level AVPs are |
528
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
47 # searched. This behavior can be changed quite easily if needed. |
284
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
48 |
290
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
49 # The following list is informative only. |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
50 # You may also consult RFC4005 sections 10.2.1 and 10.2.2 for other examples |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
51 # "Origin-Host"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
52 # "Origin-Realm"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
53 # "Destination-Realm"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
54 # "Destination-Host"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
55 # "Session-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
56 # "Origin-State-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
57 # "Accounting-Record-Type"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
58 # "Accounting-Record-Number"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
59 # "User-Name"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
60 # "Event-Timestamp"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
61 # "Acct-Application-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
62 # "Accounting-Sub-Session-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
63 # "Acct-Session-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
64 # "Acct-Multi-Session-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
65 # "Origin-AAA-Protocol"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
66 # "Acct-Delay-Time"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
67 # "NAS-Identifier"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
68 # "NAS-IP-Address"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
69 # "NAS-IPv6-Address"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
70 # "NAS-Port"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
71 # "NAS-Port-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
72 # "NAS-Port-Type"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
73 # "Service-Type"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
74 # "Termination-Cause"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
75 # "Accounting-Input-Octets"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
76 # "Accounting-Input-Packets"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
77 # "Accounting-Output-Octets"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
78 # "Accounting-Output-Packets"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
79 # "Acct-Authentic"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
80 # "Acct-Link-Count"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
81 # "Acct-Session-Time"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
82 # "Acct-Tunnel-Connection"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
83 # "Acct-Tunnel-Packets-Lost"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
84 # "Callback-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
85 # "Callback-Number"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
86 # "Called-Station-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
87 # "Calling-Station-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
88 # "Connect-Info"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
89 # "Originating-Line-Info"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
90 # "Authorization-Lifetime"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
91 # "Session-Timeout"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
92 # "Idle-Timeout"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
93 # "Port-Limit"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
94 # "Accounting-Realtime-Required"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
95 # "Acct-Interim-Interval"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
96 # "Filter-Id"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
97 # "NAS-Filter-Rule"; |
527 | 98 # "QoS-Filter-Rule"; |
290
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
99 # "Login-IP-Host"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
100 # "Login-IPv6-Host"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
101 # "Login-LAT-Group"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
102 # "Login-LAT-Node"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
103 # "Login-LAT-Port"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
104 # "Login-LAT-Service"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
105 # "Login-Service"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
106 # "Login-TCP-Port"; |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
107 # "Route-Record" = { multi=5; }; # Record the last 5 hops of the message |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
108 |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
109 # This is the database table corresponding to this list: |
528
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
110 # CREATE TABLE incoming ( |
290
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
111 # "recorded_on" timestamp with time zone NOT NULL, |
529
be646053706b
Removed the NON NULL constraint to ease updates
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
528
diff
changeset
|
112 # "recorded_serv" bytea, |
290
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
113 # "Origin-Host" bytea NOT NULL, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
114 # "Origin-Realm" bytea NOT NULL, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
115 # "Destination-Realm" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
116 # "Destination-Host" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
117 # "Session-Id" bytea NOT NULL, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
118 # "Origin-State-Id" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
119 # "Accounting-Record-Type" integer NOT NULL, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
120 # "Accounting-Record-Number" integer NOT NULL, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
121 # "User-Name" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
122 # "Event-Timestamp" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
123 # "Acct-Application-Id" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
124 # "Accounting-Sub-Session-Id" bigint, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
125 # "Acct-Session-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
126 # "Acct-Multi-Session-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
127 # "Origin-AAA-Protocol" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
128 # "Acct-Delay-Time" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
129 # "NAS-Identifier" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
130 # "NAS-IP-Address" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
131 # "NAS-IPv6-Address" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
132 # "NAS-Port" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
133 # "NAS-Port-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
134 # "NAS-Port-Type" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
135 # "Service-Type" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
136 # "Termination-Cause" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
137 # "Accounting-Input-Octets" bigint, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
138 # "Accounting-Input-Packets" bigint, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
139 # "Accounting-Output-Octets" bigint, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
140 # "Accounting-Output-Packets" bigint, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
141 # "Acct-Authentic" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
142 # "Acct-Link-Count" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
143 # "Acct-Session-Time" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
144 # "Acct-Tunnel-Connection" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
145 # "Acct-Tunnel-Packets-Lost" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
146 # "Callback-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
147 # "Callback-Number" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
148 # "Called-Station-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
149 # "Calling-Station-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
150 # "Connect-Info" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
151 # "Originating-Line-Info" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
152 # "Authorization-Lifetime" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
153 # "Session-Timeout" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
154 # "Idle-Timeout" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
155 # "Port-Limit" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
156 # "Accounting-Realtime-Required" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
157 # "Acct-Interim-Interval" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
158 # "Filter-Id" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
159 # "NAS-Filter-Rule" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
160 # "QoS-Filter-Rule" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
161 # "Login-IP-Host" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
162 # "Login-IPv6-Host" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
163 # "Login-LAT-Group" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
164 # "Login-LAT-Node" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
165 # "Login-LAT-Port" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
166 # "Login-LAT-Service" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
167 # "Login-Service" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
168 # "Login-TCP-Port" integer, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
169 # "Route-Record1" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
170 # "Route-Record2" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
171 # "Route-Record3" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
172 # "Route-Record4" bytea, |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
173 # "Route-Record5" bytea |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
174 # ); |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
175 |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
176 |
7842bed901ca
Updated documentation
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
284
diff
changeset
|
177 |
284
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
178 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
179 ####################### |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
180 ## Part II: Database ## |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
181 ####################### |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
182 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
183 # You must specify the connection information to the database here. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
184 # Please note that if the connection is terminated, it will trig the shutdown of the freeDiameter daemon |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
185 # For this reason, you should as much as possible use a local database. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
186 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
187 # ConnInfo: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
188 # The connection string to the database. See http://www.postgresql.org/docs/8.4/static/libpq-connect.html |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
189 # Example: ConnInfo = "host=localhost port=5432 dbname=acct user=acct password=freediameter"; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
190 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
191 # Table: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
192 # The name of the table to use. The fields and types in this table must be created accordingly to the Part I configuration in this file. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
193 # Example: Table = "incoming"; |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
194 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
195 # Timestamp_field: |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
196 # Optionaly, you can specify a name of a field that will receive the value 'now' when a new record is inserted. |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
197 # Default: no timestamp is inserted. |
528
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
198 # Example: Timestamp_field = "recorded_on"; |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
199 |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
200 # Server_name_field: |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
201 # Optionaly, you can specify a field which will receive the Diameter Identity of the local server for each record saved. |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
202 # This is useful especially if you have several Accounting servers and want to check Load-Balancing behavior or so, |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
203 # after aggregating all the data. |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
204 # Default: no server name inserted. |
1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
527
diff
changeset
|
205 # Example: Server_name_field = "recorded_serv"; |
284
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
206 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
207 |
397cdcd41f53
New app_acct in progress, backup only
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff
changeset
|
208 |