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
