Glo Triggering a library refresh automatically

[tshering]

Originally Posted by kido.resuri

You can't use the real and virtual sd at the same time, can you?

Yes this works. However, I have trouble to update the library after umount /mnt/sd (and this happens when the user removes the sd) and mount bind again. Then the books of the virtual sd get only shown in the library if I touch (or rename) them before executing "sd add /dev/mmcblk1p1 >> /tmp/nickel-hardware-status".

Edit: I guess I mistook "at the same time". I meant to say you can use the virtual sd, when the real sd is inserted. But now I see that you rather meant that you can access the content of both at the same time

[kido.resuri]

Originally Posted by frostschutz

You can try using a subdir of /mnt/sd as mount point instead of /mnt/sd itself. (It will vanish and need to be re-mounted when someone actually puts in an sd card later)

Maybe, but Kobo puts some data, creates some subdirs on /mnt/sd after the mount, so I don't know what happens when a virtual sd is mounted in a subdir of /mnt/sd

[kido.resuri]

Originally Posted by tshering

However, I have trouble to update the library after umount /mnt/sd (and this happens when the user removes the sd) and mount bind again. Then the books of the virtual sd get only shown in the library if I touch (or rename) them before executing "sd add /dev/mmcblk1p1 >> /tmp/nickel-hardware-status".

I did an umount after the "sd add", and the book was still shown in the library, however when I tried opening it, Kobo displayed a message that the document couldn't be opened and something about DRM. (the book was calibre's user manual)

[tshering]

Taking a sub folder of /mnt/sd as mount point, as advised by Frostschutz, seems to have solved my problem with the library not updating after remounting the virtual sd.

[kido.resuri]

What if you mount /mnt/onboad/.mysd to /mnt/sd/virtual, then after nickel does the content update, you execute this sql query:

UPDATE content SET ContentID = REPLACE(ContentID,'/mnt/sd/virtual/','/mnt/onboard/.mysd/'), BookID = REPLACE(BookID,'/mnt/sd/virtual/','/mnt/onboard/.mysd/');
UPDATE Activity SET Id = REPLACE(Id,'/mnt/sd/virtual/','/mnt/onboard/.mysd/');

DELETE FROM Activity WHERE Id LIKE '%/mnt/sd/virtual/%';

I tried, but edited the database offline, then copied back over ftp, rebooted, and it works. So it should work on Kobo itself with a script.

EDIT: I tried the query on the Kobo itself, and it works. nickel needs a restart tho to see the changes. It would be good to detect when nickel finishes the content update from the virtual sd, so we could execute a script with the query and make a restart. Maybe it's not a real good idea, because every time it gets mounted, the old files are updated to, so it would be a better idea to move the content already read by nickel to another subdir. Makes it too complicated and vulnerable maybe.

[kido.resuri]

Ok, played with it a bit.

mkdir -p /mnt/onboard/.mysd
mkdir -p /mnt/onboard/.mybooks

Then I copied 3 epubs over ftp to /mnt/onboard/.mysd

Then i did over telnet:

