[ixpmanager] IRRDB setup

Brian Thompson brian.thompson at iovation.com
Fri Jan 10 17:02:11 GMT 2014


excellent, some how I thought since it was quering whois.radb.net it would
resolve.  I was not familiar with the -S and thought ARIN was also denoting
where the IP addresses were issued from.

Yes it now works.  I am sure I will have more questions as we are working
to get Smartly configured bird route server.

Thanks,
Brian

*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 Fri, Jan 10, 2014 at 8:49 AM, Barry O'Donovan <barry.odonovan at inex.ie>wrote:

>
> 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/                 |
> +-------------------------------+-------------------------------------+
>
> _______________________________________________
> INEX IXP Manager mailing list
> ixpmanager at inex.ie
> https://www.inex.ie/mailman/listinfo/ixpmanager
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.inex.ie/pipermail/ixpmanager/attachments/20140110/9ddabf9b/attachment.html>


More information about the ixpmanager mailing list