asterisk users - Nov 2018 - Asterisk non-root - selinux - astdb

Hi

I'm trying to use Asterisk running as non-root user and selinux enabled.
Asterisk is running ok, but astdb not works. When i try to put in astdb,
console shows this message:

WARNING[1853]: db.c:350 ast_db_put: Couldn't execute statment: SQL logic
error or missing database

CentOS 7.5.1804
Asterisk certified/13.21-cert3

[root at sv03 asterisk]# ls -lahZ /var/lib/asterisk/astdb.sqlite3
-rw-r-----. asterisk asterisk unconfined_u:object_r:asterisk_var_lib_t:s0
/var/lib/asterisk/astdb.sqlite3


Can anyone help?

Thanks.



Rafael S. Saraiva
<http://br.linkedin.com/pub/rafael-saraiva/52/aab/230>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181130/451419f7/attachment.html>

Hello,

I haven't tried but this post probably gives a solution :

https://bugzilla.redhat.com/show_bug.cgi?id=1342733

Regards

Jean Aunis

Le 30/11/2018 à 19:24, Rafael dos Santos Saraiva a
écrit :
> Hi
>
> I'm trying to use Asterisk running as non-root user and selinux 
> enabled. Asterisk is running ok, but astdb not works. When i try to 
> put in astdb, console shows this message:
>
> WARNING[1853]: db.c:350 ast_db_put: Couldn't execute statment: SQL 
> logic error or missing database
>
> CentOS 7.5.1804
> Asterisk certified/13.21-cert3
>
> [root at sv03 asterisk]# ls -lahZ /var/lib/asterisk/astdb.sqlite3
> -rw-r-----. asterisk asterisk 
> unconfined_u:object_r:asterisk_var_lib_t:s0 
> /var/lib/asterisk/astdb.sqlite3
>
>
> Can anyone help?
>
> Thanks.
>
>
>
>
> 	Rafael S. Saraiva
>
> [View Rafael Saraiva's profile on LinkedIn] 
> <http://br.linkedin.com/pub/rafael-saraiva/52/aab/230>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181203/f829477e/attachment.html>

Hi Jean

Thanks, you've solved my problem.

Reference:
https://bugzilla.redhat.com/show_bug.cgi?id=1342733


Solution:

semanage fcontext -a -t asterisk_var_lib_t /var/lib/asterisk/

restorecon -v /var/lib/asterisk/

Regards

Rafael S. Saraiva
Porto Alegre - RS | Mobile: (51) 981-747-956
<http://br.linkedin.com/pub/rafael-saraiva/52/aab/230>



Em seg, 3 de dez de 2018 às 05:51, Jean Aunis <jean.aunis at prescom.fr>
escreveu:
> Hello,
>
> I haven't tried but this post probably gives a solution :
>
> https://bugzilla.redhat.com/show_bug.cgi?id=1342733
>
> Regards
>
> Jean Aunis
> Le 30/11/2018 à 19:24, Rafael dos Santos Saraiva a écrit :
>
> Hi
>
> I'm trying to use Asterisk running as non-root user and selinux
enabled.
> Asterisk is running ok, but astdb not works. When i try to put in astdb,
> console shows this message:
>
> WARNING[1853]: db.c:350 ast_db_put: Couldn't execute statment: SQL
logic
> error or missing database
>
> CentOS 7.5.1804
> Asterisk certified/13.21-cert3
>
> [root at sv03 asterisk]# ls -lahZ /var/lib/asterisk/astdb.sqlite3
> -rw-r-----. asterisk asterisk unconfined_u:object_r:asterisk_var_lib_t:s0
> /var/lib/asterisk/astdb.sqlite3
>
>
> Can anyone help?
>
> Thanks.
>
>
>
>
> Rafael S. Saraiva
>
> <http://br.linkedin.com/pub/rafael-saraiva/52/aab/230>
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181203/b5d2fb21/attachment.html>