ASTPP Still using MySQL?

General questions DB
1
2

Interesting to see this. We haven’t tried it with MariaDB, but it should work since it’s quite similar to MySQL.

Has anyone tried ASTPP with MariaDB?

3

I was able to get it working with MariaDB in version 6. However, some of the addon modules I noticed are having compatibility issues.

4

Thanks for testing this and sharing your findings, @KNERD, that’s useful real-world feedback for the community.

Regarding the addon compatibility issues you mentioned, could you share which specific addons you ran into problems with? That would help us reproduce and test on our end when we start looking at MariaDB option.

5

These commands made it more compatible with MariaDB

 sed -i -e 's/utf8mb4_0900_ai_ci/utf8_unicode_ci/g' /opt/ASTPP/database/astpp-6.0.sql
 sed -i -e 's/utf8mb4/utf8/g' /opt/ASTPP/database/astpp-6.0.1.sql
 sed -i -e 's/utf8_0900_ai_ci/utf8_unicode_ci/g' /opt/ASTPP/database/astpp-6.0.1.sql
 sed -i -e 's/utf8mb4_0900_ai_ci/utf8_unicode_ci/g' /opt/ASTPP/database/astpp-6.0.1.sql

I don’t recall offlhand which modules where not compatible. I think the Spanish one was one of them.

6

This project should use MariaDB by default since that is what is used by Debian now. It would not be hard to add the option to the install script.

1 Like
7

Thank you both for the practical input.

@KNERD those sed commands are very useful for anyone attempting a MariaDB migration right now. We will test these on our end and document them properly if they hold up across versions.

@sman123 you make a fair point. Debian has moved to MariaDB as default and our install script should reflect that. We will evaluate full MariaDB compatibility across core and addon modules and if viable, add official support to the install script as part of our roadmap.

If anyone else has tested ASTPP with MariaDB and hit specific issues, please share them here. It will help us prioritize what to fix first.

8

Since you haven’t released v7 community yet, seems to me that adding MariaDB compatibility to that version would make a lot of sense. It’s not a heavy lift imo. I ran ASTPP on MariaDB for quite awhile back on v4 or v5 without any issues. I think I only had to change a few lines in the sql file for a new install.

1 Like