As a complimentary information, you may no longer be able to access the 
Fingerbank GUI that let you update the database.

The easiest way to get you back on track will probably be by copying over the 
latest database backup file (the date is appended to filename) over the 
existing fingerbank_Upstream.db file.

cp /usr/local/fingerbank/db/fingerbank_Upstream.db_LATESTTIMESTAMP 
/usr/local/fingerbank/db/fingerbank_Upstream.db

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 23, 2015 at 16:33:45, Derek Wuelfrath ([email protected]) wrote:

Tim,

Fingerbank upstream DB was buggy. We just fixed it so you should be good to go!

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 23, 2015 at 13:32:33, Tim DeNike ([email protected]) wrote:

OK, the fingerbank DB I have that is 40mb has 9 tables.  The finger bank DB 
that gets downloaded only has 1 table.  devices_mac_vendors.



On Thu, Apr 23, 2015 at 1:23 PM, Tim DeNike <[email protected]> wrote:
Update says "Successful", but the replacement file is much smaller and this 
shows in the httpd.admin.log when you try to view the fingerprints:

Apr 23 13:20:28 httpd.admin(4717) ERROR: 
DBIx::Class::Storage::DBI::_prepare_sth(): DBI Exception: DBD::SQLite::db 
prepare_cached failed: no such table: dhcp_vendor [for Statement "SELECT COUNT( 
* ) FROM dhcp_vendor me"] at /usr/local/fingerbank/lib/fingerbank/Base/CRUD.pm 
line 317

------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to