Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Install sqlite3 to mysql in CentOS 7.6.1810x86_64 (Py3.7.9) #41

Closed
anzhiyu-c opened this issue Apr 14, 2022 · 6 comments
Closed

Install sqlite3 to mysql in CentOS 7.6.1810x86_64 (Py3.7.9) #41

anzhiyu-c opened this issue Apr 14, 2022 · 6 comments
Assignees
@techouse
Labels
need more info

Comments

@anzhiyu-c
Copy link

I tried to install it in server CentOS 7.6.1810x86_64 (Py3.7.9), but it seems not to be able to install, and I am disconnected from the server
@anzhiyu-c anzhiyu-c added the bug Something isn't working label Apr 14, 2022
@techouse
Copy link
Owner

Hi,

Can you provide more info? Please fill out the bug report template.

@techouse techouse removed the bug Something isn't working label Apr 14, 2022
@anzhiyu-c
Copy link
Author

I guess my PIP version is too low

@anzhiyu-c
Copy link
Author

anzhiyu-c commented Apr 14, 2022 •
edited

Hi, this is my installation error log. I understand that there seems to be a problem with the dependency of backports-datetime-fromisoformat. I found a report on this.
Installing backports-datetime-fromisoformat on Python 2 doesn't work
I am using the python3 installation
I executed the yum install python-devel.

Looking in indexes: https://pypi.doubanio.com/simple
Collecting sqlite3-to-mysql
  Using cached https://pypi.doubanio.com/packages/26/9b/eab8bde9039481af1f36029bc678f1be0c2bd663b1097fc292ba4f8e057f/sqlite3_to_mysql-1.4.15-py2.py3-none-any.whl (18 kB)
Requirement already satisfied: tabulate in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (0.8.9)
Collecting backports-datetime-fromisoformat>=1.0.0
  Downloading https://pypi.doubanio.com/packages/20/15/4bc39da78d00da480ff627398ad25770be1f0c3cf40ea9bc5e9030b441fb/backports-datetime-fromisoformat-1.0.0.tar.gz (10 kB)
  Preparing metadata (setup.py) ... done
