Get all tables with columns 'columnA' or 'ColumnB' in the database

To get all tables with columns 'columnA' or 'ColumnB' in the database 'YourDatabase'

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Fedora 20 on Dell XPS 13

A few notes on setting up a Dell XPS 13 with Fedora 20.

Put Fedora 20 on a flash drive
Change to UEFI boot

Boot from flash (F12 to choose boot device)

Some settings for laptop SSD disks and power saving

TRIM for SSD disk: add discard to disc options (or replace defaults) in /etc/fstab

installed tuned and switch it on

yum install tuned
systemctl start tuned.service
systemctl enable tuned.service
tuned-adm list
tuned-adm profile powersave

yum list powertop
yum install powertop

Touchpad on kernel > 3.11.10

There is currently a minor problem with the touchpad on higher kernels. It seems that the touchpad initialises incorrectly because of i2c and PS2 interfaces.
Blacklisting the i2c-hid module

1. Open /etc/modprobe.d/blacklist.conf in your favorite text editor.
2. Add the line 'blacklist i2c-hid' (no quotes)
3. Save and reboot

See: https://bugzilla.redhat.com/show_bug.cgi?id=1048314

RPM Fusion

su -c 'yum localinstall --nogpgcheck http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-$(rpm -E %fedora).noarch.rpm http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-$(rpm -E %fedora).noarch.rpm'


yum install gstreamer-plugins-ugly gstreamer-plugins-bad gstreamer-ffmpeg xine-lib-extras-freeworld

Rebuild VM host with bigger disks

Disk partitioning

/boot - 500MB
swap - 18GB
/ - 30 GB
/usr - 30GB
/tmp - 10GB
/home - 100GB
/var - the remaining space

3 disks - 2x2TB + 1x1TB

Setup the 2TB disks as a RAID 1 pair - two md devices - md0 for /boot and /md1 for LVM Physical Volume

Put swap on the 1TB disk (no raid) and mounted the rest of the 1TB as /single

OS Install

Installed CentOS 6.5 - software selection - Virtulization Host

Install EPEL:
rpm -Uvh http://www.mirrorservice.org/sites/dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

yum install ntp ntpdate
chkconfig ntpd on

OpenStack Install

The following instructions are from  RDO Quickstart : http://openstack.redhat.com/Quickstart

yum install -y http://rdo.fedorapeople.org/rdo-release.rpm

packstack --allinone

xymon

Add my local basetwo yum repo (or the http://terabithia.org/rpms/xymon/ repo)

yum install xymon-client

Set XYMONSERVERS in /etc/default/xymon-client

service xymon-client start

Add br0 bridge

This is for non-openstack kvm images




Remember to remove this server from known_hosts on any client running virt-manager, otherwise you get a 'is libvirtd running' error.

Create /etc/polkit-1/localauthority/50-local.d/50-libvirt-remote-access.pkla
With something like

[libvirt Management Access]
Identity=unix-user:markd
Action=org.libvirt.unix.manage
ResultAny=yes
ResultInactive=yes
ResultActive=yes






 

Playing with Openstack

Threw together a fedora 20 VM in order to play with http://devstack.org/ gave it 4G Ram and 60G disk and 4 cpus

Install Fedora 20 Basic Web Server

Make selinux permissive

Make sure /etc/hosts is correct (and does not have hostname on 127.0.0.1)

Add a stack user:

useradd stack

Make the stack user a sudoer:

cat <<EOF >/etc/sudoers.d/stack
stack ALL=(ALL) NOPASSWD:ALL
Defaults:stack !requiretty
EOF

Get the devstack scripts and setup a simple local.conf

cd /home/stack
git clone https://github.com/openstack-dev/devstack.git
cd devstack
echo '[[local|localrc]]' > local.conf 
echo ADMIN_PASSWORD=password >> local.conf 
echo MYSQL_PASSWORD=password >> local.conf 
echo RABBIT_PASSWORD=password >> local.conf 
echo SERVICE_PASSWORD=password >> local.conf 
echo SERVICE_TOKEN=tokentoken >> local.conf

Then run the stack.sh as the stack user

./stack.sh


Open up firewall

firewall-cmd --add-service http
firewall-cmd --add-service https

consoles
firewall-cmd --add-port 6080/tcp

keystone
firewall-cmd --add-port 5000/tcp