May 6, 201511 yr Here's the pastebin: http://pastebin.com/j5rndL8C What causes this kind of "unable to open database" issue? The database does not exist, but it's also not creating it. Using HeidiSQL I can connect to 192.168.1.3 using username/password kodi/kodi. I can then verify username kodi. Username kodi has all privileges and has access from everywhere. I feel like I consistently get to points like this where something randomly stops working and there's no rhyme or reason why. Welcome to the world of Linux, huh? My guess is an uninstall followed by a clean install of Mariadb docker would get things up and running. The problem is, as my uses for my home server continue to grow and the database becomes more important, I don't want to have to rely on this as the "fix all" solution. Any idea what could be going wrong?
May 6, 201511 yr Author Sorry for lack of clarity. I'm using my home PC right now and an instance of Kodi to play with things. All of the random issues have begun once I've started trying to get all of these different dockers, virtual machines, and other client devices running linux OSes. I love linux, but it's certainly difficult to get all of these databases, dockers, vms, etc. to run nicely together. A fun challenge however! Any clues in the log file as to where the issue may lie?
May 6, 201511 yr Sorry for lack of clarity. I'm using my home PC right now and an instance of Kodi to play with things. All of the random issues have begun once I've started trying to get all of these different dockers, virtual machines, and other client devices running linux OSes. I love linux, but it's certainly difficult to get all of these databases, dockers, vms, etc. to run nicely together. A fun challenge however! Any clues in the log file as to where the issue may lie? you had some issues with openelec yesterday too ? i'm wondering if it's this http://lime-technology.com/forum/index.php?topic=39597.0
May 7, 201511 yr Author Sorry for lack of clarity. I'm using my home PC right now and an instance of Kodi to play with things. All of the random issues have begun once I've started trying to get all of these different dockers, virtual machines, and other client devices running linux OSes. I love linux, but it's certainly difficult to get all of these databases, dockers, vms, etc. to run nicely together. A fun challenge however! Any clues in the log file as to where the issue may lie? you had some issues with openelec yesterday too ? i'm wondering if it's this http://lime-technology.com/forum/index.php?topic=39597.0 Yeah, yesterday was OpenELEC. Today it's all devices. I'll take a look at the thread, thanks!!!
May 7, 201511 yr Author Correct me if I'm wrong, but it appears these are issues with the docker's communication with the internet and not the LAN. When my devices are trying to connect to mariadb, this is all LAN, right?
May 7, 201511 yr Author it's all network traffic of one kind or another though. Hmmm. Well I tried to change from bridge > host > bridge to no avail. I'm going to completely remove mariadb and reinstall to see what happens.
May 7, 201511 yr Author Now I'm just getting an error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Before I was able to connect through HeidiSQL. Now I can't. Interesting. I noticed that in the log for Mariadb I'm seeing a constant repeat of: Starting MariaDB... 150506 20:44:28 mysqld_safe Logging to '/db/mysql_safe.log'. 150506 20:44:28 mysqld_safe Starting mysqld daemon with databases from /db 150506 20:44:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Database exists.
May 7, 201511 yr Now I'm just getting an error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Before I was able to connect through HeidiSQL. Now I can't. Interesting. I noticed that in the log for Mariadb I'm seeing a constant repeat of: Starting MariaDB... 150506 20:44:28 mysqld_safe Logging to '/db/mysql_safe.log'. 150506 20:44:28 mysqld_safe Starting mysqld daemon with databases from /db 150506 20:44:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Database exists. constantly repeating ? , that doesn't sound good to me.
May 7, 201511 yr Author Now I'm just getting an error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Before I was able to connect through HeidiSQL. Now I can't. Interesting. I noticed that in the log for Mariadb I'm seeing a constant repeat of: Starting MariaDB... 150506 20:44:28 mysqld_safe Logging to '/db/mysql_safe.log'. 150506 20:44:28 mysqld_safe Starting mysqld daemon with databases from /db 150506 20:44:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Database exists. constantly repeating ? , that doesn't sound good to me. I just did a clean install too. Guess I could make sure to go into /appdata this time and delete all the folders/files.
May 7, 201511 yr Now I'm just getting an error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Before I was able to connect through HeidiSQL. Now I can't. Interesting. I noticed that in the log for Mariadb I'm seeing a constant repeat of: Starting MariaDB... 150506 20:44:28 mysqld_safe Logging to '/db/mysql_safe.log'. 150506 20:44:28 mysqld_safe Starting mysqld daemon with databases from /db 150506 20:44:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Database exists. constantly repeating ? , that doesn't sound good to me. I just did a clean install too. Guess I could make sure to go into /appdata this time and delete all the folders/files. you'll lose all of your mysql library and any other appdata for dockers etc.... unless you have a backup, you really don't want to do that.
May 7, 201511 yr Author Currently all I have on there is Kodi and the library isn't huge so I can just rebuild it.
May 7, 201511 yr Currently all I have on there is Kodi and the library isn't huge so I can just rebuild it. try my koma container , lol. in my main repo.
May 7, 201511 yr Author Koma? lol. I'll check it out. And a clean install worked. That's the thing that scares me with some of this stuff. It works beautifully one day, and then randomly one day, without any user changes, things stop working and I can't for the life of me figure out what got thrown off without a 100% "factory reset".
May 7, 201511 yr I had a really hard time with centralized Kodi database when I upgraded from Frodo to Helix... the answer was that I had databases for both Frodo and Gotham, and Kodi had a hard time upgrading the databases to Helix. Once I dropped the Gotham (which I never used - but probably tried) tables, it upgraded fine. It took a while if you have a large database. Not saying this is your issue, but it was a problem for me that took days to solve.
May 7, 201511 yr Hi I had exactly the same issue, the only way I can fix it to delete all the database files and create a new database, which of course does not have my watches movies/episodes data.
May 7, 201511 yr Hi I had exactly the same issue, the only way I can fix it to delete all the database files and create a new database, which of course does not have my watches movies/episodes data. Way to solve that is to periodically have kodi export your database to individual files (and overwrite them). Then when you create your new database and import the media files, there's an option in advancedsettings.xml to also import your watched status
May 7, 201511 yr Hi I had exactly the same issue, the only way I can fix it to delete all the database files and create a new database, which of course does not have my watches movies/episodes data. Way to solve that is to periodically have kodi export your database to individual files (and overwrite them). Then when you create your new database and import the media files, there's an option in advancedsettings.xml to also import your watched status There's also trakt.tv which can sync with Kodi and then you have an offline backup
May 7, 201511 yr Hi I had exactly the same issue, the only way I can fix it to delete all the database files and create a new database, which of course does not have my watches movies/episodes data. Way to solve that is to periodically have kodi export your database to individual files (and overwrite them). Then when you create your new database and import the media files, there's an option in advancedsettings.xml to also import your watched status There's also trakt.tv which can sync with Kodi and then you have an offline backup which kept crashing kodi last time i used that POS plugin.
May 8, 201511 yr Hi I had exactly the same issue, the only way I can fix it to delete all the database files and create a new database, which of course does not have my watches movies/episodes data. Way to solve that is to periodically have kodi export your database to individual files (and overwrite them). Then when you create your new database and import the media files, there's an option in advancedsettings.xml to also import your watched status There's also trakt.tv which can sync with Kodi and then you have an offline backup which kept crashing kodi last time i used that POS plugin. It's working for me with kodi and plex on windows (and iOS / Android clients for plex), there was a period that trakt changed the API within the last 6 months that broke things, but it's working for me now. Can't speak to how it works on other platforms
Archived
This topic is now archived and is closed to further replies.