[Freeswitch-users] sqldb and GREAT SCOTT! errors

Thu Oct 23 02:22:50 MSD 2014

Ken,

Thanks for your suggestion.  This is an outbound IVR server, so no
voicemail, so that wont be a problem.

I stopped FS, erased the log file and then ran: mount -t tmpfs -o
size=250M,mode=0755 tmpfs /usr/local/freeswitch/db

Started FS and this was written to the log:

2014-10-22 16:28:41.182119 [CRIT] switch_core_sqldb.c:507 Failure to
connect to CORE_DB sofia_reg_iplantrunk!
2014-10-22 16:28:41.182123 [CRIT] sofia.c:2750 Cannot Open SQL Database
[iplantrunk]!
2014-10-22 16:28:42.691286 [ERR] switch_core_db.c:223 SQL ERR [unable to
open database file]
2014-10-22 16:28:42.691308 [CRIT] switch_core_sqldb.c:507 Failure to
connect to CORE_DB call_limit!
2014-10-22 16:28:43.196185 [ERR] switch_core_db.c:223 SQL ERR [unable to
open database file]
2014-10-22 16:28:43.196207 [CRIT] switch_core_sqldb.c:507 Failure to
connect to CORE_DB fifo!
2014-10-22 16:28:43.196216 [CRIT] mod_fifo.c:4407 Cannot open DB!
2014-10-22 16:28:43.198799 [ERR] switch_core_db.c:223 SQL ERR [unable to
open database file]
2014-10-22 16:28:43.198823 [CRIT] switch_core_sqldb.c:507 Failure to
connect to CORE_DB voicemail_default!
2014-10-22 16:28:43.198833 [CRIT] mod_voicemail.c:772 Cannot open DB!

On Wed, Oct 22, 2014 at 1:34 PM, Ken Rice <krice at freeswitch.org> wrote:

