<div dir="ltr"><div>it seems nothing... yes tells something, but no one error, it seems all modules are loaded ok.</div><div><br></div><div><br></div><div><div>2018-05-24 22:58:20.552211 [INFO] sofia.c:5987 Setting MAX Auth Validity to 0 Attempts</div></div><div><br></div><div><div>2018-05-24 22:58:20.557248 [INFO] switch_core_sqldb.c:1693 sofia:external Starting SQL thread.</div></div><div><br></div><div><div><div>2018-05-24 22:58:20.562295 [NOTICE] sofia.c:4172 Adding Alias [10.90.226.83] for profile [internal]</div><div>2018-05-24 22:58:20.562424 [WARNING] sofia.c:2285 MSG Thread 0 Started</div></div></div><div><br></div><div>2018-05-24 22:58:22.059111 [CONSOLE] switch_loadable_module.c:1540 Successfully Loaded [mod_db]</div><div>2018-05-24 22:58:22.059118 [NOTICE] switch_loadable_module.c:292 Adding Application 'db'</div><div>2018-05-24 22:58:22.059128 [NOTICE] switch_loadable_module.c:292 Adding Application 'group'</div><div>2018-05-24 22:58:22.059137 [NOTICE] switch_loadable_module.c:338 Adding API Function 'db'</div><div>2018-05-24 22:58:22.059146 [NOTICE] switch_loadable_module.c:338 Adding API Function 'group'</div><div>2018-05-24 22:58:22.059154 [NOTICE] switch_loadable_module.c:556 Adding Limit interface 'db'</div><div><br></div></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-24 23:23 GMT+02:00 Madovsky <span dir="ltr"><<a href="mailto:infos@madovsky.org" target="_blank">infos@madovsky.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div text="#000000" bgcolor="#FFFFFF">
    <p>and anything in FS logs?</p>
    <div class="m_1948172350244949374moz-cite-prefix">On 5/24/2018 1:59 PM, Blackhold wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">done, restarted psql and turned on freeswitch,
        nothing in psql log files, no tables where created.
        <div><br>
        </div>
        <div>using psql conector</div>
      </div>
      <div class="gmail_extra"><br clear="all">
        <div>
          <div class="m_1948172350244949374gmail_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-24 22:41 GMT+02:00 Madovsky <span dir="ltr"><<a href="mailto:infos@madovsky.org" target="_blank">infos@madovsky.org</a>></span>:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div text="#000000" bgcolor="#FFFFFF">
              <p>remove these 2 lines<br>
              </p>
              <p>local   all             postgres                       
                        peer<br>
              </p>
              <p>local   all             all                           
                         peer<br>
              </p>
              <div>and replace with<br>
              </div>
              <p>local   all all  trust</p>
              <p>in your pg_hba.conf</p>
              <p><br>
              </p>
              <div class="m_1948172350244949374m_6786559865130825391moz-cite-prefix">On
                5/24/2018 1:26 PM, Blackhold wrote:<br>
              </div>
              <blockquote type="cite">
                <div dir="ltr">Hi,
                  <div><br>
                  </div>
                  <div>I'm trying both ways, switching between one and
                    the other... I initially want to use psql directly,
                    not using odbc, but when using directly I get less
                    info, well... logs files don't say nothing :( if the
                    correct way is to use that:</div>
                  <div><br>
                  </div>
                  <div>
                    <div><param name="core-db-dsn"
                      value="pgsql://hostaddr=127.0.<wbr>0.1
                      dbname=freeswitch_db user=freeswitch_user
                      password='XXX' options='-c
                      client_min_messages=NOTICE'" /></div>
                  </div>
                  <div><br>
                  </div>
                  <div>so then, I only will use that, and the problem is
                    my system, not freeswitch.</div>
                  <div><br>
                  </div>
                  <div>odbc configuration is an old odbc configuration
                    that I used some time ago when I had to use it...
                    so... for actual psql db wich version is the ok?!</div>
                  <div><br>
                  </div>
                  <div>Here you have the versions of libraries I have:</div>
                  <div><br>
                  </div>
                  <div># debian 8 fresh install (x86_64)</div>
                  <div><br>
                  </div>
                  <div>
                    <div>root@freeswitch-capa8:~# cat
                      /etc/debian_version </div>
                    <div>8.10</div>
                    <div>root@freeswitch-capa8:~# dpkg -l |grep
                      postgresql</div>
                    <div>ii  odbc-postgresql:amd64             
                       1:09.03.0300-1                     amd64       
                      ODBC driver for PostgreSQL</div>
                    <div>ii  postgresql                         
                      9.4+165+deb8u3                     all         
                      object-relational SQL database (supported version)</div>
                    <div>ii  postgresql-9.4                     
                      9.4.15-0+deb8u1                    amd64       
                      object-relational SQL database, version 9.4 server</div>
                    <div>ii  postgresql-client                 
                       9.4+165+deb8u3                     all         
                      front-end programs for PostgreSQL (supported
                      version)</div>
                    <div>ii  postgresql-client-9.4             
                       9.4.15-0+deb8u1                    amd64       
                      front-end programs for PostgreSQL 9.4</div>
                    <div>ii  postgresql-client-common           
                      165+deb8u3                         all         
                      manager for multiple PostgreSQL client versions</div>
                    <div>ii  postgresql-common                 
                       165+deb8u3                         all         
                      PostgreSQL database-cluster manager</div>
                    <div>root@freeswitch-capa8:~# dpkg -l |grep libpq</div>
                    <div>ii  libpq-dev                         
                       9.4.15-0+deb8u1                    amd64       
                      header files for libpq5 (PostgreSQL library)</div>
                    <div>ii  libpq5:amd64                       
                      9.4.15-0+deb8u1                    amd64       
                      PostgreSQL C client library</div>
                  </div>
                  <div><br>
                  </div>
                  <div>all these packages are downloaded from sources</div>
                  <div><br>
                  </div>
                  <div>the lines enabled at pg_hba.conf are these (the
                    debian default ones)</div>
                  <div><br>
                  </div>
                  <div>local   all             postgres                 
                                  peer<br>
                    <div>local   all             all                   
                                       peer</div>
                  </div>
                  <div>
                    <div>host    all             all             <a href="http://127.0.0.1/32" target="_blank">127.0.0.1/32</a>         
                        md5</div>
                  </div>
                  <div>
                    <div>host    all             all           
                       ::1/128                 md5</div>
                  </div>
                  <div><br>
                  </div>
                  <div>the script that I have used to do the
                    installation is the one located in source code</div>
                  <div><br>
                  </div>
                  <div>
                    <div>root@freeswitch-capa8:/usr/src<wbr>/freeswitch/scripts#
                      ls -l |grep raspbian-installer</div>
                    <div>-rwxr-xr-x 1 root root 7922 May 23 20:26
                      FreeSWITCH-debian-raspbian-ins<wbr>taller.sh</div>
                  </div>
                  <div><br>
                  </div>
                  <div><br>
                  </div>
                </div>
                <div class="gmail_extra"><br clear="all">
                  <div>
                    <div class="m_1948172350244949374m_6786559865130825391gmail_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-24 21:58 GMT+02:00
                    Madovsky <span dir="ltr"><<a href="mailto:infos@madovsky.org" target="_blank">infos@madovsky.org</a>></span>:<br>
                    <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                      <div text="#000000" bgcolor="#FFFFFF">
                        <p>First of all, pgsql:// does not use odbc,
                          instead use odbc:// to use odbc (btw your
                          odbc.ini file shows Protocol=6.4 (!?) are you
                          using</p>
                        <p>postgresql 6.x !??!)</p>
                        <p>what version of postgresql are you using?
                          compiled yourself or from system package?</p>
                        <p>check if there are not multiple versions of
                          libpq.xx in your system.</p>
                        <p>check pg_hba.conf if localhost is on trust
                          mode for all local users.</p>
                        <p>if you compiled yourself so be sure the right
                          libpq.xx have been chosen.<br>
                        </p>
                        <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-cite-prefix">On
                          5/24/2018 12:33 PM, Blackhold wrote:<br>
                        </div>
                        <blockquote type="cite">
                          <div dir="ltr">nope, it is not able to create
                            stuff
                            <div><br>
                            </div>
                            <div>now I also have enabled that in
                              switch.conf.xml</div>
                            <div><br>
                            </div>
                            <div>
                              <div>    <param
                                name="auto-create-schemas"
                                value="true"/></div>
                              <div>    <param name="auto-clear-sql"
                                value="true"/></div>
                            </div>
                            <div><br>
                            </div>
                            <div>tested with odbc and directly with psql
                              and behaviour is the same.</div>
                            <div><br>
                            </div>
                            <div>for psql the procedure I have followed
                              is</div>
                            <div><br>
                            </div>
                            <div>
                              <div>root@freeswitch-capa8:~# su -
                                postgres</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">root@freeswitch-capa8:~#<span> </span></span>postg<wbr>res@freeswitch-capa8:~$ create<wbr>user
                                freeswitch_user</div>
                            </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">root@freeswitch-capa8:~#<span> </span></span>creat<wbr>edb
                              -O freeswitch_user freeswitch_db<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">root@freeswitch-capa8:~#<span> </span></span>psql
                              freeswitch_db<br>
                            </div>
                            <div>freeswitch_db=# ALTER USER
                              freeswitch_user WITH PASSWORD 'XXX';<br>
                            </div>
                            <div>freeswitch_db=# GRANT ALL PRIVILEGES ON
                              ALL TABLES IN SCHEMA public TO
                              freeswitch_user;<br>
                            </div>
                            <div>freeswitch_db=# GRANT ALL PRIVILEGES ON
                              ALL SEQUENCES IN SCHEMA public TO
                              freeswitch_user;<br>
                            </div>
                            <div><br>
                            </div>
                            <div>the most beatiful was with odbc +
                              tables created... in the last mail...
                              freeswitch turned on, in other ways
                              freeswitch doesn't turns on.</div>
                            <div><br>
                            </div>
                            <div>logs doesn't talk about permissions....</div>
                            <div><br>
                            </div>
                            <div><br>
                            </div>
                          </div>
                          <div class="gmail_extra"><br clear="all">
                            <div>
                              <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330gmail_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-24 21:20
                              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">you
                                  shouldn't need to pre-import the
                                  tables, if the permissions are right,
                                  it should create the tables and
                                  indexes for you.
                                  <div>
                                    <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330h5">
                                      <div><br>
                                        <div><br>
                                          <blockquote type="cite">
                                            <div>On May 24, 2018, at
                                              3:15 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank">blackholdmailer@gmail.com</a>>
                                              wrote:</div>
                                            <br class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197Apple-interchange-newline">
                                            <div>
                                              <div dir="ltr">I continue
                                                with tests
                                                <div><br>
                                                </div>
                                                <div>I think I know wich
                                                  problem I had with
                                                  errors</div>
                                                <div><br>
                                                </div>
                                                <div>I have missed to
                                                  grant privileges in
                                                  psql:</div>
                                                <div><br>
                                                </div>
                                                <div>
                                                  <div>GRANT ALL
                                                    PRIVILEGES ON ALL
                                                    TABLES IN SCHEMA
                                                    public TO
                                                    freeswitch_user;</div>
                                                  <div>GRANT ALL
                                                    PRIVILEGES ON ALL
                                                    SEQUENCES IN SCHEMA
                                                    public TO
                                                    freeswitch_user;</div>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div># with tables
                                                  imported from sqlite
                                                  it shows (freeswitch
                                                  runs)</div>
                                                <div><br>
                                                </div>
                                                <div>
                                                  <div>root@freeswitch-capa8:/var/log<wbr>/postgresql#
                                                    tail -f
                                                    postgresql-9.4-main.log </div>
                                                  <div><br>
                                                  </div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-1]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-2]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    recovery1 on
                                                    recovery(technology);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-3]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-4]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    recovery2 on
                                                    recovery(profile_name);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-5]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-6]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    recovery3 on
                                                    recovery(uuid);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-7]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-8]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    recovery3 on
                                                    recovery(runtime_uuid);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-9]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-10]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index alias1
                                                    on aliases
                                                    (alias);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-11]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-12]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index tasks1
                                                    on tasks
                                                    (hostname,task_id);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-13]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-14]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete1 on
                                                    complete
                                                    (a1,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-15]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-16]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete2 on
                                                    complete
                                                    (a2,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-17]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-18]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete3 on
                                                    complete
                                                    (a3,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-19]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-20]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete4 on
                                                    complete
                                                    (a4,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-21]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-22]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete5 on
                                                    complete
                                                    (a5,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-23]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-24]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete6 on
                                                    complete
                                                    (a6,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-25]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-26]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete7 on
                                                    complete
                                                    (a7,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-27]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-28]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete8 on
                                                    complete
                                                    (a8,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-29]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-30]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete9 on
                                                    complete
                                                    (a9,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-31]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-32]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete10 on
                                                    complete
                                                    (a10,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-33]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-34]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    complete11 on
                                                    complete
                                                    (a1,a2,a3,a4,a5,a6,a7,a8,a9,a1<wbr>0,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-35]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-36]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    nat_map_port_proto
                                                    on nat
                                                    (port,proto,hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-37]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-38]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    channels1 on
                                                    channels(hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-39]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-40]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index calls1
                                                    on
                                                    calls(hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-41]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-42]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index chidx1
                                                    on channels
                                                    (hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-43]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-44]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index uuindex
                                                    on channels (uuid,
                                                    hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-45]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-46]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    uuindex2 on channels
                                                    (call_uuid);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-47]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-48]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    callsidx1 on calls
                                                    (hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-49]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-50]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    eruuindex on calls
                                                    (caller_uuid,
                                                    hostname);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-51]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-52]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    eeuuindex on calls
                                                    (callee_uuid);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-53]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-54]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    eeuuindex2 on calls
                                                    (call_uuid);EXECUTE
                                                    "_PLAN0x123ff90"</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-55]
                                                    freeswitch_user@freeswitch_db
                                                    ERROR:  syntax error
                                                    at or near "create"
                                                    at character 29</div>
                                                  <div>2018-05-24
                                                    21:03:34 CEST
                                                    [8623-56]
                                                    freeswitch_user@freeswitch_db
                                                    STATEMENT:  PREPARE
                                                    "_PLAN0x123ff90" as
                                                    create index
                                                    regindex1 on
                                                    registrations
                                                    (reg_user,realm,hostname);EXEC<wbr>UTE
                                                    "_PLAN0x123ff90"</div>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div># with a clean
                                                  database</div>
                                                <div><br>
                                                </div>
                                                <div>start dropping last
                                                  errors, and don't
                                                  create any table in
                                                  db. Freeswitch doesn't
                                                  turns on.</div>
                                                <div><br>
                                                </div>
                                                <div>each time I stop
                                                  freeswitch when it
                                                  don't runs, it keeps a
                                                  process running that I
                                                  have to kill manually</div>
                                                <div><br>
                                                </div>
                                                <div>
                                                  <div>root@freeswitch-capa8:/var/log<wbr>/postgresql#  ps
                                                    aux |grep free</div>
                                                  <div>root      8706
                                                    39.6  0.7 141296
                                                    15244 ?       
                                                    S<l  21:08   1:13
