dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.7k stars 3.52k forks source link

Fail to reconnect to Snowflake connection with external browser authentificator after DBeaver restart #8867

Closed CATGF closed 4 years ago

CATGF commented 4 years ago

System information:

Connection specification:

Describe the problem you're observing:

When I start DBeaver and try connect to my existing Snowflake connections, the authentication windows doesn't open in the web browser and the connection fail with error : Connection timed out: connect. To be able to connect to Snowflake, I need to go to Window >> Preferences >> General >> Network connections, then set the Active provider to DIRECT and Apply, then set the Active provider back to MANUAL and Apply. Now I can connect to Snowflake until I restart DBeaver and fall in this issue again.

Steps to reproduce, if exist:

Configure DBeaver to use a proxy for HTTP and HTTPS, setup a Snowflake connection with Authentificator: External browser, connection to Snowflake should works fine. Restart DBeaver and try to connect to the previous Snowflake connection should fail with the error described above.

Include any warning/errors/backtraces from the logs

Relevant traces in dbeaver-debug.log

Start DBeaver UI Editors - Connections [org.jkiss.dbeaver.ui.editors.connection 1.0.25.202005311732] Start DBeaver Snowflake UI [org.jkiss.dbeaver.ext.snowflake.ui 1.0.54.202005311732] Start DBeaver SSH tunnels [org.jkiss.dbeaver.net.ssh.ui 1.0.55.202005311732] Start DBeaver SSH tunnels [org.jkiss.dbeaver.net.ssh 1.0.55.202005311732] Start DBeaver Generic Plug-in [org.jkiss.dbeaver.ext.generic 2.3.120.202005311732] Jun 02, 2020 4:12:30 PM net.snowflake.client.core.SecureStorageWindowsManager getCredential INFO: Failed to read target or could not find it in Windows Credential Manager. Error code = 1168 Jun 02, 2020 4:14:37 PM net.snowflake.client.jdbc.RestRequest execute SEVERE: Stop retrying since elapsed time due to network issues has reached timeout. Elapsed: 126,203(ms), timeout: 60,000(ms) Start Equinox Java Authentication and Authorization Service (JAAS) [org.eclipse.equinox.security 1.3.500.v20200114-1637]

CATGF commented 4 years ago

After 2 weeks living with this problem, I can connect normally today even though I have done nothing to correct it.