<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">This set of logs is after it attaches to the db and creates the tables. <br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On May 24, 2018, at 6:20 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com" class="">blackholdmailer@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="">it seems nothing... yes tells something, but no one error, it seems all modules are loaded ok.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div class="">2018-05-24 22:58:20.552211 [INFO] sofia.c:5987 Setting MAX Auth Validity to 0 Attempts</div></div><div class=""><br class=""></div><div class=""><div class="">2018-05-24 22:58:20.557248 [INFO] switch_core_sqldb.c:1693 sofia:external Starting SQL thread.</div></div><div class=""><br class=""></div><div class=""><div class=""><div class="">2018-05-24 22:58:20.562295 [NOTICE] sofia.c:4172 Adding Alias [10.90.226.83] for profile [internal]</div><div class="">2018-05-24 22:58:20.562424 [WARNING] sofia.c:2285 MSG Thread 0 Started</div></div></div><div class=""><br class=""></div><div class="">2018-05-24 22:58:22.059111 [CONSOLE] switch_loadable_module.c:1540 Successfully Loaded [mod_db]</div><div class="">2018-05-24 22:58:22.059118 [NOTICE] switch_loadable_module.c:292 Adding Application 'db'</div><div class="">2018-05-24 22:58:22.059128 [NOTICE] switch_loadable_module.c:292 Adding Application 'group'</div><div class="">2018-05-24 22:58:22.059137 [NOTICE] switch_loadable_module.c:338 Adding API Function 'db'</div><div class="">2018-05-24 22:58:22.059146 [NOTICE] switch_loadable_module.c:338 Adding API Function 'group'</div><div class="">2018-05-24 22:58:22.059154 [NOTICE] switch_loadable_module.c:556 Adding Limit interface 'db'</div><div class=""><br class=""></div></div><div class="gmail_extra"><br clear="all" class=""><div class=""><div class="gmail_signature" data-smartmail="gmail_signature"><br class="">- Blackhold<br class=""><a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">@blackhold_<br class="">~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs)<br class=""><°((( ><</div></div>
<br class=""><div class="gmail_quote">2018-05-24 23:23 GMT+02:00 Madovsky <span dir="ltr" class=""><<a href="mailto:infos@madovsky.org" target="_blank" class="">infos@madovsky.org</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class=""><p class="">and anything in FS logs?</p>
<div class="m_1948172350244949374moz-cite-prefix">On 5/24/2018 1:59 PM, Blackhold wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div dir="ltr" class="">done, restarted psql and turned on freeswitch,
nothing in psql log files, no tables where created.
<div class=""><br class="">
</div>
<div class="">using psql conector</div>
</div>
<div class="gmail_extra"><br clear="all" class="">
<div class="">
<div class="m_1948172350244949374gmail_signature" data-smartmail="gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal lluitar contra el fort per deixar de ser febles, i
contra nosaltres mateixos quan siguem forts (Xirinacs)<br class="">
<°((( ><</div>
</div>
<br class="">
<div class="gmail_quote">2018-05-24 22:41 GMT+02:00 Madovsky <span dir="ltr" class=""><<a href="mailto:infos@madovsky.org" target="_blank" class="">infos@madovsky.org</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class=""><p class="">remove these 2 lines<br class="">
</p><p class="">local all postgres
peer<br class="">
</p><p class="">local all all
peer<br class="">
</p>
<div class="">and replace with<br class="">
</div><p class="">local all all trust</p><p class="">in your pg_hba.conf</p><p class=""><br class="">
</p>
<div class="m_1948172350244949374m_6786559865130825391moz-cite-prefix">On
5/24/2018 1:26 PM, Blackhold wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div dir="ltr" class="">Hi,
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">
<div class=""><param name="core-db-dsn"
value="<a href="pgsql://hostaddr=127.0" class="">pgsql://hostaddr=127.0</a>.<wbr class="">0.1
dbname=freeswitch_db user=freeswitch_user
password='XXX' options='-c
client_min_messages=NOTICE'" /></div>
</div>
<div class=""><br class="">
</div>
<div class="">so then, I only will use that, and the problem is
my system, not freeswitch.</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">Here you have the versions of libraries I have:</div>
<div class=""><br class="">
</div>
<div class=""># debian 8 fresh install (x86_64)</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:~# cat
/etc/debian_version </div>
<div class="">8.10</div>
<div class="">root@freeswitch-capa8:~# dpkg -l |grep
postgresql</div>
<div class="">ii odbc-postgresql:amd64
1:09.03.0300-1 amd64
ODBC driver for PostgreSQL</div>
<div class="">ii postgresql
9.4+165+deb8u3 all
object-relational SQL database (supported version)</div>
<div class="">ii postgresql-9.4
9.4.15-0+deb8u1 amd64
object-relational SQL database, version 9.4 server</div>
<div class="">ii postgresql-client
9.4+165+deb8u3 all
front-end programs for PostgreSQL (supported
version)</div>
<div class="">ii postgresql-client-9.4
9.4.15-0+deb8u1 amd64
front-end programs for PostgreSQL 9.4</div>
<div class="">ii postgresql-client-common
165+deb8u3 all
manager for multiple PostgreSQL client versions</div>
<div class="">ii postgresql-common
165+deb8u3 all
PostgreSQL database-cluster manager</div>
<div class="">root@freeswitch-capa8:~# dpkg -l |grep libpq</div>
<div class="">ii libpq-dev
9.4.15-0+deb8u1 amd64
header files for libpq5 (PostgreSQL library)</div>
<div class="">ii libpq5:amd64
9.4.15-0+deb8u1 amd64
PostgreSQL C client library</div>
</div>
<div class=""><br class="">
</div>
<div class="">all these packages are downloaded from sources</div>
<div class=""><br class="">
</div>
<div class="">the lines enabled at pg_hba.conf are these (the
debian default ones)</div>
<div class=""><br class="">
</div>
<div class="">local all postgres
peer<br class="">
<div class="">local all all
peer</div>
</div>
<div class="">
<div class="">host all all <a href="http://127.0.0.1/32" target="_blank" class="">127.0.0.1/32</a>
md5</div>
</div>
<div class="">
<div class="">host all all
::1/128 md5</div>
</div>
<div class=""><br class="">
</div>
<div class="">the script that I have used to do the
installation is the one located in source code</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/usr/src<wbr class="">/freeswitch/scripts#
ls -l |grep raspbian-installer</div>
<div class="">-rwxr-xr-x 1 root root 7922 May 23 20:26
FreeSWITCH-debian-raspbian-ins<wbr class="">taller.sh</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
</div>
<div class="gmail_extra"><br clear="all" class="">
<div class="">
<div class="m_1948172350244949374m_6786559865130825391gmail_signature" data-smartmail="gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal lluitar contra el fort per deixar de ser
febles, i contra nosaltres mateixos quan siguem
forts (Xirinacs)<br class="">
<°((( ><</div>
</div>
<br class="">
<div class="gmail_quote">2018-05-24 21:58 GMT+02:00
Madovsky <span dir="ltr" class=""><<a href="mailto:infos@madovsky.org" target="_blank" class="">infos@madovsky.org</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class=""><p class="">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 class="">postgresql 6.x !??!)</p><p class="">what version of postgresql are you using?
compiled yourself or from system package?</p><p class="">check if there are not multiple versions of
libpq.xx in your system.</p><p class="">check pg_hba.conf if localhost is on trust
mode for all local users.</p><p class="">if you compiled yourself so be sure the right
libpq.xx have been chosen.<br class="">
</p>
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-cite-prefix">On
5/24/2018 12:33 PM, Blackhold wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div dir="ltr" class="">nope, it is not able to create
stuff
<div class=""><br class="">
</div>
<div class="">now I also have enabled that in
switch.conf.xml</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""> <param
name="auto-create-schemas"
value="true"/></div>
<div class=""> <param name="auto-clear-sql"
value="true"/></div>
</div>
<div class=""><br class="">
</div>
<div class="">tested with odbc and directly with psql
and behaviour is the same.</div>
<div class=""><br class="">
</div>
<div class="">for psql the procedure I have followed
is</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:~# su -
postgres</div>
<div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">root@freeswitch-capa8:~#<span class=""> </span></span>postg<wbr class="">res@freeswitch-capa8:~$ create<wbr class="">user
freeswitch_user</div>
</div>
<div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">root@freeswitch-capa8:~#<span class=""> </span></span>creat<wbr class="">edb
-O freeswitch_user freeswitch_db<br class="">
</div>
<div class=""><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline" class="">root@freeswitch-capa8:~#<span class=""> </span></span>psql
freeswitch_db<br class="">
</div>
<div class="">freeswitch_db=# ALTER USER
freeswitch_user WITH PASSWORD 'XXX';<br class="">
</div>
<div class="">freeswitch_db=# GRANT ALL PRIVILEGES ON
ALL TABLES IN SCHEMA public TO
freeswitch_user;<br class="">
</div>
<div class="">freeswitch_db=# GRANT ALL PRIVILEGES ON
ALL SEQUENCES IN SCHEMA public TO
freeswitch_user;<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">logs doesn't talk about permissions....</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
</div>
<div class="gmail_extra"><br clear="all" class="">
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330gmail_signature" data-smartmail="gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal lluitar contra el fort per
deixar de ser febles, i contra nosaltres
mateixos quan siguem forts (Xirinacs)<br class="">
<°((( ><</div>
</div>
<br class="">
<div class="gmail_quote">2018-05-24 21:20
GMT+02:00 Michael Jerris <span dir="ltr" class=""><<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word;line-break:after-white-space" class="">you
shouldn't need to pre-import the
tables, if the permissions are right,
it should create the tables and
indexes for you.
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330h5">
<div class=""><br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On May 24, 2018, at
3:15 PM, Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank" class="">blackholdmailer@gmail.com</a>>
wrote:</div>
<br class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">I continue
with tests
<div class=""><br class="">
</div>
<div class="">I think I know wich
problem I had with
errors</div>
<div class=""><br class="">
</div>
<div class="">I have missed to
grant privileges in
psql:</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">GRANT ALL
PRIVILEGES ON ALL
TABLES IN SCHEMA
public TO
freeswitch_user;</div>
<div class="">GRANT ALL
PRIVILEGES ON ALL
SEQUENCES IN SCHEMA
public TO
freeswitch_user;</div>
</div>
<div class=""><br class="">
</div>
<div class=""># with tables
imported from sqlite
it shows (freeswitch
runs)</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/var/log<wbr class="">/postgresql#
tail -f
postgresql-9.4-main.log </div>
<div class=""><br class="">
</div>
<div class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">0,hostname);EXECUTE
"_PLAN0x123ff90"</div>
<div class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">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 class="">UTE
"_PLAN0x123ff90"</div>
</div>
<div class=""><br class="">
</div>
<div class=""># with a clean
database</div>
<div class=""><br class="">
</div>
<div class="">start dropping last
errors, and don't
create any table in
db. Freeswitch doesn't
turns on.</div>
<div class=""><br class="">
</div>
<div class="">each time I stop
freeswitch when it
don't runs, it keeps a
process running that I
have to kill manually</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/var/log<wbr class="">/postgresql# ps
aux |grep free</div>
<div class="">root 8706
39.6 0.7 141296
15244 ?
S<l 21:08 1:13
/usr/local/freeswitch/bin/free<wbr class="">switch -nc</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""># with granted
permisions if I turn
configuration to not
use odbc, using psql
directly</div>
<div class=""><br class="">
</div>
<div class="">freeswitch turns
on, there's no errors
in psql log file and
no table was created
on db.</div>
<div class=""><br class="">
</div>
</div>
<div class="gmail_extra"><br clear="all" class="">
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197gmail_signature" data-smartmail="gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal lluitar
contra el fort per
deixar de ser
febles, i contra
nosaltres mateixos
quan siguem forts
(Xirinacs)<br class="">
<°((( ><</div>
</div>
<br class="">
<div class="gmail_quote">2018-05-24
20:31 GMT+02:00
Blackhold <span dir="ltr" class=""><<a href="mailto:blackholdmailer@gmail.com" target="_blank" class="">blackholdmailer@gmail.com</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" class=""># OK
for location of
ODBC files
<div class=""><br class="">
</div>
<div class=""># output
freeswitch using
psql (I only
edited
switch.conf.xml
file)</div>
<div class=""><param
name="core-db-dsn"
value="<a class="">pgsql://hostaddr=127.0</a>.<wbr class="">0.1
dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE'" /> (switch.conf.xml file)<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">I see no
errors related
on logs (nor
freeswitch, nor
psql -debug5-),
obviously
restarted psql
to reload
config.</div>
<div class=""><br class="">
</div>
<div class="">in
sofia.conf.xml
file I found no
option to
configure it
pointing to
database</div>
<div class="">no other
config file,
except
switch.conf.xml
has configured
database
pointing</div>
<div class=""><br class="">
</div>
<div class="">I tried to
configure db.conf.xml
file, with
switch.conf.xml
line but also do
nothing</div>
<div class=""><br class="">
</div>
<div class=""># output
freeswtich using
odbc</div>
<div class=""><param
name="core-db-dsn"
value="freeswitch:freeswitch_u<wbr class="">ser:XXX"/> (switch.conf.xml file)<br class="">
</div>
<div class=""><br class="">
</div>
<div class="gmail_extra">these
are the first
lines of
postgresql log
file</div>
<div class="gmail_extra"><br class="">
</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 class="">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 class="">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 class="">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 class=""><br class="">
</div>
<div class="">and now
freeswitch
isn't able to
run.</div>
<div class=""><br class="">
</div>
<div class="">If I enable
odbc trace
in odbcinst.ini</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">Trace=Yes</div>
<div class="">TraceFile=/var/log/odbctrace.l<wbr class="">og</div>
</div>
<div class=""><br class="">
</div>
<div class="">Also
there's no
output....</div>
<div class=""><br class="">
</div>
<div class="">In
freeswitch log
also there's
nothing about
what is
happening :(</div>
<span class="">
<div class=""><br class="">
</div>
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal
lluitar contra
el fort per
deixar de ser
febles, i
contra
nosaltres
mateixos quan
siguem forts
(Xirinacs)<br class="">
<°(((
><</div>
</div>
<br class="">
</span>
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197h5">
<div class="gmail_quote">2018-05-24
19:30
GMT+02:00
Michael Jerris
<span dir="ltr" class=""><<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div style="word-wrap:break-word" class="">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 class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-h5"><br class="">
<div class=""><br class="">
<blockquote type="cite" class="">
<div class="">On May
24, 2018, at
1:11 PM,
Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank" class="">blackholdmailer@gmail.com</a>>
wrote:</div>
<br class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-m_3360575814196352002Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">Hi,
<div class="">The
tables are:</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">ostgres@freeswitch-capa8:~/sql<wbr class="">$
psql
freeswitch_db</div>
<div class="">freeswitch_db-#
\dt</div>
<div class=""><br class="">
</div>
<div class="">
List of
relations</div>
<div class=""> Schema
|
Name
|
Type |
Owner </div>
<div class="">--------+---------------------<wbr class="">----------------+-------+-----<wbr class="">-----</div>
<div class=""> public |
aliases
| table
| postgres</div>
<div class=""> public |
calls
| table
| postgres</div>
<div class=""> public |
channels
|
table |
postgres</div>
<div class=""> public |
complete
|
table |
postgres</div>
<div class=""> public |
db_data
| table
| postgres</div>
<div class=""> public |
fifo_bridge
| table
| postgres</div>
<div class=""> public |
fifo_callers
|
table |
postgres</div>
<div class=""> public |
fifo_outbound
| table
| postgres</div>
<div class=""> public |
group_data
|
table |
postgres</div>
<div class=""> public |
interfaces
|
table |
postgres</div>
<div class=""> public |
json_store
|
table |
postgres</div>
<div class=""> public |
limit_data
|
table |
postgres</div>
<div class=""> public |
nat
| table
| postgres</div>
<div class=""> public |
recovery
|
table |
postgres</div>
<div class=""> public |
registrations
| table
| postgres</div>
<div class=""> public |
sip_authentication | table | postgres</div>
<div class=""> public |
sip_dialogs
| table
| postgres</div>
<div class=""> public |
sip_presence
|
table |
postgres</div>
<div class=""> public |
sip_registrations | table | postgres</div>
<div class=""> public |
sip_shared_appearance_dialogs | table | postgres</div>
<div class=""> public |
sip_shared_appearance_subscrip<wbr class="">tions | table | postgres</div>
<div class=""> public |
sip_subscriptions | table | postgres</div>
<div class=""> public |
tasks
| table
| postgres</div>
<div class=""> public |
voicemail_msgs | table | postgres</div>
<div class=""> public |
voicemail_prefs | table | postgres</div>
<div class="">(25 rows)</div>
</div>
<div class=""><br class="">
</div>
<div class="">I
continued
testing and
found that if
I configure
switch.conf.xml
file like
this:</div>
<div class=""><br class="">
</div>
<div class=""><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" class=""><param
name="core-db-dsn" value="<a class="">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" class=""><wbr class="">0.1
dbname=freeswitch_db user=freeswitch_user password='****' options='-c
client_min_messages=NOTICE'"
/></span><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">Here I
show the
config of odbc
files:</div>
<div class="">
<div class="">root@freeswitch-capa8:/etc#
cat odbc.ini </div>
<div class="">[freeswitch]</div>
<div class="">;
WARNING: The
old psql odbc
driver
psqlodbc.so is
now renamed
psqlodbcw.so</div>
<div class="">; in
version 08.x.
Note that the
library can
also be
installed
under an other</div>
<div class="">; path
than
/usr/local/lib/
following your
installation.</div>
<div class="">; Driver
=
/usr/lib64/odbc/psqlodbcw.so</div>
<div class="">; Driver
=
/usr/lib/x86_64-linux-gnu/odbc<wbr class="">/psqlodbca.so</div>
<div class="">Driver =
/usr/lib/x86_64-linux-gnu/odbc<wbr class="">/psqlodbcw.so</div>
<div class="">Description=Connection
to
LDAP/POSTGRESQL</div>
<div class="">Servername=localhost </div>
<div class="">Port=5432 </div>
<div class="">Protocol=6.4</div>
<div class="">FetchBufferSize=99</div>
<div class="">Username=freeswitch_user</div>
<div class="">Password=XXX</div>
<div class="">Database=freeswitch_db</div>
<div class="">ReadOnly=no</div>
<div class="">Debug=0</div>
<div class="">CommLog=0</div>
</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/etc#
cat
odbcinst.ini </div>
<div class="">[PostgreSQL]</div>
<div class="">Description
= PostgreSQL
driver for
Linux &
Win32</div>
<div class="">;Driver =
/usr/lib64/odbc/psqlodbcw.so</div>
<div class="">Driver =
/usr/lib/x86_64-linux-gnu/odbc<wbr class="">/psqlodbcw.so</div>
<div class="">Threading
= 0</div>
<div class="">MaxLongVarcharSize=65536</div>
</div>
<div class=""><br class="">
</div>
<div class="">And then
connect to
psql through
odbc</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/etc#
isql -v
freeswitch</div>
<div class="">+-----------------------------<wbr class="">----------+</div>
<div class="">|
Connected!
|</div>
<div class="">|
|</div>
<div class="">|
sql-statement
|</div>
<div class="">| help
[tablename]
|</div>
<div class="">| quit
|</div>
<div class="">|
|</div>
<div class="">+-----------------------------<wbr class="">----------+</div>
<div class="">SQL> </div>
</div>
<div class=""><br class="">
</div>
<div class="">Then in
file
switch.conf.xml
I changed db
connection
configuration</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/usr/loc<wbr class="">al/freeswitch/conf/autoload_co<wbr class="">nfigs#
cat
switch.conf.xml
|grep
core-db-dsn</div>
<div class="">
<param
name="core-db-dsn"
value="<a class="">pgsql://hostaddr=127.0.<wbr class="">0.1</a>
dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE'"
/></div>
<div class="">
<!--<param
name="core-db-dsn" value="freeswitch:freeswitch_u<wbr class="">ser:XXX"/>--></div>
</div>
<div class=""><br class="">
</div>
<div class="">Last
night SwK user
at freenode
channel told
me that
freeswitch on
turning on, it
creates tables
at database
(thanks SwK).</div>
<div class=""><br class="">
</div>
<div class="">I spect
that
configuration
of odbc is
working but
drops lot of
errors (here
you have some
lines):</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">2018-05-24
02:03:25 CEST
[3099-338780]
freeswitch_user@freeswitch_db STATEMENT: PREPARE "_PLAN0x140bf90" as
CREATE TABLE
nat (</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
sticky
INTEGER,</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>port<span style="white-space:pre-wrap" class=""> </span>INTEGER,</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>proto<span style="white-space:pre-wrap" class=""> </span>INTEGER,</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
hostname
VARCHAR(256)</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>);</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>;EXECUTE
"_PLAN0x140bf90"</div>
<div class="">2018-05-24
02:03:25 CEST
[3099-338781]
freeswitch_user@freeswitch_db WARNING: there is already a transaction
in progress</div>
<div class="">2018-05-24
02:03:25 CEST
[3099-338782]
freeswitch_user@freeswitch_db ERROR: relation "registrations" does not
exist at
character 41</div>
<div class="">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 class="">2018-05-24
02:03:25 CEST
[3099-338784]
freeswitch_user@freeswitch_db WARNING: there is already a transaction
in progress</div>
<div class="">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 class="">2018-05-24
02:03:25 CEST
[3099-338786]
freeswitch_user@freeswitch_db STATEMENT: PREPARE "_PLAN0x140bf90" as
DROP TABLE
registrations;EXECUTE
"_PLAN0x140bf90"</div>
<div class="">2018-05-24
02:03:25 CEST
[3099-338787]
freeswitch_user@freeswitch_db WARNING: there is already a transaction
in progress</div>
<div class="">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 class="">2018-05-24
02:03:25 CEST
[3099-338789]
freeswitch_user@freeswitch_db STATEMENT: PREPARE "_PLAN0x140bf90" as
CREATE TABLE
registrations
(</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
reg_user
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
realm
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
token
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
url
TEXT,</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
expires
INTEGER,</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
network_ip
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
network_port
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
network_proto
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
hostname
VARCHAR(256),</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>
metadata
VARCHAR(256)</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>);</div>
<div class=""><span style="white-space:pre-wrap" class=""> </span>;EXECUTE
"_PLAN0x140bf90"</div>
<div class="">2018-05-24
02:03:25 CEST
[3099-338790]
freeswitch_user@freeswitch_db WARNING: there is already a transaction
in progress</div>
<div class="">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 class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">I tested
with tables in
psql database
and without
tables in psql
database.</div>
<div class=""><span style="color:rgb(80,0,80);font-size:12.8px" class=""><br class="">
</span></div>
<div class=""><span style="color:rgb(80,0,80);font-size:12.8px" class="">freeswitch@freeswitch-capa8>
version</span><br class="">
</div>
<div class=""><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" class="">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" class="">3c7<wbr class="">db639fd~64bit
(git 3c7db63
2018-05-16
21:12:08Z
64bit)</span><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">As I told
in last mail,
I'm working
with last git
version.</div>
<div class=""><br class="">
</div>
<div class="">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" class="">/usr/local/freeswitch/con<wbr class="">f/sip_profiles/internal.xml</span></div>
<div class=""><br class="">
</div>
<div class="">
<div class="">root@freeswitch-capa8:/usr/loc<wbr class="">al/freeswitch/conf#
cat
/usr/local/freeswitch/conf/sip<wbr class="">_profiles/internal.xml
|grep db</div>
<div class="">
<!-- Name
of the db to
use for this
profile --></div>
<div class="">
<!--<param
name="dbname"
value="share_presence"/>--></div>
<div class="">
<!--<param
name="odbc-dsn" value="dsn:user:pass"/>--></div>
<div class="">
<!--<param
name="odbc-dsn" value="freeswitch:freeswitch_u<wbr class="">ser:XXX"/>--></div>
<div class="">
<!--
<param
name="odbc-dsn"
value="<a class="">pgsql://hostaddr=127.0.<wbr class="">0.1</a>
dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c
client_min_messages=NOTICE'
application_name='freeswitch'" /> --></div>
<div class="">
<!--all
inbound reg
will stored in
the db using
this domain
--></div>
<div class="">
<param
name="force-register-db-domain<wbr class="">"
value="$${domain}"/></div>
</div>
<div class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">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 class=""><br class="">
</div>
<div class="">Thanks
you much for
your help :)</div>
<div class=""><br class="">
</div>
<div class="">References: </div>
<div class=""><a href="https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core" target="_blank" class="">https://freeswitch.org/conflue<wbr class="">nce/display/FREESWITCH/Postgre<wbr class="">SQL+in+the+core</a></div>
<div class=""><a href="https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN" target="_blank" class="">https://freeswitch.org/conflue<wbr class="">nce/display/FREESWITCH/ODBC+DS<wbr class="">N</a><br class="">
</div>
<div class=""><a href="https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases" target="_blank" class="">https://freeswitch.org/conflue<wbr class="">nce/display/FREESWITCH/FreeSWI<wbr class="">TCH+Databases</a><br class="">
</div>
<div class=""><br class="">
</div>
</div>
<div class="gmail_extra"><br clear="all" class="">
<div class="">
<div class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330m_4393266532543739197m_1464568345192727893gmail-m_3360575814196352002gmail_signature"><br class="">
- Blackhold<br class="">
<a href="http://blackhold.nusepas.com/" target="_blank" class="">http://blackhold.nusepas.com</a><br class="">
@blackhold_<br class="">
~> cal
lluitar contra
el fort per
deixar de ser
febles, i
contra
nosaltres
mateixos quan
siguem forts
(Xirinacs)<br class="">
<°(((
><</div>
</div>
<br class="">
<div class="gmail_quote">2018-05-24
18:21
GMT+02:00
Michael Jerris
<span dir="ltr" class=""><<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>></span>:<br class="">
<blockquote class="gmail_quote" style="margin: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 class="">
<span class=""><br class="">
> On May
23, 2018, at
6:13 PM,
Blackhold <<a href="mailto:blackholdmailer@gmail.com" target="_blank" class="">blackholdmailer@gmail.com</a>>
wrote:<br class="">
> <br class="">
> Hi,<br class="">
> I have
just installed
freeswitch 1.9<br class="">
> <br class="">
>
freeswitch@freeswitch-capa8>
version<br class="">
>
FreeSWITCH
Version
1.9.0+git~20180516T211208Z~3c7<wbr class="">db639fd~64bit
(git 3c7db63
2018-05-16
21:12:08Z
64bit)<br class="">
> <br class="">
> And I'm
trying to
freeswitch use
postgresql
instead
sqlitedb.<br class="">
> <br class="">
> I have
configured the
file
switch.conf.xml
of
/usr/local/freeswitch/conf/aut<wbr class="">oload_configs
with
uncomenting
and
configuring
this line<br class="">
> <br class="">
>
<param
name="core-db-dsn"
value="<a class="">pgsql://hostaddr=127.0</a>.<wbr class="">0.1
dbname=freeswitch_db user=freeswitch_user password='****' options='-c
client_min_messages=NOTICE'"
/><br class="">
> <br class="">
> then I
exported all
sqlitedbs to
sql and then
imported to a
database that
I have created
in postgresql<br class="">
> <br class="">
> I have
run again
/etc/init.d/freeswitch.sh
start<br class="">
> <br class="">
> But seems
it still is
taking
sqlitedb.<br class="">
> <br class="">
> I tried
to move the
sqlitedbs
files to other
side and
turned on
again
freeswitch,
but it creates
sqlitedbs
again.<br class="">
> <br class="">
> What I'm
missing? what
I'm doing
wrong? what
could I check?<br class="">
<br class="">
<br class="">
</span>______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional
FreeSWITCH
Consulting
Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official
FreeSWITCH
Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a></blockquote>
</div>
<br class="">
</div>
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional
FreeSWITCH
Consulting
Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official
FreeSWITCH
Sites<br class="">
<a href="http://www.freeswitch.org/" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" target="_blank" class="">http://www.freeswitch.org</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
<br class="">
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional
FreeSWITCH
Consulting
Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official
FreeSWITCH
Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH
Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing
list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" target="_blank" class="">http://www.freeswitch.org</a></div>
</blockquote>
</div>
<br class="">
</div>
</div>
</div>
</div>
<br class="">
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting
Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="">______________________________<wbr class="">______________________________<wbr class="">_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitchsolutions.com/" target="_blank">http://www.freeswitchsolutions<wbr class="">.com</a>
Official FreeSWITCH Sites
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://confluence.freeswitch.org/" target="_blank">http://confluence.freeswitch.o<wbr class="">rg</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a>
UNSUBSCRIBE:<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a>
<a class="m_1948172350244949374m_6786559865130825391m_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a></pre>
</blockquote>
<br class="">
</div>
<br class="">
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/free<wbr class="">switch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="m_1948172350244949374m_6786559865130825391mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="">______________________________<wbr class="">______________________________<wbr class="">_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitchsolutions.com/" target="_blank">http://www.freeswitchsolutions<wbr class="">.com</a>
Official FreeSWITCH Sites
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://confluence.freeswitch.org/" target="_blank">http://confluence.freeswitch.o<wbr class="">rg</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a>
UNSUBSCRIBE:<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.frees<wbr class="">witch.org/mailman/options/<wbr class="">freeswitch-users</a>
<a class="m_1948172350244949374m_6786559865130825391moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a></pre>
</blockquote>
<br class="">
</div>
<br class="">
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.freeswitchsolutions<wbr class="">.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.o<wbr class="">rg</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.freeswi<wbr class="">tch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/ma<wbr class="">ilman/listinfo/freeswitch-user<wbr class="">s</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.frees<wbr class="">witch.org/mailman/options/<wbr class="">freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
</blockquote>
</div>
<br class="">
</div>
<br class="">
<fieldset class="m_1948172350244949374mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="">______________________________<wbr class="">______________________________<wbr class="">_____________
Professional FreeSWITCH Consulting Services:
<a class="m_1948172350244949374moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitchsolutions.com/" target="_blank">http://www.<wbr class="">freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://confluence.freeswitch.org/" target="_blank">http://confluence.freeswitch.<wbr class="">org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="m_1948172350244949374moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a>
UNSUBSCRIBE:<a class="m_1948172350244949374moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a>
<a class="m_1948172350244949374moz-txt-link-freetext" href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org</a></pre>
</blockquote>
<br class="">
</div>
<br class="">______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.<wbr class="">freeswitchsolutions.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.<wbr class="">org</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" class="">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class=""></blockquote></div><br class=""></div>
_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services:<br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">http://www.freeswitchsolutions.com<br class=""><br class="">Official FreeSWITCH Sites<br class="">http://www.freeswitch.org<br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></body></html>