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

Fri Oct 9 14:36:55 MSD 2015

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151009/e3b6e063/attachment-0001.html 