MYSQL on remote linux server
#1
Hi,

I want to setup MySQL server for database files on a linux server. Kodi will run on windows

I followed on Linux server
http://kodi.wiki/view/MySQL/Setting_up_MySQL
using bind-address = 0.0.0.0

Then I try to follow on Windows Kodi:
http://kodi.wiki/view/MySQL/Setting_up_MySQL

When I run Kodi, I see the same sources (basically samba shares). But I try to set content and doesn't work, I go back and content is unset. My movies are not scrapped and not shown on Kodi.

What am I doing wrong? How can I see if MySQL server is actually receiving requests from Windows Kodi? And where should database files be saved on Linux server?

Thanks!

-J
Reply
#2
I got this on the log

21:53:49 T:13244 ERROR: Unable to open database: MyMusic56 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic55 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic54 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic53 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic52 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic51 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic50 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic49 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic48 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic47 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic46 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic45 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic44 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic43 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic42 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic41 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic40 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic39 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic38 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic37 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic36 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic35 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic34 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic33 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic32 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic56 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to create new database
21:53:49 T:13244 ERROR: Unable to open database: MyVideos99 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos98 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos97 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos96 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos95 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos94 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos93 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos92 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos91 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos90 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos89 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos88 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos87 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos86 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos85 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos84 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos83 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos82 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos81 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos80 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos79 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos78 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos77 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos76 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos75 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos99 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)


I thought the following config would be enough

#bind-address = 127.0.0.1
bind-address = 0.0.0.0.0

What am I missing?
Reply
#3
1) in order to avoid littering forum's database with logs use pastebin to post log files, always post full debug log - read http://kodi.wiki/view/Log_file first
2) from the snippet you posted it looks like kodi user lacks permissions to create a new database, recheck you did the "GRANT" step right.

To check kodi (assuming you named your user 'kodi') user rights you could run this query on mysql server:
Code:
SHOW GRANTS FOR 'kodi';
Reply
#4
Ohhh

Thanks.. I'm new to SQL and I didn't understand that all commands end with a ';'
Perhaps you wan to do this clear in the wiki

-J
Reply
#5
Hey guys, I'm new to mysql, so I have one question regarding mysql and kodi: Is it really necessary to grant all privileges to the kodi-user? Isn't this a bit dangerous if you are hosting some other services like owncloud or similar and don't have a dedicated mysql-server for kodi?

edit:

I did it like that now:

Global privileges only: CREATE, ALTER (so it can create those "MyVideo..." and "MyMusic..." Databases)
Database privileges for "My%": all privileges

At the moment everything seems fine, but can some of the devs tell me if I'm going to have problems, maybe after an kodi-update?
Reply
#6
@Pyromaniac if you actually _read_ the wiki you'll find that there is an "8" tab with commands to restrict kodi user rights
http://kodi.wiki/view/MySQL/Setting_up_M...ess_rights
Reply
#7
Thanks asavah, I _have read_ the wiki, this part of the WIKI: http://kodi.wiki/view/MySQL/Setting_up_Kodi and unfortunately I haven't read all 1000 pages of the wiki, I'm sorry.
In the link I have found, there is no information about my question, but in your link it is. So, what I did was correct, thanks. But I still don't know, if updates can result in problems with my configuration for "GLOBAL PRIVILEGES", thats why I asked.

So, again, are more privileges needed for kodi to create its database(s) in case of an update/new installation?
Reply

Logout Mark Read Team Forum Stats Members Help
MYSQL on remote linux server0