Ispconfig3 MySQL issue

Discussion in 'Installation/Configuration' started by nekic, Jan 30, 2020.

  1. nekic

    nekic New Member

    Hello,

    following tutorial https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/ server was prepared for ispconfig installation.

    After reaching part for "Initial configuration" on 18.04.3 LTS and after entering password for root every time i got same error:
    Unable to connect to the specified MySQL server Can't connect to local MySQL server through socket '/dev/null' (111)

    For case, I must add that I can login to mysql with root and selected password.
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. nekic

    nekic New Member

    Thank you for your reply! Yes, im sure that password is right and correct.
    Here is report and yes, it is single server setup. I did try at least 5 times, and every time im on same error

    Paste Bin C o m R4MGmCFd
     
  4. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    Can you login to MySQL using
    Code:
    mariadb -u root -p
    , or do you get the same error?
    If you get the same error, run
    Code:
    systemctl status mariadb
    and check the state of mariaDB. If it's failed, look for errors in systemctl or in the logs.
     
    nekic likes this.
  5. nekic

    nekic New Member

    Thanks for reply. Yes I can, never had issue with login to MySQL and here is image:

    [​IMG]

    Here is log:

    HTML:
    mariadb.service - MariaDB 10.1.43 database server
       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
       Active: active (running) since Fri 2020-01-31 14:03:51 UTC; 5min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 929 (mysqld)
       Status: "Taking your SQL requests now..."
        Tasks: 27 (limit: 1152)
       CGroup: /system.slice/mariadb.service
               └─929 /usr/sbin/mysqld
    
    Jan 31 14:03:48 adm.mydomain.info systemd[1]: Starting MariaDB 10.1.43 database server...
    Jan 31 14:03:50 adm.mydomain.info mysqld[929]: 2020-01-31 14:03:50 140063482399872 [Note] /usr/sbin/mysqld (mys
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1014]: Upgrading MySQL tables if necessary.
    Jan 31 14:03:51 adm.mydomain.info systemd[1]: Started MariaDB 10.1.43 database server.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: /usr/bin/mysql_upgrade: the '--basedir' option
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysql' as: /usr/bin/mysql
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysqlcheck' as: /usr/bin/mysqlche
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: This installation of MySQL is already upgraded
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1032]: Checking for insecure root accounts.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1040]: Triggering myisam-recover for all MyISAM table
    lines 1-21/21 (END)...skipping...
    ● mariadb.service - MariaDB 10.1.43 database server
       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
       Active: active (running) since Fri 2020-01-31 14:03:51 UTC; 5min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 929 (mysqld)
       Status: "Taking your SQL requests now..."
        Tasks: 27 (limit: 1152)
       CGroup: /system.slice/mariadb.service
               └─929 /usr/sbin/mysqld
    
    Jan 31 14:03:48 adm.mydomain.info systemd[1]: Starting MariaDB 10.1.43 database server...
    Jan 31 14:03:50 adm.mydomain.info mysqld[929]: 2020-01-31 14:03:50 140063482399872 [Note] /usr/sbin/mysqld (mysqld 10.1.43-MariaDB-0ubuntu0.18.04.1) starting as process
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1014]: Upgrading MySQL tables if necessary.
    Jan 31 14:03:51 adm.mydomain.info systemd[1]: Started MariaDB 10.1.43 database server.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysql' as: /usr/bin/mysql
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: This installation of MySQL is already upgraded to 10.1.43-MariaDB, use --force if you still need to run
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1032]: Checking for insecure root accounts.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1040]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    lines 1-21/21 (END)...skipping...
    ● mariadb.service - MariaDB 10.1.43 database server
       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
       Active: active (running) since Fri 2020-01-31 14:03:51 UTC; 5min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 929 (mysqld)
       Status: "Taking your SQL requests now..."
        Tasks: 27 (limit: 1152)
       CGroup: /system.slice/mariadb.service
               └─929 /usr/sbin/mysqld
    
    Jan 31 14:03:48 adm.mydomain.info systemd[1]: Starting MariaDB 10.1.43 database server...
    Jan 31 14:03:50 adm.mydomain.info mysqld[929]: 2020-01-31 14:03:50 140063482399872 [Note] /usr/sbin/mysqld (mysqld 10.1.43-MariaDB-0ubuntu0.18.04.1) starting as process
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1014]: Upgrading MySQL tables if necessary.
    Jan 31 14:03:51 adm.mydomain.info systemd[1]: Started MariaDB 10.1.43 database server.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysql' as: /usr/bin/mysql
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: This installation of MySQL is already upgraded to 10.1.43-MariaDB, use --force if you still need to run
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1032]: Checking for insecure root accounts.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1040]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    ~
    lines 1-21/21 (END)...skipping...
    ● mariadb.service - MariaDB 10.1.43 database server
       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
       Active: active (running) since Fri 2020-01-31 14:03:51 UTC; 5min ago
         Docs: man:mysqld(8)
               https://mariadb.com/kb/en/library/systemd/
     Main PID: 929 (mysqld)
       Status: "Taking your SQL requests now..."
        Tasks: 27 (limit: 1152)
       CGroup: /system.slice/mariadb.service
               └─929 /usr/sbin/mysqld
    
    Jan 31 14:03:48 adm.mydomain.info systemd[1]: Starting MariaDB 10.1.43 database server...
    Jan 31 14:03:50 adm.mydomain.info mysqld[929]: 2020-01-31 14:03:50 140063482399872 [Note] /usr/sbin/mysqld (mysqld 10.1.43-MariaDB-0ubuntu0.18.04.1) starting as process
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1014]: Upgrading MySQL tables if necessary.
    Jan 31 14:03:51 adm.mydomain.info systemd[1]: Started MariaDB 10.1.43 database server.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysql' as: /usr/bin/mysql
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1018]: This installation of MySQL is already upgraded to 10.1.43-MariaDB, use --force if you still need to run
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1032]: Checking for insecure root accounts.
    Jan 31 14:03:51 adm.mydomain.info /etc/mysql/debian-start[1040]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
    
    Any other suggestion what to check?
     
  6. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    Did you untag
    Code:
    bind adress=127.0.0.1
    in
    Code:
    nano /etc/mysql/mariadb.conf.d/50-server.cnf
    ?
    Also, verify your settings with the steps in the Perfect Server tutorial
     
    nekic likes this.
  7. nekic

    nekic New Member

  8. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    What is the content of /etc/mysql/mariadb.conf.d/50-client.cnf ?
     
    nekic likes this.
  9. nekic

    nekic New Member

    Here it is, did not change anything

    Code:
    #
    # This group is read by the client library
    # Use it for options that affect all clients, but not the server
    #
    
    [client]
    # Default is Latin1, if you need UTF-8 set this (also in server section)
    default-character-set = utf8mb4
    
    # socket location
    socket = /var/run/mysqld/mysqld.sock
    
    # Example of client certificate usage
    # ssl-cert=/etc/mysql/client-cert.pem
    # ssl-key=/etc/mysql/client-key.pem
    #
    # Allow only TLS encrypted connections
    # ssl-verify-server-cert=on
    
    # This group is *never* read by mysql client library, though this
    # /etc/mysql/mariadb.cnf.d/client.cnf file is not read by Oracle MySQL
    # client anyway.
    # If you use the same .cnf file for MySQL and MariaDB,
    # use it for MariaDB-only client options
    [client-mariadb]
    
    
     
  10. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    And your mariadb error log?
    Code:
    nano /var/log/mysql/error.log
     
  11. nekic

    nekic New Member

    HTML:
    2020-01-31T08:30:33.383744Z 4269 [Note] Got packets out of order
    2020-01-31T08:37:30.051604Z 4284 [Note] Got packets out of order
    2020-01-31T11:43:14.170681Z 4860 [Warning] IP address '83.97.20.33' has been resolved to the host name '33.20.97.83.ro.ovo.sc', which resembles IPv4-address itself.
    2020-01-31T11:43:17.257292Z 4860 [Note] Got an error reading communication packets
    2020-01-31T15:46:27.642831Z 0 [Note] Giving 0 client threads a chance to die gracefully
    2020-01-31T15:46:27.642877Z 0 [Note] Shutting down slave threads
    2020-01-31T15:46:27.642885Z 0 [Note] Forcefully disconnecting 0 remaining clients
    2020-01-31T15:46:27.642896Z 0 [Note] Event Scheduler: Purging the queue. 0 events
    2020-01-31T15:46:27.644024Z 0 [Note] Binlog end
    2020-01-31T15:46:27.644528Z 0 [Note] Shutting down plugin 'auth_socket'
    2020-01-31T15:46:27.644542Z 0 [Note] Shutting down plugin 'ngram'
    2020-01-31T15:46:27.644545Z 0 [Note] Shutting down plugin 'partition'
    2020-01-31T15:46:27.644549Z 0 [Note] Shutting down plugin 'BLACKHOLE'
    2020-01-31T15:46:27.644553Z 0 [Note] Shutting down plugin 'ARCHIVE'
    2020-01-31T15:46:27.644556Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2020-01-31T15:46:27.644587Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
    2020-01-31T15:46:27.644592Z 0 [Note] Shutting down plugin 'MyISAM'
    2020-01-31T15:46:27.644599Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
    2020-01-31T15:46:27.644603Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2020-01-31T15:46:27.644606Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2020-01-31T15:46:27.644609Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2020-01-31T15:46:27.644612Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2020-01-31T15:46:27.644614Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2020-01-31T15:46:27.644617Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2020-01-31T15:46:27.644620Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2020-01-31T15:46:27.644623Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2020-01-31T15:46:27.644626Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2020-01-31T15:46:27.644628Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2020-01-31T15:46:27.644631Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2020-01-31T15:46:27.644633Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2020-01-31T15:46:27.644636Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2020-01-31T15:46:27.644639Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2020-01-31T15:46:27.644641Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2020-01-31T15:46:27.644644Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
    2020-01-31T15:46:27.644647Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
    2020-01-31T15:46:27.644649Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2020-01-31T15:46:27.644652Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2020-01-31T15:46:27.644655Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2020-01-31T15:46:27.644657Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2020-01-31T15:46:27.644660Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2020-01-31T15:46:27.644663Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2020-01-31T15:46:27.644665Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2020-01-31T15:46:27.644668Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2020-01-31T15:46:27.644670Z 0 [Note] Shutting down plugin 'INNODB_CMP'
    2020-01-31T15:46:27.644673Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2020-01-31T15:46:27.644676Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
    2020-01-31T15:46:27.644679Z 0 [Note] Shutting down plugin 'INNODB_TRX'
    2020-01-31T15:46:27.644681Z 0 [Note] Shutting down plugin 'InnoDB'
    2020-01-31T15:46:27.644730Z 0 [Note] InnoDB: FTS optimize thread exiting.
    2020-01-31T15:46:27.644866Z 0 [Note] InnoDB: Starting shutdown...
    2020-01-31T15:46:27.745137Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
    2020-01-31T15:46:27.746026Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200131 16:46:27
    2020-01-31T15:46:29.072507Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1133399652
    2020-01-31T15:46:29.074341Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-01-31T15:46:29.074374Z 0 [Note] Shutting down plugin 'MEMORY'
    2020-01-31T15:46:29.074384Z 0 [Note] Shutting down plugin 'CSV'
    2020-01-31T15:46:29.074391Z 0 [Note] Shutting down plugin 'sha256_password'
    2020-01-31T15:46:29.074396Z 0 [Note] Shutting down plugin 'mysql_native_password'
    2020-01-31T15:46:29.074628Z 0 [Note] Shutting down plugin 'binlog'
    2020-01-31T15:46:29.075003Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
    
    2020-01-31T15:47:15.960144Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2020-01-31T15:47:15.966278Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-0ubuntu0.18.04.1) starting as process 939 ...
    2020-01-31T15:47:15.984340Z 0 [Note] InnoDB: PUNCH HOLE support available
    2020-01-31T15:47:15.984369Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2020-01-31T15:47:15.984373Z 0 [Note] InnoDB: Uses event mutexes
    2020-01-31T15:47:15.984377Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
    2020-01-31T15:47:15.984380Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-01-31T15:47:15.984386Z 0 [Note] InnoDB: Using Linux native AIO
    2020-01-31T15:47:15.986348Z 0 [Note] InnoDB: Number of pools: 1
    2020-01-31T15:47:15.992015Z 0 [Note] InnoDB: Using CPU crc32 instructions
    2020-01-31T15:47:15.997501Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
    2020-01-31T15:47:16.033662Z 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-01-31T15:47:16.050844Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
    2020-01-31T15:47:16.068452Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
    2020-01-31T15:47:16.169343Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-01-31T15:47:16.169402Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-01-31T15:47:16.240654Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
    2020-01-31T15:47:16.241355Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
    2020-01-31T15:47:16.241368Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
    2020-01-31T15:47:16.242137Z 0 [Note] InnoDB: Waiting for purge to start
    2020-01-31T15:47:16.292310Z 0 [Note] InnoDB: 5.7.29 started; log sequence number 1133399652
    2020-01-31T15:47:16.292525Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2020-01-31T15:47:16.293244Z 0 [Note] Plugin 'FEDERATED' is disabled.
    2020-01-31T15:47:16.330739Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
    2020-01-31T15:47:16.331535Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
    2020-01-31T15:47:16.344067Z 0 [Warning] CA certificate ca.pem is self signed.
    2020-01-31T15:47:16.344122Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
    2020-01-31T15:47:16.345761Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
    2020-01-31T15:47:16.345832Z 0 [Note] IPv6 is available.
    2020-01-31T15:47:16.345838Z 0 [Note]   - '::' resolves to '::';
    2020-01-31T15:47:16.345858Z 0 [Note] Server socket created on IP: '::'.
    2020-01-31T15:47:16.450491Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200131 16:47:16
    2020-01-31T15:47:16.464875Z 0 [Note] Event Scheduler: Loaded 0 events
    2020-01-31T15:47:16.465054Z 0 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.7.29-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
    2020-01-31T16:07:57.827070Z 54 [Warning] Hostname 'f360853.rederatural.com' does not resolve to '104.140.188.26'.
    2020-01-31T16:07:57.827128Z 54 [Note] Hostname 'f360853.rederatural.com' has the following IP addresses:
    2020-01-31T16:07:57.827171Z 54 [Note]  - 23.82.12.30
    2020-01-31T16:08:07.833058Z 54 [Note] Got timeout reading communication packets
    
     
  12. Steini86

    Steini86 Active Member

    Could be that you have a strange symbol in your password? Is the password stored in /usr/local/ispconfig/server/lib/mysql_clientdb.conf correct? Is the host 'localhost'?
     
  13. nekic

    nekic New Member

    Thank you for your help. I did try more than 10 times to install but without succes. Thats why I installed on debian with autoinstall. If anyone have time, please check ubuntu droplests at digitalocean. No mater what I was not able to pass database issue.
     
  14. nhybgtvfr

    nhybgtvfr Active Member

    unless it's a very recent non-standard change they've made to their ubuntu images then it's not something specific to digitalocean.
    we have several droplets running on digitalocean running ispconfig without any problems.

    I don't see why the install is warning about can't connect through socket '/dev/null' rather than the correct socket location.
    try
    MySQL -h localhost -u root -p
    MySQL -h 127.0.0.1 -u root -p
    MySQL -h <host.domain.tld> -u root -p

    see if any of those succeed/fail.
     

Share This Page