sonerezh icon indicating copy to clipboard operation
sonerezh copied to clipboard

Update song, artist, or album information

Open bichomen opened this issue 7 years ago • 18 comments

How can I update information, images, names, etc. with Sonerezh? or can not be?

bichomen avatar Jun 02 '17 10:06 bichomen

Currently the only way is to remove & re-add the folders to have the metadata re-read again. Alternatively click Reset the database in the settings.

gs11 avatar Jun 02 '17 18:06 gs11

To remove the album in the database, here is the MySQL line I use in phpMyAdmin:

    DELETE FROM `songs` WHERE `songs`.`album` = "your album title"

MightyCreak avatar Jun 03 '17 13:06 MightyCreak

@gs11 I think this would be a nice evolution of your PR #293: to detect files that have changed (file modification date greater than last update date in the table) and re-read them.

(#293 is good the way it is, small and easy to merge, but maybe another PR sitting on top of it?)

MightyCreak avatar Jun 03 '17 13:06 MightyCreak

Anyhow, I'd say that this particular issue is a dup of #127 and #129

MightyCreak avatar Jun 03 '17 13:06 MightyCreak

@bichomen Feel free to try out an implementation for this in https://github.com/gs11/sonerezh/commit/26e3b3d1d915f0460278b12313e9cf672357aa95

gs11 avatar Jun 05 '17 07:06 gs11

Hi, thanks for replying, but I see that changing the metadata of a file can only be done using external software like EasyTAG and then upload the modified file to sonerezh.

bichomen avatar Jun 06 '17 14:06 bichomen

That's correct, the project developers mentioned planning this feature in issue #127.

gs11 avatar Jun 06 '17 18:06 gs11

@bichomen I think editing your own files is the best way to go. If it was possible to edit the metadata directly in the Sonerezh database, then obviously, the metadata in the database would start to be different than the metadata in your files. Meaning that if you use the same files in another player, you won't have the same metadata displayed as in Sonerezh. That was what iTunes was doing before, and I think it is fundamentally a bad idea.

I advise you to synchronize your local song files on your server (using Nextcloud, rsync, or something else). This way you will, firstly, backup your songs, and secondly, easily be able to edit your files locally and they will synchronize automatically on your server. Personally I use Nextcloud and it works very well; and now with the commit from @gs11 I won't have to delete entries in the songs table so that update the update pass will detect them again, I will just have to hit 'update' and that's it!

MightyCreak avatar Jun 06 '17 23:06 MightyCreak

@MightyCreak How to synchronize the song folder with nextcloud? I do not see the option in nextcloud

bichomen avatar Jun 08 '17 06:06 bichomen

I simply upload my music in the music folder of Nextcloud and in Sonerezh I change the music folder in the settings to point to the Nextcloud music folder. And that's it! ;)

MightyCreak avatar Jun 08 '17 11:06 MightyCreak

What is the problem? The permissions are identical

Current path: /srv/www/musica/Musica

Path where NextCloud: /srv/www/nc/data/bichomen/files/Musica

Permissions Error Sonerezh

bichomen avatar Jun 08 '17 12:06 bichomen

That's weird... If you're on Fedora, I'd search around SELinux maybe?

MightyCreak avatar Jun 08 '17 22:06 MightyCreak

Not, I'm using Trisquel based in Ubuntu

bichomen avatar Jun 09 '17 06:06 bichomen

I was doing tests and it does not accept any folder that is not in the route /srv/www/musica, not even creating symbolic links it works

bichomen avatar Jun 09 '17 11:06 bichomen

In the nginx configuration I have: root /srv/www/musica/app/webroot;

bichomen avatar Jun 09 '17 11:06 bichomen

Could it be that your webserver is jailed to www root?

gs11 avatar Jun 09 '17 11:06 gs11

www is bichomen, bichomen is the user of nginx:

namei -l /srv/www f: /srv/www drwxr-xr-x root root / drwxr-xr-x root root srv drwxr-xr-x bichomen ftp www

bichomen avatar Jun 09 '17 11:06 bichomen

In the PHP configuration modifying:

php_admin_value[open_basedir] = /srv/www/musica/:/tmp/

by:

/srv/www/musica/:/home/Musica/

Take the new route, but do not update the list of new songs

bichomen avatar Jun 09 '17 12:06 bichomen