Login at Kodi Home

NeoDuck · 2016-01-09, 02:17

Does Kodi need to be installed on the system where mySQL is installed for a MySQL Kodi setup like this one?

http://kodi.wiki/view/MySQL

I have all my clients set up with Kodi and added sources. However, when I try to SET CONTENT, the setting is never stored and I cannot scan items into my library?

trogggy · 2016-01-09, 02:19

No.

kassysimon · 2016-01-09, 02:31

Nope.

NeoDuck · (This post was last modified: 2016-01-09, 02:34 by NeoDuck.)

(2016-01-09, 02:19)trogggy Wrote: No.

Why do you think my client machines can't SET CONTENT?

I double checked the MySQL port and IP address, both match the advanced settings file.

kassysimon · 2016-01-09, 02:35

Strange.

How many clients are you running?

NeoDuck · 2016-01-09, 02:38

(2016-01-09, 02:35)kassysimon Wrote: Strange.

How many clients are you running?

Three, they're all on kodi 15.2

trogggy · 2016-01-09, 02:40

(2016-01-09, 02:33)NeoDuck Wrote:
(2016-01-09, 02:19)trogggy Wrote: No.

Why do you think my client machines can't SET CONTENT?

I double checked the MySQL port and IP address, both match the advanced settings file.

No idea - there's nothing to go on (and I'm no expert). I'd suggest posting a debug log as a starting point.

NeoDuck · 2016-01-09, 02:43

(2016-01-09, 02:40)trogggy Wrote:
(2016-01-09, 02:33)NeoDuck Wrote:
(2016-01-09, 02:19)trogggy Wrote: No.

Why do you think my client machines can't SET CONTENT?

I double checked the MySQL port and IP address, both match the advanced settings file.

No idea - there's nothing to go on (and I'm no expert). I'd suggest posting a debug log as a starting point.

Yes, it is weird. It was working before. I had to redo my torrent / Kodi MySQL machine.

I will get a debug going and see what is going on, thanks!

kassysimon · 2016-01-09, 02:44

Post up your advance setting xml file. Just remove your IP address'.

Ill take a look. But I doubt it's this.

Does each instace of kodi not save the set content selection?

Redwingsfansfc · 2016-01-09, 04:40

Almost Guarantee it's a MySQL corrupt db like you had a few months ago. Close all kodi instances, then drop the database, and restart one instance of kodi and set content.

NeoDuck · (This post was last modified: 2016-01-09, 06:46 by NeoDuck.)

Thank you everyone for your help! I totally forgot about the log file thing. I saw what was wrong:

Code:
36:10 T:6596   ERROR: SQL: Can't create new database: 'MyMusic52' (1044)

36:10 T:6596   ERROR: Unable to open database: MyMusic52 (0)

36:10 T:6596   ERROR: Unable to create new database

36:10 T:6596   ERROR: Unable to open database: MyVideos93 [1044](Access denied for user 'kodi'@'%' to database 'myvideos93')

36:10 T:6596   ERROR: Unable to open database: MyVideos92 [1044](Access denied for user 'kodi'@'%' to database 'myvideos92')

36:10 T:6596   ERROR: Unable to open database: MyVideos91 [1044](Access denied for user 'kodi'@'%' to database 'myvideos91')

36:10 T:6596   ERROR: Unable to open database: MyVideos90 [1044](Access denied for user 'kodi'@'%' to database 'myvideos90')

36:10 T:6596   ERROR: Unable to open database: MyVideos89 [1044](Access denied for user 'kodi'@'%' to database 'myvideos89')

36:10 T:6596   ERROR: Unable to open database: MyVideos88 [1044](Access denied for user 'kodi'@'%' to database 'myvideos88')

So, I opened the MySQL CLC and did this again:

Code:
GRANT ALL ON *.* TO 'kodi';

I probably forgot to end the command with a ; the first time I did it. Everything works now! Big Grin