[Freeswitch-users] Connecting freeswitch to postgresql

Michael Jerris mike at jerris.com
Fri May 25 18:18:39 UTC 2018 

there is an arg to not create schema, its possible thats default on odbc, but I didnt think so.  You’ll need to look at the errors and see if its trying to create the schema or not.  If it is and its failing, the errors should point you to why.

> On May 25, 2018, at 2:15 PM, Blackhold <blackholdmailer at gmail.com> wrote:
> 
> no, it still don't. It still don't create tables on turning on freeswitch :(
> 
> 
> - Blackhold
> http://blackhold.nusepas.com <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-25 19:14 GMT+02:00 Michael Jerris <mike at jerris.com <mailto:mike at jerris.com>>:
> it sounds like its actually working?
> 
> 
>> On May 25, 2018, at 1:07 PM, Blackhold <blackholdmailer at gmail.com <mailto: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"/>-->
>> 
>> 
> 
> 
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org <mailto:consulting at freeswitch.org>
> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org <http://www.freeswitch.org/>
> http://confluence.freeswitch.org <http://confluence.freeswitch.org/>
> http://www.cluecon.com <http://www.cluecon.com/>
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org <mailto:FreeSWITCH-users at lists.freeswitch.org>
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users>
> http://www.freeswitch.org <http://www.freeswitch.org/>
> 
> _________________________________________________________________________
> 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/2854415e/attachment-0001.html>

More information about the FreeSWITCH-users mailing list