<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Folks,<br>
<br>
I'm working on getting my AS added to a 5.7.0 installation, and for
some reason every prefix I advertise is being filtered. I'm having
trouble determining why.<br>
Other members are able to advertise prefixes, and I'm receiving
those prefixes so it seems like it's something specific to my member
info.<br>
I have tried both my AS-SET macro and my ASN and both produce the
same result. For simplicity I'm using my ASN in these examples.<br>
<br>
<tt>mysql> select id,maxprefixes from cust where autsys like
'14818';</tt><tt><br>
</tt><tt>+----+-------------+</tt><tt><br>
</tt><tt>| id | maxprefixes |</tt><tt><br>
</tt><tt>+----+-------------+</tt><tt><br>
</tt><tt>| 8 | 100 |</tt><tt><br>
</tt><tt>+----+-------------+</tt><tt><br>
</tt><tt>1 row in set (0.01 sec)</tt><br>
<br>
<br>
<tt>mysql> SELECT @IRRDBID := irrdb FROM cust WHERE id = 8;</tt><tt><br>
</tt><tt>+-------------------+</tt><tt><br>
</tt><tt>| @IRRDBID := irrdb |</tt><tt><br>
</tt><tt>+-------------------+</tt><tt><br>
</tt><tt>| 23 |</tt><tt><br>
</tt><tt>+-------------------+</tt><tt><br>
</tt><tt>1 row in set, 1 warning (0.00 sec)</tt><tt><br>
<br>
</tt><tt><br>
</tt><tt>mysql> SELECT * FROM irrdbconfig WHERE id = @IRRDBID;</tt><tt><br>
</tt><tt>+----+----------------+----------+--------+--------------------------------+</tt><tt><br>
</tt><tt>| id | host | protocol | source |
notes |</tt><tt><br>
</tt><tt>+----+----------------+----------+--------+--------------------------------+</tt><tt><br>
</tt><tt>| 23 | whois.radb.net | irrd | ALTDB | ALTDB Query
from RADB Database |</tt><tt><br>
</tt><tt>+----+----------------+----------+--------+--------------------------------+</tt><tt><br>
</tt><tt>1 row in set (0.00 sec)</tt><tt><br>
</tt><br>
<br>
<tt>$ bgpq3 -Al test AS14818 -S ALTDB</tt><tt><br>
</tt><tt>no ip prefix-list test</tt><tt><br>
</tt><tt>ip prefix-list test permit 8.10.176.0/23</tt><tt><br>
</tt><tt>ip prefix-list test permit 63.229.162.0/24</tt><tt><br>
</tt><tt>ip prefix-list test permit 63.233.220.0/23</tt><tt><br>
</tt><tt>ip prefix-list test permit 65.19.0.0/18</tt><tt><br>
</tt><tt>ip prefix-list test permit 65.19.0.0/18 ge 24 le 24</tt><tt><br>
</tt><tt>ip prefix-list test permit 192.12.12.0/24</tt><tt><br>
</tt><tt>ip prefix-list test permit 207.225.52.0/24</tt><tt><br>
<br>
$ bgpq3 -S ALTDB -Al pl -j AS14818<br>
{ "pl": [<br>
{ "prefix": "8.10.176.0\/23", "exact": true },<br>
{ "prefix": "63.229.162.0\/24", "exact": true },<br>
{ "prefix": "63.233.220.0\/23", "exact": true },<br>
{ "prefix": "65.19.0.0\/18", "exact": true },<br>
{ "prefix": "65.19.0.0\/18", "exact": false,<br>
"greater-equal": 24, "less-equal": 24 },<br>
{ "prefix": "192.12.12.0\/24", "exact": true },<br>
{ "prefix": "207.225.52.0\/24", "exact": true }<br>
] }<br>
<br>
<br>
<br>
$ sudo php artisan irrdb:update-prefix-db 14818<br>
Cyber Mesa: [IPv4: 70 total; 0 stale; 0 new; DB updated] [IPv6: 1
total; 0 stale; 0 new; DB updated]<br>
<br>
</tt><br>
I'm advertising 65.19.0.0/18 and 65.19.10.0/24 to the route servers
currently. Both prefixes are being filtered, with for following
communities applied:<br>
<br>
<tt>14129:1000:3</tt><tt> </tt><tt><span class="badge
badge-warning">RPKI NOT CHECKED</span></tt><tt> </tt><tt><br>
</tt><tt> </tt><tt>14129:1101:9</tt><tt> </tt><tt><span
class="badge badge-danger">IRRDB PREFIX FILTERED</span></tt><tt>
</tt><tt><br>
</tt><tt> </tt><tt>14129:1001:1002</tt><tt> </tt><span
class="badge badge-warning"><tt>IRRDB PREFIX EMPTY</tt><br>
<br>
</span>Is there a way to interact directly with irrdb to verify the
query it is doing as well as what it returns? <br>
<br>
Thanks,<br>
<br>
Tim Densmore<br>
</body>
</html>