Freeswitch Install for Postgres Core, Db, Configuration, Dialplan, Directory with Lua Dbh

install postgres & lib

apt-get install postgresql libpq-dev

Install FS

Нажмите, чтобы отобразить

Нажмите, чтобы скрыть

apt-get update && apt-get install -y gnupg2 wget
 
wget -O - https://files.freeswitch.org/repo/deb/freeswitch-1.8/fsstretch-archive-keyring.asc | apt-key add -
echo "deb http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main" > /etc/apt/sources.list.d/freeswitch.list
echo "deb-src http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main" >> /etc/apt/sources.list.d/freeswitch.list
 
apt-get update && apt-get build-dep freeswitch
 
apt-get update && apt-get install -y freeswitch-meta-all

install from source

fs1.8

fs1.8

wget -O - https://files.freeswitch.org/repo/deb/freeswitch-1.8/fsstretch-archive-keyring.asc | apt-key add -
echo "deb http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main" > /etc/apt/sources.list.d/freeswitch.list
echo "deb-src http://files.freeswitch.org/repo/deb/freeswitch-1.8/ stretch main" >> /etc/apt/sources.list.d/freeswitch.list
apt-get update
apt-get build-dep freeswitch
cd /usr/src/
fs1.10
apt update && apt install -yq gnupg2 wget lsb-release &&
wget -O - https://files.freeswitch.org/repo/deb/debian-release/fsstretch-archive-keyring.asc | apt-key add - &&
echo "deb http://files.freeswitch.org/repo/deb/debian-release/ `lsb_release -sc` main" > /etc/apt/sources.list.d/freeswitch.list &&
echo "deb-src http://files.freeswitch.org/repo/deb/debian-release/ `lsb_release -sc` main" >> /etc/apt/sources.list.d/freeswitch.list &&
apt -y update &&
apt -y build-dep freeswitch

fs1.8

fs1.8

git clone https://freeswitch.org/stash/scm/fs/freeswitch.git -bv1.8 freeswitch

git clone https://github.com/signalwire/freeswitch.git -bv1.8 freeswitch
cd freeswitch
./bootstrap.sh -j
./configure --enable-core-pgsql-support
make
make install
fs1.10
cd /usr/src/ &&
git clone https://github.com/signalwire/freeswitch.git -bv1.10 freeswitch &&
cd freeswitch &&
git config pull.rebase true &&
./bootstrap.sh -j &&
./configure --enable-core-pgsql-support &&
make &&
make install
make sounds-install &&
make moh-install &&
make sounds-ru-install &&
useradd freeswitch &&
cd /usr/local/ &&
chown -R freeswitch:freeswitch freeswitch &&
chmod -R g+w freeswitch
cd  /usr/local/bin/ &&
ln -s /usr/local/freeswitch/bin/fs_cli fs_cli &&
cd /usr/bin &&
ln -s /usr/local/freeswitch/bin/freeswitch freeswitch
/etc/systemd/system/multi-user.target.wants/freeswitch.service

change /etc/systemd/system/multi-user.target.wants/freeswitch.service

change /etc/systemd/system/multi-user.target.wants/freeswitch.service

cat >> /lib/systemd/system/freeswitch.service << EOF
[Unit]
Description=freeswitch
Wants=network-online.target
Requires=network.target local-fs.target
After=network.target network-online.target local-fs.target 
After=postgresql-service
 
[Service]
; service
Type=forking
PIDFile=/usr/local/freeswitch/run/freeswitch.pid
Environment="DAEMON_OPTS=-nonat"
Environment="USER=freeswitch"
Environment="GROUP=freeswitch"
EnvironmentFile=-/etc/default/freeswitch
ExecStartPre=/bin/chown -R ${USER}:${GROUP} /usr/local/freeswitch/lib /usr/local/freeswitch/log /usr/local/freeswitch/conf  /usr/local/freeswitch /usr/local/freeswitch/run
ExecStart=/usr/bin/freeswitch -u ${USER} -g ${GROUP} -ncwait ${DAEMON_OPTS}
TimeoutSec=45s
Restart=always
; exec
;User=${USER}
;Group=${GROUP}
LimitCORE=infinity
LimitNOFILE=100000
LimitNPROC=60000
LimitSTACK=250000
LimitRTPRIO=infinity
LimitRTTIME=infinity
IOSchedulingClass=realtime
IOSchedulingPriority=2
CPUSchedulingPolicy=rr
CPUSchedulingPriority=89
UMask=0007
NoNewPrivileges=false
 
[Install]
WantedBy=multi-user.target
 
EOF
add ''posqresql-service'' и ''After'' params
reboot & check
 fs_cli -r

Make lua esl

download src if not done before

cd /usr/src/
git clone https://freeswitch.org/stash/scm/fs/freeswitch.git -bv1.8 freeswitch
cd freeswitch

make ESL

apt-get install lua5.2 
apt-get install liblua5.2-dev
 
;  apt-get install freeswitch-mod-lua
 
;  cd /usr/src/freeswitch
;  ./bootstrap.sh -j
;  ./configure --enable-core-pgsql-support
 
cd /usr/src/freeswitch/libs/esl
make luamod

check

cd /usr/src/freeswitch/libs/esl/lua && ./single_command.lua status

change interpreter if needs
bash: ./single_command.lua: /usr/local/bin/lua: bad interpreter: No such file or directory

# which lua
/usr/bin/lua

Core & db in Postgres

create core db user

useradd  -d/home/fsuser -m fsuser

su to postgres

su - posgres

create user & db

$ createuser fsuser
$ createdb -O fsuser fscore

alter user pass

 psql fscore
alter user fsuser with password 'PASS';

check

 su - fsuser

use db in postgres

