我在我的Android应用程序数据库中收到此错误.

在sqlite数据库中,我借助此代码从资产文件夹中的脚本获取数据库查询.

manager = context.getResources().getAssets();
            input = manager.open("createDb.xml");
            xpp.setInput(input,null);
            int type = xpp.getEventType();
            while(type != XmlPullParser.END_DOCUMENT) {
                if(type == XmlPullParser.START_DOCUMENT) {

                    Log.d(Tag,"In start document");
                }
                else if(type == XmlPullParser.START_TAG) {
                    Log.d(Tag,"In start tag = "+xpp.getName());
                }
                else if(type == XmlPullParser.END_TAG) {
                    Log.d(Tag,"In end tag = "+xpp.getName());

                }
                else if(type == XmlPullParser.TEXT) {
                    Log.d(Tag,"Have text = "+xpp.getText()); 
                    String strquery = xpp.getText();
                    db.execsql(strquery);
                }
                type = xpp.next();
            }
        } 
        catch (XmlPullParserException e) {
            // Todo Auto-generated catch block
            e.printstacktrace();
        } catch (IOException e) {
            // Todo Auto-generated catch block
            e.printstacktrace();
        }

它的工作正常.

但我在sqlCipher数据库中运行相同的代码,它总是给出这个错误和应用程序崩溃.

即使我已经添加了所有必要的库.

Failure 0 (not an error) on 0x1a1ab0 when executing '
 FATAL EXCEPTION: main
 net.sqlcipher.database.sqliteException: not an error: 
    at net.sqlcipher.database.sqliteDatabase.native_execsql(Native Method)
    at net.sqlcipher.database.sqliteDatabase.execsql(sqliteDatabase.java:1834)
    at com.acs.android.fwk.database.ScriptExecutor.executeScripts(ScriptExecutor.java:86)
    at com.acs.android.fwk.database.DatabaseHelper.onCreate(DatabaseHelper.java:55)
    at net.sqlcipher.database.sqliteOpenHelper.getWritableDatabase(sqliteOpenHelper.java:121)
    at com.acs.android.fwk.database.DatabaseAdapter.open(DatabaseAdapter.java:79)
    at com.acs.android.fwk.database.DatabaseAdapter.dispatchMessage(Handler.java:92)
    at android.os.Looper.loop(Looper.java:137)
    at android.app.ActivityThread.main(ActivityThread.java:4424)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:511)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
    at dalvik.system.NativeStart.main(Native Method)

请帮忙.

Thansk

在你逆向分析**app时,分析分析其数据存储结构绝对是事倍功倍.

下面是我在hook 微信sqlite暗码的分享

知识准备

1：懂的利用xposed框架或Cydia框架hook技术

2 ：jadx工具(定位分析工具)

static public void wechatOpenDatabase(String wechatVersionName,final XC_LoadPackage.LoadPackageParam lpparam) {

/**

*调用生成sqliteDatabase 重要入口

* //主要第3个参数是sqlite的暗码

public static sqliteDatabase openDatabase(String paramString1,LockedDevice paramlockedDevice,String paramString2,Arithmetic paramArithmetic,CursorFactory paramCursorFactory,int paramInt1,DatabaseErrorHandler paramDatabaseErrorHandler,boolean paramBoolean,int paramInt2)

{

sqliteDatabase localsqliteDatabase = new sqliteDatabase(paramString1,paramInt1,paramCursorFactory,paramDatabaseErrorHandler);

localsqliteDatabase.open(paramlockedDevice,paramString2,paramArithmetic,paramBoolean,paramInt2);

return localsqliteDatabase;

}

*/

try {

Class clazzPalue3= null;

if (wechatVersionName.equals("6.3.13.56_r238e8af")){

clazzPalue3 = String.class;

}else {

clazzPalue3 = byte[].class;

}

XposedHelpers.findAndHookMethod(PluginsConfigWechatsqlite.WECHAT_sqliteDatabase_CLASSE,lpparam.classLoader,"openDatabase",

String.class,//sqlite 数据库文件全路径如：/data/data/com.tencent.mm/MicroMsg/71daf7e10a38aa48ee8bad199dde232a/EnMicroMsg.db

lpparam.classLoader.loadClass(PluginsConfigWechatsqlite.WECHAT_sqliteDatabase_CLASSE+"$LockedDevice"),

clazzPalue3,//byte[].class,//String.class,//6.3.13版本string.class6.3.31是byte[].class sqlite数据库的暗码如21e8906

lpparam.classLoader.loadClass(PluginsConfigWechatsqlite.WECHAT_sqliteDatabase_CLASSE+"$Arithmetic"),

lpparam.classLoader.loadClass(PluginsConfigWechatsqlite.WECHAT_sqliteDatabase_CLASSE+"$CursorFactory"),

int.class,

lpparam.classLoader.loadClass(PluginsConfigWechatsqlite.WECHAT_sqliteDatabase_3Level_CLASSE+".DatabaseErrorHandler"),

boolean.class,

new XC_MethodHook() {

@Override

protected void afterHookedMethod(MethodHookParam param) throws Throwable {

super.afterHookedMethod(param);

String strsqliteDatabaseFilePaht= (String) param.args[0];

//if (strsqliteDatabaseFilePaht.endsWith("EnMicroMsg.db") && EnMicroMsgsqliteDatabaSEObject ==null) { //获取EnMicroMsg对应的sqliteDatabase

if (strsqliteDatabaseFilePaht.endsWith("EnMicroMsg.db")) { //获取EnMicroMsg对应的sqliteDatabase

EnMicroMsgsqliteDatabaSEObject = param.getResult();

System.out.println("sqliteDatabaSEObject的类名:"+ EnMicroMsgsqliteDatabaSEObject.getClass().getName());

}

}

@Override

protected void beforeHookedMethod(MethodHookParam param) throws Throwable {

//sqliteDatabase db = sqliteDatabase openDatabase(String path,sqliteDatabase.CursorFactory factory,int flags)

String mm ="";

if (param.args[2] !=null){

String str= param.args[2].getClass().getName();

if (str.equals("[B")){

byte[] mmbytes = (byte[]) param.args[2];

mm = new String(mmbytes,"UTF-8");

}else if (str.equals("java.lang.String")) {

mm =""+param.args[2];

}

}

//Log.i(TAG,"openDatabase String 0参数sqlite全路径和暗码： " +param.args[0]+"参数sqlite暗码：" +param.args[2].toString());

Log.i(TAG,"openDatabase String 0参数sqlite全路径和暗码： " +param.args[0]+"参数sqlite暗码：" +mm);

}

});

} catch (ClassNotFoundException e) {

e.printstacktrace();

}

}

