<div dir="ltr">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><br></div><div><div>postgres@freeswitch-capa8:~/sql$ psql -U freeswitch_user -d freeswitch_db --password</div><div>Password for user freeswitch_user: </div><div>psql (9.4.15)</div><div>Type "help" for help.</div><div><br></div><div>freeswitch_db=> CREATE TABLE complete (</div><div>freeswitch_db(>    sticky  INTEGER,</div><div>freeswitch_db(>    a1  VARCHAR(128),</div><div>freeswitch_db(>    a2  VARCHAR(128),</div><div>freeswitch_db(>    a3  VARCHAR(128),</div><div>freeswitch_db(>    a4  VARCHAR(128),</div><div>freeswitch_db(>    a5  VARCHAR(128),</div><div>freeswitch_db(>    a6  VARCHAR(128),</div><div>freeswitch_db(>    a7  VARCHAR(128),</div><div>freeswitch_db(>    a8  VARCHAR(128),</div><div>freeswitch_db(>    a9  VARCHAR(128),</div><div>freeswitch_db(>    a10 VARCHAR(128),</div><div>freeswitch_db(>    hostname VARCHAR(256)</div><div>freeswitch_db(> );</div><div>CREATE TABLE</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','help','','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','help','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','console','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','alert','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','crit','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel','err','','','','','','','','freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> \dt</div><div>              List of relations</div><div> Schema |   Name   | Type  |      Owner      </div><div>--------+----------+-------+-----------------</div><div> public | complete | table | freeswitch_user</div><div>(1 row)</div><div><br></div><div>freeswitch_db=> drop table complete;</div><div>DROP TABLE</div><div>freeswitch_db=> \dt</div><div>No relations found.</div></div><div><br></div><div><br></div><div>I show the db config in the config files (grouped by config line):</div><div><br></div><div><div>root@freeswitch-capa8:/usr/local/freeswitch/conf# grep XXX * -R</div><div><br></div><div><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">autoload_configs/switch.conf.xml:    <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 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">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">' options='-c client_min_messages=NOTICE'" /></span><br></div><div><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"><br></span></div><div>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'" /></div><div>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'" /></div><div>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'" /></div><div>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'" /></div><div>autoload_configs/lcr.conf.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/callcenter.conf.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>jingle_profiles/server.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>sip_profiles/internal.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>sip_profiles/internal-ipv6.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>skinny_profiles/internal.xml:    <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 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">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div><br></div><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">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">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'" /></div></div><div><br></div><div><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">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">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">"/>--> </span></div><div><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">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">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">"/>--></span><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><br>- Blackhold<br><a href="http://blackhold.nusepas.com" target="_blank">http://blackhold.nusepas.com</a><br>@blackhold_<br>~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs)<br><°((( ><</div></div>
<br><div class="gmail_quote">2018-05-24 22:34 GMT+02:00 jungle Boogie <span dir="ltr"><<a href="mailto:jungleboogie0@gmail.com" target="_blank">jungleboogie0@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 24 May 2018 at 11:31, Blackhold <<a href="mailto:blackholdmailer@gmail.com">blackholdmailer@gmail.com</a>> wrote:<br>
> # OK for location of ODBC files<br>
><br>
> # output freeswitch using psql (I only edited switch.conf.xml file)<br>
> <param name="core-db-dsn" value="pgsql://hostaddr=127.0.<wbr>0.1<br>
> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c<br>
> client_min_messages=NOTICE'" /> (switch.conf.xml file)<br>
><br>
> I see no errors related on logs (nor freeswitch, nor psql -debug5-),<br>
> obviously restarted psql to reload config.<br>
<br>
<br>
</span>Does your user have access to the database within postgres?<br>
<div class="HOEnZb"><div class="h5"><br>
______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.<wbr>freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.<wbr>org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a></div></div></blockquote></div><br></div>