/etc/freeswitch/autoload_configs/db.conf.xml

<configuration name="db.conf" description="LIMIT DB Configuration">
  <settings>
    <!--<param name="odbc-dsn" value="dsn:user:pass"/>-->
    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=fscore  user=fsuser password='PASS'"/>
  </settings>
</configuration>

check
fs_cli> fsctl shutdown restart now

   su  - fsuser
$ psql fscore
psql (9.6.11)
TYPE "help" FOR help.
 
fscore=> \dt
          List OF relations
 Schema |    Name    | TYPE  | Owner  
--------+------------+-------+--------
 public | db_data    | TABLE | fsuser
 public | group_data | TABLE | fsuser
 public | limit_data | TABLE | fsuser
(3 ROWS)

switch db in postgres

/etc/freeswitch/autoload_configs/switch.conf.xml

<param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=fscore  user=fsuser password='PASS' options='-c client_min_messages=NOTICE' "/>

core switch tables

core switch tables

fscore=> \dt
                       List of relations
 Schema |                Name                 | Type  | Owner  
--------+-------------------------------------+-------+--------
 public | aliases                             | table | fsuser
 public | calls                               | table | fsuser
 public | channels                            | table | fsuser
 public | complete                            | table | fsuser
 public | db_data                             | table | fsuser
 public | group_data                          | table | fsuser
 public | interfaces                          | table | fsuser
 public | limit_data                          | table | fsuser
 public | nat                                 | table | fsuser
 public | recovery                            | table | fsuser
 public | registrations                       | table | fsuser
 public | sip_authentication                  | table | fsuser
 public | sip_dialogs                         | table | fsuser
 public | sip_presence                        | table | fsuser
 public | sip_registrations                   | table | fsuser
 public | sip_shared_appearance_dialogs       | table | fsuser
 public | sip_shared_appearance_subscriptions | table | fsuser
 public | sip_subscriptions                   | table | fsuser
 public | tasks                               | table | fsuser

Create Lua DBH Storage for Directory, Dialplan, Configs

Import Postgesql database schema

fsdir schema

fsdir schema

fsdir_schema.pgsql
--
-- PostgreSQL database dump
--
 
-- Dumped from database version 9.6.11
-- Dumped by pg_dump version 9.6.11
 
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
 
--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--
 
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
 
 
--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--
 
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
 
 
--
-- Name: agent_status; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.agent_status AS ENUM (
    'Logged Out',
    'Available',
    'Available (On Demand)',
    'On Break'
);
 
 
ALTER TYPE public.agent_status OWNER TO fsuser;
 
--
-- Name: agent_type; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.agent_type AS ENUM (
    'callback',
    'uuid-standby'
);
 
 
ALTER TYPE public.agent_type OWNER TO fsuser;
 
--
-- Name: queue_strategy; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.queue_strategy AS ENUM (
    'ring-all',
    'longest-idle-agent',
    'round-robin',
    'top-down',
    'agent-with-least-talk-time',
    'agent-with-fewest-calls',
    'sequentially-by-agent-order',
    'random',
    'ring-progressively'
);
 
 
ALTER TYPE public.queue_strategy OWNER TO fsuser;
 
SET default_tablespace = '';
 
SET default_with_oids = false;
 
--
-- Name: admin; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.admin (
    id integer NOT NULL,
    username text NOT NULL,
    password text NOT NULL,
    session text
);
 
 
ALTER TABLE public.admin OWNER TO fsuser;
 
--
-- Name: cc_agents; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.cc_agents (
    id integer NOT NULL,
    name character varying,
    type public.agent_type,
    contact character varying NOT NULL,
    status public.agent_status,
    max_no_answer integer DEFAULT 3 NOT NULL,
    wrap_up_time integer DEFAULT 10 NOT NULL,
    reject_delay_time integer DEFAULT 3 NOT NULL,
    busy_delay_time integer DEFAULT 60 NOT NULL,
    no_answer_delay_time integer DEFAULT 5 NOT NULL,
    reserve_agents character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_agents_on_load character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_tiers_on_load character varying DEFAULT 'false'::character varying NOT NULL
);
 
 
ALTER TABLE public.cc_agents OWNER TO fsuser;
 
--
-- Name: cc_agents_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.cc_agents_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.cc_agents_id_seq OWNER TO fsuser;
 
--
-- Name: cc_agents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.cc_agents_id_seq OWNED BY public.cc_agents.id;
 
 
--
-- Name: cc_queues; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.cc_queues (
    id integer NOT NULL,
    name character varying,
    strategy public.queue_strategy,
    moh_sound character varying DEFAULT '$${hold_music}'::character varying NOT NULL,
    record_template character varying,
    time_base_score character varying DEFAULT 'queue'::character varying NOT NULL,
    max_wait_time integer DEFAULT 0 NOT NULL,
    max_wait_time_wna integer DEFAULT 0 NOT NULL,
    max_wait_time_wna_tr integer DEFAULT 5 NOT NULL,
    tier_rules_apply character varying DEFAULT 'false'::character varying NOT NULL,
    tier_rule_wait_second integer DEFAULT 300 NOT NULL,
    tier_rule_wait_ml character varying DEFAULT 'true'::character varying NOT NULL,
    tier_rule_no_agent_no_wait character varying DEFAULT 'false'::character varying NOT NULL,
    discard_abandoned_after integer DEFAULT 60 NOT NULL,
    abandoned_resume_allowed character varying DEFAULT 'false'::character varying NOT NULL,
    ring_progressively_delay integer DEFAULT 60 NOT NULL
);
 
 
ALTER TABLE public.cc_queues OWNER TO fsuser;
 
--
-- Name: cc_queues_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.cc_queues_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.cc_queues_id_seq OWNER TO fsuser;
 
