misc.sgml

H.323网守实现

<newline>
</descrip>

<item>
<tt/VirtualQueuePrefixes/<newline>
Default: none
<p>
This defines a list of prefixes for the virtual queues (used with the vqueue RoutingPolicy).

<descrip>
<tag/Example:/
<quote/<tt/VirtualQueuePrefixes=001215,1215//
<newline>
</descrip>

<item>
<tt/VirtualQueueRegex/<newline>
Default: none
<p>
This defines a regular expression for the virtual queues (used with the vqueue RoutingPolicy).

<descrip>
<tag/Example (numbers starting with 001215 or 1215):/
<quote/<tt/VirtualQueueRegex=^(001|1)215[0-9]*$//
<newline>
</descrip>

<item>
<tt/RequestTimeout/<newline>
Default: <tt/10/
Timeout in seconds for the external application to answer the RouteRequest.
If no answer is received during this time an ARJ will be sent to
the caller.
</itemize>


<sect1>Section &lsqb;SQLConfig&rsqb;
<label id="sqlconf">
<p>
Load gatekeeper settings from an SQL database (in addition to settings
read from the config file). A generic <tt/ConfigQuery/ can be used
to read almost all setting from the database and/or one of <tt/[RasSrv::RewriteE164]/,
<tt/[RasSrv::PermanentEndpoints]/, <tt/[RasSrv::Neighbors]/, 
<tt/[RasSrv::GWPrefixes]/ queries can be used to load particular settings.
Entries read from the SQL database take precedence over settings found
in the config file.

<itemize>
<item><tt/Driver=MySQL | PostgreSQL/<newline>
Default: N/A
<p>
SQL database driver to use. Currently, <tt/MySQL/ and <tt/PostgreSQL/ drivers
are implemented.

<item><tt/Host=DNS[:PORT] | IP[:PORT]/<newline>
Default: <tt/localhost/
<p>
SQL server host address. Can be in the form of <tt/DNS[:PORT]/ or <tt/IP[:PORT]/.
Like <tt/sql.mycompany.com/ or <tt/sql.mycompany.com:3306/ or <tt/192.168.3.100/.

<item><tt/Database=billing/<newline>
Default: <tt/billing/
<p>
The database name to connect to.

<item><tt/Username=gnugk/<newline>
<p>
The username used to connect to the database.

<item><tt/Password=secret/<newline>
<p>
The password used to connect to the database.
If the password is not specified, a database connection attempt 
without any password will be made.
If <tt/EncryptAllPasswords/ is enabled, or a <tt/KeyFilled/ variable is defined
in this section, the password is in encrypted form and should be created using
the <tt/addpasswd/ utility.

<item><tt/ConfigQuery=SELECT .../<newline>
Default: <tt>N/A</tt>
<p>
Define an SQL query used to read gatekeeper settings from the database. 
The query is parametrized - that means parameter replacement occurs before 
the query is executed. Parameter placeholders are denoted by <bf/%1/, <bf/%2/, ... 
strings. Specify %% to embed a percent character before a digit into string 
(like <bf/%%1/), specify <bf/%{1}/ to allow expansion inside complex expressions 
like <bf/%{1}123/. For <tt/ConfigQuery/ only one parameter is defined:
<itemize>
<item><tt/%1/ - the gatekeeper identifier
</itemize>
It is expected that the query returns zero or more rows of data,
with each row consisting of <bf/three/ columns:
<itemize>
<item><tt/column at index 0/ - config section name
<item><tt/column at index 1/ - config key (option name)
<item><tt/column at index 2/ - config value (option value)
</itemize>
<p>
Sample query strings:
<tscreen><verb>
ConfigQuery=SELECT secname, seckey, secval FROM sqlconfig WHERE gk = '%1'
ConfigQuery=SELECT '[RasSrv::RRQAuth]', alias, rule FROM rrqauth WHERE gk = '%1'
</verb></tscreen>

