[Freeswitch-users] Connecting freeswitch to postgresql
Madovsky
infos at madovsky.org
Fri May 25 20:21:45 UTC 2018
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
> <mailto: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 <mailto: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 <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
>>> <mailto:mike at jerris.com>>:
>>>
>>> it sounds like its actually working?
>>>
>>>
>>>> On May 25, 2018, at 1:07 PM, Blackhold
>>>> <blackholdmailer at gmail.com
>>>> <mailto: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.co
>>>> <http://callcenter.co>nf.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 <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com
>>> <http://www.freeswitchsolutions.com/>
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org <http://www.freeswitch.org/>
>>> http://confluence.freeswitch.org
>>> <http://confluence.freeswitch.org/>
>>> http://www.cluecon.com <http://www.cluecon.com/>
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>> http://www.freeswitch.org <http://www.freeswitch.org/>
>>>
>>>
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Consulting Services:
>>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>>> http://www.freeswitchsolutions.com
>>> <http://www.freeswitchsolutions.com>
>>>
>>> Official FreeSWITCH Sites
>>> http://www.freeswitch.org
>>> http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>>> http://www.cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>>> http://www.freeswitch.org
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>> <http://www.freeswitchsolutions.com>
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org <http://confluence.freeswitch.org>
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> <mailto:FreeSWITCH-users at lists.freeswitch.org>
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
>> http://www.freeswitch.org
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
> http://www.freeswitchsolutions.com
> <http://www.freeswitchsolutions.com>
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org <http://confluence.freeswitch.org>
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> <mailto:FreeSWITCH-users at lists.freeswitch.org>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> <http://lists.freeswitch.org/mailman/options/freeswitch-users>
> http://www.freeswitch.org
>
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> 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/f4536846/attachment-0001.html>
More information about the FreeSWITCH-users
mailing list