Hello,
We had another issue with the DB constuction overnight.
Retry, it should be good.
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 24, 2015 at 06:35:12, mourik jan heupink ([email protected]) wrote:
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
------------------------------------------------------------------------------
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
