[OpenSIPS-Users] Tables Missing Access Permissions

[Bogdan-Andrei Iancu]

Hi Nathaniel,

Thanks for confirming the fix. Indeed, I found out the answer to my own 
question after sending you my first reply...after digging more into the 
code of opensipsdbctl.

Anyhow, thanks for report !

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 26.01.2016 10:11, Nathaniel L. Keeling III wrote:
> Bogdan,
>
> To answer the first question, I created all of the tables including 
> the extras. I did another git pull and recreated the tables. All of 
> the permissions were in place except for the table route_tree_id_seq.
>
> Thanks
>
> Nathaniel Keeling
>
> On 1/25/16 6:07 AM, Bogdan-Andrei Iancu wrote:
>> Hi (again),
>>
>> I pushed a fix on GIT, please update and try to re-create your DB to 
>> see if all the grants are now fine.
>>
>> Thanks and regards,
>>
>> Bogdan-Andrei Iancu
>> OpenSIPS Founder and Developer
>> http://www.opensips-solutions.com
>>
>> On 25.01.2016 13:48, Bogdan-Andrei Iancu wrote:
>>> Hi Nathaniel,
>>>
>>> When you created the tables, have you created all the "extra" tables 
>>> ? I see you have the b2b related tables (part of extra), but no kind 
>>> of missing privileges on other extra tables like "siptrace".
>>>
>>> Regards,
>>>
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developer
>>> http://www.opensips-solutions.com
>>>
>>> On 25.01.2016 05:38, Nathaniel L. Keeling III wrote:
>>>> When starting Opensips 2.1, I am getting permissions errors on 
>>>> dr_carriers and dr_carriers_id_seq tables in Postgresql and 
>>>> Opensips errors. After checking the database, these tables were 
>>>> missing any access permissions.
>>>>
>>>>
>>>>                                   Access privileges for database 
>>>> "opensips21"
>>>>  Schema |            Name            |   Type 
>>>> |                      Access privileges
>>>> --------+----------------------------+----------+-------------------------------------------------------------- 
>>>>
>>>>  public | b2b_entities               | table    |
>>>>  public | b2b_entities_id_seq        | sequence |
>>>>  public | b2b_logic                  | table    |
>>>>  public | b2b_logic_id_seq           | sequence |
>>>>  public | dr_carriers                | table    |
>>>>  public | dr_carriers_id_seq         | sequence |
>>>>  public | dr_partitions              | table    |
>>>>  public | dr_partitions_id_seq       | sequence |
>>>>  public | route_tree_id_seq          | sequence |
>>>>
>>>>
>>>> Thanks
>>>>
>>>> Nathaniel Keeling
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>
>>
>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>