Requirement already satisfied: tqdm>=4.35.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (4.64.0)
Requirement already satisfied: pytimeparse>=1.1.8 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.1.8)
Requirement already satisfied: mysql-connector-python>=8.0.18 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.28)
Requirement already satisfied: Unidecode>=1.2.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.3.4)
Requirement already satisfied: Click>=7.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.4)
Requirement already satisfied: simplejson>=3.16.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (3.17.6)
Requirement already satisfied: packaging>=20.3 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (21.3)
Requirement already satisfied: six>=1.12.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.16.0)
Requirement already satisfied: importlib-metadata in /usr/local/lib/python3.6/site-packages (from Click>=7.0->sqlite3-to-mysql) (4.8.3)
Requirement already satisfied: protobuf>=3.0.0 in /usr/local/lib64/python3.6/site-packages (from mysql-connector-python>=8.0.18->sqlite3-to-mysql) (3.19.4)
Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /usr/local/lib/python3.6/site-packages (from packaging>=20.3->sqlite3-to-mysql) (3.0.8)
Requirement already satisfied: importlib-resources in /usr/local/lib/python3.6/site-packages (from tqdm>=4.35.0->sqlite3-to-mysql) (5.4.0)
Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (4.1.1)
Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (3.6.0)
Building wheels for collected packages: backports-datetime-fromisoformat
  Building wheel for backports-datetime-fromisoformat (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-izi5im4d
       cwd: /tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/
  Complete output (20 lines):
  running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.linux-x86_64-3.6
  creating build/lib.linux-x86_64-3.6/backports
  copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
  creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
  copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
  running build_ext
  building 'backports._datetime_fromisoformat' extension
  creating build/temp.linux-x86_64-3.6
  creating build/temp.linux-x86_64-3.6/backports
  creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
  gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
  backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
   #include <Python.h>
                      ^
  编译中断。
  error: command 'gcc' failed with exit status 1
  ----------------------------------------
  ERROR: Failed building wheel for backports-datetime-fromisoformat
  Running setup.py clean for backports-datetime-fromisoformat
Failed to build backports-datetime-fromisoformat
Installing collected packages: backports-datetime-fromisoformat, sqlite3-to-mysql
    Running setup.py install for backports-datetime-fromisoformat ... error
    ERROR: Command errored out with exit status 1:
     command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-6wcqf8o_/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat
         cwd: /tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/
    Complete output (20 lines):
    running install
    running build
    running build_py
    creating build
    creating build/lib.linux-x86_64-3.6
    creating build/lib.linux-x86_64-3.6/backports
    copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
    creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
    copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
    running build_ext
    building 'backports._datetime_fromisoformat' extension
    creating build/temp.linux-x86_64-3.6
    creating build/temp.linux-x86_64-3.6/backports
    creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
    gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
    backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
     #include <Python.h>
                        ^
    编译中断。
    error: command 'gcc' failed with exit status 1
    ----------------------------------------
ERROR: Command errored out with exit status 1: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-5939n180/backports-datetime-fromisoformat_d69c81f9d5914d229ab82b8c5f24f7fb/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-6wcqf8o_/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat Check the logs for full command output.

Hi,

Can you provide more info? Please fill out the bug report template.

@techouse
Copy link
Owner

techouse commented Apr 14, 2022 •
edited

What Python version are you on? That package only installs on Python 3.4, 3.5 and 3.6. From the title of the issue, I gathered you're on 3.7.9 but it looks like you're on 3.6.x?

https://github.com/techouse/sqlite3-to-mysql/blob/master/setup.py#L24

@anzhiyu-c
Copy link
Author

Sorry, there are two versions at the same time, but I installed it with version 3.6.8 of python.

Here is my complete run command, because I have two versions of python, so I used python3 -m pip😭

[root@czw ~]# python3 -m pip install sqlite3-to-mysql
Looking in indexes: https://pypi.doubanio.com/simple
Collecting sqlite3-to-mysql
  Using cached https://pypi.doubanio.com/packages/26/9b/eab8bde9039481af1f36029bc678f1be0c2bd663b1097fc292ba4f8e057f/sqlite3_to_mysql-1.4.15-py2.py3-none-any.whl (18 kB)
Requirement already satisfied: tqdm>=4.35.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (4.64.0)
Requirement already satisfied: Unidecode>=1.2.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.3.4)
Collecting backports-datetime-fromisoformat>=1.0.0
  Downloading https://pypi.doubanio.com/packages/20/15/4bc39da78d00da480ff627398ad25770be1f0c3cf40ea9bc5e9030b441fb/backports-datetime-fromisoformat-1.0.0.tar.gz (10 kB)
  Preparing metadata (setup.py) ... done
