[asterisk-bugs] [JIRA] (ASTERISK-16956) asterisk cannot find columns in pgsql realtime database
Sean Bright (JIRA)
noreply at issues.asterisk.org
Tue Feb 28 12:27:10 CST 2017
[ https://issues.asterisk.org/jira/browse/ASTERISK-16956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Bright closed ASTERISK-16956.
----------------------------------
Resolution: Cannot Reproduce
The best I can determine from the age of this bug is that reporter was running 1.6.2.13. The code in {{res_config_pgsql}} has changed significantly in the intervening 7 years. If you are able to reproduce on Asterisk 13 GIT or Asterisk 13.15 once released, please re-open.
> asterisk cannot find columns in pgsql realtime database
> -------------------------------------------------------
>
> Key: ASTERISK-16956
> URL: https://issues.asterisk.org/jira/browse/ASTERISK-16956
> Project: Asterisk
> Issue Type: Bug
> Components: Resources/res_config_pgsql
> Reporter: Eugene M. Zheganin
> Assignee: Sean Bright
> Severity: Minor
>
> 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)
More information about the asterisk-bugs
mailing list