THAT'S IT!!! all time has no support for psql now on configuring and compiling it creates the tables! \o/ hurrah! Thanks you much! I have learnt a lot! :) - 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:55 GMT+02:00 Blackhold <blackholdmailer@gmail.com>:
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@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@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@madovsky.org>:
any iptables rules activated? SELinux? On 5/25/2018 1:13 PM, Blackhold wrote:
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/free switch-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/free switch-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/free switch-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/free switch-users http://www.freeswitch.org