<div dir="ltr">no, it still don't. It still don't create tables on turning on freeswitch :(</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><br>- Blackhold<br><a href="http://blackhold.nusepas.com" target="_blank">http://blackhold.nusepas.com</a><br>@blackhold_<br>~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs)<br><°((( ><</div></div>
<br><div class="gmail_quote">2018-05-25 19:14 GMT+02:00 Michael Jerris <span dir="ltr"><<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word;line-break:after-white-space">it sounds like its actually working?<div><div class="h5"><br><div><br><blockquote type="cite"><div>On May 25, 2018, at 1:07 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank">blackholdmailer@gmail.com</a>> wrote:</div><br class="m_-1201048498107052003Apple-interchange-newline"><div><div dir="ltr">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<div><br></div><div><div>postgres@freeswitch-capa8:~/<wbr>sql$ psql -U freeswitch_user -d freeswitch_db --password</div><div>Password for user freeswitch_user: </div><div>psql (9.4.15)</div><div>Type "help" for help.</div><div><br></div><div>freeswitch_db=> CREATE TABLE complete (</div><div>freeswitch_db(> sticky INTEGER,</div><div>freeswitch_db(> a1 VARCHAR(128),</div><div>freeswitch_db(> a2 VARCHAR(128),</div><div>freeswitch_db(> a3 VARCHAR(128),</div><div>freeswitch_db(> a4 VARCHAR(128),</div><div>freeswitch_db(> a5 VARCHAR(128),</div><div>freeswitch_db(> a6 VARCHAR(128),</div><div>freeswitch_db(> a7 VARCHAR(128),</div><div>freeswitch_db(> a8 VARCHAR(128),</div><div>freeswitch_db(> a9 VARCHAR(128),</div><div>freeswitch_db(> a10 VARCHAR(128),</div><div>freeswitch_db(> hostname VARCHAR(256)</div><div>freeswitch_db(> );</div><div>CREATE TABLE</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','help','','<wbr>','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'','','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'help','','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'console','','','','','','',''<wbr>,'freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'alert','','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'crit','','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> INSERT INTO "complete" VALUES(0,'console','loglevel',<wbr>'err','','','','','','','','<wbr>freeswitch-capa8');</div><div>INSERT 0 1</div><div>freeswitch_db=> \dt</div><div> List of relations</div><div> Schema | Name | Type | Owner </div><div>--------+----------+-------+--<wbr>---------------</div><div> public | complete | table | freeswitch_user</div><div>(1 row)</div><div><br></div><div>freeswitch_db=> drop table complete;</div><div>DROP TABLE</div><div>freeswitch_db=> \dt</div><div>No relations found.</div></div><div><br></div><div><br></div><div>I show the db config in the config files (grouped by config line):</div><div><br></div><div><div>root@freeswitch-capa8:/usr/<wbr>local/freeswitch/conf# grep XXX * -R</div><div><br></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">autoload_configs/switch.conf.<wbr>xml: <param name="core-db-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline">U8r9BuntD6iryrKK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">' options='-c client_min_messages=NOTICE'" /></span><br></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline"><br></span></div><div>autoload_configs/directory.<wbr>conf.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/voicemail.<wbr>conf.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/cidlookup.<wbr>conf.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/db.conf.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/lcr.conf.xml:<wbr> <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>autoload_configs/callcenter.<wbr>conf.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>jingle_profiles/server.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>sip_profiles/internal.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>sip_profiles/internal-ipv6.<wbr>xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div><div>skinny_profiles/internal.xml: <param name="odbc-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">XXX</span>' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div><br></div><div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">autoload_configs/easyroute.<wbr>conf.xml: <param name="db-password" value="XXX"/></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">autoload_configs/easyroute.<wbr>conf.xml: <param name="db-dsn" value="<a>pgsql://hostaddr=127.0.<wbr>0.1</a> dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /></div></div><div><br></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">autoload_configs/lcr.conf.xml:<wbr> <!--<param name="odbc-dsn" value="freeswitch_db:<wbr>freeswitch_user:</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline">U8r9BuntD6iryr<wbr>KK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">"/>--> </span></div><div><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">sip_profiles/internal.xml: <!--<param name="odbc-dsn" value="freeswitch:freeswitch_<wbr>user:</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255);float:none;display:inline">U8r9BuntD6iryrKK</span><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">"/>--></span><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"></div></div></blockquote></div><br></div></div></div><br>______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.<wbr>freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.<wbr>org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>