no, it still don't. It still don't create tables on turning on freeswitch :( - 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-25 19:14 GMT+02:00 Michael Jerris <mike@jerris.com>:
it sounds like its actually working?
On May 25, 2018, at 1:07 PM, Blackhold <blackholdmailer@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@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"/>-->
_________________________________________________________________________ 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