for the profile this one <param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" /> core-db-dsn is only for swithc.conf.xml if I recall well. On 5/24/2018 5:13 PM, Blackhold wrote:
wich string I have to add?
<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'" />
or
<param name="odbc-dsn" value="pgsql://hostaddr=127.0.0.1 dbname=freeswitch_db user=freeswitch_user password='XXX' options='-c client_min_messages=NOTICE' application_name='freeswitch'" />
?
for example for file conf/sip_profiles/internal.xml:231
wich modules needs db connection?
thanks!
- Blackhold http://blackhold.nusepas.com @blackhold_ ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs) <°((( ><
2018-05-25 1:33 GMT+02:00 Madovsky <infos@madovsky.org <mailto:infos@madovsky.org>>:
if you set pgsql:// in switch.conf.xml so
you must set pgsql:// in every config where a DB is involved
On 5/24/2018 4:11 PM, Blackhold wrote:
what or wich is the sip profile?
I understand that all tables that are created in sqlite are the ones that have to create to psql database that I'm refering all time...
The configs I'm showing all time are the real config (only changing password value)
2018-05-25 0:43 GMT+02:00 Madovsky <infos@madovsky.org <mailto:infos@madovsky.org>>:
are you sure you are using the proper sip profile which use pgsql:// ?
On 5/24/2018 3:20 PM, Blackhold wrote:
it seems nothing... yes tells something, but no one error, it seems all modules are loaded ok.
2018-05-24 22:58:20.552211 [INFO] sofia.c:5987 Setting MAX Auth Validity to 0 Attempts
2018-05-24 22:58:20.557248 [INFO] switch_core_sqldb.c:1693 sofia:external Starting SQL thread.
2018-05-24 22:58:20.562295 [NOTICE] sofia.c:4172 Adding Alias [10.90.226.83] for profile [internal] 2018-05-24 22:58:20.562424 [WARNING] sofia.c:2285 MSG Thread 0 Started
2018-05-24 22:58:22.059111 [CONSOLE] switch_loadable_module.c:1540 Successfully Loaded [mod_db] 2018-05-24 22:58:22.059118 [NOTICE] switch_loadable_module.c:292 Adding Application 'db' 2018-05-24 22:58:22.059128 [NOTICE] switch_loadable_module.c:292 Adding Application 'group' 2018-05-24 22:58:22.059137 [NOTICE] switch_loadable_module.c:338 Adding API Function 'db' 2018-05-24 22:58:22.059146 [NOTICE] switch_loadable_module.c:338 Adding API Function 'group' 2018-05-24 22:58:22.059154 [NOTICE] switch_loadable_module.c:556 Adding Limit interface 'db'
- Blackhold http://blackhold.nusepas.com @blackhold_ ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs) <°((( ><
2018-05-24 23:23 GMT+02:00 Madovsky <infos@madovsky.org <mailto:infos@madovsky.org>>:
and anything in FS logs?
On 5/24/2018 1:59 PM, Blackhold wrote:
done, restarted psql and turned on freeswitch, nothing in psql log files, no tables where created.
using psql conector
- Blackhold http://blackhold.nusepas.com @blackhold_ ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs) <°((( ><
2018-05-24 22:41 GMT+02:00 Madovsky <infos@madovsky.org <mailto:infos@madovsky.org>>:
remove these 2 lines
local all postgres peer
local all all peer
and replace with
local all all trust
in your pg_hba.conf
On 5/24/2018 1:26 PM, Blackhold wrote:
Hi,
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:
<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'" />
so then, I only will use that, and the problem is my system, not freeswitch.
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?!
Here you have the versions of libraries I have:
# debian 8 fresh install (x86_64)
root@freeswitch-capa8:~# cat /etc/debian_version 8.10 root@freeswitch-capa8:~# dpkg -l |grep postgresql ii odbc-postgresql:amd64 1:09.03.0300-1 amd64 ODBC driver for PostgreSQL ii postgresql 9.4+165+deb8u3 all object-relational SQL database (supported version) ii postgresql-9.4 9.4.15-0+deb8u1 amd64 object-relational SQL database, version 9.4 server ii postgresql-client 9.4+165+deb8u3 all front-end programs for PostgreSQL (supported version) ii postgresql-client-9.4 9.4.15-0+deb8u1 amd64 front-end programs for PostgreSQL 9.4 ii postgresql-client-common 165+deb8u3 all manager for multiple PostgreSQL client versions ii postgresql-common 165+deb8u3 all PostgreSQL database-cluster manager root@freeswitch-capa8:~# dpkg -l |grep libpq ii libpq-dev 9.4.15-0+deb8u1 amd64 header files for libpq5 (PostgreSQL library) ii libpq5:amd64 9.4.15-0+deb8u1 amd64 PostgreSQL C client library
all these packages are downloaded from sources
the lines enabled at pg_hba.conf are these (the debian default ones)
local all postgres peer local all all peer host all all 127.0.0.1/32 <http://127.0.0.1/32> md5 host all all ::1/128 md5
the script that I have used to do the installation is the one located in source code
root@freeswitch-capa8:/usr/src/freeswitch/scripts# ls -l |grep raspbian-installer -rwxr-xr-x 1 root root 7922 May 23 20:26 FreeSWITCH-debian-raspbian-installer.sh
- Blackhold http://blackhold.nusepas.com @blackhold_ ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs) <°((( ><
2018-05-24 21:58 GMT+02:00 Madovsky <infos@madovsky.org <mailto:infos@madovsky.org>>:
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
postgresql 6.x !??!)
what version of postgresql are you using? compiled yourself or from system package?
check if there are not multiple versions of libpq.xx in your system.
check pg_hba.conf if localhost is on trust mode for all local users.
if you compiled yourself so be sure the right libpq.xx have been chosen.
On 5/24/2018 12:33 PM, Blackhold wrote:
nope, it is not able to create stuff
now I also have enabled that in switch.conf.xml
<param name="auto-create-schemas" value="true"/> <param name="auto-clear-sql" value="true"/>
tested with odbc and directly with psql and behaviour is the same.
for psql the procedure I have followed is
root@freeswitch-capa8:~# su - postgres root@freeswitch-capa8:~#postgres@freeswitch-capa8:~$ createuser freeswitch_user root@freeswitch-capa8:~#createdb -O freeswitch_user freeswitch_db root@freeswitch-capa8:~#psql freeswitch_db freeswitch_db=# ALTER USER freeswitch_user WITH PASSWORD 'XXX'; freeswitch_db=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO freeswitch_user; freeswitch_db=# GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO freeswitch_user;
the most beatiful was with odbc + tables created... in the last mail... freeswitch turned on, in other ways freeswitch doesn't turns on.
logs doesn't talk about permissions....
- Blackhold http://blackhold.nusepas.com @blackhold_ ~> cal lluitar contra el fort per deixar de ser febles, i contra nosaltres mateixos quan siguem forts (Xirinacs) <°((( ><
2018-05-24 21:20 GMT+02:00 Michael Jerris <mike@jerris.com <mailto:mike@jerris.com>>:
you shouldn't need to pre-import the tables, if the permissions are right, it should create the tables and indexes for you.
> On May 24, 2018, at 3:15 PM, Blackhold > <blackholdmailer@gmail.com > <mailto:blackholdmailer@gmail.com>> wrote: > > I continue with tests > > I think I know wich problem I had with > errors > > I have missed to grant privileges in psql: > > GRANT ALL PRIVILEGES ON ALL TABLES IN > SCHEMA public TO freeswitch_user; > GRANT ALL PRIVILEGES ON ALL SEQUENCES IN > SCHEMA public TO freeswitch_user; > > # with tables imported from sqlite it > shows (freeswitch runs) > > root@freeswitch-capa8:/var/log/postgresql# > tail -f postgresql-9.4-main.log > > 2018-05-24 21:03:34 CEST [8623-1] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-3] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-5] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-7] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-9] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-11] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-13] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-15] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-17] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-19] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-21] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-23] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-25] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-27] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-29] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-31] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-33] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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,a10,hostname);EXECUTE > "_PLAN0x123ff90" > 2018-05-24 21:03:34 CEST [8623-35] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-37] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-39] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-41] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-43] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-45] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-47] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-49] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-51] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-53] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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" > 2018-05-24 21:03:34 CEST [8623-55] > freeswitch_user@freeswitch_db ERROR: > syntax error at or near "create" at > character 29 > 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);EXECUTE > "_PLAN0x123ff90" > > # with a clean database > > start dropping last errors, and don't > create any table in db. Freeswitch > doesn't turns on. > > each time I stop freeswitch when it > don't runs, it keeps a process running > that I have to kill manually > > root@freeswitch-capa8:/var/log/postgresql# ps > aux |grep free > root 8706 39.6 0.7 141296 15244 ? S<l > 21:08 1:13 > /usr/local/freeswitch/bin/freeswitch -nc > > > # with granted permisions if I turn > configuration to not use odbc, using > psql directly > > freeswitch turns on, there's no errors > in psql log file and no table was > created on db. > > > > - Blackhold > http://blackhold.nusepas.com > <http://blackhold.nusepas.com/> > @blackhold_ > ~> cal lluitar contra el fort per deixar > de ser febles, i contra nosaltres > mateixos quan siguem forts (Xirinacs) > <°((( >< > > 2018-05-24 20:31 GMT+02:00 Blackhold > <blackholdmailer@gmail.com > <mailto:blackholdmailer@gmail.com>>: > > # OK for location of ODBC files > > # output freeswitch using psql (I > only edited switch.conf.xml file) > <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'" /> > (switch.conf.xml file) > > I see no errors related on logs (nor > freeswitch, nor psql -debug5-), > obviously restarted psql to reload > config. > > in sofia.conf.xml file I found no > option to configure it pointing to > database > no other config file, except > switch.conf.xml has configured > database pointing > > I tried to configure db.conf.xml > file, with switch.conf.xml line but > also do nothing > > # output freeswtich using odbc > <param name="core-db-dsn" > value="freeswitch:freeswitch_user:XXX"/> > (switch.conf.xml file) > > these are the first lines of > postgresql log file > > 2018-05-24 20:23:15 CEST [7518-7] > LOG: received fast shutdown request > 2018-05-24 20:23:15 CEST [7518-8] > LOG: aborting any active transactions > 2018-05-24 20:23:15 CEST [7548-2] > LOG: autovacuum launcher shutting down > 2018-05-24 20:23:15 CEST [7545-1] > LOG: shutting down > 2018-05-24 20:23:15 CEST [7545-2] > LOG: database system is shut down > 2018-05-24 20:23:16 CEST [7568-1] > LOG: database system was shut down > at 2018-05-24 20:23:15 CEST > 2018-05-24 20:23:16 CEST [7568-2] > LOG: MultiXact member wraparound > protections are now enabled > 2018-05-24 20:23:16 CEST [7567-1] > LOG: database system is ready to > accept connections > 2018-05-24 20:23:16 CEST [7572-1] > LOG: autovacuum launcher started > 2018-05-24 20:23:16 CEST [7574-1] > [unknown]@[unknown] LOG: incomplete > startup packet > 2018-05-24 20:23:39 CEST [7596-1] > freeswitch_user@freeswitch_db ERROR: > relation "channels" does not exist > at character 40 > 2018-05-24 20:23:39 CEST [7596-2] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as delete from channels where > hostname='freeswitch-capa8';EXECUTE > "_PLAN0x9f3f90" > 2018-05-24 20:23:39 CEST [7596-3] > freeswitch_user@freeswitch_db ERROR: > relation "calls" does not exist at > character 40 > 2018-05-24 20:23:39 CEST [7596-4] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as delete from calls where > hostname='freeswitch-capa8';EXECUTE > "_PLAN0x9f3f90" > 2018-05-24 20:23:39 CEST [7596-5] > freeswitch_user@freeswitch_db ERROR: > relation "tasks" does not exist at > character 40 > 2018-05-24 20:23:39 CEST [7596-6] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as delete from tasks where > hostname='freeswitch-capa8';EXECUTE > "_PLAN0x9f3f90" > 2018-05-24 20:23:39 CEST [7596-7] > freeswitch_user@freeswitch_db ERROR: > relation "aliases" does not exist at > character 49 > 2018-05-24 20:23:39 CEST [7596-8] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as select hostname from > aliases;EXECUTE "_PLAN0x9f3f90" > 2018-05-24 20:23:39 CEST [7596-9] > freeswitch_user@freeswitch_db > ERROR: syntax error at or near > "DROP" at character 28 > 2018-05-24 20:23:39 CEST [7596-10] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as DROP TABLE aliases;EXECUTE > "_PLAN0x9f3f90" > 2018-05-24 20:23:39 CEST [7596-11] > freeswitch_user@freeswitch_db > ERROR: syntax error at or near > "CREATE" at character 28 > 2018-05-24 20:23:39 CEST [7596-12] > freeswitch_user@freeswitch_db > STATEMENT: PREPARE "_PLAN0x9f3f90" > as CREATE TABLE aliases ( > sticky INTEGER, > alias VARCHAR(128), > command VARCHAR(4096), > hostname VARCHAR(256) > ); > ;EXECUTE "_PLAN0x9f3f90" > > and now freeswitch isn't able to run. > > If I enable odbc trace in odbcinst.ini > > Trace=Yes > TraceFile=/var/log/odbctrace.log > > Also there's no output.... > > In freeswitch log also there's > nothing about what is happening :( > > > - Blackhold > http://blackhold.nusepas.com > <http://blackhold.nusepas.com/> > @blackhold_ > ~> cal lluitar contra el fort per > deixar de ser febles, i contra > nosaltres mateixos quan siguem forts > (Xirinacs) > <°((( >< > > 2018-05-24 19:30 GMT+02:00 Michael > Jerris <mike@jerris.com > <mailto:mike@jerris.com>>: > > 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. > > >> On May 24, 2018, at 1:11 PM, >> Blackhold >> <blackholdmailer@gmail.com >> <mailto:blackholdmailer@gmail.com>> >> wrote: >> >> Hi, >> The tables are: >> >> ostgres@freeswitch-capa8:~/sql$ >> psql freeswitch_db >> freeswitch_db-# \dt >> >> List of relations >> Schema | Name | >> Type | Owner >> --------+-------------------------------------+-------+---------- >> public | aliases | >> table | postgres >> public | calls | table >> | postgres >> public | channels | >> table | postgres >> public | complete | >> table | postgres >> public | db_data | >> table | postgres >> public | fifo_bridge | >> table | postgres >> public | fifo_callers >> | table | postgres >> public | fifo_outbound >> | table | postgres >> public | group_data | >> table | postgres >> public | interfaces | >> table | postgres >> public | json_store | >> table | postgres >> public | limit_data | >> table | postgres >> public | nat | table | >> postgres >> public | recovery | >> table | postgres >> public | registrations >> | table | postgres >> public | sip_authentication >> | table | postgres >> public | sip_dialogs | >> table | postgres >> public | sip_presence >> | table | postgres >> public | sip_registrations >> | table | postgres >> public | >> sip_shared_appearance_dialogs >> | table | postgres >> public | >> sip_shared_appearance_subscriptions >> | table | postgres >> public | sip_subscriptions >> | table | postgres >> public | tasks | table >> | postgres >> public | voicemail_msgs >> | table | postgres >> public | voicemail_prefs >> | table | postgres >> (25 rows) >> >> I continued testing and found >> that if I configure >> switch.conf.xml file like this: >> >> <param name="core-db-dsn" >> value="pgsql://hostaddr=127.0.0.1 >> dbname=freeswitch_db >> user=freeswitch_user >> password='****' options='-c >> client_min_messages=NOTICE'" /> >> >> 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 >> >> 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? >> >> Here I show the config of odbc >> files: >> root@freeswitch-capa8:/etc# cat >> odbc.ini >> [freeswitch] >> ; WARNING: The old psql odbc >> driver psqlodbc.so is now >> renamed psqlodbcw.so >> ; in version 08.x. Note that >> the library can also be >> installed under an other >> ; path than /usr/local/lib/ >> following your installation. >> ; Driver = >> /usr/lib64/odbc/psqlodbcw.so >> ; Driver = >> /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so >> Driver = >> /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so >> Description=Connection to >> LDAP/POSTGRESQL >> Servername=localhost >> Port=5432 >> Protocol=6.4 >> FetchBufferSize=99 >> Username=freeswitch_user >> Password=XXX >> Database=freeswitch_db >> ReadOnly=no >> Debug=0 >> CommLog=0 >> >> root@freeswitch-capa8:/etc# cat >> odbcinst.ini >> [PostgreSQL] >> Description = PostgreSQL driver >> for Linux & Win32 >> ;Driver = >> /usr/lib64/odbc/psqlodbcw.so >> Driver = >> /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so >> Threading = 0 >> MaxLongVarcharSize=65536 >> >> And then connect to psql >> through odbc >> >> root@freeswitch-capa8:/etc# >> isql -v freeswitch >> +---------------------------------------+ >> | Connected! | >> | | >> | sql-statement | >> | help [tablename] | >> | quit | >> | | >> +---------------------------------------+ >> SQL> >> >> Then in file switch.conf.xml I >> changed db connection configuration >> >> root@freeswitch-capa8:/usr/local/freeswitch/conf/autoload_configs# >> cat switch.conf.xml |grep >> core-db-dsn >> <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'" /> >> <!--<param name="core-db-dsn" >> value="freeswitch:freeswitch_user:XXX"/>--> >> >> Last night SwK user at freenode >> channel told me that freeswitch >> on turning on, it creates >> tables at database (thanks SwK). >> >> I spect that configuration of >> odbc is working but drops lot >> of errors (here you have some >> lines): >> >> 2018-05-24 02:03:25 CEST >> [3099-338780] >> freeswitch_user@freeswitch_db >> STATEMENT: PREPARE >> "_PLAN0x140bf90" as CREATE >> TABLE nat ( >> sticky INTEGER, >> portINTEGER, >> protoINTEGER, >> hostname VARCHAR(256) >> ); >> ;EXECUTE "_PLAN0x140bf90" >> 2018-05-24 02:03:25 CEST >> [3099-338781] >> freeswitch_user@freeswitch_db >> WARNING: there is already a >> transaction in progress >> 2018-05-24 02:03:25 CEST >> [3099-338782] >> freeswitch_user@freeswitch_db >> ERROR: relation >> "registrations" does not exist >> at character 41 >> 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" >> 2018-05-24 02:03:25 CEST >> [3099-338784] >> freeswitch_user@freeswitch_db >> WARNING: there is already a >> transaction in progress >> 2018-05-24 02:03:25 CEST >> [3099-338785] >> freeswitch_user@freeswitch_db >> ERROR: syntax error at or near >> "DROP" at character 29 >> 2018-05-24 02:03:25 CEST >> [3099-338786] >> freeswitch_user@freeswitch_db >> STATEMENT: PREPARE >> "_PLAN0x140bf90" as DROP TABLE >> registrations;EXECUTE >> "_PLAN0x140bf90" >> 2018-05-24 02:03:25 CEST >> [3099-338787] >> freeswitch_user@freeswitch_db >> WARNING: there is already a >> transaction in progress >> 2018-05-24 02:03:25 CEST >> [3099-338788] >> freeswitch_user@freeswitch_db >> ERROR: syntax error at or near >> "CREATE" at character 29 >> 2018-05-24 02:03:25 CEST >> [3099-338789] >> freeswitch_user@freeswitch_db >> STATEMENT: PREPARE >> "_PLAN0x140bf90" as CREATE >> TABLE registrations ( >> reg_user VARCHAR(256), >> realm VARCHAR(256), >> token VARCHAR(256), >> url TEXT, >> expires INTEGER, >> network_ip VARCHAR(256), >> network_port VARCHAR(256), >> network_proto VARCHAR(256), >> hostname VARCHAR(256), >> metadata VARCHAR(256) >> ); >> ;EXECUTE "_PLAN0x140bf90" >> 2018-05-24 02:03:25 CEST >> [3099-338790] >> freeswitch_user@freeswitch_db >> WARNING: there is already a >> transaction in progress >> 2018-05-24 02:03:25 CEST >> [3099-338791] >> freeswitch_user@freeswitch_db >> LOG: unexpected EOF on client >> connection with an open transaction >> >> >> I tested with tables in psql >> database and without tables in >> psql database. >> >> freeswitch@freeswitch-capa8> >> version >> FreeSWITCH Version >> 1.9.0+git~20180516T211208Z~3c7db639fd~64bit >> (git 3c7db63 2018-05-16 >> 21:12:08Z 64bit) >> >> As I told in last mail, I'm >> working with last git version. >> >> 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 >> /usr/local/freeswitch/conf/sip_profiles/internal.xml >> >> root@freeswitch-capa8:/usr/local/freeswitch/conf# >> cat >> /usr/local/freeswitch/conf/sip_profiles/internal.xml >> |grep db >> <!-- Name of the db to use for >> this profile --> >> <!--<param name="dbname" >> value="share_presence"/>--> >> <!--<param name="odbc-dsn" >> value="dsn:user:pass"/>--> >> <!--<param name="odbc-dsn" >> value="freeswitch:freeswitch_user:XXX"/>--> >> <!-- <param name="odbc-dsn" >> value="pgsql://hostaddr=127.0.0.1 >> dbname=freeswitch_db >> user=freeswitch_user >> password='XXX' options='-c >> client_min_messages=NOTICE' >> application_name='freeswitch'" >> /> --> >> <!--all inbound reg will stored >> in the db using this domain --> >> <param >> name="force-register-db-domain" >> value="$${domain}"/> >> >> 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... >> >> 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. >> >> Thanks you much for your help :) >> >> References: >> https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core >> <https://freeswitch.org/confluence/display/FREESWITCH/PostgreSQL+in+the+core> >> https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN >> <https://freeswitch.org/confluence/display/FREESWITCH/ODBC+DSN> >> https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases >> <https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+Databases> >> >> >> >> - Blackhold >> http://blackhold.nusepas.com >> <http://blackhold.nusepas.com/> >> @blackhold_ >> ~> cal lluitar contra el fort >> per deixar de ser febles, i >> contra nosaltres mateixos quan >> siguem forts (Xirinacs) >> <°((( >< >> >> 2018-05-24 18:21 GMT+02:00 >> Michael Jerris <mike@jerris.com >> <mailto:mike@jerris.com>>: >> >> 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. >> >> > On May 23, 2018, at 6:13 >> PM, Blackhold >> <blackholdmailer@gmail.com >> <mailto:blackholdmailer@gmail.com>> >> wrote: >> > >> > Hi, >> > I have just installed >> freeswitch 1.9 >> > >> > >> freeswitch@freeswitch-capa8> >> version >> > FreeSWITCH Version >> 1.9.0+git~20180516T211208Z~3c7db639fd~64bit >> (git 3c7db63 2018-05-16 >> 21:12:08Z 64bit) >> > >> > And I'm trying to >> freeswitch use postgresql >> instead sqlitedb. >> > >> > I have configured the >> file switch.conf.xml of >> /usr/local/freeswitch/conf/autoload_configs >> with uncomenting and >> configuring this line >> > >> > <param >> name="core-db-dsn" >> value="pgsql://hostaddr=127.0.0.1 >> dbname=freeswitch_db >> user=freeswitch_user >> password='****' options='-c >> client_min_messages=NOTICE'" /> >> > >> > then I exported all >> sqlitedbs to sql and then >> imported to a database that >> I have created in postgresql >> > >> > I have run again >> /etc/init.d/freeswitch.sh start >> > >> > But seems it still is >> taking sqlitedb. >> > >> > I tried to move the >> sqlitedbs files to other >> side and turned on again >> freeswitch, but it creates >> sqlitedbs again. >> > >> > What I'm missing? what >> I'm doing wrong? what could >> I check? >> >> >> _________________________________________________________________________ >> Professional FreeSWITCH >> Consulting Services: >> consulting@freeswitch.org >> <mailto:consulting@freeswitch.org> >> http://www.freeswitchsolutions.com >> <http://www.freeswitchsolutions.com/> >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> <http://www.freeswitch.org/> >> http://confluence.freeswitch.org >> <http://confluence.freeswitch.org/> >> http://www.cluecon.com >> <http://www.cluecon.com/> >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@lists.freeswitch.org >> <mailto:FreeSWITCH-users@lists.freeswitch.org> >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users >> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> >> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users >> <http://lists.freeswitch.org/mailman/options/freeswitch-users> >> http://www.freeswitch.org >> <http://www.freeswitch.org/> >> >> >> _________________________________________________________________________ >> Professional FreeSWITCH >> Consulting Services: >> consulting@freeswitch.org >> <mailto:consulting@freeswitch.org> >> http://www.freeswitchsolutions.com >> <http://www.freeswitchsolutions.com/> >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> <http://www.freeswitch.org/> >> http://confluence.freeswitch.org >> <http://confluence.freeswitch.org/> >> http://www.cluecon.com >> <http://www.cluecon.com/> >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@lists.freeswitch.org >> <mailto:FreeSWITCH-users@lists.freeswitch.org> >> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users >> <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> >> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users >> <http://lists.freeswitch.org/mailman/options/freeswitch-users> >> http://www.freeswitch.org >> <http://www.freeswitch.org/> > > > _________________________________________________________________________ > Professional FreeSWITCH > Consulting Services: > consulting@freeswitch.org > <mailto:consulting@freeswitch.org> > http://www.freeswitchsolutions.com > <http://www.freeswitchsolutions.com/> > > Official FreeSWITCH Sites > http://www.freeswitch.org > <http://www.freeswitch.org/> > http://confluence.freeswitch.org > <http://confluence.freeswitch.org/> > http://www.cluecon.com > <http://www.cluecon.com/> > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > <mailto:FreeSWITCH-users@lists.freeswitch.org> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > <http://lists.freeswitch.org/mailman/options/freeswitch-users> > http://www.freeswitch.org > <http://www.freeswitch.org/> > > > > _________________________________________________________________________ > Professional FreeSWITCH Consulting Services: > consulting@freeswitch.org > <mailto:consulting@freeswitch.org> > http://www.freeswitchsolutions.com > <http://www.freeswitchsolutions.com> > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://confluence.freeswitch.org > <http://confluence.freeswitch.org> > http://www.cluecon.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@lists.freeswitch.org > <mailto:FreeSWITCH-users@lists.freeswitch.org> > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > <http://lists.freeswitch.org/mailman/options/freeswitch-users> > http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org <http://confluence.freeswitch.org> http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org