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"/>--> - 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-24 22:34 GMT+02:00 jungle Boogie <jungleboogie0@gmail.com>:
On 24 May 2018 at 11:31, Blackhold <blackholdmailer@gmail.com> wrote:
# OK for location of ODBC files
# output freeswitch using psql (I only edited switch.conf.xml file) <param name="core-db-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE'" /> (switch.conf.xml file)
I see no errors related on logs (nor freeswitch, nor psql -debug5-), obviously restarted psql to reload config.
Does your user have access to the database within postgres?
_________________________________________________________________________ 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