[Support] MariaDB Official


Recommended Posts

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.

Link to comment
  • 4 weeks later...

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"

 

 

Link to comment
  • 2 months later...

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)]>

Link to comment

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 ;-)

Link to comment

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

Link to comment
  • 2 weeks later...

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 by bombz
Link to comment
  • 2 weeks later...
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

 

Link to comment
  • 1 month later...
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

 

Link to comment
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?

Link to comment
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.

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.