MobileRead Forums - View Single Post - Kobo standalone? (never want to connect to Kobo, or activate)

frostschutz · 02-02-2015, 08:37 PM

Since I just had the opportunity redoing this after a firmware reset...

First time turning on, you have to select your language, then select "no wifi available" (or some such), then it asks you to connect the PC. That gives you access to the USB storage, and the .kobo/KoboReader.sqlite

At this point there is actually already an entry in the users table. You have to get rid of it and insert your own. Just inserting does not (always) work.

The user table:

Code:

$ sqlite3 KoboReader.sqlite 
SQLite version 3.8.8.1 2015-01-20 16:51:25
Enter ".help" for usage hints.
sqlite> .schema user
CREATE TABLE user(UserID TEXT NOT NULL,UserKey TEXT NOT NULL,UserDisplayName TEXT,UserEmail TEXT,___DeviceID TEXT,FacebookAuthToken TEXT,HasMadePurchase BIT DEFAULT FALSE, IsOneStoreAccount BIT DEFAULT FALSE, IsChildAccount BIT DEFAULT FALSE,PRIMARY KEY (UserID));

The existing entry:

Code:

sqlite> select * from user;
00665c32-6e8a-4b3d-84b2-4df0173419d3|494cf778-af9d-407e-a37d-26d8b4565dae|demobundle06_13@kobo.com|demobundle06_13@kobo.com|||false|true|false

Get rid of it and insert your own. It can be entirely empty:

Code:

sqlite> delete from user;
sqlite> insert into user values ('','','','','','','','','');
sqlite> .quit

Unmount / eject the device properly. It should go into the main menu. Clicking 'sync' should ask for wifi network data and update the device; or you can put the firmware KoboRoot.tgz into the .kobo folder to update offline like. Just make sure you use the correct firmware for your reader.

02-02-2015, 08:37 PM	#60
frostschutz Linux User Posts: 2,282 Karma: 6123806 Join Date: Sep 2010 Location: Heidelberg, Germany Device: none	Since I just had the opportunity redoing this after a firmware reset... First time turning on, you have to select your language, then select "no wifi available" (or some such), then it asks you to connect the PC. That gives you access to the USB storage, and the .kobo/KoboReader.sqlite At this point there is actually already an entry in the users table. You have to get rid of it and insert your own. Just inserting does not (always) work. The user table: Code: $ sqlite3 KoboReader.sqlite SQLite version 3.8.8.1 2015-01-20 16:51:25 Enter ".help" for usage hints. sqlite> .schema user CREATE TABLE user(UserID TEXT NOT NULL,UserKey TEXT NOT NULL,UserDisplayName TEXT,UserEmail TEXT,___DeviceID TEXT,FacebookAuthToken TEXT,HasMadePurchase BIT DEFAULT FALSE, IsOneStoreAccount BIT DEFAULT FALSE, IsChildAccount BIT DEFAULT FALSE,PRIMARY KEY (UserID)); The existing entry: Code: sqlite> select * from user; 00665c32-6e8a-4b3d-84b2-4df0173419d3\|494cf778-af9d-407e-a37d-26d8b4565dae\|demobundle06_13@kobo.com\|demobundle06_13@kobo.com\|\|\|false\|true\|false Get rid of it and insert your own. It can be entirely empty: Code: sqlite> delete from user; sqlite> insert into user values ('','','','','','','','',''); sqlite> .quit Unmount / eject the device properly. It should go into the main menu. Clicking 'sync' should ask for wifi network data and update the device; or you can put the firmware KoboRoot.tgz into the .kobo folder to update offline like. Just make sure you use the correct firmware for your reader.