Ricky Adams – Page 4 – RickyAdams.com

Processing Excel Files in Python Using XLRD (Documentation)

April 27, 2017 Ricky Adams

xlrd 1.0.0 documentation Handling of Unicode Dates in Excel spreadsheets Named references, constants, formulas, and macros Formatting information in Excel Spreadsheets Loading worksheets on demand XML vulnerabilities and Excel files API Reference Installation Instructions Development Changes Acknowledgements Licenses xlrd Docs » xlrd 1.0.0 documentation Edit on GitHub xlrd documentation¶ xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files. Handling of Unicode¶ This package presents all text strings as…

Read More Read More

Kill Processes from Command Prompt in Windows

April 26, 2017 Ricky Adams

Kill Processes from Command Prompt I’m sure you are familiar with the traditional way to kill or end a process in Windows using Task Manager. This method is effective but not nearly as fun as killing a process in Command Prompt. Additionally, killing processes in Command Prompt provides much more control and the ability to end multiple processes at once. All of this is possible with the TaskKill command. First, let’s cover the basics. You can kill a process by…

Read More Read More

Installing Third-Party Python Modules

April 25, 2017 Ricky Adams

Installing Third-Party Modules Beyond the standard library of modules packaged with Python, other developers have written their own modules to extend Python’s capabilities even further. The primary way to install third-party modules is to use Python’s pip tool. This tool securely downloads and installs Python modules onto your computer from https://pypi.python.org/, the website of the Python Software Foundation. PyPI, or the Python Package Index, is a sort of free app store for Python modules. The pip Tool The executable file…

Read More Read More

Using Python with Excel Spreadsheets with OpenPyXL

April 25, 2017 Ricky Adams

Working with Excel Spreadsheets Excel is a popular and powerful spreadsheet application for Windows. The openpyxl module allows your Python programs to read and modify Excel spreadsheet files. For example, you might have the boring task of copying certain data from one spreadsheet and pasting it into another one. Or you might have to go through thousands of rows and pick out just a handful of them to make small edits based on some criteria. Or you might have to…

Read More Read More

Configuring JIRA for Email Feeds

April 19, 2017 Ricky Adams

Configuring JIRA applications to receive email from a POP or IMAP mail server To enable JIRA to create comments and issues from email, you need to first configure JIRA to receive email from a POP or IMAP mail server as described below. Note: For all of the following procedures, you must be logged in as a user with the JIRA Administrators global permission. Add or edit a POP or IMAP mail server Choose > System. Select Mail > Incoming Mail to open the Incoming Mail page….

Read More Read More

How to setup cifs mounts in autofs using kerberos authentication on RedHat Linux

April 19, 2017 Ricky Adams

How to setup cifs mounts in autofs using kerberos authentication Solution Verified – Updated March 6 2017 at 2:24 AM – English No translations currently exist. Environment Red Hat Enterprise Linux 6 Please Note: Kerberos support for CIFS mounts is considered Tech Preview in Red Hat Enterprise Linux 5. See 5.8 Technical Notes for more information. Issue How to setup cifs mounts in autofs using kerberos authentication? Configuration for authentication to cifs shares with a kerberos ticket. Resolution using sssd…

Read More Read More

Linux CIFS AutoFS (automount) using Kerberos Authentication and kinit

April 19, 2017 Ricky Adams

Setup Linux CIFS AutoFS (automount) using kerberos authentication March 5, 2015 ~ tatroc2015 Written using CentOS 6, Windows 2012 Active Directory This guide was written assuming you already have Kerberos authentication working. In this post I will describe how to mount a Windows CIFS share from a Linux system using Kerberos authentication to a Windows Active Directory domain. In addition, the users credentials will be stored securely in a keytab file. Step 1. verify you can get a Kerberos ticket kinit…

Read More Read More

RedHat OpenStack Deployment and Management (RDO, TripleO, OOO)

March 29, 2017 Ricky Adams

Virtual Environment Quickstart Further reading Presentations TripleO quickstart TripleO is an OpenStack Deployment & Management tool. It is developed upstream as the OpenStack TripleO project, but we have a special love for it in RDO-land. Virtual environment quickstart There is an Ansible-based project called tripleo-quickstart whose main goal is to quickly stand up TripleO environments using an image-based undercloud approach similar to the OPNFV Apex project. You will need a host machine (referred to as $VIRTHOST) with at least 16GB…

Read More Read More

Introduction: Deploying OpenStack on MAAS 1.9+ with Juju

March 29, 2017 Ricky Adams

Introduction: Deploying OpenStack on MAAS 1.9+ with Juju By Canonical on 21 January 2016 Share or save Facebook Twitter Google+ Email LinkedIn Add to Instapaper Add to Pocket In the past months our Juju Core Sapphire team has been working on the design, planning, and implementation of a set of extended networking features for Juju 1.25 and the upcoming (January 2016) 1.26 releases. The main focus is enabling users of Juju to have a finer-grained control over how their services…

Read More Read More

Deploying an OpenStack Cloud with Juju

March 29, 2017 Ricky Adams

Scope The OpenStack platform is powerful and its uses diverse. This section of documentation is primarily concerned with deploying a “standard” running OpenStack system using, but not limited to, Canonical components such as MAAS, Juju and Ubuntu. Where appropriate other methods and software will be mentioned. Assumptions Use of MAAS – follow these intructions first. Use of Juju Local network configuration – This document assumes that you have an adequate local network configuration, including separate interfaces for access to the…

Read More Read More

Preparing MAAS for Juju and OpenStack using Simplestreams from Cononical

