本文记录了在使用 Cocos2d-x 构建 Android 项目时遇到的 SQLite 相关符号未定义错误。错误发生在链接阶段，涉及多个 SQLite 函数如 sqlite3CodecGetKey 和 sqlite3_key_v2 等。通过分析编译日志，指出了可能的原因在于 SQLite 的加密支持未正确配置或缺失。
Compile++ thumb : cocos2dcpp_shared <= unknown_field_set.cc
Compile++ thumb : cocos2dcpp_shared <= wire_format.cc
Compile++ thumb : cocos2dcpp_shared <= wire_format_lite.cc
SharedLibrary : libcocos2dcpp.so
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3VdbeExec:jni/../../libs.cpp/sqlite3/sqlite3.c:111800: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103074: error: undefined reference to 'sqlite3_key_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103076: error: undefined reference to 'sqlite3_rekey_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103086: error: undefined reference to 'sqlite3_activate_see'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87836: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87838: error: undefined reference to 'sqlite3CodecAttach'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/Classes/DbUtils.o: in function DbUtils::open():jni/../../Classes/DbUtils.cpp:230: error: undefined reference to 'sqlite3_key'
collect2: ld returned 1 exit status
make: *** [obj/local/armeabi/libcocos2dcpp.so] Error 1
make: Leaving directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
sogas-Mac-mini:~ soga$ /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/build_native.sh
NDK_ROOT = /Users/soga/Downloads/android-ndk-r8e
COCOS2DX_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/../../..
APP_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/..
APP_ANDROID_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android
Using prebuilt externals
make: Entering directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
Compile thumb : cocos2dcpp_shared <= sqlite3.c
cc1: warning: command line option '-Wno-conversion-null' is valid for C++/ObjC++ but not for C [enabled by default]
SharedLibrary : libcocos2dcpp.so
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3VdbeExec:jni/../../libs.cpp/sqlite3/sqlite3.c:111803: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103077: error: undefined reference to 'sqlite3_key_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103079: error: undefined reference to 'sqlite3_rekey_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103089: error: undefined reference to 'sqlite3_activate_see'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87839: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87841: error: undefined reference to 'sqlite3CodecAttach'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/Classes/DbUtils.o: in function DbUtils::open():jni/../../Classes/DbUtils.cpp:230: error: undefined reference to 'sqlite3_key'
collect2: ld returned 1 exit status
make: *** [obj/local/armeabi/libcocos2dcpp.so] Error 1
make: Leaving directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
Compile++ thumb : cocos2dcpp_shared <= wire_format.cc
Compile++ thumb : cocos2dcpp_shared <= wire_format_lite.cc
SharedLibrary : libcocos2dcpp.so
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3VdbeExec:jni/../../libs.cpp/sqlite3/sqlite3.c:111800: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103074: error: undefined reference to 'sqlite3_key_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103076: error: undefined reference to 'sqlite3_rekey_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103086: error: undefined reference to 'sqlite3_activate_see'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87836: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87838: error: undefined reference to 'sqlite3CodecAttach'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/Classes/DbUtils.o: in function DbUtils::open():jni/../../Classes/DbUtils.cpp:230: error: undefined reference to 'sqlite3_key'
collect2: ld returned 1 exit status
make: *** [obj/local/armeabi/libcocos2dcpp.so] Error 1
make: Leaving directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
sogas-Mac-mini:~ soga$ /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/build_native.sh
NDK_ROOT = /Users/soga/Downloads/android-ndk-r8e
COCOS2DX_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/../../..
APP_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android/..
APP_ANDROID_ROOT = /Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android
Using prebuilt externals
make: Entering directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
Compile thumb : cocos2dcpp_shared <= sqlite3.c
cc1: warning: command line option '-Wno-conversion-null' is valid for C++/ObjC++ but not for C [enabled by default]
SharedLibrary : libcocos2dcpp.so
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3VdbeExec:jni/../../libs.cpp/sqlite3/sqlite3.c:111803: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103077: error: undefined reference to 'sqlite3_key_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103079: error: undefined reference to 'sqlite3_rekey_v2'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function sqlite3Pragma:jni/../../libs.cpp/sqlite3/sqlite3.c:103089: error: undefined reference to 'sqlite3_activate_see'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87839: error: undefined reference to 'sqlite3CodecGetKey'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/libs.cpp/sqlite3/sqlite3.o: in function attachFunc:jni/../../libs.cpp/sqlite3/sqlite3.c:87841: error: undefined reference to 'sqlite3CodecAttach'
/Users/soga/Downloads/android-ndk-r8e/toolchains/arm-linux-androideabi-4.6/prebuilt/darwin-x86_64/bin/../lib/gcc/arm-linux-androideabi/4.6/../../../../arm-linux-androideabi/bin/ld: ./obj/local/armeabi/objs/cocos2dcpp_shared/__/__/Classes/DbUtils.o: in function DbUtils::open():jni/../../Classes/DbUtils.cpp:230: error: undefined reference to 'sqlite3_key'
collect2: ld returned 1 exit status
make: *** [obj/local/armeabi/libcocos2dcpp.so] Error 1
make: Leaving directory `/Users/soga/Desktop/cocos2d-x-2.2.3/projects/CatchMonkey/proj.android'
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
