Daniel-Constantin Mierla
65d4dae702
db_postgres: memset vars to 0 to avoid using invalid values inside db_postgres_new_connection()
|
%!s(int64=10) %!d(string=hai) anos | |
|---|---|---|
| .. | ||
| doc | %!s(int64=10) %!d(string=hai) anos | |
| Makefile | %!s(int64=10) %!d(string=hai) anos | |
| README | %!s(int64=10) %!d(string=hai) anos | |
| km_db_postgres.c | %!s(int64=11) %!d(string=hai) anos | |
| km_db_postgres.h | %!s(int64=11) %!d(string=hai) anos | |
| km_dbase.c | %!s(int64=10) %!d(string=hai) anos | |
| km_dbase.h | %!s(int64=11) %!d(string=hai) anos | |
| km_pg_con.c | %!s(int64=10) %!d(string=hai) anos | |
| km_pg_con.h | %!s(int64=11) %!d(string=hai) anos | |
| km_pg_type.h | %!s(int64=11) %!d(string=hai) anos | |
| km_res.c | %!s(int64=11) %!d(string=hai) anos | |
| km_res.h | %!s(int64=11) %!d(string=hai) anos | |
| km_val.c | %!s(int64=11) %!d(string=hai) anos | |
| km_val.h | %!s(int64=11) %!d(string=hai) anos | |
| pg_cmd.c | %!s(int64=10) %!d(string=hai) anos | |
| pg_cmd.h | %!s(int64=14) %!d(string=hai) anos | |
| pg_con.c | %!s(int64=10) %!d(string=hai) anos | |
| pg_con.h | %!s(int64=16) %!d(string=hai) anos | |
| pg_fld.c | %!s(int64=12) %!d(string=hai) anos | |
| pg_fld.h | %!s(int64=12) %!d(string=hai) anos | |
| pg_mod.c | %!s(int64=10) %!d(string=hai) anos | |
| pg_mod.h | %!s(int64=10) %!d(string=hai) anos | |
| pg_oid.c | %!s(int64=16) %!d(string=hai) anos | |
| pg_oid.h | %!s(int64=17) %!d(string=hai) anos | |
| pg_res.c | %!s(int64=16) %!d(string=hai) anos | |
| pg_res.h | %!s(int64=16) %!d(string=hai) anos | |
| pg_sql.c | %!s(int64=16) %!d(string=hai) anos | |
| pg_sql.h | %!s(int64=16) %!d(string=hai) anos | |
| pg_uri.c | %!s(int64=11) %!d(string=hai) anos | |
| pg_uri.h | %!s(int64=16) %!d(string=hai) anos | |
README
postgres Module
Greg Fausak
August.net
Edited by
Greg Fausak
Copyright © 2003 Greg Fausak
__________________________________________________________________
Table of Contents
1. Admin Guide
1. Overview
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
4. Functions
List of Examples
1.1. Set retries parameter
1.2. Set timeout parameter
1.3. Set tcp_keepalive parameter
Chapter 1. Admin Guide
Table of Contents
1. Overview
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
4. Functions
1. Overview
The module is an implementation of the internal DB API v1 and v2
connector for PostgreSQL server. It has support for reconnecting when
the connection is broken.
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
2.1. Kamailio Modules
The following modules must be loaded before this module:
* No dependencies on other Kamailio modules.
2.2. External Libraries or Applications
The following libraries or applications must be installed before
running Kamailio with this module loaded:
* PostgreSQL library - e.g., libpq5.
* PostgreSQL devel library - to compile the module (e.g., libpq-dev).
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
3.1. retries (integer)
How many retries to attept to reconnect if connection to Postgres
server becomes broken.
Default value is 2 (that means three attepts to submit the query, first
will triger the connection error and two more (the value of this
parameter) after resetting the connection).
Example 1.1. Set retries parameter
...
modparam("db_postgres", "retries", 3)
...
3.2. timeout (integer)
Setting this variable to any value larger than zero (which is the
default value) enables both a connection timeout and a query timeout.
If a connection attempt or a query takes longer than this many seconds,
the operation will be aborted and an error will be returned.
Note that this timeout is applied to each underlying operation (i.e.
for each connection attempt), so depending on circumstances and on the
value of the “retries” variable, a single query from the SIP proxy's
point of view can take longer than the “timeout”.
Example 1.2. Set timeout parameter
...
modparam("db_postgres", "timeout", 10)
...
3.3. tcp_keepalive (integer)
Enable the TCP keepalive timer and set the number of seconds the
connection must be idle before to start sending keepalive packets.
Defaults to zero, which disables TCP keepalive packets.
Only supported on platforms which understand and support the
“TCP_KEEPIDLE” socket option.
Example 1.3. Set tcp_keepalive parameter
...
modparam("db_postgres", "tcp_keepalive", 600)
...
4. Functions
NONE
Greg Fausak
August.net
Edited by
Greg Fausak
Copyright © 2003 Greg Fausak
__________________________________________________________________
Table of Contents
1. Admin Guide
1. Overview
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
4. Functions
List of Examples
1.1. Set retries parameter
1.2. Set timeout parameter
1.3. Set tcp_keepalive parameter
Chapter 1. Admin Guide
Table of Contents
1. Overview
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
4. Functions
1. Overview
The module is an implementation of the internal DB API v1 and v2
connector for PostgreSQL server. It has support for reconnecting when
the connection is broken.
2. Dependencies
2.1. Kamailio Modules
2.2. External Libraries or Applications
2.1. Kamailio Modules
The following modules must be loaded before this module:
* No dependencies on other Kamailio modules.
2.2. External Libraries or Applications
The following libraries or applications must be installed before
running Kamailio with this module loaded:
* PostgreSQL library - e.g., libpq5.
* PostgreSQL devel library - to compile the module (e.g., libpq-dev).
3. Parameters
3.1. retries (integer)
3.2. timeout (integer)
3.3. tcp_keepalive (integer)
3.1. retries (integer)
How many retries to attept to reconnect if connection to Postgres
server becomes broken.
Default value is 2 (that means three attepts to submit the query, first
will triger the connection error and two more (the value of this
parameter) after resetting the connection).
Example 1.1. Set retries parameter
...
modparam("db_postgres", "retries", 3)
...
3.2. timeout (integer)
Setting this variable to any value larger than zero (which is the
default value) enables both a connection timeout and a query timeout.
If a connection attempt or a query takes longer than this many seconds,
the operation will be aborted and an error will be returned.
Note that this timeout is applied to each underlying operation (i.e.
for each connection attempt), so depending on circumstances and on the
value of the “retries” variable, a single query from the SIP proxy's
point of view can take longer than the “timeout”.
Example 1.2. Set timeout parameter
...
modparam("db_postgres", "timeout", 10)
...
3.3. tcp_keepalive (integer)
Enable the TCP keepalive timer and set the number of seconds the
connection must be idle before to start sending keepalive packets.
Defaults to zero, which disables TCP keepalive packets.
Only supported on platforms which understand and support the
“TCP_KEEPIDLE” socket option.
Example 1.3. Set tcp_keepalive parameter
...
modparam("db_postgres", "tcp_keepalive", 600)
...
4. Functions
NONE