DB issues after updating?

someonesusername · August 23, 2021, 1:34pm

My YunoHost server

Hardware: AMD 64
YunoHost version: Latest version
I have access to my server : Yuno it
Are you in a special context or did you perform some particular tweaking on your YunoHost instance ? : no
If yes, please explain:
I said no!

Description of my issue

To get help efficiently, please explain what you are trying to achieve, in which context, what you tried and provide detailed error messages and logs if you can.

Avoid saying that it “doesn’t work” or that it “does nothing” … explain what really happens and how you interpret it !

NB: you can use paste.yunohost.org to share logs and error messages. You can also directly include error messages using backticks like this :

since the last update i get this
-- Logs begin at Sat 2021-08-21 06:43:32 CEST, end at Mon 2021-08-23 15:29:08 CEST. --
aug 23 14:49:55 mysqld[795]: 2021-08-23 14:49:55 970302 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:50:13 mysqld[795]: 2021-08-23 14:50:13 970307 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:50:14 mysqld[795]: 2021-08-23 14:50:14 970308 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:50:15 mysqld[795]: 2021-08-23 14:50:15 970309 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:50:16 mysqld[795]: 2021-08-23 14:50:16 970310 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:50:25 mysqld[795]: 2021-08-23 14:50:25 970311 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:51:50 mysqld[795]: 2021-08-23 14:51:50 970344 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:54:15 mysqld[795]: 2021-08-23 14:54:15 970388 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:55:38 mysqld[795]: 2021-08-23 14:55:38 970420 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:57:37 mysqld[795]: 2021-08-23 14:57:37 970455 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:58:12 mysqld[795]: 2021-08-23 14:58:12 970466 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:58:21 mysqld[795]: 2021-08-23 14:58:21 970472 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 14:58:39 mysqld[795]: 2021-08-23 14:58:39 970487 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:58:40 mysqld[795]: 2021-08-23 14:58:40 970488 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:58:42 mysqld[795]: 2021-08-23 14:58:42 970491 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:58:43 mysqld[795]: 2021-08-23 14:58:43 970492 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 14:59:16 mysqld[795]: 2021-08-23 14:59:16 970504 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:00:24 mysqld[795]: 2021-08-23 15:00:24 970512 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:06:01 mysqld[795]: 2021-08-23 15:06:01 970619 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:06:21 mysqld[795]: 2021-08-23 15:06:21 970633 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:07:05 mysqld[795]: 2021-08-23 15:07:05 970658 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:07:59 mysqld[795]: 2021-08-23 15:07:59 970673 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:08:31 mysqld[795]: 2021-08-23 15:08:31 970689 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 15:08:34 mysqld[795]: 2021-08-23 15:08:34 970690 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 15:08:37 mysqld[795]: 2021-08-23 15:08:37 970701 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 15:08:40 mysqld[795]: 2021-08-23 15:08:40 970704 [Warning] Access denied for user 'wordpress__5'@'localhost' (using password: YES)
aug 23 15:09:22 mysqld[795]: 2021-08-23 15:09:22 970719 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:09:44 mysqld[795]: 2021-08-23 15:09:44 970720 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:09:54 mysqld[795]: 2021-08-23 15:09:54 970721 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:10:21 mysqld[795]: 2021-08-23 15:10:21 970726 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:10:49 mysqld[795]: 2021-08-23 15:10:49 970741 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:11:50 mysqld[795]: 2021-08-23 15:11:50 970756 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:14:31 mysqld[795]: 2021-08-23 15:14:31 970814 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:16:33 mysqld[795]: 2021-08-23 15:16:33 970850 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:19:07 mysqld[795]: 2021-08-23 15:19:07 970926 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:22:31 mysqld[795]: 2021-08-23 15:22:31 970975 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:26:04 mysqld[795]: 2021-08-23 15:26:04 971032 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:26:04 mysqld[795]: 2021-08-23 15:26:04 971033 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:26:51 mysqld[795]: 2021-08-23 15:26:51 971063 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:06 mysqld[795]: 2021-08-23 15:27:06 971066 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:08 mysqld[795]: 2021-08-23 15:27:08 971067 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:11 mysqld[795]: 2021-08-23 15:27:11 971068 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:11 mysqld[795]: 2021-08-23 15:27:11 971069 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:11 mysqld[795]: 2021-08-23 15:27:11 971070 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:12 mysqld[795]: 2021-08-23 15:27:12 971071 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:53 mysqld[795]: 2021-08-23 15:27:53 971076 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:27:53 mysqld[795]: 2021-08-23 15:27:53 971077 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:28:26 mysqld[795]: 2021-08-23 15:28:26 971111 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:28:38 mysqld[795]: 2021-08-23 15:28:38 971120 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
aug 23 15:28:52 mysqld[795]: 2021-08-23 15:28:52 971133 [Warning] Access denied for user 'wordpress__3'@'localhost' (using password: YES)
--------------------------------------------------
OH (YU)NOOOO :frowning: 