Requirement already satisfied: Click>=7.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.4)
Requirement already satisfied: simplejson>=3.16.0 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (3.17.6)
Requirement already satisfied: six>=1.12.0 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.16.0)
Requirement already satisfied: tabulate in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (0.8.9)
Requirement already satisfied: mysql-connector-python>=8.0.18 in /usr/local/lib64/python3.6/site-packages (from sqlite3-to-mysql) (8.0.28)
Requirement already satisfied: pytimeparse>=1.1.8 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (1.1.8)
Requirement already satisfied: packaging>=20.3 in /usr/local/lib/python3.6/site-packages (from sqlite3-to-mysql) (21.3)
Requirement already satisfied: importlib-metadata in /usr/local/lib/python3.6/site-packages (from Click>=7.0->sqlite3-to-mysql) (4.8.3)
Requirement already satisfied: protobuf>=3.0.0 in /usr/local/lib64/python3.6/site-packages (from mysql-connector-python>=8.0.18->sqlite3-to-mysql) (3.19.4)
Requirement already satisfied: pyparsing!=3.0.5,>=2.0.2 in /usr/local/lib/python3.6/site-packages (from packaging>=20.3->sqlite3-to-mysql) (3.0.8)
Requirement already satisfied: importlib-resources in /usr/local/lib/python3.6/site-packages (from tqdm>=4.35.0->sqlite3-to-mysql) (5.4.0)
Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (3.6.0)
Requirement already satisfied: typing-extensions>=3.6.4 in /usr/local/lib/python3.6/site-packages (from importlib-metadata->Click>=7.0->sqlite3-to-mysql) (4.1.1)
Building wheels for collected packages: backports-datetime-fromisoformat
  Building wheel for backports-datetime-fromisoformat (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' bdist_wheel -d /tmp/pip-wheel-2m2glxuo
       cwd: /tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/
  Complete output (20 lines):
  running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.linux-x86_64-3.6
  creating build/lib.linux-x86_64-3.6/backports
  copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
  creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
  copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
  running build_ext
  building 'backports._datetime_fromisoformat' extension
  creating build/temp.linux-x86_64-3.6
  creating build/temp.linux-x86_64-3.6/backports
  creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
  gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
  backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
   #include <Python.h>
                      ^
  编译中断。
  error: command 'gcc' failed with exit status 1
  ----------------------------------------
  ERROR: Failed building wheel for backports-datetime-fromisoformat
  Running setup.py clean for backports-datetime-fromisoformat
Failed to build backports-datetime-fromisoformat
Installing collected packages: backports-datetime-fromisoformat, sqlite3-to-mysql
    Running setup.py install for backports-datetime-fromisoformat ... error
    ERROR: Command errored out with exit status 1:
     command: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-jb5_vlvf/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat
         cwd: /tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/
    Complete output (20 lines):
    running install
    running build
    running build_py
    creating build
    creating build/lib.linux-x86_64-3.6
    creating build/lib.linux-x86_64-3.6/backports
    copying backports/__init__.py -> build/lib.linux-x86_64-3.6/backports
    creating build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
    copying backports/datetime_fromisoformat/__init__.py -> build/lib.linux-x86_64-3.6/backports/datetime_fromisoformat
    running build_ext
    building 'backports._datetime_fromisoformat' extension
    creating build/temp.linux-x86_64-3.6
    creating build/temp.linux-x86_64-3.6/backports
    creating build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat
    gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -I/usr/include/python3.6m -c backports/datetime_fromisoformat/module.c -o build/temp.linux-x86_64-3.6/backports/datetime_fromisoformat/module.o
    backports/datetime_fromisoformat/module.c:1:20: 致命错误：Python.h：没有那个文件或目录
     #include <Python.h>
                        ^
    编译中断。
    error: command 'gcc' failed with exit status 1
    ----------------------------------------
ERROR: Command errored out with exit status 1: /usr/bin/python3 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"'; __file__='"'"'/tmp/pip-install-ph1c9213/backports-datetime-fromisoformat_6ecb3bab59d04b5dab7ba26e8c79201f/setup.py'"'"';f = getattr(tokenize, '"'"'open'"'"', open)(__file__) if os.path.exists(__file__) else io.StringIO('"'"'from setuptools import setup; setup()'"'"');code = f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-jb5_vlvf/install-record.txt --single-version-externally-managed --compile --install-headers /usr/local/include/python3.6m/backports-datetime-fromisoformat Check the logs for full command output.
[root@czw ~]#

@anzhiyu-c
Copy link
Author

python3 -m pip install sqlite3-to-mysql
Sorry to bother you, but I found a solution. I reported this error because I couldn't find Python.h, and I have two versions of python. I should execute it on python3.
Yum install python3-devel is then installed successfully. Sorry, please close this issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@techouse techouse

Labels
need more info
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@techouse @anzhiyu-c