[Freeswitch-users] sqldb and GREAT SCOTT! errors

Guillermo Ruiz Camauer grcamauer at gmail.com
Wed Oct 22 02:47:50 MSD 2014


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?
>>>>>
>>>>> --
>>>>> 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
>>>
>>> _________________________________________________________________________
>>> 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
>



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


Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list