11/21/2023 0 Comments Failed to resolve host sqlprocnf files from configuration directoryĬlient error message: Used command: /usr/bin/ssh -v -N -S none -o ControlMaster=no -o ExitOnForwardFailure=yes -o ConnectTimeout=10 -o NumberOfPasswordPrompts=3 -i /Users/myself/.ssh/id_rsa -o TCPKeepAlive=no -o ServerAliveInterval=60 -o ServerAliveCountMax=1 -L 51130:127.0.0.1:3306ĭebug1: Reading configuration data /Users/myself/.ssh/configĭebug1: Reading configuration data /etc/ssh/ssh_configĭebug1: /etc/ssh/ssh_config line 21: include /etc/ssh/ssh_config.d/* matched no filesĭebug1: /etc/ssh/ssh_config line 54: Applying options for *ĭebug1: Authenticator provider $SSH_SK_PROVIDER did not resolve disablingĭebug1: Control socket " none" does not existĭebug1: Connecting to 123.123.7.7 port 22.ĭebug1: identity file /Users/myself/.ssh/id_rsa type 0ĭebug1: identity file /Users/myself/.ssh/id_rsa-cert type -1ĭebug1: Local version string SSH-2.0-OpenSSH_8.6ĭebug1: Remote protocol version 2.0, remote software version OpenSSH_8.2p1 Ubuntu-4ubuntu0.5ĭebug1: compat_banner: match: OpenSSH_8.2p1 Ubuntu-4ubuntu0.5 pat OpenSSH* compat 0x04000000ĭebug1: Authenticating to 123.123.7.7:22 as 'myuser'ĭebug1: load_hostkeys: fopen /Users/myself/.ssh/known_hosts2: No such file or directoryĭebug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts: No such file or directoryĭebug1: load_hostkeys: fopen /etc/ssh/ssh_known_hosts2: No such file or directoryĭebug1: kex: algorithm: curve25519-sha256ĭebug1: kex: host key algorithm: ssh-ed25519ĭebug1: kex: server->client cipher: MAC: compression: noneĭebug1: kex: client->server cipher: MAC: compression: noneĭebug1: expecting SSH2_MSG_KEX_ECDH_REPLYĭebug1: Server host key: ssh-ed25519 SHA256:asdf/LAU/Yĭebug1: Host '123.123.7.7' is known and matches the ED25519 host key.ĭebug1: Found key in /Users/myself/.ssh/known_hosts:17ĭebug1: Will attempt key: /Users/myself/.ssh/id_rsa RSA SHA256:AO6tKEjnczkQI2lrYFWbLhYpwPFTboZt3+bTd0Tg1JM explicitĭebug1: kex_input_ext_info: server-sig-algs=ĭebug1: Authentications that can continue: publickeyĭebug1: Next authentication method: publickeyĭebug1: Offering public key: /Users/myself/.ssh/id_rsa RSA SHA256:xx+xx explicitĭebug1: Server accepts key: /Users/myself/.ssh/id_rsa RSA SHA256:xx+xx explicitĭebug1: read_passphrase: can't open /dev/tty: Device not configuredĭebug1: Authentication succeeded (publickey).Īuthenticated to 123.123.7.7 (:22).ĭebug1: Local connections to LOCALHOST:51130 forwarded to remote address 127.0.0.1:3306ĭebug1: Local forwarding listening on ::1 port 51130.ĭebug1: Local forwarding listening on 127.0.0.1 port 51130.ĭebug1: Requesting Entering interactive session.ĭebug1: Connection to port 51130 forwarding to 127.0.0.1 port 3306 requested.ĭebug1: client_input_global_request: rtype want_reply 0ĭebug1: client_input_hostkeys: searching /Users/myself/.ssh/known_hosts for 123.123.7.7 / (none)ĭebug1: client_input_hostkeys: searching /Users/myself/.ssh/known_hosts2 for 123.123.7.7 / (none)ĭebug1: client_input_hostkeys: hostkeys file /Users/myself/.ssh/known_hosts2 does not existĭebug1: client_input_hostkeys: no new or deprecated keys from serverĭebug1: Remote: /home/myuser/.ssh/authorized_keys:1: key options: agent-forwarding port-forwarding pty user-rc x11-forwardingĬhannel 2: open failed: connect failed: Connection refusedĭebug1: channel 2: free: direct-tcpip: listening port 51130 for 127.0.0.1 port 3306, connect from 127.0.0.1 port 51133 to 127.0.0.1 port 51130, nchannels 3 Some options may be missing from the help textĭefault options are read from the following files in the given order: 9:03:53 0 Plugin 'FEEDBACK' is disabled. usr/sbin/mysqld: One can only use the -user switch if running as root $ /usr/sbin/mysqld -verbose -help | grep -A 1 "Default options" These directories are included in the configuration. # localhost which is more compatible and is not less secure. # Instead of skip-networking the default is now to listen only on # this is only for the mysqld standalone daemon Unix 2 STREAM LISTENING 269765 39044/mysqld/run/mysqld/mysqld.sockĪnd these are the settings for the file: /etc/mysql//50-server.cnf # this is read by the standalone daemon and embedded servers This command, returns only a socket: sudo netstat -anpe | grep sql Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive : active (running) since Fri 10:25:46 UTC 2 days ago I also cannot access this database remotely over SSH. Type '\c' to clear the current input statement.īut not on the localhost: $ mysql -u root -h 127.0.0.1ĮRROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115) I can access this server through SSH with user myuser and open run the CLI-client on the server to open a prompt for the database. On my remote Ubuntu 20.04 server I have an instance of mariadb running.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |