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
