[tomp_gl]

Thanks!

[tomp_gl]

To answer your questions:

1) In your present setup did you get the same error for WinSCP and Putty anytime ?

No

2) Does all your SSH connections uses Pageant to authenticate ?

Yes

3) Are you specifying the key that's required for the authentication in the session configuration in WinSCP or Putty for any connection?

Yes

Thanks

[tomp_gl]

Can you look at integrating pageant support into the next SQLyog version? It is quite an essential tool for unix administrators…

[tomp_gl]

What if I have 50 keys in Pageant? I don't want to increase MaxAuthTries to 50…

http://winscp.net/eng/docs/message_too_man…cation_failures

Thanks

[tomp_gl]

Well the problem is occurring again now. I have 6 keys in Pageant, including the key SQLyog uses. MaxAuthTries is set to 3.

Thanks

[tomp_gl]

When the problem occurred, I had 5 keys in Pageant, including the key SQLyog uses. MaxAuthTries is set to 3.

I tried again just now but I could not reproduce the problem.

Thanks

[tomp_gl]

Thanks! That fixed the problem.

[tomp_gl]

[accidently double posted]

[tomp_gl]

SQLyog is on my desktop, and the SSH daemon is on the remote gateway.

MySQL version is 5.0.45-log.

mysql> SHOW VARIABLES LIKE '%timeout%';

connect_timeout 50

delayed_insert_timeout 300

innodb_lock_wait_timeout 50

innodb_rollback_on_timeout OFF

interactive_timeout 50

net_read_timeout 30

net_write_timeout 60

slave_net_timeout 3600

table_lock_wait_timeout 50

wait_timeout 5

Thanks

[Author]

Posts