/usr/local/freeswitch/bin/free<wbr>switch -nc</div>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div><br>
                                                </div>
                                                <div># with granted
                                                  permisions if I turn
                                                  configuration to not
                                                  use odbc, using psql
                                                  directly</div>
                                                <div><br>
                                                </div>
                                                <div>freeswitch turns
                                                  on, there's no errors
                                                  in psql log file and
                                                  no table was created
                                                  on db.</div>
                                                <div><br>
                                                </div>
                                              </div>
                                              <div class="gmail_extra"><br clear="all">
                                                <div>
                                                  <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197gmail_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-24
                                                  20:31 GMT+02:00
                                                  Blackhold <span dir="ltr"><<a href="mailto:blackholdmailer@gmail.com" target="_blank">blackholdmailer@gmail.com</a>></span>:<br>
                                                  <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                                    <div dir="ltr"># OK
                                                      for location of
                                                      ODBC files
                                                      <div><br>
                                                      </div>
                                                      <div># output
                                                        freeswitch using
                                                        psql (I only
                                                        edited
                                                        switch.conf.xml
                                                        file)</div>
                                                      <div><param
                                                        name="core-db-dsn"
                                                        value="<a>pgsql://hostaddr=127.0</a>.<wbr>0.1
dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE'" /> (switch.conf.xml file)<br>
                                                      </div>
                                                      <div><br>
                                                      </div>
                                                      <div>I see no
                                                        errors related
                                                        on logs (nor
                                                        freeswitch, nor
                                                        psql -debug5-),
                                                        obviously
                                                        restarted psql
                                                        to reload
                                                        config.</div>
                                                      <div><br>
                                                      </div>
                                                      <div>in
                                                        sofia.conf.xml
                                                        file I found no
                                                        option to
                                                        configure it
                                                        pointing to
                                                        database</div>
                                                      <div>no other
                                                        config file,
                                                        except
                                                        switch.conf.xml
                                                        has configured
                                                        database
                                                        pointing</div>
                                                      <div><br>
                                                      </div>
                                                      <div>I tried to
                                                        configure db.conf.xml
                                                        file, with
                                                        switch.conf.xml
                                                        line but also do
                                                        nothing</div>
                                                      <div><br>
                                                      </div>
                                                      <div># output
                                                        freeswtich using
                                                        odbc</div>
                                                      <div><param
                                                        name="core-db-dsn"
