[jbinkley60]

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

[sufreak]

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

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

[jbinkley60]

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

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

[sufreak]

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

[Karellen]

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

[jbinkley60]

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

[sufreak]

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

[jbinkley60]

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

[sufreak]

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

<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

[jbinkley60]

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

<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

[jbinkley60]

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