March 29, 2017 Ricky Adams

Preparing MAAS for Juju and OpenStack using Simplestreams When Juju bootstraps a cloud, it needs two critical pieces of information: The uuid of the image to use when starting new compute instances. The URL from which to download the correct version of a tools tarball. This necessary information is stored in a json metadata format called “simplestreams”. For supported public cloud services such as Amazon Web Services, HP Cloud, Azure, etc, no action is required by the end user. However,…

Read More Read More

Using MaaS to Prepare for an OpenStack Installation

March 29, 2017 Ricky Adams

Scope This document provides instructions on how to install the Metal As A Service (MAAS) software. You have sufficient, appropriate node hardware You will be using Juju to assign workloads to MAAS You will be configuring the cluster network to be controlled entirely by MAAS (i.e. DNS and DHCP) If you have a compatible power-management system, any additional hardware required is also installed(e.g. IPMI network). Introducing MAAS Metal as a Service – MAAS – lets you treat physical servers like…

Read More Read More

Python Exceptions and Error Handling

March 23, 2017 Ricky Adams

Python provides two very important features to handle any unexpected error in your Python programs and to add debugging capabilities in them − Exception Handling: This would be covered in this tutorial. Here is a list standard Exceptions available in Python: Standard Exceptions. Assertions: This would be covered in Assertions in Python tutorial. List of Standard Exceptions − EXCEPTION NAME DESCRIPTION Exception Base class for all exceptions StopIteration Raised when the next() method of an iterator does not point to…

Read More Read More

Linux CHMOD File Permissions Decoded from the 1980s

March 10, 2017 Ricky Adams

Linux File Permissions In Ubuntu / Linux everything is a file, so everything will have permissions also. File permissions define which user or system accounts have permissions to read, write, and execute specific files. These read, write, and execute permissions are defined for: user the user that owns the file group users in the files group other every other user There are also three other components when it comes to file mode bits, namely the setuid bit, the setgid bit,…

Read More Read More

Packer: In 10 minutes, from zero to bootable VirtualBox Ubuntu 12.04

February 13, 2017 Ricky Adams

Packer: In 10 minutes, from zero to bootable VirtualBox Ubuntu 12.04 Updated: June 21, 2016 Trying to build a simple VirtualBox Ubuntu image was not without digging around, even though the documentation at Packer would lead you to believe everything is quite straightforward. If you were looking for a concrete example of creating a VirtualBox Ubuntu 12.04 LTS image with Packer, this should be a straightforward guide to get you up and running fast. (Updated for packer v0.10.1) Packer is…

Read More Read More

vOneCloud – A Simple Poor Man’s vCloud

February 8, 2017 Ricky Adams

SOURCE: http://vonecloud.today/ A Cloud on VMware vCenter vOneCloud is an OpenNebula distribution optimized to work on existing VMware vCenter deployments. It deploys an enterprise-ready OpenNebula cloud just in a few minutes where the infrastructure is managed by already familiar VMware tools, such as vSphere and vCenter Operations Manager, and the provisioning, elasticity and multi-tenancy cloud features are offered by OpenNebula Powerful Virtual data centers, self-service portal, datacenter federation, hybrid cloud on your VMware environment Cost Effective Free, there are no…

Read More Read More

Infrastructure-As-Code (IAC) – Terraform Versus The Others

February 8, 2017 Ricky Adams

SOURCE: https://blog.gruntwork.io/why-we-use-terraform-and-not-chef-puppet-ansible-saltstack-or-cloudformation-7989dad2865c#.gxz3kx827 Update: we took this blog post series, expanded it, and turned it into a book called Terraform: Up & Running! This is Part 1 of the Comprehensive Guide to Terraform series. In the intro to the series, we discussed why every company should be using infrastructure-as-code (IAC). In this post, we’re going to discuss why we picked Terraform as our IAC tool of choice. If you search the Internet for “infrastructure-as-code”, it’s pretty easy to come up with…

Read More Read More

Linux Script to Autostart a Background Process if not running

February 7, 2017 Ricky Adams

# start a background process if it is not running, can also use in cron to check every hour or so #!/bin/sh if ! ps -elf | grep -v grep | grep processname ; then python processname.py >> /home/user/bin/spooler.log & ## #mailing program ## /home/user/bin/simplemail.php “Print spooler was not running… Restarted.” fi

Linux TarBall Create and Extract

January 28, 2017 Ricky Adams

Create a TarBall File tar -zcvf archive-name.tar.gz directory-name Where, -z : Compress archive using gzip program -c: Create archive -v: Verbose i.e display progress while creating archive -f: Archive File name For example, say you have a directory called /home/jerry/prog and you would like to compress this directory then you can type tar command as follows: $ tar -zcvf prog-1-jan-2005.tar.gz /home/jerry/prog Above command will create an archive file called prog-1-jan-2005.tar.gz in current directory. If you wish to restore your archive…

Read More Read More

KVM Installation on Linux

January 26, 2017 Ricky Adams

KVM/Installation Reference: https://help.ubuntu.com/community/KVM KVM Introduction Ubuntu uses KVM as the back-end virtualization technology primarily for non-graphic servers and libvirt as its toolkit/API. Libvirt front ends for managing VMs include virt-manager (GUI) or virsh (CLI). Alternative management options include convirt (GUI) or convirt2 (WWW). Documentation Installation – Installation and removal of KVM Networking – Network configuration; includes bridging Guest Creation – Creation of different kinds of guests Guest Management – Management of guests; command line or graphically Guest Console…

Read More Read More