Installaron - problem installing Wordpress

A

arky_

Verified User
Joined
Apr 25, 2020
Messages
67
Fresh installatron plugin installation. At the time of installing wordpress, I get the following error:
Code: 
Błąd
mysql database connection failed:
host = localhost
database = admin_k8kb1
username = admin_k8kb1
password = **HIDDEN**
prefix = riz9_
errstr = Could not connect to `localhost` using the username `admin_k8kb1` and password **HIDDEN** (mysqli) -- [1045] Access denied for user 'admin_k8kb1'@'localhost' (using password: YES)
At this point the installation is terminated.
 
I wrote to them, they suspected that the firewall was blocking but that's not it.
So, to recap: this is the error that you see when trying to install:
Code: 
Could not connect to `localhost` using the username `admin_k8kb1` and password **HIDDEN** (mysqli) -- [1045] Access denied for user 'admin_k8kb1'@'localhost' (using password: YES)
But in the debug log I can see that every time Installatron makes a HTTP call to domain it produces this error from DirectAdmin's plugin API:
Code: 
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8;"/>
        <meta name="viewport" content="width=device-width, initial-scale=1"/>
        
        <title>
            192.168.22.179 | Login
        </title>
        <link rel="shortcut icon" href="/images/favicon.png" type="image/x-icon" />
        <meta name="robots" content="noindex,nofollow" />
        <script>
            var tokens = {
                LOST_PASSWORD: "no" === "yes",
                TIME: {
                    current: 1589804309 * 1000,
                    offset: 86400 * 1000,
                },
                AUTH_METHOD: "CMD_LOGIN",
                QUESTION: "|QUESTION_JSON|",
                LOGIN_LANGUAGES: "default=en;en=English;pl=polski;",
                GEO_IP_LANG: "|GEO_IP_LANG|",
                trial: "|IS_TRIAL_LICENSE|",
            };
        </script>
    <link href="/assets/css/login.css" rel="stylesheet"></head>
    <body>
        <div id="login"></div>
    <script type="text/javascript" src="/assets/login.js"></script></body>
</html>
It's asking Installatron to log in, which Installatron can't do.
 
In case you masked your real ip by changing it to a private ip in te log, lets try this:

arky_ said:
Could not connect to `localhost` using the username `admin_k8kb1` and password **HIDDEN** (
Click to expand...
If you try this via SSH, so login via ssh try logging in like this:
Code: 
mysql -u admin_k8kb1 -p
hit enter, then it will ask for the password, then enter the correct password you filled in DA.
Does that get you into mysql, or do you get the same error notice?

To get out of mysql just type:
\q
 
[QUOTE = "Richard G, post: 315729, członek: 16122"]
Jeśli zamaskowałeś swój prawdziwy adres IP, zmieniając go na prywatny adres IP w dzienniku, spróbuj:


Jeśli spróbujesz to przez SSH, więc zaloguj się przez ssh, spróbuj zalogować się w następujący sposób:
[kod] mysql -u admin_k8kb1 -p [/ code]
naciśnij enter, wtedy poprosi o hasło, a następnie wprowadź poprawne hasło, które wpisałeś DA.
Czy to powoduje przejście do mysql, czy pojawia się ten sam komunikat o błędzie?

Aby wyjść z mysql, po prostu wpisz:
\ q
[/QUOTE]
I log in without a problem.
 
Last edited:
Try and change this if that helps in any way in the script if possible:
Code: 
host = localhost
to
Code: 
host = 127.0.0.1

Also check your /etc/my.cnf file if it contains this under [mysqld]
bind-address = 127.0.0.1

Don't forget to restart mysql if you change or add this.
If that doesn't work, I don't know.
 
Here is my my.cnf content
Code: 
[Mysqld]
local-infile = 0
innodb_file_per_table

[Client]
socket = / usr / local / mysql / data / mysql.sock
Do I understand correctly, should I add host = 127.0.0.1 in my.cnf?
 
arky_ said:
Do I understand correctly, should I add host = 127.0.0.1 in my.cnf?
Click to expand...
No
Also check your /etc/my.cnf file if it contains this under [mysqld]
bind-address = 127.0.0.1 <<<<<this line
 
There is no such field in the my.cnf file, add [
mysqld address] = 127.0.0.1...??
 
Open the file something like
Code: 
nano my.cnf
find the
[Mysqld] section
insert a line under it
paste or type in the below
Code: 
bind-address = 127.0.0.1

Save file.
restart database server.
 
So I did and still the same mistake.
Here is my configuration:
Code: 
[mysqld]
local-infile=0
innodb_file_per_table
bind-address = 127.0.0.1

[client]
socket=/usr/local/mysql/data/mysql.sock
 
I didn't ever have issues with Installatron and Wordpress with DA.
So the only thing I can think of is that is must have something to do with the fact that it's running on a local ip somehow.
 
You must log in or register to reply here.
Back
Top