What the :duck:  could this happen.

someonesusername · August 23, 2021, 1:57pm

@tituspijean sorry for the mention but HELP I’m of the grid and loosing money

Aleks · August 23, 2021, 2:23pm

You could get help, but first you’d need to start by :

not pinging specific people - they have a life and not everybody likes to get pinged at random hours of they day as if everything lies on their shoulder and as if they are your personal IT support
you could start by providing actual context. For now all we have apart from the error message is “since the last update”. What update ? Did you update some system packages ? Did it update yunohost ? Or do you mean you update wordpress ? Did the upgrade report any error ? Could you share the corresponding logs ?

someonesusername · August 23, 2021, 2:44pm

My sincere apologies Aleks, but I already said sorry for the ping.

hey have a life and not everybody likes to get pinged at random hours of they day as if everything lies on their shoulder and as if they are your personal IT support

That is a wrong assumption you make there. I never ever asked you of someone here to be. I’m just assuming that some people are might have experience with it or just know a lot of stuff, just like you. So it’s more like I mentioned him because he might know what is going on.

Now back on topic, I talk about updating, so I was not speaking specifiably on a kind of update. So in this case it means all of them. Most of the time I first do the system updates then the apps, however I do this URL easycomp.shop no wp3 separate. Because it’s HUGE!

But now while I type this message the domain/website seems to be working again. Like. But, what, huh, who, where? IDK, it’s just a big buzz in my brain how…IT dies and revives? I guess?!

someonesusername · August 23, 2021, 3:02pm

also is this message normal?

Your app wordpress__3 is currently under maintenance!

This app has been put under maintenance by your administrator at ma 23 aug 2021 16:56:40 CEST

Please wait until the maintenance operation is done. This page will be reloaded as soon as your app will be back.

it seems strange and off to me?

someonesusername · August 23, 2021, 3:10pm

Sorry but now I saw WordPress__3 vanish in FTP right in front of me poof gone… uh, now what?
Is there a command to see what’s going on in SSH? Other than PS? I have no indication other than a red flashing HDD led.

someonesusername · August 23, 2021, 3:50pm

Oh, it is back, but still not being able to see what it does very, very much scare me to death almost. Don’t get me wrong Aleks, but it’s just terrifying stuff.

I was finally able to see the log, but the site is wired, it shows up but does not work. easycomp.shop i mean.

e[1m+++ /etc/php/7.3/fpm/pool.d/wordpress__3.conf 2021-08-23 16:56:47.877390567 +0200e[0m
e[36m@@ -15,11 +15,8 @@e[0m
pm.max_requests = 500
request_terminate_timeout = 1d
e[31m-e[0m
; Additional php.ini defines, specific to this pool of workers.
e[31m-php_admin_value[upload_max_filesize] = 1024Me[0m
e[31m-php_admin_value[memory_limit] = 256Me[0m
e[31m-php_admin_value[post_max_size] = 1024Me[0m
e[31m-php_admin_value[allow_url_fopen] = One[0m
e[31m-php_admin_value[max_execution_time] = 120e[0m
\ Geen regeleindeteken (LF) aan einde van bestand
e[32m+php_admin_value[upload_max_filesize] = 50Me[0m
e[32m+php_admin_value[memory_limit] = 64Me[0m
e[32m+php_admin_value[post_max_size] = 50Me[0m
File /var/www/wordpress__3/wp-config.php has been manually modified since the installation or last upgrade. So it has been duplicated in /home/yunohost.conf/backup//var/www/wordpress__3/wp-config.php.backup.20210823.165648
Configuring multisite...
ERROR 1045 (28000): Access denied for user 'wordpress__3'@'localhost' (using password: YES)
[Error] Upgrade failed.
2709928 File /etc/php/7.3/fpm/pool.d/wordpress__3.conf has been manually modified since the installation or last upgrade. So it has been duplicated in /home/yunohost.conf/backup//etc/php/7.3/fpm/pool.d/wordpress__3.conf.backup.20210823.174640
2710389 e[1m--- /home/yunohost.conf/backup//etc/php/7.3/fpm/pool.d/wordpress__3.conf.backup.20210823.174640 2021-08-23 16:41:49.000000000 +0200e[0m
2710389 e[1m+++ /etc/php/7.3/fpm/pool.d/wordpress__3.conf 2021-08-23 17:46:41.262905558 +0200e[0m
2710390 e[36m@@ -15,11 +15,8 @@e[0m
2710390 pm.max_requests = 500
2710390 request_terminate_timeout = 1d
2710390 e[31m-e[0m
2710391 ; Additional php.ini defines, specific to this pool of workers.
2710391 e[31m-php_admin_value[upload_max_filesize] = 1024Me[0m
2710391 e[31m-php_admin_value[memory_limit] = 256Me[0m
 Documentation
 Need help?
 Donate
Powered by YunoHost 4.2.8 (stable).

system · September 22, 2021, 3:50pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.