Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
https://wiki.archlinux.org/title/Bug_reporting_guidelines
Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.
REPEAT: Do NOT report bugs for outdated packages!
FS#44143 - [mysql-workbench] regression when trying to connect using an ssh tunnel
Attached to Project:
Community Packages
Opened by Panos Mavrogiorgos (pmav99) - Wednesday, 11 March 2015, 10:09 GMT
Last edited by Christian Hesse (eworm) - Wednesday, 25 March 2015, 08:33 GMT
Opened by Panos Mavrogiorgos (pmav99) - Wednesday, 11 March 2015, 10:09 GMT
Last edited by Christian Hesse (eworm) - Wednesday, 25 March 2015, 08:33 GMT
|
DetailsDescription:
This is a regression I've noticed when I upgraded from Version 6.2.4-9 to 6.2.5-1 I can't connect to a remote database when I use an ssh tunnel. Additional info: * Version affected 6.2.5-1 * Version 6.2.4-9 works fine Steps to reproduce: I create the tunnel using the following command (I've changed the ip and the port) autossh -M 0 -p 22 -N -o "ServerAliveInterval 60" -o "ServerAliveCountMax 300" panos@8.8.8.8 -L 3307:127.0.0.1:3306 I then try to connect to panos@localhost:3307 but this is the message I get: http://imgur.com/MXWBAde I guess it has something to do with this patch: https://projects.archlinux.org/svntogit/community.git/diff/trunk/0003-mysql-workbench-keyring.patch?h=packages/mysql-workbench&id=3730d8dec432ca99b843dff2df34b1276a158e84 If you need any more info, I will be happy to provide it. |
This task depends upon
Closed by Christian Hesse (eworm)
Wednesday, 25 March 2015, 08:33 GMT
Reason for closing: Fixed
Additional comments about closing: mysql-workbench 6.2.5-3
Wednesday, 25 March 2015, 08:33 GMT
Reason for closing: Fixed
Additional comments about closing: mysql-workbench 6.2.5-3
First of all: gnome-keyring is just an optional dependency. Do you have it installed? Do you expect to not enter a password or do you just want to get rid of the error message?
So some questions arise:
* You wirte about tunnelled connections. (btw, mysql-workbench can connect via ssh on its own) Does this work with local connections?
* Does this work when connecting to default port 3306?
* Any useful information from logfiles in ~/.mysql/workbench/log/?
* Is XDG_RUNTIME_DIR set correctly?
> Do you expect to not enter a password or do you just want to get rid of the error message?
Well, I surely would like to be able to enter a password, but after clicking on "Close" an the given error message it just disappears and nothing happens.
> * You wirte about tunnelled connections. (btw, mysql-workbench can connect via ssh on its own) Does this work with local connections?
I am using a very simple local connection (no custom ports, no encryption, nothing), so I can say: No, it does not work.
> * Does this work when connecting to default port 3306?
Nope, does not work.
* Any useful information from logfiles in ~/.mysql/workbench/log/?
Just the messages from the error-message-pop-up, plus this:
13:42:01 [INF][ base library]: Notification GNFocusChanged is not registered
13:42:01 [INF][ base library]: Notification GNUIFormCreated is not registered
13:42:01 [INF][ base library]: Notification GNUIFormDestroyed is not registered
13:42:01 [ERR][ SqlEditor]: SQL editor could not be connected: Fehler bei der Kommunikation mit dem GNOME-Schlüsselbunddienst
13:42:01 [ERR][ SqlEditor]: Your connection attempt failed for user 'root' from your host to server at localhost:3306:
The german part roughly translates to "Error while communicating with GNOME-keyring-deamon"
> * Is XDG_RUNTIME_DIR set correctly?
Well, that depends. How should it be set?
[hoerbert@Arch ~]$ echo $XDG_RUNTIME_DIR
/run/user/1000
Additional info:
- I'm using Plasma 5
- gnome-keyring is not installed
If I can be of further assistance just let me know.
WB_NO_GNOME_KEYRING=1 mysql-workbench
Does that bring the expected result?
>
> WB_NO_GNOME_KEYRING=1 mysql-workbench
>
> Does that bring the expected result?
Yeah, that works. Now, if I try to connect, I am asked for a password again.
So for me this is a suitable workaround.
That version should work with and without gnome-keyring installed.
If I haven't done something completely wrong (I'm a first-timer in using the testing-repos), then this version does not work for me.
I enabled the testing and community-testing repos in /etc/pacman.conf, did a pacman -Syu, aborted the upgrade, because I did not want to install every new package version from testing, and then did a pacman -S mysql-workbench, which upgraded it to Version 6.2.5-2 (as also stated by pacman -Q mysql-workbench). I know, this is a partial upgrade, but as the workbench seems not to need any other packages from the suggested upgrade, I thought this would be OK this time.
But: The error message posted by OP is still there and I'm not able to login to my mysql-server. Additionally, there is a new message at the command line (if started from there):
/usr/bin/mysql-workbench: Zeile 9: type: gnome-keyring-daemon: Nicht gefunden.
("Nicht gefunden" means "not found" in german, "Zeile" means "line" [as you probably know, but others may not])
"WB_NO_GNOME_KEYRING=1 mysql-workbench" still works, the new message on the command line is also there.
I haven't thoroughly tested all of the other functionality, but the first impression is good ;)