Bug#629872: asterisk: res_config_pgsql complains of missing fields on inheritated tables
David van Laatum
david.vanlaatum at valex.com.au
Thu Jun 9 03:52:48 UTC 2011
Package: asterisk
Version: 1:1.6.2.9-1~bpo50+3
Severity: normal
Originally iax_adelaide was an inheritated table and it was complaining of the missing fields. Looks like its using the sql
SELECT a.attname, t.typname, a.attlen, a.attnotnull, d.adsrc, a.atttypmod FROM (((pg_catalog.pg_class c INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace AND c.relname = 'iax' AND n.nspname = current_schema()) INNER JOIN pg_catalog.pg_attribute a ON (NOT a.attisdropped) AND a.attnum > 0 AND a.attrelid = c.oid) INNER JOIN pg_catalog.pg_type t ON t.oid = a.atttypid) LEFT OUTER JOIN pg_attrdef d ON a.atthasdef AND d.adrelid = a.attrelid AND d.adnum = a.attnum ORDER BY n.nspname, c.relname, attnum
to get the list of fields which dosn't work with inherited tables but Im still getting the following errors/warnings after making iax_adelaide not inherited, messages and table structure follows.
[Jun 9 13:03:48] WARNING[29359]: res_config_pgsql.c:1184 require_pgsql: Table iax_Adelaide requires a column 'name' of size '10', but no such column exists.
[Jun 9 13:03:48] WARNING[29359]: res_config_pgsql.c:1184 require_pgsql: Table iax_Adelaide requires a column 'ipaddr' of size '15', but no such column exists.
[Jun 9 13:03:48] WARNING[29359]: res_config_pgsql.c:1184 require_pgsql: Table iax_Adelaide requires a column 'port' of size '5', but no such column exists.
[Jun 9 13:03:48] WARNING[29359]: res_config_pgsql.c:1184 require_pgsql: Table iax_Adelaide requires a column 'regseconds' of size '6', but no such column exists.
[Jun 9 13:05:20] ERROR[27741]: res_config_pgsql.c:618 update_pgsql: PostgreSQL RealTime: Updating on column 'ipaddr', but that column does not exist within the table 'iax_Adelaide'!
Table "public.iax_adelaide"
Column | Type | Modifiers
------------------+------------------------+-----------------------------------------------
name | character varying(10) | not null
username | character varying(30) |
type | character varying(6) | not null
secret | character varying(50) |
md5secret | character varying(32) |
dbsecret | character varying(100) |
transfer | character varying(10) | default 'no'::character varying
inkeys | character varying(100) |
outkeys | character varying(100) |
auth | character varying(100) | default 'rsa'::character varying
accountcode | character varying(100) |
amaflags | character varying(100) |
callerid | character varying(100) |
context | character varying(100) | not null default 'default'::character varying
defaultip | character varying(15) |
host | character varying(31) | not null default 'dynamic'::character varying
language | character(5) |
mailbox | character varying(50) |
deny | character varying(95) |
permit | character varying(95) |
qualify | character varying(4) | default 'yes'::character varying
disallow | character varying(100) |
allow | character varying(100) |
ipaddr | character(15) |
port | integer |
regseconds | integer | default 0
trunk | character varying(3) | not null default 'no'::character varying
sourceaddress | character varying(32) |
regexten | character varying(8) |
jitterbuffer | character varying(8) | not null default 'no'::character varying
requirecalltoken | character varying(8) | not null default 'no'::character varying
-- System Information:
Debian Release: 5.0.8
APT prefers oldstable
APT policy: (500, 'oldstable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-2-amd64 (SMP w/16 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages asterisk depends on:
ii adduser 3.110 add and remove users and groups
ii asterisk-config 1:1.6.2.9-1~bpo50+3 Configuration files for Asterisk
ii asterisk-sounds-ma 1:1.6.2.9-1~bpo50+3 Core Sound files for Asterisk (Eng
ii dahdi 1:2.2.1.1-1~bpo50+1 utilities for using the DAHDI kern
ii libasound2 1.0.16-2 ALSA library
ii libc-client2007b 7:2007b~dfsg-4+lenny3 c-client library for mail protocol
ii libc6 2.7-18lenny7 GNU C Library: Shared libraries
ii libcap2 2.11-2 support for getting/setting POSIX.
ii libcurl3 7.18.2-8lenny4 Multi-protocol file transfer libra
ii libgcc1 1:4.3.2-1.1 GCC support library
ii libglib2.0-0 2.16.6-3 The GLib library of C routines
ii libgmime-2.0-2a 2.2.22-2+lenny2 MIME library
ii libgsm1 1.0.12-1 Shared libraries for GSM speech co
ii libiksemel3 1.2-4 C library for the Jabber IM platfo
ii libldap-2.4-2 2.4.11-1+lenny2 OpenLDAP libraries
ii liblua5.1-0 5.1.3-1 Simple, extensible, embeddable pro
ii libncurses5 5.7+20081213-1 shared libraries for terminal hand
ii libnewt0.52 0.52.2-11.3+lenny1 Not Erik's Windowing Toolkit - tex
ii libogg0 1.1.3-4 Ogg Bitstream Library
ii libopenais2 0.83-1 Standards-based cluster framework
ii libpopt0 1.14-4 lib for parsing cmdline parameters
ii libpq5 9.0.1-1~bpo50+1 PostgreSQL C client library
ii libpri1.4 1.4.11.3-1~bpo50+1 Primary Rate ISDN specification li
ii libradiusclient-ng 0.5.5-1 Enhanced RADIUS client library
ii libsdl1.2debian 1.2.13-2 Simple DirectMedia Layer
ii libsnmp15 5.4.1~dfsg-12 SNMP (Simple Network Management Pr
ii libspandsp1 0.0.5~pre4-1 Telephony signal processing librar
ii libspeex1 1.2~rc1-1 The Speex codec runtime library
ii libspeexdsp1 1.2~rc1-1 The Speex extended runtime library
ii libsqlite0 2.8.17-4 SQLite shared library
ii libssl0.9.8 0.9.8g-15+lenny11 SSL shared libraries
ii libstdc++6 4.3.2-1.1 The GNU Standard C++ Library v3
ii libsybdb5 0.82-4 libraries for connecting to MS SQL
ii libtiff4 3.8.2-11.4 Tag Image File Format (TIFF) libra
ii libtonezone2.0 1:2.2.1.1-1~bpo50+1 tonezone library (runtime)
ii libvorbis0a 1.2.0.dfsg-3.1+lenny1 The Vorbis General Audio Compressi
ii libvorbisenc2 1.2.0.dfsg-3.1+lenny1 The Vorbis General Audio Compressi
ii libvpb0 4.2.38.1-1 Voicetronix telephony hardware use
ii libx11-6 2:1.1.5-2 X11 client-side library
ii libxml2 2.6.32.dfsg-5+lenny4 GNOME XML library
ii unixodbc 2.2.11-16 ODBC tools libraries
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
Versions of packages asterisk recommends:
ii sox 14.0.1-2+b1 Swiss army knife of sound processi
Versions of packages asterisk suggests:
pn asterisk-dev <none> (no description available)
pn asterisk-doc <none> (no description available)
pn asterisk-h323 <none> (no description available)
-- no debconf information
More information about the Pkg-voip-maintainers
mailing list