Mobileread
Kobo standalone? (never want to connect to Kobo, or activate)
#71  PurpleStar 01-14-2017, 10:36 AM
Quote frostschutz
I'd also like to add, that with this empty user setup, a Kobo sync not only won't work, it also won't abort, which means as long as the sync is running, the wifi will be always on. I'm abusing this property when I need to work with telnet on the Kobo.

On the other hand, if for some reason the "automatic sync" feature is enabled, you will wake up with your Kobo's battery mysteriously drained. That's because even when the device looks like it's in standby, it's still attempting to sync and the wifi eats the battery within a few short hours.
I turned off wi-fi and automatic sync is off and my Kobo still drained overnight.
Reply 

#72  very_rude_Turnip 01-14-2017, 10:48 AM
Quote PurpleStar
I turned off wi-fi and automatic sync is off and my Kobo still drained overnight.
Same thing happened me a day or two ago after upgrading the to the newest OS. It seems to be okay today though. Might have been a one-off problem, or maybe this registration workaround has caused some bug that eats CPU. Will let you know if it happens again.

Note that I have my wifi configured off, and physically disabled on the board, so I don't think that had anything to do with it.
Reply 

#73  pluma 01-28-2017, 03:33 PM
kobo firmware 3.20 reference.

What would it be the fields to set given the following:

Code
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,
IsC$ildAccount BIT DEFAULT FALSE,
RefreshToken TEXT,
AuthToken TEXT,
AuthType TEXT,
Loyalty BLOB,
IsLibraryMigrated BIT NOT NULL DEFAULT true,
SyncContinuationToken TEXT,
Subscription INT NOT NULL DEFAULT 0,
PRIMARY $EY (UserID));
Where would it go the fancyful email address here while keeping everything else empty?

thanks
Reply 

#74  kido.resuri 01-28-2017, 03:41 PM
The above is just the creation of the table. You need to INSERT or UPDATE.

Why would you keep the email address while the others are empty?

Anyhow, you would need an sqlite query something like this:

INSERT INTO "user" VALUES('','','','put.your@email.here','','','','', '','','','','','','','');
Reply 

#75  davidfor 01-28-2017, 07:29 PM
Quote pluma
kobo firmware 3.20 reference.
Any reason for using 3.20? I can think of a lot of reasons for not using it, but none for choosing it specifically.
Reply 

#76  pluma 01-29-2017, 06:53 AM
Quote kido.resuri
The above is just the creation of the table. You need to INSERT or UPDATE.

Why would you keep the email address while the others are empty?

Anyhow, you would need an sqlite query something like this:

INSERT INTO "user" VALUES('','','','put.your@email.here','','','','', '','','','','','','','');

Yes do know is the original fields, the thing is that I did the inserting by trial and error so I pasted the original table for help. I am not a sqlite haxxor, I only copy paste :/

Quote
Any reason for using 3.20? I can think of a lot of reasons for not using it, but none for choosing it specifically.
That's the recovery firmware version after hard reset. I updated afterwards.

danke for your concerns
Reply 

#77  PeterT 01-29-2017, 11:05 AM
I wonder if it would be more release independent to use the other form of the INSERT statement, ie

INSERT INTO "user" (<list of columns>) VALUES(<list of values>)

This has the benefit of being independent of schema changes.

Sent from my Nexus 7 using Tapatalk
Reply 

#78  dragon788 09-15-2017, 03:17 PM
As the number of columns and their names may change over time as probably noted in this thread, it is a bit of a pain to do the registration "hack" to fill them all out.

While looking to do this from my Linux machine I installed `sqliteman` as its description offered a GUI for administrating and developing for SQLite databases.

EDIT: Use method outlined further down
One of the features I hadn't counted on was being able to right click on the "users" table and choose "populate" from the list and having the tool automatically craft a query to insert data to fill all the columns. I didn't have to modify anything and could just click "Insert" and after ejecting and unplugging (I chose register with desktop to start), it complained about the data format, but bypassed the registration screen and put me at the "Home" screen.

I may play around with it a bit and see if not choosing "autonumber" for the user column avoids the error, but this is probably the easiest way to describe to a non-technical user without creating a data map that might get outdated with every update.

EDIT:

Upon further testing having random data in all the fields was bad, but adding a new row defaults everything to <null> and then only editing the first two fields that have "NOT NULL" constraints, iirc UserName and UserKey, and "committing" the changes (you get prompted to do so if you just attempt to close sqliteman with changes) resolved the error after I unmounted and unplugged and didn't require any further messing around with the database.
Reply 

#79  u238110 02-03-2018, 08:38 PM
This is the 'user' table for the Kobo I just bought (firmware 4.7.10.413). Should anything be left alone to prevent messing up the device? Also, the fourth post in this thread states that one also needs to downgrade to firmware 1.9.16 in order for this hack to work. Is that true?

Quote rashkae
The new firmware will not accept new books until it's registered.
47665.png 
Reply 

#80  _twoflower_ 11-26-2019, 09:56 PM
Has anybody had success doing this with a Libra? Got to the homepage successfully after editing KoboReader.sqlite users, but can't view the My Books page.
Reply 

 « First  « Prev   (8/8)
Today's Posts | Search this Thread | Login | Register