Thursday, July 19, 2018

Problem installing mysql-python on Windows 10 (x64)

I tried to install mysql-python using 'pip' from the scripts directory of Python 37.


PipMysql_0

I got the following error failing to compile:
------------
C:\Users\Owner\AppData\Local\Programs\Python\Python37\Scripts>pip3.7 install mysql-python
Collecting mysql-python
  Downloading https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip (108kB)
    100% |████████████████████████████████| 112kB 595kB/s
Installing collected packages: mysql-python
  Running setup.py install for mysql-pythonerror
    Complete output from command c:\users\owner\appdata\local\programs\python\python37\python.exe -u -c "import setuptools, tokenize;__file__='C:\\Users\\Owner\\AppData\\Local\\Temp\\pip-install-mp58q1_3\\mysql-python\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\Owner\AppData\Local\Temp\pip-record-f1y77nfx\install-record.txt --single-version-externally-managed --compile:
    running install
    running build
    running build_py
    creating build
    creating build\lib.win-amd64-3.7
    copying _mysql_exceptions.py -> build\lib.win-amd64-3.7
    creating build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\__init__.py -> build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\converters.py -> build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\connections.py -> build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\cursors.py -> build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\release.py -> build\lib.win-amd64-3.7\MySQLdb
    copying MySQLdb\times.py -> build\lib.win-amd64-3.7\MySQLdb
    creating build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.7\MySQLdb\constants
    running build_ext
    building '_mysql' extension
    creating build\temp.win-amd64-3.7
    creating build\temp.win-amd64-3.7\Release
    C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\bin\HostX86\x64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" -Ic:\users\owner\appdata\local\programs\python\python37\include -Ic:\users\owner\appdata\local\programs\python\python37\include "-IC:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\include" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\winrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.17134.0\cppwinrt" /Tc_mysql.c /Fobuild\temp.win-amd64-3.7\Release\_mysql.obj /Zl
    _mysql.c
    _mysql.c(42): fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory
    error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.14.26428\\bin\\HostX86\\x64\\cl.exe' failed with exit status 2
-----------------------------
I followed up on this suggestion (http://www.voidcn.com/article/p-qxepvobu-bt.html) to install a file downloaded from the indicated site:

MySQL_python-1.2.5-cp27-none-win_amd64.whl

I again tried pip install with this downloaded file. It failed with the following:


It appears that the versions are so many, to get a proper set is not easy. This is one thing I find with Open Source software often.

Monday, July 16, 2018

Art Show by Tomita's students in Honolulu - July 15 to August 26, 2018

Come and participate in the Water Color exhibition (Art Show) by students of Honolulu artist, Tom Tomita. All the exhibits are creations of his students.




Make yourself free on July 22 between 5:00 pm to 7:pm to attend the reception. The works will be on exhibit from July 15 to August 26.

Here is the location of the exhibits: The Honolulu Country Club Gallery


The Country Club building:


Follow this link to know more about Tom:

Wednesday, July 11, 2018

Stay productive tips and Windows 10 Pro Insider Preview

Recently this build was applied to my computer and it did take quite bit of time. I am not sure how much change it made to my resources.


Microsoft Edge has been enhanced. There are lots of great stuff and the productivity tips are many. There is nice web page that explains each of the following with gifs (may be):

Here is a list of the productivity related new items:
     
One click to fill forms
Mark up PDFs and e-books
Reading made easier

Print what matters

Browse on your phone and continue on your PC
Mute tabs
Have the web read out loud to you
Read e-books in the browser
Translate websites instantly--Download Translation Extension
Customize with extensions
Use your touchpad like a touchscreen
 I liked this one
Swipe to go back or forward
Keyboard shortcuts
Get notifications from websites
Use mouse gestures to close tabs and more
Earn rewards for using Microsoft Edge
Save money with Cortana
Get instant answers as you search
Read without distractions
Write on the web
Add notes to sites
Clip and share anything
 Clipped image has unknown format, cannot be opened  
Cast your content
 Does not discover the TV
Browse longer without a charge
Get helpful tips from Cortana
Ask Cortana anything
Save creative ideas from around the web with Pinterest
Instant access to all your Office files  -- You need an extension
Get a Focused inbox with Outlook.com

You may think that productivity has increased, but actually it has decreased because the computer has become very sluggish. I tried to check out the above and I had browser freezing up, or printer menu not coming up; the Cast to devices not showing and many more.

DMCA.com Protection Status