<item><tt/RewriteE164Query=SELECT .../<newline>
Default: <tt>N/A</tt>
<p>
Define an SQL query used to retrieve from the database rewrite rules 
for <tt/[RasSrv::RewriteE164]/ section. The query is parametrized 
- that means parameter replacement occurs before each query is executed. 
Parameter placeholders are denoted by <bf/%1/, <bf/%2/, ... strings. 
Specify %% to embed a percent character before a digit into string 
(like <bf/%%1/), specify <bf/%{1}/ to allow expansion inside complex expressions 
like <bf/%{1}123/. For <tt/RewriteE164Query/ only one parameter is defined:
<itemize>
<item><tt/%1/ - the gatekeeper identifier
</itemize>
It is expected that the query returns zero or more rows of data,
with each row consisting of two columns:
<itemize>
<item><tt/column at index 0/ - rewrite rule key
<item><tt/column at index 1/ - rewrite rule value
</itemize>
<p>
Sample query strings:
<tscreen><verb>
RewriteE164Query=SELECT rkey, rvalue FROM rewriterule WHERE gk = '%1'
</verb></tscreen>

<item><tt/NeighborsQuery=SELECT .../<newline>
Default: <tt>N/A</tt>
<p>
Define an SQL query used to retrieve from the database neighbor entries
for <tt/[RasSrv::Neighbors]/ section . The query is parametrized 
- that means parameter replacement occurs before each query
is executed. Parameter placeholders are denoted by <bf/%1/, <bf/%2/, ... 
strings. Specify %% to embed a percent character before a digit into string 
(like <bf/%%1/), specify <bf/%{1}/ to allow expansion inside complex expressions 
like <bf/%{1}123/. For <tt/NeighborsQuery/ one parameter is defined:
<itemize>
<item><tt/%1/ - the gatekeeper identifier
</itemize>
It is expected that the query returns zero or more rows of data,
with each row consisting of six columns:
<itemize>
<item><tt/column at index 0/ - neighbor name (idenitifier)
<item><tt/column at index 1/ - neighbor IP address
<item><tt/column at index 2/ - neighbor port number
<item><tt/column at index 3/ - optional prefixes (comma separated)
<item><tt/column at index 4/ - optional password
<item><tt/column at index 5/ - optional dynamic IP flag
</itemize>
<p>
Sample query strings:
<tscreen><verb>
NeighborsQuery=SELECT nid, nip, nport, npfx, NULL, 0 FROM neighbor WHERE gk = '%1'
</verb></tscreen>

<item><tt/PermanentEndpointsQuery=SELECT .../<newline>
Default: <tt>N/A</tt>
<p>
Define an SQL query used to retrieve permanent endpoints from the database 
for <tt/[RasSrv::PermanentEndpoints]/ section . The query is parametrized 
- that means parameter replacement occurs before each query
is executed. Parameter placeholders are denoted by <bf/%1/, <bf/%2/, ... 
strings. Specify %% to embed a percent character before a digit into string 
(like <bf/%%1/), specify <bf/%{1}/ to allow expansion inside complex expressions 
like <bf/%{1}123/. For <tt/PermanentEndpointsQuery/ only one parameter is defined:
<itemize>
<item><tt/%1/ - the gatekeeper identifier
</itemize>
It is expected that the query returns zero or more rows of data,
with each row consisting of four columns:
<itemize>
<item><tt/column at index 0/ - permanent endpoint IP address
<item><tt/column at index 1/ - permanent endpoint port number
<item><tt/column at index 2/ - permanent endpoint alias
<item><tt/column at index 3/ - optional permanent endpoint prefixes (comma separated)
</itemize>
<p>
Sample query strings:
<tscreen><verb>
PermanentEndpointsQuery=SELECT peip, 1720, pealias, NULL FROM permanentep WHERE gk = '%1'
</verb></tscreen>

<item><tt/GWPrefixesQuery=SELECT .../<newline>
Default: <tt>N/A</tt>
<p>
Define an SQL query used to retrieve gateway prefixes from the database 
for <tt/[RasSrv::GWPrefixes]/ section . The query is parametrized 
- that means parameter replacement is made before each query
is executed. Parameter placeholders are denoted by <bf/%1/, <bf/%2/, ... 
strings. Specify %% to embed a percent character before a digit into string 
(like <bf/%%1/), specify <bf/%{1}/ to allow expansion inside complex expressions 
like <bf/%{1}123/. For <tt/GWPrefixesQuery/ only one parameter is defined:
<itemize>
<item><tt/%1/ - the gatekeeper identifier
</itemize>
It is expected that the query returns zero or more rows of data,
with each row consisting of two columns:
<itemize>
<item><tt/column at index 0/ - gateway alias
<item><tt/column at index 1/ - gateway prefixes (comma separated)
</itemize>
<p>
Sample query strings:
<tscreen><verb>
GWPrefixesQuery=SELECT gwalias, gwpfx FROM gwprefix WHERE gk = '%1'
</verb></tscreen>

</itemize>