[ixpmanager] IRRDB setup

[Barry O'Donovan]

On 10/01/2014 05:05, Brian Thompson wrote:
> I have one customer with Apply IRRDB Filtering checked and Apply IRRDB
> Filtering checked.

What IRRDB is this customer configured to use? I.e.:

  - in IXP Manager, are there entries in the 'IRRDB Configuration' (left 
admin menu option) [these are added by the fixtures during set-up 
typically and you can find examples in bin/fixtures.php.dist];

  - when adding / editing the customer, have you selected an appropriate 
IRRDB database for the customer under Peering Details / IRRDB Source.

What does the following SQL return:

SELECT @IRRDBID := irrdb FROM cust WHERE id = 2;
SELECT * FROM irrdbconfig WHERE id = @IRRDBID;


  - Barry

NB: If you find the GitHub wiki documentation lacking, PLEASE improve it 
as you work your way through these issues.

>
> mysql>
> mysql> select * from irrdb_prefix;
> Empty set (0.00 sec)
>
> mysql> select * from irrdb_asn;
> +----+-------------+-------+----------+---------------------+
> | id | customer_id | asn   | protocol | first_seen          |
> +----+-------------+-------+----------+---------------------+
> |  1 |           2 | 15301 |        4 | 2014-01-10 04:28:54 |
> |  2 |           2 | 15301 |        6 | 2014-01-10 04:28:54 |
> +----+-------------+-------+----------+---------------------+
> 2 rows in set (0.00 sec)
>
> root at portal:/usr/local/ixp# ./bin/ixptool.php -a
> irrdb-cli.update-prefix-db -v
> PHP Deprecated:  Comments starting with '#' are deprecated in
> /etc/php5/cli/conf.d/ming.ini on line 1 in Unknown on line 0
> Processing iovation: [IPv4: IRRDB 0; DB not updated] [IPv6: IRRDB 0; DB
> not updated]
> Database time  : 0.0019369125366211
> Processing time: 0
> Network time   : 0.76200199127197
>
> I have confirmed bgpq3 is working
> root at portal:~# bgpq3 -Jl test AS15301
> policy-options {
> replace:
>   prefix-list test {
> 38.103.166.0/24 <http://38.103.166.0/24>;
> 74.121.28.0/22 <http://74.121.28.0/22>;
> 74.121.28.0/23 <http://74.121.28.0/23>;
> 74.121.31.0/24 <http://74.121.31.0/24>;
> 206.169.239.0/24 <http://206.169.239.0/24>;
>   }
>
>
> }
> and IRR Tool Set is working.
>
> rtconfig> @RtConfig access_list filter AS15301
>
> !
>
> no ip prefix-list pl100
>
> ip prefix-list pl100 permit 38.103.166.0/24 <http://38.103.166.0/24>
>
> ip prefix-list pl100 permit 74.121.28.0/22 <http://74.121.28.0/22>
>
> ip prefix-list pl100 permit 74.121.28.0/23 <http://74.121.28.0/23>
>
> ip prefix-list pl100 permit 74.121.31.0/24 <http://74.121.31.0/24>
>
> ip prefix-list pl100 permit 206.169.239.0/24 <http://206.169.239.0/24>
>
> ip prefix-list pl100 deny 0.0.0.0/0 <http://0.0.0.0/0> le 32
>
>
> still no prefixes
>
>
> Suggestions?
>
>
> Thanks,
>
> Brian
>
>
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> https://www.inex.ie/mailman/listinfo/ixpmanager
>

-- 

Kind regards,
Barry O'Donovan
INEX Operations

Mob: +353 86 801 7669
Tel: +353  1 685 4220

+-------------------------------+-------------------------------------+
| Open Source Solutions Ltd.    | INEX Operations Team                |
| Lynx House Old Church Road,   | Internet Neutral Exchange           |
| Lower Kilmacud Road,          | Association, 4027 Kingswood Road,   |
| Stillorgan, Co Dublin.        | Citywest Business Campus, Dublin 24 |
| http://www.opensolutions.ie/  | http://www.inex.ie/                 |
+-------------------------------+-------------------------------------+