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