[MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

[outkastm]

from the log file i see that mysql started at 23:14 and stopped at 23:30

I can't figure it out the issue on your NAS without a share screen.

Is running OK on mine

[sanctimon]

Happy to share screen.

The successful startup you saw was me running a startup command and bypassing the script.

DM for Teamviewer if you like.

MariaDB_start.log always fails at:

Code: Select all

++ stat -c %s /usr/local/MariaDB/bin/access_log
+ '[' 168 -gt 5000 ']'
+ '[' -f /usr/local/MariaDB/bin/error_log ']'
++ stat -c %s /usr/local/MariaDB/bin/error_log
+ '[' 54 -gt 5000 ']'
httpd (pid 8199) already running
+ i=0
+ test 0 -ne 100
+ /usr/local/MariaDB/bin/MariaDB/bin/mysqladmin --defaults-file=/usr/local/MariaDB/config/my.cnf ping
+ su_kill -0
+ kill -0
+ break
+ log_failure_msg 'log file'
+ echo ' ERROR! log file'
 ERROR! log file
+ return 1

which seems to indicate some issue with the log file.

[brunix86]

{L_BUTTON_AT}outkastm

Hi, I just installed MariaDB + phpMyAdmin (10.4.28.2) on TOS 5.1.67 (fresh installed some days ago) and I didn't make any changes to the default config. After installation, only MariaDB is started and I just manually start also phpMyAdmin.

App MariaDB

The problem is that if I open phpMyAdmin, I see the following error.

phpMyAdmin Error

I don't see errors in the logs (or I have to find other log file...).

Error Log

Start Log

start log.png (15.84 KiB) Viewed 1160 times

Could you gently help me to understand what's wrong? Thanks.

[brunix86]

Hi outkastm,

I just solved the issue by restarting the TNAS device.
In general, each time you edit the "config.inc.php" file, you need to restart the device.
Also note that it's needed to edit the "config.sample.inc.php" file, otherwise the configuration won't apply.

Best Regards

[wetmarble]

I'm encountering the same problem where phpmyadmin starts, but mysql does not.

Environment
TerraMaster F2-421 with 12gb ram
TOS 5.0.176-00227
installed version is 10.4.28.2

Start.log Contents

Code: Select all

11/01/24 14:25:34 Will use /Volume1 to store config files
11/01/24 14:25:34 The main volume is /Volume1
11/01/24 14:25:34 Config folder exist at /home/wetmarble/MOD_CONFIG/MariaDB
11/01/24 14:25:34 config symlink doesn't exist, will be created
11/01/24 14:25:47 Database folder at /Volume1/MariaDB_DB
11/01/24 14:25:47 Temporary directory set to /Volume1/MariaDB_DB/tmp
12/01/24 00:52:25 Will use /Volume1 to store config files
12/01/24 00:52:25 The main volume is /Volume1
12/01/24 00:52:25 Config folder exist at /home/wetmarble/MOD_CONFIG/MariaDB
12/01/24 00:52:25 Database folder at /Volume1/MariaDB_DB
12/01/24 00:52:25 Temporary directory set to /Volume1/MariaDB_DB/tmp
httpd (pid 24426) already running

Error.log contents

Code: Select all

[Thu Jan 11 14:25:47.774873 2024] [ssl:warn] [pid 24425] AH01909: www.example.com:52443:0 server certificate does NOT include an ID which matches the server name
[Thu Jan 11 14:25:47.901728 2024] [ssl:warn] [pid 24426] AH01909: www.example.com:52443:0 server certificate does NOT include an ID which matches the server name
[Thu Jan 11 14:25:47.997745 2024] [mpm_prefork:notice] [pid 24426] AH00163: Apache/2.4.57 (Unix) OpenSSL/1.1.1i PHP/7.4.33 configured -- resuming normal operations
[Thu Jan 11 14:25:47.997834 2024] [core:notice] [pid 24426] AH00094: Command line: '/usr/local/apache24/sys/bin/httpd -f /usr/local/MariaDB/config/httpd.conf'

Troubleshooting
When attempting to start mysql via console with

Code: Select all

service mysql start

I receive the error message:

Code: Select all

fork/exec /etc/init.d/mysql: no such file or directory

When attempting to start maria via console with

Code: Select all

service MariaDB start

I get no error message, but a subsequent

Code: Select all

service MariaDB status

yields

Code: Select all

mysql is stopped. phpMyAdmin (pid 24426) is running

Any advice on next steps would be greatly appreciated.