value="freeswitch:freeswitch_u<wbr>ser:XXX"/> (switch.conf.xml file)<br>
                                                      </div>
                                                      <div><br>
                                                      </div>
                                                      <div class="gmail_extra">these
                                                        are the first
                                                        lines of
                                                        postgresql log
                                                        file</div>
                                                      <div class="gmail_extra"><br>
                                                      </div>
                                                      <div class="gmail_extra">
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:15 CEST
                                                          [7518-7] LOG: 
                                                          received fast
                                                          shutdown
                                                          request</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:15 CEST
                                                          [7518-8] LOG: 
                                                          aborting any
                                                          active
                                                          transactions</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:15 CEST
                                                          [7548-2] LOG: 
                                                          autovacuum
                                                          launcher
                                                          shutting down</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:15 CEST
                                                          [7545-1] LOG: 
                                                          shutting down</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:15 CEST
                                                          [7545-2] LOG: 
                                                          database
                                                          system is shut
                                                          down</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:16 CEST
                                                          [7568-1] LOG: 
                                                          database
                                                          system was
                                                          shut down at
                                                          2018-05-24
                                                          20:23:15 CEST</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:16 CEST
                                                          [7568-2] LOG: 
                                                          MultiXact
                                                          member
                                                          wraparound
                                                          protections
                                                          are now
                                                          enabled</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:16 CEST
                                                          [7567-1] LOG: 
                                                          database
                                                          system is
                                                          ready to
                                                          accept
                                                          connections</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:16 CEST
                                                          [7572-1] LOG: 
                                                          autovacuum
                                                          launcher
                                                          started</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:16 CEST
                                                          [7574-1]
                                                          [unknown]@[unknown]
                                                          LOG: 
                                                          incomplete
                                                          startup packet</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-1]
                                                          freeswitch_user@freeswitch_db
                                                          ERROR: 
                                                          relation
                                                          "channels"
                                                          does not exist
                                                          at character
                                                          40</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-2]
                                                          freeswitch_user@freeswitch_db
                                                          STATEMENT: 
                                                          PREPARE
                                                          "_PLAN0x9f3f90"
                                                          as delete from
                                                          channels where
