Correct my.cnf file?

Hi all,

I'm trying to install ISP Config on Debian 9 with this tutorial:
https://www.howtoforge.com/tutorial...ase-cluster-on-debian-8.4-with-ispconfig-3/2/

I am up to 5.1 - MySQL Master-Master Replication (Prepare Server1).
It asks to edit /etc/mysql/my.cnf and then add some stuff in the "mysqld" section - but "mysqld" section doesn't exist in this file. Am I looking at the correct file? I'm using MariaDB. I have looked at a few files in and around this folder but I can't see anything that has a section called mysqld. Please help!

 

In other news, I'm having issues getting the slave to connect to the master in this tutorial. When I issue the SHOW SLAVE STATUS \G command from within MariaDB, I get errors:

Code:

MariaDB [(none)]> SHOW SLAVE STATUS \G
*************************** 1. row ***************************
               Slave_IO_State: Waiting to reconnect after a failed registration on master
                  Master_Host: ISP-Config-1.launcestonit.int
                  Master_User: slaveuser2
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File:
          Read_Master_Log_Pos: 4
               Relay_Log_File: mysqld-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File:
             Slave_IO_Running: Connecting
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 0
              Relay_Log_Space: 249
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 1597
                Last_IO_Error: Master command COM_REGISTER_SLAVE failed: Access denied for user 'slaveuser2'@'isp-config-2.launcestonit.int' (using password: YES) (Errno: 1045)
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Master_Server_Id: 1
               Master_SSL_Crl:
           Master_SSL_Crlpath:
                   Using_Gtid: No
                  Gtid_IO_Pos:
      Replicate_Do_Domain_Ids:
  Replicate_Ignore_Domain_Ids:
                Parallel_Mode: conservative
1 row in set (0.00 sec)

MariaDB [(none)]>

So it couldn't connect, seems like a password issue, right? Or is it because I have mistyped the hostname of the master server? How and where do I go to fix these issues? Or how do I narrow down the potential issues?

 

I fixed the second issue, I must have made a mistake in the hosts file. I simplified the host names (made them shorter and easier to type without mistake) and then I compared the host files on both machines. All good.

Still not sure about the first issue though. But it all seems to be working. Tutorial definitely needs error correction!