[SOLVED]MySQL Replication Failed

Discussion in 'Installation/Configuration' started by Xase, Sep 20, 2018.

  1. Xase

    Xase Member

    SOLVED... I hadf a misconfiguration of /etc/hosts still.

    I fixed this error last night with @till 's advice about adding the ipv6 to the /etc/hosts file
    But now it's back... this time with the external vhost for my IP... correct me if my terminology is wrong but here is the server.sh output from slave
    Code:
    [email protected]:~# /usr/local/ispconfig/server/server.sh
    19.09.2018-20:25 - WARNING - There is already a lockfile set, but no process running with this pid (14966). Continuing.
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198
    DB::query -> reconnectUnable to load the server configuration from database.PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    PHP Warning:  mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'cpe-174-105-101-49.columbus.res.rr.com' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83
    Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible!
    
    
    I'm not sure how to avoid this. Maybe it has something to do with the way I configured my DNS zones?
    or which server I should point this at in which /etc/hosts. I would assume since it's my external vhost (again correct me if I'm using the wrong term) I should point this to my first server "miyagi". Obviously in both instances of /etc/hosts But why/where does it keep grabbing these users from? I believe it also has to do with the artifact of not being able to get a static ipv6 lease. I posted that in the Linux Install/configuration section. So if these two are related, I'd be interested to know.
     
    Last edited: Sep 20, 2018
  2. ahrasis

    ahrasis Well-Known Member

    You can just use ipv4 without ipv6, if ipv6 is the problem, but I don't think that was your problem.

    Check and test your public ipv4 and ipv6 before you set them in your /etc/hosts.
     
  3. Xase

    Xase Member

    On the slave server I had it pointing the primary's IPs at itself on accident... Novice moment :(
     

Share This Page