sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 Definitely not. kk.. restart the container if it is stopped... docker exec into again , cd to /config/databases and mv any file ending with .err (be very careful and make sure what you're doing) to .old exit out of the exec session, restart the docker exec back and paste the content of any new .err file Quote Link to comment
sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 meanwhile i'm trying to bust a test copy of mariadb to see if it logs the error.... Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 Step 1: Move .err files... root@Gallifrey:~# docker exec -it mariadb /bin/bash root@aab3299b69a3:/# cd /config/databases root@aab3299b69a3:/config/databases# ls -l total 176347 -rw-r----- 1 abc users 20089 Nov 12 21:29 4325730b7f89.err -rw-rw---- 1 abc users 16384 Nov 14 03:23 aria_log.00000001 -rw-rw---- 1 abc users 52 Nov 14 03:23 aria_log_control -rw-rw---- 1 abc users 50331648 Nov 14 03:23 ib_logfile0 -rw-rw---- 1 abc users 50331648 Nov 14 03:23 ib_logfile1 -rw-rw---- 1 abc users 79691776 Nov 14 03:23 ibdata1 -rw-rw---- 1 abc users 0 Oct 12 20:50 multi-master.info drwx------ 2 mysql users 2976 Oct 12 20:50 mysql drwx------ 2 abc users 1512 Nov 8 19:10 owncloud drwx------ 2 abc users 2744 Oct 12 20:50 performance_schema root@aab3299b69a3:/config/databases# mv 4325730b7f89.err 4325730b7f89.old root@aab3299b69a3:/config/databases# exit exit Step 2: Restart docker from unRAID admin Step 3: No new .err file created. Quote Link to comment
sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 i forcefully deleted all the files in the mysql folder and now docker log is full of this 151115 02:17:33 mysqld_safe Starting mysqld daemon with databases from /config/databases 151115 02:17:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended over and over. but the .err file is written and tells me i don't have any tables in databases Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 My unRAID log is still saying this: 151114 21:21:36 mysqld_safe Starting mysqld daemon with databases from /config/databases 151114 21:21:36 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 151114 21:21:37 mysqld_safe Logging to '/config/databases/aab3299b69a3.err'. 151114 21:21:37 mysqld_safe Starting mysqld daemon with databases from /config/databases 151114 21:21:37 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended etc Quote Link to comment
sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 -rw-r----- 1 abc abc 998K Nov 15 02:24 Docker-Server.err -rw-rw---- 1 abc abc 16K Nov 15 02:15 aria_log.00000001 -rw-rw---- 1 abc abc 52 Nov 15 02:15 aria_log_control -rw-rw---- 1 abc abc 48M Nov 15 02:24 ib_logfile0 -rw-rw---- 1 abc abc 48M Nov 15 02:14 ib_logfile1 -rw-rw---- 1 abc abc 12M Nov 15 02:15 ibdata1 -rw-rw---- 1 abc abc 0 Nov 15 02:14 multi-master.info drwx------ 2 abc abc 4.0K Nov 15 02:14 mysql drwx------ 2 abc abc 4.0K Nov 14 20:16 performance_schema your mysql folder has different ownership to mine. Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 I have no idea where that abc user came from. Nothing I've personally created, but I did notice reference in my.cnf to an abc user when I was trying to figure this out earlier. Didn't touch it, haven't changed anything. Quote Link to comment
sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 I have no idea where that abc user came from. Nothing I've personally created, but I did notice reference in my.cnf to an abc user when I was trying to figure this out earlier. Didn't touch it, haven't changed anything. abc is the user we (linuxserver) create to run services etc inside of the docker. it's transparent to unraid users because it's preset in the template but for other systems it allows people to set uid and gid to match their host user. anyways, long and short, for some reason that folder has changed ownership. from the unraid terminal run this docker exec -it mariadb find /config/databases \! -user abc -print there shouldn't be any output normally.... Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 Well... root@Gallifrey:~# docker exec -it mariadb find /config/databases \! -user abc -print /config/databases /config/databases/mysql Quote Link to comment
sparklyballs Posted November 15, 2015 Share Posted November 15, 2015 dr who fan eh ? anyways, i think we're closing in on what's going on. docker exec back into the container and once inside the container run... chown -R abc:abc /config then exit out and restart the container. i changed those two folders to be owned by mysql:users and my mariad instance didn't start. the good news is the only things affected are two folders and none of the files within them. the bad news is i don't why it would have happened, the only thing i can think of is running unraid newperms script. Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 A fan for 40 years and counting. OK, commands have been run, and so far the log looks like this: ----------------------------------- _ _ _ | |___| (_) ___ | / __| | |/ _ \ | \__ \ | | (_) | |_|___/ |_|\___/ |_| Brought to you by linuxserver.io ----------------------------------- GID/UID ----------------------------------- User uid: 99 User gid: 100 ----------------------------------- We are now refreshing packages from apt repositorys, this *may* take a while Nov 14 21:45:19 aab3299b69a3 syslog-ng[59]: syslog-ng starting up; version='3.5.3' 151114 21:45:19 mysqld_safe Logging to '/config/databases/aab3299b69a3.err'. 151114 21:45:19 mysqld_safe Starting mysqld daemon with databases from /config/databases No repeating itself over and over. And most importantly I can now connect to the MySQL server from another computer using the root account. I'll now enable the ownCloud docker and see if it connects ok. Will post back when I find out. Thank you for your help! But FYI, I haven't run the newperms script at all since I originally installed MariaDB. Quote Link to comment
ridge Posted November 15, 2015 Share Posted November 15, 2015 So ownCloud now works, therefore I'm at 100% working again. Thanks for your help! Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 I'm hoping you can help as I'm about through the laptop out of the window. I've been trying for ages to set up the mariadb docker and eventually the kodi docker. I've both up and running however I cant connect to the the database at all. I've installed mysql workbench and tried connecting to the server but connection is always refused. I've found this whole process exceptionally frustrating and am hoping you guys can help please. Kind regards Scott Quote Link to comment
j0nnymoe Posted December 22, 2015 Share Posted December 22, 2015 I'm hoping you can help as I'm about through the laptop out of the window. I've been trying for ages to set up the mariadb docker and eventually the kodi docker. I've both up and running however I cant connect to the the database at all. I've installed mysql workbench and tried connecting to the server but connection is always refused. I've found this whole process exceptionally frustrating and am hoping you guys can help please. Kind regards Scott Hi Scott, could you post some more information for us please? For example, what details are you putting into MySQL Workbench/system logs etc Thanks Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 Hostname: 192.168.1.105 = Ip address of unraid server port 3306 Username: root Password: (i've specified a password and typed it in) Connection method standard tcp/ip When trying to connect, it appears as if it cant find the server. In terms of system logs, where do I get them from? Quote Link to comment
sparklyballs Posted December 22, 2015 Share Posted December 22, 2015 mysql workbench doesn't work with mariadb 10 Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 I tried heidisql it has the same issue. its as if the db server doesnt exist Im stuck on what to do. Quote Link to comment
sparklyballs Posted December 22, 2015 Share Posted December 22, 2015 I tried heidisql it has the same issue. its as if the db server doesnt exist Im stuck on what to do. command line docker exec -it mariadb bash mysql -uroot -p CREATE USER 'kodi' IDENTIFIED BY 'kodi'; GRANT ALL ON *.* TO 'kodi'; flush privileges; exit exit Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 After I run the mysql -uroot -p command, I get this message "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")" Quote Link to comment
CHBMB Posted December 22, 2015 Share Posted December 22, 2015 After I run the mysql -uroot -p command, I get this message "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")" Can you post a screenshot or something of how you have your docker container setup... (the bit where you fill in ports, folders etc) Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 Attached as requested, I've no Idea if I've done it correctly Quote Link to comment
sparklyballs Posted December 22, 2015 Share Posted December 22, 2015 Attached as requested, I've no Idea if I've done it correctly is appData share set to cache only ? Quote Link to comment
ScotlandThomas Posted December 22, 2015 Share Posted December 22, 2015 yes, If thats set up wrong then please let me know the best way to set it up. Thanks in advance. Scott Quote Link to comment
Marvel Posted December 22, 2015 Share Posted December 22, 2015 Hi. This has happened twice now after the first time i scrapped my original setup and started again but this time i would like to try and find the problem. I run mariadb for my kodi boxes. For some reason my unraid web page froze so i had to manually reboot the server, and when the server comes back mariadb doesnt seem to work anymore. All my media is missing from kodi. Heres a screen shot of the log There isn't a .err file in my config folder Quote Link to comment
sparklyballs Posted December 22, 2015 Share Posted December 22, 2015 Hi. This has happened twice now after the first time i scrapped my original setup and started again but this time i would like to try and find the problem. I run mariadb for my kodi boxes. For some reason my unraid web page froze so i had to manually reboot the server, and when the server comes back mariadb doesnt seem to work anymore. All my media is missing from kodi. Heres a screen shot of the log There isn't a .err file in my config folder i've just pushed a build to the dockerhub to mitigate this while we work on a permanent fix, i believe i the issue is related to not being able to answer a dialog when updating to a later version of mariadb. hopefully pulling the newer build shouldn't affect your data. 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.