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/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.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.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