--
-- Name: cc_queues_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.cc_queues_id_seq OWNED BY public.cc_queues.id;
 
 
--
-- Name: cc_settings; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.cc_settings (
    id integer NOT NULL,
    odbc_dsn character varying(1024),
    dbname character varying
);
 
 
ALTER TABLE public.cc_settings OWNER TO fsuser;
 
--
-- Name: cc_tiers; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.cc_tiers (
    id integer NOT NULL,
    agent character varying NOT NULL,
    queue character varying NOT NULL,
    level integer DEFAULT 1 NOT NULL,
    "position" integer DEFAULT 1 NOT NULL
);
 
 
ALTER TABLE public.cc_tiers OWNER TO fsuser;
 
--
-- Name: cc_tiers_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.cc_tiers_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.cc_tiers_id_seq OWNER TO fsuser;
 
--
-- Name: cc_tiers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.cc_tiers_id_seq OWNED BY public.cc_tiers.id;
 
 
--
-- Name: cdr; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.cdr (
    id integer NOT NULL,
    local_ip_v4 inet NOT NULL,
    caller_id_name character varying,
    caller_id_number character varying,
    destination_number character varying NOT NULL,
    context character varying NOT NULL,
    start_stamp timestamp with time zone NOT NULL,
    answer_stamp timestamp with time zone,
    end_stamp timestamp with time zone NOT NULL,
    duration integer NOT NULL,
    billsec integer NOT NULL,
    hangup_cause character varying NOT NULL,
    uuid uuid NOT NULL,
    bleg_uuid uuid,
    accountcode character varying,
    read_codec character varying,
    write_codec character varying,
    sip_hangup_disposition character varying,
    ani character varying,
    endpoint_disposition character varying(32)
);
 
 
ALTER TABLE public.cdr OWNER TO fsuser;
 
--
-- Name: cdr_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.cdr_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.cdr_id_seq OWNER TO fsuser;
 
--
-- Name: cdr_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.cdr_id_seq OWNED BY public.cdr.id;
 
 
--
-- Name: dialplan_xml; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.dialplan_xml (
    id integer NOT NULL,
    dp_domain text,
    dp_context text,
    dp_name text,
    dp_continue text DEFAULT 'false'::text,
    dp_condtype text DEFAULT 'field'::text,
    dp_condvalue text DEFAULT 'destination_number'::text,
    dp_expr text,
    dp_break text DEFAULT 'on-false'::text,
    dp_xml text,
    enabled boolean DEFAULT false
);
 
 
ALTER TABLE public.dialplan_xml OWNER TO fsuser;
 
--
-- Name: dialplan_xml_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.dialplan_xml_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.dialplan_xml_id_seq OWNER TO fsuser;
 
--
-- Name: dialplan_xml_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.dialplan_xml_id_seq OWNED BY public.dialplan_xml.id;
 
 
--
-- Name: directory; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.directory (
    domain character varying(32) NOT NULL,
    id character varying(32) NOT NULL,
    "number-alias" character varying(32) DEFAULT NULL::character varying,
    mailbox character varying(64) DEFAULT NULL::character varying,
    cidr character varying(64) DEFAULT NULL::character varying,
    password character varying(64) DEFAULT NULL::character varying,
    toll_allow character varying(32) DEFAULT NULL::character varying,
    user_context character varying(32) DEFAULT NULL::character varying,
    default_gateway character varying(32) DEFAULT NULL::character varying,
    effective_caller_id_name character varying(512) DEFAULT NULL::character varying,
    effective_caller_id_number character varying(64) DEFAULT NULL::character varying,
    outbound_caller_id_name character varying(512) DEFAULT NULL::character varying,
    outbound_caller_id_number character varying(64) DEFAULT NULL::character varying,
    callgroup character varying(64) DEFAULT NULL::character varying,
    tls character varying(8) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    uservar1 character varying(64) DEFAULT NULL::character varying,
    uservar2 character varying(64) DEFAULT NULL::character varying,
    uservar3 character varying(64) DEFAULT NULL::character varying,
    uservar4 character varying(512) DEFAULT NULL::character varying,
    uservar5 character varying(512) DEFAULT NULL::character varying,
    uservar6 character varying(8) DEFAULT NULL::character varying,
    uservar7 character varying(512) DEFAULT NULL::character varying,
    branch character varying(255) DEFAULT NULL::character varying
);
 
 
ALTER TABLE public.directory OWNER TO fsuser;
 
--
-- Name: distributor; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.distributor (
    id integer NOT NULL,
    list character varying,
    node character varying,
    weight character varying
);
 
 
ALTER TABLE public.distributor OWNER TO fsuser;
 
--
-- Name: distributor_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.distributor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.distributor_id_seq OWNER TO fsuser;
 
--
-- Name: distributor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.distributor_id_seq OWNED BY public.distributor.id;
 
 
--
-- Name: fifo; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.fifo (
    id integer NOT NULL,
    name character varying,
    importance integer DEFAULT 0,
    timeout integer DEFAULT 20,
    simo integer DEFAULT 1,
    lag integer DEFAULT 5,
    member_wait character varying DEFAULT 'nowait'::character varying,
    members character varying
);
 
 
ALTER TABLE public.fifo OWNER TO fsuser;
 
--
-- Name: fifo_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.fifo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.fifo_id_seq OWNER TO fsuser;
 
--
-- Name: fifo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.fifo_id_seq OWNED BY public.fifo.id;
 
 
--
-- Name: gateways; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.gateways (
    id integer NOT NULL,
    profile character varying,
    gw_name character varying,
    type character varying,
    name character varying,
    value character varying,
    enable boolean DEFAULT false NOT NULL,
    active boolean DEFAULT false
);
 
 
ALTER TABLE public.gateways OWNER TO fsuser;
 
