Updating Media Indexes on Synology NAS: Difference between revisions
No edit summary Tag: wikieditor |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== DSM 7 == | |||
== Goal == | |||
=== Scenario === | |||
'''Synology Photos''' is not showing some image files and/or some directories within the `/Photo` or `/Photos` directories. | |||
=== Resolution === | |||
First try renaming the directory, e.g. `missing-photos` to `missing-photos-a`. Then refresh the view in '''Synology Photos'''. This usually works to force Synology Photos to recognize a missing directory's existence. | |||
If photos are still missing, re-index the photos directory: '''Synology Photos''' > '''Account''' > '''Settings''' > ''(choose between '''Personal''' or '''Shared''' tabs)'' > '''Indexing''' > click the '''Re-Index''' button. | |||
'''SP''' will display "indexing..." next to the button. Re-indexing may take a while. I have not found any articles describing a way to watch the progress of the indexing. The only indication that the process has completed is waiting for the "indexing..." message to go away. | |||
== DSM 6 and previous (ARCHIVED) == | |||
<p class="alert alert-warning">The following information refers to previous versions of DSM (prior to DSM 7) and are saved for archival purposes</p> | |||
=== Goal === | |||
Files are saved to a Windows 7 directory. | Files are saved to a Windows 7 directory. | ||
| Line 10: | Line 27: | ||
How to re-index NAS so the files are available in Photo Station before the nightly indexing. | How to re-index NAS so the files are available in Photo Station before the nightly indexing. | ||
== Log on to NAS with SSH == | === Log on to NAS with SSH === | ||
See [Enable SSH on Synology NAS] | See [[Enable SSH on Synology NAS]] | ||
== Re-index media files == | === Re-index media files === | ||
<div class="alert alert-warning">TODO: Research the differences between command line re-indexing and re-indexing through the DSM Control Panel. I think they do the same thing. If that's the case, using the DSM is easier.</div> | <div class="alert alert-warning">TODO: Research the differences between command line re-indexing and re-indexing through the DSM Control Panel. I think they do the same thing. If that's the case, using the DSM is easier.</div> | ||
=== Command line === | ==== Command line ==== | ||
SSH to NAS server | SSH to NAS server | ||
| Line 42: | Line 59: | ||
`synoindex` can be used to retrieve metadata from indexed files. | `synoindex` can be used to retrieve metadata from indexed files. | ||
=== Synology DSM === | ==== Synology DSM ==== | ||
* Login to the DSM with an account with administrator priviledges. | * Login to the DSM with an account with administrator priviledges. | ||
| Line 48: | Line 65: | ||
* It will report '''Indexing media files''', which is a slow process. | * It will report '''Indexing media files''', which is a slow process. | ||
== Checking on the current indexes == | === Checking on the current indexes === | ||
Use the postgreSQL interactive terminal:<ref>[http://wacha.ch/wiki/synology Synology Indexing] - Synology Wiki by Clemens Wacha</ref> | Use the postgreSQL interactive terminal:<ref>[http://wacha.ch/wiki/synology Synology Indexing] - Synology Wiki by Clemens Wacha</ref> | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
DiskStation> psql mediaserver | DiskStation> sudo psql mediaserver postgres | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 71: | Line 88: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
To check the current number of indexed files: | |||
<syntaxhighlight lang="sql"> | |||
select count(1) as music_count from music; | |||
select count(1) as photo_count from photo; | |||
select count(1) as video_count from video; | |||
</syntaxhighlight> | |||
To | To view the last file indexed: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
select * from | select * from photo where id = (select max(id) from photo); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 86: | Line 110: | ||
== Notes == | == Notes == | ||
<references /> | <references /> | ||
[[Category:Synology]] [[Category:Production]] | |||
Latest revision as of 21:21, 29 November 2022
DSM 7[edit]
Scenario[edit]
Synology Photos is not showing some image files and/or some directories within the /Photo or /Photos directories.
Resolution[edit]
First try renaming the directory, e.g. missing-photos to missing-photos-a. Then refresh the view in Synology Photos. This usually works to force Synology Photos to recognize a missing directory's existence.
If photos are still missing, re-index the photos directory: Synology Photos > Account > Settings > (choose between Personal or Shared tabs) > Indexing > click the Re-Index button.
SP will display "indexing..." next to the button. Re-indexing may take a while. I have not found any articles describing a way to watch the progress of the indexing. The only indication that the process has completed is waiting for the "indexing..." message to go away.
DSM 6 and previous (ARCHIVED)[edit]
The following information refers to previous versions of DSM (prior to DSM 7) and are saved for archival purposes
Goal[edit]
Files are saved to a Windows 7 directory.
A scheduled task copies those files to a remote NAS drive.
A task runs on NAS that re-indexes its media nightly (making it available to Photo Station).
How to re-index NAS so the files are available in Photo Station before the nightly indexing.
Log on to NAS with SSH[edit]
See Enable SSH on Synology NAS
Re-index media files[edit]
Command line[edit]
SSH to NAS server
usage:
Add: synoindex -a filename
Delete: synoindex -d filename
Add folder: synoindex -A folder
Delete folder: synoindex -D folder
Rename/move file/folder: synoindex -N newfullpath oldfullpath
Update Photo Images: synoindex -U photo
Get from DB: synoindex -g filename -t [video|music|photo|playlist]
Additionally, this command will re-index a specific media table:[1]
synoindex -R [video|music|photo|playlist|all]
synoindex -h for all command line options.[2]
synoindex can be used to retrieve metadata from indexed files.
Synology DSM[edit]
- Login to the DSM with an account with administrator priviledges.
- Control Panel > System > Media Indexing > Media Indexing tab > Re-index button.
- It will report Indexing media files, which is a slow process.
Checking on the current indexes[edit]
Use the postgreSQL interactive terminal:[3]
DiskStation> sudo psql mediaserver postgres
To display a list of tables:
mediaserver=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------+-------+-------
public | directory | table | admin
public | music | table | admin
public | photo | table | admin
public | playlist | table | admin
public | video | table | admin
(5 rows)
To check the current number of indexed files:
select count(1) as music_count from music; select count(1) as photo_count from photo; select count(1) as video_count from video;
To view the last file indexed:
select * from photo where id = (select max(id) from photo);
To quit type
\q
Notes[edit]
- ↑ Synology Indexing - Synology Wiki by Clemens Wacha
- ↑ More on the Synology NAS Automatically Indexing New Files ("codesourcery" blog, 11/29/2012)
This includes a Python script for watching for file system changes and triggering thesynoindexcommand. - ↑ Synology Indexing - Synology Wiki by Clemens Wacha