Hi,
i met the same issue yesterday and a "pfcmd configreload" fixed the issue.
Regards
Fabrice
Le 2014-08-22 10:11, Bagley, Cheslin (Mr) (Summerstrand Campus North) a
écrit :
Hi Louis
Sorry for replying only know. Had to concentrate on other things.
>Is the database running?
Yes the database is running (command used to check this “service
mysqld status”)
>Can pf connect to it?
Not sure if I checked this correctly, but I used command “mysql
--host=localhost --user=pf –password” to check this
>If the database is missing columns then something is very wrong.
These are the tables in the database:
+---------------------+
| Tables_in_pf |
+---------------------+
| action |
| activation |
| billing |
| class |
| configfile |
| dhcp_fingerprint |
| email_activation |
| ifoctetslog |
| inline_accounting |
| iplog |
| locationlog |
| locationlog_history |
| node |
| node_category |
| node_useragent |
| os_class |
| os_mapping |
| os_type |
| person |
| radacct |
| radacct_log |
| radius_nas |
| savedsearch |
| scan |
| sms_activation |
| sms_carrier |
| soh_filter_rules |
| soh_filters |
| switchlocation |
| temporary_password |
| traplog |
| trigger |
| userlog |
| violation |
| wrix |
+---------------------+
I think I sorted out the database issue by upgrading the
pfschema.mysql to 4.3.0
>How did you install this system
Clean install using the Admin guide.
>What release of PF is this?
4.3.0
>On which OS/distro/release?
Centos6.5
I’m still getting the fix permission error from web gui. I can make
changes in config files from CLI.
Any other suggestion is much appreciated.
Regards
Cheslin
*From:*Louis Munro [mailto:[email protected]]
*Sent:* Wednesday, August 20, 2014 4:26 PM
*To:* [email protected]
*Subject:* Re: [PacketFence-users] Packetfence 4.3.0 - Cannot save
changes to configs via Web Gui
On 2014-08-20, at 10:10 , "Bagley, Cheslin (Mr) (Summerstrand Campus
North)" <[email protected] <mailto:[email protected]>>
wrote:
Hi Louis
It seems to be under every menu, eg. If I make changes under
“Configuration” – “General” it gives me that error message. Also
under “Configuration” – “Switches” it gives me the same message.
If I want to create a user it gives me an error message, but a
different one (WARN: database query failed with: Unknown column
'p.portal' in 'field list' (errno: 1054), will try again
(pf::db::db_query_execute)) and (ERROR: modify of non-existent
person cbagley attempted - person add failed
(pf::person::person_modify))
Then you likely have a database issue and not a permissions issue.
Is the database running?
Can pf connect to it?
If the database is missing columns then something is very wrong.
How did you instal this system?
What release of PF is this?
On which OS/distro/release?
Regards,
--
Louis Munro
[email protected] <mailto:[email protected]> :: www.inverse.ca
<http://www.inverse.ca>
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu <http://www.sogo.nu>)
and PacketFence (www.packetfence.org <http://www.packetfence.org>)
------------------------------------------------------------------------
NOTICE: Please note that this eMail, and the contents thereof, is
subject to the standard NMMU eMail disclaimer which may be found at:
http://www.nmmu.ac.za/disclaimer/email.htm
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
Slashdot TV.
Video for Nerds. Stuff that matters.
http://tv.slashdot.org/
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
