Bug #105347 Couldn't load library libmysqlclient_r.so
Submitted: 27 Oct 2021 19:53 Modified: 28 Oct 2021 12:49
Reporter: André verwijs Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.25 OS:SUSE ( x86_64)
Assigned to: CPU Architecture:Other (x64)
Tags: WBBugReporter

[27 Oct 2021 19:53] André verwijs
Description:
System info:
~~~~~~~~~~~~~~
 
Operating System: openSUSE Tumbleweed 20211025
KDE Plasma Version: 5.23.1
KDE Frameworks Version: 5.87.0
Qt Version: 5.15.2
Kernel Version: 5.14.14-1-default (64-bit)
Graphics Platform: X11
Processors: 2 × Intel® Core™2 CPU 6700 @ 2.66GHz
Memory: 5.7 GiB of RAM
Graphics Processor: GeForce GT 610/PCIe/SSE2

MySQL Workbench Community (GPL) for Linux/Unix version 8.0.25 CE build 788958 (64 bit)
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.16.0
OS:  x86_64
CPU: 2x Intel(R) Core(TM)2 CPU - 6700 @ 2.66GHz (2664.111MHz) - 5,72GiB RAM

this is the exception i got:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

21:44:39 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /usr/share/mysql-workbench
	plugin path: /usr/lib64/mysql-workbench/plugins
	struct path: /usr/share/mysql-workbench/grt
	module path: /usr/lib64/mysql-workbench/modules
	library path: /usr/share/mysql-workbench/libraries
	user data dir: /home/verwijs/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
21:44:39 [INF][      WBContext]: WbContext::init
21:44:40 [INF][            WBA]: Looking for extension modules for WBA...
21:44:40 [INF][            WBA]: 0 extension modules found
21:44:40 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
21:44:40 [WRN][            grt]: /home/verwijs/.mysql/workbench/connections.xml:23: link '0eefec46-375e-11ec-9fc0-0019d1852a92' <object GrtObject> key=owner could not be resolved
21:44:40 [WRN][            grt]: /home/verwijs/.mysql/workbench/server_instances.xml:29: link '0eefec46-375e-11ec-9fc0-0019d1852a92' <object GrtObject> key=owner could not be resolved
21:44:40 [WRN][            grt]: Duplicate plugin name wb.tools.cmdlineClient	There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
21:44:40 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 8.0.25 CE build 788958 (64 bit)
	Configuration Directory: /home/verwijs/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.16.0
	OS:  x86_64
	CPU: 2x Intel(R) Core(TM)2 CPU          6700  @ 2.66GHz (2664.111MHz) - 5,72GiB RAM
No video adapter info available
	Fips mode enabled: no

21:44:41 [WRN][       WBModule]: OS not found on supported OS list. OS string: ' x86_64'
21:44:42 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet
21:44:42 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet
21:44:42 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet
21:44:42 [ERR][    WQE backend]: Got an exception during connection: Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet
21:44:42 [ERR][SQL Editor Form]: SQL editor could not be connected: Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet
21:44:42 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:
  Couldn't load library libmysqlclient_r.so: libmysqlclient_r.so: kan gedeeld objectbestand niet openen: Bestand of map bestaat niet

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

How to repeat:
..

Suggested fix:
..
[27 Oct 2021 19:54] André verwijs
wb.log

Attachment: wb.log.txt (text/plain), 3.59 KiB.

[27 Oct 2021 20:15] MySQL Verification Team
From wb.log:

21:44:41 [WRN][       WBModule]: OS not found on supported OS list. OS string: ' x86_64'
[28 Oct 2021 12:49] MySQL Verification Team
Hello André verwijs,

Thank you for the bug report.
After going through your log file, we found that you are not using supported platform. Please see here 

Operating System: openSUSE Tumbleweed 20211025
21:44:41 [WRN][       WBModule]: OS not found on supported OS list. OS string: ' x86_64'

Regards,
Ashwini Patil