Dave Kludt oldarmyc

Connecting to MS SQL using Kerberos Authentication

FreeTDS is as set of libraries that allows programs to talk to MS SQL Server. It doesn't currently support Kerberos authentication, however, so you'll need to rebuild the freetds package to enable the flag.

Rebuilding FreeTDS

Pull down the existing recipe for the current conda packages for freetds located here: https://github.com/AnacondaRecipes/freetds-feedstock

git clone https://github.com/AnacondaRecipes/freetds-feedstock.git

To build the ibm_db package you would need to execute the following steps.

conda skeleton pypi ibm_db

Once complete a directory labeled ibm_db will be created, and inside that directory you will have a meta.yaml file.

If you would like to build the package for a specific python version you can edit the meta.yaml file

Migrating an Anaconda Enterprise 5 Repository

When faced with the prospect of moving between versions of AE5, you might be wondering what to do about your repository. Mirroring large repos can take hours. Plus, you may have custom channels that platform users have created to share packages. Follow the steps below to make the process of migrating your repository easier.

Before you begin:

Ensure that you have SSH access between both the existing and new clusters, so that files can be moved within and between systems.

The following processes use the root user, but root access is not required to complete the tasks.

	MODULES="overlay br_netfilter ebtables iptable_nat iptable_filter"
	echo "Enabling Modules"
	for i in ${MODULES}; do echo "$i" \| tee /etc/modules-load.d/$i.conf > /dev/null; done
	for i in ${MODULES}; do sudo modprobe $i; done
	lsmod \| grep 'overlay\\|br_netfilter\\|ebtables'

	echo "Disabling SELinux"
	sudo setenforce 0
	sudo sed -i -- 's/SELINUX\=enforcing/SELINUX\=disabled/g' /etc/selinux/config
	echo "Modifying Kernel Parameters"

	"""
	MLDB example using the pymldb library
	Note: pymldb only works in python 2

	The pip packages you would need to install and use the are pymldb and tqdm

	pip install pymldb tqdm

	"""
	# Import the library

	"""
	To get started will have to install a few packages to get things running

	# Download the release RPM from couchbase that sets up the couchbase repositories
	wget http://packages.couchbase.com/releases/couchbase-release/couchbase-release-1.0-4-x86_64.rpm

	# Install the RPM using yum
	sudo yum localinstall couchbase-release-1.0-4-x86_64.rpm -y

	# Install the needed packages required for the pip package install

	"""
	Connecting to Redis server

	Install the pip package for python to use for connecting to Redis

	pip install redis
	"""

	# Import the library
	import redis

	"""
	To install the vertica driver would need to install via conda

	conda install -c conda-forge vertica-python

	Import the vertica python library
	"""
	import vertica_python
	import json

	"""
	Import the ibm_db library

	Will need to ensure that gcc is installed in the project environment as well. To do this will need to
	go to the environment terminal and install gcc through yum using the following command.

	sudo yum install gcc -y

	After gcc installs you can install the pip package ibm_db using the following command.

	"""
	Import the cassandra libraries that will be needed to connect to the cassandra cluster.

	Note: Currently the cassandra-driver is only available for python 2.7 on conda-forge

	Example install of package
	conda install -c conda-forge cassandra-driver
	"""
	from cassandra.auth import PlainTextAuthProvider
	from cassandra.cluster import Cluster

Dave Kludt oldarmyc

Migrating an Anaconda Enterprise 5 Repository

Before you begin:

On the newly installed cluster (version 5.2.3)