[Freeswitch-users] Connecting freeswitch to postgresql

Blackhold blackholdmailer at gmail.com
Fri May 25 20:55:15 UTC 2018


maybe on using configure script doesn't configured freeswitch without PGSQL
support?

https://marc.info/?l=freeswitch-users&m=135482851910677&w=2

./configure --enable-core-pgsql-support --no-create --no-recursion

I have to move from my site a while, in a while I test to configure, make
and make install again...


- 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 22:30 GMT+02:00 Blackhold <blackholdmailer at gmail.com>:

> I revised kvm configuration and firewall is disabled.
>
> also I have set to 1 /proc/sys/net/ipv4/ip_forward and the behaviour is
> the same
>
>
> - 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 22:22 GMT+02:00 Blackhold <blackholdmailer at gmail.com>:
>
>> nope, debian 8 installed by default using net-install iso.
>>
>> I'm inside a kvm machine
>>
>>
>> - 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 22:21 GMT+02:00 Madovsky <infos at madovsky.org>:
>>
>>> any iptables rules activated? SELinux?
>>> On 5/25/2018 1:13 PM, Blackhold wrote:
>>>
>>> root at freeswitch-capa8:/usr/local/freeswitch/log# grep CRIT
>>> freeswitch.log
>>> 2018-05-25 22:11:59.362305 [CRIT] switch_core_sqldb.c:468 Failure! PGSQL
>>> NOT AVAILABLE! Can't connect to DSN hostaddr=127.0.0.1 dbname=freeswitch_db
>>> user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'
>>> application_name='freeswitch'
>>> 2018-05-25 22:11:59.362669 [CRIT] sofia.c:3130 Cannot Open SQL Database
>>> [internal-ipv6]!
>>> 2018-05-25 22:12:00.362142 [CRIT] switch_core_sqldb.c:468 Failure! PGSQL
>>> NOT AVAILABLE! Can't connect to DSN hostaddr=127.0.0.1 dbname=freeswitch_db
>>> user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'
>>> application_name='freeswitch'
>>> 2018-05-25 22:12:00.362145 [CRIT] sofia.c:3130 Cannot Open SQL Database
>>> [internal]!
>>> 2018-05-25 22:12:03.021179 [CRIT] switch_core_sqldb.c:468 Failure! PGSQL
>>> NOT AVAILABLE! Can't connect to DSN hostaddr=127.0.0.1 dbname=freeswitch_db
>>> user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'
>>> application_name='freeswitch'
>>> 2018-05-25 22:12:03.563069 [CRIT] switch_core_sqldb.c:468 Failure! PGSQL
>>> NOT AVAILABLE! Can't connect to DSN hostaddr=127.0.0.1 dbname=freeswitch_db
>>> user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'
>>> application_name='freeswitch'
>>> 2018-05-25 22:12:03.563076 [CRIT] mod_voicemail.c:774 Cannot open 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-25 21:56 GMT+02:00 Madovsky <infos at madovsky.org>:
>>>
>>>> also turn FS to debug level 7 to 9 to see if it tries to connect to the
>>>> database
>>>> On 5/25/2018 11:18 AM, Michael Jerris wrote:
>>>>
>>>> there is an arg to not create schema, its possible thats default on
>>>> odbc, but I didnt think so.  You’ll need to look at the errors and see if
>>>> its trying to create the schema or not.  If it is and its failing, the
>>>> errors should point you to why.
>>>>
>>>> On May 25, 2018, at 2:15 PM, Blackhold <blackholdmailer at gmail.com>
>>>> wrote:
>>>>
>>>> no, it still don't. It still don't create tables on turning on
>>>> freeswitch :(
>>>>
>>>>
>>>> - 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 19:14 GMT+02:00 Michael Jerris <mike at jerris.com>:
>>>>
>>>>> it sounds like its actually working?
>>>>>
>>>>>
>>>>> On May 25, 2018, at 1:07 PM, Blackhold <blackholdmailer at gmail.com>
>>>>> wrote:
>>>>>
>>>>> it seems it is not a permissions problem, 'cause I can create and
>>>>> delete a table and insert registries to the table as user I have created
>>>>>
>>>>> postgres at freeswitch-capa8:~/sql$ psql -U freeswitch_user -d
>>>>> freeswitch_db --password
>>>>> Password for user freeswitch_user:
>>>>> psql (9.4.15)
>>>>> Type "help" for help.
>>>>>
>>>>> freeswitch_db=> CREATE TABLE complete (
>>>>> freeswitch_db(>    sticky  INTEGER,
>>>>> freeswitch_db(>    a1  VARCHAR(128),
>>>>> freeswitch_db(>    a2  VARCHAR(128),
>>>>> freeswitch_db(>    a3  VARCHAR(128),
>>>>> freeswitch_db(>    a4  VARCHAR(128),
>>>>> freeswitch_db(>    a5  VARCHAR(128),
>>>>> freeswitch_db(>    a6  VARCHAR(128),
>>>>> freeswitch_db(>    a7  VARCHAR(128),
>>>>> freeswitch_db(>    a8  VARCHAR(128),
>>>>> freeswitch_db(>    a9  VARCHAR(128),
>>>>> freeswitch_db(>    a10 VARCHAR(128),
>>>>> freeswitch_db(>    hostname VARCHAR(256)
>>>>> freeswitch_db(> );
>>>>> CREATE TABLE
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','help','','
>>>>> ','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> '','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> 'help','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> 'console','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> 'alert','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> 'crit','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',
>>>>> 'err','','','','','','','','freeswitch-capa8');
>>>>> INSERT 0 1
>>>>> freeswitch_db=> \dt
>>>>>               List of relations
>>>>>  Schema |   Name   | Type  |      Owner
>>>>> --------+----------+-------+-----------------
>>>>>  public | complete | table | freeswitch_user
>>>>> (1 row)
>>>>>
>>>>> freeswitch_db=> drop table complete;
>>>>> DROP TABLE
>>>>> freeswitch_db=> \dt
>>>>> No relations found.
>>>>>
>>>>>
>>>>> I show the db config in the config files (grouped by config line):
>>>>>
>>>>> root at freeswitch-capa8:/usr/local/freeswitch/conf# grep XXX * -R
>>>>>
>>>>> autoload_configs/switch.conf.xml:    <param name="core-db-dsn" value="
>>>>> pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user
>>>>> password='U8r9BuntD6iryrKK' options='-c client_min_messages=NOTICE'"
>>>>> />
>>>>>
>>>>> autoload_configs/directory.conf.xml:    <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'" />
>>>>> autoload_configs/voicemail.conf.xml:    <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'" />
>>>>> autoload_configs/cidlookup.conf.xml:    <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'" />
>>>>> autoload_configs/db.conf.xml:    <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'" />
>>>>> autoload_configs/lcr.conf.xml:    <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'" />
>>>>> autoload_configs/callcenter.conf.xml:    <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'" />
>>>>> jingle_profiles/server.xml:    <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'" />
>>>>> sip_profiles/internal.xml:    <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'" />
>>>>> sip_profiles/internal-ipv6.xml:    <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'" />
>>>>> skinny_profiles/internal.xml:    <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'" />
>>>>>
>>>>> autoload_configs/easyroute.conf.xml:    <param name="db-password"
>>>>> value="XXX"/>
>>>>> autoload_configs/easyroute.conf.xml:    <param name="db-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'" />
>>>>>
>>>>> autoload_configs/lcr.conf.xml:    <!--<param name="odbc-dsn"
>>>>> value="freeswitch_db:freeswitch_user:U8r9BuntD6iryrKK"/>-->
>>>>> sip_profiles/internal.xml:    <!--<param name="odbc-dsn"
>>>>> value="freeswitch:freeswitch_user:U8r9BuntD6iryrKK"/>-->
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ____________________________________________________________
>>>>> _____________
>>>>> 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/freeswitch-users
>>> http://www.freeswitch.org
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/9e7b81ba/attachment-0001.html>


More information about the FreeSWITCH-users mailing list