[asterisk-bugs] [Asterisk 0018305]: asterisk cannot find columns in pgsql realtime database
Asterisk Bug Tracker
noreply at bugs.digium.com
Sun Nov 14 22:59:09 CST 2010
The following issue has been SUBMITTED.
======================================================================
https://issues.asterisk.org/view.php?id=18305
======================================================================
Reported By: drookie
Assigned To:
======================================================================
Project: Asterisk
Issue ID: 18305
Category: Resources/res_config_pgsql
Reproducibility: sometimes
Severity: major
Priority: normal
Status: new
Asterisk Version: 1.6.2.11
JIRA:
Regression: No
Reviewboard Link:
SVN Branch (only for SVN checkouts, not tarball releases): N/A
SVN Revision (number only!):
Request Review:
======================================================================
Date Submitted: 2010-11-14 22:59 CST
Last Modified: 2010-11-14 22:59 CST
======================================================================
Summary: asterisk cannot find columns in pgsql realtime
database
Description:
Due to memory leak in chan_sip.c I restart asterisk once in a week.
Sometimes (not always) asterisk cannot find columns in the pgsql realtime
database.
It complains in it's log like this:
Nov 14 04:00:31 asterisk-omega asterisk[52970]: NOTICE[52970]:
config.c:1961 in ast_config_engine_register: Registered Config Engine
pgsql
Nov 14 04:00:31 asterisk-omega asterisk[52970]: NOTICE[52970]: cdr.c:1484
in do_reload: CDR simple logging enabled.
Nov 14 04:00:31 asterisk-omega asterisk[52970]: NOTICE[52970]:
loader.c:1060 in load_modules: 177 modules will be loaded.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: NOTICE[52970]:
res_smdi.c:1360 in load_module: No SMDI interfaces are available to listen
on, not starting SMDI listener.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: rc_read_config: can't open
/etc/radiusclient-ng/radiusclient.conf: No such file or directory
Nov 14 04:00:32 asterisk-omega asterisk[52970]: NOTICE[52970]:
cdr_radius.c:252 in load_module: Cannot load radiusclient-ng configuration
file /etc/radiusclient-ng/radiusclient.conf.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: NOTICE[52970]:
config.c:1961 in ast_config_engine_register: Registered Config Engine curl
Nov 14 04:00:32 asterisk-omega asterisk[52970]: NOTICE[52970]:
chan_sip.c:24104 in build_peer: The 'username' field for sip peers has been
deprecated in favor of the term 'defaultuser'
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'name' of size '10', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'ipaddr' of size '15', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'port' of size '5', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'regseconds' of size '11', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'defaultuser' of size '10', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'fullcontact' of size '35', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'regserver' of size '20', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'useragent' of size '20', but no such column exists.
Nov 14 04:00:32 asterisk-omega asterisk[52970]: WARNING[52970]:
res_config_pgsql.c:1207 in require_pgsql: Table sip requires a column
'lastms' of size '11', but no such column exists.
All these columns do exist in my sip realtime table (however, some of them
are longer than asterisk expects), and after reload asterisk always can
find 'em.
The 'defaultuser' column also exists, and no column 'usernem' exists, but
asterisk keeps complaining about it.
My realtime sip table:
Column | Type | Modifiers
------------------+------------------------+--------------------------------------------------
name | character varying(80) |
host | character varying(31) |
nat | character varying(5) |
type | character varying(255) |
accountcode | character varying(20) |
amaflags | character varying(13) |
callgroup | character varying(10) |
callerid | character varying(80) |
cancallforward | character(3) |
canreinvite | character(3) |
context | character varying(80) |
defaultip | character varying(15) |
dtmfmode | character varying(7) |
fromuser | character varying(80) |
fromdomain | character varying(80) |
insecure | character varying(4) |
language | character(2) |
mailbox | character varying(50) |
md5secret | character varying(80) |
deny | character varying(95) |
permit | character varying(95) |
mask | character varying(95) |
musiconhold | character varying(100) |
pickupgroup | character varying(10) |
qualify | character(3) |
regexten | character varying(80) |
restrictcid | character(3) |
rtptimeout | character(3) |
rtpholdtimeout | character(3) |
secret | character varying(80) |
setvar | character varying(100) |
disallow | character varying(100) |
allow | character varying(100) |
fullcontact | character varying(80) |
ipaddr | character varying(15) |
port | integer |
regserver | character varying(100) |
regseconds | integer |
defaultuser | character varying(80) | not null
id | integer | not null default
nextval('sip_id_seq'::regclass)
lastms | character varying(20) | default NULL::character
varying
useragent | character varying(256) |
ignoresdpversion | character varying(3) | default 'no'::character
varying
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
2010-11-14 22:59 drookie New Issue
2010-11-14 22:59 drookie Asterisk Version => 1.6.2.11
2010-11-14 22:59 drookie Regression => No
2010-11-14 22:59 drookie SVN Branch (only for SVN checkouts, not tarball
releases) => N/A
======================================================================
More information about the asterisk-bugs
mailing list