aiai. That line was commented out. :-(
And I also realise why... On my first atempt, I did not DROP 6.2.1 the database, but simply imported the 5.6.1 'on top of' the existing 6.2.1 database. Doing that, the database upgrades didn't work out well. Then first I tried to comment out a few offending lines. And try again. Then I decided that this was not the best approach. Then i DROPPED the pf6 database, and recreating a new pf-5.6.1 database. Run the upgrades on that... but forgot to re-enable that line... Sorry to have waisted your time Derek! MJ On 09/23/2016 04:26 PM, Derek Wuelfrath wrote: > MJ, > > That’s strange. You are effectively missing the “login_remaining” column > in the “password” table. > It should be part of the upgrade-5.7.0-6.0.0.sql script. > > Can you open it and tell me what you have at line 35 of that file ? > > Thanks > > Cheers! > -dw. > > — > Derek Wuelfrath > [email protected] <mailto:[email protected]> :: +1.514.447.4918 > (x110) :: +1.866.353.6153 (x110) > Inverse inc. :: Leaders behind SOGo (www.sogo.nu <http://www.sogo.nu>) > and PacketFence (www.packetfence.org <http://www.packetfence.org>) > >> On Sep 23, 2016, at 10:19, mj <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi Derek, >> >> Thanks for the response. >> >>> Can you send output of ‘explain password’ in MySQL. >> Here it is: >> >>> mysql> explain password >>> -> ; >>> +-----------------+--------------+------+-----+---------------------+-------+ >>> | Field | Type | Null | Key | Default | >>> Extra | >>> +-----------------+--------------+------+-----+---------------------+-------+ >>> | pid | varchar(255) | NO | PRI | NULL | >>> | >>> | password | varchar(255) | NO | | NULL | >>> | >>> | valid_from | datetime | YES | | NULL | >>> | >>> | expiration | datetime | NO | | NULL | >>> | >>> | access_duration | varchar(255) | YES | | NULL | >>> | >>> | access_level | varchar(255) | YES | | NONE | >>> | >>> | category | int(11) | YES | | NULL | >>> | >>> | sponsor | tinyint(1) | NO | | 0 | >>> | >>> | unregdate | datetime | NO | | 0000-00-00 00:00:00 | >>> | >>> +-----------------+--------------+------+-----+---------------------+-------+ >>> 9 rows in set (0.00 sec) >>> >>> mysql> >> >>> >>> Can you also send the output of 'select * from pf_version;’ in MySQL. >> >> Here: >>> mysql> select * from pf_version;’ >>> +--------+---------+ >>> | id | version | >>> +--------+---------+ >>> | 327936 | 5.1.0 | >>> | 328192 | 5.2.0 | >>> | 328448 | 5.3.0 | >>> | 328704 | 5.4.0 | >>> | 328960 | 5.5.0 | >>> | 329216 | 5.6.0 | >>> | 329472 | 5.7.0 | >>> | 393216 | 6.0.0 | >>> | 393472 | 6.1.0 | >>> | 393728 | 6.2.0 | >>> +--------+---------+ >>> 10 rows in set (0.00 sec) >> >> All looking good it seems... >> >> MJ >> >> ------------------------------------------------------------------------------ >> _______________________________________________ >> PacketFence-users mailing list >> [email protected] >> <mailto:[email protected]> >> https://lists.sourceforge.net/lists/listinfo/packetfence-users > > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > 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
