Hi Derek, For me, things don't seem to work yet:
1) updating the fingerbank configuration from the pf web gui caused a permission denied on fingerbank.conf, so I chmoded fingerbank.conf to 666, applied the config, and chmodded back to 600: this worked. 2) downloading the online fingerbank gives me a file which size is 965K, whereas my fingerbank backups are around 39MB each. (manually downloading the database gives me the same file/filesize) 3) in the gui I still the "Error! An error occured while contacting the server. Please try again later." 4) in the logs I receive: "Apr 24 09:30:19 httpd.admin(3520) ERROR: DBIx::Class::ResultSet::count(): DBI Exception: DBD::SQLite::db prepare_cached failed: no such table: device [for Statement "SELECT COUNT( * ) FROM device me WHERE ( parent_id IS NULL )"] at /usr/local/fingerbank/lib/fingerbank/Base/CRUD.pm line 317 (pfappserver::PacketFence::Controller::Root::end)" Are you sure that everything on your side should be fully operational now? Regards, and thanks for your (and your collueges) kind support. MJ On 04/23/2015 10:40 PM, Derek Wuelfrath wrote: > 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] <mailto:[email protected]> :: +1.514.447.4918 > (x110) :: +1.866.353.6153 (x110) > Inverse inc. (www.inverse.ca <http://www.inverse.ca>) :: Leaders behind > SOGo (www.sogo.nu <http://www.sogo.nu>) and PacketFence > (www.packetfence.org <http://www.packetfence.org>) > > On April 23, 2015 at 16:33:45, Derek Wuelfrath ([email protected] > <mailto:[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] >> <mailto:[email protected]> :: +1.514.447.4918 (x110) :: >> +1.866.353.6153 (x110) >> Inverse inc. (www.inverse.ca <http://www.inverse.ca>) :: Leaders >> behind SOGo (www.sogo.nu <http://www.sogo.nu>) and PacketFence >> (www.packetfence.org <http://www.packetfence.org>) >> >> On April 23, 2015 at 13:32:33, Tim DeNike ([email protected] >> <mailto:[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] >>> <mailto:[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 > ------------------------------------------------------------------------------ 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
