KUAL: Kindle Unified Application Launcher (v2.7)

[knc1]

Thanks.
I think you are the first to make a report about KUAL on a PW2 running 5.9.2.0.1
I can only guess at the other posts you have seen here, but I bet they are not about a PW2 running 5.9.2.0.1
Yes, I know, it should be: same version number == same behavior, but not when Amazon/Lab126 is doing the work.

[knc1]

Originally Posted by knc1

- - - - -
And then again...
So try following the sqlite.org directions, and:

[root@kindle local]# sqlite3 cc.db
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .dump Locale
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Locale ( locale );
INSERT INTO "Locale" VALUES('en_US.utf8');
COMMIT;

sqlite> SELECT * FROM Locale;
en_US.utf8

sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');
Error: no such function: icu_load_collation
sqlite>

????
Well, the answer to that one happens to be on the first line shown above.
SQLite version 3.7.14.1 2012-10-04 19:37:12
The ability to load a custom collation was first added to sqlite3, version 3.7.16

The current version is 3.21
My Ubuntu LTS has 3.20 installed.
So the most likely situation is the (?contractor?) person at Lab126 is doing all of s/he's work on a PC (with a current or nearly current version) and never checking their work on the Kindle.

Update:
The above was from 5.9.2 -
A similar problem exists on 5.3.7.3 (the oldest ts firmware version we support here).
I.E: The interactive sqlite3 can not delete records from cc.db for the same reason (the extension library might be able to but not the interactive).

Whoot!
A build of SQLite3 (3.21.0 the newest) that runs on our oldest, supported, touchscreen model, the KT-fw5.3.7.3:

[root@kindle local]# cat /etc/prettyversion.txt
Kindle 5.3.7.3 (~~otaVersion~~)

[root@kindle local]# LD_LIBRARY_PATH=/var/local ./sqlite3.armv7a
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

The library path thingy is because the Kindles are missing a library that is required.
Which really isn't all that bad, only one additional file required to make today's sqlite3 version run on our oldest supported model/firmware combination.

Tomorrow - return to the "get rid of the KUAL booklet" script writing.

[quyptit]

My Jailbroken Kindle PPW3 automatically upgraded to 5.9.2.0.1, and the jailbreak was lost.

I tried to reinstall KUAL by ;log mrpi but it showed nothing. Is there any measures that I can do to install KUAL again?

Thanks very much!

[knc1]

You DID NOT lose your jailbreak.
KUAL does not work properly on 5.9.<anything>

What do you want to launch?
You should be able to use the .log runme command to start it.

[Georgie W]

I've got the same problem as everyone else with 5.9.x.x. I'd like to run librarian sync. I know that I can run ";log mrpi" from the search bar, but how do I point "runme" at Librarian Sync? thanks in advance for any advice.

[knc1]

Originally Posted by Georgie W

I've got the same problem as everyone else with 5.9.x.x. I'd like to run librarian sync. I know that I can run ";log mrpi" from the search bar, but how do I point "runme" at Librarian Sync? thanks in advance for any advice.

Review the examples in the "runme scripts" thread for a start.

[BishopLuc]

Originally Posted by DaRk_ViVi

Yesterday I updated my Kindle Voyage to the latest version just to find out that KUAL is not working anymore.
No problem, I used the ;log mrpi to install the booklet version and is up and running again (with my beloved screensaver hack).

Now I would like to remove the old KUAL icon from my Kindle as it's not working anymore, but deleting the KUAL-KDK-2.0.azw2 file from the /documents directory of the Kindle did nothing. Is there anything I am missing?

I only registered to ask this.... HOW? Please!

EDIT: Nevermind, I figured it out!

[BishopLuc]

Originally Posted by Antinoos

As I'm asked directly here:

You've run in one of the bugs out of the bucket full of them in fw 5.9.<anything>. But really in one of the less nasty ones...

There's a little chance to get rid of the unneeded icon for the KUAL kindlet. It's stored in: /developer/KUAL/metadata/thumbnail.jpg in the user visible storage - just delete it there and do a reboot.

As I've strictly avoided to update to 5.9.x, I only can guess that this could help, but I wasn't able to test it. Please report back what happened. Unfortunately, it's possible that the new 5.9.x internal database structure keeps a copy of the icon inside the system area. Then you're out of look. But the useless icon in your library doesn't do any harm at all...

Just removed the background image bit its still there with the words:

KUAL
ixtab NiLuJe
twobo stepk

Help in removing? Please?

[knc1]

Originally Posted by BishopLuc

Just removed the background image bit its still there with the words:

KUAL
ixtab NiLuJe
twobo stepk

Help in removing? Please?

If you would read up in the thread a few posts, you will learn that I am working on the problem.

[hfpop]

Hello,
I run jailbroken KV 5.9.2.0.1. This is to confirm that the Kual Booklet installed via log mrpi works perfectly.

[Branch Delay]

Yep. Working on my Voyage as well.

[Gryzor]

Same here (KV), I panicked there for a moment when I realised the silent update...

[knc1]

Originally Posted by knc1

. . . . . . snip . . . . .

And then again...
Maybe it is user error:
http://www.sqlite.org/src/doc/trunk/ext/icu/README.txt

And then again...
So try following the sqlite.org directions, and:

