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@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@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@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@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