MySQL MariaDB Not Installed After I Try To 3 Times Installing It!

SobatWP

Hello, I just tried installing aapanel on a new vps and everything went smoothly except there was a problem with MariaDB.

I have tried 3 times to install mariadb but it still doesn't install.

I tried checking /tmp/panelExec.log and got the following information:

mysql_root.sh: line 5: /etc/init.d/mysqld: No such file or directory Changing password... mysql_root.sh: line 6: mysqld_safe: command not found mysql_root.sh: line 12: mysql: command not found mysql_root.sh: line 23: mysql: command not found mysql_root.sh: line 28: /etc/init.d/mysqld: No such file or directory The root password set d0b26548757b372b8 successuful 1 mysql.sh: line 332: /etc/init.d/mysqld: No such file or directory mysql.sh: line 336: /etc/init.d/mysqld: No such file or directory mysql.sh: line 338: /www/server/mysql/bin/mysql: No such file or directory mysql.sh: line 339: /www/server/mysql/bin/mysql: No such file or directory mysql.sh: line 340: /www/server/mysql/bin/mysql: No such file or directory |-Successify --- Command executed! ---

aaPanel_Kern

Hello, I suggest you check more installation logs or install mysql

SobatWP

aaPanel_Kern here is it:

`copying pymysql/cursors.py -> build/lib/pymysql
copying pymysql/socketio.py -> build/lib/pymysql
copying pymysql/auth.py -> build/lib/pymysql
copying pymysql/converters.py -> build/lib/pymysql
copying pymysql/connections.py -> build/lib/pymysql
copying pymysql/util.py -> build/lib/pymysql
copying pymysql/optionfile.py -> build/lib/pymysql
copying pymysql/err.py -> build/lib/pymysql
copying pymysql/compat.py -> build/lib/pymysql
copying pymysql/init.py -> build/lib/pymysql
copying pymysql/protocol.py -> build/lib/pymysql
creating build/lib/pymysql/constants
copying pymysql/constants/FLAG.py -> build/lib/pymysql/constants
copying pymysql/constants/CLIENT.py -> build/lib/pymysql/constants
copying pymysql/constants/ER.py -> build/lib/pymysql/constants
copying pymysql/constants/FIELD_TYPE.py -> build/lib/pymysql/constants
copying pymysql/constants/COMMAND.py -> build/lib/pymysql/constants
copying pymysql/constants/init.py -> build/lib/pymysql/constants
copying pymysql/constants/CR.py -> build/lib/pymysql/constants
copying pymysql/constants/SERVER_STATUS.py -> build/lib/pymysql/constants
creating build/bdist.linux-x86_64
creating build/bdist.linux-x86_64/egg
creating build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/times.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/charset.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/cursors.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/socketio.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/auth.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/converters.py -> build/bdist.linux-x86_64/egg/pymysql
creating build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/FLAG.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/CLIENT.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/ER.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/FIELD_TYPE.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/COMMAND.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/init.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/CR.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/constants/SERVER_STATUS.py -> build/bdist.linux-x86_64/egg/pymysql/constants
copying build/lib/pymysql/connections.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/util.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/optionfile.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/err.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/compat.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/init.py -> build/bdist.linux-x86_64/egg/pymysql
copying build/lib/pymysql/protocol.py -> build/bdist.linux-x86_64/egg/pymysql
byte-compiling build/bdist.linux-x86_64/egg/pymysql/times.py to times.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/charset.py to charset.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/cursors.py to cursors.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/_socketio.py to socketio.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/auth.py to auth.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/converters.py to converters.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/FLAG.py to FLAG.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/CLIENT.py to CLIENT.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/ER.py to ER.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/FIELD_TYPE.py to FIELD_TYPE.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/COMMAND.py to COMMAND.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/init.py to init.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/CR.py to CR.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/constants/SERVER_STATUS.py to SERVER_STATUS.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/connections.py to connections.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/util.py to util.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/optionfile.py to optionfile.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/err.py to err.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/compat.py to _compat.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/init.py to init.cpython-312.pyc
byte-compiling build/bdist.linux-x86_64/egg/pymysql/protocol.py to protocol.cpython-312.pyc
creating build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/PKG-INFO -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/SOURCES.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/dependency_links.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/requires.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
copying PyMySQL.egg-info/top_level.txt -> build/bdist.linux-x86_64/egg/EGG-INFO
zip_safe flag not set; analyzing archive contents...
creating dist
creating 'dist/PyMySQL-0.9.3-py3.12.egg' and adding 'build/bdist.linux-x86_64/egg' to it
removing 'build/bdist.linux-x86_64/egg' (and everything under it)
Processing PyMySQL-0.9.3-py3.12.egg
Copying PyMySQL-0.9.3-py3.12.egg to /www/server/panel/pyenv/lib/python3.12/site-packages
Adding PyMySQL 0.9.3 to easy-install.pth file

Installed /www/server/panel/pyenv/lib/python3.12/site-packages/PyMySQL-0.9.3-py3.12.egg
Processing dependencies for PyMySQL==0.9.3
Finished processing dependencies for PyMySQL==0.9.3
Reload Bt-Panel.. [32mdone[0m
mysql_root.sh: line 5: /etc/init.d/mysqld: No such file or directory
Changing password...
mysql_root.sh: line 6: mysqld_safe: command not found
mysql_root.sh: line 12: mysql: command not found
mysql_root.sh: line 23: mysql: command not found
mysql_root.sh: line 28: /etc/init.d/mysqld: No such file or directory

The root password set 0eccfb1b4e9581ec successuful
1
mysql.sh: line 332: /etc/init.d/mysqld: No such file or directory
mysql.sh: line 336: /etc/init.d/mysqld: No such file or directory
mysql.sh: line 338: /www/server/mysql/bin/mysql: No such file or directory
mysql.sh: line 339: /www/server/mysql/bin/mysql: No such file or directory
mysql.sh: line 340: /www/server/mysql/bin/mysql: No such file or directory
|-Successify --- Command executed! ---`

