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]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to