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.
Start with this: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ Is this a single server setup? Are you sure it is password for MySQL root user? Check you have edited mysql config file as the guide instructs.
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
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.
Thanks for reply. Yes I can, never had issue with login to MySQL and here is image: 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?
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
Yes, I did remove # and try with #, rebooting server after change, and still same error: This is tutorial I followed https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/
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]
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
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'?
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.
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.
