Release - Kodi Selective Cleaner addon support

Release Kodi Selective Cleaner addon support - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Add-on Support (https://forum.kodi.tv/forumdisplay.php?fid=27)
+---- Forum: Program Add-ons (https://forum.kodi.tv/forumdisplay.php?fid=151)
+---- Thread: Release Kodi Selective Cleaner addon support (/showthread.php?tid=369984)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-15

(2024-05-15, 14:08)sufreak Wrote: Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity. If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields. It would also help to see the exact log message from the kodi.log file.

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - sufreak - 2024-05-15

(2024-05-15, 15:52)jbinkley60 Wrote:
(2024-05-15, 14:08)sufreak Wrote: Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity. If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields. It would also help to see the exact log message from the kodi.log file.

Thanks,

Jeff

Quote:2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25): default.py
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): entering source directory /storage/.kodi/addons/plugin.program.kscleaner
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): instantiating addon using automatically obtained id of "plugin.program.kscleaner" dependent on version 3.0.0 of the xbmc.python api
2024-05-15 15:52:36.815 T:4064     info <general>: KS Cleaner logging database check successful. Addon started.
2024-05-15 15:52:36.830 T:4064     info <general>: Kodi Selective Cleaner Python vesion is: 3.11.2
2024-05-15 15:52:36.850 T:4064     info <general>: KS Cleaner music DB trigger checking is disabled
2024-05-15 15:52:36.902 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.125 3306 kodi <removed> myvideos121
2024-05-15 15:52:37.422 T:720     debug <general>: ------ Window Init (DialogConfirm.xml) ------
2024-05-15 15:52:41.535 T:724     debug <general>: LIRC: - NEW 160 0 KEY_OK devinput (KEY_OK)
2024-05-15 15:52:41.572 T:720     debug <general>: HandleKey: 11 (0xb, obc244) pressed, window 12002, action is Select
2024-05-15 15:52:41.849 T:720     debug <general>: ------ Window Deinit (DialogConfirm.xml) ------
2024-05-15 15:52:41.872 T:4064     info <general>: KS Cleaner MySQL server database not found: myvideos121
2024-05-15 15:52:42.040 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.105 3306 kodi <removed> mymusic82

I wonder if is case sensitive. My dbs are MyVideos121 and MyMusic82

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-15

(2024-05-15, 22:01)sufreak Wrote:
(2024-05-15, 15:52)jbinkley60 Wrote:
(2024-05-15, 14:08)sufreak Wrote: Hey - just installed this add on to try it out.

I am using MySQL dbs, and when I set it to them, it told me they weren't found. Is there a configuration that needs to happen? (I know they're up and working, just connected to them with another db tool)

Here's the Wiki link on setting up MySQL connectivity. If this doesn't help then I need to understand your addon settings for MySQL Database Names, your database names and your advancedsettings.zml database name fields. It would also help to see the exact log message from the kodi.log file.

Thanks,

Jeff
Quote:2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25): default.py
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): entering source directory /storage/.kodi/addons/plugin.program.kscleaner
2024-05-15 15:52:35.906 T:4064    debug <general>: CPythonInvoker(25, /storage/.kodi/addons/plugin.program.kscleaner/default.py): instantiating addon using automatically obtained id of "plugin.program.kscleaner" dependent on version 3.0.0 of the xbmc.python api
2024-05-15 15:52:36.815 T:4064     info <general>: KS Cleaner logging database check successful. Addon started.
2024-05-15 15:52:36.830 T:4064     info <general>: Kodi Selective Cleaner Python vesion is: 3.11.2
2024-05-15 15:52:36.850 T:4064     info <general>: KS Cleaner music DB trigger checking is disabled
2024-05-15 15:52:36.902 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.125 3306 kodi <removed> myvideos121
2024-05-15 15:52:37.422 T:720     debug <general>: ------ Window Init (DialogConfirm.xml) ------
2024-05-15 15:52:41.535 T:724     debug <general>: LIRC: - NEW 160 0 KEY_OK devinput (KEY_OK)
2024-05-15 15:52:41.572 T:720     debug <general>: HandleKey: 11 (0xb, obc244) pressed, window 12002, action is Select
2024-05-15 15:52:41.849 T:720     debug <general>: ------ Window Deinit (DialogConfirm.xml) ------
2024-05-15 15:52:41.872 T:4064     info <general>: KS Cleaner MySQL server database not found: myvideos121
2024-05-15 15:52:42.040 T:4064    debug <general>: KS Cleaner parse: mysql 192.168.10.105 3306 kodi <removed> mymusic82

I wonder if is case sensitive. My dbs are MyVideos121 and MyMusic82

Certain Kodi platforms are case sensitive. What's the OS on which you are running the addon ? You can manually add MyVideos and MyMusic to the addon database name settings and see if that fixes it or update your advancedsettings.xml file to proper case.

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - sufreak - 2024-05-15

