Second dns server not updating

Discussion in 'Installation/Configuration' started by zustudios, Jan 21, 2018.

Page 2 of 2
  1. till

    till Super Moderator Staff Member ISPConfig Developer

    There are no database entries in the ISPConfig database to be edited for a hostname change. My guess is that you did not use the phpmyadmin user editor and edited the mysql.user table manually instMySQLA mysql user with complex permissions consists of many different records in the 'mysql' database, thats why one should not mess in mysql.user table directly and use the user editor in phpmyadmin instead which correctly edits the user. But that's not ISPconfig specific and applies to all kind of MySQL users.
     
    till, Feb 22, 2018
    #21
  2. zustudios

    zustudios Member

    I keep getting connection timed out with those commands.
     
    zustudios, Feb 22, 2018
    #22
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    And that's the reason why ISPConfig is not able to fetch the changes from master. What can be the reason for a connection error?

    - Wrong hostname setup (the hostname of the master in /etc/hosts on the slave points to a wrong IP).
    - MySQL port closed on master server.
    - Mysql on master is bound to localhost only and not the external network interface.
     
    till, Feb 22, 2018
    #23
  4. zustudios

    zustudios Member

    I'll try and redo the tutorial. My only problem is the packages are different on ubuntu 16.04.
     
    zustudios, Feb 22, 2018
    #24
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no need to redo the tutorial. Just check why mysql on master is unreachable.
     
    till, Feb 22, 2018
    #25
  6. zustudios

    zustudios Member

    Can someone correct these commands? I think this is my problem... What should I use instead of root?
    CREATE USER 'root'@'1.2.3.5' IDENTIFIED BY 'yourrootsqlpassword';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'1.2.3.5' IDENTIFIED BY 'yourrootsqlpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

    CREATE USER 'root'@'server2.example.com' IDENTIFIED BY 'yourrootsqlpassword';
    GRANT ALL PRIVILEGES ON * . * TO 'root'@'server2.example.com' IDENTIFIED BY 'yourrootsqlpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

    FLUSH PRIVILEGES;

    quit;
     
    zustudios, Feb 22, 2018
    #26
  7. Rabenkind

    Rabenkind Member

    Yes, but your OWN manual says I can use the shell comand to create and update users.
    phpmyadmin updates the database as well as a command - in fact using the sql-editor there is exactly like typing the commands directly(try to copy paste them if you don't belive me). If there is something different in phpmyadmin and the shell please have the grace to document it properly.
    I agree that is why I asked for a procedure. because changing form 'ispcsrv8'@'OLDhostname.tld' to 'ispcsrv8'@'NEWhostname.tld' works only in part (Jobqueue does not get processed) Have you tried it? There seems to be no official procedure.

    I had to redo 3 Servers because of this issue. Could you also have a look at the DNS-Problems please?
     
    Rabenkind, Feb 22, 2018
    #27
  8. Rabenkind

    Rabenkind Member

    Manual and Perfect Server setup also say to use root.
     
    Rabenkind, Feb 22, 2018
    #28
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    You can do it on the shell as well, I just recommended you to use phpmyadmin as you seem to have problems to change a MySQL user on the shell.

    Of course, I did this many times. That's a simple MySQL connect, not different from e.g. cms like WordPress that connects to a MySQL database, so no reason to reinstall something.
     
    till, Feb 22, 2018
    #29
  10. till

    till Super Moderator Staff Member ISPConfig Developer

    Sorry, but you are completely wrong here. And no, there is no issue in the manual. Maybe you should reread this thread, I'll explained it all there and I don't want to repeat myself. The root user is NOT used for the slave to connect to the master to fetch config transactions. The root user is solely used by the instaööer to create the ispcsrv* user on the master during install. And that's why the root user is also not the cause for the problem from @zustudios
     
    till, Feb 22, 2018
    #30
  11. zustudios

    zustudios Member

    What do you mean by this...?
     
    zustudios, Feb 22, 2018
    #31
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    I explained that in detail in post #18 of this thread.
     
    till, Feb 22, 2018
    #32
  13. zustudios

    zustudios Member

    So the commands I posted is something different then #18? I'm a little confused.
    I used the commands on the tutorial and the second server shows up on the panel.
     

    Attached Files:

    zustudios, Feb 22, 2018
    #33
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, something completely different. See post #30: The root user is used at install time only to create the ispcsrv* users, not more and not less. And the ispcsrv* users are used then by the server.sh script to fetch changes.

    Please run the command:

    wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    on the master server and post the output.
     
    till, Feb 22, 2018
    #34
  15. zustudios

    zustudios Member

    root@ns1:~# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    ##### SCRIPT FINISHED #####
    Results can be found in htf_report.txt
    To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console.

    If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug).
    root@ns1:~# php -q htf-common-issues.php --debug

    ##### SERVER #####
    IP-address (as per hostname): 127.0.1.1
    IP-address(es) (as per ifconfig): my.ip.1.2.
    [WARN] ip addresses from hostname differ from ifconfig output. Please check your ip settings.
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.11


    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.0.22-0ubuntu0.16.04.1

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 1786)
    [INFO] I found the following mail server(s):
    Postfix (PID 2555)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 1451)
    [INFO] I found the following imap server(s):
    Dovecot (PID 1451)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 2364)

    ##### LISTENING PORTS #####
    (only ()
    Local (Address)
    0.0.0.0:22 (1219/sshd)
    0.0.0.0:25 (2555/master)
    127.0.0.1:953 (1211/named)
    0.0.0.0:993 (1451/dovecot)
    0.0.0.0:995 (1451/dovecot)
    127.0.0.1:10023 (1757/postgrey.pid)
    127.0.0.1:10024 (2504/amavisd-new)
    127.0.0.1:10025 (2555/master)
    127.0.0.1:10026 (2504/amavisd-new)
    127.0.0.1:10027 (2555/master)
    0.0.0.0:587 (2555/master)
    127.0.0.1:11211 (1214/memcached)
    0.0.0.0:5901 (1537/Xtightvnc)
    0.0.0.0:110 (1451/dovecot)
    0.0.0.0:143 (1451/dovecot)
    0.0.0.0:465 (2555/master)
    0.0.0.0:6001 (1537/Xtightvnc)
    0.0.0.0:21 (2364/pure-ftpd)
    47.47.194.71:53 (1211/named)
    127.0.0.1:53 (1211/named)
    :::22 (1219/sshd)
    :::25 (2555/master)
    ::1:953 (1211/named)
    :::443 (1786/apache2)
    :::993 (1451/dovecot)
    :::995 (1451/dovecot)
    ::1:10023 (1757/postgrey.pid)
    ::1:10024 (2504/amavisd-new)
    ::1:10026 (2504/amavisd-new)
    :::3306 (1692/mysqld)
    :::587 (2555/master)
    :::110 (1451/dovecot)
    :::143 (1451/dovecot)
    :::8080 (1786/apache2)
    :::80 (1786/apache2)
    :::465 (2555/master)
    :::8081 (1786/apache2)
    :::21 (2364/pure-ftpd)
    :::53 (1211/named)




    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target prot opt source destination
    f2b-dovecot-pop3imap tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 110,995,143,993
    f2b-pureftpd tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 21
    f2b-postfix-sasl tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 25
    f2b-sshd tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 22

    Chain FORWARD (policy ACCEPT)
    target prot opt source destination

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination

    Chain f2b-dovecot-pop3imap (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0

    Chain f2b-postfix-sasl (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0

    Chain f2b-pureftpd (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0

    Chain f2b-sshd (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0



    root@ns1:~#
     
    zustudios, Feb 22, 2018
    #35
Page 2 of 2

Share This Page