>  Why not just mount the freeswitch/db directory as tmp fs
>
> # mount –t tmpfs tmpfs /usr/local/freeswitch/db
> You can also put this in your fstab to make it persistant... The only
> thing you have to watch out for doing this is the location of your
> voicemail.db file as you’ll want that to persist over reboots... Everything
> else in there is fine to lose across reboots
>
>
>
> On 10/22/14 11:27 AM, "Anthony Minessale" <anthony.minessale at gmail.com>
> wrote:
>
> I tried to do the same to see what happens and it works for me.
>
> what does ls -ld /run/shm say?
>
> for me it's
> drwxrwxrwt 2 root root 180 Oct 22 11:23 /run/shm
>
>
>
>
>
>
>
>
> On Tue, Oct 21, 2014 at 6:29 PM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
>
> OK, so when I run with -nosql or with <param name="core-db-name"
> value="/usr/local/freeswitch/db/core.db" />
> I don't get errors.  As soon as I run with <param name="core-db-name"
> value="/dev/shm/core.db" />  I get the errors again.
>
> root at FS2:~# ls -la /dev/shm
> lrwxrwxrwx 1 root root 8 Oct 21 20:02 /dev/shm -> /run/shm
>
> and I can freely copy files to and from /dev/shm.
>
> FS is running as a service with user freeswitch/daemon or starting it by
> hand as root.  Either way produces the same error.
>
> Guillermo
>
>
> On Tue, Oct 21, 2014 at 7:55 PM, Anthony Minessale <
> anthony.minessale at gmail.com> wrote:
>
> I already provided a suggestion.
>
> On Tue, Oct 21, 2014 at 5:47 PM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
>
> If I run FS with -nosql  I don't get any errors.  What exaclty do I miss
> out on by doing this?
>
> Guillermo
>
> On Tue, Oct 21, 2014 at 7:46 PM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
>
> All I did was:
> <param name="core-db-name" value="/dev/shm/core.db" />
> I manually copied something to /deb/shm and no problem.
> Any thoughts?
>
> Guillermo
>
>
>
> On Tue, Oct 21, 2014 at 7:18 PM, Anthony Minessale <
> anthony.minessale at gmail.com> wrote:
>
> Maybe start over and use the real dir for db and trace your steps to
> moving it to memdisk.
> Maybe the memdisk is mounted read only.
>
>
> On Tue, Oct 21, 2014 at 5:12 PM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
>
> I forgot to mention that I stopped FS, deleted core.db and started FS
> again, but the same errors result.
>
> Guillermo
>
> On Tue, Oct 21, 2014 at 6:58 PM, Anthony Minessale <
> anthony.minessale at gmail.com> wrote:
>
> You might want to move them all out of the way and see if it creates new
> ones that work or open them with sqlite3 util to ensure they work.
>
>
> On Tue, Oct 21, 2014 at 4:43 PM, Guillermo Ruiz Camauer <
> grcamauer at gmail.com> wrote:
> I am getting these errors in my FS log:
>
> 2014-10-21 18:15:29.297837 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from sip_registrations where sub_host is null and hostname='FS2'
> and network_ip like '%' and network_port like '%' and sip_username like '%'
> and mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%'
> and orig_hostname like '%';delete from sip_registrations where sub_host is
> null and hostname='FS2' and network_ip like '%' and network_port like '%'
> and sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
> orig_server_host like '%' and orig_hostname like '%'
> 2014-10-21 18:15:29.297859 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
> execute batched statements! [attempt to write a readonly database]
> If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
> and enable FLAG_MULTI_STATEMENTS
> 2014-10-21 18:15:29.297876 [CRIT] sofia.c:2750 Cannot Open SQL Database
> [crossfonetrunk]!
> 2014-10-21 18:15:29.301425 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from sip_registrations where sub_host is null and hostname='FS2'
> and network_ip like '%' and network_port like '%' and sip_username like '%'
> and mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%'
> and orig_hostname like '%';delete from sip_registrations where sub_host is
> null and hostname='FS2' and network_ip like '%' and network_port like '%'
> and sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
> orig_server_host like '%' and orig_hostname like '%'
> 2014-10-21 18:15:29.301449 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
> execute batched statements! [attempt to write a readonly database]
> If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
> and enable FLAG_MULTI_STATEMENTS
> 2014-10-21 18:15:29.301465 [CRIT] sofia.c:2750 Cannot Open SQL Database
> [external]!
> 2014-10-21 18:15:29.302165 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from sip_registrations where sub_host is null and hostname='FS2'
> and network_ip like '%' and network_port like '%' and sip_username like '%'
> and mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%'
> and orig_hostname like '%';delete from sip_registrations where sub_host is
> null and hostname='FS2' and network_ip like '%' and network_port like '%'
> and sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
> orig_server_host like '%' and orig_hostname like '%'
> 2014-10-21 18:15:29.302190 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
> execute batched statements! [attempt to write a readonly database]
> If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
> and enable FLAG_MULTI_STATEMENTS
> 2014-10-21 18:15:29.302202 [CRIT] sofia.c:2750 Cannot Open SQL Database
> [internal]!
> 2014-10-21 18:15:29.308285 [ERR] sofia.c:3292 Ignoring invalid name ''
> 2014-10-21 18:15:30.799151 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from limit_data where hostname='FS2';
> 2014-10-21 18:15:31.306387 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> update fifo_outbound set
> start_time=0,stop_time=0,ring_count=0,use_count=0,outbound_call_count=0,outbound_fail_count=0
> where static=0
> 2014-10-21 18:15:31.306466 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from fifo_outbound where static=1 and hostname='FS2'
>
>
> My core.db file is in a ramdisk (/dev/~shm) and has all the right
> permissions.  I did a  'make clean modwipe' followed by a 'make current'
> and I still get the same errors.  I am on STABLE.
>
> How can I get my FS working again?
>
> --
> Ken
>
>
>
> *http://www.FreeSWITCH.org <http://www.FreeSWITCH.org>
> http://www.ClueCon.com <http://www.ClueCon.com> http://www.OSTAG.org
> <http://www.OSTAG.org> *irc.freenode.net #freeswitch
> Twitter: @FreeSWITCH
>
>
> _________________________________________________________________________
> 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
>

-- 
Guillermo Ruiz Camauer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141022/cd068ca8/attachment.html 