Qt 5.13.0 - Build postgres driver for android

NickV · wrote on 19 Jul 2019, 06:47

Hello, i would like to build the postgres driver for android. Does anyone knows the way that i can do that? When i was used qt 5.9.6 i have followed the following instructions: https://wiki.qt.io/Build_Qt_5_PostgreSQL_Plugin_for_Android

This instructions not work in Qt 5.13.0. Any suggestions?

NickV · wrote on 19 Jul 2019, 07:07

When i am doing the steps of the https://wiki.qt.io/Build_Qt_5_PostgreSQL_Plugin_for_Android i am getting the following error:
Project ERROR: Library 'psql' is not defined.

SGaist · wrote on 19 Jul 2019, 14:06

Hi,

The build instructions have changed. See the Qt documentation for that and adapt the guide to them.

NickV · 22 Jul 2019, 10:05

WIth this instructions i am getting the following error:

android-ndk-r19c/toolchains/arm-linux-androideabi-4.9/prebuilt/linux-x86_64/lib/gcc/arm-linux-androideabi/4.9.x/../../../../arm-linux-androideabi/bin/ld: error: /usr/lib/x86_64-linux-gnu/libpq.so: incompatible target

Any idea?

jsulm · N NickV 22 Jul 2019, 07:59

@NickV said in Qt 5.13.0 - Build postgres driver for android:

/usr/lib/x86_64-linux-gnu/libpq.so

This lib was built for x86_64, not ARM. You need this lib in your sysroot for ARM.

NickV · wrote on 22 Jul 2019, 14:07

Is there a way to build postgres from source for arm?
Any instructions will be perfect!

SGaist · wrote on 22 Jul 2019, 19:10

It's explained in the Wiki page you are using as reference.

NickV · 23 Jul 2019, 06:59

When i follow these instruction the libpq.so that produced is not for arm architecture but for x86_64. Maybe there is a problem with the ndk. I don't know for sure.

jsulm · N NickV 23 Jul 2019, 06:55

@NickV This sounds like you're building for x86_64. Can you show the steps you're executing to build it?

NickV · 23 Jul 2019, 07:20

@jsulm
export ANDROID_NDK_ROOT="/<path-to-ndk>/android-ndk-r15c"
SR="$ANDROID_NDK_ROOT/platforms/android-21/arch-arm"
BR="$ANDROID_NDK_ROOT/toolchains/arm-linux-androideabi-4.9/prebuilt/linux-x86_64/bin/arm-linux-androideabi-"

and then cd to postgres folder
STRIP="$BR"strip RANLIB="$BR"ranlib OBJDUMP="$BR"objdump AR="$BR"ar CC="$BR"gcc CFLAGS=--sysroot=$SR CPP="$BR"cpp CPPFLAGS=$CFLAGS ./configure --prefix=$SR/usr --host=arm-linux-androideabi --target=arm-linux-androideabi --build="$CHOST" --without-readline --with-openssl --with-includes=/<path-to-openssl>/openssl-1.0.2n/include --with-libs=/<path-to-openssl>/openssl-1.0.2n

sed -e 's/lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION).$(SO_MINOR_VERSION)/lib$(NAME)$(DLSUFFIX)/g' -i src/Makefile.shlib
sed -e 's/lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION)/lib$(NAME)$(DLSUFFIX)/g' -i src/Makefile.shlib

make -C src/interfaces/libpq

WIth this instructions i made it to create a libpq.so form arm architecture but it is for 32bit not for 64bit. If i use android ndk r18b then the libpq.so that produced is for x86_64 architecture.

jsulm · N NickV 23 Jul 2019, 07:12

@NickV How do you build with r18b?

NickV · wrote on 23 Jul 2019, 07:20

@jsulm
I am doing exactly the same thing but i use
export ANDROID_NDK_ROOT="/<path-to-ndk>/android-ndk-r18b"

SGaist · wrote on 24 Jul 2019, 19:46

Since you are building for 5.13 you should change to NDK r19 at least.

NickV · wrote on 25 Jul 2019, 06:27

@SGaist
I've also tried with android ndk r19c. Still having problems.

NickV · 25 Jul 2019, 11:16

Does postgres supports android 64 bit cpu architectures?

jsulm · N NickV 25 Jul 2019, 11:13

@NickV This is something you should ask postgres developers

SGaist · wrote on 26 Jul 2019, 18:58

It should be since it's available on Debian for arm64. However there might be a flag to set somewhere.

Nogood · 13 Apr 2021, 15:25

Hi, has anyone managed to put together a psql android plugin for qt qml app? My application is not connecting to postgres database on another machine.

SGaist · 23 Apr 2021, 09:20

@Nogood said in Qt 5.13.0 - Build postgres driver for android:

Hi, has anyone managed to put together a psql android plugin for qt qml app? My application is not connecting to postgres database on another machine.

Hi and welcome to devnet,

Did you follow the guide @NickV used ?
If not, what did you do ?
If you did, what error message do you get ?
Also, are you sure you can access that database remotely from another computer ?
Did you start your application with the QT_DEBUG_PLUGINS environment variable set to 1 in order to have more information ?

Nogood · S SGaist 13 Apr 2021, 15:25

@SGaist said in Qt 5.13.0 - Build postgres driver for android:

guide

Yes, i used guide. But I didn't find the arm-linux-androideabi-gcc file.

everything is fine with the database, the program works well on windows.