TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Connection failure with ssh and keyboard-interactive

Open davidneunhoeffer opened this issue 3 years ago • 0 comments

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): 10.5.15-MariaDB-0+deb11u1

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 4.10.2 (202) - x64

  3. The steps to reproduce this issue: I'm currently working with Win10 and i want to connect to a Linux Debian 11 over ssh and keyboard-interactive. I configured the ssh pam that common-auth is disabled so you have to use ssh-keys.

3.1 Install the Google Authenticator PAM Module

apt update -y && apt install libpam-google-authenticator -y

3.2 Generate Your 2FA Code

google-authenticator -t -f -d -w 3 -e 10 -r 3 -R 30

3.3 Edit your SSH PAM configuration file

nano /etc/pam.d/sshd

3.3.1 Add the following line to the bottom of the file

auth required pam_google_authenticator.so nullok

3.3.2 Disable user password authentication. Comment out the following line by adding # to the beginning

# @include common-auth

3.4 Edit the SSH daemon configuration file

Note: Everything works fine if 2fa is disabled.

davidneunhoeffer avatar Aug 15 '22 09:08 davidneunhoeffer