Errors in logs - New KeyHelp installation - Ubuntu 20.04

Locked
User avatar
gusarg81
Posts: 33
Joined: Sun 18. Jul 2021, 02:20
Location: Argentina
Contact:

Errors in logs - New KeyHelp installation - Ubuntu 20.04

Post by gusarg81 »

Hi,

Every certain amount of seconds, I see this in logs:
Jul 21 23:52:25 server postfix/submission/smtpd[75940]: connect from localhost[127.0.0.1]
Jul 21 23:52:25 server mariadbd[1093]: 2021-07-21 23:52:25 3128 [Warning] Aborted connection 3128 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 21 23:52:25 server postfix/submission/smtpd[75940]: lost connection after CONNECT from localhost[127.0.0.1]
Jul 21 23:52:25 server postfix/submission/smtpd[75940]: disconnect from localhost[127.0.0.1] commands=0/0
Jul 21 23:52:25 server dovecot: imap-login: Disconnected (disconnected before auth was ready, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS handshaking: Connection closed, session=<Yop4YK3HZo5/AAAB>
Jul 21 23:52:25 server dovecot: pop3-login: Disconnected (no auth attempts in 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, TLS handshaking: Connection closed, session=<U5Z4YK3HRNZ/AAAB>
It is something wrong with the installation?

Still the server is not in production, I am migrating all from i-MSCP, but I want to make sure that this will not cause any problems later.

Thanks in advance.

EDIT 1: Also, just in case if is related, the only warning I had during installation was:
db | UPDATE `mysql`.`user` SET `Password` = PASSWORD('***DB_ROOT_PASS***') WHERE `User` = 'root'
Database error: SQLSTATE[HY000]: General error: 1356 View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ERROR DETECTED <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

[SKIPPED DUE PREVIOUS ERRORS] db | DELETE FROM `mysql`.`user` WHERE `User` = 'root' AND `Host` NOT IN ('localhost', '127.0.0.1', '::1')
[SKIPPED DUE PREVIOUS ERRORS] db | DELETE FROM `mysql`.`user` WHERE `User` = ''
[SKIPPED DUE PREVIOUS ERRORS] db | DROP DATABASE IF EXISTS `test`
[SKIPPED DUE PREVIOUS ERRORS] db | FLUSH PRIVILEGES
[SKIPPED DUE PREVIOUS ERRORS] db | GRANT ALL PRIVILEGES ON *.* TO 'mysqladmin'@'localhost' IDENTIFIED BY '***DB_ROOT_PASS***' WITH GRANT OPTION
EDIT 2: also, I found this:
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 286
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 111
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 112
[22-Jul-2021 00:17:06 America/Argentina/Buenos_Aires] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 122
[22-Jul-2021 00:17:07 America/Argentina/Buenos_Aires] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 131
[22-Jul-2021 00:17:07 America/Argentina/Buenos_Aires] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
User avatar
Alexander
Keyweb AG
Posts: 3814
Joined: Wed 20. Jan 2016, 02:23

Re: Errors in logs - New KeyHelp installation - Ubuntu 20.04

Post by Alexander »

There is an issue with your MariaDB installation on your server.

Have you installed KeyHelp on a clean and minimal operating system installation?

Which version of MariaDB is running on the server?

(As it seams, you are running something >= 10.4.x before starting the installation - Please stick to the operating system defaults, which is MariaDB 10.3.x for Ubuntu 20 - after the installation has finished, you can update the version as you like)
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
gusarg81
Posts: 33
Joined: Sun 18. Jul 2021, 02:20
Location: Argentina
Contact:

Re: Errors in logs - New KeyHelp installation - Ubuntu 20.04

Post by gusarg81 »

Alexander wrote: Fri 23. Jul 2021, 11:29 There is an issue with your MariaDB installation on your server.

Have you installed KeyHelp on a clean and minimal operating system installation?

Which version of MariaDB is running on the server?

(As it seams, you are running something >= 10.4.x before starting the installation - Please stick to the operating system defaults, which is MariaDB 10.3.x for Ubuntu 20 - after the installation has finished, you can update the version as you like)
Yes, my mistake. My server already had an newer version of MariaDB. Anyways, I've executed by hand the left queries of the error logs and seems all works normally (at least, those errors are not shown anymore in syslog).
Locked