Mariadb not installing on 23.05

Hey all I have been trying to install mariadb on my openwrt v. 23.05 running on ARMv7 Processor rev 1 (v7l).

When running:
opkg install libreadline libncursesw uclibcxx libmysqlclient mysql-server

I get:

Package libreadline (8.1-1) installed in root is up to date.
Package libncurses (6.3-3) installed in root is up to date.
Package uclibcxx (0.2.5-3) installed in root is up to date.
Package libmariadb (3.1.12-4) installed in root is up to date.
Unknown package 'mysql-serveropkg'.
Collected errors:
 * opkg_install_cmd: Cannot install package mysql-serveropkg.
Unknown package 'update'.
Collected errors:
 * opkg_install_cmd: Cannot install package update.
Package libreadline (8.1-1) installed in root is up to date.
Package libncurses (6.3-3) installed in root is up to date.
Package uclibcxx (0.2.5-3) installed in root is up to date.
Package libmariadb (3.1.12-4) installed in root is up to date.
Package mariadb-server (10.6.15-2) installed in root is up to date.

When installing using:
mysql_install_db --force
I get the following errors:

root@turris:~# mysql_install_db  --forcemysql_install_db  --force
Error relocating /usr/./bin/my_print_defaults: __getrusage_time64: symbol not found
Error relocating /usr/./bin/my_print_defaults: __lstat_time64: symbol not found
Error relocating /usr/./bin/my_print_defaults: __stat_time64: symbol not found
Error relocating /usr/./bin/my_print_defaults: __fstat_time64: symbol not found
Error relocating /usr/./bin/my_print_defaults: __clock_gettime64: symbol not found
Error relocating /usr/./bin/my_print_defaults: __pthread_cond_timedwait_time64: symbol not found
Installing MariaDB/MySQL system tables in './data' ...
Error loading shared library liburing.so.2: No such file or directory (needed by /usr/bin/mariadbd)
Error relocating /usr/bin/mariadbd: __getrusage_time64: symbol not found
Error relocating /usr/bin/mariadbd: __clock_gettime64: symbol not found
Error relocating /usr/bin/mariadbd: __nanosleep_time64: symbol not found
Error relocating /usr/bin/mariadbd: _ZNSt19basic_ostringstreamIcSt11char_traitsIcESaIcEEC1Ev: symbol not found
Error relocating /usr/bin/mariadbd: __utime64: symbol not found
Error relocating /usr/bin/mariadbd: __fstat_time64: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_mlock_size: symbol not found
Error relocating /usr/bin/mariadbd: _ZSt28__throw_bad_array_new_lengthv: symbol not found
Error relocating /usr/bin/mariadbd: __dlsym_time64: symbol not found
Error relocating /usr/bin/mariadbd: __gettimeofday_time64: symbol not found
Error relocating /usr/bin/mariadbd: __io_uring_get_cqe: symbol not found
Error relocating /usr/bin/mariadbd: __localtime64_r: symbol not found
Error relocating /usr/bin/mariadbd: __select_time64: symbol not found
Error relocating /usr/bin/mariadbd: __pthread_cond_timedwait_time64: symbol not found
Error relocating /usr/bin/mariadbd: __difftime64: symbol not found
Error relocating /usr/bin/mariadbd: __time64: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_submit: symbol not found
Error relocating /usr/bin/mariadbd: __lstat_time64: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_register_files_update: symbol not found
Error relocating /usr/bin/mariadbd: __stat_time64: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_ring_dontfork: symbol not found
Error relocating /usr/bin/mariadbd: _ZNSs7reserveEv: symbol not found
Error relocating /usr/bin/mariadbd: __gmtime64_r: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_queue_init: symbol not found
Error relocating /usr/bin/mariadbd: io_uring_queue_exit: symbol not found

So i'm not sure where to go from here. All my packages seem to be installed for mysql?


What am I missing?

Those aren't mariadb packages, only support for the DB in PHP.

And the DB packages install just fine (not using the same arch as you though).

