Logging and reporting shows traffic from just one user

Hi Andy and welcome to the UTM Community!

You should either have no reporting for a feature or reporting for all devices using that feature.  You can try the following to re-initialize your PostgreSQL databases, but you may need to re-install with a new DVD burned at 4x or slower.

/etc/init.d/postgresql92 rebuild

To get host names instead of IPs, use DNS best practice if you have an internal DNS server.  If the UTM is doing DHCP for your internal network, study DHCP and "Hosts with static mapping."

'External (WAN) (address) --> Internal' has no effect.

One of the unwritten rules here is "one topic per thread" - that's to make it easier for future members to find an answer to their question without starting a new thread that's already been answered.  Please ask your firewall-rule question in the Network Protection forum.

Cheers - Bob

Bob,

I don't understand what reporting has to do with PostgreSQL database. I believe it is caused by my wireless router connected to the utm internal network and IP request is not being passed on to the utm from my wireless router.

If I disable dhcp on wireless router, whole wireless network in my house cease to work. I even couldn't access router's interface. I had to reset the router to get its interface back and enable wireless networking.

I don't have internal dns server. I use Google dns for dns resolution.

First problem is truly a major issue since I want to see individual computer traffic in my reporting feature. I will appreciate your help.

Thanks

Andy

Once you get the hang of WebAdmin, you'll really like this.

The preferred topology is:

[Internal Wireless Devices]<-->[Wireless Switch]<-->[UTM]<-->Internet

To make a "Wireless Switch" out of your wireless router can be done in two different ways.  Some will allow you to put the router in bridge mode.  With others, you just tape over the WAN port and connect one of the LAN ports to the UTM instead.  In any case, you will want to disable DHCP on the wireless router and have the UTM do DHCP.

I assumed that you had searched here and come up with the preferred approach, so you're right that my first response above was off base.

Also, if you want to have your devices identified by name in Reporting, you will want to have DHCP use Host Definitions to assign static IPs.  Note that all statically-assigned IPs must be outside the dynamic range of your DHCP server definition.

Cheers -Bob

Bob,

Thanks for your response.

As you mentioned, I have an exact same setup:

[Internal Wireless Devices]<-->[Wireless Switch]<-->[UTM]<-->Internet

Now We know that wireless router (wireless switch) is causing an issue because currently it acts as DHCP provider. I looked at my ASUS router and it has nothing to put it in a bridged mode. It has something called AP (Access Point) mode. Can you please advice on that?

Thanks

Andy 

I would try that to see if it gets an IP for itself from the UTM.  If not, then tape over the WAN port on the ASUS and connect it via a LAN port.

Cheers - Bob

I would try that to see if it gets an IP for itself from the UTM.  If not, then tape over the WAN port on the ASUS and connect it via a LAN port.

Cheers - Bob