[Spce-user] Admin Block List

[Andrew Pogrebennyk]

Paul,
the database location is the voip.usr_preferences like with all other
user preferences:

mysql> select * from voip_usr_preferences where attribute_id in (select
id from voip_preferences where attribute in
('block_in_list','block_out_list'));
+------+---------------+--------------+-------+---------------------+
| id   | subscriber_id | attribute_id | value | modify_timestamp    |
+------+---------------+--------------+-------+---------------------+
| 1223 |            29 |            3 | 123   | 2015-03-06 10:39:35 |
| 1225 |            29 |            3 | 456   | 2015-03-06 10:39:38 |
| 1227 |            29 |            3 | 789   | 2015-03-06 10:39:41 |
+------+---------------+--------------+-------+---------------------+
3 rows in set (0.00 sec)

But if you ask me about the right direction, the right way would be to
import the lists using the REST* or SOAP API.. This would be quite easy.

[*] https://www.sipwise.com/doc/mr3.7.1/spce/ar01s10.html#_rest_api

Regards,
Andrew

On 03/04/2015 04:18 PM, Paul Hughes wrote:
> Hi everyone,
> 
> I wonder if anyone can point me in to the right direction.
> 
> What i am looking for is a way to do a direct upload to the databae for
> the admin blocked numbers list as in the interface there is only option
> to add a nuber one by one.
> 
> does anyone know the database location for the admin block list so that
> i can do a direct import of the numbers or a way to remote in to the
> database using a gui like phpmyadmin.
> 
> has anyone installed phpmyadmin on the server at all ? as gui can be
> handy for such instances? 
> 
> perhaps in the admin lock list section there would be an improvement in
> next version to upload csv like in the billing section ??
> 
> Regards Paul