Installation of Python MySQL client on beaglebone angustrom

Referring to
http://www.hkcode.com/programming/417
http://sourceforge.net/projects/mysql-python/

http://dev.mysql.com/doc/connector-python/en/connector-python-installation.html

There are several connectors for different platform, win32, win64, debian, ubuntu...etc, each has file in 2 compression formats.ZIP or tar.

My beaglebone is on angustrom, no worry, there is a platform independent option

down load the tar file, and transfer to beaglebone with SCP, then un tar it, using python setup.py install to install it.
shell> tar xzf mysql-connector-python-VER.tar.gz
shell> cd mysql-connector-python-VER
shell> sudo python setup.py install




 installation complete with out error,
but  in python:
import mysql   no error
import mysql.connector failed with lot of error

Traceback (most recent call last):
  File "dates.py", line 38, in <module>
    import mysql.connector
  File "/usr/lib/python2.7/site-packages/mysql/connector/__init__.py", line 41, in <module>
    from .optionfiles import read_option_files
  File "/usr/lib/python2.7/site-packages/mysql/connector/optionfiles.py", line 35, in <module>
    from .fabric import CNX_FABRIC_ARGS
  File "/usr/lib/python2.7/site-packages/mysql/connector/fabric/__init__.py", line 48, in <module>
    from .connection import (
  File "/usr/lib/python2.7/site-packages/mysql/connector/fabric/connection.py", line 44, in <module>
    from xmlrpc.client import Fault, ServerProxy, Transport
ImportError: No module named xmlrpc.client

this web page explain some similar situation:
http://blog.immanuelnoel.com/2014/07/05/the-mysqlpython-connector-saga/

Using opke list | grep xmlrpc we found following related package:
python-xmlrpc - 2.7.3-r0.3.7 - python version 2.7.3-r0.3
xmlrpcpp - 1.9.48-r0.1 - xmlrpcpp version 1.9.48-r0
xmlrpcpp-dev - 1.9.48-r0.1 - xmlrpcpp version 1.9.48-r0 - Development files

seems the first one looks good, try it with
opkg install python-xmlrpc

But I got errors as following:
 * pkg_get_installed_files: Failed to open //var/lib/opkg/info/libxxf86dga1.list: No such file or directory.
 * pkg_get_installed_files: Failed to open //var/lib/opkg/info/kernel-module-virtio-console.list: No such file or directory.

Not sure what's that, but seems not terrible....So, I tried to import mysql.conector in python shell, this time, error has gone.
root@beaglebone:~# python
Python 2.7.3 (default, May 29 2013, 21:25:00)
[GCC 4.7.3 20130205 (prerelease)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import mysql.connector
>>>

留言

張貼留言

這個網誌中的熱門文章

Meshtastic 03 adding GPS on TTGO lora32 V2

圖片
 I wish to add GPS on my running meshtastic client on TTGO lora32. I have a GPS module outputs with nema at 9600bps. In the config app, in the position sector, you  can find the redefine of PGS pins. I firstly use IO00 as GPS_RX_pin. But it does not work. I guess the web config use 0 as none-config default. Then I want to know what is the default pin for GPS in meshtastic for TTGO Lora 32, I use the 2.4.x firmware for V2.1-1.6. Checked the git, there is no default gps pin for this hardware, so I changed the gps to mcu pin to 34, leave other pins stuff as 0 and do the config .  And it works. there is a new flasher, which still has LILYGO T-Lora V2.1-1.6 as board selection, with latest 2.5.xx firmware maintain 34,0,0 setting is no longer working. after few try, I decided to set to 34/32/25, where 32/25 are free pin on my board. I also reference to  LILYGO Meshtastic T-Beam V1.2 ESP32 LoRaGPS WiFi , it has a gps on 34/12 with 34/12/0 the setting is still working
閱讀完整內容

GeoSetter how to add geotag on to pictures, and export to google earth as kmz

圖片
I use gps info of my cell phone when I take pictures, so that I can find where these pics were taken after a long voyage. I also wish to export these pics to google earth or google map, which can be kml or kmz. https://geosetter.de/en/download-en/ Geo setter is a very powerful one. Some times my phone was not able to add geotag info on the the picture, since it does not have location info at that time(indoor picture or gps was not available). Of course you can edit the pic, but geo sitter provide a better interface, you can pic a location on map and then assign the location to the photo that you selected. much easier than deal with coordinates. I notes the steps as following. After install geosetter, select the folder where you store your images. photos with a blue location dot means these pics contain geotag. select one pic with no blue dot, and go to top menu "map", select "show overview map"  a google map will show up with goe location of pictures...
閱讀完整內容

Meshtastic 02 try to work with sensors

圖片
 It's possible to config client with attached sensor, in 2.4 version, there is IIC ones, maybe we can also use serial  function for sensors as well.( Serial Module Configuration ) Currently Supported Sensor Types ​ 2.4 Sensor I 2 C Address Data Points BMP085 0x76, 0x77 Temperature and barometric pressure BMP180 0x76, 0x77 Temperature and barometric pressure BMP280 0x76, 0x77 Temperature and barometric pressure BME280 0x76, 0x77 Temperature, barometric pressure and humidity BME680 0x76, 0x77 Temperature, barometric pressure, humidity and air resistance MCP9808 0x18 Temperature INA260 0x40, 0x41, 0x43 Current and Voltage INA219 0x40, 0x41, 0x43 Current and Voltage INA3221 0x42 3-channel Current and Voltage LPS22 0x5D, 0x5C Barometric pressure SHTC3 0x70 Temperature and humidity SHT31 0x44 Temperature and humidity PMSA003I 0x12 Concentration units by size and particle counts by size PMSA003I 0x12 Concentration units by size and particle counts by size DFROBOT_LARK 0x42 Temperatur...
閱讀完整內容