[root@kindle local]# sqlite3 cc.db
SQLite version 3.7.14.1 2012-10-04 19:37:12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

sqlite> .dump Locale
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE Locale ( locale );
INSERT INTO "Locale" VALUES('en_US.utf8');
COMMIT;

sqlite> SELECT * FROM Locale;
en_US.utf8

sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');
Error: no such function: icu_load_collation
sqlite>

????
Well, the answer to that one happens to be on the first line shown above.
SQLite version 3.7.14.1 2012-10-04 19:37:12
The ability to load a custom collation was first added to sqlite3, version 3.7.16

The current version is 3.21
My Ubuntu LTS has 3.20 installed.
So the most likely situation is the (?contractor?) person at Lab126 is doing all of s/he's work on a PC (with a current or nearly current version) and never checking their work on the Kindle.

Update:
The above was from 5.9.2 -
A similar problem exists on 5.3.7.3 (the oldest ts firmware version we support here).
I.E: The interactive sqlite3 can not delete records from cc.db for the same reason (the extension library might be able to but not the interactive).

After a week of handsprings:

[root@kindle local]# cp -a cc.db cc-test.db

[root@kindle local]# sqlite3 cc-test.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.

sqlite> SELECT * FROM Locale;
en_US.utf8

sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');

sqlite> SELECT p_location FROM Entries WHERE p_location LIKE '%KUAL-KDK-2.0.azw2';
/mnt/us/documents/KUAL-KDK-2.0.azw2

sqlite> DELETE FROM Entries WHERE p_location LIKE '%KUAL-KDK-2.0.azw2';           
Error: no such function: is_journaling_enabled
sqlite>

???
No idea about that one, fixing it may take minutes or months - one of those 'm' words.

But at least our interactive version of kSQLite3 now understands every possible ICU collation in the world (as of December 13, 2017).

[knc1]

Originally Posted by knc1

- - - -
No idea about that one, fixing it may take minutes or months - one of those 'm' words.

But at least our interactive version of kSQLite3 now understands every possible ICU collation in the world (as of the latest release by the unicode people).

Work-around already found:
https://www.mobileread.com/forums/sh...76&postcount=8

[knc1]

At least the required set of commands a script would need are now working:
(I have added blank lines to make this a bit more readable.)

[root@kindle local]# cat /etc/prettyversion.txt
Kindle 5.3.7.3 (~~otaVersion~~)

[root@kindle local]# find . -type f -a -name '*.db' 2>/dev/null
./appreg.db
./reg/prereg.db
./reg/ServerConfig.db
./cc.db
./mesquite/store/resource/appcache/ApplicationCache.db

[root@kindle local]# echo $PATH
/mnt/us/esys/bin:/usr/local/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/local/python/bin

[root@kindle local]# sqlite3 --version
3.21.0 2017-10-24 18:55:49 1a584e499906b5c87ec7d43d4abce641fdf017c42125b083109bc77c4de4alt2

root@kindle local]# sqlite3 -line cc-test.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.

sqlite> .header off

sqlite> .load libfixup

sqlite> SELECT * FROM Locale;
locale = en_US.utf8

sqlite> SELECT icu_load_collation('en_US.utf8', 'icu');

sqlite> SELECT p_uuid, p_location, p_thumbnail FROM Entries WHERE p_location LIKE '%KUAL-KDK-2.0.azw2';
     p_uuid = 36f27e44-af05-4675-8771-ae80158e0c39
 p_location = /mnt/us/documents/KUAL-KDK-2.0.azw2
p_thumbnail = /mnt/us/developer/KUAL/metadata/thumbnail.jpg

sqlite> SELECT p_location, p_thumbnail FROM Entries WHERE p_uuid IN ('36f27e44-af05-4675-8771-ae80158e0c39');
 p_location = /mnt/us/documents/KUAL-KDK-2.0.azw2
p_thumbnail = /mnt/us/developer/KUAL/metadata/thumbnail.jpg

sqlite> DELETE FROM Entries WHERE p_uuid IN ('36f27e44-af05-4675-8771-ae80158e0c39');

sqlite> SELECT p_location, p_thumbnail FROM Entries WHERE p_uuid IN ('36f27e44-af05-4675-8771-ae80158e0c39');

sqlite> .quit 

root@kindle local]# rm -f /mnt/us/documents/KUAL-KDK-2.0.azw2 /mnt/us/developer/KUAL/metadata/thumbnail.jpg

root@kindle local]#

Next - investigate changes (additions mostly) to the databases for the firmware versions from 5.3.7.3 (above) to 5.9.2.
Then - invent a script to handle all cases of "Can not delete the KUAL document".
Hmm - and maybe even include deleting the KUAL booklet as an option to the script.

And then - back to the new 'bridge code' (I needed a working, interactive, kSQLite3 for that project).

= = = =

WARNING:
Attached is a 'unzip to top of visible USB storage' archive of what I used above (for those who just can't wait to get rid of the KUAL thumbnail).
BUT IT WILL CONFLICT with the files from my ARMHF example (because this build is soft float, to enable it to use some of the Kindle's libraries).
I will have that conflict fixed by the time I release a script for this purpose.

Hmm...
That name should be: 01_26_2018 not 01_26_2017
I'll fix that in the final version also

Update:
I pulled the attachment, hfpop found a problem with the build.
Will repost with I get it fixed