I've seen that before - if you install as sudo, but are runnning as freeswitch this happens On Thu, Oct 8, 2015 at 12:47 PM, Ken Rice <krice@freeswitch.org> wrote:
That means it cant access the db properly. Check your perms for the user FreeSWITCH is running as and make sure it has full read/write perms to the db dir, also make sure there is plenty of space on whatever mount point that is on
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Kiran Patil *Sent:* Thursday, October 8, 2015 7:55 AM *To:* freeswitch-users@lists.freeswitch.org *Subject:* [Freeswitch-users] [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]
Hi,
I installed Freeswitch 1.6.2 on CentOS 7.
[root@freeswitch freeswitch]# freeswitch -version FreeSWITCH version: 1.6.2~64bit ( 64bit)
[root@freeswitch freeswitch]# systemctl status freeswitch.service freeswitch.service - FreeSWITCH Loaded: loaded (/usr/lib/systemd/system/freeswitch.service; enabled) Active: active (running) since Thu 2015-10-08 17:50:38 IST; 29min ago Main PID: 12226 (freeswitch) CGroup: /system.slice/freeswitch.service └─12226 /usr/bin/freeswitch -nc -nf
Oct 08 17:50:38 freeswitch systemd[1]: Starting FreeSWITCH... Oct 08 17:50:38 freeswitch systemd[1]: Started FreeSWITCH.
Started Freeswitch daemon and typed fs_cli on cmd line and I am seeing only errors as below.
Please help me to resolve this issue.
BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database] BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database] BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database] BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database] BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [attempt to write a readonly database] BEGIN EXCLUSIVE 2015-10-08 18:11:35.190458 [CRIT] switch_core_sqldb.c:1952 ERROR [attempt to write a readonly database] 2015-10-08 18:11:35.190458 [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active] COMMIT
Thanks,
Kiran.
_________________________________________________________________________ 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-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
-- mandra c:410.258.5281