Writing your own reports

[Tala]

I would like to access the database to write my own reports, is this possible and where will i find the admin username and passwords?

T

[dmorris]

Hi Tala,

Yes there are a couple posts around explaining how to make postgres externally accessible.

http://forums.untangle.com/reports/2...html#post68640

If you do any of this stuff make sure you disable auto-upgrade.

have fun.

[Tala]

Hi DM,

Thanks for your speedy post I will take a look, I hadn't realised I would have to disable updates, but this makes sense if I have to edit your files.

The only thing I need to do is this. In Captive Portal the reports in there display a user login along with the IP, this allows me to track the IP and cross ref against the name.

So I want to edit the reports to produce a login authentication against an IP and even possibly a MAC as well.

PS: Its just me in my company no budget so using LITE which I find great, though the web filter doesn't block all the adult sites, which was embarassing when showing my friends how good it was as it loaded the web page from google

T

[sky-knight]

Web Filter is such a massive improvement over Web Filter Lite that it's hard to express it. I almost want Web Filter Lite to be renamed to Web Filter Limited, because it would be closer to the truth.

1 million sites vs over 900million sites?

If you're going to dig into the code, I'd suggest you take a look at the report exports that have csv files in them. You'll likely find a way to get the data you're after, but doing it in a way that doesn't require customizing the underlying platform. Which preserves updatability of the installation and leaves you with a solution that is also more portable.

If you want to access postgres remotely it's a simple matter of reconfiguring postgres to listen on a LAN IP address. It's configured for localhost only by default. And then making a packet filter rule to allow access to the appropriate port.

I have a how to around here somewhere for an old version. The instructions are still valid, but the versions of things have changed so you may have to research some syntax changes.

[Tala]

Hi Sky-Knight,

Thanks for the information, I will take a look for your Postgres remote instructions and have a play.

Thank you so much for your help.

Tala

[Tala]

From what I can see the database only contains 3 tables for Captive Portal Lite.

n_cpd_block_evt
n_cpd_host_database_entry
n_cpd_login_evt

The Lite version isn't capturing the MAC address but it does capture the IP, which is what I needed, to save an IP against a logged in username.

All I have to do now is

shutdown Untangle
access the database
send the data to a remote mysql server
clear down the untangle logs
restart untangle

This is going to be fun.

have you any plans for adding another open source app to do this