[Freeswitch-users] Not honoring ODBC in the core

Sun Jun 4 00:57:00 UTC 2017

It is working. It sounds like a dummy error, but after reading the source,
specifically the function _switch_cache_db_get_db_handle_dsn in the
file src/switch_core_sqldb.c, first i found that it is better to prefix
with ,odbc://, second I found in the freeswitch.xml the big issue
with <X-PRE-PROCESS cmd="include" data="autoload_configs/*.xml"/>, it seems
that my syncthing was creating double files without taking out the .xml
extension, this makes the to process another "backup" file which it was
overwriting the variable.

Thanks for your time

--
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 Sat, Jun 3, 2017 at 8:25 PM, Luis Daniel Lucio Quiroz <
luis.daniel.lucio at gmail.com> wrote:

> 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/8a23963c/attachment.html>