Unsolved Can You Help me Please , MySQL + Android on Qt
-
I have now an other problems
When a try to make the mysql.pro i have this error ,
15:31:46: Exécution des étapes pour le projet mysql... 15:31:46: Débute : "C:\Qt\5.10.1\mingw53_32\bin\qmake.exe" C:\Qt\5.10.1\Src\qtbase\src\plugins\sqldrivers\mysql\mysql.pro -spec win32-g++ Project ERROR: Library 'mysql' is not defined. 15:31:46: Le processus "C:\Qt\5.10.1\mingw53_32\bin\qmake.exe" s'est terminé avec le code 3. Erreur lors de la compilation/déploiement du projet mysql (kit : Desktop Qt 5.10.1 MinGW 32bit) When executing step "qmake" 15:31:46: Temps écoulé : 00:00.
-
The procedure has changed since at least 5.10. See the corresponding chapter in Qt's documentation.
-
Thx for you answer but didnt works same problems and i think that my libmariadb.so is corrupted or didnt work cause if i link this librairie in the program the apk crash .
-
Are you trying to use your Android built MariaDB to build the MinGW plugin ?
-
yes , i try the App on NoSql DB mode dont work too but its appear that i havent got root permission for Database how can i fixe it
-
You can't use libraries built for Android with MinGW.
NoSQL is a complete different paradigm. How is that related to your current problem ?
-
@SGaist No related just try another method for validate 99% of my app . I return on MySQL so i build with on armeabi-v7a with libqsqlmysql.so for android . the app crash
D/Zygote (23930): CtrlSocket libc.so ctrl_sockets_set_addr pfunc is not exist! I/ (23930): power log dlsym ok I/ActivityManager( 1264): Start proc 23930:org.qtproject.example.TestMYSQL/u0a131 for activity org.qtproject.example.TestMYSQL/org.qtproject.qt5.android.bindings.QtActivity I/art (23930): Late-enabling -Xcheck:jni D/ActivityThread(23930): ActivityThread,attachApplication D/ActivityManager( 1264): ActivityManagerService,attachApplication,callingPid = 23930 V/ActivityManager( 1264): New app record ProcessRecord{6a964ae 23930:org.qtproject.example.TestMYSQL/u0a131} thread=android.os.BinderProxy@1a3aa12 pid=23930 D/HwCust (23930): Create obj success use class android.content.res.HwCustHwResourcesImpl V/HwPolicyFactory(23930): : success to get AllImpl object and return.... V/ActivityThread(23930): ActivityThread,callActivityOnCreate V/HwWidgetFactory(23930): : successes to get AllImpl object and return.... W/System (23930): ClassLoader referenced unknown path: D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.15, mControlPoint1y = 0.7, mControlPoint2x = 0.2, mControlPoint2y = 0.98 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.6, mControlPoint1y = 0.9, mControlPoint2x = 0.8, mControlPoint2y = 1.0 V/BoostFramework(23930): mAcquireFunc method = public int com.qualcomm.qti.Performance.perfLockAcquire(int,int[]) V/BoostFramework(23930): mReleaseFunc method = public int com.qualcomm.qti.Performance.perfLockRelease() V/BoostFramework(23930): mAcquireTouchFunc method = public int com.qualcomm.qti.Performance.perfLockAcquireTouch(android.view.MotionEvent,android.util.DisplayMetrics,int,int[]) V/BoostFramework(23930): mIOPStart method = public int com.qualcomm.qti.Performance.perfIOPrefetchStart(int,java.lang.String) V/BoostFramework(23930): mIOPStop method = public int com.qualcomm.qti.Performance.perfIOPrefetchStop() V/BoostFramework(23930): BoostFramework() : mPerf = com.qualcomm.qti.Performance@f3abed0 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.15, mControlPoint1y = 0.7, mControlPoint2x = 0.2, mControlPoint2y = 0.98 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.6, mControlPoint1y = 0.9, mControlPoint2x = 0.8, mControlPoint2y = 1.0 V/BoostFramework(23930): BoostFramework() : mPerf = com.qualcomm.qti.Performance@706cec9 I/QtCore (23930): Start W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Gui.so: unused DT entry: type 0x1d arg 0x55c5c W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Gui.so: unsupported flags DT_FLAGS_1=0x81 W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Widgets.so: unused DT entry: type 0x1d arg 0x6d119 W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Widgets.so: unsupported flags DT_FLAGS_1=0x81 W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Sql.so: unused DT entry: type 0x1d arg 0x6286 W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libQt5Sql.so: unsupported flags DT_FLAGS_1=0x81 W/linker (23930): /data/data/org.qtproject.example.TestMYSQL/qt-reserved-files/plugins/platforms/android/libqtforandroid.so: unused DT entry: type 0x1d arg 0x8cd3 W/linker (23930): /data/data/org.qtproject.example.TestMYSQL/qt-reserved-files/plugins/platforms/android/libqtforandroid.so: unsupported flags DT_FLAGS_1=0x81 I/Qt (23930): qt start W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libqsqlmysql.so: unused DT entry: type 0x1d arg 0x15db8 W/linker (23930): /data/app/org.qtproject.example.TestMYSQL-1/lib/arm/libqsqlmysql.so: is missing DT_SONAME will use basename as a replacement: "libqsqlmysql.so" W/System.err(23930): java.lang.reflect.InvocationTargetException W/System.err(23930): at java.lang.reflect.Method.invoke(Native Method) W/System.err(23930): at org.qtproject.qt5.android.bindings.QtLoader.loadApplication(QtLoader.java:241) W/System.err(23930): at org.qtproject.qt5.android.bindings.QtLoader.startApp(QtLoader.java:676) W/System.err(23930): at org.qtproject.qt5.android.bindings.QtActivityLoader.onCreate(QtActivityLoader.java:183) W/System.err(23930): at org.qtproject.qt5.android.bindings.QtActivity.onCreateHook(QtActivity.java:266) W/System.err(23930): at org.qtproject.qt5.android.bindings.QtActivity.onCreate(QtActivity.java:273) W/System.err(23930): at android.app.Activity.performCreate(Activity.java:6367) W/System.err(23930): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1110) W/System.err(23930): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2404) W/System.err(23930): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2511) W/System.err(23930): at android.app.ActivityThread.access$900(ActivityThread.java:165) W/System.err(23930): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1375) W/System.err(23930): at android.os.Handler.dispatchMessage(Handler.java:102) W/System.err(23930): at android.os.Looper.loop(Looper.java:150) W/System.err(23930): at android.app.ActivityThread.main(ActivityThread.java:5621) W/System.err(23930): at java.lang.reflect.Method.invoke(Native Method) W/System.err(23930): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:794) W/System.err(23930): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:684) W/System.err(23930): Caused by: java.lang.UnsatisfiedLinkError: dlopen failed: library "libmariadb.so" not found W/System.err(23930): at java.lang.Runtime.load(Runtime.java:344) W/System.err(23930): at java.lang.System.load(System.java:1079) W/System.err(23930): at org.qtproject.qt5.android.QtNative.loadBundledLibraries(QtNative.java:209) W/System.err(23930): at org.qtproject.qt5.android.QtActivityDelegate.loadApplication(QtActivityDelegate.java:599) W/System.err(23930): ... 18 more D/HwSensorManager(23930): HwSensorManager version: 1.0.0 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.15, mControlPoint1y = 0.7, mControlPoint2x = 0.2, mControlPoint2y = 0.98 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.6, mControlPoint1y = 0.9, mControlPoint2x = 0.8, mControlPoint2y = 1.0 V/BoostFramework(23930): BoostFramework() : mPerf = com.qualcomm.qti.Performance@f4b9283 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.15, mControlPoint1y = 0.7, mControlPoint2x = 0.2, mControlPoint2y = 0.98 D/CubicBezierInterpolator(23930): CubicBezierInterpolator mControlPoint1x = 0.6, mControlPoint1y = 0.9, mControlPoint2x = 0.8, mControlPoint2y = 1.0 V/BoostFramework(23930): BoostFramework() : mPerf = com.qualcomm.qti.Performance@e237c00 I/HwSecImmHelper(23930): mSecurityInputMethodService is null D/OpenGLRenderer(23930): Use EGL_SWAP_BEHAVIOR_PRESERVED: true I/Adreno (23930): QUALCOMM build : d28da0e, Iec24cdb30f I/Adreno (23930): Build Date : 03/10/16 I/Adreno (23930): OpenGL ES Shader Compiler Version: XE031.06.00.05 I/Adreno (23930): Local Branch : I/Adreno (23930): Remote Branch : refs/tags/AU_LINUX_ANDROID_LA.BR.1.2.6_RB1.06.00.01.179.013 I/Adreno (23930): Remote Branch : NONE I/Adreno (23930): Reconstruct Branch : NOTHING I/OpenGLRenderer(23930): Initialized EGL, version 1.4 I/HwSecImmHelper(23930): mSecurityInputMethodService is null V/AudioManager(23930): playSoundEffect effectType: 0 V/AudioManager(23930): querySoundEffectsEnabled...
-
@Lenawel said in Can You Help me Please , MySQL + Android on Qt:
Caused by: java.lang.UnsatisfiedLinkError: dlopen failed: library "libmariadb.so" not found
This is the problem
-
@jsulm said in Can You Help me Please , MySQL + Android on Qt:
his is the problem
thx for your answer , i check a los of time and the library is in the good PATH
-
@Lenawel In which path is it? Don't forget that libmariadb.so is loaded using dlopen().
-
@jsulm thx for answer .
I work a little bit on this problem i pass this problem but have an other one i dont know why this problem appear cause i use only Qt 5.10 and not 5.3 if you want try something i can drop my projectsI/ActivityManager( 412): Start proc 3420:org.qtproject.example/u0a519 for activity org.qtproject.example/org.qtproject.qt5.android.bindings.QtActivity I/art ( 3420): Late-enabling -Xcheck:jni I/QtCore ( 3420): Start W/linker ( 3420): libQt5Gui.so: unused DT entry: type 0x1d arg 0x55c5c W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Widgets.so: unused DT entry: type 0x1d arg 0x6d119 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5PrintSupport.so: unused DT entry: type 0x1d arg 0xb762 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Network.so: unused DT entry: type 0x1d arg 0x13f76 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Qml.so: unused DT entry: type 0x1d arg 0x39f24 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Quick.so: unused DT entry: type 0x1d arg 0x4a9e4 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5QuickParticles.so: unused DT entry: type 0x1d arg 0x55d7 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5QuickWidgets.so: unused DT entry: type 0x1d arg 0x3034 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Multimedia.so: unused DT entry: type 0x1d arg 0x18fab W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5Sql.so: unused DT entry: type 0x1d arg 0x6286 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libQt5MultimediaQuick.so: unused DT entry: type 0x1d arg 0x32a0 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libqtforandroid.so: unused DT entry: type 0x1d arg 0x8cd3 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 I/Qt ( 3420): qt start W/linker ( 3420): libqandroidbearer.so: unused DT entry: type 0x1d arg 0x1711 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libqtmedia_android.so: unused DT entry: type 0x1d arg 0x56f4 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libRegisterVisit.so: unused DT entry: type 0x1d arg 0x2cf2 D/ ( 3420): (null):0 ((null)): QML debugging is enabled. Only use this in a safe environment. D/OpenGLRenderer( 3420): Use EGL_SWAP_BEHAVIOR_PRESERVED: true D/Atlas ( 3420): Validating map... I/OpenGLRenderer( 3420): Initialized EGL, version 1.4 D/OpenGLRenderer( 3420): Enabling debug mode 0 D/mali_winsys( 3420): new_window_surface returns 0x3000 W/linker ( 3420): libqandroidstyle.so: unused DT entry: type 0x1d arg 0x44b9 W/linker ( 3420): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3420): libqsqlmysql.so: unused DT entry: type 0x1d arg 0x15db8 F/libRegisterVisit.so( 3420): (null):0 ((null)): Cannot mix incompatible Qt library (version 0x50302) with this library (version 0x50a01) F/libc ( 3420): Fatal signal 6 (SIGABRT), code -6 in tid 3448 (QtMainThread) I/DEBUG ( 128): pid: 3420, tid: 3448, name: QtMainThread >>> org.qtproject.example <<< I/Zygote ( 136): Process 3420 exited due to signal (6) I/ActivityManager( 412): Process org.qtproject.example (pid 3420) has died "org.qtproject.example" died.
-
@Lenawel Somehow you're mixing two different Qt version, but I don't know how this is happening.
Did you build libqsqlmysql.so by yourself? If so which Qt version did you use? -
@jsulm
no it's my work mate who build it (5.0.3) but i delete libqsqmysql.so and replace it by libmariadb.so that i build myself (5.10.1) : another error .I can drop my project if you want try by yourselfI/art ( 3768): Late-enabling -Xcheck:jni I/ActivityManager( 412): Start proc 3768:org.qtproject.example/u0a519 for activity org.qtproject.example/org.qtproject.qt5.android.bindings.QtActivity I/QtCore ( 3768): Start W/linker ( 3768): libQt5Gui.so: unused DT entry: type 0x1d arg 0x55c5c W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Widgets.so: unused DT entry: type 0x1d arg 0x6d119 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5PrintSupport.so: unused DT entry: type 0x1d arg 0xb762 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Network.so: unused DT entry: type 0x1d arg 0x13f76 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Qml.so: unused DT entry: type 0x1d arg 0x39f24 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Quick.so: unused DT entry: type 0x1d arg 0x4a9e4 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5QuickParticles.so: unused DT entry: type 0x1d arg 0x55d7 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5QuickWidgets.so: unused DT entry: type 0x1d arg 0x3034 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Multimedia.so: unused DT entry: type 0x1d arg 0x18fab W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5Sql.so: unused DT entry: type 0x1d arg 0x6286 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libQt5MultimediaQuick.so: unused DT entry: type 0x1d arg 0x32a0 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqtforandroid.so: unused DT entry: type 0x1d arg 0x8cd3 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 I/Qt ( 3768): qt start W/linker ( 3768): libqandroidbearer.so: unused DT entry: type 0x1d arg 0x1711 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqtmedia_android.so: unused DT entry: type 0x1d arg 0x56f4 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libRegisterVisit.so: unused DT entry: type 0x1d arg 0x2cf2 D/ ( 3768): (null):0 ((null)): QML debugging is enabled. Only use this in a safe environment. D/OpenGLRenderer( 3768): Use EGL_SWAP_BEHAVIOR_PRESERVED: true D/Atlas ( 3768): Validating map... I/OpenGLRenderer( 3768): Initialized EGL, version 1.4 D/OpenGLRenderer( 3768): Enabling debug mode 0 D/mali_winsys( 3768): new_window_surface returns 0x3000 W/linker ( 3768): libqandroidstyle.so: unused DT entry: type 0x1d arg 0x44b9 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/libRegisterVisit.so( 3768): (null):0 ((null)): QSqlDatabase: QMYSQL driver not loaded W/libRegisterVisit.so( 3768): (null):0 ((null)): QSqlDatabase: available drivers: QSQLITE W/linker ( 3768): libqgif.so: unused DT entry: type 0x1d arg 0x7f9 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqicns.so: unused DT entry: type 0x1d arg 0xcc8 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqico.so: unused DT entry: type 0x1d arg 0xaea W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqjpeg.so: unused DT entry: type 0x1d arg 0x1052 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqtga.so: unused DT entry: type 0x1d arg 0x7fc W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqtiff.so: unused DT entry: type 0x1d arg 0xb8a W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqwbmp.so: unused DT entry: type 0x1d arg 0x8f0 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 W/linker ( 3768): libqwebp.so: unused DT entry: type 0x1d arg 0x148c W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81 D/mali_winsys( 3768): new_window_surface returns 0x3000 D/mali_winsys( 3768): new_window_surface returns 0x3000 W/linker ( 3768): libqtaudio_opensles.so: unused DT entry: type 0x1d arg 0x17e0 W/linker ( 3768): Unsupported flags DT_FLAGS_1=0x81
-
@Lenawel said in Can You Help me Please , MySQL + Android on Qt:
libqsqmysql.so and replace it by libmariadb.so
these two are not the same. First one is the Qt plugin to support MySQL, it requires libmariadb.so or libmysql.so to work. If you delete libqsqmysql.so you will not be able to use MySQL.
-
@jsulm said in Can You Help me Please , MySQL + Android on Qt:
And can you tell me How can i make libqsqlmysql.so in 5.10.1 on Windows for Android please ?
-
@Lenawel Sorry, I never built Qt for Android. You should first check whether it is already part of official Qt for Android build.
-
-
Ok i try with this link to compile but i have problems on steps "CompilingMaria"
developpement1@POR-LAG45 /c/AndroidMysql/mariadb-connector-c-3.0.0-alpha-src/build $ PKG_CONFIG_PATH=$SR/usr/lib/pkgconfig cmake -DCMAKE_AR="$BR"ar -DCMAKE_BUILD_TYPE=Release -DCMAKE_C_C OMPILER="$BR"gcc -DCMAKE_C_FLAGS=--sysroot=$SR -DCMAKE_INSTALL_PREFIX=$SR/usr -DCMAKE_LINKER="$BR"ld -D CMAKE_NM="$BR"nm -DCMAKE_OBJCOPY="$BR"objcopy -DCMAKE_OBJDUMP="$BR"objdump -DCMAKE_RANLIB="$BR"ranlib - DCMAKE_STRIP="$BR"strip -DWITH_EXTERNAL_ZLIB=ON -DICONV_INCLUDE_DIR=$SR/usr/include -DICONV_LIBRARIES=$ SR/usr/lib/libiconv.a -DZLIB_INCLUDE_DIR=$SR/usr/include -DZLIB_LIBRARY=$SR/usr/lib/libz.so ../ -- The C compiler identification is GNU 4.8.0 CMake Error at CMakeLists.txt:5 (PROJECT): The CMAKE_C_COMPILER: c:/Qt/android-ndk-r10e/toolchains/arm-linux-androideabi-4.8/prebuilt/windows-x86_64/bin/arm-linux-androideabi-gcc is not a full path to an existing compiler tool. To use the NMake generator with Visual C++, cmake must be run from a shell that can use the compiler cl from the command line. This environment is unable to invoke the cl compiler. To fix this problem, run cmake from the Visual Studio Command Prompt (vcvarsall.bat). Tell CMake where to find the compiler by setting either the environment variable "CC" or the CMake cache entry CMAKE_C_COMPILER to the full path to the compiler, or to the compiler name if it is in the PATH. -- Configuring incomplete, errors occurred! See also "C:/AndroidMysql/mariadb-connector-c-3.0.0-alpha-src/build/CMakeFiles/CMakeOutput.log". See also "C:/AndroidMysql/mariadb-connector-c-3.0.0-alpha-src/build/CMakeFiles/CMakeError.log".
-
Dear Lenawel
I search many times and try many times, fail !
Do you have good new on it?
Best regards,
jeff