Hello MJ, > I have installed a fresh packetfence 6.2.1 on new hardware on debian > 8.6. Dropped the pf database from mysql, and imported an sql database > dump from our old pf 5.6.1 database. > > Than these four upgrades: >> upgrade-5.6.0-5.7.0.sql >> upgrade-5.7.0-6.0.0.sql >> upgrade-6.0.0-6.1.0.sql >> upgrade-6.1.0-6.2.0.sql > No errors, and I managed to logon, and take a look in the new > packetfence, noticing the old users and computers. Looking good so far.
Looks good. > Now the next day, restart the (testing) machine again, and I cannot > login the web interface using the admin account anymore: > >> Sep 23 14:57:54 httpd.admin(1543) INFO: Authentication successful for >> 'admin' in source local (SQL) (pf::authentication::authenticate) >> Sep 23 14:57:54 httpd.admin(1543) INFO: Using sources local for matching >> (pf::authentication::match) >> Sep 23 14:57:54 httpd.admin(1543) INFO: database query failed with: Unknown >> column 't.login_remaining' in 'field list' (errno: 1054) >> (pf::db::db_query_execute) > > So, I WAS able to logon yesterday, and the database IS running: Curious… Can you send output of ‘explain password’ in MySQL. Can you also send the output of 'select * from pf_version;’ in MySQL. Thanks! Cheers! -dw. — Derek Wuelfrath [email protected] :: +1.514.447.4918 (x110) :: +1.866.353.6153 (x110) Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) > On Sep 23, 2016, at 09:18, mj <[email protected]> wrote: > > Hi, > > I have installed a fresh packetfence 6.2.1 on new hardware on debian > 8.6. Dropped the pf database from mysql, and imported an sql database > dump from our old pf 5.6.1 database. > > Than these four upgrades: >> upgrade-5.6.0-5.7.0.sql >> upgrade-5.7.0-6.0.0.sql >> upgrade-6.0.0-6.1.0.sql >> upgrade-6.1.0-6.2.0.sql > No errors, and I managed to logon, and take a look in the new > packetfence, noticing the old users and computers. Looking good so far. > > Now the next day, restart the (testing) machine again, and I cannot > login the web interface using the admin account anymore: > >> Sep 23 14:57:54 httpd.admin(1543) INFO: Authentication successful for >> 'admin' in source local (SQL) (pf::authentication::authenticate) >> Sep 23 14:57:54 httpd.admin(1543) INFO: Using sources local for matching >> (pf::authentication::match) >> Sep 23 14:57:54 httpd.admin(1543) INFO: database query failed with: Unknown >> column 't.login_remaining' in 'field list' (errno: 1054) >> (pf::db::db_query_execute) > > So, I WAS able to logon yesterday, and the database IS running: > >> root@wired:/usr/local/pf/logs# mysql -upf -p pf >> Enter password: >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Welcome to the MySQL monitor. Commands end with ; or \g. >> Your MySQL connection id is 148 >> Server version: 5.5.52-0+deb8u1 (Debian) >> >> Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. >> >> Oracle is a registered trademark of Oracle Corporation and/or its >> affiliates. Other names may be trademarks of their respective >> owners. >> >> Type 'help;' or '\h' for help. Type '\c' to clear the current input >> statement. >> >> mysql> show tables; >> +---------------------+ >> | Tables_in_pf | >> +---------------------+ >> | action | > ..... >> | violation | >> | wrix | >> +---------------------+ >> 36 rows in set (0.00 sec) >> >> mysql> > > The database options in pfconfig.conf are correct. > > Anyone an idea what I am missing? > > MJ > > ------------------------------------------------------------------------------ > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
