<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>if you set pgsql:// in switch.conf.xml so</p>
    <p>you must set pgsql:// in every config where a DB is involved<br>
    </p>
    <div class="moz-cite-prefix">On 5/24/2018 4:11 PM, Blackhold wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAMFaAL2vV17s8MsS+W2Xp+D4hLP+9VU53NC7cxTrY-W6QMMF9Q@mail.gmail.com">
      <div dir="ltr">
        <div class="gmail_extra">what or wich is the sip profile?</div>
        <div class="gmail_extra"><br>
        </div>
        <div class="gmail_extra">I understand that all tables that are
          created in sqlite are the ones that have to create to psql
          database that I'm refering all time...</div>
        <div class="gmail_extra"><br>
        </div>
        <div class="gmail_extra">The configs I'm showing all time are
          the real config (only changing password value)<br>
          <br>
          <div class="gmail_quote">2018-05-25 0:43 GMT+02:00 Madovsky <span
              dir="ltr"><<a href="mailto:infos@madovsky.org"
                target="_blank" moz-do-not-send="true">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>are you sure you are using the proper sip profile
                  which use pgsql:// ?<br>
                </p>
                <div class="m_988892909442301037moz-cite-prefix">On
                  5/24/2018 3:20 PM, Blackhold wrote:<br>
                </div>
                <blockquote type="cite">
                  <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="m_988892909442301037gmail_signature"
                        data-smartmail="gmail_signature"><br>
                        - Blackhold<br>
                        <a href="http://blackhold.nusepas.com"
                          target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">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_988892909442301037m_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_988892909442301037m_1948172350244949374gmail_signature"
                                  data-smartmail="gmail_signature"><br>
                                  - Blackhold<br>
                                  <a href="http://blackhold.nusepas.com"
                                    target="_blank"
                                    moz-do-not-send="true">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"
                                    moz-do-not-send="true">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_988892909442301037m_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"
                                              moz-do-not-send="true">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_988892909442301037m_1948172350244949374m_6786559865130825391gmail_signature"
data-smartmail="gmail_signature"><br>
                                            - Blackhold<br>
                                            <a
                                              href="http://blackhold.nusepas.com"
                                              target="_blank"
                                              moz-do-not-send="true">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"
                                              moz-do-not-send="true">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_988892909442301037m_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_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330gmail_signature"
data-smartmail="gmail_signature"><br>
                                                      - Blackhold<br>
                                                      <a
                                                        href="http://blackhold.nusepas.com"
                                                        target="_blank"
moz-do-not-send="true">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"
moz-do-not-send="true">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_988892909442301037m_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"
                                                          moz-do-not-send="true">blackholdmailer@gmail.com</a>>
                                                          wrote:</div>
                                                          <br
class="m_988892909442301037m_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_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197gmail_signature"
data-smartmail="gmail_signature"><br>
                                                          - Blackhold<br>
                                                          <a
                                                          href="http://blackhold.nusepas.com/"
target="_blank" moz-do-not-send="true">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"
                                                          moz-do-not-send="true">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 moz-do-not-send="true">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_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail_signature"><br>
                                                          - Blackhold<br>
                                                          <a
                                                          href="http://blackhold.nusepas.com/"
target="_blank" moz-do-not-send="true">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_988892909442301037m_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" moz-do-not-send="true">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_988892909442301037m_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"
                                                          moz-do-not-send="true">blackholdmailer@gmail.com</a>>
                                                          wrote:</div>
                                                          <br
class="m_988892909442301037m_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 moz-do-not-send="true">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
                                                          moz-do-not-send="true">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
                                                          moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-m_3360575814196352002gmail_signature"><br>
                                                          - Blackhold<br>
                                                          <a
                                                          href="http://blackhold.nusepas.com/"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">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"
                                                          moz-do-not-send="true">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
                                                          moz-do-not-send="true">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" moz-do-not-send="true">consulting@freeswitch.org</a><br>
                                                          <a
                                                          href="http://www.freeswitchsolutions.com/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                          <br>
                                                          Official
                                                          FreeSWITCH
                                                          Sites<br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                          <a
                                                          href="http://confluence.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                          <a
                                                          href="http://www.cluecon.com/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
                                                          <br>
FreeSWITCH-users mailing list<br>
                                                          <a
                                                          href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a
                                                          href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">consulting@freeswitch.org</a><br>
                                                          <a
                                                          href="http://www.freeswitchsolutions.com/"
target="_blank" moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                          <br>
                                                          Official
                                                          FreeSWITCH
                                                          Sites<br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                          <a
                                                          href="http://confluence.freeswitch.org/"
target="_blank" moz-do-not-send="true">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                          <a
                                                          href="http://www.cluecon.com/"
target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
                                                          <br>
FreeSWITCH-users mailing list<br>
                                                          <a
                                                          href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a
                                                          href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank" moz-do-not-send="true">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"