(2024-05-15, 22:32)jbinkley60 Wrote: Certain Kodi platforms are case sensitive. What's the OS on which you are running the addon ? You can manually add MyVideos and MyMusic to the addon database name settings and see if that fixes it or update your advancedsettings.xml file to proper case.
Thanks,
Jeff

I'm running on Linux, both Kodi and my sql db server. I'll try to mess with the add on later

RE: Kodi Selective Cleaner addon support - Karellen - 2024-05-15

Maybe try adding the <name>MyVideos121</name> tag

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-15

(2024-05-15, 23:08)Karellen Wrote: Maybe try adding the <name>MyVideos121</name> tag

Yes, that should work. Right now the Kodi Selective Cleaner is seeing the name tag as all lowercase and Linux is case sensitive..

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - sufreak - 2024-05-16

I added the names to the addon instead of default and it seemed to work. Hopefully the next version can patch that.

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-16

(2024-05-16, 00:56)sufreak Wrote: I added the names to the addon instead of default and it seemed to work. Hopefully the next version can patch that.

There isn't anything the addon can do here. Your advancedsettings.xml name doesn't match your database name for proper case. If you changed the database settings back to Default and updated your advancedsettings.xml file that should work too.

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - sufreak - 2024-05-16

My advancedsettings.xml doesn't specify a name, it uses default.

Quote:<videodatabase>
        <type>mysql</type>
        <host>192.168.10.125</host>
        <port>3306</port>
        <user>Removed</user>
        <pass>Removed</pass>
    </videodatabase>

Looking at common.py, changing:

line 145, myvideos > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as MyVideos and MyMusic

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-16

(2024-05-16, 01:24)sufreak Wrote: My advancedsettings.xml doesn't specify a name, it uses default.

Quote:<videodatabase>
        <type>mysql</type>
        <host>192.168.10.125</host>
        <port>3306</port>
        <user>Removed</user>
        <pass>Removed</pass>
    </videodatabase>
Looking at common.py, changing:

line 145, myvideos > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as MyVideos and MyMusic

So you do not have name tags in your advancedsettings.xml file ? If so, then your suggestion would fix it. I presumed you had lowercase name tags.

Jeff

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-16

(2024-05-16, 01:24)sufreak Wrote: Looking at common.py, changing:

line 145, myvideos > MyVideos
line 205, mymusic > MyMusic

Wouldn't that solve the problem?

The Kodi documentation https://kodi.wiki/index.php?title=Databases states the names as MyVideos and MyMusic

I have posted version 1.0.5d which has the suggested change. Once you install this version reset the database names back to Default and see if it works.

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - kittmaster - 2024-05-24

I like it.

I would recommend one creature feature add, you have "clean all tables" which is great when turned on. Each database item has an analyze which is nice, but 15 times in and out to "check" is laborious. Would you consider an "Analyze all tables" and display that to reduce the click in and outs to either find a problem in a particular DB item vs. the large hammer where all are cleaned but don't know what 'til it's over i.e. clean all tables.

I do like the feature and will be adding it to my addons.

Greetz,
Chris

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-24

(2024-05-24, 13:05)kittmaster Wrote: I like it.

I would recommend one creature feature add, you have "clean all tables" which is great when turned on. Each database item has an analyze which is nice, but 15 times in and out to "check" is laborious. Would you consider an "Analyze all tables" and display that to reduce the click in and outs to either find a problem in a particular DB item vs. the large hammer where all are cleaned but don't know what 'til it's over i.e. clean all tables.

I do like the feature and will be adding it to my addons.

Analyzing all tables is a bit more challenging than cleaning all tables due to the differences in displaying the output results for each table. Yours' is the second request for this. What about Analyze All but output it to a CSV or text file vs. the screen ? I'll give this some thought. A text file output would likely be the easiest.

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - jbinkley60 - 2024-05-25

I have posted a new release version 1.0.6 of Kodi Selective Cleaner. This version has a number of fixes and features, including support for the Kodi Omega 21 videroversion tables. I appreciate all who provided feature suggestions and helped test this release.

Here's the complete list of highlights since 1.0.5

• Changed cleaning seasons from displaying season name to associated TV Show names
• Added videoversion and videoversiontype tables to CSV export
• Added logging of Kodi version detected to KS Cleaner logger
• Added videoversion table to the video database analyzer
• Added repairing of missing triggers for MySQL music databases. Previously only detection was supported.
• Added CSV export for video database tag and tag_link tables
• Fixed MySQL default database names from all lowercase to propercase

Now to begin the feature requests for v1.0.7 Smile

Thanks,

Jeff

RE: Kodi Selective Cleaner addon support - Meth0d - 2024-06-04

There really should be a "Clean all" after "Analyse all" option, as said before going manually through all tables back and forth through the menu feels very stupid Wink

I guess this will not be requested by many but i would find it very usefull if you could trigger the script(s) from ssh.
I run libreelec in my livingroom mostly headless and would rather do all the "library stuff" like keeping tvshows up2date from somwhere else ie my Desktop Smile