<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>for the profile this one</p>
<p><param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1
dbname=freeswitch_db user=freeswitch_user password='XXX'
options='-c client_min_messages=NOTICE'
application_name='freeswitch'" /></p>
<p>core-db-dsn is only for swithc.conf.xml if I recall well.<br>
</p>
<div class="moz-cite-prefix">On 5/24/2018 5:13 PM, Blackhold wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAMFaAL3t89qp66HLNW9EYdGdp4ydK=u7hxedNg=9EKF9NcYm6Q@mail.gmail.com">
<div dir="ltr">wich string I have to add?
<div><br>
</div>
<div>
<div><param name="core-db-dsn"
value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db
user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE'" /></div>
</div>
<div><br>
</div>
<div>or</div>
<div><br>
</div>
<div>
<div><param name="odbc-dsn"
value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db
user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE' application_name='freeswitch'"
/></div>
</div>
<div><br>
</div>
<div>?</div>
<div><br>
</div>
<div>for example for file conf/sip_profiles/internal.xml:231</div>
<div><br>
</div>
<div>wich modules needs db connection?</div>
<div><br>
</div>
<div>thanks!</div>
<div><br>
</div>
<div><br>
</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature" data-smartmail="gmail_signature"><br>
- Blackhold<br>
<a href="http://blackhold.nusepas.com" target="_blank"
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-25 1:33 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>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="m_1113647494900590553moz-cite-prefix">On
5/24/2018 4:11 PM, Blackhold wrote:<br>
</div>
<blockquote type="cite">
<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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_988892909442301037m_1948172350244949374m_6786559865130825391m_-6505748881310717330mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_988892909442301037m_1948172350244949374m_6786559865130825391mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_988892909442301037m_1948172350244949374mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1113647494900590553m_988892909442301037m_1948172350244949374moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="m_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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_1113647494900590553m_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/free<wbr>switch-users</a>
<a class="m_1113647494900590553m_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/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_1113647494900590553m_988892909442301037mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1113647494900590553m_988892909442301037moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="m_1113647494900590553m_988892909442301037moz-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_1113647494900590553m_988892909442301037moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a>
<a class="m_1113647494900590553m_988892909442301037moz-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_1113647494900590553m_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_1113647494900590553m_988892909442301037moz-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_1113647494900590553m_988892909442301037moz-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_1113647494900590553m_988892909442301037moz-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_1113647494900590553m_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"
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>
</div>
<br>
<fieldset
class="m_1113647494900590553mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1113647494900590553moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="m_1113647494900590553moz-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_1113647494900590553moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a>
<a class="m_1113647494900590553moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.<wbr>org</a>
<a class="m_1113647494900590553moz-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_1113647494900590553moz-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_1113647494900590553moz-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_1113647494900590553moz-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_1113647494900590553moz-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>
<!--'"--><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>