[Freeswitch-users] Connecting freeswitch to postgresql
Madovsky
infos at madovsky.org
Thu May 24 22:43:27 UTC 2018
are you sure you are using the proper sip profile which use pgsql:// ?
On 5/24/2018 3:20 PM, Blackhold wrote:
> it seems nothing... yes tells something, but no one error, it seems
> all modules are loaded ok.
>
>
> 2018-05-24 22:58:20.552211 [INFO] sofia.c:5987 Setting MAX Auth
> Validity to 0 Attempts
>
> 2018-05-24 22:58:20.557248 [INFO] switch_core_sqldb.c:1693
> sofia:external Starting SQL thread.
>
> 2018-05-24 22:58:20.562295 [NOTICE] sofia.c:4172 Adding Alias
> [10.90.226.83] for profile [internal]
> 2018-05-24 22:58:20.562424 [WARNING] sofia.c:2285 MSG Thread 0 Started
>
> 2018-05-24 22:58:22.059111 [CONSOLE] switch_loadable_module.c:1540
> Successfully Loaded [mod_db]
> 2018-05-24 22:58:22.059118 [NOTICE] switch_loadable_module.c:292
> Adding Application 'db'
> 2018-05-24 22:58:22.059128 [NOTICE] switch_loadable_module.c:292
> Adding Application 'group'
> 2018-05-24 22:58:22.059137 [NOTICE] switch_loadable_module.c:338
> Adding API Function 'db'
> 2018-05-24 22:58:22.059146 [NOTICE] switch_loadable_module.c:338
> Adding API Function 'group'
> 2018-05-24 22:58:22.059154 [NOTICE] switch_loadable_module.c:556
> Adding Limit interface 'db'
>
>
>
> - Blackhold
> http://blackhold.nusepas.com
> @blackhold_
> ~> cal lluitar contra el fort per deixar de ser febles, i contra
> nosaltres mateixos quan siguem forts (Xirinacs)
> <°((( ><
>
> 2018-05-24 23:23 GMT+02:00 Madovsky <infos at madovsky.org
> <mailto:infos at madovsky.org>>:
>
> and anything in FS logs?
>
> On 5/24/2018 1:59 PM, Blackhold wrote:
>> done, restarted psql and turned on freeswitch, nothing in psql
>> log files, no tables where created.
>>
>> using psql conector
>>
>>
>> - Blackhold
>> http://blackhold.nusepas.com
>> @blackhold_
>> ~> cal lluitar contra el fort per deixar de ser febles, i contra
>> nosaltres mateixos quan siguem forts (Xirinacs)
>> <°((( ><
>>
>> 2018-05-24 22:41 GMT+02:00 Madovsky <infos at madovsky.org
>> <mailto:infos at madovsky.org>>:
>>
>> remove these 2 lines
>>
>> local all postgres peer
>>
>> local all all peer
>>
>> and replace with
>>
>> local all all trust
>>
>> in your pg_hba.conf
>>
>>
>> On 5/24/2018 1:26 PM, Blackhold wrote:
>>> Hi,
>>>
>>> I'm trying both ways, switching between one and the other...
>>> I initially want to use psql directly, not using odbc, but
>>> when using directly I get less info, well... logs files
>>> don't say nothing :( if the correct way is to use that:
>>>
>>> <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1
>>> dbname=freeswitch_db user=freeswitch_user password='XXX'
>>> options='-c client_min_messages=NOTICE'" />
>>>
>>> so then, I only will use that, and the problem is my system,
>>> not freeswitch.
>>>
>>> odbc configuration is an old odbc configuration that I used
>>> some time ago when I had to use it... so... for actual psql
>>> db wich version is the ok?!
>>>
>>> Here you have the versions of libraries I have:
>>>
>>> # debian 8 fresh install (x86_64)
>>>
>>> root at freeswitch-capa8:~# cat /etc/debian_version
>>> 8.10
>>> root at freeswitch-capa8:~# dpkg -l |grep postgresql
>>> ii odbc-postgresql:amd64 1:09.03.0300-1 amd64
>>> ODBC driver for PostgreSQL
>>> ii postgresql 9.4+165+deb8u3 all
>>> object-relational SQL database (supported version)
>>> ii postgresql-9.4 9.4.15-0+deb8u1 amd64
>>> object-relational SQL database, version 9.4 server
>>> ii postgresql-client 9.4+165+deb8u3 all
>>> front-end programs for PostgreSQL (supported version)
>>> ii postgresql-client-9.4 9.4.15-0+deb8u1 amd64
>>> front-end programs for PostgreSQL 9.4
>>> ii postgresql-client-common 165+deb8u3 all
>>> manager for multiple PostgreSQL client versions
>>> ii postgresql-common 165+deb8u3 all PostgreSQL
>>> database-cluster manager
>>> root at freeswitch-capa8:~# dpkg -l |grep libpq
>>> ii libpq-dev 9.4.15-0+deb8u1 amd64 header files
>>> for libpq5 (PostgreSQL library)
>>> ii libpq5:amd64 9.4.15-0+deb8u1 amd64 PostgreSQL C
>>> client library
>>>
>>> all these packages are downloaded from sources
>>>
>>> the lines enabled at pg_hba.conf are these (the debian
>>> default ones)
>>>
>>> local all postgres peer
>>> local all all peer
>>> host all all 127.0.0.1/32
>>> <http://127.0.0.1/32> md5
>>> host all all ::1/128 md5
>>>
>>> the script that I have used to do the installation is the
>>> one located in source code
>>>
>>> root at freeswitch-capa8:/usr/src/freeswitch/scripts# ls -l
>>> |grep raspbian-installer
>>> -rwxr-xr-x 1 root root 7922 May 23 20:26
>>> FreeSWITCH-debian-raspbian-installer.sh
>>>
>>>
>>>
>>>
>>> - Blackhold
>>> http://blackhold.nusepas.com
>>> @blackhold_
>>> ~> cal lluitar contra el fort per deixar de ser febles, i
>>> contra nosaltres mateixos quan siguem forts (Xirinacs)
>>> <°((( ><
>>>
>>> 2018-05-24 21:58 GMT+02:00 Madovsky <infos at madovsky.org
>>> <mailto:infos at madovsky.org>>:
>>>
>>> First of all, pgsql:// does not use odbc, instead use
>>> odbc:// to use odbc (btw your odbc.ini file shows
>>> Protocol=6.4 (!?) are you using
>>>
>>> postgresql 6.x !??!)
>>>
>>> what version of postgresql are you using? compiled
>>> yourself or from system package?
>>>
>>> check if there are not multiple versions of libpq.xx in
>>> your system.
>>>
>>> check pg_hba.conf if localhost is on trust mode for all
>>> local users.
>>>
>>> if you compiled yourself so be sure the right libpq.xx
>>> have been chosen.
>>>
>>> On 5/24/2018 12:33 PM, Blackhold wrote:
>>>> nope, it is not able to create stuff
>>>>
>>>> now I also have enabled that in switch.conf.xml
>>>>
>>>> <param name="auto-create-schemas" value="true"/>
>>>> <param name="auto-clear-sql" value="true"/>
>>>>
>>>> tested with odbc and directly with psql and behaviour
>>>> is the same.
>>>>
>>>> for psql the procedure I have followed is
>>>>
>>>> root at freeswitch-capa8:~# su - postgres
>>>> root at freeswitch-capa8:~#postgres at freeswitch-capa8:~$ createuser
>>>> freeswitch_user
>>>> root at freeswitch-capa8:~#createdb -O freeswitch_user
>>>> freeswitch_db
>>>> root at freeswitch-capa8:~#psql freeswitch_db
>>>> freeswitch_db=# ALTER USER freeswitch_user WITH
>>>> PASSWORD 'XXX';
>>>> freeswitch_db=# GRANT ALL PRIVILEGES ON ALL TABLES IN
>>>> SCHEMA public TO freeswitch_user;
>>>> freeswitch_db=# GRANT ALL PRIVILEGES ON ALL SEQUENCES
>>>> IN SCHEMA public TO freeswitch_user;
>>>>
>>>> the most beatiful was with odbc + tables created... in
>>>> the last mail... freeswitch turned on, in other ways
>>>> freeswitch doesn't turns on.
>>>>
>>>> logs doesn't talk about permissions....
>>>>
>>>>
>>>>
>>>>
>>>> - Blackhold
>>>> http://blackhold.nusepas.com
>>>> @blackhold_
>>>> ~> cal lluitar contra el fort per deixar de ser febles,
>>>> i contra nosaltres mateixos quan siguem forts (Xirinacs)
>>>> <°((( ><
>>>>
>>>> 2018-05-24 21:20 GMT+02:00 Michael Jerris
>>>> <mike at jerris.com <mailto:mike at jerris.com>>:
>>>>
>>>> you shouldn't need to pre-import the tables, if the
>>>> permissions are right, it should create the tables
>>>> and indexes for you.
>>>>
>>>>
>>>>> On May 24, 2018, at 3:15 PM, Blackhold
>>>>> <blackholdmailer at gmail.com
>>>>> <mailto:blackholdmailer at gmail.com>> wrote:
>>>>>
>>>>> I continue with tests
>>>>>
>>>>> I think I know wich problem I had with errors
>>>>>
>>>>> I have missed to grant privileges in psql:
>>>>>
>>>>> GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA
>>>>> public TO freeswitch_user;
>>>>> GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA
>>>>> public TO freeswitch_user;
>>>>>
>>>>> # with tables imported from sqlite it shows
>>>>> (freeswitch runs)
>>>>>
>>>>> root at freeswitch-capa8:/var/log/postgresql# tail -f
>>>>> postgresql-9.4-main.log
>>>>>
>>>>> 2018-05-24 21:03:34 CEST [8623-1]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-2]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index recovery1 on
>>>>> recovery(technology);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-3]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-4]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index recovery2 on
>>>>> recovery(profile_name);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-5]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-6]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index recovery3 on
>>>>> recovery(uuid);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-7]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-8]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index recovery3 on
>>>>> recovery(runtime_uuid);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-9]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-10]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index alias1 on aliases
>>>>> (alias);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-11]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-12]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index tasks1 on tasks
>>>>> (hostname,task_id);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-13]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-14]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete1 on
>>>>> complete (a1,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-15]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-16]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete2 on
>>>>> complete (a2,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-17]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-18]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete3 on
>>>>> complete (a3,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-19]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-20]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete4 on
>>>>> complete (a4,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-21]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-22]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete5 on
>>>>> complete (a5,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-23]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-24]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete6 on
>>>>> complete (a6,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-25]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-26]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete7 on
>>>>> complete (a7,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-27]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-28]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete8 on
>>>>> complete (a8,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-29]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-30]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete9 on
>>>>> complete (a9,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-31]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-32]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete10 on
>>>>> complete (a10,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-33]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-34]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index complete11 on
>>>>> complete
>>>>> (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname);EXECUTE
>>>>> "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-35]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-36]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index
>>>>> nat_map_port_proto on nat
>>>>> (port,proto,hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-37]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-38]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index channels1 on
>>>>> channels(hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-39]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-40]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index calls1 on
>>>>> calls(hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-41]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-42]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index chidx1 on
>>>>> channels (hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-43]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-44]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index uuindex on
>>>>> channels (uuid, hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-45]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-46]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index uuindex2 on
>>>>> channels (call_uuid);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-47]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-48]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index callsidx1 on
>>>>> calls (hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-49]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-50]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index eruuindex on
>>>>> calls (caller_uuid, hostname);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-51]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-52]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index eeuuindex on
>>>>> calls (callee_uuid);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-53]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-54]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index eeuuindex2 on
>>>>> calls (call_uuid);EXECUTE "_PLAN0x123ff90"
>>>>> 2018-05-24 21:03:34 CEST [8623-55]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax error
>>>>> at or near "create" at character 29
>>>>> 2018-05-24 21:03:34 CEST [8623-56]
>>>>> freeswitch_user at freeswitch_db STATEMENT: PREPARE
>>>>> "_PLAN0x123ff90" as create index regindex1 on
>>>>> registrations (reg_user,realm,hostname);EXECUTE
>>>>> "_PLAN0x123ff90"
>>>>>
>>>>> # with a clean database
>>>>>
>>>>> start dropping last errors, and don't create any
>>>>> table in db. Freeswitch doesn't turns on.
>>>>>
>>>>> each time I stop freeswitch when it don't runs, it
>>>>> keeps a process running that I have to kill manually
>>>>>
>>>>> root at freeswitch-capa8:/var/log/postgresql# ps aux
>>>>> |grep free
>>>>> root 8706 39.6 0.7 141296 15244 ? S<l 21:08
>>>>> 1:13 /usr/local/freeswitch/bin/freeswitch -nc
>>>>>
>>>>>
>>>>> # with granted permisions if I turn configuration
>>>>> to not use odbc, using psql directly
>>>>>
>>>>> freeswitch turns on, there's no errors in psql log
>>>>> file and no table was created on db.
>>>>>
>>>>>
>>>>>
>>>>> - Blackhold
>>>>> http://blackhold.nusepas.com
>>>>> <http://blackhold.nusepas.com/>
>>>>> @blackhold_
>>>>> ~> cal lluitar contra el fort per deixar de ser
>>>>> febles, i contra nosaltres mateixos quan siguem
>>>>> forts (Xirinacs)
>>>>> <°((( ><
>>>>>
>>>>> 2018-05-24 20:31 GMT+02:00 Blackhold
>>>>> <blackholdmailer at gmail.com
>>>>> <mailto:blackholdmailer at gmail.com>>:
>>>>>
>>>>> # OK for location of ODBC files
>>>>>
>>>>> # output freeswitch using psql (I only edited
>>>>> switch.conf.xml file)
>>>>> <param name="core-db-dsn"
>>>>> value="pgsql://hostaddr=127.0.0.1
>>>>> dbname=freeswitch_db user=freeswitch_user
>>>>> password='XXX' options='-c
>>>>> client_min_messages=NOTICE'" />
>>>>> (switch.conf.xml file)
>>>>>
>>>>> I see no errors related on logs (nor
>>>>> freeswitch, nor psql -debug5-), obviously
>>>>> restarted psql to reload config.
>>>>>
>>>>> in sofia.conf.xml file I found no option to
>>>>> configure it pointing to database
>>>>> no other config file, except switch.conf.xml
>>>>> has configured database pointing
>>>>>
>>>>> I tried to configure db.conf.xml file, with
>>>>> switch.conf.xml line but also do nothing
>>>>>
>>>>> # output freeswtich using odbc
>>>>> <param name="core-db-dsn"
>>>>> value="freeswitch:freeswitch_user:XXX"/>
>>>>> (switch.conf.xml file)
>>>>>
>>>>> these are the first lines of postgresql log file
>>>>>
>>>>> 2018-05-24 20:23:15 CEST [7518-7] LOG:
>>>>> received fast shutdown request
>>>>> 2018-05-24 20:23:15 CEST [7518-8] LOG:
>>>>> aborting any active transactions
>>>>> 2018-05-24 20:23:15 CEST [7548-2] LOG:
>>>>> autovacuum launcher shutting down
>>>>> 2018-05-24 20:23:15 CEST [7545-1] LOG:
>>>>> shutting down
>>>>> 2018-05-24 20:23:15 CEST [7545-2] LOG:
>>>>> database system is shut down
>>>>> 2018-05-24 20:23:16 CEST [7568-1] LOG:
>>>>> database system was shut down at 2018-05-24
>>>>> 20:23:15 CEST
>>>>> 2018-05-24 20:23:16 CEST [7568-2] LOG:
>>>>> MultiXact member wraparound protections are
>>>>> now enabled
>>>>> 2018-05-24 20:23:16 CEST [7567-1] LOG:
>>>>> database system is ready to accept connections
>>>>> 2018-05-24 20:23:16 CEST [7572-1] LOG:
>>>>> autovacuum launcher started
>>>>> 2018-05-24 20:23:16 CEST [7574-1]
>>>>> [unknown]@[unknown] LOG: incomplete startup packet
>>>>> 2018-05-24 20:23:39 CEST [7596-1]
>>>>> freeswitch_user at freeswitch_db ERROR: relation
>>>>> "channels" does not exist at character 40
>>>>> 2018-05-24 20:23:39 CEST [7596-2]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as delete from
>>>>> channels where
>>>>> hostname='freeswitch-capa8';EXECUTE
>>>>> "_PLAN0x9f3f90"
>>>>> 2018-05-24 20:23:39 CEST [7596-3]
>>>>> freeswitch_user at freeswitch_db ERROR: relation
>>>>> "calls" does not exist at character 40
>>>>> 2018-05-24 20:23:39 CEST [7596-4]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as delete from calls
>>>>> where hostname='freeswitch-capa8';EXECUTE
>>>>> "_PLAN0x9f3f90"
>>>>> 2018-05-24 20:23:39 CEST [7596-5]
>>>>> freeswitch_user at freeswitch_db ERROR: relation
>>>>> "tasks" does not exist at character 40
>>>>> 2018-05-24 20:23:39 CEST [7596-6]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as delete from tasks
>>>>> where hostname='freeswitch-capa8';EXECUTE
>>>>> "_PLAN0x9f3f90"
>>>>> 2018-05-24 20:23:39 CEST [7596-7]
>>>>> freeswitch_user at freeswitch_db ERROR: relation
>>>>> "aliases" does not exist at character 49
>>>>> 2018-05-24 20:23:39 CEST [7596-8]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as select hostname
>>>>> from aliases;EXECUTE "_PLAN0x9f3f90"
>>>>> 2018-05-24 20:23:39 CEST [7596-9]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax
>>>>> error at or near "DROP" at character 28
>>>>> 2018-05-24 20:23:39 CEST [7596-10]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as DROP TABLE
>>>>> aliases;EXECUTE "_PLAN0x9f3f90"
>>>>> 2018-05-24 20:23:39 CEST [7596-11]
>>>>> freeswitch_user at freeswitch_db ERROR: syntax
>>>>> error at or near "CREATE" at character 28
>>>>> 2018-05-24 20:23:39 CEST [7596-12]
>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>> PREPARE "_PLAN0x9f3f90" as CREATE TABLE aliases (
>>>>> sticky INTEGER,
>>>>> alias VARCHAR(128),
>>>>> command VARCHAR(4096),
>>>>> hostname VARCHAR(256)
>>>>> );
>>>>> ;EXECUTE "_PLAN0x9f3f90"
>>>>>
>>>>> and now freeswitch isn't able to run.
>>>>>
>>>>> If I enable odbc trace in odbcinst.ini
>>>>>
>>>>> Trace=Yes
>>>>> TraceFile=/var/log/odbctrace.log
>>>>>
>>>>> Also there's no output....
>>>>>
>>>>> In freeswitch log also there's nothing about
>>>>> what is happening :(
>>>>>
>>>>>
>>>>> - Blackhold
>>>>> http://blackhold.nusepas.com
>>>>> <http://blackhold.nusepas.com/>
>>>>> @blackhold_
>>>>> ~> cal lluitar contra el fort per deixar de
>>>>> ser febles, i contra nosaltres mateixos quan
>>>>> siguem forts (Xirinacs)
>>>>> <°((( ><
>>>>>
>>>>> 2018-05-24 19:30 GMT+02:00 Michael Jerris
>>>>> <mike at jerris.com <mailto:mike at jerris.com>>:
>>>>>
>>>>> but that table layout is like that because
>>>>> you imported the tables, i was asking what
>>>>> is in the recreated sqlite ones. If it
>>>>> fails to connect like you later describe,
>>>>> its going to fall back, you should see
>>>>> stuff in the fs logs on startup about
>>>>> this. the odbc configs go in the normal
>>>>> place they go in the os, not in fs
>>>>> specific dirs. Those errors tell me
>>>>> something is up, but not sure what, might
>>>>> need to turn on some debug on pg side to
>>>>> see. some of our tests like to see if
>>>>> table schema is right throw errors then we
>>>>> act on them, if you restart a second time
>>>>> you should get a more useful set of errors.
>>>>>
>>>>>
>>>>>> On May 24, 2018, at 1:11 PM, Blackhold
>>>>>> <blackholdmailer at gmail.com
>>>>>> <mailto:blackholdmailer at gmail.com>> wrote:
>>>>>>
>>>>>> Hi,
>>>>>> The tables are:
>>>>>>
>>>>>> ostgres at freeswitch-capa8:~/sql$ psql
>>>>>> freeswitch_db
>>>>>> freeswitch_db-# \dt
>>>>>>
>>>>>> List of relations
>>>>>> Schema | Name | Type | Owner
>>>>>> --------+-------------------------------------+-------+----------
>>>>>> public | aliases | table | postgres
>>>>>> public | calls | table | postgres
>>>>>> public | channels | table | postgres
>>>>>> public | complete | table | postgres
>>>>>> public | db_data | table | postgres
>>>>>> public | fifo_bridge | table |
>>>>>> postgres
>>>>>> public | fifo_callers | table |
>>>>>> postgres
>>>>>> public | fifo_outbound | table |
>>>>>> postgres
>>>>>> public | group_data | table |
>>>>>> postgres
>>>>>> public | interfaces | table |
>>>>>> postgres
>>>>>> public | json_store | table |
>>>>>> postgres
>>>>>> public | limit_data | table |
>>>>>> postgres
>>>>>> public | nat | table | postgres
>>>>>> public | recovery | table | postgres
>>>>>> public | registrations | table |
>>>>>> postgres
>>>>>> public | sip_authentication
>>>>>> | table | postgres
>>>>>> public | sip_dialogs | table |
>>>>>> postgres
>>>>>> public | sip_presence | table |
>>>>>> postgres
>>>>>> public | sip_registrations
>>>>>> | table | postgres
>>>>>> public | sip_shared_appearance_dialogs
>>>>>> | table | postgres
>>>>>> public |
>>>>>> sip_shared_appearance_subscriptions |
>>>>>> table | postgres
>>>>>> public | sip_subscriptions
>>>>>> | table | postgres
>>>>>> public | tasks | table | postgres
>>>>>> public | voicemail_msgs
>>>>>> | table | postgres
>>>>>> public | voicemail_prefs
>>>>>> | table | postgres
>>>>>> (25 rows)
>>>>>>
>>>>>> I continued testing and found that if I
>>>>>> configure switch.conf.xml file like this:
>>>>>>
>>>>>> <param name="core-db-dsn"
>>>>>> value="pgsql://hostaddr=127.0.0.1
>>>>>> dbname=freeswitch_db user=freeswitch_user
>>>>>> password='****' options='-c
>>>>>> client_min_messages=NOTICE'" />
>>>>>>
>>>>>> When I turn on freeswitch, postgresql
>>>>>> don't output nothing. Then I tried to
>>>>>> configure freeswitch using odbc I then
>>>>>> YES I get something in postgresql logs
>>>>>>
>>>>>> For odbc I have something not clear, it
>>>>>> is mandatory to put files in
>>>>>> /usr/local/freeswitch/etc ? or leaving
>>>>>> them at default directory (/etc) is enough?
>>>>>>
>>>>>> Here I show the config of odbc files:
>>>>>> root at freeswitch-capa8:/etc# cat odbc.ini
>>>>>> [freeswitch]
>>>>>> ; WARNING: The old psql odbc driver
>>>>>> psqlodbc.so is now renamed psqlodbcw.so
>>>>>> ; in version 08.x. Note that the library
>>>>>> can also be installed under an other
>>>>>> ; path than /usr/local/lib/ following
>>>>>> your installation.
>>>>>> ; Driver = /usr/lib64/odbc/psqlodbcw.so
>>>>>> ; Driver =
>>>>>> /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so
>>>>>> Driver =
>>>>>> /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
>>>>>> Description=Connection to LDAP/POSTGRESQL
>>>>>> Servername=localhost
>>>>>> Port=5432
>>>>>> Protocol=6.4
>>>>>> FetchBufferSize=99
>>>>>> Username=freeswitch_user
>>>>>> Password=XXX
>>>>>> Database=freeswitch_db
>>>>>> ReadOnly=no
>>>>>> Debug=0
>>>>>> CommLog=0
>>>>>>
>>>>>> root at freeswitch-capa8:/etc# cat odbcinst.ini
>>>>>> [PostgreSQL]
>>>>>> Description = PostgreSQL driver for Linux
>>>>>> & Win32
>>>>>> ;Driver = /usr/lib64/odbc/psqlodbcw.so
>>>>>> Driver =
>>>>>> /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
>>>>>> Threading = 0
>>>>>> MaxLongVarcharSize=65536
>>>>>>
>>>>>> And then connect to psql through odbc
>>>>>>
>>>>>> root at freeswitch-capa8:/etc# isql -v
>>>>>> freeswitch
>>>>>> +---------------------------------------+
>>>>>> | Connected! |
>>>>>> | |
>>>>>> | sql-statement |
>>>>>> | help [tablename] |
>>>>>> | quit |
>>>>>> | |
>>>>>> +---------------------------------------+
>>>>>> SQL>
>>>>>>
>>>>>> Then in file switch.conf.xml I changed db
>>>>>> connection configuration
>>>>>>
>>>>>> root at freeswitch-capa8:/usr/local/freeswitch/conf/autoload_configs#
>>>>>> cat switch.conf.xml |grep core-db-dsn
>>>>>> <param name="core-db-dsn"
>>>>>> value="pgsql://hostaddr=127.0.0.1
>>>>>> dbname=freeswitch_db user=freeswitch_user
>>>>>> password='XXX' options='-c
>>>>>> client_min_messages=NOTICE'" />
>>>>>> <!--<param name="core-db-dsn"
>>>>>> value="freeswitch:freeswitch_user:XXX"/>-->
>>>>>>
>>>>>> Last night SwK user at freenode channel
>>>>>> told me that freeswitch on turning on, it
>>>>>> creates tables at database (thanks SwK).
>>>>>>
>>>>>> I spect that configuration of odbc is
>>>>>> working but drops lot of errors (here you
>>>>>> have some lines):
>>>>>>
>>>>>> 2018-05-24 02:03:25 CEST [3099-338780]
>>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>>> PREPARE "_PLAN0x140bf90" as CREATE TABLE
>>>>>> nat (
>>>>>> sticky INTEGER,
>>>>>> portINTEGER,
>>>>>> protoINTEGER,
>>>>>> hostname VARCHAR(256)
>>>>>> );
>>>>>> ;EXECUTE "_PLAN0x140bf90"
>>>>>> 2018-05-24 02:03:25 CEST [3099-338781]
>>>>>> freeswitch_user at freeswitch_db WARNING:
>>>>>> there is already a transaction in progress
>>>>>> 2018-05-24 02:03:25 CEST [3099-338782]
>>>>>> freeswitch_user at freeswitch_db ERROR:
>>>>>> relation "registrations" does not exist
>>>>>> at character 41
>>>>>> 2018-05-24 02:03:25 CEST [3099-338783]
>>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>>> PREPARE "_PLAN0x140bf90" as delete from
>>>>>> registrations where reg_user='';EXECUTE
>>>>>> "_PLAN0x140bf90"
>>>>>> 2018-05-24 02:03:25 CEST [3099-338784]
>>>>>> freeswitch_user at freeswitch_db WARNING:
>>>>>> there is already a transaction in progress
>>>>>> 2018-05-24 02:03:25 CEST [3099-338785]
>>>>>> freeswitch_user at freeswitch_db ERROR:
>>>>>> syntax error at or near "DROP" at
>>>>>> character 29
>>>>>> 2018-05-24 02:03:25 CEST [3099-338786]
>>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>>> PREPARE "_PLAN0x140bf90" as DROP TABLE
>>>>>> registrations;EXECUTE "_PLAN0x140bf90"
>>>>>> 2018-05-24 02:03:25 CEST [3099-338787]
>>>>>> freeswitch_user at freeswitch_db WARNING:
>>>>>> there is already a transaction in progress
>>>>>> 2018-05-24 02:03:25 CEST [3099-338788]
>>>>>> freeswitch_user at freeswitch_db ERROR:
>>>>>> syntax error at or near "CREATE" at
>>>>>> character 29
>>>>>> 2018-05-24 02:03:25 CEST [3099-338789]
>>>>>> freeswitch_user at freeswitch_db STATEMENT:
>>>>>> PREPARE "_PLAN0x140bf90" as CREATE TABLE
>>>>>> registrations (
>>>>>> reg_user VARCHAR(256),
>>>>>> realm VARCHAR(256),
>>>>>> token VARCHAR(256),
>>>>>> url TEXT,
>>>>>> expires INTEGER,
>>>>>> network_ip VARCHAR(256),
>>>>>> network_port VARCHAR(256),
>>>>>> network_proto VARCHAR(256),
>>>>>> hostname VARCHAR(256),
>>>>>> metadata VARCHAR(256)
>>>>>> );
>>>>>> ;EXECUTE "_PLAN0x140bf90"
>>>>>> 2018-05-24 02:03:25 CEST [3099-338790]
>>>>>> freeswitch_user at freeswitch_db WARNING:
>>>>>> there is already a transaction in progress
>>>>>> 2018-05-24 02:03:25 CEST [3099-338791]
>>>>>> freeswitch_user at freeswitch_db LOG:
>>>>>> unexpected EOF on client connection with
>>>>>> an open transaction
>>>>>>
>>>>>>
>>>>>> I tested with tables in psql database and
>>>>>> without tables in psql database.
>>>>>>
>>>>>> freeswitch at freeswitch-capa8> version
>>>>>> FreeSWITCH Version
>>>>>> 1.9.0+git~20180516T211208Z~3c7db639fd~64bit
>>>>>> (git 3c7db63 2018-05-16 21:12:08Z 64bit)
>>>>>>
>>>>>> As I told in last mail, I'm working with
>>>>>> last git version.
>>>>>>
>>>>>> Then I have a last question, related to
>>>>>> that (db), when it will work, all mods
>>>>>> will save the information to pgsql or a
>>>>>> mix some to sqlite and some to pgsql? I
>>>>>> saw in other files the availibility to
>>>>>> configure also db, like
>>>>>> /usr/local/freeswitch/conf/sip_profiles/internal.xml
>>>>>>
>>>>>> root at freeswitch-capa8:/usr/local/freeswitch/conf#
>>>>>> cat
>>>>>> /usr/local/freeswitch/conf/sip_profiles/internal.xml
>>>>>> |grep db
>>>>>> <!-- Name of the db to use for this
>>>>>> profile -->
>>>>>> <!--<param name="dbname"
>>>>>> value="share_presence"/>-->
>>>>>> <!--<param name="odbc-dsn"
>>>>>> value="dsn:user:pass"/>-->
>>>>>> <!--<param name="odbc-dsn"
>>>>>> value="freeswitch:freeswitch_user:XXX"/>-->
>>>>>> <!-- <param name="odbc-dsn"
>>>>>> value="pgsql://hostaddr=127.0.0.1
>>>>>> dbname=freeswitch_db user=freeswitch_user
>>>>>> password='XXX' options='-c
>>>>>> client_min_messages=NOTICE'
>>>>>> application_name='freeswitch'" /> -->
>>>>>> <!--all inbound reg will stored in the db
>>>>>> using this domain -->
>>>>>> <param name="force-register-db-domain"
>>>>>> value="$${domain}"/>
>>>>>>
>>>>>> The config you see in the mail is the
>>>>>> last configuration I defined. Yesterday I
>>>>>> get lost with wich config work or wich
>>>>>> one no...
>>>>>>
>>>>>> I feel I'm almost at end of this
>>>>>> installation! I'm doing a step by step
>>>>>> manual in spanish to how to install last
>>>>>> version of freeswitch, this will be
>>>>>> public and if you want I could upload to
>>>>>> wiki.
>>>>>>
>>>>>> Thanks you much for your help :)
>>>>>>
>>>>>> References:
>>>>>> https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core
>>>>>> <https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core>
>>>>>> https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN
>>>>>> <https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN>
>>>>>> https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases
>>>>>> <https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases>
>>>>>>
>>>>>>
>>>>>>
>>>>>> - Blackhold
>>>>>> http://blackhold.nusepas.com
>>>>>> <http://blackhold.nusepas.com/>
>>>>>> @blackhold_
>>>>>> ~> cal lluitar contra el fort per deixar
>>>>>> de ser febles, i contra nosaltres
>>>>>> mateixos quan siguem forts (Xirinacs)
>>>>>> <°((( ><
>>>>>>
>>>>>> 2018-05-24 18:21 GMT+02:00 Michael Jerris
>>>>>> <mike at jerris.com <mailto:mike at jerris.com>>:
>>>>>>
>>>>>> what tables are ending up in the
>>>>>> recreated sqlite db? You need to set
>>>>>> it for the modules that use sqlite
>>>>>> too (like for mod_sofia). we have a
>>>>>> global var for this in default configs.
>>>>>>
>>>>>> > On May 23, 2018, at 6:13 PM,
>>>>>> Blackhold <blackholdmailer at gmail.com
>>>>>> <mailto:blackholdmailer at gmail.com>>
>>>>>> wrote:
>>>>>> >
>>>>>> > Hi,
>>>>>> > I have just installed freeswitch 1.9
>>>>>> >
>>>>>> > freeswitch at freeswitch-capa8> version
>>>>>> > FreeSWITCH Version
>>>>>> 1.9.0+git~20180516T211208Z~3c7db639fd~64bit
>>>>>> (git 3c7db63 2018-05-16 21:12:08Z 64bit)
>>>>>> >
>>>>>> > And I'm trying to freeswitch use
>>>>>> postgresql instead sqlitedb.
>>>>>> >
>>>>>> > I have configured the file
>>>>>> switch.conf.xml of
>>>>>> /usr/local/freeswitch/conf/autoload_configs
>>>>>> with uncomenting and configuring this
>>>>>> line
>>>>>> >
>>>>>> > <param name="core-db-dsn"
>>>>>> value="pgsql://hostaddr=127.0.0.1
>>>>>> dbname=freeswitch_db
>>>>>> user=freeswitch_user password='****'
>>>>>> options='-c
>>>>>> client_min_messages=NOTICE'" />
>>>>>> >
>>>>>> > then I exported all sqlitedbs to
>>>>>> sql and then imported to a database
>>>>>> that I have created in postgresql
>>>>>> >
>>>>>> > I have run again
>>>>>> /etc/init.d/freeswitch.sh start
>>>>>> >
>>>>>> > But seems it still is taking sqlitedb.
>>>>>> >
>>>>>> > I tried to move the sqlitedbs files
>>>>>> to other side and turned on again
>>>>>> freeswitch, but it creates sqlitedbs
>>>>>> again.
>>>>>> >
>>>>>> > What I'm missing? what I'm doing
>>>>>> wrong? what could I check?
>>>>>>
>>>>>>
>>>>>> _________________________________________________________________________
>>>>>> Professional FreeSWITCH Consulting
>>>>>> Services:
>>>>>> consulting at freeswitch.org
>>>>>> <mailto:consulting at freeswitch.org>
>>>>>> http://www.freeswitchsolutions.com
>>>>>> <http://www.freeswitchsolutions.com/>
>>>>>>
>>>>>> Official FreeSWITCH Sites
>>>>>> http://www.freeswitch.org
>>>>>> <http://www.freeswitch.org/>
>>>>>> http://confluence.freeswitch.org
>>>>>> <http://confluence.freeswitch.org/>
>>>>>> http://www.cluecon.com
>>>>>> <http://www.cluecon.com/>
>>>>>>
>>>>>> FreeSWITCH-users mailing list
>>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>>> http://www.freeswitch.org
>>>>>> <http://www.freeswitch.org/>
>>>>>>
>>>>>>
>>>>>> _________________________________________________________________________
>>>>>> Professional FreeSWITCH Consulting Services:
>>>>>> consulting at freeswitch.org
>>>>>> <mailto:consulting at freeswitch.org>
>>>>>> http://www.freeswitchsolutions.com
>>>>>> <http://www.freeswitchsolutions.com/>
>>>>>>
>>>>>> Official FreeSWITCH Sites
>>>>>> http://www.freeswitch.org
>>>>>> <http://www.freeswitch.org/>
>>>>>> http://confluence.freeswitch.org
>>>>>> <http://confluence.freeswitch.org/>
>>>>>> http://www.cluecon.com
>>>>>> <http://www.cluecon.com/>
>>>>>>
>>>>>> FreeSWITCH-users mailing list
>>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>>> http://www.freeswitch.org
>>>>>> <http://www.freeswitch.org/>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> Professional FreeSWITCH Consulting Services:
>>>>> consulting at freeswitch.org
>>>>> <mailto:consulting at freeswitch.org>
>>>>> http://www.freeswitchsolutions.com
>>>>> <http://www.freeswitchsolutions.com/>
>>>>>
>>>>> Official FreeSWITCH Sites
>>>>> http://www.freeswitch.org
>>>>> <http://www.freeswitch.org/>
>>>>> http://confluence.freeswitch.org
>>>>> <http://confluence.freeswitch.org/>
>>>>> http://www.cluecon.com
>>>>> <http://www.cluecon.com/>
>>>>>
>>>>> FreeSWITCH-users mailing list
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://www.freeswitch.org
>>>>> <http://www.freeswitch.org/>
>>>>>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> Professional FreeSWITCH Consulting Services:
>>>>> consulting at freeswitch.org
>>>>> <mailto:consulting at freeswitch.org>
>>>>> http://www.freeswitchsolutions.com
>>>>> <http://www.freeswitchsolutions.com>
>>>>>
>>>>> Official FreeSWITCH Sites
>>>>> http://www.freeswitch.org
>>>>> http://confluence.freeswitch.org
>>>>> <http://confluence.freeswitch.org>
>>>>> http://www.cluecon.com
>>>>>
>>>>> FreeSWITCH-users mailing list
>>>>> FreeSWITCH-users at lists.freeswitch.org
>>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>>> http://www.freeswitch.org
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Consulting Services:
>>>> consulting at freeswitch.org
>>>> <mailto:consulting at freeswitch.org>
>>>> http://www.freeswitchsolutions.com
>>>> <http://www.freeswitchsolutions.com>
>>>>
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://confluence.freeswitch.org
>>>> <http://confluence.freeswitch.org>
>>>> http://www.cluecon.com
>>>>
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://www.freeswitch.org
>>>>
>>>>
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Consulting Services:
>>>> consulting at freeswitch.org
>>>> <mailto:consulting at freeswitch.org>
>>>> http://www.freeswitchsolutions.com
>>>> <http://www.freeswitchsolutions.com>
>>>>
>>>> Official FreeSWITCH Sites
>>>> http://www.freeswitch.org
>>>> http://confluence.freeswitch.org
>>>> <http://confluence.freeswitch.org>
>>>> http://www.cluecon.com
>>>>
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>>> http://www.freeswitch.org
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com
>>> <http://www.freeswitchsolutions.com>
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org
>>> <http://confluence.freeswitch.org>
>>> http://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>> http://www.freeswitch.org
>>>
>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com
>>> <http://www.freeswitchsolutions.com>
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org
>>> <http://confluence.freeswitch.org>
>>> http://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>> http://www.freeswitch.org
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>> <http://www.freeswitchsolutions.com>
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> <http://confluence.freeswitch.org>
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>> http://www.freeswitch.org
>>
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>> <http://www.freeswitchsolutions.com>
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>> http://www.freeswitch.org
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
> http://www.freeswitchsolutions.com
> <http://www.freeswitchsolutions.com>
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org <http://confluence.freeswitch.org>
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> <mailto:FreeSWITCH-users at lists.freeswitch.org>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
> http://www.freeswitch.org
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180524/4dca12be/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list