Closed Bouchra994 closed 10 months ago
From https://pypi.org/project/psycopg2/
Psycopg 2 is mostly implemented in C as a libpq wrapper,
The C needs to be compiled for ARM. psycopg2-binary only supports Linux/OSX/Windows https://pypi.org/project/psycopg2-binary/
Specifying the uncompiled psycopg2 and the compiled psycopg2-binary in requirements is probably not helpful.
p4a has a recipe mechanism for compiling non pure Python packages, a list of implemented packages is here: https://github.com/kivy/python-for-android/tree/develop/pythonforandroid/recipes
The alternatives are finding a pure Python package, or building a recipe https://python-for-android.readthedocs.io/en/latest/recipes/
Not a bug I think.
I didn't realised the psycopg2-binary
was used there, thanks for the heads-up.
@Bouchra994 could you try without and try from clean build (buildozer android clean
)?
Hi thank u for reply for the psycopg2 - Binary I have already test without it but still the same error
I think this is the expected result with psycopg2 (psycopg2-binary contains nothing useful) The compile for ARM is not occuring because there is no ARM compile recipe; so the symbol "PQencryptPasswordConn" is not found.
Thank u but what is the Arm and what do u think I should do
ARM is a processor architecture, the C code must be compiled to generate binaries for the instruction set of a particular processor architecture (usually ARM or derivatives of intel's x86). Android uses ARM, desktops use Intel based (Apple's announcement aside).
What you should do depends on your needs, not a question I can answer.
As I stated previously the options I know of are: 1) an existing recipe, 2) find a pure Python package, 3) write a recipe.
If you have to ask about ARM, I'd suggest that 3) might be a a challenge. If 2) exists (see below) and if the speed is sufficient then this would be the easiest. And for 1) I don't know if the available recipes meet your need or what app changes would be required.
A quick Google search returns a starting point: https://wiki.postgresql.org/wiki/Python
What do you mean @Ham-Merhead? We do have a recipe for https://github.com/kivy/python-for-android/blob/v2020.06.02/pythonforandroid/recipes/psycopg2/__init__.py right? So the question to be is with the recipe is not compiling/linking libqa properly https://github.com/kivy/python-for-android/blob/v2020.06.02/pythonforandroid/recipes/libpq/__init__.py
My error about the existence of the recipe, so yes it looks like a bug. Workaround is still the same, use pure Python.
thank u but please what do u mean by using pure python
pure Python - the code is python and no other language.
In the exemple I used just python I didn't even use kivy
From https://pypi.org/project/psycopg2/
Psycopg 2 is mostly implemented in C as a libpq wrapper,
So the app is not pure Python
The app code may be pure Python, but psycopg2 is not pure Python and the app uses psycopg2. Which is why we talk about compiling C with a recipe. This is what appears to be failing in this case. A pure Python alternative works around this issue (assuming it does work!, and it is fast enough) by replacing psycopg2 with something else.
As I said previously: A quick Google search returns a starting point: https://wiki.postgresql.org/wiki/Python Look at the "Platforms" column.
If you want to debug the current configuration, simplify the .spec buy removing unnecessary requirements and don't forget thebuildozer appclean
.
Read the log_level=2 build log carefully (every line), there may be a hint in there.
I just noticed this is the "develop" branch of p4a https://github.com/kivy/python-for-android/tree/develop/pythonforandroid/recipes/psycopg2
Yes we got some recent runtime fixes in "develop"
It might be worth giving a try @Bouchra994 change to p4a.branch = develop
and do a clean buildozer android clean
and a rebuild to see
alternatively you could use this pure-python package for to connect to your postgres database: https://github.com/tlocke/pg8000
Am So., 28. Juni 2020 um 09:46 Uhr schrieb Andre Miras < notifications@github.com>:
Yes we got some recent runtime fixes in "develop"
2245 https://github.com/kivy/python-for-android/pull/2245
2246 https://github.com/kivy/python-for-android/pull/2246
It might be worth giving a try @Bouchra994 https://github.com/Bouchra994 change to p4a.branch = develop and do a clean buildozer android clean and a rebuild to see
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/kivy/python-for-android/issues/2240#issuecomment-650719380, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA4U63RIOHHYIXWDEKKWTZLRY37PFANCNFSM4OE6CXAA .
i fix the error by changing the p4a.branch =develop thank u for you all but i have an other error related to the postgres connection because im using localhost
06-28 15:26:12.014 26978 27082 I python : psycopg2.OperationalError: could not connect to server: Connection refused 06-28 15:26:12.014 26978 27082 I python : Is the server running on host "0.0.0.0" and accepting 06-28 15:26:12.014 26978 27082 I python : TCP/IP connections on port 5432? 06-28 15:26:12.014 26978 27082 I python :
please have you any idea about that
Is the database server on your PC where you developed the app? The app needs to know that IP address. Or the app needs INTERNET permission, Or the server is only configured for localhost Or if the server is expected to be on the phone, it was not started (no idea about that).
https://groups.google.com/g/kivy-users is more suited to general programming questions.
👋 We use the issue tracker exclusively for bug reports and feature requests. However, this issue appears to be a support request. Please use our support channels to get help with the project.
If you're having trouble installing or using python-for-android, maybe you could be interested in our quickstart guide.
Let us know if this comment was made in error, and we'll be happy to reopen the issue.
im working with psycopg2 to connect my app with posstgres data base it work good in laptop but when i try to deloy it crach in time of importing psycopg2
print("before psycopg2") import psycopg2
print("after psycopg2")
Versions
Description
// REPLACE ME: i want to know why does that happen
Spec file:
--------- beginning of crash --------- beginning of system --------- beginning of main 06-22 18:48:14.474 9178 9396 I python : Initializing Python for Android 06-22 18:48:14.474 9178 9396 I python : Setting additional env vars from p4a_env_vars.txt 06-22 18:48:14.474 9178 9396 I python : Changing directory to the one provided by ANDROID_ARGUMENT 06-22 18:48:14.474 9178 9396 I python : /data/user/0/org.test.myapp/files/app 06-22 18:48:14.474 9178 9396 I python : Preparing to initialize python 06-22 18:48:14.474 9178 9396 I python : _python_bundle dir exists 06-22 18:48:14.474 9178 9396 I python : calculated paths to be... 06-22 18:48:14.474 9178 9396 I python : /data/user/0/org.test.myapp/files/app/_python_bundle/stdlib.zip:/data/user/0/org.test.myapp/files/app/_python_bundle/modules 06-22 18:48:14.475 9178 9396 I python : set wchar paths... 06-22 18:48:14.561 9178 9396 I python : Initialized python 06-22 18:48:14.561 9178 9396 I python : AND: Init threads 06-22 18:48:14.563 9178 9396 I python : testing python print redirection 06-22 18:48:14.564 9178 9396 I python : Android path ['.', '/data/user/0/org.test.myapp/files/app/_python_bundle/stdlib.zip', '/data/user/0/org.test.myapp/files/app/_python_bundle/modules', '/data/user/0/org.test.myapp/files/app/_python_bundle/site-packages'] 06-22 18:48:14.565 9178 9396 I python : os.environ is environ({'PATH': '/sbin:/system/sbin:/system/bin:/system/xbin:/odm/bin:/vendor/bin:/vendor/xbin', 'DOWNLOAD_CACHE': '/data/cache', 'ANDROID_BOOTLOGO': '1', 'ANDROID_ROOT': '/system', 'ANDROID_ASSETS': '/system/app', 'ANDROID_DATA': '/data', 'ANDROID_STORAGE': '', 'EXTERNAL_STORAGE': '/sdcard', 'ASEC_MOUNTPOINT': '/mnt/asec', 'BOOTCLASSPATH': '/system/framework/core-oj.jar:/system/framework/core-libart.jar:/system/framework/conscrypt.jar:/system/framework/okhttp.jar:/system/framework/bouncycastle.jar:/system/framework/apache-xml.jar:/system/framework/ext.jar:/system/framework/framework.jar:/system/framework/telephony-common.jar:/system/framework/voip-common.jar:/system/framework/ims-common.jar:/system/framework/android.hidl.base-V1.0-java.jar:/system/framework/android.hidl.manager-V1.0-java.jar:/system/framework/framework-oahl-backward-compatibility.jar:/system/framework/android.test.base.jar:/system/framework/featurelayer-widget.jar:/system/framework/hwEmui.jar:/system/framework/hwTelephony-common.jar:/system/framework/hwIms-common.jar:/system/framework/hwframework.jar:/system/framework/com.huawei.nfc.jar:/system/framework/org.ifaa.android.manager.jar:/system/framework/hwperf.jar:/system/framework/hwaps.jar:/system/framework/hwcustEmui.jar:/system/framework/hwcustframework.jar:/system/framework/hwcustTelephony-common.jar:/system/framework/servicehost.jar:/system/framework/hwIAwareAL.jar', 'SYSTEMSERVERCLASSPATH': '/system/framework/services.jar:/system/framework/ethernet-service.jar:/system/framework/wifi-service.jar:/system/framework/com.android.location.provider.jar:/system/framework/hwServices.jar:/system/framework/hwWifi-service.jar:/system/framework/hwcustServices.jar:/system/framework/hwcustwifi-service.jar', 'OEM_ROOT': '/product/hw_oem/JKM-L21', 'ODM_PRODUCT': '/odm/hw_odm/JKM-L21', 'CUST_POLICY_DIRS': '/system/emui/base:/system/emui/oversea:/system/emui/lite:/vendor/etc:/odm/etc:/product/etc:/odm/hw_odm/JKM-L21:/product/region_comm/oversea:/preas/oversea:/product/hw_oem/JKM-L21:/preload/JKM-L21/hw/meafnaf:/cust/global:/cust/hw/meafnaf:/product/special_cust/JKM-L21/hw/meafnaf', 'ANDROID_SOCKET_zygote_secondary': '18', 'ANDROID_ENTRYPOINT': 'main.pyc', 'ANDROID_ARGUMENT': '/data/user/0/org.test.myapp/files/app', 'ANDROID_APP_PATH': '/data/user/0/org.test.myapp/files/app', 'ANDROID_PRIVATE': '/data/user/0/org.test.myapp/files', 'ANDROID_UNPACK': '/data/user/0/org.test.myapp/files/app', 'PYTHONHOME': '/data/user/0/org.test.myapp/files/app', 'PYTHONPATH': '/data/user/0/org.test.myapp/files/app:/data/user/0/org.test.myapp/files/app/lib', 'PYTHONOPTIMIZE': '2', 'P4A_BOOTSTRAP': 'SDL2', 'PYTHON_NAME': 'python', 'P4A_IS_WINDOWED': 'True', 'P4A_ORIENTATION': 'portrait', 'P4A_NUMERIC_VERSION': 'None', 'P4A_MINSDK': '21', 'LC_CTYPE': 'C.UTF-8'}) 06-22 18:48:14.565 9178 9396 I python : Android kivy bootstrap done. name is main 06-22 18:48:14.565 9178 9396 I python : AND: Ran string 06-22 18:48:14.565 9178 9396 I python : Run user program, change dir and execute entrypoint 06-22 18:48:14.565 9178 9396 I python : before psycopg2 06-22 18:48:14.568 9178 9396 I python : Traceback (most recent call last): 06-22 18:48:14.568 9178 9396 I python : File "/mnt/c/users/lenovo/desktop/login/.buildozer/android/app/main.py", line 4, in
06-22 18:48:14.568 9178 9396 I python : File "/mnt/c/users/lenovo/desktop/login/.buildozer/android/platform/build-armeabi-v7a/build/python-installs/myapp/psycopg2/init.py", line 50, in
06-22 18:48:14.568 9178 9396 I python : ImportError: dlopen failed: cannot locate symbol "PQencryptPasswordConn" referenced by "/data/data/org.test.myapp/files/app/_python_bundle/site-packages/psycopg2/_psycopg.so"...
06-22 18:48:14.568 9178 9396 I python : Python for android ended.