MySQL support for android

[mahmud al hasan]

Does python for android support MySQL?

[dilshad khan]

Yes, if you check the p4a recipes github page. There's a list of all the existing recipes. 

On Fri, 22 Jun 2018, 09:07 mahmud al hasan, <rau...@gmail.com> wrote:

Does python for android support MySQL?

--
You received this message because you are subscribed to the Google Groups "Kivy users support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kivy-users+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[mahmud al hasan]

So there should be no problem if I create an apk which will send data using REST api to my MySQL database?

[dilshad khan]

As long as you have all the requirements you will have no problems. Use the mysqldb library. If you use python 3 then you will have to use the mysqlclient library. 

[dilshad khan]

The mysqlclient github page explains how to install it. 

[mahmud al hasan]

On Friday, June 22, 2018 at 3:07:40 PM UTC+6, dilshad khan wrote:

The mysqlclient github page explains how to install it. 

Getting error when I am trying to install mysqlclient. 

[dilshad khan]

What operating system are you using?

What's the error? 

--

[mahmud al hasan]

On Friday, June 22, 2018 at 5:21:30 PM UTC+6, dilshad khan wrote:

What operating system are you using?

What's the error? 

I am using buildozer VM which I have downloaded from kivy website.

[dilshad khan]

Did you install the development libraries before installing mysqlclient?

What is the error? 

--

[mahmud al hasan]

On Saturday, June 23, 2018 at 5:59:06 AM UTC, mahmud al hasan wrote:

On Saturday, June 23, 2018 at 5:14:23 AM UTC, dilshad khan wrote:

Did you install the development libraries before installing mysqlclient?

What is the error? 

Yes, I have tried to install the libraries before installing mysqlclient.
Here is my error log-

command-

sudo apt-get install python-dev default-libmysqlclient-dev

log-

[sudo] password for kivy:
Reading package lists... Done
Building dependency tree      
Reading state information... Done
The following additional packages will be installed:
  libexpat1-dev libmysqlclient-dev libmysqlclient20 libpython-dev
  libpython2.7-dev mysql-common python2.7-dev
The following NEW packages will be installed:
  default-libmysqlclient-dev libexpat1-dev libmysqlclient-dev libmysqlclient20
  libpython-dev libpython2.7-dev mysql-common python-dev python2.7-dev
0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
Need to get 30.5 MB/30.5 MB of archives.
After this operation, 54.4 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Err:1 http://fr.archive.ubuntu.com/ubuntu zesty-updates/main amd64 libmysqlclient20 amd64 5.7.18-0ubuntu0.17.04.1
  404  Not Found [IP: 194.158.119.186 80]
Ign:2 http://fr.archive.ubuntu.com/ubuntu zesty-updates/main amd64 libmysqlclient-dev amd64 5.7.18-0ubuntu0.17.04.1
Err:3 http://fr.archive.ubuntu.com/ubuntu zesty/main amd64 libexpat1-dev amd64 2.2.0-2
  404  Not Found [IP: 194.158.119.186 80]
Err:4 http://fr.archive.ubuntu.com/ubuntu zesty/main amd64 libpython2.7-dev amd64 2.7.13-2
  404  Not Found [IP: 194.158.119.186 80]
Err:5 http://fr.archive.ubuntu.com/ubuntu zesty/main amd64 libpython-dev amd64 2.7.13-2
  404  Not Found [IP: 194.158.119.186 80]
Err:6 http://fr.archive.ubuntu.com/ubuntu zesty/main amd64 python2.7-dev amd64 2.7.13-2
  404  Not Found [IP: 194.158.119.186 80]
Err:7 http://fr.archive.ubuntu.com/ubuntu zesty/main amd64 python-dev amd64 2.7.13-2
  404  Not Found [IP: 194.158.119.186 80]
Err:1 http://security.ubuntu.com/ubuntu zesty-security/main amd64 libmysqlclient20 amd64 5.7.18-0ubuntu0.17.04.1
  404  Not Found [IP: 194.158.119.186 80]
Err:2 http://security.ubuntu.com/ubuntu zesty-security/main amd64 libmysqlclient-dev amd64 5.7.18-0ubuntu0.17.04.1
  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.7/libmysqlclient20_5.7.18-0ubuntu0.17.04.1_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://security.ubuntu.com/ubuntu/pool/main/m/mysql-5.7/libmysqlclient-dev_5.7.18-0ubuntu0.17.04.1_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://fr.archive.ubuntu.com/ubuntu/pool/main/e/expat/libexpat1-dev_2.2.0-2_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://fr.archive.ubuntu.com/ubuntu/pool/main/p/python2.7/libpython2.7-dev_2.7.13-2_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://fr.archive.ubuntu.com/ubuntu/pool/main/p/python-defaults/libpython-dev_2.7.13-2_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://fr.archive.ubuntu.com/ubuntu/pool/main/p/python2.7/python2.7-dev_2.7.13-2_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Failed to fetch http://fr.archive.ubuntu.com/ubuntu/pool/main/p/python-defaults/python-dev_2.7.13-2_amd64.deb  404  Not Found [IP: 194.158.119.186 80]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

command-

pip install mysqlclient

log-

Collecting mysqlclient
  Cache entry deserialization failed, entry ignored
  Using cached https://files.pythonhosted.org/packages/6f/86/bad31f1c1bb0cc99e88ca2adb7cb5c71f7a6540c1bb001480513de76a931/mysqlclient-1.3.12.tar.gz
    Complete output from command python setup.py egg_info:
    sh: 1: mysql_config: not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-mJLgJ5/mysqlclient/setup.py", line 17, in <module>
        metadata, options = get_config()
      File "setup_posix.py", line 44, in get_config
        libs = mysql_config("libs_r")
      File "setup_posix.py", line 26, in mysql_config
        raise EnvironmentError("%s not found" % (mysql_config.path,))
    EnvironmentError: mysql_config not found
   
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-mJLgJ5/mysqlclient/
You are using pip version 9.0.1, however version 10.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.