<div dir="ltr">Ken,<div><br></div><div>Thanks for your suggestion. This is an outbound IVR server, so no voicemail, so that wont be a problem.</div><div><br></div><div>I stopped FS, erased the log file and then ran: mount -t tmpfs -o size=250M,mode=0755 tmpfs /usr/local/freeswitch/db</div><div><br></div><div>Started FS and this was written to the log:</div><div><br></div><div><div>2014-10-22 16:28:41.182119 [CRIT] switch_core_sqldb.c:507 Failure to connect to CORE_DB sofia_reg_iplantrunk!</div><div>2014-10-22 16:28:41.182123 [CRIT] sofia.c:2750 Cannot Open SQL Database [iplantrunk]!</div><div>2014-10-22 16:28:42.691286 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]</div><div>2014-10-22 16:28:42.691308 [CRIT] switch_core_sqldb.c:507 Failure to connect to CORE_DB call_limit!</div><div>2014-10-22 16:28:43.196185 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]</div><div>2014-10-22 16:28:43.196207 [CRIT] switch_core_sqldb.c:507 Failure to connect to CORE_DB fifo!</div><div>2014-10-22 16:28:43.196216 [CRIT] mod_fifo.c:4407 Cannot open DB!</div><div>2014-10-22 16:28:43.198799 [ERR] switch_core_db.c:223 SQL ERR [unable to open database file]</div><div>2014-10-22 16:28:43.198823 [CRIT] switch_core_sqldb.c:507 Failure to connect to CORE_DB voicemail_default!</div><div>2014-10-22 16:28:43.198833 [CRIT] mod_voicemail.c:772 Cannot open DB!</div></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Oct 22, 2014 at 1:34 PM, Ken Rice <span dir="ltr"><<a href="mailto:krice@freeswitch.org" target="_blank">krice@freeswitch.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<font face="Monaco, Courier New"><span style="font-size:11pt">Why not just mount the freeswitch/db directory as tmp fs<br>
<br>
# mount –t tmpfs tmpfs /usr/local/freeswitch/db <br>
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<div><div class="h5"><br>
<br>
<br>
On 10/22/14 11:27 AM, "Anthony Minessale" <<a href="http://anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
<br>
</div></div></span></font><div><div class="h5"><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">I tried to do the same to see what happens and it works for me.<br>
<br>
what does ls -ld /run/shm say?<br>
<br>
for me it's <br>
drwxrwxrwt 2 root root 180 Oct 22 11:23 /run/shm<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
On Tue, Oct 21, 2014 at 6:29 PM, Guillermo Ruiz Camauer <<a href="http://grcamauer@gmail.com" target="_blank">grcamauer@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">OK, so when I run with -nosql or with <param name="core-db-name" value="/usr/local/freeswitch/db/core.db" /><br>
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.<br>
<br>
root@FS2:~# ls -la /dev/shm<br>
lrwxrwxrwx 1 root root 8 Oct 21 20:02 /dev/shm -> /run/shm<br>
<br>
and I can freely copy files to and from /dev/shm.<br>
<br>
FS is running as a service with user freeswitch/daemon or starting it by hand as root. Either way produces the same error.<br>
<font color="#888888"><br>
Guillermo<br>
<br>
</font><br>
On Tue, Oct 21, 2014 at 7:55 PM, Anthony Minessale <<a href="http://anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">I already provided a suggestion.<br>
<br>
On Tue, Oct 21, 2014 at 5:47 PM, Guillermo Ruiz Camauer <<a href="http://grcamauer@gmail.com" target="_blank">grcamauer@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">If I run FS with -nosql I don't get any errors. What exaclty do I miss out on by doing this?<br>
<br>
Guillermo<br>
<br>
On Tue, Oct 21, 2014 at 7:46 PM, Guillermo Ruiz Camauer <<a href="http://grcamauer@gmail.com" target="_blank">grcamauer@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">All I did was:<br>
<param name="core-db-name" value="/dev/shm/core.db" /><br>
I manually copied something to /deb/shm and no problem.<br>
Any thoughts?<br>
<font color="#888888"><br>
Guillermo<br>
<br>
<br>
</font><br>
On Tue, Oct 21, 2014 at 7:18 PM, Anthony Minessale <<a href="http://anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">Maybe start over and use the real dir for db and trace your steps to moving it to memdisk.<br>
Maybe the memdisk is mounted read only.<br>
<br>
<br>
On Tue, Oct 21, 2014 at 5:12 PM, Guillermo Ruiz Camauer <<a href="http://grcamauer@gmail.com" target="_blank">grcamauer@gmail.com</a>> wrote:<br>
</span></font><blockquote><font face="Monaco, Courier New"><span style="font-size:11pt">I forgot to mention that I stopped FS, deleted core.db and started FS again, but the same errors result.<br>
<br>
Guillermo<br>
<br>
On Tue, Oct 21, 2014 at 6:58 PM, Anthony Minessale <<a href="http://anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br>
</span></font></blockquote></blockquote></blockquote></blockquote></blockquote></blockquote></blockquote></div></div><font face="Monaco, Courier New"><span style="font-size:11pt"><div><div class="h5">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.<br>
<br>
<br>
On Tue, Oct 21, 2014 at 4:43 PM, Guillermo Ruiz Camauer <<a href="http://grcamauer@gmail.com" target="_blank">grcamauer@gmail.com</a>> wrote:<br>
I am getting these errors in my FS log:<br>
<br>
2014-10-21 18:15:29.297837 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
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 '%'<br>
2014-10-21 18:15:29.297859 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot execute batched statements! [attempt to write a readonly database]<br>
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS<br>
2014-10-21 18:15:29.297876 [CRIT] sofia.c:2750 Cannot Open SQL Database [crossfonetrunk]!<br>
2014-10-21 18:15:29.301425 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
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 '%'<br>
2014-10-21 18:15:29.301449 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot execute batched statements! [attempt to write a readonly database]<br>
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS<br>
2014-10-21 18:15:29.301465 [CRIT] sofia.c:2750 Cannot Open SQL Database [external]!<br>
2014-10-21 18:15:29.302165 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
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 '%'<br>
2014-10-21 18:15:29.302190 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot execute batched statements! [attempt to write a readonly database]<br>
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS<br>
2014-10-21 18:15:29.302202 [CRIT] sofia.c:2750 Cannot Open SQL Database [internal]!<br>
2014-10-21 18:15:29.308285 [ERR] sofia.c:3292 Ignoring invalid name ''<br>
2014-10-21 18:15:30.799151 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
delete from limit_data where hostname='FS2';<br>
2014-10-21 18:15:31.306387 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
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<br>
2014-10-21 18:15:31.306466 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [attempt to write a readonly database]<br>
delete from fifo_outbound where static=1 and hostname='FS2'<br>
<br>
<br>
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.<br>
<br>
How can I get my FS working again?<br>
<br>
-- <br></div></div>
Ken<br>
<font color="#0000FF"><u><a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br>
<a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
<a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br>
</u></font><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
Twitter: @FreeSWITCH<br>
<br>
</span></font>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Guillermo Ruiz Camauer<br>
</div>