root@OpenWrt:~# opkg install  mariadb-server
Installing mariadb-server (10.9.3-4) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/packages/mariadb-server_10.9.3-4_x86_64.ipk
Installing libfmt (9.1.0-1) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/packages/libfmt_9.1.0-1_x86_64.ipk
Installing liburing (2.3-1) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/packages/liburing_2.3-1_x86_64.ipk
Installing liblzma (5.4.6-1) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/packages/liblzma_5.4.6-1_x86_64.ipk
Installing libpcre2 (10.42-1) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/base/libpcre2_10.42-1_x86_64.ipk
Installing resolveip (2) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/base/resolveip_2_x86_64.ipk
Installing mariadb-server-base (10.9.3-4) to root...
Downloading https://downloads.openwrt.org/releases/23.05.2/packages/x86_64/packages/mariadb-server-base_10.9.3-4_x86_64.ipk
Configuring liblzma.
Configuring resolveip.
Configuring liburing.
Configuring libfmt.
Configuring libpcre2.
Configuring mariadb-server-base.
2024-04-15 17:18:05 0 [Warning] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some options may be missing from the help text
service not enabled in /etc/config/mysqld
Configuring mariadb-server.
root@OpenWrt:~#
root@OpenWrt:~# mysql_install_db --force
Installing MariaDB/MySQL system tables in './data' ...
2024-04-15 17:22:11 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-expire-logs-seconds work.
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system


Two all-privilege accounts were created.
One is root@localhost, it has no password, but you need to
be system 'root' user to connect. Use, for example, sudo mysql
The second is root@localhost, it has no password either, but
you need to be the system 'root' user to connect.
After connecting you can set the password, if you would need to be
able to connect as any of these users with a password and without sudo

See the MariaDB Knowledgebase at https://mariadb.com/kb

You can start the MariaDB daemon with:
cd '/usr' ; /usr/bin/mysqld_safe --datadir='./data'

You can test the MariaDB daemon with mysql-test-run.pl
cd '/usr/mysql-test' ; perl mysql-test-run.pl

Please report any problems at https://mariadb.org/jira

The latest information about MariaDB is available at https://mariadb.org/.

Consider joining MariaDB's strong and vibrant community:
https://mariadb.org/get-involved/


1 Like

Yeah i see you ran openwrt on your x86. Much different in my case. Just odd that its not working.

Maybe it does not install/work on 32 bit platforms?

@frollic was able to install it but it's the x86 version. I am using the Arm version and its not installing.

What hardware do you have? It needs to be something like a Pi board with Gbs of RAM and storage since Mariadb is really large.

Armv7 is 32 bit maybe that is the problem?

I was a kickstarter contributor to the Turris Omnia - this is what I am using as my router. It has 2GB ram, dual core @ 1.6GHz with around 50gb of ssd space so it should be able to handle the tiny database I need to setup on it.

And is it Openwrt or TurrisOS ?

Running mostly GUI edits for them.

Its running LuCI in the advanced mode.

Powered by LuCI branch (git-23.093.57360-e98243e) / TurrisOS 6.5.2

BusyBox v1.33.2 (2022-10-19 04:44:51 UTC) built-in shell (ash)

      ______                _         ____  _____
     /_  __/_  ____________(_)____   / __ \/ ___/
      / / / / / / ___/ ___/ / ___/  / / / /\__
     / / / /_/ / /  / /  / (__  )  / /_/ /___/ /
    /_/  \__,_/_/  /_/  /_/____/   \____//____/

 -----------------------------------------------------
 TurrisOS 6.5.2, Turris Omnia
 -----------------------------------------------------
root@turris:~# ubus call system board
{
        "kernel": "5.15.147",
        "hostname": "turris",
        "system": "ARMv7 Processor rev 1 (v7l)",
        "model": "Turris Omnia",
        "board_name": "cznic,turris-omnia",
        "release": {
                "distribution": "TurrisOS",
                "version": "6.5.2",
                "revision": "r16881+135",
                "target": "mvebu/cortexa9",
                "description": "TurrisOS 6.5.2"
        }
}

The kernel 5.15 points to version 23.05.

I think you should report this to TurrisOS devs. While TurrisOS supposedly "stands on OpenWrt", there could be any number of subtle differences which may cause issues such as the one you're facing.

1 Like

Alright - will do.