July 16, 20223 yr Hi thank you very much for your Help. I deleted the files and reinstall. Now i have a root access, I changed the random password genereted. I'm trying to configure with kodi.... anthor story hihihi thank so much and have a nice day
July 16, 20223 yr Hello, need another help please. I can not import my .db from kodi to mariadb form phpmyadmin. how can i change the 2mb max size please? by the console can not read .db
July 16, 20223 yr Author 2 hours ago, kirk69 said: how can i change the 2mb max size please? Ask in the support thread of the phpmyadmin container.
July 16, 20223 yr Neither phpmyadmin containers have forum support links defined. If you use the "other" phpmyadmin container (linuxserver) the limit is 8MB there. I tried changing it on both but have not managed to, even though the linuxsever one at least intends to have one I haven't managed to have it take. Adminer allows 128MB but you'll likely timeout if you send something anywhere that big. This might help you split your sql file: https://www.philiplb.de/sqldumpsplitter3/ I ended up using the linuxserver phpmyadmin, used the above to split my files to 10MB, then zipped them (brings them down to <8MB and then imported them in sequence.
July 16, 20223 yr Author How to create a dump is explained in the MariaDB description. As an alternative you could use HeidiSQL.
July 17, 20223 yr Ok thanks for your help. I find how to put informations from kodi directly into the database, making a scan best regards and have a nice day
August 9, 20223 yr Adding "mysqld_safe --skip-grant-tables --skip-networking" to post arguments for the purpose of resetting my root password causes the container to rapidly keep restarting. Trying to use the console gives me a flickering window with "reconnecting" and "connected," trying to attach via the host gives "Container [id] is not running"
August 10, 20223 yr Ah sorry I have tried without that also, no improvement. I added --skip-networking as it was suggested elsewhere this may alleviate the issue, but it didn't
August 10, 20223 yr Author Ok, and the container works flawlessly without the command? Which MariaDB Version is installed?
October 14, 20223 yr Not having any luck resetting my MariaDB Root pw. I followed the instructions in this post, but when I try to authenticate to it via adminer, I keep getting this error: "Access denied for user 'root'@'172.21.0.1' (using password: YES)" Here are the steps and responses I received trying to reset it: $ mariadb -u root Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.9.3-MariaDB-1:10.9.3+maria~ubu2204 mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.039 sec) MariaDB [(none)]> SET Password FOR root@'localhost' = PASSWORD('complex_password'); Query OK, 0 rows affected (0.004 sec) MariaDB [(none)]>
October 14, 20223 yr Author 33 minutes ago, irishjd said: Here are the steps and responses I received trying to reset it: Looks perfectly fine to me?!
October 15, 20223 yr Looks like I figured it out. I was using a really long (20 character) and complex password. When I shortened it, and took out the special characters, everything is fine.
October 15, 20223 yr Author 19 minutes ago, irishjd said: special characters That could be the reason. Some characters needed to be escaped to execute the "SET Password" command correctly: https://stackoverflow.com/a/881208/318765
October 15, 20223 yr Ahh... Between that and the fact that I can not log into the db from adminer with the root account, is driving me crazy. Adminer has no issues authenticating with any other db accounts, it's just the "root" account. I event tried this: GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES; but adminer still gives me this error: Access denied for user 'root'@'172.21.0.11' (using password: YES) It's not a huge deal as I can do admin work from the cli, but its just driving me nuts trying to figure out what the issue is. BTW, I am not a DBA, so I am probably overlooking something
October 15, 20223 yr Author Did you remove skip-grant-tables? PS you should not use the internal docker IPs as they can change at any time.
October 15, 20223 yr I went back to the config and told it to generate a random password, but it does not appear to be doing so: 2022-10-15 11:14:16 0 [Note] mariadbd (server 10.9.3-MariaDB-1:10.9.3+maria~ubu2204) starting as process 1 ... 2022-10-15 11:14:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-10-15 11:14:16 0 [Note] InnoDB: Number of transaction pools: 1 2022-10-15 11:14:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-10-15 11:14:16 0 [Note] InnoDB: Using liburing 2022-10-15 11:14:16 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB 2022-10-15 11:14:16 0 [Note] InnoDB: Completed initialization of buffer pool 2022-10-15 11:14:16 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) 2022-10-15 11:14:16 0 [Note] InnoDB: 128 rollback segments are active. 2022-10-15 11:14:16 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ... 2022-10-15 11:14:16 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB. 2022-10-15 11:14:16 0 [Note] InnoDB: log sequence number 273003; transaction id 325 2022-10-15 11:14:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-10-15 11:14:16 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2022-10-15 11:14:16 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work. 2022-10-15 11:14:16 0 [Note] Server socket created on IP: '0.0.0.0'. 2022-10-15 11:14:16 0 [Note] Server socket created on IP: '::'. 2022-10-15 11:14:16 0 [Note] InnoDB: Buffer pool(s) load completed at 221015 11:14:16 2022-10-15 11:14:16 0 [Note] mariadbd: ready for connections. Version: '10.9.3-MariaDB-1:10.9.3+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2022-10-15 11:14:15-05:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:10.9.3+maria~ubu2204 started. 2022-10-15 11:14:16-05:00 [Note] [Entrypoint]: MariaDB upgrade not required
October 15, 20223 yr Author 17 minutes ago, irishjd said: I went back to the config and told it to generate a random password, but it does not appear to be doing so: This only done on initial installation
October 27, 20223 yr Good day all, I have been reading some guides on how to backup (export) my mariadb databases via console.... as I would like to restore (import) them to another SQL docker container. I am not the most experienced db user with the CLI. I have tried the following commands without success from console docker exec CONTAINER_id /usr/bin/mysqldump -uusername --password=yourpassword databasename> backup.sql mysqldump -u username -p database_name > dump.sql mysqldump -u username -p database_name > data-dump.sql Each time, after running the above commands, the response in mariadb console is -> -> If i add a ; at the end of each command it prompts a syntax error. Clearly I am not understanding something here and was curious if anyone has had experience with this process. Thank you, Edited October 27, 20223 yr by bombz
November 4, 20223 yr On 10/27/2022 at 1:17 AM, bombz said: Good day all, I have been reading some guides on how to backup (export) my mariadb databases via console.... as I would like to restore (import) them to another SQL docker container. I am not the most experienced db user with the CLI. I have tried the following commands without success from console docker exec CONTAINER_id /usr/bin/mysqldump -uusername --password=yourpassword databasename> backup.sql mysqldump -u username -p database_name > dump.sql mysqldump -u username -p database_name > data-dump.sql Each time, after running the above commands, the response in mariadb console is -> -> If i add a ; at the end of each command it prompts a syntax error. Clearly I am not understanding something here and was curious if anyone has had experience with this process. Thank you, try this mysqldump -uusername -ppassword databasename > /location/name.sql example: mysqldump -uuser -ppassword nextcloud > /mnt/user/backup/dbbackup/nextcloud.sql
December 5, 20223 yr Spoiler Spoiler Hello, I am using the MariaDB docker to make some databases for some of my local minecraft servers, one of them is using a plugin that creates a map of the world called dynmap. the issue is that after the server starts up fine a few moments later I start seeing these errors of too many connections, then slowly the rest of the plugins that I used that also need a database start to complain about too many connections as well. I tried to create a 'connections.cnf' file in '/mnt/user/appdata/mariadb-official/config' with [mysqld] max_connections=1000 but it doesn't seem to change anything, in adminer I can see the variables and it is still shown as the default value, I tried adding a space as well before and after the equals sign but it still did not change when restarting the mariadb docker [13:57:54 ERROR]: [dynmap] SQLException: Tile read error [13:57:54 ERROR]: [dynmap] ErrorCode: 0, SQLState=08001 [13:57:54 ERROR]: [dynmap] Message: Could not create connection to database server. Attempted reconnect 3 times. Giving up. [13:57:54 ERROR]: [dynmap] ConnectionString: jdbc:mysql://10.10.22.3:3306/server_dynmap?allowReconnect=true&autoReconnect=true [13:57:54 ERROR]: [dynmap] CausedBy: Too many connections [13:57:59 ERROR]: [dynmap] SQLException: Tile exists error [13:57:59 ERROR]: [dynmap] ErrorCode: 0, SQLState=08001 [13:57:59 ERROR]: [dynmap] Message: Could not create connection to database server. Attempted reconnect 3 times. Giving up. [13:57:59 ERROR]: [dynmap] ConnectionString: jdbc:mysql://10.10.22.3:3306/server_dynmap?allowReconnect=true&autoReconnect=true [13:57:59 ERROR]: [dynmap] CausedBy: Too many connections
December 5, 20223 yr Author 1 hour ago, variants said: I am using the MariaDB docker to make some databases Multiple databases in a single container? I absolutely don't recommend this. Create a new Container with different paths. By that it's much easier to update, dump and configure your setup. 1 hour ago, variants said: , in adminer I can see the variables and it is still shown as the default value What is shown as the default. The 1000 or what? Did you restart the container after addinf the custom config?
December 8, 20223 yr On 12/5/2022 at 3:08 PM, mgutt said: Multiple databases in a single container? I absolutely don't recommend this. Create a new Container with different paths. By that it's much easier to update, dump and configure your setup. What is shown as the default. The 1000 or what? Did you restart the container after addinf the custom config? Hi the default was like 151 max connections I believe, I created another instance of maradb and now everything is running smoothly, thank you.
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.