Also, where did the asterisks * come from in the *43 and in */home/susan/calibre/testlibrary ??
Also, the * just before *AS 'SOURCE' ; ??
Code:
ATTACH DATABASE '/home/susan/calibre/testlibrary/metadata.db' *AS 'SOURCE' ;
length of path: *43
Attaching to New Source Library: /home/susan/calibre/testlibrary/metadata.db
NOT Attached: /home/susan/calibre/testlibrary/metadata.db
CantOpenError: unable to open database: /home/susan/calibre/testlibrary/metadata.db
^^^^^^^ Source Library was NOT found: */home/susan/calibre/testlibrary
The debug log should be similar to this from my Windows 11 testing:
Code:
ATTACH DATABASE 's:/calibre/calibrelibrarycodes/metadata.db' AS 'SOURCE' ;
length of path: 42
Attaching to New Source Library: s:/calibre/calibrelibrarycodes/metadata.db
Now Attached to New Source Library: s:/calibre/calibrelibrarycodes/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source