I did the first one, pasted
mysql -u root -p pf -v < db/upgrade-4.1.0-4.2.0.sql
into the console.
For running the commands within mysql, I just tried logging in as root,
switching to use pf, and then ran the command
db/upgrade-4.1.0-4.2.0.sql
but it obviously didn't like that as it didn't know how to find the file,
etc. So... how should I run the commands from within mysql? Open the file
and copy/paste the contents?
Thanks,
Joshua Nathan
IT Administrator
Black Forest Academy
+49 (0) 7626-916123
On Wed, May 7, 2014 at 4:21 PM, Fabrice DURAND <[email protected]> wrote:
> 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]> 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 <%2B49%20%280%29%207626-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
> 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
