Comments - Getting Help With MariaDB

"I've set up SSL on the MariaDB server (version 10.11 on AlmaLinux), and it works as expected when connecting with the MariaDB client. However, when using the Windows ODBC driver (version 3.2.2), I encounter a 'no cipher match' error. Any ideas on how to resolve this? The exact error message is as follows:" --------------------------- Connection test --------------------------- Connection failed: [HY000] [ma-3.2.2]TLS/SSL error: no cipher match. Error 0x80090331(SEC_E_ALGORITHM_MISMATCH)

Connection String:

DRIVER={MariaDB ODBC 3.2 Driver};TCPIP=1;SERVER=x.x.x.x;UID=xxx;PWD=***;PORT=3306;SSLKEY=C:\xxxxx\client-key.pem;SSLCERT=C:\xxxxx\client-cert.pem;SSLCA=C:\xxxxx\ca-cert.pem;NULLISCURRENT=1;PSCACHESIZE=250;MAXCACHEKEY=2112;PCALLBACK=1 --------------------------- OK ---------------------------

I'm looking at `innodb_large_prefix` system variable. Previously it was included to go from 767 bytes max key length to 3072 bytes max key length.

It has since been removed. Is it removed due to it being undesirable to make this increase, or from 3072 now being the default max key length?

The default was ON, so 3072, for a long time prior to its removal - it's now no longer possible to reduce this.

In the selected fields of a query I had the following field statement:

ROUND(((od.price_incl-od.price_excl)*100/od.price_excl),1)) AS taxrate

That worked ok. I got values like "7.0" and "12.1".

The problem was that with small prices it is not accurate. So I had to add a clause that for small prices some other source will be used. So I got:

IF(od.price_excl < 1.0, rate, ROUND(((od.price_incl-od.price_excl)*100/od.price_excl),1))) AS taxrate

And now suddenly I get values like "7.000" and "12.100" returned when the ROUND statement is executed. There is still rounding taking place. However, two zeroes are added. Most likely this has something to do with the other option (rate) that contains values with three decimals like "1.000".

Is this a bug?

Hello mariadb community,

I am currently unable to restart a previously working version of mariadb. Rocky Linux 8.6 server crashed during yum update and became unbootable. Installed Rocky Linux 9.3 and reinstalled mariadb and mariadb-server. mariadb now fails to start on previous datadir with:

systemctl start mariadb

2024-03-29 15:24:37 0 [Note] Starting MariaDB 10.5.22-MariaDB source revision 7e650253dc488debcb0898ebe6d385bf6dfa3656 as process 1971547

2024-03-29 15:24:37 0 [Note] InnoDB: Uses event mutexes

2024-03-29 15:24:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2024-03-29 15:24:37 0 [Note] InnoDB: Number of pools: 1

2024-03-29 15:24:37 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions

2024-03-29 15:24:37 0 [Note] InnoDB: Using Linux native AIO

2024-03-29 15:24:37 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2024-03-29 15:24:37 0 [Note] InnoDB: Completed initialization of buffer pool

2024-03-29 15:24:37 0 [ERROR] InnoDB: MySQL-8.0 tablespace in ./ibdata1

2024-03-29 15:24:37 0 [ERROR] InnoDB: Restart in MySQL for migration/recovery.

2024-03-29 15:24:37 0 [ERROR] InnoDB: Plugin initialization aborted with error Unsupported

2024-03-29 15:24:37 0 [Note] InnoDB: Starting shutdown...

2024-03-29 15:24:37 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2024-03-29 15:24:37 0 [Note] Plugin 'FEEDBACK' is disabled.

2024-03-29 15:24:37 0 [ERROR] Unknown/unsupported storage engine: InnoDB

2024-03-29 15:24:37 0 [ERROR] Aborting

I have attempted innodb_force_recovery from 1 to 6, to no avail. What would you recommend? Thank you.

Hi everyone! I am having a problem scripting a create user's store procedure I have a SP that in some fragment creates a user like this:

