[Freeswitch-users] Connecting freeswitch to postgresql

Blackhold blackholdmailer at gmail.com
Fri May 25 17:07:56 UTC 2018 

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"/>-->



- 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 at gmail.com>:

> On 24 May 2018 at 11:31, Blackhold <blackholdmailer at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180525/0621bebd/attachment-0001.html>

More information about the FreeSWITCH-users mailing list