PDA

Voir la version complète : sipregs ne marche pas!!! S.O.S



davlefou
26/12/2012, 23h10
je suis entrain de passer mon asterisk en realtime, j'utilise postgresql. Pour le moment, l'iax et les sip sont faite, je bloque sur le register qui devrait se faire via la table sipregs. J'ai plusieurs version. Il s'agit de ligne chez ovh, cela marche parfaitement en classique. En realtime, je peux passer des appels pas en recevoir.



--
-- 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: extensions_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--

CREATE TABLE extensions_conf (
id serial NOT NULL,
context character varying(20) DEFAULT ''::character varying NOT NULL,
exten character varying(20) DEFAULT ''::character varying NOT NULL,
priority smallint DEFAULT 0 NOT NULL,
app character varying(20) DEFAULT ''::character varying NOT NULL,
appdata character varying(256)
);


ALTER TABLE public.extensions_conf OWNER TO asteriskrt;

--
-- Name: extensions_conf_id_seq; Type: SEQUENCE; Schema: public; Owner: asteriskrt
--

CREATE SEQUENCE extensions_conf_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;


ALTER TABLE public.extensions_conf_id_seq OWNER TO asteriskrt;

--
-- Name: extensions_conf_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: asteriskrt
--

ALTER SEQUENCE extensions_conf_id_seq OWNED BY extensions_conf.id;


--
-- Name: iax_conf; Type: TABLE; Schema: public; Owner: asteriskrt; Tablespace:
--

CREATE TABLE iax_conf (
id serial 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',
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),
regserver varchar(100) DEFAULT NULL,
regseconds bigint DEFAULT (0)::bigint NOT NULL,
lastms bigint NOT NULL DEFAULT '0',
requirecalltoken character varying(10) DEFAULT 'auto'::bpchar,
CONSTRAINT iax_conf_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
CREATE UNIQUE INDEX "name" ON iax_conf USING btree (name);


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 serial 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 varchar(100) DEFAULT NULL,
regseconds bigint DEFAULT (0)::bigint NOT NULL,
lastms bigint NOT NULL DEFAULT '0',
ipaddr character varying(15) DEFAULT ''::character varying NOT NULL,
regexten character varying(80) DEFAULT ''::character varying NOT NULL,
useragent character varying(20) DEFAULT NULL,
commentaire character varying(80),
cancallforward character varying(3) DEFAULT 'yes'::character varying
);
CREATE UNIQUE INDEX "name" ON sip_conf USING btree (name);

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;


CREATE TABLE sipregs_conf (
id serial NOT NULL,
name varchar(80) NOT NULL DEFAULT '',
fullcontact varchar(80) NOT NULL DEFAULT '',
ipaddr varchar(15) NOT NULL DEFAULT '',
port character varying(5) NOT NULL DEFAULT '0',
username varchar(80) NOT NULL DEFAULT '',
secret character varying(80),
md5secret character varying(80),
regserver varchar(100) DEFAULT NULL,
regseconds integer NOT NULL DEFAULT '0',
CONSTRAINT sipregs_pkey PRIMARY KEY (id)
);

CREATE TABLE sipregs_conf (
id serial NOT NULL,
name varchar(80) NOT NULL DEFAULT '',
fullcontact varchar(80) NOT NULL DEFAULT '',
ipaddr varchar(15) NOT NULL DEFAULT '',
port integer NOT NULL DEFAULT '0',
username varchar(80) NOT NULL DEFAULT '',
regserver varchar(100) DEFAULT NULL,
regseconds integer NOT NULL DEFAULT '0',
CONSTRAINT sipregs_pkey PRIMARY KEY (id)
);

CREATE TABLE sipregs_conf (
id serial NOT NULL,
name varchar(80) NOT NULL DEFAULT '',
defaultuser varchar(80) NOT NULL DEFAULT '',
fullcontact varchar(80) NOT NULL DEFAULT '',
ipaddr varchar(15) NOT NULL DEFAULT '',
port integer NOT NULL DEFAULT '0',
username varchar(80) NOT NULL DEFAULT '',
regserver varchar(100) DEFAULT NULL,
regseconds integer NOT NULL DEFAULT '0',
useragent varchar(80) NOT NULL DEFAULT '',
lastms bigint NOT NULL DEFAULT '0',
CONSTRAINT sipregs_pkey PRIMARY KEY (id)
);


ALTER TABLE public.sipregs_conf OWNER TO asteriskrt;

INSERT INTO sip_conf (name,username,secret,type,dtmfmode,qualify,insecu re,host,context,fromuser,fromdomain,allow,commenta ire) VALUES
('ovh-0033422999666','0033422999666','pass','friend','rf c2833','no','port,invite','sip.ovh.net','ovh-sip','0033422999666','sip.ovh.net','g729;ulaw;alaw ;','')

et

INSERT INTO sipregs_conf (name) VALUES
('ovh-0033422999666');


Je ne vois pas du tout le probléme ni ou avoir un indice pour le résoudre. SOS!!!

therebel23
27/12/2012, 16h30
Bonjour,
peux tu mettre un extrait de la CLI sur un appel entrant ?

davlefou
27/12/2012, 21h00
Bonjour,
les appels sortant fonctionnent, c'est les appels entrant qui ne fonctionne pas. Comme il s'agit de ligne sip, elles doivent être enregistré pour que asterisk recoive l'appels. Donc j'ai rein du tout dans le cli.
Le problème est justement, que les sip ne s'enregistre pas dans les bases de donnés alors que cela marchais dans les fichier de configuration classique.