Mysql - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: iOS & tvOS (https://forum.kodi.tv/forumdisplay.php?fid=137) +---- Thread: Mysql (/showthread.php?tid=114345) |
Mysql - BULLIT - 2011-11-10 Hey Guys, Trying to set up MySQL db on my apple TV 2g. I noticed in Workbench that the tables are not coming in. So I took a look at the XBMC.log file and I'm getting this ERROR alot, 19:06:11 T:82640896 ERROR: Unable to open database: adult_video57 [2003](Can't connect to MySQL server on '192.168.0.103' (61)) I'm running, Nightly xbmc-20111108-b499c47-master-atv2.deb Here is my log, http://pastebin.ubuntu.com/734269/ I know this is probably a MySQL issue and not a XBMC on apple tv issue. Just wondering if anyone can point me in the right direction. Thanks. - muggi - 2011-11-10 BULLIT Wrote:Hey Guys, hi have you a user "xbmc" with all access on your mysql server? is your database correct? - BULLIT - 2011-11-10 muggi Wrote:hi Thanks for the reply, Actually I am using the name "adult". I followed the lifehacker.com guide and replaced every "xbmc" with "adult". My advancedsettings.xml in my log file has the correct settings. I also did the SHOW DATABASE; command and the names are correct. I am thinking maybe port 3306 is not open, Anyone know how to check if it is open in Ubuntu? - Memphiz - 2011-11-10 Code: nmap -sS -P0 192.168.0.103 -p3306 - BULLIT - 2011-11-10 Memphiz Wrote: Port is closed, Ha. Thanks, now how do I open it? Starting Nmap 5.21 ( http://nmap.org ) at 2011-11-10 12:57 MST Nmap scan report for PC Name (192.168.0.103) Host is up (0.000077s latency). PORT STATE SERVICE 3306/tcp closed mysql - BULLIT - 2011-11-11 Alright, Got the port part out of the way. I had to change the bind address in my mysql my.cnf file. For anyone else who may run into this prob, it is located in Ubuntu, /etc/mysql.my.cnf Change the bind address from 127.0.0.1 to the Servers IP. Got this after I did that, Code: krypton@krypton-MS-7623:~$ sudo nmap -sS -P0 192.168.0.103 -p3306 Now, restarted XBMC and this ERROR is in the logs now, Code: 18:39:39 T:87044096 DEBUG: Connecting to mysql:192.168.0.103:adult_video57 Any more help would be great. Thanks. EDIT: Forgot log, http://pastebin.ubuntu.com/734886/ - BULLIT - 2011-11-11 Alright, Did some fiddling around with MySQL some more and dropped the users and databases and redid the whole thing. I'm now getting this, Code: 20:43:14 T:97677312 DEBUG: Connecting to mysql:192.168.0.103:adult_video57 And This, Code: 20:43:16 T:97677312 DEBUG: Connecting to mysql:192.168.0.103:adult_video Any Thoughts? - BULLIT - 2011-11-11 Alright. Got it. Found a buried post that says let XBMC create the DB's in MySQL. So I dropped the DB's and reran XBMC, Created the DB's just fine. Well, Thanks for the help guys, and letting me rattle off...... One last thing, Should I remove, <name>adult_video</name> From the advancesettings? - muggi - 2011-11-11 BULLIT Wrote:Alright. Got it. Found a buried post that says let XBMC create the DB's in MySQL. So I dropped the DB's and reran XBMC, Created the DB's just fine. hi if you delete the db name, xbmc search for the defaultname + dbVersion. For exapmple db name: MyVideos57 - Rumik - 2011-11-15 Hi, I could really use some help with this. Took me all night to get my SQL server running on my NAS, and finally got XBMC to connect to the database. The problem is, if I create the databases myself then I get the "Unexpectedly Empty" error, and if I drop them and load up XBMC, it doesn't do anything. What's worse is, if I leave my Databases folder intact, XBMC will just use that instead of SQL. No errors now in the log, no mention of SQL at all besides what's in the advancedsettings.xml file. EDIT: Actually, I just realised that XBMC is creating a music db (xbmc_music18) but not a video database. Anyone have any ideas? Many thanks - Rumik - 2011-11-15 Ah, it was the too many connections error. I updated my max_connection setting to 100 and it's fine now - BULLIT - 2011-11-15 Rumik Wrote:Ah, it was the too many connections error. I updated my max_connection setting to 100 and it's fine now Can you explain how you upped your connections? Would like to do this as well. - Rumik - 2011-11-15 Sure I just edited the my.cnf file... there's a line there that says "max_connection". - BULLIT - 2011-11-15 Rumik Wrote:Sure I just edited the my.cnf file... there's a line there that says "max_connection". Thanks, Thought it was a command. Easy enough. - flipped cracker - 2011-12-09 BULLIT Wrote:Alright. Got it. Found a buried post that says let XBMC create the DB's in MySQL. So I dropped the DB's and reran XBMC, Created the DB's just fine. Thanks so much. I spent all day trying to fix this and your posted helped. |