Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 6:47 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
PostPosted: Fri Nov 02, 2007 2:59 am 
Offline
Contributor

Joined: Fri Sep 28, 2007 12:07 am
Posts: 189
I receive the following error:

[code]Fatal Error:

SELECT * FROM system, network_card WHERE ( 1 ) AND net_uuid = system_uuid AND system_timestamp = net_timestamp AND net_gateway = '10.23.0.1' ORDER BY net_ip_address DESC

Column 'net_ip_address' in order clause is ambiguous[/code]

Thanks

Jason

_________________
OA Deployment:
Windows 2003 with XAMPP install
80 Windows Servers
250 Windows workstations (mixed XP and 2000)
5 MACs
Multiple printers, switches, routers, firewalls, and other servers (ESX, AIX etc.)


Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 03, 2007 4:23 am 
Offline
Contributor

Joined: Fri Sep 28, 2007 12:07 am
Posts: 189
Ok,

I did some more digging on the error.

Both the system table and network_card table both have net_ip_address in there. The idea with the ambiguous, is that the database does not which table to sort net_ip_address by.

I changed the query to below and it ran fine in phpmyadmin:

[code]SELECT * FROM system, network_card WHERE ( 1 ) AND net_uuid = system_uuid AND system_timestamp = net_timestamp AND net_gateway = '10.23.0.1' ORDER BY system.net_ip_address DESC[/code]

I checked the php file, and I am not sure how you guys are passing the sort order.

Please help with this, as it seems pretty simple.

Thanks

Jason

_________________
OA Deployment:
Windows 2003 with XAMPP install
80 Windows Servers
250 Windows workstations (mixed XP and 2000)
5 MACs
Multiple printers, switches, routers, firewalls, and other servers (ESX, AIX etc.)


Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 03, 2007 8:41 am 
Try it now, I made change to the viewdef file.


Top
  
Reply with quote  
PostPosted: Sun Nov 04, 2007 5:49 am 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Works for me now. Thanks. :D

_________________
Andrew

[size=85]OA Server: Windows XP/ XAMPP, Mandriva/Apache, Ubuntu
Auditing: 300+ Wstns, 20+ Srvrs, Thin clients, Linux boxes, Routers, etc
OS's: Windows XP , W2K Srvr, W2K3 Srvr, W2K8, Vista, Windows 7, Linuxes (and a Mac at home)
LDAP: Active Directory[/size]


Top
 Profile  
Reply with quote  
PostPosted: Tue Nov 13, 2007 10:23 pm 
Offline
Contributor

Joined: Fri Sep 28, 2007 12:07 am
Posts: 189
Would just like to say that although this works, I see many machines showing up twice on the gateway list. Why? I am not sure.

I will try look into this as well as the other problem with software register.

Thanks

Jason

_________________
OA Deployment:
Windows 2003 with XAMPP install
80 Windows Servers
250 Windows workstations (mixed XP and 2000)
5 MACs
Multiple printers, switches, routers, firewalls, and other servers (ESX, AIX etc.)


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group