27 Jul
2016
27 Jul
'16
11:24 a.m.
I am trying to get the geo scripts in the phirelight git repository to work. The readme
says the scripts have to be explicitly enabled.
I have:
@load ./set-country.bro
enabled in my geo/__load__.bro. However, my conn.log is not showing any country
information. There are no errors and bro deploys cleanly. Why exactly is the country
information not being inserted into the conn.log? I load geo/conn as well, which includes
the 4 add-X-conn.bro scripts. This SHOULD put in the country, but is not doing so. What am
I missing. The loadled_scripts.log says the add-X-conn.bro scripts are loaded.
27 Jul
27 Jul
11:56 a.m.
On Jul 27, 2016, at 2:24 PM, philosnef
<philosnef(a)yahoo.com> wrote:
I am trying to get the geo scripts in the phirelight git repository to work. The readme
says the scripts have to be explicitly enabled.
I have:
@load ./set-country.bro
enabled in my geo/__load__.bro. However, my conn.log is not showing any country
information. There are no errors and bro deploys cleanly. Why exactly is the country
information not being inserted into the conn.log? I load geo/conn as well, which includes
the 4 add-X-conn.bro scripts. This SHOULD put in the country, but is not doing so. What am
I missing. The loadled_scripts.log says the add-X-conn.bro scripts are loaded.
These scripts https://github.com/phirelight/bro-scripts/tree/master/geo ?
"Scripts to set geoip/asn info for conn. Note, these will not be logged as is. There
are addional scripts to log the variables for each log type."
You need to load the scripts under conn,dns,files, or ssl if you want the fields to be
logged. By default they are just making the fields available.
In your case what you are missing is loading geo/conn/add-country-conn.bro
--
- Justin Azoff
12:02 p.m.
Sorry, meant to reply to the list....From my original message:
The loadled_scripts.log says the add-X-conn.bro scripts are loaded.
All the add scripts are already loaded, or loaded_scripts.log from the log directory would
not say so?
If the scripts weren't being loaded, loaded_scripts.log would not indicate they
are....
12:05 p.m.
Begin forwarded message:
From: philosnef <philosnef(a)yahoo.com>
Subject: Re: [Bro] problems with geo scripts in phirelight repository
Date: July 27, 2016 at 3:00:31 PM EDT
To: "Azoff, Justin S" <jazoff(a)illinois.edu>
Reply-To: philosnef <philosnef(a)yahoo.com>
From my original message:
The loadled_scripts.log says the add-X-conn.bro scripts are loaded.
All the add scripts are already loaded, or loaded_scripts.log from the log directory
would not say so?
Oh, derp. I can read.. really.. :-)
When you say "conn.log is not showing any country information" do you have the
new columns?
add-country-conn.bro adds an "orig_country" and "resp_country" column.
Do you have those 2 columns but they are blank, or do you not even have those columns?
If you don't have the columns at all that would be very odd. If you have them but
they are all blank, that would point to an issue with the geoip bindings or databases.
--
- Justin Azoff
12:08 p.m.
Yeah, no new columns at all. I am logging in json format, but they should still show up,
right?
On Wednesday, July 27, 2016 3:05 PM, "Azoff, Justin S"
<jazoff(a)illinois.edu> wrote:
Begin forwarded message:
From: philosnef <philosnef(a)yahoo.com>
Subject: Re: [Bro] problems with geo scripts in phirelight repository
Date: July 27, 2016 at 3:00:31 PM EDT
To: "Azoff, Justin S" <jazoff(a)illinois.edu>
Reply-To: philosnef <philosnef(a)yahoo.com>
From my original message:
The loadled_scripts.log says the add-X-conn.bro scripts are loaded.
All the add scripts are already loaded, or loaded_scripts.log from the log directory
would not say so?
Oh, derp. I can read.. really.. :-)
When you say "conn.log is not showing any country information" do you have the
new columns?
add-country-conn.bro adds an "orig_country" and "resp_country" column.
Do you have those 2 columns but they are blank, or do you not even have those columns?
If you don't have the columns at all that would be very odd. If you have them but
they are all blank, that would point to an issue with the geoip bindings or databases.
--
- Justin Azoff
12:15 p.m.
On Jul 27, 2016, at 3:08 PM, philosnef
<philosnef(a)yahoo.com> wrote:
Yeah, no new columns at all. I am logging in json format, but they should still show up,
right?
Ah, that complicates things because optional fields are not logged in json format. unlike
the TSV logs it doesn't need a fixed column layout, so fields can only show up when
needed..
geoip is probably broken for you in general.
I'd try this experiment. Some errors are ok since it tries some fallbacks, but you
should get the result in the end:
$ cat test.bro
print lookup_location(8.8.8.8);
$ bro test.bro
Failed to open GeoIP Cityv6 database: /usr/local/var/GeoIP/GeoIPCityv6.dat
Failed to open GeoIPv6 Country database: /usr/local/var/GeoIP/GeoIPv6.dat
error in ./test.bro, line 1: Can't open GeoIPv6 City/Country database
(lookup_location(8.8.8.8))
[country_code=US, region=CA, city=Mountain View, latitude=37.386002,
longitude=-122.083801]
--
- Justin Azoff
12:39 p.m.
Justin,
I get a bit where it says init-bare.bro problem initializing NB-DNS, but other than that
it properly reports the exact same information you have there (US, CA, Mountain View).
For some reason, it seems to work fine now. We just pushed a new version of geo from the
phirelight repository and that seems to have fixed it.
On Wednesday, July 27, 2016 3:15 PM, "Azoff, Justin S"
<jazoff(a)illinois.edu> wrote:
On Jul 27, 2016, at 3:08 PM, philosnef
<philosnef(a)yahoo.com> wrote:
Yeah, no new columns at all. I am logging in json format, but they should still show up,
right?
Ah, that complicates things because optional fields are not logged in json format. unlike
the TSV logs it doesn't need a fixed column layout, so fields can only show up when
needed..
geoip is probably broken for you in general.
I'd try this experiment. Some errors are ok since it tries some fallbacks, but you
should get the result in the end:
$ cat test.bro
print lookup_location(8.8.8.8);
$ bro test.bro
Failed to open GeoIP Cityv6 database: /usr/local/var/GeoIP/GeoIPCityv6.dat
Failed to open GeoIPv6 Country database: /usr/local/var/GeoIP/GeoIPv6.dat
error in ./test.bro, line 1: Can't open GeoIPv6 City/Country database
(lookup_location(8.8.8.8))
[country_code=US, region=CA, city=Mountain View, latitude=37.386002,
longitude=-122.083801]
--
- Justin Azoff
2126
days inactive
2126
days old
6 comments
2 participants
participants (2)
-
Azoff, Justin S -
philosnef