MobileRead Forums - View Single Post - Kobo Aura HD - Linux Walkthrough

CatRovacer · 07-05-2016, 09:39 AM

I tried connect Kobo Aura HD to PC (Win7) and use sqlite3

Launch:
sqlite3 KoboReader.sqlite
copypaste in sqlite3 console directives
====

Code:

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

drop  table if exists user;

CREATE TABLE user(UserID TEXT NOT NULL,UserKey TEXT NOT NULL,UserDisplayName TEXT,UserEmail TEXT,___DeviceID TEXT,FacebookAuthToken TEXT,HasMadePurchase BIT DEFAULT FALSE,PRIMARY KEY (UserID));
INSERT INTO "user" VALUES('61df00a6-XXXX-48XX-b349-4367651fcab5','e2015759-a200-42e4-b58c-XXXX','trilogybundle@kobo.com','trilogybundle@kobo .com','11:22:33:44:55:66',NULL,'FALSE');
INSERT INTO "user" VALUES('Linux User','Linux User','LinuxUser@mailinator.com','LinuxUser@mailin ator.com',NULL,NULL,'false');

COMMIT;

.quit
====

After savety reject Kobo storage ereader say:
"Critical Error"

And user table no consist any data.

But possible see pure main sceen. Like on "registered" reader.

I removed the table 'user' because of the fact that the basis of the sample table the user had 13 fields, while the directive INSERT has the values of only for 7 fields.

I tried to fill in the 'user' table with values 'foo'. Without success.

07-05-2016, 09:39 AM	#15
CatRovacer Member Posts: 18 Karma: 10 Join Date: Dec 2015 Location: Moscow Device: Kobo Glo, Touch, Aura HD	I tried connect Kobo Aura HD to PC (Win7) and use sqlite3 Launch: sqlite3 KoboReader.sqlite copypaste in sqlite3 console directives ==== Code: PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; drop table if exists user; CREATE TABLE user(UserID TEXT NOT NULL,UserKey TEXT NOT NULL,UserDisplayName TEXT,UserEmail TEXT,___DeviceID TEXT,FacebookAuthToken TEXT,HasMadePurchase BIT DEFAULT FALSE,PRIMARY KEY (UserID)); INSERT INTO "user" VALUES('61df00a6-XXXX-48XX-b349-4367651fcab5','e2015759-a200-42e4-b58c-XXXX','trilogybundle@kobo.com','trilogybundle@kobo .com','11:22:33:44:55:66',NULL,'FALSE'); INSERT INTO "user" VALUES('Linux User','Linux User','LinuxUser@mailinator.com','LinuxUser@mailin ator.com',NULL,NULL,'false'); COMMIT; .quit ==== After savety reject Kobo storage ereader say: "Critical Error" And user table no consist any data. But possible see pure main sceen. Like on "registered" reader. I removed the table 'user' because of the fact that the basis of the sample table the user had 13 fields, while the directive INSERT has the values of only for 7 fields. I tried to fill in the 'user' table with values 'foo'. Without success.