<div dir="ltr"><div>I have managed to move all modules to ODBC but the core. If it helps, this deployment is using AWS RDS.</div><div><br></div>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.<div><br></div><div><div>2017-06-04 00:21:52.739199 [INFO] switch_event.c:685 Activate Eventing Engine.</div><div>2017-06-04 00:21:52.749458 [WARNING] switch_event.c:656 Create additional event dispatch thread 0</div><div>2017-06-04 00:21:52.783529 [INFO] switch_nat.c:417 Scanning for NAT</div><div>2017-06-04 00:21:52.783645 [DEBUG] switch_nat.c:170 Checking for PMP 1/5</div><div>2017-06-04 00:21:53.783805 [DEBUG] switch_nat.c:170 Checking for PMP 2/5</div><div>2017-06-04 00:21:54.783954 [DEBUG] switch_nat.c:170 Checking for PMP 3/5</div><div>2017-06-04 00:21:55.784111 [DEBUG] switch_nat.c:170 Checking for PMP 4/5</div><div>2017-06-04 00:21:56.784274 [DEBUG] switch_nat.c:170 Checking for PMP 5/5</div><div>2017-06-04 00:21:57.784405 [ERR] switch_nat.c:199 Error checking for PMP [general error]</div><div>2017-06-04 00:21:57.784435 [DEBUG] switch_nat.c:422 Checking for UPnP</div><div>2017-06-04 00:22:09.785033 [INFO] switch_nat.c:438 No PMP or UPnP NAT devices detected!</div><div>2017-06-04 00:22:09.786686 [NOTICE] switch_core.c:2326 Set switchname to <a href="http://fs02.prostarsentertainment.com">fs02.prostarsentertainment.com</a></div><div>2017-06-04 00:22:09.787097 [INFO] switch_core_sqldb.c:3396 Opening DB</div><div>2017-06-04 00:22:09.787131 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such table: channels]</div><div>drop table channels</div><div>2017-06-04 00:22:09.787149 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such table: calls]</div><div>drop table calls</div><div>2017-06-04 00:22:09.787164 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such view: detailed_calls]</div><div>drop view detailed_calls</div><div>2017-06-04 00:22:09.787179 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such view: basic_calls]</div><div>drop view basic_calls</div><div>2017-06-04 00:22:09.787193 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such table: interfaces]</div><div>drop table interfaces</div><div>2017-06-04 00:22:09.787218 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [no such table: tasks]</div><div>drop table tasks</div><div>2017-06-04 00:22:09.787393 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: aliases]</div><div>[select hostname from aliases]</div><div>Auto Generating Table!</div><div>2017-06-04 00:22:09.787412 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: aliases]</div><div>[DROP TABLE aliases]</div><div>2017-06-04 00:22:09.787562 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: complete]</div><div>[select hostname from complete]</div><div>Auto Generating Table!</div><div>2017-06-04 00:22:09.787582 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: complete]</div><div>[DROP TABLE complete]</div><div>2017-06-04 00:22:09.787709 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: nat]</div><div>[select hostname from nat]</div><div>Auto Generating Table!</div><div>2017-06-04 00:22:09.787728 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: nat]</div><div>[DROP TABLE nat]</div><div>2017-06-04 00:22:09.787822 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: registrations]</div><div>[delete from registrations where reg_user='']</div><div>Auto Generating Table!</div><div>2017-06-04 00:22:09.787842 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: registrations]</div><div>[DROP TABLE registrations]</div><div>2017-06-04 00:22:09.788012 [DEBUG] switch_core_sqldb.c:1347 SQL ERR [no such table: recovery]</div><div>[select hostname from recovery]</div><div>Auto Generating Table!</div><div>2017-06-04 00:22:09.788033 [DEBUG] switch_core_sqldb.c:1354 Ignoring SQL ERR [no such table: recovery]</div><div>[DROP TABLE recovery]</div><div>2017-06-04 00:22:09.792959 [INFO] switch_core_sqldb.c:1693 CORE Starting SQL thread.</div><div>2017-06-04 00:22:09.797506 [DEBUG] switch_scheduler.c:249 Added task 1 heartbeat (core) to run at 1496535729</div><div>2017-06-04 00:22:09.797533 [DEBUG] switch_scheduler.c:249 Added task 2 check_ip (core) to run at 1496535729</div></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>--</div><div>Luis Daniel Lucio Quiroz<br>CISSP, CISM, CISA<br>Linux, VoIP and much more fun<br><a href="http://www.okay.com.mx" target="_blank">www.okay.com.mx</a><br><br>Need LCR? Check out LCR for FusionPBX with FreeSWITCH<br>Need Billing? Check out Billing for FusionPBX with FreeSWITCH</div></div></div></div>
<br><div class="gmail_quote">On Fri, Jun 2, 2017 at 6:07 PM, Michael Jerris <span dir="ltr"><<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">take a look at the logs to see why it can’t connect to the db.<br>
<span class=""><br>
> On Jun 2, 2017, at 11:30 AM, Luis Daniel Lucio Quiroz <<a href="mailto:luis.daniel.lucio@gmail.com">luis.daniel.lucio@gmail.com</a>> wrote:<br>
><br>
> 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.<br>
><br>
> <param name="core-db-dsn" value="freeswitch:USER:<wbr>XXXXXXXXXXXX" /><br>
> <param name="core-recovery-db-dsn" value="freeswitch:USER:<wbr>XXXXXXXX" /><br>
><br>
<br>
<br>
</span>______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" rel="noreferrer" target="_blank">http://www.<wbr>freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" rel="noreferrer" target="_blank">http://confluence.freeswitch.<wbr>org</a><br>
<a href="http://www.cluecon.com" rel="noreferrer" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" rel="noreferrer" target="_blank">http://www.freeswitch.org</a></blockquote></div><br></div>