Glo Please help. Unable to skip registration on Kobo Glo

limutwit · 07-03-2020, 11:03 AM

Hi

Following the instructions from this forum, I have managed to skip registration on the Clara (it was extremely difficult but I got there in the end) Thank you!

Now I wish to attempt the same on the Kobo Glo.

I followed the command codes from https://www.mobileread.com/forums/sh...d.php?t=171664

I used both

INSERT INTO "user" VALUES('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','xxxx@xxxx.xx','xxxx@xxxx.xx','2aaaa aaaaaaaaaaaaa==');

and also tried

INSERT INTO "user" VALUES('foo','foo','foo','foo','foo');

However, I received the following error
Error: table user has 26 columns but 5 values were supplied

I thought it was because it had the latest 4.22... firmware, so I downgraded to 3.19... but still came up with the same error.

Please advise. Thank you

DNSB · 07-03-2020, 02:11 PM

Why don't you simply register with a self-generated email address. Kobo does not check the address. E.g. koboglo17e@anywheres.net will work.

This has the advantage that you don't have to worry in the future about a firmware update breaking your registration.

PeterT · 07-03-2020, 06:49 PM

One thing I think people forget is that there are two forms of SQL inserts.

Either

Code:

INSERT INTO Customers
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

Or

Code:

INSERT INTO Customers (CustomerName, ContactName)
VALUES ('Cardinal', 'Tom B. Erichsen');

The second method explicitly names the columns being given data and sets the other columns to default values. This means that if the table is changed to have additional columns added the insert will still function.

For instance at one point all one needed was

Code:

INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail)
values("00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000","MyDummyUser@dummy.com","MyDummyUser@dummy.com")

If now additional columns need explicit values they just need to be added to both the list of columns and the value statement

limutwit · 07-03-2020, 10:49 PM

Quote:

Originally Posted by DNSB

Why don't you simply register with a self-generated email address. Kobo does not check the address. E.g. koboglo17e@anywheres.net will work.

This has the advantage that you don't have to worry in the future about a firmware update breaking your registration.

Hi thank you for the reply! Yes, that is my final step once I fail to attempt to do this.

I like this kind of 'mini' challenge to see if I could do.

thanks

PeterT · 07-04-2020, 08:11 PM

As an experiment, I logged out from my Kobo account on one of my devices, let it do the reset and then, when prompted for language selected English and said No to the WiGi. The device then displayed the connect to my desktop and install Kobo Desktop message.

I made sure that neither calibre, ADE or Kobo desktop were lrunning and connected the Kobo to my PC.

I then launched a Sqlite client (in my case DB Browser for SQLite https://sqlitebrowser.org/), opened the Kobo database and did the SQL command I mentioned above

Code:

INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail)
values("00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000","MyDummyUser@dummy.com","MyDummyUser@dummy.com")

When I closed the database and ejected the device it proceeded to import all the sideloaded content I had on the kobo.

limutwit · 07-06-2020, 11:14 AM

Quote:

Originally Posted by PeterT

As an experiment, I logged out from my Kobo account on one of my devices, let it do the reset and then, when prompted for language selected English and said No to the WiGi. The device then displayed the connect to my desktop and install Kobo Desktop message.

I made sure that neither calibre, ADE or Kobo desktop were lrunning and connected the Kobo to my PC.

I then launched a Sqlite client (in my case DB Browser for SQLite https://sqlitebrowser.org/), opened the Kobo database and did the SQL command I mentioned above

Code:

INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail)
values("00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000","MyDummyUser@dummy.com","MyDummyUser@dummy.com")

When I closed the database and ejected the device it proceeded to import all the sideloaded content I had on the kobo.

OMG! Thank you so much! It worked!! Thank you x9999999

PeterT · 07-06-2020, 12:06 PM

So glad. And this approach should work regardless of f/w level / database version until Kobo requires another column to be populated.

JSWolf · 07-17-2020, 02:40 PM

Please delete this thread and don't help anyone be paranoid to register their Kobo. It's just not worth the hassle. And you lose more then you gain. One day you could lose everything when a firmware update decide to change thing so the face registration no longer works. This has already happened once.