moz-do-not-send="true">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">consulting@freeswitch.org</a><br>
                                                          <a
                                                          href="http://www.freeswitchsolutions.com/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                          <br>
                                                          Official
                                                          FreeSWITCH
                                                          Sites<br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                          <a
                                                          href="http://confluence.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                          <a
                                                          href="http://www.cluecon.com/"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
                                                          <br>
FreeSWITCH-users mailing list<br>
                                                          <a
                                                          href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a
                                                          href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a
                                                          href="http://www.freeswitch.org/"
rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">consulting@freeswitch.org</a><br>
                                                          <a
                                                          href="http://www.freeswitchsolutions.com"
target="_blank" moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                          <br>
                                                          Official
                                                          FreeSWITCH
                                                          Sites<br>
                                                          <a
                                                          href="http://www.freeswitch.org"
target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                          <a
                                                          href="http://confluence.freeswitch.org"
target="_blank" moz-do-not-send="true">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                          <a
                                                          href="http://www.cluecon.com"
target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
                                                          <br>
FreeSWITCH-users mailing list<br>
                                                          <a
                                                          href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                          <a
                                                          href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank" moz-do-not-send="true">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"
moz-do-not-send="true">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                          <a
                                                          href="http://www.freeswitch.org"
target="_blank" moz-do-not-send="true">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"
moz-do-not-send="true">consulting@freeswitch.org</a><br>
                                                      <a
                                                        href="http://www.freeswitchsolutions.com"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a><br>
                                                      <br>
                                                      Official
                                                      FreeSWITCH Sites<br>
                                                      <a
                                                        href="http://www.freeswitch.org"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                      <a
                                                        href="http://confluence.freeswitch.org"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">http://confluence.freeswitch.o<wbr>rg</a><br>
                                                      <a
                                                        href="http://www.cluecon.com"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">http://www.cluecon.com</a><br>
                                                      <br>
                                                      FreeSWITCH-users
                                                      mailing list<br>
                                                      <a
                                                        href="mailto:FreeSWITCH-users@lists.freeswitch.org"
                                                        target="_blank"
moz-do-not-send="true">FreeSWITCH-users@lists.freeswi<wbr>tch.org</a><br>
                                                      <a
                                                        href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">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"
moz-do-not-send="true">http://lists.frees<wbr>witch.org/mailman/options/free<wbr>switch-users</a><br>
                                                      <a
                                                        href="http://www.freeswitch.org"
                                                        rel="noreferrer"
                                                        target="_blank"
moz-do-not-send="true">http://www.freeswitch.org</a><br>
                                                    </blockquote>
                                                  </div>
                                                  <br>
                                                </div>
                                                <br>
                                                <fieldset
class="m_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330mimeAttachmentHeader"></fieldset>
                                                <br>
                                                <pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="m_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitchsolutions.com" target="_blank" moz-do-not-send="true">http://www.freeswitchsolutions<wbr>.com</a>

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

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

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

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

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

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

Official FreeSWITCH Sites
<a class="m_988892909442301037moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a>
<a class="m_988892909442301037moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.<wbr>org</a>
<a class="m_988892909442301037moz-txt-link-freetext" href="http://www.cluecon.com" target="_blank" moz-do-not-send="true">http://www.cluecon.com</a>

FreeSWITCH-users mailing list
<a class="m_988892909442301037moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" moz-do-not-send="true">FreeSWITCH-users@lists.<wbr>freeswitch.org</a>
<a class="m_988892909442301037moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" moz-do-not-send="true">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a>
UNSUBSCRIBE:<a class="m_988892909442301037moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" moz-do-not-send="true">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a>
<a class="m_988892909442301037moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a></pre>
                </blockquote>
                <br>
              </div>
              <br>
              ______________________________<wbr>______________________________<wbr>_____________<br>
              Professional FreeSWITCH Consulting Services:<br>
              <a href="mailto:consulting@freeswitch.org"
                moz-do-not-send="true">consulting@freeswitch.org</a><br>
              <a href="http://www.freeswitchsolutions.com"
                rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.<wbr>freeswitchsolutions.com</a><br>
              <br>
              Official FreeSWITCH Sites<br>
              <a href="http://www.freeswitch.org" rel="noreferrer"
                target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
              <a href="http://confluence.freeswitch.org"
                rel="noreferrer" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.<wbr>org</a><br>
              <a href="http://www.cluecon.com" rel="noreferrer"
                target="_blank" moz-do-not-send="true">http://www.cluecon.com</a><br>
              <br>
              FreeSWITCH-users mailing list<br>
              <a href="mailto:FreeSWITCH-users@lists.freeswitch.org"
                moz-do-not-send="true">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
              <a
                href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
                rel="noreferrer" target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
              <a href="http://www.freeswitch.org" rel="noreferrer"
                target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a><br>
            </blockquote>
          </div>
          <br>
        </div>
      </div>
      <!--'"--><br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>

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

FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
    </blockquote>
    <br>
  </body>
</html>