Ok so did you do :
mysql -u root -p pf -v < db/upgrade-4.1.0-4.2.0.sql
or did you paste db/upgrade-4.1.0-4.2.0.sql in the mysql console ?
Because it look like a paste and the console don´t want stuff like -
Regards
Fabrice
Le 2014-05-07 10:09, Josh Nathan a écrit :
mysql> explain node;
+------------------+------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key |
Default | Extra |
+------------------+------------------+------+-----+---------------------+-------+
| mac | varchar(17) | NO | PRI |
NULL | |
| pid | varchar(255) | NO | MUL |
admin | |
| category_id | int(11) | YES | MUL |
NULL | |
| detect_date | datetime | NO | | 0000-00-00
00:00:00 | |
| regdate | datetime | NO | | 0000-00-00
00:00:00 | |
| unregdate | datetime | NO | | 0000-00-00
00:00:00 | |
| lastskip | datetime | NO | | 0000-00-00
00:00:00 | |
| status | varchar(15) | NO | MUL |
unreg | |
| user_agent | varchar(255) | YES | |
NULL | |
| computername | varchar(255) | YES | |
NULL | |
| notes | varchar(255) | YES | |
NULL | |
| last_arp | datetime | NO | | 0000-00-00
00:00:00 | |
| last_dhcp | datetime | NO | | 0000-00-00
00:00:00 | |
| dhcp_fingerprint | varchar(255) | YES | MUL |
NULL | |
| bypass_vlan | varchar(50) | YES | |
NULL | |
| voip | enum('no','yes') | NO | |
no | |
| autoreg | enum('no','yes') | NO | |
no | |
+------------------+------------------+------+-----+---------------------+-------+
Thanks,
Joshua Nathan
IT Administrator
Black Forest Academy
+49 (0) 7626-916123
On Wed, May 7, 2014 at 3:39 PM, Fabrice DURAND <[email protected]
<mailto:[email protected]>> wrote:
Hello Joshua,
can you paste from mysql the result of :
explain node;
Thanks
Fabrice
Le 2014-05-07 09:32, Josh Nathan a écrit :
I'm getting the below error when I run the mysql command given in
the upgrade document. I'm upgrading from version 4.1 on CentOS 6.5.
--------------
-
-
-
ALTER TABLE node ADD `time_balance` int unsigned AFTER `lastskip`
--------------
ERROR 1064 (42000) at line 1: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '-
-
-
ALTER TABLE node ADD `time_balance` int unsigned AFTER
`lastskip`' at line 1
Thanks,
Joshua Nathan
IT Administrator
Black Forest Academy
+49 (0) 7626-916123 <tel:%2B49%20%280%29%207626-916123>
On Wed, May 7, 2014 at 2:42 AM, Francis Lachapelle
<[email protected] <mailto:[email protected]>> wrote:
The Inverse team is pleased to announce the immediate
availability of PacketFence 4.2.0. This is a major release
with new features, enhancements and important bug fixes. This
release is considered ready for production use and upgrading
from 4.1.0 is strongly advised.
What is PacketFence?
PacketFence is a fully supported, trusted, Free and Open
Source Network Access Control (NAC) solution. Boasting an
impressive feature set, PacketFence can be used to
effectively secure small to very large heterogeneous networks.
Among the features provided by PacketFence, there are:
* Powerful BYOD (Bring Your Own Device) workflows
* Simple and efficient guests management
* Multiple enforcement methods with Role-Based Access
Control (RBAC)
* Compliance checks for computers present on your network
* Integration with various vulnerability scanners and
intrusion detection solutions
* Bandwidth accounting for all devices
A complete overview of the solution is available from the
official website: http://www.packetfence.org/about/overview.html
Changes Since Previous Release
*New Features*
* New 'Apply violation' bulk action
* The same bulk actions for nodes are now available for users
* New WRIX data management
*
Added PacketFence provisioning agent for Android
* Support Hotspot for Cisco WLC and Aruba IAP
* Support for Huawei AC6605 wireless controller
* Support for Enterasys V2110 wireless controller
* Support for Juniper EX2200 and EX4200 switches
* Inline layer 3 support
* New pfbandwidthd daemon for inline layer 3 accounting
* New violation type based on time usage from RADIUS
accounting information
* New violation type based on bandwidth usage from
pfbandwidthd information
* New Mirapay online payment as a billing option
* Billing tiers can now be defined with a real usage
duration (instead of simply a timeout)
* Billing: A confirmation email is sent when purchasing a tier
* New status page with options to extend the network access
(when billing is enabled with access duration) and to
unregister any node associated to the current user
* Integration of mod_qos in the Apache configuration of the
captive portal
* New pfcmd "cache" command
* New pfcmd "configreload" command
*Enhancements*
* Mandatory fields during registration are now configured
per portal profile
* Expanded fields for person field
* Allow pfcmd error/warning/success messages colors to be
configurable
* Allow rules on username for null authentication sources
* Landing page of Web admin interface now depends on the
user's access rights
* Reevaluate access when changing the role of multiple
nodes (#1757)
* Each portal profile can now use its own set of locales
* Added a new URI filter for portal profiles
* Switches configuration page is now paginated
* LLDP support for 3Com 4000 Series
* Multiple DNS server in the network configuration
* Allow alias interface as captive portal
* MAC Authentication support for Enterasys D2 switch
* Added support for JSON-RPC and msgpack RPC over HTTP for
webservices
* Made msgpack the default RPC for RADIUS
* Improved performance of webservices by preloading Perl
modules
* Regexp filter for LDAP source is now case-insensitive
* Improved maintenance database script
* Preserve and restore the URL fragment when the web
session expires in Web admin (#1780)
* Logging is now separated and configurable for each service
* Added missing 'redirect_url' paramater when editing a
violation in the Web admin
* Complete rewrite of captive portal as a Catalyst application
* Added a section documenting eduroam support to the Admin
guide
* Controller IP address can be determined dynamically
* Added a file backing for the cache to decrease cache misses
* Allow advanced search of nodes by OS type (#1790)
* The PF RPC client can be configured in the
conf/radiusd/radiusd.conf
*
Added PacketFence RADIUS dictionary
*Bug Fixes*
* Fixed retrieval of ifIndex in Cisco Catalyst 2950 module
* Fixed Snort and Suricata services management
* Fixed issue when saving a users search in Web admin
*
Fixed JavaScript error with IE8 on Web admin users page
* Fixed Web admin access restrictions for users and nodes
creation
* Fixed SQL query of connection types report in Web admin
* Fixed blank page with WISPr on OS X
* Fixed nodes simple search by IP address
* Fixed access reevaluation when changing the status of a
pending node
* Fixed network access for users with no "set role" action
(#1778)
* Fixed conversion of wildcards to regular expressions in
domains passthroughs
* Fixed display of last IP address of nodes when end_time
is in the future
* Fixed XSS issues in Web admin
* Fixed extractSsid for Cisco Aironet and Cisco Aironet WDS
See the ChangeLog file for the complete list of changes:
https://github.com/inverse-inc/packetfence/tree/packetfence-4.2.0/ChangeLog
See the UPGRADE file for notes about upgrading:
https://github.com/inverse-inc/packetfence/tree/packetfence-4.2.0/UPGRADE.asciidoc
Getting PacketFence
PacketFence is free software and is distributed under the GNU
GPL. As such, you are free to download and try it by either
getting the new release or by getting the sources:
http://www.packetfence.org/development/sourcecode.html
Documentation about the installation and configuration of
PacketFence is also available:
http://www.packetfence.org/documentation/
How Can I Help?
PacketFence is a collaborative effort in order to create the
best Free and Open Source NAC solution. There are multiple
ways you can contribute to the project:
* Documentation reviews, enhancements and translations
* Feature requests or by sharing your ideas
*
Participate in the discussion on mailing lists
(http://www.packetfence.org/support/community.html)
* Patches for bugs or enhancements
* Provide new translations of remediation pages
Getting Support
For any questions, do not hesitate to contact us by writing
to [email protected] <mailto:[email protected]>
You can also fill our online form
(http://www.inverse.ca/about/contact.html) and a
representative from Inverse will contact you.
Inverse offers professional services to organizations willing
to secure their wired and wireless networks with the
PacketFence solution.
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May
7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected] <mailto:[email protected]> ::+1.514.447.4918
<tel:%2B1.514.447.4918> (x135) ::www.inverse.ca <http://www.inverse.ca>
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to
find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
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)
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
