[ixpmanager] IRRDB setup
Barry O'Donovan
barry.odonovan at inex.ie
Fri Jan 10 16:49:07 GMT 2014
So it's working as expected. Note the difference between the following two:
barryo at prime:~ $ bgpq3 -Jl test AS15301
policy-options {
replace:
prefix-list test {
38.103.166.0/24;
74.121.28.0/22;
74.121.28.0/23;
74.121.31.0/24;
206.169.239.0/24;
}
}
barryo at prime:~ $ bgpq3 -Jl test AS15301 -S ARIN
policy-options {
replace:
prefix-list test {
}
}
I.e. there are route: objects for this ASN in the "RADB,RIPE,APNIC"
sources (bgpq3 default) but not in the ARIN source.
- Barry
On 10/01/2014 16:43, Brian Thompson wrote:
> mysql> SELECT @IRRDBID := irrdb FROM cust WHERE id = 2;
> +-------------------+
> | @IRRDBID := irrdb |
> +-------------------+
> | 7 |
> +-------------------+
> 1 row in set (0.01 sec)
>
> mysql> SELECT * FROM irrdbconfig WHERE id = @IRRDBID;
> +----+----------------+----------+--------+-------------------------------+
> | id | host | protocol | source | notes |
> +----+----------------+----------+--------+-------------------------------+
> | 7 | whois.radb.net <http://whois.radb.net> | irrd | ARIN | ARIN
> Query from RADB Database |
> +----+----------------+----------+--------+-------------------------------+
> 1 row in set (0.00 sec)
>
> mysql>
>
> *Brian Thompson*
> Senior Infrastructure Engineer // Senior Second Guesser
>
> Direct: 503.943.6779
> Mobile: 503.707.9018 // Twitter: iovation
> *www.iovation.com <http://www.iovation.com/>*
>
>
>
> On Thu, Jan 9, 2014 at 11:04 PM, Barry O'Donovan <barry.odonovan at inex.ie
> <mailto:barry.odonovan at inex.ie>> wrote:
>
>
>
> 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> <http://38.103.166.0/24>;
> 74.121.28.0/22 <http://74.121.28.0/22> <http://74.121.28.0/22>;
> 74.121.28.0/23 <http://74.121.28.0/23> <http://74.121.28.0/23>;
> 74.121.31.0/24 <http://74.121.31.0/24> <http://74.121.31.0/24>;
> 206.169.239.0/24 <http://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> <http://38.103.166.0/24>
>
> ip prefix-list pl100 permit 74.121.28.0/22
> <http://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> <http://74.121.28.0/23>
>
> ip prefix-list pl100 permit 74.121.31.0/24
> <http://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> <http://206.169.239.0/24>
>
> ip prefix-list pl100 deny 0.0.0.0/0 <http://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 <mailto:ixpmanager at inex.ie>
> https://www.inex.ie/mailman/__listinfo/ixpmanager
> <https://www.inex.ie/mailman/listinfo/ixpmanager>
>
>
> --
>
> Kind regards,
> Barry O'Donovan
> INEX Operations
>
> Mob: +353 86 801 7669 <tel:%2B353%2086%20801%207669>
> Tel: +353 1 685 4220 <tel:%2B353%20%201%20685%204220>
>
> +-----------------------------__--+---------------------------__----------+
> | 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/ |
> +-----------------------------__--+---------------------------__----------+
>
> _________________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie <mailto:ixpmanager at inex.ie>
> https://www.inex.ie/mailman/__listinfo/ixpmanager
> <https://www.inex.ie/mailman/listinfo/ixpmanager>
>
>
>
>
> _______________________________________________
> 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/ |
+-------------------------------+-------------------------------------+
More information about the ixpmanager
mailing list