# Database Support **URL:** \ **Category:** Uncategorized\ **Created:** [June 2, 2016, 6:29am UTC](https://mangoh.discourse.group/t/database-support/93 "2016-06-02T06:29:02Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 23, 2021, 7:24am UTC](https://mangoh.discourse.group/t/database-support/93/42 "2021-03-23T07:24:16Z")
then you can try the WP76 R9 toolchain when the website is available later. I don’t see problem with that toolchain. ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 5:05am UTC](https://mangoh.discourse.group/t/database-support/93/44 "2021-03-24T05:05:30Z")
I think I have installed wp76 R9 toolchain, ![image](https://us1.discourse-cdn.com/flex016/uploads/mangoh/original/2X/7/70ad4e529c51668a5c0fc7a2bc60bf2b236a1965.png) but in /opt/swi, nothing was added same as [Database Support - #29 by jeremyzhang](https://mangoh.discourse.group/t/database-support/93/29) ![image](https://us1.discourse-cdn.com/flex016/uploads/mangoh/original/2X/6/6c30a802afe9ea79b058af30358fa23a41b6b0fa.png) ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 24, 2021, 5:21am UTC](https://mangoh.discourse.group/t/database-support/93/45 "2021-03-24T05:21:34Z")
it is installed in the leaf folder… ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 5:41am UTC](https://mangoh.discourse.group/t/database-support/93/46 "2021-03-24T05:41:12Z")
I’m new to Legato. I’m confused now… so what are installed in this /opt/swi folder? ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 24, 2021, 5:52am UTC](https://mangoh.discourse.group/t/database-support/93/47 "2021-03-24T05:52:11Z")
You need to run the script .sh in the toolchain, and then it will be install in /opt/swi ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 5:59am UTC](https://mangoh.discourse.group/t/database-support/93/48 "2021-03-24T05:59:39Z")
Did you mean that **toolChainExtractor.sh** script? ![image](https://us1.discourse-cdn.com/flex016/uploads/mangoh/original/2X/0/0338db18880c59d5c683480ac4df156dd0469166.png) ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 24, 2021, 6:21am UTC](https://mangoh.discourse.group/t/database-support/93/49 "2021-03-24T06:21:31Z")
Yes, you can run it… ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 6:36am UTC](https://mangoh.discourse.group/t/database-support/93/50 "2021-03-24T06:36:47Z")
this is what i got while executing the shell script: > Poky (Yocto Project Reference Distro) SDK installer version 2.2.3 > / ================================================================= > Enter target directory for SDK (default: /opt/swi/y22-ext): > You are about to install the SDK to “/opt/swi/y22-ext”. Proceed[Y/n]? Y > Extracting SDK…tail: error writing ‘standard output’: Broken pipe > done > Setting it up…done > Makefile:662: Cannot use CONFIG\_CC\_STACKPROTECTOR\_REGULAR: -fstack-protector not supported by compiler > HOSTCC scripts/basic/fixdep > HOSTCC scripts/basic/bin2c > HOSTCC scripts/kconfig/conf.o > SHIPPED scripts/kconfig/zconf.tab.c > SHIPPED scripts/kconfig/zconf.lex.c > SHIPPED scripts/kconfig/zconf.hash.c > HOSTCC scripts/kconfig/zconf.tab.o > HOSTLD scripts/kconfig/conf > scripts/kconfig/conf --silentoldconfig Kconfig > drivers/soc/qcom/Kconfig:368:warning: choice value used outside its choice group > drivers/soc/qcom/Kconfig:373:warning: choice value used outside its choice group > warning: (SND\_SOC\_QDSP6V2) selects SND\_SOC\_MSM\_QDSP6V2\_INTF which has unmet direct dependencies (SOUND && !M68K && !UML && SND && SND\_SOC && MSM\_QDSP6\_APRV2) > warning: (SND\_SOC\_QDSP6V2) selects SND\_SOC\_MSM\_QDSP6V2\_INTF which has unmet direct dependencies (SOUND && !M68K && !UML && SND && SND\_SOC && MSM\_QDSP6\_APRV2) > > \*\*\* Error during update of the configuration. > > scripts/kconfig/Makefile:36: recipe for target ‘silentoldconfig’ failed > make[2]: \*\*\* [silentoldconfig] Error 1 > Makefile:546: recipe for target ‘silentoldconfig’ failed > make[1]: \*\*\* [silentoldconfig] Error 2 > make: \*\*\* No rule to make target ‘include/config/auto.conf’, needed by ‘scripts’. Stop. > SDK has been successfully set up and is ready to be used. > Each time you wish to use the SDK in a new shell session, you need to source the environment setup script e.g. > $ . /opt/swi/y22-ext/environment-setup-armv7a-neon-poky-linux-gnueabi ----------------------------------------------------UPDATE----------------------------------- the errors were gone if I sudo .sh script ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 7:35am UTC](https://mangoh.discourse.group/t/database-support/93/52 "2021-03-24T07:35:13Z")
> (lsh:wp76\_r9\_toolchain) mangoh@mangoh-vm:~/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain$ sudo wp76-toolchain/toolChainExtractor.sh > Poky (Yocto Project Reference Distro) SDK installer version 2.2.3 > -================================================================= > Enter target directory for SDK (default: /opt/swi/y22-ext): > The directory “/opt/swi/y22-ext” already contains a SDK for this architecture. > If you continue, existing files will be overwritten! Proceed[y/N]? y > Extracting SDK…tail: error writing ‘standard output’: Broken pipe > done > Setting it up…done > HOSTCC scripts/kconfig/conf.o > HOSTLD scripts/kconfig/conf > scripts/kconfig/conf --silentoldconfig Kconfig > drivers/soc/qcom/Kconfig:368:warning: choice value used outside its choice group > drivers/soc/qcom/Kconfig:373:warning: choice value used outside its choice group > warning: (SND\_SOC\_QDSP6V2) selects SND\_SOC\_MSM\_QDSP6V2\_INTF which has unmet direct dependencies (SOUND && !M68K && !UML && SND && SND\_SOC && MSM\_QDSP6\_APRV2) > warning: (SND\_SOC\_QDSP6V2) selects SND\_SOC\_MSM\_QDSP6V2\_INTF which has unmet direct dependencies (SOUND && !M68K && !UML && SND && SND\_SOC && MSM\_QDSP6\_APRV2) > HOSTCC scripts/dtc/dtc.o > HOSTCC scripts/dtc/flattree.o > HOSTCC scripts/dtc/fstree.o > HOSTCC scripts/dtc/data.o > HOSTCC scripts/dtc/livetree.o > HOSTCC scripts/dtc/treesource.o > HOSTCC scripts/dtc/srcpos.o > HOSTCC scripts/dtc/checks.o > HOSTCC scripts/dtc/util.o > SHIPPED scripts/dtc/dtc-lexer.lex.c > SHIPPED scripts/dtc/dtc-parser.tab.h > HOSTCC scripts/dtc/dtc-lexer.lex.o > SHIPPED scripts/dtc/dtc-parser.tab.c > HOSTCC scripts/dtc/dtc-parser.tab.o > HOSTLD scripts/dtc/dtc > CC scripts/mod/empty.o > HOSTCC scripts/mod/mk\_elfconfig > MKELF scripts/mod/elfconfig.h > HOSTCC scripts/mod/modpost.o > CC scripts/mod/devicetable-offsets.s > GEN scripts/mod/devicetable-offsets.h > HOSTCC scripts/mod/file2alias.o > HOSTCC scripts/mod/sumversion.o > HOSTLD scripts/mod/modpost > HOSTCC scripts/kallsyms > HOSTCC scripts/conmakehash > HOSTCC scripts/sortextable > SDK has been successfully set up and is ready to be used. > Each time you wish to use the SDK in a new shell session, you need to source the environment setup script e.g. I think sqlite has been set up in my Legato, hasn’t it? ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 24, 2021, 7:54am UTC](https://mangoh.discourse.group/t/database-support/93/53 "2021-03-24T07:54:50Z")
you just install the WP76 R9 toolchain only ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 24, 2021, 8:14am UTC](https://mangoh.discourse.group/t/database-support/93/54 "2021-03-24T08:14:02Z")
Just tried wp76 r9 to set up sqlite. now the previous error is gone 👍 ---
**Author:** ![rgod](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@rgod](https://mangoh.discourse.group/u/rgod)\ **Post date:** [March 25, 2021, 5:02pm UTC](https://mangoh.discourse.group/t/database-support/93/55 "2021-03-25T17:02:57Z")
I am also getting this error when trying to make the Makefile and create the sqlite3.so. ![Screenshot from 2021-03-25 13-00-39](https://us1.discourse-cdn.com/flex016/uploads/mangoh/original/2X/a/a1c227e61c250fa5e62faf47b50fd30feb48d44b.png) I have changed “y22-ext” to “y25-ext” because that appears to be all I have. ![Screenshot from 2021-03-25 13-02-28](https://us1.discourse-cdn.com/flex016/uploads/mangoh/original/2X/a/aab71692976e8fa5f4983b2ff1e3401def0bb7c9.png) Any insight would be appreciated. ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 25, 2021, 11:10pm UTC](https://mangoh.discourse.group/t/database-support/93/56 "2021-03-25T23:10:41Z")
You can use wp76 r9 toolchain to compile sqlite ---
**Author:** ![rgod](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@rgod](https://mangoh.discourse.group/u/rgod)\ **Post date:** [March 25, 2021, 11:24pm UTC](https://mangoh.discourse.group/t/database-support/93/57 "2021-03-25T23:24:04Z")
Ok, even though I’m using a wp7702 chip? Also, how would I do that and is it possible while the Sierra wireless site is down? Thanks for your help. ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 26, 2021, 12:03am UTC](https://mangoh.discourse.group/t/database-support/93/58 "2021-03-26T00:03:56Z")
You can use leaf to download, please see above > [@Database Support](https://mangoh.discourse.group/t/database-support/93/41): > > the same error was produced: ---
**Author:** ![rgod](https://avatars.discourse-cdn.com/v4/letter/r/f14d63/32.png) [@rgod](https://mangoh.discourse.group/u/rgod)\ **Post date:** [March 26, 2021, 1:36am UTC](https://mangoh.discourse.group/t/database-support/93/59 "2021-03-26T01:36:59Z")
Ok, I’ll try I couple things tomorrow. The post above doesn’t really provide a solution, unless I’m missing something. ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 26, 2021, 6:27am UTC](https://mangoh.discourse.group/t/database-support/93/60 "2021-03-26T06:27:26Z")
Now I’m getting this error, do you think it is because I used wp76 r9 to compile sqlite, and it doesn’t work on wp7702? that /home/mangoh/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain/wp76-legato/build/ is the wp76 r9 toolchain directory… > (lsh:p1\_red77) mangoh@mangoh-vm:~/Desktop/myWorkspace/sqlTest$ mkapp -t wp77 sqlTest.adef -i “$LEGATO\_ROOT/third-party/inc” -L “$LEGATO\_ROOT/third-party/sqlite/lib/sqlite3.so” > ninja: error: ‘/home/mangoh/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain/wp76-legato/build/wp77/framework/lib/liblegato.so’, needed by ‘\_build\_sqlTest/wp77/staging/read-only/lib/libComponent\_testsqlComp.so’, missing and no known rule to make it ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 26, 2021, 6:35am UTC](https://mangoh.discourse.group/t/database-support/93/61 "2021-03-26T06:35:46Z")
You can simply `leaf search`, and pick any one of these(the one I picked is 1.6.0): > │ swi-wp76\_1.0.0 │ SDK for WP76 (Release 9 + Legato 18.03.0) > │ swi-wp76\_1.2.0 │ SDK for WP76 (Release 9 + Legato 18.05.0) > │ swi-wp76\_1.2.1 │ SDK for WP76 (Release 9 + Legato 18.05.1) > │ swi-wp76\_1.3.0 │ SDK for WP76 (Release 9 + Legato 18.06.0) > │ swi-wp76\_1.3.1 │ SDK for WP76 (Release 9 + Legato 18.06.1) > │ swi-wp76\_1.3.2 │ SDK for WP76 (Release 9 + Legato 18.06.2) > │ swi-wp76\_1.3.3 │ SDK for WP76 (Release 9 + Legato 18.06.3) > │ swi-wp76\_1.4.0 │ SDK for WP76 (Release 9 + Legato 18.07.0) > │ swi-wp76\_1.4.2 │ SDK for WP76 (Release 9 + Legato 18.07.1) > │ swi-wp76\_1.5.0 │ SDK for WP76 (Release 9 + Legato 18.08.0) > │ swi-wp76\_1.6.0 │ SDK for WP76 (Release 9 + Legato 18.09.0) use `leaf setup` to install, after the installation is completed, go to the dir where you installed it, and compile the `toolChainExtractor.sh` file. Once the .sh script executed, go to /opt/swi, you will find y22-ext was added. then update the makefile in third-party/sqlite/src/Makefile, change `/opt/swi/y17-ext/sysroots/x86_64-pokysdk-linux/usr/bin/arm-poky-linux-gnueabi` to `/opt/swi/y22-ext/sysroots/x86_64-pokysdk-linux/usr/bin/arm-poky-linux-gnueabi`. ---
**Author:** ![jyijyi](https://sea2.discourse-cdn.com/flex016/user_avatar/mangoh.discourse.group/jyijyi/32/997_2.png) [@jyijyi](https://mangoh.discourse.group/u/jyijyi)\ **Post date:** [March 26, 2021, 6:40am UTC](https://mangoh.discourse.group/t/database-support/93/62 "2021-03-26T06:40:36Z")
then does it work to compile for WP76 module? I think you used the wrong setup, when you compile for WP77, why it still know the path of /home/mangoh/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain/ ---
**Author:** ![jeremyzhang](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jeremyzhang](https://mangoh.discourse.group/u/jeremyzhang)\ **Post date:** [March 26, 2021, 6:53am UTC](https://mangoh.discourse.group/t/database-support/93/63 "2021-03-26T06:53:55Z")
That’s actually the thing I’m confused about… Should I delete profiles and try to reinstall them? And this is what I got while compiling for WP76: > (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/7] Compiling C source > FAILED: \_build\_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/9e6743bd8c76fa5ac2d847a94fa75154.o > gcc -MMD -MF \_build\_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/9e6743bd8c76fa5ac2d847a94fa75154.o.d -c /home/mangoh/Desktop/myWorkspace/sqlTest/testsqlComp/testsql.c -o \_build\_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/obj/9e6743bd8c76fa5ac2d847a94fa75154.o -DLE\_FILENAME=`basename /home/mangoh/Desktop/myWorkspace/sqlTest/testsqlComp/testsql.c` -Wall -fPIC -Werror -fvisibility=hidden -DMK\_TOOLS\_BUILD -DLEGATO\_EMBEDDED -I ./\_build\_sqlTest/wp76 -I/home/mangoh/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain/wp76-legato/interfaces -I/home/mangoh/Desktop/myWorkspace/leaf-data/wp76\_r9\_toolchain/wp76-legato/framework/include -I/home/mangoh/Desktop/myWorkspace/sqlTest -I./\_build\_sqlTest/wp76/component/e2fbebc6625ee95f1e4f2e1aff635082/src -DLE\_COMPONENT\_NAME=testsqlComp -DLE\_LOG\_SESSION=testsqlComp\_LogSession -DLE\_LOG\_LEVEL\_FILTER\_PTR=testsqlComp\_LogLevelFilterPtr “-DCOMPONENT\_INIT=LE\_CI\_LINKAGE LE\_SHARED void \_testsqlComp\_COMPONENT\_INIT()” > /home/mangoh/Desktop/myWorkspace/sqlTest/testsqlComp/testsql.c:1:9: fatal error: lib/sqlite3.h: No such file or directory > #include\ > ^ ~~~~~~~~~~~~~~ > compilation terminated. > ninja: build stopped: subcommand failed. I tried #include “sqlite3.h”/#include “inc/sqlite3.h”, all returned same error. [Previous page](https://mangoh.discourse.group/t/database-support/93.md?page=2) [Next page](https://mangoh.discourse.group/t/database-support/93.md?page=4)