--
-- Name: gateways_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.gateways_id_seq
    START WITH 1
    INCREMENT BY 5
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.gateways_id_seq OWNER TO fsuser;
 
--
-- Name: gateways_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.gateways_id_seq OWNED BY public.gateways.id;
 
 
--
-- Name: gw_dummy; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.gw_dummy (
    profile character varying,
    gw_name character varying,
    type character varying,
    name character varying,
    value character varying,
    enable boolean
);
 
 
ALTER TABLE public.gw_dummy OWNER TO fsuser;
 
--
-- Name: incoming_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.incoming_map (
    id character varying(8) NOT NULL,
    did character varying(32) DEFAULT NULL::character varying,
    did_domain character varying(64) DEFAULT '$${domain}'::character varying,
    did_pre_execute character varying(512) DEFAULT 'ALL_TC'::character varying,
    did_app character varying(32) DEFAULT NULL::character varying,
    did_fail character varying(512) DEFAULT NULL::character varying,
    did_timeout character varying(8) DEFAULT NULL::character varying,
    did_data character varying(512) DEFAULT NULL::character varying,
    did_var character varying(512) DEFAULT NULL::character varying,
    did_post_execute character varying(512) DEFAULT 'ALL_HG'::character varying,
    did_branch character varying(64) DEFAULT NULL::character varying,
    did_codec character varying(128) DEFAULT 'PCMA'::character varying
);
 
 
ALTER TABLE public.incoming_map OWNER TO fsuser;
 
--
-- Name: ivr_entry; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.ivr_entry (
    id integer NOT NULL,
    menu_name character varying(32),
    action character varying(32),
    digits character varying(32),
    param character varying
);
 
 
ALTER TABLE public.ivr_entry OWNER TO fsuser;
 
--
-- Name: ivr_entry_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.ivr_entry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.ivr_entry_id_seq OWNER TO fsuser;
 
--
-- Name: ivr_entry_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.ivr_entry_id_seq OWNED BY public.ivr_entry.id;
 
 
--
-- Name: ivr_menus; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.ivr_menus (
    id integer NOT NULL,
    name character varying NOT NULL,
    greet_long character varying(256),
    greet_short character varying(256),
    invalid_sound character varying(256),
    exit_sound character varying(256),
    inter_digit_timeout character varying(4),
    timeout character varying(4),
    confirm_macro character varying(256),
    confirm_key character varying(4),
    confirm_attempts character varying(4),
    max_failures character varying(4),
    max_timeouts character varying(4),
    exec_on_max_failures character varying(256),
    exec_on_max_timeouts character varying(256),
    tts_engine character varying(256),
    tts_voice character varying(256),
    digit_len character varying(16)
);
 
 
ALTER TABLE public.ivr_menus OWNER TO fsuser;
 
--
-- Name: ivr_menus_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.ivr_menus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.ivr_menus_id_seq OWNER TO fsuser;
 
--
-- Name: ivr_menus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.ivr_menus_id_seq OWNED BY public.ivr_menus.id;
 
 
--
-- Name: out_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.out_map (
    id integer NOT NULL,
    out_prepend character varying(32),
    out_prefix character varying(8),
    out_pattern text,
    out_type character varying(32),
    out_codec character varying(32) DEFAULT 'PCMA'::character varying,
    out_cid character varying(32),
    out_gw character varying(32),
    out_toll_allow character varying(32)
);
 
 
ALTER TABLE public.out_map OWNER TO fsuser;
 
--
-- Name: out_map_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.out_map_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.out_map_id_seq OWNER TO fsuser;
 
--
-- Name: out_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.out_map_id_seq OWNED BY public.out_map.id;
 
 
--
-- Name: queuelog; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.queuelog (
    id integer NOT NULL,
    cc_member_uuid uuid NOT NULL,
    cc_agent_uuid uuid,
    cc_queue_joined_epoch integer NOT NULL,
    cc_queue_answered_epoch integer,
    cc_queue_terminated_epoch integer,
    cc_queue_canceled_epoch integer,
    cc_side character varying NOT NULL,
    caller_id character varying,
    cc_queue character varying NOT NULL,
    cc_agent character varying,
    waitsec integer NOT NULL,
    duration integer NOT NULL,
    billsec integer NOT NULL,
    cc_cause character varying NOT NULL,
    cc_cancel_reason character varying,
    hangup_cause character varying NOT NULL,
    cc_agent_bridged character varying,
    sip_hangup_disposition character varying,
    cc_record_filename character varying
);
 
 
ALTER TABLE public.queuelog OWNER TO fsuser;
 
--
-- Name: queuelog_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.queuelog_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.queuelog_id_seq OWNER TO fsuser;
 
--
-- Name: queuelog_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.queuelog_id_seq OWNED BY public.queuelog.id;
 
 
--
-- Name: sip_profiles; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.sip_profiles (
    id integer NOT NULL,
    profile character varying,
    type character varying,
    name character varying,
    value character varying,
    enable boolean DEFAULT false NOT NULL,
    active boolean DEFAULT true
);
 
 
ALTER TABLE public.sip_profiles OWNER TO fsuser;
 
--
-- Name: sip_profiles_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.sip_profiles_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.sip_profiles_id_seq OWNER TO fsuser;
 
--
-- Name: sip_profiles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.sip_profiles_id_seq OWNED BY public.sip_profiles.id;
 
 
--
-- Name: user_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.user_map (
    id integer NOT NULL,
    did_start character varying(8) NOT NULL,
    did_end character varying(8) NOT NULL,
    type character varying(16) DEFAULT NULL::character varying,
    data character varying(512) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    branch character varying(128) DEFAULT NULL::character varying
);
 
 
ALTER TABLE public.user_map OWNER TO fsuser;
 