SET @dinamic_sql = CONCAT("CREATE USER IF NOT EXISTS '",_User,"'@'localhost' IDENTIFIED BY '",_Passwd,"' DEFAULT ROLE 'USER_ROLE' ACCOUNT UNLOCK"); PREPARE create_user FROM @dinamic_sql; EXECUTE create_user; set @err = @err + @@error_count; -- this is 'cus it is inside a transaction DEALLOCATE PREPARE create_user; FLUSH PRIVILEGES;

But my problem is that when I try to run de SP it gives me sintaxis error near 'DEFAULT ROLE 'USER_ROLE' ACCOUNT UNLOCK' This happens on my Ubuntu Server

I also use MySql Workbench on a windows developer instance, but it runs without any problems

I have also checked the MariaDB documentation, and the create user's sintaxis is the same as MySql's one

If someone have any idea about what could be happening, 'cus it looks like MariaDB has something wrong

Hello folks

I want to know what is the best way to upgrade and move my mysql 5.7 database (simple one with no partitions, etc) over to MariaDB 10.3.39 safely with less surprises.

is there a built in script I can use for MySQL to check or vice versa?

the MySQL database is located in Server A

the MariaDB database is located in Server C

How can I move it to Server C? do I make a backup of MySQL db first, copy it over to Server C and just "import" it into Maria DB?

We are running RHEL 8.9

Thank you

See Upgrading from MySQL to MariaDB.

MariaDB Server version: 10.6.12 (OS - Ubuntu 22.04)

Hi all,

Please advise where can I find its tutorial and commands. The syntax used looks different. The commands used by me in the past are not all applicable to this version.

Thanks in advance

Regards

Statements from older version are almost always applicable to newer versions. You can find documentation here on the Knowledge Base.

Hi,

Thanks for your advice and link. I have made heavy searching before posting. This is a mystery to me. Finally I found the solution as follow:-

This ia a LAMP server running on a VM of VirtualBox. Later I discovered there are 2 passwords to login MariaDB/MySQL; password-1 password-2 (discovered later)

To login MariaDB with password-1 Running some MariaDB commands popup warnings -> Syntax error, running the command corresponding to the right version of MariaDB

To login MariaDB with password-2 All MariaDB commands work without problem.

This VM has been created and running for a long time. Previously I have problem on this PCIe3.0 NVMe SSD compelling me to reinstall it. Host - Ubuntu 22.04 VM - Ubuntu 22.04

The VMs were re-created on their .vbox images. There are 6 VMs running. I still have problem unsolved. Some websites on VM unable to connect on browser with their internal IP addresses. I don't know WHY?

I'll leave the problem unsolved until I found time to build a new PC.

Regards

Hello.

Is there a way to easily use MariaDB (or another opensource database management system) for rich text? I'd like, for instance, to just click Ctrl + B to put a piece of text in bold. If yes, what to install for this?

Thank you in advance.

i get this when i try to connect Host 'static.MyIP.clients.your-server.de' is not allowed to connect to this MariaDB serveruery

See Troubleshooting Connection Issues.

I have a simple script that produces a simple table output;

MariaDB [nation]> source script.sql
+-----------+------------+-----------+
| name      | area       | region_id |
+-----------+------------+-----------+
| India     | 3287263.00 |         2 |
| Kazakstan | 2724900.00 |         2 |
+-----------+------------+-----------+
2 rows in set (0.000 sec)

But when I run it from the command line, I get this:

$mariadb -u root -pxxxxxxxx nation < script.sql
name	area	region_id
India	3287263.00	2
Kazakstan	2724900.00	2
[daryl@tigger sqltut]

Are there command line optons or script-level commands I can use to produce the tabular output?

Problem solved. The -t command line option is what I was looking for.

Buenas tardes, en MySQL se usa "default" para poder establecer un valor en un parámetro definido, pero en MariaDB no se puede usar "default".

Create Procedure 'spAction' ( In Valor int default 1) begin ... ... ...

Hi, I am planning to build a custom solution to capture Changes from MariaDB to Oracle dw. Possibly triggers could be of one kind solution to handle this. I want to know from Mariadb experts if there is any other way to integrate Mariadb to Oracle. Regards Himanshu

Hi this is kathir,

its possible to use CDC (Change Data Capture) in DB to DB same instance.