Mercurial > hg > freeDiameter
comparison doc/app_acct.conf.sample @ 528:1b3b9790e7cb
Add a new field in the app_acct.fdx database to receive the name of the local server.
Update your existing tables with the following SQL command:
ALTER TABLE "incoming" ADD "recorded_serv" bytea NOT NULL;
| author | Sebastien Decugis <sdecugis@nict.go.jp> |
|---|---|
| date | Fri, 03 Sep 2010 16:46:16 +0900 |
| parents | e27cb71abd4b |
| children | be646053706b |
comparison
equal
deleted
inserted
replaced
| 527:e27cb71abd4b | 528:1b3b9790e7cb |
|---|---|
| 42 # | 42 # |
| 43 # In case the default behavior for an AVP is fine, you can use the short syntax: | 43 # In case the default behavior for an AVP is fine, you can use the short syntax: |
| 44 # "AVP-dictionary-name"; | 44 # "AVP-dictionary-name"; |
| 45 # | 45 # |
| 46 # Note that at the moment, GROUPED AVP are not supported. Also, only the top-level AVPs are | 46 # Note that at the moment, GROUPED AVP are not supported. Also, only the top-level AVPs are |
| 47 # search. This behavior can be changed quite easily if needed. | 47 # searched. This behavior can be changed quite easily if needed. |
| 48 | 48 |
| 49 # The following list is informative only. | 49 # The following list is informative only. |
| 50 # You may also consult RFC4005 sections 10.2.1 and 10.2.2 for other examples | 50 # You may also consult RFC4005 sections 10.2.1 and 10.2.2 for other examples |
| 51 # "Origin-Host"; | 51 # "Origin-Host"; |
| 52 # "Origin-Realm"; | 52 # "Origin-Realm"; |
| 105 # "Login-Service"; | 105 # "Login-Service"; |
| 106 # "Login-TCP-Port"; | 106 # "Login-TCP-Port"; |
| 107 # "Route-Record" = { multi=5; }; # Record the last 5 hops of the message | 107 # "Route-Record" = { multi=5; }; # Record the last 5 hops of the message |
| 108 | 108 |
| 109 # This is the database table corresponding to this list: | 109 # This is the database table corresponding to this list: |
| 110 # CREATE TABLE app_acct ( | 110 # CREATE TABLE incoming ( |
| 111 # "recorded_on" timestamp with time zone NOT NULL, | 111 # "recorded_on" timestamp with time zone NOT NULL, |
| 112 # "recorded_serv" bytea NOT NULL, | |
| 112 # "Origin-Host" bytea NOT NULL, | 113 # "Origin-Host" bytea NOT NULL, |
| 113 # "Origin-Realm" bytea NOT NULL, | 114 # "Origin-Realm" bytea NOT NULL, |
| 114 # "Destination-Realm" bytea, | 115 # "Destination-Realm" bytea, |
| 115 # "Destination-Host" bytea, | 116 # "Destination-Host" bytea, |
| 116 # "Session-Id" bytea NOT NULL, | 117 # "Session-Id" bytea NOT NULL, |
| 192 # Example: Table = "incoming"; | 193 # Example: Table = "incoming"; |
| 193 | 194 |
| 194 # Timestamp_field: | 195 # Timestamp_field: |
| 195 # Optionaly, you can specify a name of a field that will receive the value 'now' when a new record is inserted. | 196 # Optionaly, you can specify a name of a field that will receive the value 'now' when a new record is inserted. |
| 196 # Default: no timestamp is inserted. | 197 # Default: no timestamp is inserted. |
| 197 # Example: Timestamp_field = "inc_ts"; | 198 # Example: Timestamp_field = "recorded_on"; |
| 198 | 199 |
| 199 | 200 # Server_name_field: |
| 200 | 201 # Optionaly, you can specify a field which will receive the Diameter Identity of the local server for each record saved. |
| 201 | 202 # This is useful especially if you have several Accounting servers and want to check Load-Balancing behavior or so, |
| 202 | 203 # after aggregating all the data. |
| 204 # Default: no server name inserted. | |
| 205 # Example: Server_name_field = "recorded_serv"; | |
| 206 | |
| 207 | |
| 208 |