Help WordOps Debian 9

rodrigo_mct

Hello everyone, everything good?
Right now I really need some help from someone I don't know much about servers.
I need to make my server work right now because I really need to back up two databases, and then I'll update my machine later.
see the log below

root@localhost:~# wo maintence usage: wo (sub-commands ...) [options ...] {arguments ...} wo: error: unrecognized arguments: maintence root@localhost:~# wo maintenance updating apt-cache, please wait... Whoops, something went wrong... Check the WordOps log for more detailstail /var/log/wo/wordops.logand please try again... root@localhost:~# tail tail /var/log/wo/wordops.log tail: cannot open 'tail' for reading: No such file or directory ==> /var/log/wo/wordops.log <== 2022-11-18 12:52:02,758 (INFO) wo : Restarting mysql 2022-11-18 12:52:02,758 (DEBUG) wo.core.logging : Restarting service: netdata 2022-11-18 12:52:02,758 (INFO) wo : Restarting netdata 2022-11-18 12:52:02,813 (INFO) wo : Restarting netdata 2022-11-18 12:52:26,735 (INFO) wo : Initializing WordOps Database 2022-11-18 12:52:26,740 (INFO) wo : updating apt-cache, please wait... E: The repository 'https://packages.sury.org/php stretch Release' does no longer have a Release file. E: The repository 'http://download.opensuse.org/repositories/home:/virtubox:/WordOps/Debian_9.0 Release' does no longer have a Release file. 2022-11-18 12:52:28,888 (INFO) wo : Whoops, something went wrong... 2022-11-18 12:52:28,889 (ERROR) wo : Check the WordOps log for more detailstail /var/log/wo/wordops.logand please try again...

marty

rodrigo_mct right now because I really need to back up two databases, and then I'll update my machine later.

You don't need to run maintenance to get backups. So use the admin tools (PHPmyAdmin/Adminer) at your.ip:22222 or yourdomain.com:22222 if they've been installed (bearing in mind you also need the /wp-content/ folder). Or just install any WordPress backup/migration plugin.
You can also backup just the DB using the MySQL command line.

Dennis-Developer

Looking at this link http://download.opensuse.org/repositories/home:/virtubox:/WordOps/

Support for Debian 9 has been dropped.

I advise migrating to debian 10.

With the installation in debian 10, I believe there will be no more problem.

rodrigo_mct

OK Dennis can you help me I have no experience with this

Dennis-Developer

rodrigo_mct

I help yes! you need to create a new machine on your hosting, if it's on digital ocean, create a new droplet with debian 10 and install wordops again.

rodrigo_mct

Guys, thanks for the help but the problem is the following I need to dump my database which is mariaDB, but it is not working, I just need the dump, but when doing the status command of my mariadb it is this one below.

root@localhost:~# service mysql status ● mariadb.service - MariaDB 10.1.45 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mariadb.service.d └─limits.conf, migrated-from-my.cnf-settings.conf Active: failed (Result: exit-code) since Sun 2022-11-20 22:42:44 UTC; 7s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 5588 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Process: 5578 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0
Process: 5573 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 5571 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 5588 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139745456523520 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.47-87.0 started; log sequence number 616854704160
Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139744889497344 [Note] InnoDB: Dumping buffer pool(s) not yet started
Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139745456523520 [Note] Plugin 'FEEDBACK' is disabled.
Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139745456523520 [Note] Recovering after a crash using tc.log
Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139745456523520 [ERROR] Can't init tc log
Nov 20 22:42:41 localhost mysqld[5588]: 2022-11-20 22:42:41 139745456523520 [ERROR] Aborting
Nov 20 22:42:44 localhost systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 20 22:42:44 localhost systemd[1]: Failed to start MariaDB 10.1.45 database server.
Nov 20 22:42:44 localhost systemd[1]: mariadb.service: Unit entered failed state.
Nov 20 22:42:44 localhost systemd[1]: mariadb.service: Failed with result 'exit-code'.`

I need to make this dump to solve my problem and redo the VM

marty

OK - you didn't mention that MySQL was down. :-)
You can try just restarting MySQL - it may recover itself service mysql restart
But otherwise you're looking at trying to recover a crashed MySQL which may have a corrupt database. The best way to recover that is to restore from a backup - so if you have any backups at all that may be your best approach.
If you want to attempt it there's lots of guides if you Google 'how to recover crashed mysql', but I'd recommend you backup the server first.

rodrigo_mct

Hello how are you? Many thanks for the reply.

I already have the files backed up, can you show me those guides you mentioned? I'm super desperate.

marty

Did you try the restart?

rodrigo_mct I already have the files backed up

Just to be clear, I did say backup the server (i.e. the whole thing). Because attemps to fix the database may make things worse if you don't know what you're doing. So backup the server to have something to go back to if it goes badly.

rodrigo_mct can you show me those guides you mentioned?

Literally just Google 'how to recover crashed mysql'. :-)

rodrigo_mct

Hello,

See the log

tail /var/log/wo/wordops.log
gpg:              unchanged: 1

2022-11-23 15:53:03,018 (INFO) wo : Updating APT cache
W: The repository 'http://download.opensuse.org/repositories/home:/virtubox:/WordOps/Debian_9.0  Release' does not have a Release file.
W: The repository 'https://packages.sury.org/php stretch Release' does not have a Release file.
E: Failed to fetch http://download.opensuse.org/repositories/home:/virtubox:/WordOps/Debian_9.0/Packages  404  Not Found [IP: 2001:67c:2178:8::13 80]
E: Failed to fetch https://packages.sury.org/php/dists/stretch/main/binary-amd64/Packages  403  Forbidden
E: Some index files failed to download. They have been ignored, or old ones used instead.
2022-11-23 15:53:05,218 (INFO) wo : Whoops, something went wrong...
2022-11-23 15:53:05,219 (ERROR) wo : Check the WordOps log for more details `tail /var/log/wo/wordops.log` and please try again...

What should I do?

rodrigo_mct

Hello,

See log change

root@localhost:/var/lib# tail /var/log/wo/wordops.log
  Package mariadb-server-10.1 is not configured yet.

dpkg: error processing package mariadb-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mariadb-server-10.1
 mariadb-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
2022-11-23 16:32:22,130 (INFO) wo : Oops Something went wrong!!
2022-11-23 16:32:22,131 (ERROR) wo : Check the WordOps log for more details `tail /var/log/wo/wordops.log` and please try again...

What should I do?

marty

It's not clear what you've done so far or what you're now trying to do. The fragments of error log don't really help without any explanation.