Bug #100555 Cannot connect to database server
Submitted: 18 Aug 2020 6:27 Modified: 15 Sep 2020 20:31
Reporter: Palanikumar P Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S7 (Test Cases)
Version:8.0.21 OS:Linux (Ubuntu 20.04 x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[18 Aug 2020 6:27] Palanikumar P
Description:
11:47:52 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /snap/mysql-workbench-community/6/usr/share/mysql-workbench
	plugin path: /snap/mysql-workbench-community/6/usr/lib/mysql-workbench/plugins
	struct path: /snap/mysql-workbench-community/6/usr/share/mysql-workbench/grt
	module path: /snap/mysql-workbench-community/6/usr/lib/mysql-workbench/modules
	library path: /snap/mysql-workbench-community/6/usr/share/mysql-workbench/libraries
	user data dir: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
11:47:52 [INF][      WBContext]: WbContext::init
11:47:53 [INF][            WBA]: Looking for extension modules for WBA...
11:47:53 [INF][            WBA]: 0 extension modules found
11:47:53 [WRN][            grt]: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench/connections.xml:23: link '1cdf0e00-e119-11ea-9646-f371bdb654f2' <object GrtObject> key=owner could not be resolved
11:47:54 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 8.0.21 CE build 16448441 (64 bit)
	Configuration Directory: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench
	Data Directory: /snap/mysql-workbench-community/6/usr/share/mysql-workbench
	Cairo Version: 1.15.10
	OS: Ubuntu 20.04 x86_64
	CPU: 8x Intel(R) Core(TM) i7-2760QM CPU @ 2.40GHz (2594.042MHz) - 7.66GiB RAM
No video adapter info available
	Distribution: Ubuntu 20.04.1 LTS

	Fips mode enabled: no

11:47:56 [INF][               ]: Remote error from secret service: org.freedesktop.DBus.Error.AccessDenied: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:47:56 [ERR][SQL Editor Form]: SQL editor could not be connected: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:47:56 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
  An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")

Please:
1 Check that MySQL is running on address localhost
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
11:48:02 [INF][  column_widths]: Initializing column width cache for unconnected
11:48:17 [ERR][wb_admin_grt.py:openAdminSection:854]: No context found for editor in call to openAdminSection
11:48:24 [INF][               ]: Remote error from secret service: org.freedesktop.DBus.Error.AccessDenied: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:48:24 [ERR][      WBContext]: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")

How to repeat:
11:47:52 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /snap/mysql-workbench-community/6/usr/share/mysql-workbench
	plugin path: /snap/mysql-workbench-community/6/usr/lib/mysql-workbench/plugins
	struct path: /snap/mysql-workbench-community/6/usr/share/mysql-workbench/grt
	module path: /snap/mysql-workbench-community/6/usr/lib/mysql-workbench/modules
	library path: /snap/mysql-workbench-community/6/usr/share/mysql-workbench/libraries
	user data dir: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
11:47:52 [INF][      WBContext]: WbContext::init
11:47:53 [INF][            WBA]: Looking for extension modules for WBA...
11:47:53 [INF][            WBA]: 0 extension modules found
11:47:53 [WRN][            grt]: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench/connections.xml:23: link '1cdf0e00-e119-11ea-9646-f371bdb654f2' <object GrtObject> key=owner could not be resolved
11:47:54 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 8.0.21 CE build 16448441 (64 bit)
	Configuration Directory: /home/palanikumar/snap/mysql-workbench-community/6/.mysql/workbench
	Data Directory: /snap/mysql-workbench-community/6/usr/share/mysql-workbench
	Cairo Version: 1.15.10
	OS: Ubuntu 20.04 x86_64
	CPU: 8x Intel(R) Core(TM) i7-2760QM CPU @ 2.40GHz (2594.042MHz) - 7.66GiB RAM
No video adapter info available
	Distribution: Ubuntu 20.04.1 LTS

	Fips mode enabled: no

11:47:56 [INF][               ]: Remote error from secret service: org.freedesktop.DBus.Error.AccessDenied: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:47:56 [ERR][SQL Editor Form]: SQL editor could not be connected: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:47:56 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
  An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")

Please:
1 Check that MySQL is running on address localhost
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines) 
4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from
11:48:02 [INF][  column_widths]: Initializing column width cache for unconnected
11:48:17 [ERR][wb_admin_grt.py:openAdminSection:854]: No context found for editor in call to openAdminSection
11:48:24 [INF][               ]: Remote error from secret service: org.freedesktop.DBus.Error.AccessDenied: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")
11:48:24 [ERR][      WBContext]: An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.194" (uid=1000 pid=9532 comm="/snap/mysql-workbench-community/6/usr/bin/mysql-wo" label="snap.mysql-workbench-community.mysql-workbench-community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession" error name="(unset)" requested_reply="0" destination=":1.45" (uid=1000 pid=1683 comm="/usr/bin/gnome-keyring-daemon --daemonize --login " label="unconfined")

Suggested fix:
Cannot connect to database server.please help!!
[15 Sep 2020 20:30] MySQL Verification Team
WorkBench connected to server on Ubuntu

Attachment: 100555.png (image/png, text), 964.94 KiB.

[15 Sep 2020 20:31] MySQL Verification Team
Thank you for the bug report. I couldn't repeat see prior attached picture.