[Support] MariaDB Official

[kirk69]

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

 

[kirk69]

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

 

[mgutt]

2 hours ago, kirk69 said:

how can i change the 2mb max size please?

Ask in the support thread of the phpmyadmin container.

[Kilrah]

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.

[mgutt]

How to create a dump is explained in the MariaDB description. As an alternative you could use HeidiSQL.

[kirk69]

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

[chrispy212]

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"

 

 

[mgutt]

20 hours ago, chrispy212 said:

skip-networking

Maybe because of this?!

[chrispy212]

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

[mgutt]

Ok, and the container works flawlessly without the command?

 

Which MariaDB Version is installed?

[irishjd]

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 [email protected]'localhost' = PASSWORD('complex_password');
Query OK, 0 rows affected (0.004 sec)

MariaDB [(none)]>

[mgutt]

33 minutes ago, irishjd said:

Here are the steps and responses I received trying to reset it:

Looks perfectly fine to me?!

[irishjd]

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.

[mgutt]

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

[irishjd]

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

[mgutt]

Did you remove skip-grant-tables?

 

PS you should not use the internal docker IPs as they can change at any time.

[irishjd]

yup...

 

[irishjd]

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

[mgutt]

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 

[irishjd]

Ahh, that makes sense...

[bombz]

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, 2022 by bombz

[Danuel]

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

 

[variants]

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

 

[mgutt]

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?

[variants]

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.