PLUG Meeting topics for April 13th

[PLUG Announcements]

  PLUG Meeting April 13th

------------------------------------------------------------------------


  This month we will have a two presentations


    Phil Waclawski will present "Using Hierarchical Data in MySQL, Trees
    vs Nests" and Ed Nicholson will present "Securing a SSH Bastion host
    with PrivacyIDEA and U2F"

For more info, Meeting time and location see:
http://phxlinux.org/index.php/meetings/14-east-valley-meeting.html
**
------------------------------------------------------------------------
*Phil Waclawski: Using Hierarchical Data in MySQL, Trees vs Nests*

Real world data is often made of hierarchical relationships, or "trees".
Representing that data in a Relational Database starts to get 
complicated as soon as you have more than two levels in your "Tree".
There are many strategies for handling such data, and I will cover 
examples of at least two of them (adjacency list and nested sets) and 
possibly more.

If you have access to a mysql instance, you can create the test tables 
and follow along, or get the code later.

*About Phil:*
Phil has been a faculty member, focusing on open source software at MCC 
for nearly two decades.

Phil teaches a variety of course, including MySQL Database, PHP, Python, 
Javascript, HTML 5 and CSS, Linux OS, Internet Server Set up and more.

This summer, Phil will once again be offering a "MCC Multimedia Madness" 
summer camp for 6-8th graders. Over the two weeks I will cover a wide 
range of open source software, including GIMP, Inkscape, Krita, 
Audacity, Blender, Hydrogen Drum Kit, Tux Guitar, Openshot, Linux 
Multimedia Studio, work with green screen and more.

For hobbies, Phil has too many. Blacksmithing, archery, Leatherworking, 
Wood Working, Jewelry, Sound Recording/editing and SCUBA diving.  Phil 
is also learning to play the Bass.

Phil has been using linux at home for desktops and servers since 1994.



*Ed Nicholson: Securing a SSH Bastion host with PrivacyIDEA and U2F*

Bastion Servers are an important tool for access control to your other
systems. PrivacyIDEA is a credential management system that can add
many types of authentication to your Jump Server, for example U2F.
FIDO Universal 2nd Factor Keys are a convenient standard implemented
by many to improve security. PrivacyIDEA is a great example of how
easy adding important levels of security to your systems can be.

*About Ed:*
Ed has been involved with Free Software for some time, and is most
interested in how people, organizations and populations use, create and
experience information. Recently, Ed is enjoying The Prescott National 
Forest
as his "personal office" and The Valley of The Sun as a home away from home.
Personal systems run either Fedora, Project Atomic, Android or OpenBSD.
------------------------------------------------------------------------

The meeting will start at 7pm at The Desert Breeze Substation.  People 
start arriving as early as 6pm, so if you would like to help setup 
and/or chat for a while, arrive a little early.
*Meeting Location*:
Desert Breeze Substation
251 North Desert Breeze Blvd West
Chandler, AZ 85226

The Desert Breeze Substation is on Chandler Blvd and Desert Breeze Blvd, 
which is half way between McClintock and Rural.  It is very close
to both the south 202 and 101 freeways.  Public transportation is
available into the late hours.
	<https://www.google.com/maps/place/251+Desert+Breeze+Blvd+W,+Chandler,+AZ+85226/@33.3076899,-111.9220921,17z/data=%214m5%213m4%211s0x872b06cdd50c43c7:0x7d3e9c66bdb7f8a2%218m2%213d33.3070191%214d-111.9193025?hl=en>

We will go for food to BJs at the Chandler Fashion Center Mall after the 
meeting so we can chat with each other comfortably. Please feel free to 
join us. Please come even if you aren't hungry, the food is not mandatory.

See the meeting information on our web site 
<http://phxlinux.org/meetings/14-east-valley-meeting.html> for more 
information.

See you there,
Brian Cluff

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phxlinux.org/pipermail/plug-announce/attachments/20170406/405358f6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 38453 bytes
Desc: not available
URL: <http://lists.phxlinux.org/pipermail/plug-announce/attachments/20170406/405358f6/attachment.jpe>