Stray nonexistant Transmission plugin popped up in the Installed list

[JaimieV]

Many moons ago I installed Transmission, then ended up deleting it and the jail as I didn't use it. With 9.3, at some point recently (not sure when as I don't look at the plugins much) that old Transmission has popped back up in the Installed list:


There's no associated jail for it, just the two for the real plugins, and unsurprisingly it doesn't start. Trying to delete it with the gui fails but also doesn't remove it from the list.

I tried installing the current Transmission and deleting it, but that just made a new line for Transmission and then deleted the new line.

I've had a look around /etc /cfg /conf /data /usr and not found anything that looks relevant containing Transmission (case insensitive!).

I've taken a look through the backupfile DB, and there doesn't seem to be an entry for Transmission in there at all, which suggests I could reset to defaults then reload the config, but I'm loathe to do that because it doesn't mention the other two plugins I have installed either!

So, two questions I guess:

1) Where would the info be that the web GUI is pulling the old Transmission label from? So I can manually edit it out. If it's in a sqlite db I will probably need a recipe to follow...
2) If I reset the NAS and reload the config, will that clear the leftover Transmission but keep my current plugins?

 

[dlavigne]

Probably worth a bug report. If you make one at bugs.freenas.org, post the issue number here.

 

[JaimieV]

Thanks - it's in as https://bugs.freenas.org/issues/8431

 

[JaimieV]

And fixed, thanks to the lovely folks over there.

Some extra detail I didn't paste into the ticket:

John said:

"
There was a point in the past where you could have a rogue entry in the database, which sounds like the case here. So, remove it from the database.
sqlite3 /data/freenas-v1.db "select * from plugins_plugins;"
Find the correct ID for the entry, then
sqlite3 /data/freenas-v1.db "delete from plugins_plugins where id = ID;""

so I did:

[root@Sisyphus] ~# sqlite3 /data/freenas-v1.db "select * from plugins_plugins;"
2.42|1|10.0.0.103|amd64|1|1|12346|transmission|transmission-2.42-amd64|/usr/pbi/transmission-amd64||1
0.9.11.7.803|1|-|amd64|2|2|12347|plexmediaserver|plexmediaserver-0.9.11.7.803-amd64|/usr/pbi/plexmediaserver-amd64|plexmediaserver_1|2
3.6.3_1|1|-|amd64|3|2|12348|crashplan|crashplan-3.6.3_1-amd64|/usr/pbi/crashplan-amd64|crashplan_1|3

At this point I puzzled for a while how to work out which field was ID, trying various "show columns" and "describe" which don't seem to work in sqlite3, but then I had a minor lightbulb moment. Be kind to me, I don't query DBs very often!

[root@Sisyphus] ~# sqlite3 /data/freenas-v1.db "select * from plugins_plugins where id=12346;"
[root@Sisyphus] ~# sqlite3 /data/freenas-v1.db "select * from plugins_plugins where id=1;"
2.42|1|10.0.0.103|amd64|1|1|12346|transmission|transmission-2.42-amd64|/usr/pbi/transmission-amd64||1
[root@Sisyphus] ~# sqlite3 /data/freenas-v1.db "delete from plugins_plugins where id=1;"
[root@Sisyphus] ~# sqlite3 /data/freenas-v1.db "select * from plugins_plugins;"
0.9.11.7.803|1|-|amd64|2|2|12347|plexmediaserver|plexmediaserver-0.9.11.7.803-amd64|/usr/pbi/plexmediaserver-amd64|plexmediaserver_1|2
3.6.3_1|1|-|amd64|3|2|12348|crashplan|crashplan-3.6.3_1-amd64|/usr/pbi/crashplan-amd64|crashplan_1|3

Hurrah! And the UI shows the same happy result on a refresh.