hostname='freeswitch-capa8';EX<wbr>ECUTE "_PLAN0x9f3f90"</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-3]
                                                          freeswitch_user@freeswitch_db
                                                          ERROR: 
                                                          relation
                                                          "calls" does
                                                          not exist at
                                                          character 40</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-4]
                                                          freeswitch_user@freeswitch_db
                                                          STATEMENT: 
                                                          PREPARE
                                                          "_PLAN0x9f3f90"
                                                          as delete from
                                                          calls where
hostname='freeswitch-capa8';EX<wbr>ECUTE "_PLAN0x9f3f90"</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-5]
                                                          freeswitch_user@freeswitch_db
                                                          ERROR: 
                                                          relation
                                                          "tasks" does
                                                          not exist at
                                                          character 40</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-6]
                                                          freeswitch_user@freeswitch_db
                                                          STATEMENT: 
                                                          PREPARE
                                                          "_PLAN0x9f3f90"
                                                          as delete from
                                                          tasks where
hostname='freeswitch-capa8';EX<wbr>ECUTE "_PLAN0x9f3f90"</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-7]
                                                          freeswitch_user@freeswitch_db
                                                          ERROR: 
                                                          relation
                                                          "aliases" does
                                                          not exist at
                                                          character 49</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-8]
                                                          freeswitch_user@freeswitch_db
                                                          STATEMENT: 
                                                          PREPARE
                                                          "_PLAN0x9f3f90"
                                                          as select
                                                          hostname from
aliases;EXECUTE "_PLAN0x9f3f90"</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-9]
                                                          freeswitch_user@freeswitch_db
                                                          ERROR:  syntax
                                                          error at or
                                                          near "DROP" at
                                                          character 28</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-10]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x9f3f90" as
                                                          DROP TABLE
                                                          aliases;EXECUTE
"_PLAN0x9f3f90"</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-11]
freeswitch_user@freeswitch_db ERROR:  syntax error at or near "CREATE"
                                                          at character
                                                          28</div>
                                                        <div class="gmail_extra">2018-05-24
                                                          20:23:39 CEST
                                                          [7596-12]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x9f3f90" as
                                                          CREATE TABLE
                                                          aliases (</div>
                                                        <div class="gmail_extra"> 
                                                                 
                                                           sticky 
                                                          INTEGER,</div>
                                                        <div class="gmail_extra"> 
                                                                 
                                                           alias 
                                                          VARCHAR(128),</div>
                                                        <div class="gmail_extra"> 
                                                                 
                                                           command 
                                                          VARCHAR(4096),</div>
                                                        <div class="gmail_extra"> 
                                                                 
                                                           hostname
                                                          VARCHAR(256)</div>
                                                        <div class="gmail_extra"> 
                                                                );</div>
                                                        <div class="gmail_extra"> 
                                                                ;EXECUTE
