This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.
DB Hangops - every other Wednesay at noon Pacific time
Percona University is coming to Washington, DC on Thursday, September 12th.
MySQL Connect is happening in San Francisco from Saturday September 21st - Monday September 23rd.
2nd MySQL, NoSQL and Cloud Conference & Expo Monday, October 14th through Wednesday October 16th, 2013 in Buenos Aires, Argentina.
Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center.
MySQL Utilities part 2
# mysqlserverinfo --server=root:passs@localhost --format=vertical
# Source on localhost: ... connected.
************************* 1. row *************************
In this week's Ear Candy, we talk about a problem installing MySQL Utilities on Ubuntu.
MySQL Utilities are installed under:
while the connector was under:
Install the Connector and in the Python command line run the following sequence:
>>> import mysql.connector
>>> print mysql.connector.__file__
Install the MySQL utilities and run the same command, now the path will begin with /usr/local/lib
Check sys.path in Python:
>>> import sys
>>> print sys.path
['', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/usr/lib/python2.7/lib-old', '/usr/lib/python2.7/lib-dynload', '/usr/local/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages', '/usr/lib/python2.7/dist-packages/PILcompat', '/usr/lib/python2.7/dist-packages/gst-0.10', '/usr/lib/python2.7/dist-packages/gtk-2.0', '/usr/lib/pymodules/python2.7', '/usr/lib/python2.7/dist-packages/ubuntu-sso-client', '/usr/lib/python2.7/dist-packages/ubuntuone-client', '/usr/lib/python2.7/dist-packages/ubuntuone-control-panel', '/usr/lib/python2.7/dist-packages/ubuntuone-couch', '/usr/lib/python2.7/dist-packages/ubuntuone-storage-protocol']
Notice that /usr/local/lib/python2.7/dist-packages is before the /usr/lib/pytho2.7/dist-packages, resulting in loading the utilities first and not recognizing the connector.
You can solve this issue with a symlink:
ln -sv /usr/lib/python2.7/dist-packages/mysql/connector/ connector
Now, if you try import mysql.utilities, followed by import mysql.connector and printing the __file__ property for both, it'll show that both are loading from the /usr/local/lib subtree.
At the Movies
This week we present A preview of the SkySQL data suite version 2 by Massimo Brignoli, Product Manager at SkySQL at the SkySQL and MariaDB Solutions Day 2013 that happened earlier this year.
Where you can see us
Sheeri will be at the September Boston MySQL User Group meeting on Monday September 9th.
We will both be speaking at MySQL Connect in San Francisco from Saturday September 21st - Monday September 23rd.
Sheeri will be at the Nagios World 2013 Conference in St. Paul, Minnesota on Monday, September 30th through Thursday, October 3rd.