aaPanel_Kern

Hello, this is not a complete log either. Log file/tmp/panelExec.log
If MariaDB cannot be installed, please use mysql

SobatWP

aaPanel_Kern I have pasted this from the complete error log which you can check from this link.

https://pastecode.io/s/ztc5352j

I can't paste it here because of character limitations. so I pasted it on the website above.

Please help:

aaPanel_Kern

--2024-07-10 06:12:02-- https://jp1-node.bt.cn/soft/mysql/mariadb_10.11/ubuntu-24-mysql-mariadb_10.11.tar.gz
Resolving jp1-node.bt.cn (jp1-node.bt.cn)... 45.76.53.20
Connecting to jp1-node.bt.cn (jp1-node.bt.cn)|45.76.53.20|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2024-07-10 06:12:02 ERROR 404: Not Found.

It is recommended to use mysql first, which is not supported by ubuntu 24.
SobatWP

SobatWP

aaPanel_Kern I just tried reinstalling the VPS and using Ubuntu version 22 and reinstalling Aapanel. Here's Ubuntu 22 from Aapanel that I installed:

then I still encountered the same problem, namely mariadb could not be installed and the error log was not detailed like this:

===

--2024-07-10 08:49:47-- https://node.aapanel.com/install/4/mysql.sh
Resolving node.aapanel.com (node.aapanel.com)... 2606:4700:3031::6815:4fc4, 2606:4700:3034::ac43:ab07, 172.67.171.7, ...
Connecting to node.aapanel.com (node.aapanel.com)|2606:4700:3031::6815:4fc4|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 22702 (22K) [application/octet-stream]
Saving to: ‘mysql.sh’

0K .......... .......... .. 100% 146M=0s

2024-07-10 08:49:47 (146 MB/s) - ‘mysql.sh’ saved [22702/22702]

selecting download node...
https://download.bt.cn
selecting download node...
系统不支持安装mariadb!
请选择安装mysql-5.5/5.7/8.0!
|-Successify --- Command executed! ---

Can mariadb really no longer be used? should I use MySQL instead?

Thanks

aaPanel_Kern

Yes, the panel is not friendly to the installation of mariaDB. It is recommended that you use mysql first.

SobatWP

aaPanel_Kern okay, but there is a problem, I can't install mysql v8 because there is a warning that the minimum RAM is 6GB. while my VPS only has 4GB RAM. (can be seen in the picture above)

Is it ok if I force install mysql version 8?

Thank You

aaPanel_Kern

It is recommended to use mysql5.7
Or use Express Install and ignore configuration
touch /www/server/panel/install/i_mysql.pl

SobatWP

aaPanel_Kern okay thanks for your help

g00v3R

Whats excat the problem with Mariadb? I use MariaDB since a long time and never had any issues.

Maybe you seperate MariaDB from MySQL installation, then it should work

aaP_baspax1

I tried to setup Mariadb 11.3 , deleted mysql , installed Mysql app with Mariadb selection,in compiled method, i was waiting about 5-8 minutes, and procedure finished.
I can see now Mariadb on panel.
But I'm a bit skeptical. When I went to verify the installation through the server, I found this—it recognizes it as MySQL running MariaDB. Is this correct? Doesn't this create some kind of conflict? Is this why most people generally encounter problems with the installation?

dedicated ~ # mariadb --version
-bash: /usr/bin/mariadb: No such file or directory
dedicated ~ # mysql --version
mysql: Deprecated program name. It will be removed in a future release, use '/www/server/mysql/bin/mariadb' instead mysql from 11.3.2-MariaDB, client 15.2 for Linux x86_64) using readline 5.1

aaPanel_Kern

hello correct
There are many reasons for failure, this does not cause

aaP_baspax1

aaP_fremfarimal11

halo bantu saya , tidak bisa menginstal mariaDB,, ini aapanel kenapa ko jadi seperti ini

dreambladeflag0

aaP_fremfarimal11 Hi, have any error report or screenshot?

SLAED

Which version of MySQL or MariaDB plus phpMyAdmin should I put on aaPanel 7.0.11 with Ubuntu 24.04 LTS?

aaPanel_Kern

Hello, install the software according to your own needs

SLAED

I didn't want to experiment, the stable operation of the components/apps is important to me.

aaPanel_Kern

Currently, the most compatible aapanel is ubnutu 22 mysql8.0

SLAED