"_PLAN0x9f3f90"</div>
                                                        <div><br>
                                                        </div>
                                                        <div>and now
                                                          freeswitch
                                                          isn't able to
                                                          run.</div>
                                                        <div><br>
                                                        </div>
                                                        <div>If I enable
                                                          odbc trace
                                                          in odbcinst.ini</div>
                                                        <div><br>
                                                        </div>
                                                        <div>
                                                          <div>Trace=Yes</div>
                                                          <div>TraceFile=/var/log/odbctrace.l<wbr>og</div>
                                                        </div>
                                                        <div><br>
                                                        </div>
                                                        <div>Also
                                                          there's no
                                                          output....</div>
                                                        <div><br>
                                                        </div>
                                                        <div>In
                                                          freeswitch log
                                                          also there's
                                                          nothing about
                                                          what is
                                                          happening :(</div>
                                                        <span>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail_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>
                                                        </span>
                                                        <div>
                                                          <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197h5">
                                                          <div class="gmail_quote">2018-05-24
                                                          19:30
                                                          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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
                                                          <div style="word-wrap:break-word">but
                                                          that table
                                                          layout is like
                                                          that because
                                                          you imported
                                                          the tables, i
                                                          was asking
                                                          what is in the
                                                          recreated
                                                          sqlite ones. 
                                                          If it fails to
                                                          connect like
                                                          you later
                                                          describe, its
                                                          going to fall
                                                          back, you
                                                          should see
                                                          stuff in the
                                                          fs logs on
                                                          startup about
                                                          this.  the
                                                          odbc configs
                                                          go in the
                                                          normal place
                                                          they go in the
                                                          os, not in fs
                                                          specific
                                                          dirs.  Those
                                                          errors tell me
                                                          something is
                                                          up, but not
                                                          sure what,
                                                          might need to
                                                          turn on some
                                                          debug on pg
                                                          side to see.
                                                           some of our
                                                          tests like to
                                                          see if table
                                                          schema is
                                                          right throw
                                                          errors then we
                                                          act on them,
                                                          if you restart
                                                          a second time
                                                          you should get
                                                          a more useful
                                                          set of errors.
                                                          <div>
                                                          <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-h5"><br>
                                                          <div><br>
                                                          <blockquote type="cite">
                                                          <div>On May
                                                          24, 2018, at
                                                          1:11 PM,
                                                          Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank">blackholdmailer@gmail.com</a>>
                                                          wrote:</div>
                                                          <br class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-m_3360575814196352002Apple-interchange-newline">
                                                          <div>
                                                          <div dir="ltr">Hi,
                                                          <div>The
                                                          tables are:</div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>ostgres@freeswitch-capa8:~/sql<wbr>$
                                                          psql
                                                          freeswitch_db</div>
                                                          <div>freeswitch_db-#
                                                          \dt</div>
                                                          <div><br>
                                                          </div>
                                                          <div>         
                                                                       
                                                          List of
                                                          relations</div>
                                                          <div> Schema
                                                          |             
                                                            Name       
                                                                   |
                                                          Type  | 
                                                          Owner   </div>
                                                          <div>--------+---------------------<wbr>----------------+-------+-----<wbr>-----</div>
                                                          <div> public |
                                                          aliases       
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          calls         
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          channels     
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          complete     
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          db_data       
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          fifo_bridge   
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          fifo_callers 
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          fifo_outbound 
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          group_data   
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          interfaces   
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          json_store   
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          limit_data   
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          nat           
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          recovery     
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
                                                          registrations 
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
sip_authentication                  | table | postgres</div>
                                                          <div> public |
                                                          sip_dialogs   
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
                                                          sip_presence 
                                                                       
                                                                  |
                                                          table |
                                                          postgres</div>
                                                          <div> public |
sip_registrations                   | table | postgres</div>
                                                          <div> public |
sip_shared_appearance_dialogs       | table | postgres</div>
                                                          <div> public |
sip_shared_appearance_subscrip<wbr>tions | table | postgres</div>
                                                          <div> public |
sip_subscriptions                   | table | postgres</div>
                                                          <div> public |
                                                          tasks         
                                                                       
                                                                 | table
                                                          | postgres</div>
                                                          <div> public |
voicemail_msgs                      | table | postgres</div>
                                                          <div> public |
voicemail_prefs                     | table | postgres</div>
                                                          <div>(25 rows)</div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>I
                                                          continued
                                                          testing and
                                                          found that if
                                                          I configure
                                                          switch.conf.xml
                                                          file like
                                                          this:</div>
                                                          <div><br>
                                                          </div>
                                                          <div><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:12.8px;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"><param
name="core-db-dsn" value="<a>pgsql://hostaddr=127.0</a>.</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:12.8px;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"><wbr>0.1
dbname=freeswitch_db user=freeswitch_user password='****' options='-c
                                                          client_min_messages=NOTICE'"
                                                          /></span><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>When I
                                                          turn on
                                                          freeswitch,
                                                          postgresql
                                                          don't output
                                                          nothing. Then
                                                          I tried to
                                                          configure
                                                          freeswitch
                                                          using odbc I
                                                          then YES I get
                                                          something in
                                                          postgresql
                                                          logs</div>
                                                          <div><br>
                                                          </div>
                                                          <div>For odbc
                                                          I have
                                                          something not
                                                          clear, it is
                                                          mandatory to
                                                          put files in
                                                          /usr/local/freeswitch/etc
                                                          ? or leaving
                                                          them at
                                                          default
                                                          directory
                                                          (/etc) is
                                                          enough?</div>
                                                          <div><br>
                                                          </div>
                                                          <div>Here I
                                                          show the
                                                          config of odbc
                                                          files:</div>
                                                          <div>
                                                          <div>root@freeswitch-capa8:/etc#
                                                          cat odbc.ini </div>
                                                          <div>[freeswitch]</div>
                                                          <div>;
                                                          WARNING: The
                                                          old psql odbc
                                                          driver
                                                          psqlodbc.so is
                                                          now renamed
                                                          psqlodbcw.so</div>
                                                          <div>; in
                                                          version 08.x.
                                                          Note that the
                                                          library can
                                                          also be
                                                          installed
                                                          under an other</div>
                                                          <div>; path
                                                          than
                                                          /usr/local/lib/
                                                          following your
                                                          installation.</div>
                                                          <div>; Driver
                                                          =
                                                          /usr/lib64/odbc/psqlodbcw.so</div>
                                                          <div>; Driver
                                                          =
                                                          /usr/lib/x86_64-linux-gnu/odbc<wbr>/psqlodbca.so</div>
                                                          <div>Driver =
/usr/lib/x86_64-linux-gnu/odbc<wbr>/psqlodbcw.so</div>
                                                          <div>Description=Connection
                                                          to
                                                          LDAP/POSTGRESQL</div>
                                                          <div>Servername=localhost </div>
                                                          <div>Port=5432 </div>
                                                          <div>Protocol=6.4</div>
                                                          <div>FetchBufferSize=99</div>
                                                          <div>Username=freeswitch_user</div>
                                                          <div>Password=XXX</div>
                                                          <div>Database=freeswitch_db</div>
                                                          <div>ReadOnly=no</div>
                                                          <div>Debug=0</div>
                                                          <div>CommLog=0</div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>root@freeswitch-capa8:/etc#
                                                          cat
                                                          odbcinst.ini </div>
                                                          <div>[PostgreSQL]</div>
                                                          <div>Description
                                                          = PostgreSQL
                                                          driver for
                                                          Linux &
                                                          Win32</div>
                                                          <div>;Driver =
/usr/lib64/odbc/psqlodbcw.so</div>
                                                          <div>Driver =
/usr/lib/x86_64-linux-gnu/odbc<wbr>/psqlodbcw.so</div>
                                                          <div>Threading
                                                          = 0</div>
                                                          <div>MaxLongVarcharSize=65536</div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>And then
                                                          connect to
                                                          psql through
                                                          odbc</div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>root@freeswitch-capa8:/etc#
                                                          isql -v
                                                          freeswitch</div>
                                                          <div>+-----------------------------<wbr>----------+</div>
                                                          <div>|
                                                          Connected!   
                                                                       
                                                                    |</div>
                                                          <div>|       
                                                                       
                                                                       
                                                             |</div>
                                                          <div>|
                                                          sql-statement 
                                                                       
                                                                   |</div>
                                                          <div>| help
                                                          [tablename]   
                                                                       
                                                              |</div>
                                                          <div>| quit   
                                                                       
                                                                       
                                                            |</div>
                                                          <div>|       
                                                                       
                                                                       
                                                             |</div>
                                                          <div>+-----------------------------<wbr>----------+</div>
                                                          <div>SQL> </div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>Then in
                                                          file
                                                          switch.conf.xml
                                                          I changed db
                                                          connection
                                                          configuration</div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>root@freeswitch-capa8:/usr/loc<wbr>al/freeswitch/conf/autoload_co<wbr>nfigs#
                                                          cat
                                                          switch.conf.xml
                                                          |grep
                                                          core-db-dsn</div>
                                                          <div>   
                                                          <param
                                                          name="core-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'"
                                                          /></div>
                                                          <div>   
                                                          <!--<param
name="core-db-dsn" value="freeswitch:freeswitch_u<wbr>ser:XXX"/>--></div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>Last
                                                          night SwK user
                                                          at freenode
                                                          channel told
                                                          me that
                                                          freeswitch on
                                                          turning on, it
                                                          creates tables
                                                          at database
                                                          (thanks SwK).</div>
                                                          <div><br>
                                                          </div>
                                                          <div>I spect
                                                          that
                                                          configuration
                                                          of odbc is
                                                          working but
                                                          drops lot of
                                                          errors (here
                                                          you have some
                                                          lines):</div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338780]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x140bf90" as
                                                          CREATE TABLE
                                                          nat (</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           sticky 
                                                          INTEGER,</div>
                                                          <div><span style="white-space:pre-wrap">                </span>port<span style="white-space:pre-wrap">    </span>INTEGER,</div>
                                                          <div><span style="white-space:pre-wrap">                </span>proto<span style="white-space:pre-wrap">   </span>INTEGER,</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           hostname
                                                          VARCHAR(256)</div>
                                                          <div><span style="white-space:pre-wrap">        </span>);</div>
                                                          <div><span style="white-space:pre-wrap">        </span>;EXECUTE