MGlitch · 07-17-2020, 02:55 PM

Quote:

Originally Posted by JSWolf

Please delete this thread and don't help anyone be paranoid to register their Kobo. It's just not worth the hassle. And you lose more then you gain. One day you could lose everything when a firmware update decide to change thing so the face registration no longer works. This has already happened once.

It's not worth it to you. Others disagree.

The folks skipping registration are likely sideloading books, which means even with a firmware update that changes things, they'll have a back up (or at least should).

Honestly better to do this than to set a fake email since if you lose the password the account will be lost to you if you forget it. Also if it's a fake email and someone comes along and makes it, then tries to make a kobo account they'd be able to get your books and buy more if you have a CC connected.

Regardless, it's not up to you to tell people what to do with their device, you can inform them of the risk but they should be free to do as they please.

rashkae · 07-18-2020, 01:03 PM

The simplest database insert that worked as of the 4.4 firmware was:
INSERT INTO user (UserID,UserKey) VALUES('1','');

(Note, that last value is two single ' with nothing in between them, not a double quote (")

Once you have a database with a blank user, you can just copy that into the .kobo directory (and restart). I've been using the same database file for every new generation of device and firmware. Much simpler and easier than registration and sync, fake or not.

Anyone who wants it is welcome to copy the database file I've been using:
(I've attached a zipped copy this message, as well as a link to zippy)

https://www66.zippyshare.com/v/g56DQJzy/file.html

JSWolf · 07-20-2020, 04:05 PM

@limutwit, why is it that ou are so paranoid? There is zero reason not to have a proper Kobo account and do a proper registration.

webtroter · 07-24-2020, 10:58 AM

Quote:

Originally Posted by rashkae

The simplest database insert that worked as of the 4.4 firmware was:
INSERT INTO user (UserID,UserKey) VALUES('1','');

(Note, that last value is two single ' with nothing in between them, not a double quote (")

Once you have a database with a blank user, you can just copy that into the .kobo directory (and restart). I've been using the same database file for every new generation of device and firmware. Much simpler and easier than registration and sync, fake or not.

Anyone who wants it is welcome to copy the database file I've been using:
(I've attached a zipped copy this message, as well as a link to zippy)

https://www66.zippyshare.com/v/g56DQJzy/file.html

Can I use this SQLite on any Kobo device? Like my Glo HD ?

DNSB · 07-24-2020, 11:27 AM

Quote:

Originally Posted by webtroter

Can I use this SQLite on any Kobo device? Like my Glo HD ?

Outside of the original Kobo and the Kobo WiFi which I am not certain about, they all use an SQLite database to store information (the KoboReader.sqlite file in the .kobo directory). Later firmware added an encrypted BookReader.sqlite about which little information is known.

webtroter · 07-24-2020, 01:50 PM

Quote:

Originally Posted by DNSB

Outside of the original Kobo and the Kobo WiFi which I am not certain about, they all use an SQLite database to store information (the KoboReader.sqlite file in the .kobo directory). Later firmware added an encrypted BookReader.sqlite about which little information is known.

Thanks. Ended up not waiting for an answer and downloading an SQLite browser.

rashkae · 07-26-2020, 11:42 AM

That SQLite database I posted was created with firmware version 3.19,, it should work on any kobo e-ink device with at least that firmware version. I don't know what would happen if you copied the database to a device with an older firmware, (but I doubt there's anything to loose in the attempt.)

07-03-2020, 11:03 AM	#1
limutwit Junior Member Posts: 9 Karma: 10 Join Date: Jul 2020 Device: Kobo Glo	Please help. Unable to skip registration on Kobo Glo Hi Following the instructions from this forum, I have managed to skip registration on the Clara (it was extremely difficult but I got there in the end) Thank you! Now I wish to attempt the same on the Kobo Glo. I followed the command codes from https://www.mobileread.com/forums/sh...d.php?t=171664 I used both INSERT INTO "user" VALUES('aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa','xxxx@xxxx.xx','xxxx@xxxx.xx','2aaaa aaaaaaaaaaaaa=='); and also tried INSERT INTO "user" VALUES('foo','foo','foo','foo','foo'); However, I received the following error Error: table user has 26 columns but 5 values were supplied I thought it was because it had the latest 4.22... firmware, so I downgraded to 3.19... but still came up with the same error. Please advise. Thank you

07-03-2020, 06:49 PM	#3
PeterT Grand Sorcerer Posts: 12,168 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	One thing I think people forget is that there are two forms of SQL inserts. Either Code: INSERT INTO Customers VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway'); Or Code: INSERT INTO Customers (CustomerName, ContactName) VALUES ('Cardinal', 'Tom B. Erichsen'); The second method explicitly names the columns being given data and sets the other columns to default values. This means that if the table is changed to have additional columns added the insert will still function. For instance at one point all one needed was Code: INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail) values("00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000","MyDummyUser@dummy.com","MyDummyUser@dummy.com") If now additional columns need explicit values they just need to be added to both the list of columns and the value statement Last edited by PeterT; 07-03-2020 at 06:54 PM.

07-04-2020, 08:11 PM	#5
PeterT Grand Sorcerer Posts: 12,168 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	As an experiment, I logged out from my Kobo account on one of my devices, let it do the reset and then, when prompted for language selected English and said No to the WiGi. The device then displayed the connect to my desktop and install Kobo Desktop message. I made sure that neither calibre, ADE or Kobo desktop were lrunning and connected the Kobo to my PC. I then launched a Sqlite client (in my case DB Browser for SQLite https://sqlitebrowser.org/), opened the Kobo database and did the SQL command I mentioned above Code: INSERT INTO user (UserID, UserKey, UserDisplayName, UserEmail) values("00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000000","MyDummyUser@dummy.com","MyDummyUser@dummy.com") When I closed the database and ejected the device it proceeded to import all the sideloaded content I had on the kobo.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
unable to connect to Kobo Glo HD	ribez	Devices	6	11-06-2018 03:20 PM
Kobo aura one how to skip registration?	EddieTheHead	Kobo Reader	1	08-28-2018 08:03 AM
Kobo Glo unable to enumarate usb device	loviedovie	Kobo Reader	7	10-04-2015 12:43 PM
Glo Unable to use micro sd on Kobo Glo	P-hil	Kobo Reader	17	11-15-2014 01:12 PM
Touch Nook STR-Any way to skip registration?	Japes	Barnes & Noble NOOK	2	06-09-2011 06:51 PM

07-03-2020, 02:11 PM	#2
DNSB Bibliophagist Posts: 35,464 Karma: 145525534 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Forma, Clara HD, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Why don't you simply register with a self-generated email address. Kobo does not check the address. E.g. koboglo17e@anywheres.net will work. This has the advantage that you don't have to worry in the future about a firmware update breaking your registration.

07-06-2020, 12:06 PM	#7
PeterT Grand Sorcerer Posts: 12,168 Karma: 73448616 Join Date: Nov 2007 Location: Toronto Device: Nexus 7, Clara, Touch, Tolino EPOS	So glad. And this approach should work regardless of f/w level / database version until Kobo requires another column to be populated.

07-17-2020, 02:40 PM	#8
JSWolf Resident Curmudgeon Posts: 73,998 Karma: 128903378 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	Please delete this thread and don't help anyone be paranoid to register their Kobo. It's just not worth the hassle. And you lose more then you gain. One day you could lose everything when a firmware update decide to change thing so the face registration no longer works. This has already happened once.

07-20-2020, 04:05 PM	#11
JSWolf Resident Curmudgeon Posts: 73,998 Karma: 128903378 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	@limutwit, why is it that ou are so paranoid? There is zero reason not to have a proper Kobo account and do a proper registration.

07-26-2020, 11:42 AM	#15
rashkae Wizard Posts: 1,147 Karma: 5061953 Join Date: Jun 2011 Location: Ontario, Canada Device: Kobo Aura HD	That SQLite database I posted was created with firmware version 3.19,, it should work on any kobo e-ink device with at least that firmware version. I don't know what would happen if you copied the database to a device with an older firmware, (but I doubt there's anything to loose in the attempt.)

Advert

Advert