jadx工具分析定位在com.tencent.mmdb.database.sqliteDatabase

启动**发现微信启动时同时打开的数据库有

最后感谢今日头条提供的分享平台,你觉得有用可以收藏便利以后查阅.

分享是一种美德,牵手是一种生活方式.

// 回调函数
	static int sql_callBack(void *notused, int argc, char **argv, char **szColName)  
	{  
		int i = 0;  
		for (i = 0; i < argc; i++)  	
		{  	
			CStringA str;
			//str.Format( "%s = %s\n",Utf8ToAnsi(szColName[i]) ,Utf8ToAnsi(argv[i])); 
			str.Format( "%s = %s\n",szColName[i] ,argv[i]);
			CString str2;
			str2=str;
			AfxMessageBox(str2);
		}  

		return 0;  	
	}  

	// - sk_ArxTestCode20181228.MySql command (do not rename)
	static void sk_ArxTestCode20181228MySql(void)
	{
		// Add your code for command sk_ArxTestCode20181228.MySql here
		const char *sSQL1 = "create table users(name  PRIMARY KEY, age int, score int);";  
		//const char *sSQL2 = GBKToUTF8("insert into users values(''中xxxxx文'', 26, 100);");
		const char *sSQL2 = "insert into users values(''中xxxx文'', 26, 100);"; 
		const char *sSQL3 = "insert into users values(''cainiao'', 5, 1);"; 
		const char *sSQL4 = "select * from users;"; 	

		sqlite3 *pDb = NULL;  
		char *pErrMsg = NULL;  
		const char* szPassword="33554";

		sqlite3_open("taoge.db", &pDb); // 打开数据库

		sqlite3_key( pDb,szPassword,strlen(szPassword));  // 设置密码
		sqlite3_rekey(pDb,NULL,NULL);//清除密码
		//const char* szNewPassword = "33554";
		//sqlite3_rekey(pDb,szNewPassword,strlen(szNewPassword));//重设密码，必须先执行sqlite3_key正确打开数据库

		sqlite3_exec( pDb, sSQL1, NULL, NULL, &pErrMsg);  // 创建基本信息格式
		sqlite3_exec( pDb, sSQL2, NULL, NULL, &pErrMsg);  // 增加信息
		sqlite3_exec( pDb, sSQL3, NULL, NULL, &pErrMsg);  // 增加信息
		sqlite3_exec( pDb, sSQL4, sql_callBack, 0, &pErrMsg); // 查询数据库
		sqlite3_close(pDb);
	}

#include <sqlite3.h>    

int main()
{
    sqlite3 * connection;
    sqlite3_open_v2(":memory:",&connection,sqlITE_OPEN_READWRITE | sqlITE_OPEN_CREATE,NULL);
    sqlite3_key(connection,"passphrase",10);
    sqlite3_close(connection);
}

解决方法