"_PLAN0x140bf90"</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338781]
freeswitch_user@freeswitch_db WARNING:  there is already a transaction
                                                          in progress</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338782]
freeswitch_user@freeswitch_db ERROR:  relation "registrations" does not
                                                          exist at
                                                          character 41</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338783]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x140bf90" as
                                                          delete from
                                                          registrations
                                                          where
                                                          reg_user='';EXECUTE
"_PLAN0x140bf90"</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338784]
freeswitch_user@freeswitch_db WARNING:  there is already a transaction
                                                          in progress</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338785]
freeswitch_user@freeswitch_db ERROR:  syntax error at or near "DROP" at
                                                          character 29</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338786]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x140bf90" as
                                                          DROP TABLE
                                                          registrations;EXECUTE
"_PLAN0x140bf90"</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338787]
freeswitch_user@freeswitch_db WARNING:  there is already a transaction
                                                          in progress</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338788]
freeswitch_user@freeswitch_db ERROR:  syntax error at or near "CREATE"
                                                          at character
                                                          29</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338789]
freeswitch_user@freeswitch_db STATEMENT:  PREPARE "_PLAN0x140bf90" as
                                                          CREATE TABLE
                                                          registrations
                                                          (</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           reg_user     
                                                          VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           realm   
                                                           VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           token   
                                                           VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           url     
                                                          TEXT,</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           expires 
                                                          INTEGER,</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           network_ip
                                                          VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           network_port
                                                          VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           network_proto
                                                          VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           hostname
                                                          VARCHAR(256),</div>
                                                          <div><span style="white-space:pre-wrap">        </span> 
                                                           metadata
                                                          VARCHAR(256)</div>
                                                          <div><span style="white-space:pre-wrap">        </span>);</div>
                                                          <div><span style="white-space:pre-wrap">        </span>;EXECUTE
"_PLAN0x140bf90"</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338790]
freeswitch_user@freeswitch_db WARNING:  there is already a transaction
                                                          in progress</div>
                                                          <div>2018-05-24
                                                          02:03:25 CEST
                                                          [3099-338791]
