Database Support

jyijyi · March 26, 2021, 7:28am

how about adding the include path -I in .cdef file?
Or you can copy the .h file together with the .c file?

jeremyzhang · March 26, 2021, 7:37am

I never tried so. What does it look like in .cdef?
this is how my .cdef looks:

sources:
{
testsql.c
}

And did you mean copy sqlite.h to testsql.c file?
------------------------update ----------------------------------
fatal error: lib/sqlite3.h: No such file or directory is gone now, but another error pops(something wrong with sqlite.so file I guess?):

(lsh:wp76_r9_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/sqlTest$ mkapp -t wp76 sqlTest.adef -i “$LEGATO_ROOT/third-party/inc/” -L “$LEGATO_ROOT/third-party/lib/sqlite3.so”
** WARNING: Failed to receive sysroot path from compiler ‘gcc --print-sysroot’ (errno: Success).
[1/6] Linking C library
FAILED: _build_sqlTest/wp76/staging/read-only/lib/libComponent_testsqlComp.so
gcc -shared -o _build_sqlTest/wp76/staging/read-only/lib/libComponent_testsqlComp.so _build_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/9e6743bd8c76fa5ac2d847a94fa75154.o _build_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/_componentMain.c.o /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so -L_build_sqlTest/wp76/staging/read-only/lib -Wl,–enable-new-dtags,-rpath=“$ORIGIN/…/lib” “-L$LEGATO_BUILD/framework/lib” -llegato -lpthread -lrt -lm
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: /home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/home/mangoh/Desktop/myWorkspace/leaf-data/wp76_r9_toolchain/wp76-legato/third-party/lib/sqlite3.so: error adding symbols: File in wrong format
collect2: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.

jyijyi · March 26, 2021, 8:24am

can you attach your sqlTest project and 3rd party library here?

rgod · March 26, 2021, 3:42pm

Ok, now I’m getting this error:

/Workspace/mangOH/apps/sqliteApp/_build_sqliteApp/wp77xx/component/c87ee7b719a19be1a70e5dfce1d0b4b1/obj/libComponent_sqliteTest.so: undefined reference to `sqlite3_open’
collect2: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.

jyijyi · March 26, 2021, 4:17pm

Did you compile the sqlite3.so?

rgod · March 26, 2021, 5:10pm

yes I did. Just to clarify, should be compiling the app with the wp77xx toolchain or the wp76 toolchain?

jeremyzhang · March 26, 2021, 10:18pm

that’s something I cannot help so far… I’m stuck too

jyijyi · March 27, 2021, 4:34am

I can compile with attached application.
The makefile of sqlite is using WP76 R9 toolchain.
The legato application is successfully compiled in WP76 R10.1.

testsql.7z (2.8 MB)

jeremyzhang · March 28, 2021, 4:54am

Hi,

I directly used .so file in your attach, but still got this:

(lsh:wp76_r9_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/sqlTest$ mkapp -t wp76 sqlTest.adef -i “third-party/inc” -L “third-party/lib/sqlite3.so”
** WARNING: Failed to receive sysroot path from compiler ‘gcc --print-sysroot’ (errno: Success).
[3/9] Linking C library
FAILED: _build_sqlTest/wp76/staging/read-only/lib/libComponent_testsqlComp.so
gcc -shared -o _build_sqlTest/wp76/staging/read-only/lib/libComponent_testsqlComp.so _build_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/9e6743bd8c76fa5ac2d847a94fa75154.o _build_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/_componentMain.c.o third-party/lib/sqlite3.so -lsqlite3 -L_build_sqlTest/wp76/staging/read-only/lib -Wl,–enable-new-dtags,-rpath=“$ORIGIN/…/lib” “-L$LEGATO_BUILD/framework/lib” -llegato -lpthread -lrt -lm
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/sqlite3.so: Relocations in generic ELF (EM: 40)
third-party/lib/sqlite3.so: error adding symbols: File in wrong format
collect2: error: ld returned 1 exit status
[4/9] Compiling C source
ninja: build stopped: subcommand failed.

jyijyi · March 28, 2021, 5:37am

Are you using my project for legato app?

jeremyzhang · March 28, 2021, 5:42am

I tried with your app also, it produced the same error tho…

jyijyi · March 28, 2021, 5:54am

I am not using third-party/lib/sqlite3.so.
I used libsqlite3.so

Seems you are not using the same as mine

jeremyzhang · March 28, 2021, 5:55am

This is the error produced by your app on my machine:

(lsh:wp76_r9_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/testsql$ mkapp -t wp76 testsql.adef -i “third-party/inc” -L “third-party/lib/libsqlite3.so”
** WARNING: Failed to receive sysroot path from compiler ‘gcc --print-sysroot’ (errno: Success).
[4/9] Linking C library
FAILED: _build_testsql/wp76/staging/read-only/lib/libComponent_testsqlComponent.so
gcc -shared -o _build_testsql/wp76/staging/read-only/lib/libComponent_testsqlComponent.so _build_testsql/wp76/component/8e66693676fcd15060ca87bf2fcf29b4/obj/c06d414e5250101e4956254547f2c639.o _build_testsql/wp76/component/8e66693676fcd15060ca87bf2fcf29b4/obj/_componentMain.c.o third-party/lib/libsqlite3.so -L/home/mangoh/Desktop/myWorkspace/testsql/third-party/lib -lsqlite3 -L_build_testsql/wp76/staging/read-only/lib -Wl,–enable-new-dtags,-rpath=“$ORIGIN/…/lib” “-L$LEGATO_BUILD/framework/lib” -llegato -lpthread -lrt -lm
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
/usr/bin/ld: third-party/lib/libsqlite3.so: Relocations in generic ELF (EM: 40)
third-party/lib/libsqlite3.so: error adding symbols: File in wrong format
collect2: error: ld returned 1 exit status
ninja: build stopped: subcommand failed.

jyijyi · March 28, 2021, 5:58am

Have you done a “make clean”?
Or you need to recompile libsqlite3.so with your wp76 r9 toolchain?

jeremyzhang · March 28, 2021, 6:01am

This is so weird…

(lsh:wp76_r9_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/testsql/third-party/src$ make -f Makefile clean
make: *** No rule to make target ‘clean’. Stop.
(lsh:wp76_r9_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/testsql/third-party/src$ make clean
make: *** No rule to make target ‘clean’. Stop.

I tried recompile libsqlite3.so, it didn’t make a difference…

jyijyi · March 28, 2021, 6:08am

I mean make clean the legato project…
I successfully compile the legato app with developer studio with wp76 r10.1 package, maybe you can try the same.

rgod · March 29, 2021, 4:20pm

I seem to have it working now. Thanks for your help. I’m wondering if there is a way to put an already existing .db file onto the mangoh and access it through sqlite3?

jyijyi · March 30, 2021, 12:10am

I guess you need to bundle the database in .adef.

You can see here on how to open database:

https://zetcode.com/db/sqlitec/

jeremyzhang · March 30, 2021, 5:40am

Did you have it working on wp7702?

I’m still stuck… Can you specify how you did it?

jeremyzhang · March 31, 2021, 12:43am

now I’m getting this…

(lsh:SWI-WP76) ubuntu@ubuntu1804:~/Desktop/myWorkspace/testsql$ mkapp -t wp76xx testsql.adef -i “third-party/inc” -L “third-party/lib/libsqlite3.so”
[5/10] Linking C library
FAILED: _build_testsql/wp76xx/staging/read-only/lib/libComponent_testsqlComponent.so
/home/ubuntu/Desktop/myWorkspace/leaf-data/SWI-WP76/wp76-toolchain/sysroots/x86_64-pokysdk-linux/usr/bin/arm-poky-linux-gnueabi/arm-poky-linux-gnueabi-gcc --sysroot=/home/ubuntu/Desktop/myWorkspace/leaf-data/SWI-WP76/wp76-toolchain/sysroots/armv7a-neon-poky-linux-gnueabi -shared -o _build_testsql/wp76xx/staging/read-only/lib/libComponent_testsqlComponent.so _build_testsql/wp76xx/component/d6489c1101c4ed5fdff50b8faa2fbc1c/obj/87454c5c98951df982e27e716134b07f.o _build_testsql/wp76xx/component/d6489c1101c4ed5fdff50b8faa2fbc1c/obj/_componentMain.c.o third-party/lib/libsqlite3.so -L/home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib -lsqlite3 -L_build_testsql/wp76xx/staging/read-only/lib -Wl,–enable-new-dtags,-rpath=“$ORIGIN/…/lib” “-L$LEGATO_BUILD/framework/lib” -llegato -lpthread -lrt -lm
/home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so:(.rodata+0x24): multiple definition of sqlite3_version' third-party/lib/libsqlite3.so:(.rodata+0x24): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so:(.bss+0x0): multiple definition of sqlite3_temp_directory’
third-party/lib/libsqlite3.so:(.bss+0x0): first defined here
/home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so:(.bss+0x4): multiple definition of sqlite3_data_directory' third-party/lib/libsqlite3.so:(.bss+0x4): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_status64’:
sqlite3.c:(.text+0x1ec): multiple definition of sqlite3_status64' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x1ec): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_mutex_enter’:
sqlite3.c:(.text+0x5120): multiple definition of sqlite3_mutex_enter' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x5120): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_mutex_leave’:
sqlite3.c:(.text+0x51b4): multiple definition of sqlite3_mutex_leave' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x51b4): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_status’:
sqlite3.c:(.text+0x30c): multiple definition of sqlite3_status' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x30c): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_db_status’:
sqlite3.c:(.text+0x4a8): multiple definition of sqlite3_db_status' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x4a8): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_msize’:
sqlite3.c:(.text+0x5fdc): multiple definition of sqlite3_msize' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x5fdc): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_result_error’:
sqlite3.c:(.text+0x47d2c): multiple definition of sqlite3_result_error' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x47d2c): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_stricmp’:
sqlite3.c:(.text+0xbf3c): multiple definition of sqlite3_stricmp' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0xbf3c): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_strnicmp’:
sqlite3.c:(.text+0xc080): multiple definition of sqlite3_strnicmp' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0xc080): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_value_type’:
sqlite3.c:(.text+0x479a4): multiple definition of sqlite3_value_type' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x479a4): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_value_double’:
sqlite3.c:(.text+0x47784): multiple definition of sqlite3_value_double' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x47784): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_value_text’:
sqlite3.c:(.text+0x478f4): multiple definition of sqlite3_value_text' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x478f4): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_value_bytes’:
sqlite3.c:(.text+0x4772c): multiple definition of sqlite3_value_bytes' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x4772c): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_result_double’:
sqlite3.c:(.text+0x47cf8): multiple definition of sqlite3_result_double' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x47cf8): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_snprintf’:
sqlite3.c:(.text+0xa114): multiple definition of sqlite3_snprintf' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0xa114): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_result_text’:
sqlite3.c:(.text+0x47f20): multiple definition of sqlite3_result_text' third-party/lib/libsqlite3.so:sqlite3.c:(.text+0x47f20): first defined here /home/ubuntu/Desktop/myWorkspace/testsql/third-party/lib/libsqlite3.so: In function sqlite3_context_db_handle’:
sqlite3.c:(.text+0x48934): multiple definition of `sqlite3_context_db_handle’
.
.
.
.

Topic		Replies	Views
Config tree on app update mangOH Red	2	705	February 13, 2019
File read and Write in Legato 18.09.0 mangOH Red	5	768	November 2, 2018
mangOH Green sample apps & tutorials Tutorials	18	4694	February 11, 2017
Database write permissions	4	705	October 15, 2018
Missing Type for Config Tree	2	418	June 11, 2021

Database Support

Related topics