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]> 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
>
>
> On Wed, May 7, 2014 at 2:42 AM, Francis Lachapelle <[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]
>>
>> 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]
>> 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
> nowhttp://p.sf.net/sfu/perforce
>
>
>
> _______________________________________________
> PacketFence-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
> --
> Fabrice [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
>
>
------------------------------------------------------------------------------
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
