Living Legend Posted May 5, 2015 Share Posted May 5, 2015 How does one go about editing the config file for mariadb when it's in a container? I want to make sure that it's set to take all incoming requests across the local network? Currently I'm having issues with one of my client devices with OpenELEC attempting to reach the databases. Quote Link to comment
sparklyballs Posted May 5, 2015 Share Posted May 5, 2015 How does one go about editing the config file for mariadb when it's in a container? I want to make sure that it's set to take all incoming requests across the local network? Currently I'm having issues with one of my client devices with OpenELEC attempting to reach the databases. are you using a container already or do you plan on making one ? what container are you using ? Quote Link to comment
Living Legend Posted May 5, 2015 Author Share Posted May 5, 2015 needo. is there a better one? Quote Link to comment
sparklyballs Posted May 5, 2015 Share Posted May 5, 2015 needo. is there a better one? if you're using needo's then it is already set to allow all. sed -i -e 's#\(bind-address.*=\).*#\1 0.0.0.0#g' /etc/mysql/my.cnf that line in the dockerfile does it. the fault is with your openelec setup, paste your advancedsettings.xml and your unraid ip. Quote Link to comment
Living Legend Posted May 5, 2015 Author Share Posted May 5, 2015 The IP of my unRAID server is 192.168.1.3 The advancedsettings.xml file is: <advancedsettings> <videodatabase> <type>mysql</type> <host>192.168.1.3</host> <port>3306</port> <user>kodi</user> <pass>kodi</pass> </videodatabase> <musicdatabase> <type>mysql</type> <host>192.168.1.3</host> <port>3306</port> <user>kodi</user> <pass>kodi</pass> </musicdatabase> </advancedsettings> It works on my regular computer. Used to work on my raspberry pi. Used to work on the chromebox until yesterday when it kept doing an infinite reboot loop. I can see it boot to the logo of Kodi, then we get to the default blue background screen for a split second before it goes back to the log for a few seconds. Rinse and repeat. Quote Link to comment
Living Legend Posted May 5, 2015 Author Share Posted May 5, 2015 Here's the debug log: http://pastebin.com/nLaHWzcz Quote Link to comment
sparklyballs Posted May 5, 2015 Share Posted May 5, 2015 it's connecting to your database. there is an issue elsewhere. Quote Link to comment
sparklyballs Posted May 5, 2015 Share Posted May 5, 2015 if it wasn't connecting the log entries here would keep recycling looking for increasing numbers in the databases ie.. MyMusic49 , MyMusic50 , MyMusic51 etc... and the same for the video database. 21:58:18 T:139684346562432 NOTICE: Running database version Addons16 21:58:18 T:139684346562432 DEBUG: Initialize, updating databases... 21:58:18 T:139684346562432 NOTICE: Running database version ViewModes6 21:58:18 T:139684346562432 NOTICE: Running database version Textures13 21:58:18 T:139684346562432 NOTICE: Running database version MyMusic48 21:58:18 T:139684346562432 NOTICE: Running database version MyVideos90 21:58:18 T:139684346562432 NOTICE: Running database version TV26 21:58:18 T:139684346562432 NOTICE: Running database version Epg8 Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 Agreed. I've come to the same conclusions I've tried posting over at the Kodi forums, but to no avail. The only thing is, if I delete the advancedsettings.xml file, I'm able to boot right into Kodi. This leads me to think that it has something to do with the way this file is interacting with the OS. Quote Link to comment
soana Posted May 6, 2015 Share Posted May 6, 2015 It works on my regular computer. Used to work on my raspberry pi. Used to work on the chromebox until yesterday when it kept doing an infinite reboot loop. I can see it boot to the logo of Kodi, then we get to the default blue background screen for a split second before it goes back to the log for a few seconds. Rinse and repeat. I had the same symptoms, try to restart docker and see if the MariaDb database is still working OK. In my case the docker.img file got corrupted and the MariaDb container was one of the ones corrupted, luckily I had a back-up and all is running OK now. Quote Link to comment
soana Posted May 6, 2015 Share Posted May 6, 2015 What other dockers are you using? in my case I suspect the urBackup since the issue started shortly after trying this docker out. Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 What other dockers are you using? in my case I suspect the urBackup since the issue started shortly after trying this docker out. urBackup is a big no-no on unraid because it makes changes to the underlying file system of docker.img. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 What other dockers are you using? in my case I suspect the urBackup since the issue started shortly after trying this docker out. urBackup is a big no-no on unraid because it makes changes to the underlying file system of docker.img. I don't have urBackup. I run other dockers like couchpotato, nzbget, sonarr, & plex. And again, the chromebox is the only client device that is having difficulties working with this advancedsettings.xml file. All other devices have this same file and connect to the db seamlessly. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 So I was messing around and now the docker tab at the top of my screen is gone! Any idea how to get it back? Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 So I was messing around and now the docker tab at the top of my screen is gone! Any idea how to get it back? mice, lol. have you disabled docker ? Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 After trying to remove mariadb it went away. So then I disabled docker and was going to recreate the img file and make the containers again. Now for some reason I can't seem to auto-create a new image file. Under settings>docker: Enable Docker: YES Default Image Size: 15GB Docker Image: /mnt/cache/unraiddocker.img But when I hit apply, it doesn't create the image or start docker and give the tab back. I broke more things now! Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 After trying to remove mariadb it went away. So then I disabled docker and was going to recreate the img file and make the containers again. Now for some reason I can't seem to auto-create a new image file. Under settings>docker: Enable Docker: YES Default Image Size: 15GB Docker Image: /mnt/cache/unraiddocker.img But when I hit apply, it doesn't create the image or start docker and give the tab back. I broke more things now! has your image always been called that ? drop to a terminal and look in /mnt/user and see if there is an image file there. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 No the image was originally docker.img There is no longer an image file, I was a dumb dumb and deleted it! That's why I'm trying to create a new one and I just gave it a completely new name. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 In the directions it says: You must specify an image file for Docker. The system will automatically create this file when the Docker service is first started. If you do not want Docker to run at all, set this field blank and click Start. Where do you click start? Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 In the directions it says: You must specify an image file for Docker. The system will automatically create this file when the Docker service is first started. If you do not want Docker to run at all, set this field blank and click Start. Where do you click start? enable docker , change from no to yes. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 This is what it looks like: I went to the terminal to type this and nothing changed: root@Tower:/etc/rc.d# rc.docker start starting docker ... root@Tower:/etc/rc.d# I can go into the /mnt/cache folder, and there is no image file for docker. Ruh-ohhh, what did I do? and yes I have hit done. Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 i can't swear to it, but that looks like some older version of the docker page, yet you are running beta 15. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 Any suggestions? I'll take the syslinux, bzimage, bzroot and repopulate my flash drive with them to see if anything changes. Quote Link to comment
sparklyballs Posted May 6, 2015 Share Posted May 6, 2015 Any suggestions? I'll take the syslinux, bzimage, bzroot and repopulate my flash drive with them to see if anything changes. woah, don't do that. get hold of someone more knowledgable here before doing anything that drastic. Quote Link to comment
Living Legend Posted May 6, 2015 Author Share Posted May 6, 2015 I'm talking about those 3 files from the latest version that just came out. I had one problem and I made another. Always something! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.