Hi Everyone,
I cannot seem to get the permissions module with dbtext to load in version 1.2.
I am pretty sure the "trusted" table format is correct. This is what I have.
src_ip(str) proto(str) from_pattern(str) tag(str,null) 192.168.0.10:any:^sip:.*$:
I get the following error when I start OpenSER...
ERROR: permissions: reload_address_table(): Error while querying database
Regards, Daryl
Daryl Sanders writes:
I am pretty sure the "trusted" table format is correct. This is what I have.
src_ip(str) proto(str) from_pattern(str) tag(str,null) 192.168.0.10:any:^sip:.*$:
I get the following error when I start OpenSER...
ERROR: permissions: reload_address_table(): Error while querying database
trusted table has nothing to do with reload_address_table() function.
-- juha
Well, maybe not, but that is the error that prevents OpenSER from starting.
When I use MySQL instead of dbtext, all is well. I can use allow_trusted() and everything works fine.
Any ideas?
- Daryl
On 3/18/07, Juha Heinanen jh@tutpro.com wrote:
Daryl Sanders writes:
I am pretty sure the "trusted" table format is correct. This is what I have.
src_ip(str) proto(str) from_pattern(str) tag(str,null) 192.168.0.10:any:^sip:.*$:
I get the following error when I start OpenSER...
ERROR: permissions: reload_address_table(): Error while querying database
trusted table has nothing to do with reload_address_table() function.
-- juha
The complete error is as follows...
0(0) permissions - initializing 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.allow 0(0) Default allow file (/usr/local/etc/openser/permissions.allow) not found => empty rule set 0(0) WARNING: File not found: /usr/local/etc/openser/permissions.deny 0(0) Default deny file (/usr/local/etc/openser/permissions.deny) not found => empty rule set 0(0) ERROR: permissions: reload_address_table(): Error while querying database 0(0) permissions:init_addresses(): Reload of address table failed 0(0) Error while initializing allow_address function 0(0) init_mod(): Error while initializing module permissions ERROR: error while initializing modules
- Daryl
On 3/18/07, Juha Heinanen jh@tutpro.com wrote:
Daryl Sanders writes:
I am pretty sure the "trusted" table format is correct. This is what I have.
src_ip(str) proto(str) from_pattern(str) tag(str,null) 192.168.0.10:any:^sip:.*$:
I get the following error when I start OpenSER...
ERROR: permissions: reload_address_table(): Error while querying database
trusted table has nothing to do with reload_address_table() function.
-- juha
Daryl Sanders writes:
0(0) ERROR: permissions: reload_address_table(): Error while querying database 0(0) permissions:init_addresses(): Reload of address table failed
when permissions module is loaded, it reloads both trusted and address tables.
permissions module code is independent of underlying database implementation. i have no experience with db_text. are you sure that your db_text address table is set up correctly?
-- juha
Hi Juha,
Thanks for the info. I used the sc.dbtext tool to create the database table files and it did not create a table called "address", so this may be the problem. To be honest I don't really know what the address table is used for, or why I might need it.
- Daryl
On 3/19/07, Juha Heinanen jh@tutpro.com wrote:
Daryl Sanders writes:
0(0) ERROR: permissions: reload_address_table(): Error while querying database 0(0) permissions:init_addresses(): Reload of address table failed
when permissions module is loaded, it reloads both trusted and address tables.
permissions module code is independent of underlying database implementation. i have no experience with db_text. are you sure that your db_text address table is set up correctly?
-- juha