[Freeswitch-users] sqldb and GREAT SCOTT! errors

Wed Oct 22 02:12:09 MSD 2014

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?
>>
>> --
>> Guillermo Ruiz Camauer
>>
>> _________________________________________________________________________
>> 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
>>
>
>
>
> --
> Anthony Minessale II       ♬ @anthmfs  ♬ @FreeSWITCH  ♬
>
> ☞ http://freeswitch.org/  ☞ http://cluecon.com/  ☞
> http://twitter.com/FreeSWITCH
> ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+
> <http://freeswitch.org/g+>*
>
> ClueCon Weekly Development Call
> ☎ sip:888 at conference.freeswitch.org  ☎ +19193869900
>
>
> _________________________________________________________________________
> 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/20141021/1f4fec50/attachment-0001.html 