December 25, 20187 yr 2 hours ago, stormense said: In Unraid no problem with no password but if I put in one in key 3 I got this: # mysql -u root -p Enter password: mypassword ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) # And when try to create a database with root user with no password I get this error: MariaDB [(none)]> CREATE USER 'kodi' IDENTIFIED BY 'kodi'; ERROR 1396 (HY000): Operation CREATE USER failed for 'kodi'@'%' Setting the password only works the first time when you create the container. Look at the Readme on github for instructions. Link in first post.
January 9, 20197 yr I don’t have any experience really with mariadb and I’m a little confused by the instructions in dockerhub- Quote NOTE changing the MYSQL_ROOT_PASSWORD variable after the container has set up the initial databases has no effect, use the mysqladmin tool to change your mariadb password. Unraid users, it is advisable to edit the template/webui after setup and remove reference to this variable. Is this the correct process- 1. Install the docker with a MySQL root password variable defined in the template. 2. Run Quote docker exec -it mariadb bash mysqladmin -u root password <PASSWORD> to change that password after the docker is running. 3. Delete the MySQL root password variable in the template and restart the docker. 4. Run the Kodi dB setup- Quote docker exec -it mariadb bash mysql -uroot -p CREATE USER ‘mrmc’ IDENTIFIED BY ‘mrmc’; GRANT ALL ON *.* TO ‘mrmc’; flush privileges; exit exit Or have I totally misunderstood the instructions?😁 Edited January 9, 20197 yr by wgstarks
January 9, 20197 yr 1 hour ago, wgstarks said: I don’t have any experience really with mariadb and I’m a little confused by the instructions in dockerhub- Is this the correct process- 1. Install the docker with a MySQL root password variable defined in the template. 2. Run to change that password after the docker is running. 3. Delete the MySQL root password variable in the template and restart the docker. 4. Run the Kodi dB setup- Or have I totally misunderstood the instructions?😁 You don't have to change the password after you set it in the template before installing. The password is only set at first start, so if you want to change the password at a later time, you need to execute into the container to change it. The reason we ask unraid users to remove the password from the template is that it's easy for some to get hold of it in the template.
January 9, 20197 yr 30 minutes ago, saarg said: You don't have to change the password after you set it in the template before installing. The password is only set at first start, so if you want to change the password at a later time, you need to execute into the container to change it. The reason we ask unraid users to remove the password from the template is that it's easy for some to get hold of it in the template. Thanks. Was wondering why I would set a password just to turn around and change it immediately afterwords. I’m guessing everything else is correct?
January 10, 20197 yr I used this to set up the db for MrMC but don't I also need to set a user password in the docker? docker exec -it mariadb bash mysql -uroot -p CREATE USER ‘mrmc’ IDENTIFIED BY ‘mrmc’; GRANT ALL ON *.* TO ‘mrmc’; flush privileges; exit exit
January 11, 20197 yr I cannot get a password to work with this container no matter what I try. I have tried leaving it at the default password and tried setting one. I tried deleting the logs, and tried using the console to set it. # mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) # mysqladmin -u root -p password password Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'
January 11, 20197 yr From the instructions linked in the first post- Quote -e MYSQL_ROOT_PASSWORD - set this to root password for installation (minimum 4 characters) Your password must be at least 4 letters. Edit: You can run mysqladmin -u root password <PASSWORD> to set a new password. Edited January 11, 20197 yr by wgstarks
January 11, 20197 yr I tried that, in that same example, right after I tried just logging in. Also, the first password I set was over 4 characters. I did notice though that when I try and log in I get access denied, but when I use mysqladmin it says connection failed Edited January 11, 20197 yr by Crilith
January 11, 20197 yr Is there a chance that the password may have had special characters that might not be supported? At this point it might be easier just to nuke the docker and start over (if you haven’t already). Delete the docker and image. Delete the docker’s appdata folder. Re-install and configure from scratch. Just an idea. Someone else may have better advice. Edited January 11, 20197 yr by wgstarks
January 12, 20197 yr 20 hours ago, wgstarks said: At this point it might be easier just to nuke the docker and start over (if you haven’t already). Delete the docker and image. Delete the docker’s appdata folder. Re-install 2 I tried this many times but never deleted the appdata. That fixed it. Thank you.
January 18, 20197 yr HI, Installed this as I need it to use Nextcloud. Entered a master root pass in the Mariadb setup. Thought I could just enter the IP of server with port. DB user/name password and the DB be created from Nextcloud on Mariadb. How do I make a database? Thanks
January 18, 20197 yr To create a user you'll need to open a terminal window and enter docker exec -it mariadb bash mysql -uroot -p CREATE USER ‘<username>’ IDENTIFIED BY ‘<password>’; You should avoid special characters. Once you have created the user and password you should be able to connect. Is this what you did?
January 19, 20197 yr I'm trying to setup mariaDB and nextcloud for the first time. Setting up mariaDB went smoothly but I keep getting 504 errors when trying to connect to mariaDB in nextcloud WebUI on initial setup.
January 19, 20197 yr Have you seen the YouTube video by @SpaceInvaderOne? https://m.youtube.com/watch?v=fUPmVZ9CgtM
January 19, 20197 yr Yes. That's the video I followed. I watched the video again and saw that I was inputting the port number for nextcloud container instead of mariaDB. Problem solved. Edited January 19, 20197 yr by Otacon
January 31, 20197 yr Does any1 know if there's a way to access the Mariadb from the web.... I mean I kind of need a user to access the database from the outside of my network..... I've look on the internet and at the moment people don't seem to try to so I'm kind of lost.... If any1 could have any idea it would be awesome... Thanks
January 31, 20197 yr 6 hours ago, LifeBasher said: Does any1 know if there's a way to access the Mariadb from the web.... I mean I kind of need a user to access the database from the outside of my network..... I've look on the internet and at the moment people don't seem to try to so I'm kind of lost.... If any1 could have any idea it would be awesome... Thanks I would recommend OpenVPN server. It can be installed in a VM on your unRAID server or on many routers. There is also the OpenVPN-AS docker from LSIO (just search on CA). Fairly easy to setup if you watch @SpaceInvaderOne‘s video.
February 8, 20197 yr So I am trying to create a database for my Home-Assistant. I think I have everything setup but I am trying to figure out where my database file is getting saved. Is there a way to determine this and also change it. I want to save it to a specific disk/folder but not sure how to do this.
February 8, 20197 yr 1 hour ago, mgranger said: I want to save it to a specific disk/folder but not sure how to do this It's saved in your /config folder (ie: your appdata share). It you want it to be on a different disk than say your sql database for kodi, then you've got to install a second instance of the app and set it's /config accordingly
March 26, 20197 yr Need some help with troubleshooting a problem I am having with mariadb locking up. I just upgraded an Intel NUC to LibreELEC 9.0.1. I have been using mariadb to hold my Kodi database for quite a while, and everything has been working great. Now a week after the upgrade my machine is not being able to access the databases stored in mariadb. I have looked at the Kodi log files and see where Kodi is trying to access the database, but is unable to. ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (115)) (Address replaced with x) I have verified that the IP address, user, and password is correct. Nothing there has changed since it has been working for quite a while. When I attempt to connect to maraiadb with HeidiSQL from another machine I am unable to, it just hangs. I then have to restart the docker to be able to connect. I have looked in the syslog on my unRAID server, but the only thing I see that has any connection with mariadb is: kernel: traps: mysqld[10787] general protection ip:55fabff0322f sp:14757c0ab7f8 error:0 in mysqld[55fabf96a000+122a000] I have checked the database for corruption but did not find any. Are there any other log files I can investigate? I am running unRAID 6.5.3 with what I believe is the latest version of this docker. Any help is appreciated.
March 26, 20197 yr 2 hours ago, gmythx said: Need some help with troubleshooting a problem I am having with mariadb locking up. I just upgraded an Intel NUC to LibreELEC 9.0.1. I have been using mariadb to hold my Kodi database for quite a while, and everything has been working great. Now a week after the upgrade my machine is not being able to access the databases stored in mariadb. I have looked at the Kodi log files and see where Kodi is trying to access the database, but is unable to. ERROR: Unable to open database: MyVideos116 [2002](Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (115)) (Address replaced with x) I have verified that the IP address, user, and password is correct. Nothing there has changed since it has been working for quite a while. When I attempt to connect to maraiadb with HeidiSQL from another machine I am unable to, it just hangs. I then have to restart the docker to be able to connect. I have looked in the syslog on my unRAID server, but the only thing I see that has any connection with mariadb is: kernel: traps: mysqld[10787] general protection ip:55fabff0322f sp:14757c0ab7f8 error:0 in mysqld[55fabf96a000+122a000] I have checked the database for corruption but did not find any. Are there any other log files I can investigate? I am running unRAID 6.5.3 with what I believe is the latest version of this docker. Any help is appreciated. Docker logs for the MariaDB container would be useful.
March 26, 20197 yr 6 minutes ago, CHBMB said: Docker logs for the MariaDB container would be useful. Sorry about that... I did forget to mention these, but that may be because I did not see anything out of the ordinary. But here they are. When I could not gain access through HeidiSQL I would restart the docker. _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io We gratefully accept donations at:https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 190326 01:17:08 mysqld_safe Logging to syslog. 190326 01:17:08 mysqld_safe Starting mysqld daemon with databases from /config/databases Caught SIGTERM signal! [cont-finish.d] executing container finish scripts... [cont-finish.d] done. [s6-finish] waiting for services. [s6-finish] sending all processes the TERM signal. [s6-finish] sending all processes the KILL signal and exiting. [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 10-adduser: executing... usermod: no changes ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io We gratefully accept donations at:https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 190326 01:39:10 mysqld_safe Logging to syslog. 190326 01:39:10 mysqld_safe Starting mysqld daemon with databases from /config/databases Caught SIGTERM signal! [cont-finish.d] executing container finish scripts... [cont-finish.d] done. [s6-finish] waiting for services. [s6-finish] sending all processes the TERM signal. [s6-finish] sending all processes the KILL signal and exiting. [s6-init] making user provided files available at /var/run/s6/etc...exited 0. [s6-init] ensuring user provided files have correct perms...exited 0. [fix-attrs.d] applying ownership & permissions fixes... [fix-attrs.d] done. [cont-init.d] executing container initialization scripts... [cont-init.d] 10-adduser: executing... usermod: no changes ------------------------------------- _ () | | ___ _ __ | | / __| | | / \ | | \__ \ | | | () | |_| |___/ |_| \__/ Brought to you by linuxserver.io We gratefully accept donations at:https://www.linuxserver.io/donate/ ------------------------------------- GID/UID ------------------------------------- User uid: 99 User gid: 100 ------------------------------------- [cont-init.d] 10-adduser: exited 0. [cont-init.d] 30-config: executing... [cont-init.d] 30-config: exited 0. [cont-init.d] 40-initialise-db: executing... [cont-init.d] 40-initialise-db: exited 0. [cont-init.d] done. [services.d] starting services [services.d] done. 190326 01:55:25 mysqld_safe Logging to syslog. 190326 01:55:25 mysqld_safe Starting mysqld daemon with databases from /config/databases
March 29, 20197 yr Looking to load an XML file (itunes library.xml) into a database. However it seem this container doesn't have CONNECT installed with mariadb. I am requesting this be added into the container build
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.