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