root@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@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@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@jerris.com>:
it sounds like its actually working?
On May 25, 2018, at 1:07 PM, Blackhold <blackholdmailer@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@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@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@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@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@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@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@freeswitch.orghttp://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org