[Freeswitch-users] Not honoring ODBC in the core

Sun Jun 4 00:25:34 UTC 2017

I have managed to move all modules to ODBC but the core. If it helps, this
deployment is using AWS RDS.

I have turned on all the debug options, and i get the following. Please
note that the core.db file is still being created. This output is not
telling me what is missing or failing to fix it :(     Any pointer will be
appreciated.

2017-06-04 00:21:52.739199 [INFO] switch_event.c:685 Activate Eventing
Engine.
2017-06-04 00:21:52.749458 [WARNING] switch_event.c:656 Create additional
event dispatch thread 0
2017-06-04 00:21:52.783529 [INFO] switch_nat.c:417 Scanning for NAT
2017-06-04 00:21:52.783645 [DEBUG] switch_nat.c:170 Checking for PMP 1/5
2017-06-04 00:21:53.783805 [DEBUG] switch_nat.c:170 Checking for PMP 2/5
2017-06-04 00:21:54.783954 [DEBUG] switch_nat.c:170 Checking for PMP 3/5
2017-06-04 00:21:55.784111 [DEBUG] switch_nat.c:170 Checking for PMP 4/5
2017-06-04 00:21:56.784274 [DEBUG] switch_nat.c:170 Checking for PMP 5/5
2017-06-04 00:21:57.784405 [ERR] switch_nat.c:199 Error checking for PMP
[general error]
2017-06-04 00:21:57.784435 [DEBUG] switch_nat.c:422 Checking for UPnP
2017-06-04 00:22:09.785033 [INFO] switch_nat.c:438 No PMP or UPnP NAT
devices detected!
2017-06-04 00:22:09.786686 [NOTICE] switch_core.c:2326 Set switchname to
fs02.prostarsentertainment.com
2017-06-04 00:22:09.787097 [INFO] switch_core_sqldb.c:3396 Opening DB
2017-06-04 00:22:09.787131 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such table: channels]
drop table channels
2017-06-04 00:22:09.787149 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such table: calls]
drop table calls
2017-06-04 00:22:09.787164 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such view: detailed_calls]
drop view detailed_calls
2017-06-04 00:22:09.787179 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such view: basic_calls]
drop view basic_calls
2017-06-04 00:22:09.787193 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such table: interfaces]
drop table interfaces
2017-06-04 00:22:09.787218 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no
such table: tasks]
drop table tasks
2017-06-04 00:22:09.787393 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no
such table: aliases]
[select hostname from aliases]
Auto Generating Table!
2017-06-04 00:22:09.787412 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL
ERR [no such table: aliases]
[DROP TABLE aliases]
2017-06-04 00:22:09.787562 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no
such table: complete]
[select hostname from complete]
Auto Generating Table!
2017-06-04 00:22:09.787582 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL
ERR [no such table: complete]
[DROP TABLE complete]
2017-06-04 00:22:09.787709 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no
such table: nat]
[select hostname from nat]
Auto Generating Table!
2017-06-04 00:22:09.787728 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL
ERR [no such table: nat]
[DROP TABLE nat]
2017-06-04 00:22:09.787822 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no
such table: registrations]
[delete from registrations where reg_user='']
Auto Generating Table!
2017-06-04 00:22:09.787842 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL
ERR [no such table: registrations]
[DROP TABLE registrations]
2017-06-04 00:22:09.788012 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no
such table: recovery]
[select hostname from recovery]
Auto Generating Table!
2017-06-04 00:22:09.788033 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL
ERR [no such table: recovery]
[DROP TABLE recovery]
2017-06-04 00:22:09.792959 [INFO] switch_core_sqldb.c:1693 CORE Starting
SQL thread.
2017-06-04 00:22:09.797506 [DEBUG] switch_scheduler.c:249 Added task 1
heartbeat (core) to run at 1496535729
2017-06-04 00:22:09.797533 [DEBUG] switch_scheduler.c:249 Added task 2
check_ip (core) to run at 1496535729

--
Luis Daniel Lucio Quiroz
CISSP, CISM, CISA
Linux, VoIP and much more fun
www.okay.com.mx

Need LCR? Check out LCR for FusionPBX with FreeSWITCH
Need Billing? Check out Billing for FusionPBX with FreeSWITCH

On Fri, Jun 2, 2017 at 6:07 PM, Michael Jerris <mike at jerris.com> wrote:

> take a look at the logs to see why it can’t connect to the db.
>
> > On Jun 2, 2017, at 11:30 AM, Luis Daniel Lucio Quiroz <
> luis.daniel.lucio at gmail.com> wrote:
> >
> > my FS 1.6.17 is not honoring my ODBC settings, it keeps creating core.db
> and other sqlite db's. I can confirm ODBC works, isql command connects
> without issues.
> >
> >    <param name="core-db-dsn" value="freeswitch:USER:XXXXXXXXXXXX" />
> >    <param name="core-recovery-db-dsn" value="freeswitch:USER:XXXXXXXX"
> />
> >
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170603/f4164c36/attachment-0001.html>