freeswitch_user@freeswitch_db LOG:  unexpected EOF on client connection
                                                          with an open
                                                          transaction</div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>I tested
                                                          with tables in
                                                          psql database
                                                          and without
                                                          tables in psql
                                                          database.</div>
                                                          <div><span style="color:rgb(80,0,80);font-size:12.8px"><br>
                                                          </span></div>
                                                          <div><span style="color:rgb(80,0,80);font-size:12.8px">freeswitch@freeswitch-capa8>
                                                          version</span><br>
                                                          </div>
                                                          <div><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:12.8px;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">FreeSWITCH
                                                          Version
                                                          1.9.0+git~20180516T211208Z~</span><span style="color:rgb(80,0,80);font-family:arial,sans-serif;font-size:12.8px;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">3c7<wbr>db639fd~64bit
                                                          (git 3c7db63
                                                          2018-05-16
                                                          21:12:08Z
                                                          64bit)</span><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>As I told
                                                          in last mail,
                                                          I'm working
                                                          with last git
                                                          version.</div>
                                                          <div><br>
                                                          </div>
                                                          <div>Then I
                                                          have a last
                                                          question,
                                                          related to
                                                          that (db),
                                                          when it will
                                                          work, all mods
                                                          will save the
                                                          information to
                                                          pgsql or a mix
                                                          some to sqlite
                                                          and some to
                                                          pgsql? I saw
                                                          in other files
                                                          the
                                                          availibility
                                                          to configure
                                                          also db, like <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">/usr/local/freeswitch/con<wbr>f/sip_profiles/internal.xml</span></div>
                                                          <div><br>
                                                          </div>
                                                          <div>
                                                          <div>root@freeswitch-capa8:/usr/loc<wbr>al/freeswitch/conf#
                                                          cat
                                                          /usr/local/freeswitch/conf/sip<wbr>_profiles/internal.xml
                                                          |grep db</div>
                                                          <div>   
                                                          <!-- Name
                                                          of the db to
                                                          use for this
                                                          profile --></div>
                                                          <div>   
                                                          <!--<param
                                                          name="dbname"
value="share_presence"/>--></div>
                                                          <div>   
                                                          <!--<param
name="odbc-dsn" value="dsn:user:pass"/>--></div>
                                                          <div>   
                                                          <!--<param
name="odbc-dsn" value="freeswitch:freeswitch_u<wbr>ser:XXX"/>--></div>
                                                          <div>   
                                                          <!--   
                                                          <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>   
                                                          <!--all
                                                          inbound reg
                                                          will stored in
                                                          the db using
                                                          this domain
                                                          --></div>
                                                          <div>   
                                                          <param
                                                          name="force-register-db-domain<wbr>"
value="$${domain}"/></div>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          <div>The
                                                          config you see
                                                          in the mail is
                                                          the last
                                                          configuration
                                                          I defined.
                                                          Yesterday I
                                                          get lost with
                                                          wich config
                                                          work or wich
                                                          one no...</div>
                                                          <div><br>
                                                          </div>
                                                          <div>I feel
                                                          I'm almost at
                                                          end of this
                                                          installation!
                                                          I'm doing a
                                                          step by step
                                                          manual in
                                                          spanish to how
                                                          to install
                                                          last version
                                                          of freeswitch,
                                                          this will be
                                                          public and if
                                                          you want I
                                                          could upload
                                                          to wiki.</div>
                                                          <div><br>
                                                          </div>
                                                          <div>Thanks
                                                          you much for
                                                          your help :)</div>
                                                          <div><br>
                                                          </div>
                                                          <div>References: </div>
                                                          <div><a href="https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core" target="_blank">https://freeswitch.org/conflue<wbr>nce/display/FREESWITCH/Postgre<wbr>SQL+in+the+core</a></div>
                                                          <div><a href="https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN" target="_blank">https://freeswitch.org/conflue<wbr>nce/display/FREESWITCH/ODBC+DS<wbr>N</a><br>
                                                          </div>
                                                          <div><a href="https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases" target="_blank">https://freeswitch.org/conflue<wbr>nce/display/FREESWITCH/FreeSWI<wbr>TCH+Databases</a><br>
                                                          </div>
                                                          <div><br>
                                                          </div>
                                                          </div>
                                                          <div class="gmail_extra"><br clear="all">
                                                          <div>
                                                          <div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-m_3360575814196352002gmail_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-24
                                                          18:21
                                                          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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">what
                                                          tables are
                                                          ending up in
                                                          the recreated
                                                          sqlite db? 
                                                          You need to
                                                          set it for the
                                                          modules that
                                                          use sqlite too
                                                          (like for
                                                          mod_sofia). 
                                                          we have a
                                                          global var for
                                                          this in
                                                          default
                                                          configs.<br>
                                                          <span><br>
                                                          > On May
                                                          23, 2018, at
                                                          6:13 PM,
                                                          Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank">blackholdmailer@gmail.com</a>>
                                                          wrote:<br>
                                                          > <br>
                                                          > Hi,<br>
                                                          > I have
                                                          just installed
                                                          freeswitch 1.9<br>
                                                          > <br>
                                                          >
                                                          freeswitch@freeswitch-capa8>
                                                          version<br>
                                                          >
                                                          FreeSWITCH
                                                          Version
                                                          1.9.0+git~20180516T211208Z~3c7<wbr>db639fd~64bit
                                                          (git 3c7db63
                                                          2018-05-16
                                                          21:12:08Z
                                                          64bit)<br>
                                                          > <br>
                                                          > And I'm
                                                          trying to
                                                          freeswitch use
                                                          postgresql
                                                          instead
                                                          sqlitedb.<br>
                                                          > <br>
                                                          > I have
                                                          configured the
                                                          file
                                                          switch.conf.xml
                                                          of
                                                          /usr/local/freeswitch/conf/aut<wbr>oload_configs
                                                          with
                                                          uncomenting
                                                          and
                                                          configuring
                                                          this line<br>
                                                          > <br>
                                                          >   
                                                           <param
                                                          name="core-db-dsn"
                                                          value="<a>pgsql://hostaddr=127.0</a>.<wbr>0.1