--
-- Name: user_map_id_seq; Type: SEQUENCE; Schema: public; Owner: fsuser
--
 
CREATE SEQUENCE public.user_map_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;
 
 
ALTER TABLE public.user_map_id_seq OWNER TO fsuser;
 
--
-- Name: user_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: fsuser
--
 
ALTER SEQUENCE public.user_map_id_seq OWNED BY public.user_map.id;
 
 
--
-- Name: cc_agents id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_agents ALTER COLUMN id SET DEFAULT nextval('public.cc_agents_id_seq'::regclass);
 
 
--
-- Name: cc_queues id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_queues ALTER COLUMN id SET DEFAULT nextval('public.cc_queues_id_seq'::regclass);
 
 
--
-- Name: cc_tiers id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_tiers ALTER COLUMN id SET DEFAULT nextval('public.cc_tiers_id_seq'::regclass);
 
 
--
-- Name: cdr id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cdr ALTER COLUMN id SET DEFAULT nextval('public.cdr_id_seq'::regclass);
 
 
--
-- Name: dialplan_xml id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.dialplan_xml ALTER COLUMN id SET DEFAULT nextval('public.dialplan_xml_id_seq'::regclass);
 
 
--
-- Name: distributor id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.distributor ALTER COLUMN id SET DEFAULT nextval('public.distributor_id_seq'::regclass);
 
 
--
-- Name: fifo id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.fifo ALTER COLUMN id SET DEFAULT nextval('public.fifo_id_seq'::regclass);
 
 
--
-- Name: gateways id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.gateways ALTER COLUMN id SET DEFAULT nextval('public.gateways_id_seq'::regclass);
 
 
--
-- Name: ivr_entry id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.ivr_entry ALTER COLUMN id SET DEFAULT nextval('public.ivr_entry_id_seq'::regclass);
 
 
--
-- Name: ivr_menus id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.ivr_menus ALTER COLUMN id SET DEFAULT nextval('public.ivr_menus_id_seq'::regclass);
 
 
--
-- Name: out_map id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.out_map ALTER COLUMN id SET DEFAULT nextval('public.out_map_id_seq'::regclass);
 
 
--
-- Name: queuelog id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.queuelog ALTER COLUMN id SET DEFAULT nextval('public.queuelog_id_seq'::regclass);
 
 
--
-- Name: sip_profiles id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.sip_profiles ALTER COLUMN id SET DEFAULT nextval('public.sip_profiles_id_seq'::regclass);
 
 
--
-- Name: user_map id; Type: DEFAULT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.user_map ALTER COLUMN id SET DEFAULT nextval('public.user_map_id_seq'::regclass);
 
 
--
-- Name: admin admin_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.admin
    ADD CONSTRAINT admin_id_key UNIQUE (id);
 
 
--
-- Name: cc_agents cc_agents_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_agents
    ADD CONSTRAINT cc_agents_id_key UNIQUE (id);
 
 
--
-- Name: cc_agents cc_agents_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_agents
    ADD CONSTRAINT cc_agents_pkey PRIMARY KEY (id);
 
 
--
-- Name: cc_queues cc_queues_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_queues
    ADD CONSTRAINT cc_queues_id_key UNIQUE (id);
 
 
--
-- Name: cc_queues cc_queues_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_queues
    ADD CONSTRAINT cc_queues_pkey PRIMARY KEY (id);
 
 
--
-- Name: cc_tiers cc_tiers_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_tiers
    ADD CONSTRAINT cc_tiers_id_key UNIQUE (id);
 
 
--
-- Name: cc_tiers cc_tiers_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cc_tiers
    ADD CONSTRAINT cc_tiers_pkey PRIMARY KEY (id);
 
 
--
-- Name: cdr cdr_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.cdr
    ADD CONSTRAINT cdr_pkey PRIMARY KEY (id);
 
 
--
-- Name: dialplan_xml dialplan_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.dialplan_xml
    ADD CONSTRAINT dialplan_xml_id_key UNIQUE (id);
 
 
--
-- Name: dialplan_xml dialplan_xml_id_key1; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.dialplan_xml
    ADD CONSTRAINT dialplan_xml_id_key1 UNIQUE (id);
 
 
--
-- Name: directory directory_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.directory
    ADD CONSTRAINT directory_id_key UNIQUE (id);
 
 
--
-- Name: distributor distributor_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.distributor
    ADD CONSTRAINT distributor_id_key UNIQUE (id);
 
 
--
-- Name: distributor distributor_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.distributor
    ADD CONSTRAINT distributor_pkey PRIMARY KEY (id);
 
 
--
-- Name: fifo fifo_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.fifo
    ADD CONSTRAINT fifo_id_key UNIQUE (id);
 
 
--
-- Name: fifo fifo_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.fifo
    ADD CONSTRAINT fifo_pkey PRIMARY KEY (id);
 
 
--
-- Name: gateways gateways_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.gateways
    ADD CONSTRAINT gateways_id_key UNIQUE (id);
 
 
--
-- Name: gateways gateways_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.gateways
    ADD CONSTRAINT gateways_pkey PRIMARY KEY (id);
 
 
--
-- Name: incoming_map incoming_map_did_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.incoming_map
    ADD CONSTRAINT incoming_map_did_key UNIQUE (did);
 
 
--
-- Name: incoming_map incoming_map_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.incoming_map
    ADD CONSTRAINT incoming_map_pkey PRIMARY KEY (id);
 
 
--
-- Name: ivr_entry ivr_entry_id_menu_name_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.ivr_entry
    ADD CONSTRAINT ivr_entry_id_menu_name_key UNIQUE (id, menu_name);
 
 
