[Freeswitch-users] Connecting freeswitch to postgresql

[Michael Jerris]

it sounds like its actually working?

> On May 25, 2018, at 1:07 PM, Blackhold <blackholdmailer at 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 at 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 at 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"/>-->
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/278926f0/attachment.html>