dbname=freeswitch_db user=freeswitch_user password='****' options='-c
                                                          client_min_messages=NOTICE'"
                                                          /><br>
                                                          > <br>
                                                          > then I
                                                          exported all
                                                          sqlitedbs to
                                                          sql and then
                                                          imported to a
                                                          database that
                                                          I have created
                                                          in postgresql<br>
                                                          > <br>
                                                          > I have
                                                          run again
                                                          /etc/init.d/freeswitch.sh
                                                          start<br>
                                                          > <br>
                                                          > But seems
                                                          it still is
                                                          taking
                                                          sqlitedb.<br>
                                                          > <br>
                                                          > I tried
                                                          to move the
                                                          sqlitedbs
                                                          files to other
                                                          side and
                                                          turned on
                                                          again
                                                          freeswitch,
                                                          but it creates
                                                          sqlitedbs
                                                          again.<br>
                                                          > <br>
                                                          > What I'm
                                                          missing? what
                                                          I'm doing
                                                          wrong? what
                                                          could I check?<br>
                                                          <br>
                                                          <br>
                                                          </span>______________________________<wbr>______________________________<wbr>_____________<br>
                                                          Professional
                                                          FreeSWITCH
                                                          Consulting
                                                          Services:<br>
                                                          <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                                          <a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank">http://www.freeswitchsolutions<wbr>.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.o<wbr>rg</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" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                                                          UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank">http://www.freeswitch.org</a></blockquote>
                                                          </div>
                                                          <br>
                                                          </div>
______________________________<wbr>______________________________<wbr>_____________<br>
                                                          Professional
                                                          FreeSWITCH
                                                          Consulting
                                                          Services:<br>
                                                          <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                                          <a href="http://www.freeswitchsolutions.com/" target="_blank">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                          <br>
                                                          Official
                                                          FreeSWITCH
                                                          Sites<br>
                                                          <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a><br>
                                                          <a href="http://confluence.freeswitch.org/" target="_blank">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                          <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com</a><br>
                                                          <br>
FreeSWITCH-users mailing list<br>
                                                          <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                                                          UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a></div>
                                                          </blockquote>
                                                          </div>
                                                          <br>
                                                          </div>
                                                          </div>
                                                          </div>
                                                          <br>
______________________________<wbr>______________________________<wbr>_____________<br>
                                                          Professional
                                                          FreeSWITCH
                                                          Consulting
                                                          Services:<br>
                                                          <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                                          <a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank">http://www.freeswitchsolutions<wbr>.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.o<wbr>rg</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" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                                                          UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
                                                          </blockquote>
                                                          </div>
                                                          <br>
                                                          </div>
                                                        </div>
                                                      </div>
                                                    </div>
                                                  </blockquote>
                                                </div>
                                                <br>
                                              </div>
______________________________<wbr>______________________________<wbr>_____________<br>
                                              Professional FreeSWITCH
                                              Consulting Services:<br>
                                              <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                              <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions<wbr>.com</a><br>
                                              <br>
                                              Official FreeSWITCH Sites<br>
                                              <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
                                              <a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.o<wbr>rg</a><br>
                                              <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
                                              <br>
                                              FreeSWITCH-users mailing
                                              list<br>
                                              <a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                              <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                                              UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                              <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></div>
                                          </blockquote>
                                        </div>
                                        <br>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                                <br>
                                ______________________________<wbr>______________________________<wbr>_____________<br>
                                Professional FreeSWITCH Consulting
                                Services:<br>
                                <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                                <a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions<wbr>.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.o<wbr>rg</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" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                                UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                <a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                          <br>
                          <fieldset class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330mimeAttachmentHeader"></fieldset>
                          <br>
                          <pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions<wbr>.com</a>

Official FreeSWITCH Sites
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.o<wbr>rg</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a>
UNSUBSCRIBE:<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></pre>
                        </blockquote>
                        <br>
                      </div>
                      <br>
                      ______________________________<wbr>______________________________<wbr>_____________<br>
                      Professional FreeSWITCH Consulting Services:<br>
                      <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
                      <a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions<wbr>.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.o<wbr>rg</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" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                      <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
                      UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                      <a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
                    </blockquote>
                  </div>
                  <br>
                </div>
                <br>
                <fieldset class="m_1948172350244949374m_6786559865130825391mimeAttachmentHeader"></fieldset>
                <br>
                <pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions<wbr>.com</a>

Official FreeSWITCH Sites
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.o<wbr>rg</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a>
UNSUBSCRIBE:<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/<wbr>freeswitch-users</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></pre>
              </blockquote>
              <br>
            </div>
            <br>
            ______________________________<wbr>______________________________<wbr>_____________<br>
            Professional FreeSWITCH Consulting Services:<br>
            <a href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
            <a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.freeswitchsolutions<wbr>.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.o<wbr>rg</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" target="_blank">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
            <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/ma<wbr>ilman/listinfo/freeswitch-user<wbr>s</a><br>
            UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.frees<wbr>witch.org/mailman/options/<wbr>freeswitch-users</a><br>
            <a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset class="m_1948172350244949374mimeAttachmentHeader"></fieldset>
      <br>
      <pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitchsolutions.com" target="_blank">http://www.<wbr>freeswitchsolutions.com</a>

Official FreeSWITCH Sites
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.<wbr>org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a class="m_1948172350244949374moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.<wbr>freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a>
UNSUBSCRIBE:<a class="m_1948172350244949374moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></pre>
    </blockquote>
    <br>
  </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>