[ixpmanager] IRRDB setup

[Brian Thompson]

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 | 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>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>;
>> 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/                 |
> +-------------------------------+-------------------------------------+
>
> _______________________________________________
> 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/7864d305/attachment.html>