--
-- Name: ivr_menus ivr_menus_id_name_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.ivr_menus
    ADD CONSTRAINT ivr_menus_id_name_key UNIQUE (id, name);
 
 
--
-- Name: out_map out_map_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.out_map
    ADD CONSTRAINT out_map_id_key UNIQUE (id);
 
 
--
-- Name: out_map out_map_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.out_map
    ADD CONSTRAINT out_map_pkey PRIMARY KEY (id);
 
 
--
-- Name: queuelog queuelog_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.queuelog
    ADD CONSTRAINT queuelog_pkey PRIMARY KEY (id);
 
 
--
-- Name: sip_profiles sip_profiles_id_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.sip_profiles
    ADD CONSTRAINT sip_profiles_id_key UNIQUE (id);
 
 
--
-- Name: sip_profiles sip_profiles_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.sip_profiles
    ADD CONSTRAINT sip_profiles_pkey PRIMARY KEY (id);
 
 
--
-- Name: user_map user_map_did_end_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.user_map
    ADD CONSTRAINT user_map_did_end_key UNIQUE (did_end);
 
 
--
-- Name: user_map user_map_did_start_key; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.user_map
    ADD CONSTRAINT user_map_did_start_key UNIQUE (did_start);
 
 
--
-- Name: user_map user_map_pkey; Type: CONSTRAINT; Schema: public; Owner: fsuser
--
 
ALTER TABLE ONLY public.user_map
    ADD CONSTRAINT user_map_pkey PRIMARY KEY (id);
 
 
--
-- PostgreSQL database dump complete
--

fsdir new

fsdir new

fsdir new
--
-- PostgreSQL database dump
--
 
--
-- Name: accounts; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.accounts (
    id serial PRIMARY KEY NOT NULL,
    username text NOT NULL,
    password text NOT NULL,
    session text,
    remote_addr character varying(16),
    datetime character varying(32),
    user_agent character varying(256),
    role character varying(16),
    salt integer,
    language character varying(8) DEFAULT 'en-US'::character varying,
    theme character varying(128) DEFAULT 'hero'::character varying
);
 
 
ALTER TABLE public.accounts OWNER TO fsuser;
 
 
--
-- Name: backups; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.backups (
    id serial PRIMARY KEY NOT NULL,
    name text,
    path text,
    full_name text,
    date timestamp without time zone DEFAULT now(),
    description text,
    session_exe text,
    last_exe timestamp without time zone,
    last_ip character varying(16),
    filesize integer
);
 
 
ALTER TABLE public.backups OWNER TO fsuser;
 
--
-- Name: dialplan_xml; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.dialplan_xml (
    id serial PRIMARY KEY NOT NULL,
    dp_domain text,
    dp_context text,
    dp_name text,
    dp_continue text DEFAULT 'false'::text,
    dp_condtype text DEFAULT 'field'::text,
    dp_condvalue text DEFAULT 'destination_number'::text,
    dp_expr text,
    dp_break text DEFAULT 'on-false'::text,
    dp_xml text,
    enabled boolean DEFAULT false
);
 
 
ALTER TABLE public.dialplan_xml OWNER TO fsuser;
 
--
-- Name: directory_xml; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.directory_xml (
    domain character varying(32) NOT NULL,
    id character varying(32) UNIQUE NOT NULL,
    "number-alias" character varying(32) DEFAULT NULL::character varying,
    mailbox character varying(64) DEFAULT NULL::character varying,
    cidr character varying(64) DEFAULT NULL::character varying,
    password character varying(64) DEFAULT NULL::character varying,
    toll_allow character varying(32) DEFAULT NULL::character varying,
    user_context character varying(32) DEFAULT NULL::character varying,
    default_gateway character varying(32) DEFAULT NULL::character varying,
    effective_caller_id_name character varying(512) DEFAULT NULL::character varying,
    effective_caller_id_number character varying(64) DEFAULT NULL::character varying,
    outbound_caller_id_name character varying(512) DEFAULT NULL::character varying,
    outbound_caller_id_number character varying(64) DEFAULT NULL::character varying,
    callgroup character varying(64) DEFAULT NULL::character varying,
    tls character varying(8) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    uservar1 character varying(64) DEFAULT NULL::character varying,
    uservar2 character varying(64) DEFAULT NULL::character varying,
    uservar3 character varying(64) DEFAULT NULL::character varying,
    uservar4 character varying(512) DEFAULT NULL::character varying,
    uservar5 character varying(512) DEFAULT NULL::character varying,
    uservar6 character varying(8) DEFAULT NULL::character varying,
    uservar7 character varying(512) DEFAULT NULL::character varying,
    branch character varying(255) DEFAULT NULL::character varying,
    user_agent character varying(128),
    net_addr character varying(16),
    last_reg character varying(64),
    nibble_account bigserial UNIQUE NOT NULL,
    nibble_rate double precision DEFAULT 1.00
);
 
 
ALTER TABLE public.directory_xml OWNER TO fsuser;
 
--
-- Name: fifo; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_fifo (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    importance integer DEFAULT 0,
    timeout integer DEFAULT 20,
    simo integer DEFAULT 1,
    lag integer DEFAULT 5,
    member_wait character varying DEFAULT 'nowait'::character varying,
    members character varying
);
 
 
ALTER TABLE public.mod_fifo OWNER TO fsuser;
 
--
-- Name: gateways; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.gateways (
    id serial PRIMARY KEY NOT NULL,
    profile character varying,
    gw_name character varying,
    type character varying,
    name character varying,
    value character varying,
    param_enable boolean DEFAULT false NOT NULL,
    gw_enable boolean DEFAULT false
);
 
 
ALTER TABLE public.gateways OWNER TO fsuser;
 
