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" /> any ideas? -- 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
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" />
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
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
participants (2)
-
Luis Daniel Lucio Quiroz
-
Michael Jerris