Page 7 of 7

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 26 Mar 2023, 08:05
by 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

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 26 Mar 2023, 08:22
by 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.

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 12 Sep 2023, 22:15
by 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 started.png
The problem is that if I open phpMyAdmin, I see the following error.
phpMyAdmin error.png
I don't see errors in the logs (or I have to find other log file...).
error log.png
start log.png
Could you gently help me to understand what's wrong? Thanks.

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 05 Oct 2023, 22:29
by 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 :)

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 12 Jan 2024, 01:01
by 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.

Re: [MariaDB] MariaDB+phpMyAdmin MySQL Server Fork

Posted: 03 Feb 2025, 01:31
by Luigi1994
wetmarble wrote: 12 Jan 2024, 01:01 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.
Ehi Wetmarble seems that i've the same your problems, you've found a workaround or a solution for this one? And also access to the web browser?