[Freeswitch-users] [ERR] switch_core_sqldb.c:587 NATIVE SQL ERR [cannot commit - no transaction is active]

Fri Oct 9 17:12:26 MSD 2015

Check what user freeswitch is running as, ,then do
chown [put your freeswitch user here] -R [put your freeswitch directory
here]

On Fri, Oct 9, 2015 at 6:36 AM, Kiran Patil <kirantpatil at gmail.com> wrote:

> Hi,
>
> I now installed on docker using below links and it started working without
> any issues.
>
> 1. http://www.slideshare.net/ssuser1a9bef15/freeswitch-on-docker <= it
> does not contain all packages so it is advised to use the step 2 link to
> install all the packages before moving to compilation
> 2. https://freeswitch.org/confluence/display/FREESWITCH/CentOS+7
> 3. To add a SIP account to Empathy install "telepathy-rakia"
> 4. Changed the default password to 12345 cause it was showing error on
> fs_cli
> 5. Tested with Empathy sip client
>
> [root at 33fbb2dcab6c freeswitch]# bin/freeswitch -version
> FreeSWITCH version: 1.6.2+git~20150925T145020Z~643e3ff88f~64bit (git
> 643e3ff 2015-09-25 14:50:20Z 64bit)
>
> $ sudo docker images
>
> REPOSITORY              TAG                 IMAGE ID
> CREATED             VIRTUAL SIZE
> freeswitch_configured   latest              b98eb3f6c80c        42 minutes
> ago      1.858 GB
> freeswitch              latest              e9d878973874        2 hours
> ago         1.858 GB
> docker.io/centos        latest              0f73ae75014f        4 weeks
> ago         172.3 MB
>
> Thanks all.
> Kiran.
>
> On Thu, Oct 8, 2015 at 11:01 PM, Chris Mandra <mandra at gmail.com> wrote:
>
>> 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 at 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 at lists.freeswitch.org [mailto:
>>> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Kiran
>>> Patil
>>> *Sent:* Thursday, October 8, 2015 7:55 AM
>>> *To:* freeswitch-users at 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 at freeswitch freeswitch]# freeswitch -version
>>> FreeSWITCH version: 1.6.2~64bit ( 64bit)
>>>
>>> [root at 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 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
>>>
>>
>>
>>
>> --
>> mandra
>> c:410.258.5281
>>
>> _________________________________________________________________________
>> 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
>>
>
>
> _________________________________________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151009/256d8a2f/attachment.html 