MJ, No problem, we are here to help !
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 10:42, mj <[email protected]> wrote: > > 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]> >> <mailto:[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/> >> <http://www.sogo.nu <http://www.sogo.nu/>>) >> and PacketFence (www.packetfence.org <http://www.packetfence.org/> >> <http://www.packetfence.org <http://www.packetfence.org/>>) >> >>> On Sep 23, 2016, at 10:19, mj <[email protected] >>> <mailto:[email protected]> >>> <mailto:[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]> >>> <mailto:[email protected] >>> <mailto:[email protected]>> >>> https://lists.sourceforge.net/lists/listinfo/packetfence-users >>> <https://lists.sourceforge.net/lists/listinfo/packetfence-users> >> >> >> >> ------------------------------------------------------------------------------ >> >> >> >> _______________________________________________ >> PacketFence-users mailing list >> [email protected] >> <mailto:[email protected]> >> https://lists.sourceforge.net/lists/listinfo/packetfence-users >> <https://lists.sourceforge.net/lists/listinfo/packetfence-users> >> > > ------------------------------------------------------------------------------ > _______________________________________________ > PacketFence-users mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/packetfence-users > <https://lists.sourceforge.net/lists/listinfo/packetfence-users>
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
