<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">it sounds like its actually working?<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On May 25, 2018, at 1:07 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com" class="">blackholdmailer@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">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<div class=""><br class=""></div><div class=""><div class="">postgres@freeswitch-capa8:~/sql$ psql -U freeswitch_user -d freeswitch_db --password</div><div class="">Password for user freeswitch_user: </div><div class="">psql (9.4.15)</div><div class="">Type "help" for help.</div><div class=""><br class=""></div><div class="">freeswitch_db=> CREATE TABLE complete (</div><div class="">freeswitch_db(> sticky INTEGER,</div><div class="">freeswitch_db(> a1 VARCHAR(128),</div><div class="">freeswitch_db(> a2 VARCHAR(128),</div><div class="">freeswitch_db(> a3 VARCHAR(128),</div><div class="">freeswitch_db(> a4 VARCHAR(128),</div><div class="">freeswitch_db(> a5 VARCHAR(128),</div><div class="">freeswitch_db(> a6 VARCHAR(128),</div><div class="">freeswitch_db(> a7 VARCHAR(128),</div><div class="">freeswitch_db(> a8 VARCHAR(128),</div><div class="">freeswitch_db(> a9 VARCHAR(128),</div><div class="">freeswitch_db(> a10 VARCHAR(128),</div><div class="">freeswitch_db(> hostname VARCHAR(256)</div><div class="">freeswitch_db(> );</div><div class="">CREATE TABLE</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','help','','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','help','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','console','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','alert','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','crit','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','err','','','','','','','','freeswitch-capa8');</div><div class="">INSERT 0 1</div><div class="">freeswitch_db=> \dt</div><div class=""> List of relations</div><div class=""> Schema | Name | Type | Owner </div><div class="">--------+----------+-------+-----------------</div><div class=""> public | complete | table | freeswitch_user</div><div class="">(1 row)</div><div class=""><br class=""></div><div class="">freeswitch_db=> drop table complete;</div><div class="">DROP TABLE</div><div class="">freeswitch_db=> \dt</div><div class="">No relations found.</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">I show the db config in the config files (grouped by config line):</div><div class=""><br class=""></div><div class=""><div class="">root@freeswitch-capa8:/usr/local/freeswitch/conf# grep XXX * -R</div><div class=""><br class=""></div><div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">autoload_configs/switch.conf.xml: <param name="core-db-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline" class="">U8r9BuntD6iryrKK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">' options='-c client_min_messages=NOTICE'" /></span><br class=""></div><div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class=""><br class=""></span></div><div class="">autoload_configs/directory.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">autoload_configs/voicemail.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">autoload_configs/cidlookup.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">autoload_configs/db.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">autoload_configs/lcr.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">autoload_configs/callcenter.conf.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">jingle_profiles/server.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">sip_profiles/internal.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">sip_profiles/internal-ipv6.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div class="">skinny_profiles/internal.xml: <param name="odbc-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div class=""><br class=""></div><div class=""><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial" class="">autoload_configs/easyroute.conf.xml: <param name="db-password" value="XXX"/></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial" class="">autoload_configs/easyroute.conf.xml: <param name="db-dsn" value="<a href="pgsql://hostaddr=127.0.0.1" class="">pgsql://hostaddr=127.0.0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div class=""><br class=""></div><div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">autoload_configs/lcr.conf.xml: <!--<param name="odbc-dsn" value="freeswitch_db:freeswitch_user:</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline" class="">U8r9BuntD6iryrKK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">"/>--> </span></div><div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">sip_profiles/internal.xml: <!--<param name="odbc-dsn" value="freeswitch:freeswitch_user:</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline" class="">U8r9BuntD6iryrKK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">"/>--></span><br class=""></div><div class=""><br class=""></div></div><div class="gmail_extra"><br clear="all" class=""></div></div></blockquote></div><br class=""></body></html>