mount --bind /mnt/onboard/.mysd/ /mnt/sd/virtual
echo sd add /dev/mmcblk1p1 >> /tmp/nickel-hardware-status
(wait untill nickel finished reading content)
umount /mnt/sd/virtual/
mv /mnt/onboard/.mysd/* /mnt/onboard/.mybooks/
echo "UPDATE Activity SET Id = REPLACE(Id,'/mnt/sd/virtual/','/mnt/onboard/.mybooks/');" | sqlite3 "/mnt/onboard/.kobo/KoboReader.sqlite"
echo "UPDATE content SET ContentID = REPLACE(ContentID,'/mnt/sd/virtual/','/mnt/onboard/.mybooks/'), BookID = REPLACE(BookID,'/mnt/sd/virtual/','/mnt/onboard/.mybooks/') WHERE (ContentID LIKE '%/mnt/sd/virtual/%') OR (BookID LIKE '%/mnt/sd/virtual/%');" | sqlite3 "/mnt/onboard/.kobo/KoboReader.sqlite"
reboot

After this, I had the 3 books in the library, nickel worked on them a bit to create the cover images, after that they opened perfectly. I think this could be automated. The slowest command was the sql query for content table, it took a few seconds to finish, but everything else was quite fast. The UPDATE Activity sql query could be changed to DELETE, as no new book notification is shown after the reboot, so it makes no sense really to UPDATE it.

[anarcat]

Originally Posted by kido.resuri

reboot

reboot is actually necessary? seems a bit extreme...

[kido.resuri]

Seems extreme, but unless anyone can find a better way to make nickel recognize the database changes, i have no better idea.

[anarcat]

can't you kill nickel and restart it?

[kido.resuri]

Would that make any difference? Besides, i would have to make sure wifi is off when starting nickel, and that would make it impossible to run any telnet commands... sure a script could do it, but i find reboot more clean and fast than restarting nickel.

[davidfor]

Originally Posted by kido.resuri

What if you mount /mnt/onboad/.mysd to /mnt/sd/virtual, then after nickel does the content update, you execute this sql query:

UPDATE content SET ContentID = REPLACE(ContentID,'/mnt/sd/virtual/','/mnt/onboard/.mysd/'), BookID = REPLACE(BookID,'/mnt/sd/virtual/','/mnt/onboard/.mysd/');
UPDATE Activity SET Id = REPLACE(Id,'/mnt/sd/virtual/','/mnt/onboard/.mysd/');

DELETE FROM Activity WHERE Id LIKE '%/mnt/sd/virtual/%';

I tried, but edited the database offline, then copied back over ftp, rebooted, and it works. So it should work on Kobo itself with a script.

EDIT: I tried the query on the Kobo itself, and it works. nickel needs a restart tho to see the changes. It would be good to detect when nickel finishes the content update from the virtual sd, so we could execute a script with the query and make a restart. Maybe it's not a real good idea, because every time it gets mounted, the old files are updated to, so it would be a better idea to move the content already read by nickel to another subdir. Makes it too complicated and vulnerable maybe.

You might be able to use a trigger to do the change as the book is added when the virtual SD card is inserted. But, you also need to prevent the book from being added each time the virtual SD card is inserted.

[tshering]

Originally Posted by kido.resuri

Would that make any difference? Besides, i would have to make sure wifi is off when starting nickel, and that would make it impossible to run any telnet commands... sure a script could do it, but i find reboot more clean and fast than restarting nickel.

I do not exactly understand your use case of the whole thing, but I wonder whether it is necessary to move the new files and modify the database immediately after nickel has processed them. You could as well continue to use your reader (for reading), and if you exit nickel and nickel gives control back to start_nickel.sh (from the above description I guess you are using KSM), the script could check whether there are files in /mnt/onboard/.mysd, and if so move them to /mnt/onboard/.mybooks and modify the database. And once you really need that the library knows the newly downloaded books and those located on the external sd, you simply exit nickel and reenter again.

[kido.resuri]

Well, the above was just a test, to see if this works. I didn't use any scripts yet, but manually started the commands in telnet. I don't use KSM, but according to that, I can't simply close nickel and start it again if the wifi is on, is that right? And if I'm on telnet, executing commands manually, it didn't sound a good idea to turn the wifi off, so I used reboot command.

This whole thing could be of course done on next reboot, before nickel starts, as the user won't unmount the virtual sd on normal usage. But what if (s)he wants to plug in a real sd when the virtual one is still mounted? I didn't try that yet.

[tshering]

Originally Posted by kido.resuri

Well, the above was just a test, to see if this works. I didn't use any scripts yet, but manually started the commands in telnet. I don't use KSM, but according to that, I can't simply close nickel and start it again if the wifi is on, is that right? And if I'm on telnet, executing commands manually, it didn't sound a good idea to turn the wifi off, so I used reboot command.

This whole thing could be of course done on next reboot, before nickel starts, as the user won't unmount the virtual sd on normal usage. But what if (s)he wants to plug in a real sd when the virtual one is still mounted? I didn't try that yet.

The books of the the real sd are read into the library. The books of the virtual sd get removed from the library (if I remember correctly).

[kido.resuri]

Originally Posted by davidfor

You might be able to use a trigger to do the change as the book is added when the virtual SD card is inserted. But, you also need to prevent the book from being added each time the virtual SD card is inserted.

What trigger could be used? How to (easily) check if the book is added?
Moving the files can prevent beeing added each time.