[SR-Users] permissions module db

[David Villasmil]

The view i created on mysql returns an INT for port and mask, it looks like
kamailio doesn't like this... It looks to be expecting a smallint??

the view returns an INT and that fails....
ᐧ

Regards,

David Villasmil
email: david.villasmil.work at gmail.com
phone: +34669448337

On Wed, May 10, 2017 at 4:08 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> Hello guys,
>
> I0ve freated a view taken from other tables to use with the permissions
> module, the result looks like this:
>
>
> And some values:
>
> 23 10 192.198.1.215 32 0 Training-215
> Still, Kamailio complaints with:
>
>  0(5796) DEBUG: <core> [db_res.c:188]: db_allocate_rows(): allocate 48
> bytes for rows at 0x7f69510651b8
>  0(5796) DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 160
> bytes for row values at 0x7f6951065250
>  0(5796) DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [10]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [67.215.186.215]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [32]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [0]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [Training-215]
>  0(5796) DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 160
> bytes for row values at 0x7f6951065358
>  0(5796) DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [10]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [67.215.186.216]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [32]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [0]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [PBX-Service]
>  0(5796) DEBUG: <core> [db_row.c:117]: db_allocate_row(): allocate 160
> bytes for row values at 0x7f6951065460
>  0(5796) DEBUG: <core> [db_val.c:74]: db_str2val(): converting INT [10]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [67.215.186.212]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [32]
>  0(5796) DEBUG: <core> [db_val.c:85]: db_str2val(): converting BIGINT [0]
>  0(5796) DEBUG: <core> [db_val.c:118]: db_str2val(): converting STRING
> [JuanPablo]
>  0(5796) DEBUG: permissions [address.c:142]: reload_address_table():
> Number of rows in address table: 3
>  0(5796) DEBUG: permissions [address.c:169]: reload_address_table():
> failure during checks of database value 3 (subnet size/CIDR) in address
> table
>  0(5796) ERROR: permissions [address.c:247]: reload_address_table():
> database problem - invalid record
>  0(5796) DEBUG: <core> [db_res.c:79]: db_free_columns(): freeing 5 columns
>  0(5796) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing
> RES_NAMES[0] at 0x7f6951064790
>  0(5796) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing
> RES_NAMES[1] at 0x7f6951064718
>  0(5796) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing
> RES_NAMES[2] at 0x7f6951063950
>  0(5796) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing
> RES_NAMES[3] at 0x7f6951064340
>  0(5796) DEBUG: <core> [db_res.c:83]: db_free_columns(): freeing
> RES_NAMES[4] at 0x7f6951064498
>  0(5796) DEBUG: <core> [db_res.c:96]: db_free_columns(): freeing result
> names at 0x7f6951064610
>  0(5796) DEBUG: <core> [db_res.c:101]: db_free_columns(): freeing result
> types at 0x7f6951064808
>  0(5796) DEBUG: <core> [db_res.c:52]: db_free_rows(): freeing 3 rows
>  0(5796) DEBUG: <core> [db_row.c:95]: db_free_row(): freeing row values at
> 0x7f6951065250
>  0(5796) DEBUG: <core> [db_row.c:95]: db_free_row(): freeing row values at
> 0x7f6951065358
>  0(5796) DEBUG: <core> [db_row.c:95]: db_free_row(): freeing row values at
> 0x7f6951065460
>  0(5796) DEBUG: <core> [db_res.c:60]: db_free_rows(): freeing rows at
> 0x7f69510651b8
>  0(5796) DEBUG: <core> [db_res.c:138]: db_free_result(): freeing result
> set at 0x7f6951065118
>  0(5796) CRITICAL: permissions [address.c:359]: init_addresses(): reload
> of address table failed
>  0(5796) DEBUG: <core> [db_pool.c:100]: pool_remove(): removing connection
> from the pool
>  0(5796) ERROR: permissions [permissions.c:614]: mod_init(): failed to
> initialize the allow_address function
>  0(5796) ERROR: <core> [core/sr_module.c:968]: init_mod(): Error while
> initializing module permissions (/usr/local/kamailio5/lib64/
> kamailio/modules/permissions.so)
> ERROR: error while initializing modules
>
>
>
> Can anyone help?
>
> thanks!
> ​
> Regards,
>
> David Villasmil
> email: david.villasmil.work at gmail.com
> phone: +34669448337 <+34%20669%2044%2083%2037>
> ᐧ
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170510/a5a5c431/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screen Shot 2017-05-10 at 16.04.54.png
Type: image/png
Size: 33132 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20170510/a5a5c431/attachment.png>