Hello,
We are running current v7.4 on Debian 8.
On one of our servers, it seems the fingerbank db will not initialize
properly.
In our logs, we see similar to below:
Mar 4 14:51:08 pf2 packetfence_httpd.aaa: httpd.aaa(1142) ERROR:
[mac:fc:c2:de:9e:7e:3b] Unable to compute Fingerbank device information for
fc:c2:de:9e:7e:3b. Device profiling rules relying on it will not work.
(DBIx::Class::Storage::DBI::_dbh_execute(): Table 'pf_fingerbank.device'
doesn't exist at /usr/local/pf/lib/fingerbank/Base/CRUD.pm line 416
Mar 4 14:51:22 pf2 pfqueue: pfqueue(1268) ERROR: [mac:74:f0:6d:32:56:27]
DBIx::Class::Storage::DBI::_dbh_execute(): Table
'pf_fingerbank.dhcp_fingerprint' doesn't exist at
/usr/local/pf/lib/fingerbank/Base/CRUD.pm line 416
We tried to stop services and re-install fingerbank (apt --reinstall) with
no luck.
Inside the PF GUI, it suggests that it can successfully dispatch the
initialize DB function, but it does not seem to result in creation of the
tables.
The mysql user can ping the DB from the command line as configured in
fingerbank.conf.
We can't seem to find any logs related to the initialization command from
the GUI
Any help appreciated.
cheers,
Ian
pf2:/usr/local/pf/logs# ls -al ../../fingerbank/db
total 5463520
drwxrwxr-x 3 fingerbank fingerbank 4096 Mar 4 14:49 .
drwxrwxr-x 8 fingerbank fingerbank 4096 Mar 4 14:49 ..
-rw-rw-r-- 1 root root 98 Dec 1 10:04 .gitignore
-rw-rw-r-- 1 root root 504208005 Dec 1 10:04
fingerbank_Combination_Map.json
-rw-rw-r-- 1 fingerbank fingerbank 33792 May 26 2017
fingerbank_Local.db
-rw-rw-r-- 1 fingerbank fingerbank 1049072740 Dec 1 10:04
fingerbank_Upstream.db
-rw-r--r-- 1 pf pf 2020635648 Nov 22 21:43
fingerbank_Upstream.db_20171122_214310
-rw-r--r-- 1 pf pf 2020635648 Nov 23 21:43
fingerbank_Upstream.db_20171123_214310
-rw-rw-r-- 1 root root 1072 Dec 1 10:04
sqlite3-to-mysql.py
drwxrwsr-x 2 root root 4096 Mar 4 14:49 upgrade
-rwxrwxr-x 1 fingerbank fingerbank 2253 Dec 1 10:04 upgrade.pl
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
