Re: [SR-Users] permissions module db

2017-05-11 Thread Daniel Tryba
On Wed, May 10, 2017 at 06:54:49PM +, David Villasmil wrote: > I don't think I can... there's no cast to smallint :( Indeed, but take a look at this workaround with a custom function returning a smallint: http://ask.brothersoft.com/how-to-convert-from-int-to-smallint-86641.html (which

Re: [SR-Users] permissions module db

2017-05-10 Thread David Villasmil
I don't think I can... there's no cast to smallint :( On Wed, May 10, 2017 at 8:37 PM Daniel Tryba wrote: > On Wed, May 10, 2017 at 05:31:28PM +0200, David Villasmil wrote: > > The view i created on mysql returns an INT for port and mask, it looks > like > > kamailio doesn't

Re: [SR-Users] permissions module db

2017-05-10 Thread Daniel Tryba
On Wed, May 10, 2017 at 05:31:28PM +0200, David Villasmil wrote: > 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 > ᐧ Sound awfully familiar:

Re: [SR-Users] permissions module db

2017-05-10 Thread 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.w...@gmail.com phone: +34669448337 On Wed, May 10, 2017