davlefou
06/03/2013, 22h34
J'ai passé mon pbx du mode fichier classique qui marchait bien à temps real, c'est a dire avec des bases. J'ai choisi postgresql en adaptant les version mysql et en prenant les infos trouvé à diverse endroit. Cela marche sauf qu'il semble oublier les clients rapidement et ne passe plus les appels.
Voici mes tables:
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: iax_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE TABLE iax_conf (
id integer NOT NULL,
name character varying(80) DEFAULT ''::character varying NOT NULL,
defaultuser character varying(80) DEFAULT ''::character varying NOT NULL,
type character varying DEFAULT 'friend'::character varying NOT NULL,
secret character varying(80),
md5secret character varying(80),
dbsecret character varying(100),
notransfer character varying(10),
inkeys character varying(100),
outkey character varying(100),
auth character varying(100),
accountcode character varying(20),
amaflags character varying(7),
callerid character varying(80),
context character varying(80),
trunk character varying(3),
defaultip character varying(15),
dtmfmode character varying(7),
fromuser character varying(80),
fromdomain character varying(80),
host character varying(32) DEFAULT 'dynamic'::character varying NOT NULL,
language character varying(2) DEFAULT 'fr'::character varying NOT NULL,
mailbox character varying(50),
deny character varying(95),
permit character varying(95) DEFAULT '0.0.0.0/0.0.0.0'::character varying,
qualify character varying(4),
disallow character varying(100) DEFAULT 'all'::character varying,
allow character varying(100) DEFAULT 'g729;ulaw;alaw;gsm;'::character varying,
ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,
port character varying(5) DEFAULT ''::character varying NOT NULL,
commentaire character varying(80),
regseconds bigint DEFAULT (0)::bigint NOT NULL,
requirecalltoken character varying(10) DEFAULT 'auto'::bpchar
);
ALTER TABLE public.iax_conf OWNER TO asteriskrt;
--
-- Name: iax_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: asteriskrt
--
CREATE SEQUENCE iax_conf_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.iax_conf_id_seq OWNER TO asteriskrt;
--
-- Name: iax_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: asteriskrt
--
ALTER SEQUENCE iax_conf_id_seq OWNED BY iax_conf.id;
--
-- Name: sip_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE TABLE sip_conf (
id integer NOT NULL,
name character varying(80) DEFAULT ''::character varying NOT NULL,
accountcode character varying(20),
amaflags character varying(7),
callgroup character varying(10),
callerid character varying(80),
canreinvite character varying(3) DEFAULT 'yes'::character varying,
context character varying(80),
defaultip character varying(15),
dtmfmode character varying(7),
fromuser character varying(80),
fromdomain character varying(80),
host character varying(32) DEFAULT 'dynamic'::character varying NOT NULL,
insecure character varying(40),
language character varying(2) DEFAULT 'fr'::character varying NOT NULL,
mailbox character varying(50),
md5secret character varying(80),
nat character varying(5) DEFAULT 'no'::character varying NOT NULL,
permit character varying(95),
deny character varying(95),
mask character varying(95),
pickupgroup character varying(10),
port character varying(5) DEFAULT ''::character varying NOT NULL,
qualify character varying(3),
restrictcid character varying(1),
rtptimeout character varying(3),
rtpholdtimeout character varying(3),
secret character varying(80),
type character varying DEFAULT 'friend'::character varying NOT NULL,
defaultuser character varying(80) DEFAULT ''::character varying NOT NULL,
disallow character varying(100) DEFAULT 'all'::character varying,
allow character varying(100) DEFAULT 'g729;ulaw;alaw'::character varying,
musiconhold character varying(100),
regserver character varying(100) DEFAULT NULL::character varying,
regseconds bigint DEFAULT (0)::bigint NOT NULL,
lastms integer DEFAULT 0 NOT NULL,
ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,
regexten character varying(80) DEFAULT ''::character varying NOT NULL,
useragent character varying(20) DEFAULT NULL::character varying,
commentaire character varying(80),
cancallforward character varying(3) DEFAULT 'yes'::character varying,
fullcontact character varying(255) DEFAULT 'auto'::bpchar
);
ALTER TABLE public.sip_conf OWNER TO asteriskrt;
--
-- Name: sip_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: asteriskrt
--
CREATE SEQUENCE sip_conf_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.sip_conf_id_seq OWNER TO asteriskrt;
--
-- Name: sip_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: asteriskrt
--
ALTER SEQUENCE sip_conf_id_seq OWNED BY sip_conf.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY iax_conf ALTER COLUMN id SET DEFAULT nextval('iax_conf_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY sip_conf ALTER COLUMN id SET DEFAULT nextval('sip_conf_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY sipregs_conf ALTER COLUMN id SET DEFAULT nextval('sipregs_conf_id_seq'::regclass);
--
-- Name: iax_conf_pkey; Type: CONSTRAINT; Schema: public; Owner: asteriskrt; Tablespace:
--
ALTER TABLE ONLY iax_conf
ADD CONSTRAINT iax_conf_pkey PRIMARY KEY (id);
--
-- Name: name; Type: INDEX; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE UNIQUE INDEX name ON iax_conf USING btree (name);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
--
-- PostgreSQL database dump complete
--
et un exemple d'entré :
En sip :
COPY sip_conf (id, name, accountcode, amaflags, callgroup, callerid, canreinvite, context, defaultip, dtmfmode, fromuser, fromdomain, host, insecure, language, mailbox, md5secret, nat, permit, deny, mask, pickupgroup, port, qualify, restrictcid, rtptimeout, rtpholdtimeout, secret, type, defaultuser, disallow, allow, musiconhold, regserver, regseconds, lastms, ipaddr, regexten, useragent, commentaire, cancallforward, fullcontact) FROM stdin;
1 david rev \N \N David <33999991112> yes direction \N \N \N \N dynamic \N fr mail@domaine.com \N no 0.0.0.0/0.0.0.0 \N \N \N 26167 \N \N \N \N passwd friend david all ulaw;alaw;gsm; \N \N 1357513692 0 192.168.0.170 SFLphone \N yes auto
En iax:
COPY iax_conf (id, name, defaultuser, type, secret, md5secret, dbsecret, notransfer, inkeys, outkey, auth, accountcode, amaflags, callerid, context, trunk, defaultip, dtmfmode, fromuser, fromdomain, host, language, mailbox, deny, permit, qualify, disallow, allow, ipaddr, port, commentaire, regseconds, requirecalltoken) FROM stdin;
16 david david friend passwd \N \N \N \N \N \N rev \N David <33999991112> direction \N \N \N \N \N dynamic fr mail@domaine.com \N 0.0.0.0/0.0.0.0 \N all ulaw;alaw;gsm; 197.15.50.19 1152 \N 0 auto
et souvent j'ai ce message :
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'IAX2' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'IAX2' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13433 __set_address_from_contact: Invalid contact uri auto (missing sip: or sips:), attempting to use anyway
[2013-03-06 21:19:46] ERROR[3888]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("auto", "(null)", ...): Name or service not known
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13451 __set_address_from_contact: Invalid host name in Contact: (can't resolve in DNS) : 'auto'
[2013-03-06 21:19:46] WARNING[3888]: res_config_pgsql.c:720 update_pgsql: PostgreSQL RealTime: Failed to query database. Check debug for more info.
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13433 __set_address_from_contact: Invalid contact uri auto (missing sip: or sips:), attempting to use anyway
[2013-03-06 21:19:46] ERROR[3888]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("auto", "(null)", ...): Name or service not known
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13451 __set_address_from_contact: Invalid host name in Contact: (can't resolve in DNS) : 'auto'
[2013-03-06 21:19:46] WARNING[3888]: res_config_pgsql.c:720 update_pgsql: PostgreSQL RealTime: Failed to query database. Check debug for more info.
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Unknown)
L'enregistrement des lignes ne semble pas tenir et donc il ne trouve les client pour passer l'appels. Auriez vous un idée du probléme?
Voici mes tables:
--
-- PostgreSQL database dump
--
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: iax_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE TABLE iax_conf (
id integer NOT NULL,
name character varying(80) DEFAULT ''::character varying NOT NULL,
defaultuser character varying(80) DEFAULT ''::character varying NOT NULL,
type character varying DEFAULT 'friend'::character varying NOT NULL,
secret character varying(80),
md5secret character varying(80),
dbsecret character varying(100),
notransfer character varying(10),
inkeys character varying(100),
outkey character varying(100),
auth character varying(100),
accountcode character varying(20),
amaflags character varying(7),
callerid character varying(80),
context character varying(80),
trunk character varying(3),
defaultip character varying(15),
dtmfmode character varying(7),
fromuser character varying(80),
fromdomain character varying(80),
host character varying(32) DEFAULT 'dynamic'::character varying NOT NULL,
language character varying(2) DEFAULT 'fr'::character varying NOT NULL,
mailbox character varying(50),
deny character varying(95),
permit character varying(95) DEFAULT '0.0.0.0/0.0.0.0'::character varying,
qualify character varying(4),
disallow character varying(100) DEFAULT 'all'::character varying,
allow character varying(100) DEFAULT 'g729;ulaw;alaw;gsm;'::character varying,
ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,
port character varying(5) DEFAULT ''::character varying NOT NULL,
commentaire character varying(80),
regseconds bigint DEFAULT (0)::bigint NOT NULL,
requirecalltoken character varying(10) DEFAULT 'auto'::bpchar
);
ALTER TABLE public.iax_conf OWNER TO asteriskrt;
--
-- Name: iax_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: asteriskrt
--
CREATE SEQUENCE iax_conf_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.iax_conf_id_seq OWNER TO asteriskrt;
--
-- Name: iax_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: asteriskrt
--
ALTER SEQUENCE iax_conf_id_seq OWNED BY iax_conf.id;
--
-- Name: sip_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE TABLE sip_conf (
id integer NOT NULL,
name character varying(80) DEFAULT ''::character varying NOT NULL,
accountcode character varying(20),
amaflags character varying(7),
callgroup character varying(10),
callerid character varying(80),
canreinvite character varying(3) DEFAULT 'yes'::character varying,
context character varying(80),
defaultip character varying(15),
dtmfmode character varying(7),
fromuser character varying(80),
fromdomain character varying(80),
host character varying(32) DEFAULT 'dynamic'::character varying NOT NULL,
insecure character varying(40),
language character varying(2) DEFAULT 'fr'::character varying NOT NULL,
mailbox character varying(50),
md5secret character varying(80),
nat character varying(5) DEFAULT 'no'::character varying NOT NULL,
permit character varying(95),
deny character varying(95),
mask character varying(95),
pickupgroup character varying(10),
port character varying(5) DEFAULT ''::character varying NOT NULL,
qualify character varying(3),
restrictcid character varying(1),
rtptimeout character varying(3),
rtpholdtimeout character varying(3),
secret character varying(80),
type character varying DEFAULT 'friend'::character varying NOT NULL,
defaultuser character varying(80) DEFAULT ''::character varying NOT NULL,
disallow character varying(100) DEFAULT 'all'::character varying,
allow character varying(100) DEFAULT 'g729;ulaw;alaw'::character varying,
musiconhold character varying(100),
regserver character varying(100) DEFAULT NULL::character varying,
regseconds bigint DEFAULT (0)::bigint NOT NULL,
lastms integer DEFAULT 0 NOT NULL,
ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,
regexten character varying(80) DEFAULT ''::character varying NOT NULL,
useragent character varying(20) DEFAULT NULL::character varying,
commentaire character varying(80),
cancallforward character varying(3) DEFAULT 'yes'::character varying,
fullcontact character varying(255) DEFAULT 'auto'::bpchar
);
ALTER TABLE public.sip_conf OWNER TO asteriskrt;
--
-- Name: sip_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: asteriskrt
--
CREATE SEQUENCE sip_conf_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.sip_conf_id_seq OWNER TO asteriskrt;
--
-- Name: sip_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: asteriskrt
--
ALTER SEQUENCE sip_conf_id_seq OWNED BY sip_conf.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY iax_conf ALTER COLUMN id SET DEFAULT nextval('iax_conf_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY sip_conf ALTER COLUMN id SET DEFAULT nextval('sip_conf_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: asteriskrt
--
ALTER TABLE ONLY sipregs_conf ALTER COLUMN id SET DEFAULT nextval('sipregs_conf_id_seq'::regclass);
--
-- Name: iax_conf_pkey; Type: CONSTRAINT; Schema: public; Owner: asteriskrt; Tablespace:
--
ALTER TABLE ONLY iax_conf
ADD CONSTRAINT iax_conf_pkey PRIMARY KEY (id);
--
-- Name: name; Type: INDEX; Schema: public; Owner: asteriskrt; Tablespace:
--
CREATE UNIQUE INDEX name ON iax_conf USING btree (name);
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
--
-- PostgreSQL database dump complete
--
et un exemple d'entré :
En sip :
COPY sip_conf (id, name, accountcode, amaflags, callgroup, callerid, canreinvite, context, defaultip, dtmfmode, fromuser, fromdomain, host, insecure, language, mailbox, md5secret, nat, permit, deny, mask, pickupgroup, port, qualify, restrictcid, rtptimeout, rtpholdtimeout, secret, type, defaultuser, disallow, allow, musiconhold, regserver, regseconds, lastms, ipaddr, regexten, useragent, commentaire, cancallforward, fullcontact) FROM stdin;
1 david rev \N \N David <33999991112> yes direction \N \N \N \N dynamic \N fr mail@domaine.com \N no 0.0.0.0/0.0.0.0 \N \N \N 26167 \N \N \N \N passwd friend david all ulaw;alaw;gsm; \N \N 1357513692 0 192.168.0.170 SFLphone \N yes auto
En iax:
COPY iax_conf (id, name, defaultuser, type, secret, md5secret, dbsecret, notransfer, inkeys, outkey, auth, accountcode, amaflags, callerid, context, trunk, defaultip, dtmfmode, fromuser, fromdomain, host, language, mailbox, deny, permit, qualify, disallow, allow, ipaddr, port, commentaire, regseconds, requirecalltoken) FROM stdin;
16 david david friend passwd \N \N \N \N \N \N rev \N David <33999991112> direction \N \N \N \N \N dynamic fr mail@domaine.com \N 0.0.0.0/0.0.0.0 \N all ulaw;alaw;gsm; 197.15.50.19 1152 \N 0 auto
et souvent j'ai ce message :
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'IAX2' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'IAX2' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13433 __set_address_from_contact: Invalid contact uri auto (missing sip: or sips:), attempting to use anyway
[2013-03-06 21:19:46] ERROR[3888]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("auto", "(null)", ...): Name or service not known
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13451 __set_address_from_contact: Invalid host name in Contact: (can't resolve in DNS) : 'auto'
[2013-03-06 21:19:46] WARNING[3888]: res_config_pgsql.c:720 update_pgsql: PostgreSQL RealTime: Failed to query database. Check debug for more info.
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Unknown)
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13433 __set_address_from_contact: Invalid contact uri auto (missing sip: or sips:), attempting to use anyway
[2013-03-06 21:19:46] ERROR[3888]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("auto", "(null)", ...): Name or service not known
[2013-03-06 21:19:46] WARNING[3888]: chan_sip.c:13451 __set_address_from_contact: Invalid host name in Contact: (can't resolve in DNS) : 'auto'
[2013-03-06 21:19:46] WARNING[3888]: res_config_pgsql.c:720 update_pgsql: PostgreSQL RealTime: Failed to query database. Check debug for more info.
[2013-03-06 21:19:46] WARNING[3888]: app_dial.c:2218 dial_exec_full: Unable to create channel of type 'SIP' (cause 20 - Unknown)
L'enregistrement des lignes ne semble pas tenir et donc il ne trouve les client pour passer l'appels. Auriez vous un idée du probléme?