<div dir="ltr"><div>mysql> SELECT @IRRDBID := irrdb FROM cust WHERE id = 2;</div><div>+-------------------+</div><div>| @IRRDBID := irrdb |</div><div>+-------------------+</div><div>| 7 |</div><div>+-------------------+</div>
<div>1 row in set (0.01 sec)</div><div><br></div><div>mysql> SELECT * FROM irrdbconfig WHERE id = @IRRDBID;</div><div>+----+----------------+----------+--------+-------------------------------+</div><div>| id | host | protocol | source | notes |</div>
<div>+----+----------------+----------+--------+-------------------------------+</div><div>| 7 | <a href="http://whois.radb.net">whois.radb.net</a> | irrd | ARIN | ARIN Query from RADB Database |</div><div>+----+----------------+----------+--------+-------------------------------+</div>
<div>1 row in set (0.00 sec)</div><div><br></div><div>mysql></div></div><div class="gmail_extra"><br clear="all"><div><strong style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(136,136,136)">Brian Thompson</strong><br>
<span style="color:rgb(0,102,51);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Senior Infrastructure Engineer // Senior Second Guesser</span><br><font color="#666666" face="Lucida Grande, Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:15px"><br>
</span></font><span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Direct: </span><a value="+15039436742" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(17,85,204)">503.943.6779</a><br>
<span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px">Mobile: </span><a value="+15033196955" style="font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px;color:rgb(17,85,204)">503.707.9018</a><span style="color:rgb(102,102,102);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px"> // Twitter: iovation</span><br>
<strong style="color:rgb(0,102,51);font-family:'Lucida Grande',Verdana,Arial,sans-serif;font-size:12px;line-height:16px"><a href="http://www.iovation.com/" title="Visit iovation.com" style="color:rgb(0,102,51);text-decoration:none;border-bottom-width:0px;border-bottom-style:initial;border-bottom-color:initial" target="_blank">www.iovation.com</a></strong><br>
<font color="#006633" face="Lucida Grande, Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:15px"><br></span></font><span><font color="#888888"><div><font color="#006633" face="'Lucida Grande', Verdana, Arial, sans-serif"><span style="font-size:12px;line-height:16px"><img src="http://www.iovation.com/images/signature/eml_sig_mobilefraud.gif"></span></font></div>
</font></span></div>
<br><br><div class="gmail_quote">On Thu, Jan 9, 2014 at 11:04 PM, Barry O'Donovan <span dir="ltr"><<a href="mailto:barry.odonovan@inex.ie" target="_blank">barry.odonovan@inex.ie</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im"><br>
<br>
On 10/01/2014 05:05, Brian Thompson wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have one customer with Apply IRRDB Filtering checked and Apply IRRDB<br>
Filtering checked.<br>
</blockquote>
<br></div>
What IRRDB is this customer configured to use? I.e.:<br>
<br>
- 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];<br>
<br>
- when adding / editing the customer, have you selected an appropriate IRRDB database for the customer under Peering Details / IRRDB Source.<br>
<br>
What does the following SQL return:<br>
<br>
SELECT @IRRDBID := irrdb FROM cust WHERE id = 2;<br>
SELECT * FROM irrdbconfig WHERE id = @IRRDBID;<br>
<br>
<br>
- Barry<br>
<br>
NB: If you find the GitHub wiki documentation lacking, PLEASE improve it as you work your way through these issues.<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<br>
mysql><br>
mysql> select * from irrdb_prefix;<br>
Empty set (0.00 sec)<br>
<br>
mysql> select * from irrdb_asn;<br>
+----+-------------+-------+--<u></u>--------+---------------------<u></u>+<br>
| id | customer_id | asn | protocol | first_seen |<br>
+----+-------------+-------+--<u></u>--------+---------------------<u></u>+<br>
| 1 | 2 | 15301 | 4 | 2014-01-10 04:28:54 |<br>
| 2 | 2 | 15301 | 6 | 2014-01-10 04:28:54 |<br>
+----+-------------+-------+--<u></u>--------+---------------------<u></u>+<br>
2 rows in set (0.00 sec)<br>
<br>
root@portal:/usr/local/ixp# ./bin/ixptool.php -a<br>
irrdb-cli.update-prefix-db -v<br>
PHP Deprecated: Comments starting with '#' are deprecated in<br>
/etc/php5/cli/conf.d/ming.ini on line 1 in Unknown on line 0<br>
Processing iovation: [IPv4: IRRDB 0; DB not updated] [IPv6: IRRDB 0; DB<br>
not updated]<br>
Database time : 0.0019369125366211<br>
Processing time: 0<br>
Network time : 0.76200199127197<br>
<br>
I have confirmed bgpq3 is working<br>
root@portal:~# bgpq3 -Jl test AS15301<br>
policy-options {<br>
replace:<br>
prefix-list test {<br>
</div></div><a href="http://38.103.166.0/24" target="_blank">38.103.166.0/24</a> <<a href="http://38.103.166.0/24" target="_blank">http://38.103.166.0/24</a>>;<br>
<a href="http://74.121.28.0/22" target="_blank">74.121.28.0/22</a> <<a href="http://74.121.28.0/22" target="_blank">http://74.121.28.0/22</a>>;<br>
<a href="http://74.121.28.0/23" target="_blank">74.121.28.0/23</a> <<a href="http://74.121.28.0/23" target="_blank">http://74.121.28.0/23</a>>;<br>
<a href="http://74.121.31.0/24" target="_blank">74.121.31.0/24</a> <<a href="http://74.121.31.0/24" target="_blank">http://74.121.31.0/24</a>>;<br>
<a href="http://206.169.239.0/24" target="_blank">206.169.239.0/24</a> <<a href="http://206.169.239.0/24" target="_blank">http://206.169.239.0/24</a>>;<div class="im"><br>
}<br>
<br>
<br>
}<br>
and IRR Tool Set is working.<br>
<br>
rtconfig> @RtConfig access_list filter AS15301<br>
<br>
!<br>
<br>
no ip prefix-list pl100<br>
<br></div>
ip prefix-list pl100 permit <a href="http://38.103.166.0/24" target="_blank">38.103.166.0/24</a> <<a href="http://38.103.166.0/24" target="_blank">http://38.103.166.0/24</a>><br>
<br>
ip prefix-list pl100 permit <a href="http://74.121.28.0/22" target="_blank">74.121.28.0/22</a> <<a href="http://74.121.28.0/22" target="_blank">http://74.121.28.0/22</a>><br>
<br>
ip prefix-list pl100 permit <a href="http://74.121.28.0/23" target="_blank">74.121.28.0/23</a> <<a href="http://74.121.28.0/23" target="_blank">http://74.121.28.0/23</a>><br>
<br>
ip prefix-list pl100 permit <a href="http://74.121.31.0/24" target="_blank">74.121.31.0/24</a> <<a href="http://74.121.31.0/24" target="_blank">http://74.121.31.0/24</a>><br>
<br>
ip prefix-list pl100 permit <a href="http://206.169.239.0/24" target="_blank">206.169.239.0/24</a> <<a href="http://206.169.239.0/24" target="_blank">http://206.169.239.0/24</a>><br>
<br>
ip prefix-list pl100 deny <a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a> <<a href="http://0.0.0.0/0" target="_blank">http://0.0.0.0/0</a>> le 32<div class="im"><br>
<br>
<br>
still no prefixes<br>
<br>
<br>
Suggestions?<br>
<br>
<br>
Thanks,<br>
<br>
Brian<br>
<br>
<br>
<br></div>
______________________________<u></u>_________________<br>
INEX IXP Manager mailing list<br>
<a href="mailto:ixpmanager@inex.ie" target="_blank">ixpmanager@inex.ie</a><br>
<a href="https://www.inex.ie/mailman/listinfo/ixpmanager" target="_blank">https://www.inex.ie/mailman/<u></u>listinfo/ixpmanager</a><br>
<br>
</blockquote>
<br>
-- <br>
<br>
Kind regards,<br>
Barry O'Donovan<br>
INEX Operations<br>
<br>
Mob: <a href="tel:%2B353%2086%20801%207669" value="+353868017669" target="_blank">+353 86 801 7669</a><br>
Tel: <a href="tel:%2B353%20%201%20685%204220" value="+35316854220" target="_blank">+353 1 685 4220</a><br>
<br>
+-----------------------------<u></u>--+---------------------------<u></u>----------+<br>
| Open Source Solutions Ltd. | INEX Operations Team |<br>
| Lynx House Old Church Road, | Internet Neutral Exchange |<br>
| Lower Kilmacud Road, | Association, 4027 Kingswood Road, |<br>
| Stillorgan, Co Dublin. | Citywest Business Campus, Dublin 24 |<br>
| <a href="http://www.opensolutions.ie/" target="_blank">http://www.opensolutions.ie/</a> | <a href="http://www.inex.ie/" target="_blank">http://www.inex.ie/</a> |<br>
+-----------------------------<u></u>--+---------------------------<u></u>----------+<br>
<br>
______________________________<u></u>_________________<br>
INEX IXP Manager mailing list<br>
<a href="mailto:ixpmanager@inex.ie" target="_blank">ixpmanager@inex.ie</a><br>
<a href="https://www.inex.ie/mailman/listinfo/ixpmanager" target="_blank">https://www.inex.ie/mailman/<u></u>listinfo/ixpmanager</a><br>
</blockquote></div><br></div>