--
-- Name: incoming_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.incoming_map (
    id serial PRIMARY KEY NOT NULL,
    did character varying(32) DEFAULT NULL::character varying,
    did_domain character varying(64) DEFAULT '$${domain}'::character varying,
    did_pre_execute character varying(512) DEFAULT 'ALL_TC'::character varying,
    did_app character varying(32) DEFAULT NULL::character varying,
    did_fail character varying(512) DEFAULT NULL::character varying,
    did_timeout character varying(8) DEFAULT NULL::character varying,
    did_data character varying(512) DEFAULT NULL::character varying,
    did_var character varying(512) DEFAULT NULL::character varying,
    did_post_execute character varying(512) DEFAULT 'ALL_HG'::character varying,
    did_branch character varying(64) DEFAULT NULL::character varying,
    did_codec character varying(128) DEFAULT 'PCMA'::character varying
);
 
 
ALTER TABLE public.incoming_map OWNER TO fsuser;
 
--
-- Name: mod_ivr_entry; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_ivr_entry (
    id serial PRIMARY KEY NOT NULL,
    menu_name character varying(32),
    action character varying(32),
    digits character varying(32),
    param character varying
);
 
ALTER TABLE public.mod_ivr_entry OWNER TO fsuser;
 
--
-- Name: mod_ivr_menus; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_ivr_menus (
    id serial PRIMARY KEY NOT NULL,
    name character varying NOT NULL,
    greet_long character varying(256),
    greet_short character varying(256),
    invalid_sound character varying(256),
    exit_sound character varying(256),
    inter_digit_timeout character varying(4),
    timeout character varying(4),
    confirm_macro character varying(256),
    confirm_key character varying(4),
    confirm_attempts character varying(4),
    max_failures character varying(4),
    max_timeouts character varying(4),
    exec_on_max_failures character varying(256),
    exec_on_max_timeouts character varying(256),
    tts_engine character varying(256),
    tts_voice character varying(256),
    digit_len character varying(16)
);
 
 
ALTER TABLE public.mod_ivr_menus OWNER TO fsuser;
 
--
-- Name: mod_cdr_pg; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cdr_pg (
    id serial PRIMARY KEY NOT NULL,
    local_ip_v4 inet NOT NULL,
    caller_id_name character varying,
    caller_id_number character varying,
    destination_number character varying NOT NULL,
    context character varying NOT NULL,
    start_stamp timestamp with time zone NOT NULL,
    answer_stamp timestamp with time zone,
    end_stamp timestamp with time zone NOT NULL,
    duration integer NOT NULL,
    billsec integer NOT NULL,
    hangup_cause character varying NOT NULL,
    uuid uuid NOT NULL,
    bleg_uuid uuid,
    accountcode character varying,
    read_codec character varying,
    write_codec character varying,
    sip_hangup_disposition character varying,
    ani character varying,
    endpoint_disposition character varying(32),
    recdir character varying(512),
    recfile character varying(512)
);
 
 
ALTER TABLE public.mod_cdr_pg OWNER TO fsuser;
 
 
--
-- Name: mod_distributor; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_distributor (
    id serial PRIMARY KEY NOT NULL,
    list character varying,
    node character varying,
    weight character varying
);
 
 
ALTER TABLE public.mod_distributor OWNER TO fsuser;
 
--
-- Name: out_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.out_map (
    id serial PRIMARY KEY NOT NULL,
    out_prepend character varying(32),
    out_prefix character varying(8),
    out_pattern text,
    out_type character varying(32),
    out_codec character varying(32) DEFAULT 'PCMA'::character varying,
    out_cid character varying(32),
    out_gw character varying(32),
    out_toll_allow character varying(32)
);
 
 
ALTER TABLE public.out_map OWNER TO fsuser;
 
--
-- Name: sip_profiles; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.sip_profiles (
    id serial PRIMARY KEY NOT NULL,
    profile character varying,
    type character varying,
    name character varying,
    value character varying,
    enable boolean DEFAULT false NOT NULL,
    active boolean DEFAULT true
);
 
 
ALTER TABLE public.sip_profiles OWNER TO fsuser;
 
--
-- Name: user_map; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.user_map (
    id integer PRIMARY KEY NOT NULL,
    did_start character varying(8) NOT NULL,
    did_end character varying(8) NOT NULL,
    type character varying(16) DEFAULT NULL::character varying,
    data character varying(512) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    branch character varying(128) DEFAULT NULL::character varying
);
 
 
ALTER TABLE public.user_map OWNER TO fsuser;
 
--
-- Name: agent_status; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.agent_status AS ENUM (
    'Logged Out',
    'Available',
    'Available (On Demand)',
    'On Break'
);
 
ALTER TYPE public.agent_status OWNER TO fsuser;
 
--
-- Name: agent_type; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.agent_type AS ENUM (
    'callback',
    'uuid-standby'
);
 
ALTER TYPE public.agent_type OWNER TO fsuser;
 
--
-- Name: queue_strategy; Type: TYPE; Schema: public; Owner: fsuser
--
 
CREATE TYPE public.queue_strategy AS ENUM (
    'ring-all',
    'longest-idle-agent',
    'round-robin',
    'top-down',
    'agent-with-least-talk-time',
    'agent-with-fewest-calls',
    'sequentially-by-agent-order',
    'random',
    'ring-progressively'
);
 
ALTER TYPE public.queue_strategy OWNER TO fsuser;
 
