0

I'm trying to use lnav to query Apache's access_log on macOS. It looks really nice, but when querying with SQL, I get no results.

I'm starting the program with ./lnav /private/var/log/apache2/access_log, which shows the log file. Then I type v for the SQL result view, and then ; to enter the SQL query SELECT cs_uri_query, sc_status FROM access_log; and press enter.

In the bottom row lnav says Now rows matched. Same goes for the query SELECT * FROM access_log.

I'm clearly missing something. What is it?

1 Answer 1

0

Apparently Apple tweaked the access_log file format, and you need to install a custom file format with lnav. The guys from lnav have an active forum, and they provided an answer over there, including the format file.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .