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