--
-- Name: mod_cc_agents; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_agents (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    type public.agent_type,
    contact character varying NOT NULL,
    status public.agent_status,
    max_no_answer integer DEFAULT 3 NOT NULL,
    wrap_up_time integer DEFAULT 10 NOT NULL,
    reject_delay_time integer DEFAULT 3 NOT NULL,
    busy_delay_time integer DEFAULT 60 NOT NULL,
    no_answer_delay_time integer DEFAULT 5 NOT NULL,
    reserve_agents character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_agents_on_load character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_tiers_on_load character varying DEFAULT 'false'::character varying NOT NULL
);
 
 
ALTER TABLE public.mod_cc_agents OWNER TO fsuser;
 
--
-- Name: mod_cc_queues; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_queues (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    strategy public.queue_strategy,
    moh_sound character varying DEFAULT '$${hold_music}'::character varying NOT NULL,
    record_template character varying,
    time_base_score character varying DEFAULT 'queue'::character varying NOT NULL,
    max_wait_time integer DEFAULT 0 NOT NULL,
    max_wait_time_wna integer DEFAULT 0 NOT NULL,
    max_wait_time_wna_tr integer DEFAULT 5 NOT NULL,
    tier_rules_apply character varying DEFAULT 'false'::character varying NOT NULL,
    tier_rule_wait_second integer DEFAULT 300 NOT NULL,
    tier_rule_wait_ml character varying DEFAULT 'true'::character varying NOT NULL,
    tier_rule_no_agent_no_wait character varying DEFAULT 'false'::character varying NOT NULL,
    discard_abandoned_after integer DEFAULT 60 NOT NULL,
    abandoned_resume_allowed character varying DEFAULT 'false'::character varying NOT NULL,
    ring_progressively_delay integer DEFAULT 60 NOT NULL
);
 
 
ALTER TABLE public.mod_cc_queues OWNER TO fsuser;
 
--
-- Name: mod_cc_tiers; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_tiers (
    id serial PRIMARY KEY NOT NULL,
    agent character varying NOT NULL,
    queue character varying NOT NULL,
    level integer DEFAULT 1 NOT NULL,
    "position" integer DEFAULT 1 NOT NULL
);
 
ALTER TABLE public.mod_cc_tiers OWNER TO fsuser;
 
--
-- Name: mod_cc_settings; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_settings (
    id serial PRIMARY KEY NOT NULL,
    odbc_dsn character varying(1024),
    dbname character varying
);
 
ALTER TABLE public.mod_cc_settings OWNER TO fsuser;
 
--
-- PostgreSQL database dump complete
--
download schema
 cd /home/fsuser
 wget -O fsdir_schema.pgsql https://asterisk-pbx.ru/wiki/_export/code/freeswitch/debian_install?codeblock=22
create database
  su - postgres
  $ createdb -O fsuser fsdir
  $ exit
  su - fsuser
  $ psql -U fsuser fsdir < fsdir_schema.pgsql

Deploy FS Web Interface

First, install nginx

apt-get install nginx
systemctl enable nginx
systemctl start nginx

install php-fpm

apt install ca-certificates apt-transport-https 
wget -q https://packages.sury.org/php/apt.gpg -O- | sudo apt-key add -
wget -q https://packages.sury.org/php/apt.gpg -O- | apt-key add -
echo "deb https://packages.sury.org/php/ stretch main" | tee /etc/apt/sources.list.d/php.list

/etc/nginx/sites-available/default

/etc/nginx/sites-available/default

/etc/nginx/sites-available/default
server {
	listen 80 default_server;
	root /var/www/html;
 
	index index.php;
 
	location / {
		try_files $uri $uri/ =404;
	}
 
        location ~* \.(php|html)$ {
        try_files $uri = 404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
 
}

apt install php7.4 php7.4-fpm
systemctl restart nginx
# nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
cat  /etc/php/7.4/fpm/pool.d/www.conf  | grep security
security.limit_extensions = .php .html

Or install openresty under freeswitch user

apt -y install --no-install-recommends gnupg ca-certificates
wget -O - https://openresty.org/package/pubkey.gpg 
wget -O - https://openresty.org/package/pubkey.gpg | apt-key add -
apt -y install --no-install-recommends software-properties-common
add-apt-repository -y "deb http://openresty.org/package/debian $(lsb_release -sc) openresty"
apt update
apt -y install --no-install-recommends openresty

Edit user, owner and limit extensions for php-fpm

change 7.4 to your version.

 nano /etc/php/7.4/fpm/pool.d/www.conf
[www]
user = freeswitch
...
listen.owner = freeswitch
...
security.limit_extensions = .php .html

Create the log directory

mkdir /var/log/openresty

Configuring Openresty

/usr/local/openresty/nginx/conf/nginx.conf
user freeswitch;
worker_processes  auto;
pid /usr/local/openresty/nginx/logs/nginx.pid;
events {
    worker_connections  1024;
}

http {
    include       mime.types;
    default_type  application/octet-stream;
    sendfile        on;
    tcp_nopush      on;
    tcp_nodelay     on;
    keepalive_timeout  65;
    ssl_protocols TLSv1 TLSv1.1 TLSv1.2; # Dropping SSLv3, ref: POODLE
    ssl_prefer_server_ciphers on;
    access_log /var/log/openresty/access.log;
    error_log /var/log/openresty/error.log;
    gzip  on;
    gzip_disable "msie6";
    include ../sites/*;
}
nano /usr/local/openresty/nginx/sites/default.conf
server {
    listen 80 default_server;
    root /usr/local/openresty/nginx/html/default;

    index index.php;

    location / {
        try_files $uri $uri/ =404;
    }

        location ~* \.(php|html)$ {
        try_files $uri = 404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass unix:/var/run/php/php7.4-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include fastcgi_params;
    }
            location /lua_test {
            content_by_lua '
            ngx.header["Content-Type"] = "text/plain;charset=utf-8"
            ngx.say("Lua tested!");
        ';
    }

}
  • freeswitch/debian_install.txt
  • Последние изменения: 2020/05/29