[Freeswitch-users] Connecting freeswitch to postgresql

Blackhold blackholdmailer at gmail.com
Fri May 25 00:18:15 UTC 2018


uh... I started searching for db string in files and the first I have seen
it asks for an other variables, and the line that I have to activate is not
to de db connection. So then, which options I have to configure to get it
working?

the file is:

root at freeswitch-capa8:/usr/local/freeswitch/conf/sip_profiles# vi
external-ipv6.xml

    <!-- used to share presence info across sofia profiles
         manage-presence needs to be set to passive on this profile
         if you want it to behave as if it were the internal profile
         for presence.
    -->
    <!-- Name of the db to use for this profile -->
    <!--<param name="dbname" value="share_presence"/>-->
    <!--<param name="presence-hosts" value="$${domain}"/>-->
    <!--<param name="force-register-domain" value="$${domain}"/>-->
    <!--all inbound reg will stored in the db using this domain -->
    <!--<param name="force-register-db-domain" value="$${domain}"/>-->
    <!-- ************************************************* -->



- 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-25 2:13 GMT+02:00 Blackhold <blackholdmailer at gmail.com>:

> wich string I have to add?
>
> <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'" />
>
> or
>
> <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'" />
>
> ?
>
> for example for file conf/sip_profiles/internal.xml:231
>
> wich modules needs db connection?
>
> thanks!
>
>
>
>
> - 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-25 1:33 GMT+02:00 Madovsky <infos at madovsky.org>:
>
>> if you set pgsql:// in switch.conf.xml so
>>
>> you must set pgsql:// in every config where a DB is involved
>> On 5/24/2018 4:11 PM, Blackhold wrote:
>>
>> what or wich is the sip profile?
>>
>> I understand that all tables that are created in sqlite are the ones that
>> have to create to psql database that I'm refering all time...
>>
>> The configs I'm showing all time are the real config (only changing
>> password value)
>>
>> 2018-05-25 0:43 GMT+02:00 Madovsky <infos at madovsky.org>:
>>
>>> 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>:
>>>
>>>> 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/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/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/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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/ca945674/attachment-0001.html>


More information about the FreeSWITCH-users mailing list