<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body 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="moz-cite-prefix">On 5/24/2018 1:26 PM, Blackhold wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAMFaAL0GxTtU_hNe-9irp3QaZCy92URdJ0uEX3QvNUWPv8oCaQ@mail.gmail.com">
<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.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" 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/freeswitch/scripts# ls -l
|grep raspbian-installer</div>
<div>-rwxr-xr-x 1 root root 7922 May 23 20:26
FreeSWITCH-debian-raspbian-installer.sh</div>
</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-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_-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:~$ <wbr>createuser
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_-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_-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_-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_-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_-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_-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_-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_-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_-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/<wbr>freeswitch-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/<wbr>freeswitch-users</a><br>
<a href="http://www.freeswitch.org"
rel="noreferrer" target="_blank"
moz-do-not-send="true">http://www.freeswitch.org</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset
class="m_-6505748881310717330mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>______________________________<wbr>_____________
Professional FreeSWITCH Consulting Services:
<a class="m_-6505748881310717330moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" target="_blank" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="m_-6505748881310717330moz-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_-6505748881310717330moz-txt-link-freetext" href="http://www.freeswitch.org" target="_blank" moz-do-not-send="true">http://www.freeswitch.org</a>
<a class="m_-6505748881310717330moz-txt-link-freetext" href="http://confluence.freeswitch.org" target="_blank" moz-do-not-send="true">http://confluence.freeswitch.<wbr>org</a>
<a class="m_-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_-6505748881310717330moz-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_-6505748881310717330moz-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_-6505748881310717330moz-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_-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"
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>