[Freeswitch-users] Connecting freeswitch to postgresql
Blackhold
blackholdmailer at gmail.com
Thu May 24 22:20:48 UTC 2018
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>:
> 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>:
>
>> 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 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-ins
>> taller.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>:
>>
>>> 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>:
>>>
>>>> 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>
>>>> 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
>>>> @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>:
>>>>
>>>>> # 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
>>>>> @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>:
>>>>>
>>>>>> 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>
>>>>>> 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_u
>>>>>> ser: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,
>>>>>> port INTEGER,
>>>>>> proto INTEGER,
>>>>>> 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_u
>>>>>> ser: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/Postgre
>>>>>> SQL+in+the+core
>>>>>> https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN
>>>>>> https://freeswitch.org/confluence/display/FREESWITCH/FreeSWI
>>>>>> TCH+Databases
>>>>>>
>>>>>>
>>>>>>
>>>>>> - 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 18:21 GMT+02:00 Michael Jerris <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>
>>>>>>> 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
>>>>>>> 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/free
>>>>>>> switch-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/free
>>>>>> switch-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/free
>>>>>> switch-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/free
>>>> switch-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/free
>>>> switch-users
>>>> http://www.freeswitch.org
>>>>
>>>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>>>
>>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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
>>>
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>>
>> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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
>>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://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/20180525/af2842f3/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list