[OpenSIPS-Users] Tables Missing Access Permissions

Nathaniel L. Keeling III keeling at akan-tech.com
Tue Jan 26 09:11:17 CET 2016


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
>>
>
>
>




More information about the Users mailing list