I had performed a make clean modwipe followed by make current and everything remained the same. Started from scratch with ./bootstrap and ./configure and problem has gone away. Thanks for all the help. Guillermo On Wed, Oct 22, 2014 at 4:20 PM, Guillermo Ruiz Camauer <grcamauer@gmail.com
wrote:
Anthony,
This is what I get:
drwxrwxrwt 2 root root 60 Oct 22 13:28 /run/shm which is very similar to yours.
I have tried making a different tmpfs which I mount manually, to no avail. Note that it creates the core.db file, so it can definitely write there. The problem is that inserts and updates don't work:
2014-10-22 13:58:25.245897 [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-22 13:58:25.245908 [CRIT] sofia.c:2750 Cannot Open SQL Database [internal]! 2014-10-22 13:58:25.251979 [ERR] sofia.c:3292 Ignoring invalid name '' 2014-10-22 13:58:26.743056 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database] delete from limit_data where hostname='FS2'; 2014-10-22 13:58:27.250209 [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-22 13:58:27.250285 [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'
Running database on HDD or running FS with -nosql eliminates this problem. I think this started after I updated Debian from Linux freeswitch 3.2.0-4-amd64 #1 SMP Debian 3.2.60-1+deb7u3 x86_64 GNU/Linux to Linux FS2 3.2.0-4-amd64 #1 SMP Debian 3.2.63-2 x86_64 GNU/Linux
Guillermo
On Wed, Oct 22, 2014 at 1:27 PM, Anthony Minessale < anthony.minessale@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@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@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@gmail.com> wrote:
I already provided a suggestion.
On Tue, Oct 21, 2014 at 5:47 PM, Guillermo Ruiz Camauer < grcamauer@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@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@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@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@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@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@freeswitch.org >>>> http://www.freeswitchsolutions.com >>>> >>>> Official FreeSWITCH Sites >>>> http://www.freeswitch.org >>>> http://confluence.freeswitch.org >>>> http://www.cluecon.com >>>> >>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >>>> http://www.cudatel.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 >>>> >>> >>> >>> >>> -- >>> 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@conference.freeswitch.org ☎ +19193869900 >>> >>> >>> >>> _________________________________________________________________________ >>> 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-powered IP PBX: The CudaTel Communication Server >>> http://www.cudatel.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 >>> >> >> >> >> -- >> Guillermo Ruiz Camauer >> >> >> _________________________________________________________________________ >> 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-powered IP PBX: The CudaTel Communication Server >> http://www.cudatel.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 >> > > > > -- > 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@conference.freeswitch.org ☎ +19193869900 > > > > _________________________________________________________________________ > 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-powered IP PBX: The CudaTel Communication Server > http://www.cudatel.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 >
-- Guillermo Ruiz Camauer
-- Guillermo Ruiz Camauer
_________________________________________________________________________ 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-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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
-- 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@conference.freeswitch.org ☎ +19193869900
_________________________________________________________________________ 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-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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
-- Guillermo Ruiz Camauer
_________________________________________________________________________ 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-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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
-- 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@conference.freeswitch.org ☎ +19193869900
_________________________________________________________________________ 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-powered IP PBX: The CudaTel Communication Server http://www.cudatel.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
-- Guillermo Ruiz Camauer
-- Guillermo Ruiz Camauer