Hello Diego,

The issue has been fixed in latest ‘devel’ codebase.
You can refer to the following issue that also contains the commit. 
https://github.com/inverse-inc/packetfence/issues/488

Cheers!
dw.

-- 
Derek Wuelfrath
[email protected] :: +1.514.447.4918 (x110) :: +1.866.353.6153 (x110)
Inverse inc. (www.inverse.ca) :: Leaders behind SOGo (www.sogo.nu) and 
PacketFence (www.packetfence.org)

On April 20, 2015 at 07:31:58, Diego Bonfigli ([email protected]) wrote:

Hi,
  in pf 5.0.0 web interface, in reports -> operating systems I get "Error! 
Can't fetch data from database for report os." on httpd.admin.log:

Apr 20 09:59:05 httpd.admin(10846) WARN: database query failed with: Table 
'pf.dhcp_fingerprint' doesn't exist (errno: 1146), will try again 
(pf::db::db_query_execute)
Apr 20 09:59:05 httpd.admin(10846) WARN: database query failed with: Table 
'pf.dhcp_fingerprint' doesn't exist (errno: 1146), will try again 
(pf::db::db_query_execute)
Apr 20 09:59:05 httpd.admin(10846) WARN: database query failed with: Table 
'pf.dhcp_fingerprint' doesn't exist (errno: 1146), will try again 
(pf::db::db_query_execute)
Apr 20 09:59:05 httpd.admin(10846) ERROR: Database issue: We tried 3 times to 
serve query report_os_sql called from pf::db::db_data and we failed. Is the 
database running? (pf::db::db_query_execute)

It seems that a clean installation of pf 5.0.0 does not create that table, and 
I thing there is some legacy code in the web interface to generate the reports.

Diego


------------------------------------------------------------------------------  
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT  
Develop your own process in accordance with the BPMN 2 standard  
Learn Process modeling best practices with Bonita BPM through live exercises  
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_  
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF_______________________________________________
  
PacketFence-users mailing list  
[email protected]  
https://lists.sourceforge.net/lists/listinfo/packetfence-users  
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to