|
|
Post by Powderjockey on Aug 1, 2020 12:21:24 GMT -8
sudo /etc/init.d/mysql start
[....] Starting mysql (via systemctl): mysql.serviceJob for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
failed!
pi@raspberrypi:~ $ sudo systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.22 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset:
Active: failed (Result: exit-code) since Sat 2020-08-01 15:01:05 MDT; 54s ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 12807 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/r
Process: 12808 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_STAR
Process: 12810 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VA
Process: 12831 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_W
Main PID: 12831 (code=exited, status=2)
Status: "MariaDB server is down"
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [Note] InnoDB:
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [Note] InnoDB:
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [Note] InnoDB:
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [Note] Plugin '
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [ERROR] Could n
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [ERROR] /usr/sb
Aug 01 15:01:02 raspberrypi mysqld[12831]: 2020-08-01 15:01:02 0 [ERROR] Abortin
Aug 01 15:01:05 raspberrypi systemd[1]: mariadb.service: Main process exited, co
Aug 01 15:01:05 raspberrypi systemd[1]: mariadb.service: Failed with result 'exi
Aug 01 15:01:05 raspberrypi systemd[1]: Failed to start MariaDB 10.3.22 database
I was following the instructions on the datalogger. I received these errors trying to start the db. |
|
|
|
Post by SDL on Aug 2, 2020 9:32:28 GMT -8
Ouch! Something has gone wrong in your maria installation. Can you reinstall it? And then run a test to make sure it is running?
BP
|
|
|
|
Post by Powderjockey on Aug 3, 2020 9:11:20 GMT -8
Ouch! Something has gone wrong in your maria installation. Can you reinstall it? And then run a test to make sure it is running? BP I've done this and the same problem. I can run it in myslqd in safe mode, but I'm not sure what that does for me. |
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 4, 2020 1:04:59 GMT -8
Let us see the complete error message (It is cut out - The ERROR lines). That is how I did it.
|
|
|
|
Post by Powderjockey on Aug 4, 2020 17:50:32 GMT -8
Let us see the complete error message (It is cut out - The ERROR lines). No sure how to get that part of the errors. Ran it again and it is all cut off. Is there away to export it into a text file? Nevermind, see the attached file. mysql.txt (2.03 KB) |
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 5, 2020 2:28:51 GMT -8
"journalctl -xe" should provide you the entire log. See
|
|
|
|
Post by Powderjockey on Aug 6, 2020 18:14:10 GMT -8
"journalctl -xe" should provide you the entire log. See Ok I'll post |
|
|
|
Post by Powderjockey on Aug 7, 2020 8:35:05 GMT -8
"journalctl -xe" should provide you the entire log. See Just performed an upgrade to the system and received this error: Setting up mariadb-server-10.3 (1:10.3.23-0+deb10u1) ...
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.Attachments:journalctl (169.58 KB)
|
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 9, 2020 23:24:17 GMT -8
Too late. The logs have been rotated. You have to reboot the weatherstation, and when you see the error, then you call the logs. Sorry  |
|
|
|
Post by Powderjockey on Aug 15, 2020 10:19:12 GMT -8
journalctl.txt (130.02 KB) Not sure it this helps either. Everything seems to start on boot.
|
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 18, 2020 0:09:53 GMT -8
Got the following:
-- The job identifier is 473.
Aug 14 02:27:47 raspberrypi systemd[1]: mariadb.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- An ExecStart= process belonging to unit mariadb.service has exited.
--
-- The process' exit code is 'exited' and its exit status is 2.
Aug 14 02:27:47 raspberrypi systemd[1]: mariadb.service: Failed with result 'exit-code'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- The unit mariadb.service has entered the 'failed' state with result 'exit-code'.
Aug 14 02:27:47 raspberrypi systemd[1]: Failed to start MariaDB 10.3.23 database server.
-- Subject: A start job for unit mariadb.service has failed
-- Defined-By: systemd
-- Support: https://www.debian.org/support
--
-- A start job for unit mariadb.service has finished with a failure.
You will have to check the mysql/mariadb log file itself for more details on the error. usually in /var/log/mysql|mariadb
|
|
|
|
Post by Powderjockey on Aug 18, 2020 16:59:06 GMT -8
The folder /var/log/mysql/ is empty. Nothing that says mariadb.
This is probably due to the fact that the program isn't starting?
|
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 18, 2020 23:11:39 GMT -8
Usually mysqld/mariadb will write at least what the error is, unless that startup script is the one causing the error and causing an exit before executing the binaries.
I'd give it a look myself if I had a ssh access to it (temporarily). Can also provide you a public key in case the PI is on the public network somewhere (you can remove it to revoque the access once done).
|
|
|
|
Post by Powderjockey on Aug 19, 2020 18:40:37 GMT -8
Ok, I uninstalled all of the mariadb and dependencies using Synaptic, deleted all of the DB's. Then I installed mariadb-server-10.3, instead of mariadb-server. This installed everything back on and it loads and starts.
Now I can't get into phpmyadmin. I uninstalled it and re-installed. I've tried admin, blank; admin, password; root, blank; root, password; and then both of these again with a password that I thought I used when installing, but not.
Is there any way to reset the password for phpmyadmin from the cli?
|
|
smurphy
Full Member
Posts: 169
Raspberry Pi: Yes
Other Device: many ...
|
Post by smurphy on Aug 19, 2020 23:17:57 GMT -8
Actually - did you run the "sudo mysql_secure_installation" command? This removes all junk (test Db etc.) and forces you to actually set a password for root access.
Make sure you also after that, create a table and a user for SkyWeather. Don't remember if the skyweather script does it. Too long ago.
|
|
