MySQl-Workbench doesn't start

**riabovvv** · 22-Nov-2018, 13:25

I've installed MySQl-Workbench from official OpenSUSE repo and it fails to start wit the same error both on my desktop and laptop.

Code:

:~> mysql-workbench  
/usr/bin/mysql-workbench: line 25: ldconfig: command not found
Workbench can't find libproj.so, some options may be unavailable.
/usr/lib64/mysql-workbench/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/libwbpublic.so.6.3.10: undefined symbol: _ZN18OGRGeometryFactory13createFrom
WkbEPhP19OGRSpatialReferencePP11OGRGeometryi13OGRwkbVariant

ldconfig is installed

Code:

:~> cnf ldconfig
                         
Program 'ldconfig' is present in package 'glibc', which is installed on your system.

Absolute path to 'ldconfig' is '/sbin/ldconfig', so running it may require superuser privileges (eg. root).

As for libproj, I have both libproj12 and libproj13 (from ApplicationGeo repo) installed.

**Sauerland** · 22-Nov-2018, 22:56

Post:

Code:

zypper lr -d

Code:

zypper se -si maria mysql

**riabovvv** · 23-Nov-2018, 00:55

Code:

:~> zypper lr -d
Repository priorities are without effect. All enabled repositories share the same priority.

#  | Alias                               | Name                                    | Enabled | GPG Check | Refresh | Priority | Type     | URI                              
                                                     | Service
---+-------------------------------------+-----------------------------------------+---------+-----------+---------+----------+----------+----------------------------------
-----------------------------------------------------+--------
 1 | LOCAL_REPO                          | LOCAL REPO                              | Yes     | ( p) Yes  | Yes     |   99     | plaindir | dir:///windows/Trash_Storage/soft
/LOCAL_REPO                                          |         
 2 | Multimedia                          | packman                                 | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://ftp.gwdg.de/pub/linux/misc
/packman/suse/openSUSE_Leap_15.0/                    |         
 3 | download.opensuse.org-non-oss       | Main Repository (NON-OSS)               | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/dist
ribution/leap/15.0/repo/non-oss/                     |         
 4 | download.opensuse.org-non-oss_1     | Update Repository (Non-Oss)             | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/upda
te/leap/15.0/non-oss/                                |         
 5 | download.opensuse.org-oss           | Main Repository (OSS)                   | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/dist
ribution/leap/15.0/repo/oss/                         |         
 6 | download.opensuse.org-oss_1         | Main Update Repository                  | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/upda
te/leap/15.0/oss                                     |         
 7 | http-download.opensuse.org-05b9eea3 | Publishing                              | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repo
sitories/Publishing/openSUSE_Leap_15.0/              |         
 8 | http-download.opensuse.org-289a33ca | devel:languages:scala                   | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repo
sitories/devel:/languages:/scala/openSUSE_Leap_15.0/ |         
 9 | http-download.opensuse.org-9f90ac6a | Application:Geo                         | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/repo
sitories/Application:/Geo/openSUSE_Leap_15.0/        |         
10 | http-download.opensuse.org-ffd428ab | openSUSE:Leap:15.0:Update               | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | http://download.opensuse.org/upda
te/leap/15.0/oss/                                    |         
11 | repo-debug                          | openSUSE-Leap-15.0-Debug                | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debu
g/distribution/leap/15.0/repo/oss/                   |         
12 | repo-debug-non-oss                  | openSUSE-Leap-15.0-Debug-Non-Oss        | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debu
g/distribution/leap/15.0/repo/non-oss/               |         
13 | repo-debug-update                   | openSUSE-Leap-15.0-Update-Debug         | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debu
g/update/leap/15.0/oss/                              |         
14 | repo-debug-update-non-oss           | openSUSE-Leap-15.0-Update-Debug-Non-Oss | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/debu
g/update/leap/15.0/non-oss/                          |         
15 | repo-source                         | openSUSE-Leap-15.0-Source               | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/sour
ce/distribution/leap/15.0/repo/oss/                  |         
16 | repo-source-non-oss                 | openSUSE-Leap-15.0-Source-Non-Oss       | No      | ----      | ----    |   99     | rpm-md   | http://download.opensuse.org/sour
ce/distribution/leap/15.0/repo/non-oss/              |         
17 | rpm                                 | Opera                                   | Yes     | (r ) Yes  | Yes     |   99     | rpm-md   | https://rpm.opera.com/rpm

Code:

:~> zypper se -si maria mysql
Loading repository data...
Reading installed packages...

S  | Name                  | Type    | Version             | Arch   | Repository                
---+-----------------------+---------+---------------------+--------+--------------------------
i+ | libQt5Sql5-mysql      | package | 5.9.4-lp150.4.8     | x86_64 | Main Repository (OSS)     
i+ | libmariadb-devel      | package | 3.0.3-lp150.1.2     | x86_64 | Main Repository (OSS)     
i+ | libmariadb3           | package | 3.0.3-lp150.1.2     | x86_64 | Main Repository (OSS)     
i+ | libmysqlclient18      | package | 10.0.34-32.2        | x86_64 | (System Packages)         
i+ | libmysqlcppconn7      | package | 1.1.9-lp150.2.5     | x86_64 | Main Repository (OSS)     
i+ | libmysqld19           | package | 10.2.15-lp150.2.6.1 | x86_64 | Main Update Repository    
i+ | libmysqld19           | package | 10.2.15-lp150.2.6.1 | x86_64 | openSUSE:Leap:15.0:Update
i+ | mariadb               | package | 10.2.15-lp150.2.6.1 | x86_64 | Main Update Repository    
i+ | mariadb               | package | 10.2.15-lp150.2.6.1 | x86_64 | openSUSE:Leap:15.0:Update
i+ | mariadb-client        | package | 10.2.15-lp150.2.6.1 | x86_64 | Main Update Repository    
i+ | mariadb-client        | package | 10.2.15-lp150.2.6.1 | x86_64 | openSUSE:Leap:15.0:Update
i+ | mariadb-errormessages | package | 10.2.15-lp150.2.6.1 | noarch | Main Update Repository    
i+ | mariadb-errormessages | package | 10.2.15-lp150.2.6.1 | noarch | openSUSE:Leap:15.0:Update
i+ | mysql-workbench       | package | 6.3.10-lp150.3.1    | x86_64 | Main Repository (OSS)

**tsu2** · 23-Nov-2018, 09:01

Per your error,
Are you running your MySQL Workbench in an elevated console, and not as an ordinary User?
Your posts suggest you're not...

TSU

**riabovvv** · 23-Nov-2018, 10:06

Originally Posted by tsu2

Are you running your MySQL Workbench in an elevated console, and not as an ordinary

I try to start it as a normal user. Here is with `sudo`:

Code:

:~> sudo mysql-workbench  
[sudo] password for root:  
Found /usr/lib64/libprojectM-qt5.so.2
/usr/lib64/mysql-workbench/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/libwbpublic.so.6.3.10: undefined symbol: _ZN18OGRGeometryFactory13createFrom
WkbEPhP19OGRSpatialReferencePP11OGRGeometryi13OGRwkbVariant

**Sauerland** · 23-Nov-2018, 11:33

i+ | libmysqlclient18 | package | 10.0.34-32.2 | x86_64 | (System Package

This is not a native Leap 15.0 package.

So please post as root with su:

Code:

zypper se -si | grep -i 'system packages'

**riabovvv** · 24-Nov-2018, 09:38

Code:

:~> zypper se -si | grep -i 'system packages'
i+ | boost-license1_54_0                      | package | 1.54.0-15.15                              | noarch | (System Packages)         
i+ | grass                                    | package | 7.4.1-lp150.9.9                           | x86_64 | (System Packages)         
i+ | grass-docs                               | package | 7.4.1-lp150.9.9                           | x86_64 | (System Packages)         
i+ | libCGAL11                                | package | 4.7-45.40                                 | x86_64 | (System Packages)         
i+ | libCGAL13                                | package | 4.12-lp150.55.1                           | x86_64 | (System Packages)         
i+ | libHalf11                                | package | 2.1.0-7.3                                 | x86_64 | (System Packages)         
i+ | libIex-2_1-11                            | package | 2.1.0-7.3                                 | x86_64 | (System Packages)         
i+ | libIlmImf-Imf_2_1-21                     | package | 2.1.0-10.3.1                              | x86_64 | (System Packages)         
i+ | libIlmThread-2_1-11                      | package | 2.1.0-7.3                                 | x86_64 | (System Packages)         
i+ | libMagickCore-6_Q16-1                    | package | 6.8.8.1-58.1                              | x86_64 | (System Packages)         
i+ | libMagickCore-7_Q16HDRI5                 | package | 7.0.7.28-lp150.1.1                        | x86_64 | (System Packages)         
i+ | libMagickWand-6_Q16-1                    | package | 6.8.8.1-58.1                              | x86_64 | (System Packages)         
i+ | libMagickWand-7_Q16HDRI5                 | package | 7.0.7.28-lp150.1.1                        | x86_64 | (System Packages)         
i+ | libOpenSceneGraph130                     | package | 3.4.0-24.32                               | x86_64 | (System Packages)         
i+ | libOpenSceneGraph156                     | package | 3.6.0-lp150.32.2                          | x86_64 | (System Packages)         
i+ | libboost_serialization1_54_0             | package | 1.54.0-15.15                              | x86_64 | (System Packages)         
i+ | libboost_system1_54_0                    | package | 1.54.0-15.15                              | x86_64 | (System Packages)         
i+ | libboost_thread1_54_0                    | package | 1.54.0-15.15                              | x86_64 | (System Packages)         
i+ | libfaac0                                 | package | 1.29.9.2-2.2                              | x86_64 | (System Packages)         
i+ | libgnutls28                              | package | 3.3.27-1.5                                | x86_64 | (System Packages)         
i+ | libhdf5-10                               | package | 1.8.20-lp150.1.4                          | x86_64 | (System Packages)         
i+ | libhdf5_hl10                             | package | 1.8.20-lp150.1.4                          | x86_64 | (System Packages)         
i+ | libhogweed2                              | package | 2.7.1-12.1                                | x86_64 | (System Packages)         
i+ | libieee1284                              | package | 0.2.11-lp150.1.7                          | x86_64 | (System Packages)         
i+ | libjson-c2                               | package | 0.12-7.3                                  | x86_64 | (System Packages)         
i+ | libkea1_4_7                              | package | 1.4.7-lp150.7.1                           | x86_64 | (System Packages)         
i+ | liblwgeom-2_3-0                          | package | 2.3.3-12.53                               | x86_64 | (System Packages)         
i+ | liblwgeom-2_4-0                          | package | 2.4.5-lp150.1.2                           | x86_64 | (System Packages)         
i+ | liblwgeom-2_5-0                          | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | libmpfr4                                 | package | 3.1.2-13.15                               | x86_64 | (System Packages)         
i+ | libmysqlclient18                         | package | 10.0.34-32.2                              | x86_64 | (System Packages)         
i+ | libnetcdf11                              | package | 4.4.1.1-lp150.7.1                         | x86_64 | (System Packages)         
i+ | libnetcdf7                               | package | 4.3.3.1-9.21                              | x86_64 | (System Packages)         
i+ | libnettle4                               | package | 2.7.1-12.1                                | x86_64 | (System Packages)         
i+ | libqwt5                                  | package | 5.2.3-lp150.26.85                         | x86_64 | (System Packages)         
i+ | libshp1                                  | package | 1.3.0-lp150.6.3                           | x86_64 | (System Packages)         
i+ | libva1                                   | package | 1.7.3-1.3                                 | x86_64 | (System Packages)         
i+ | libvpx1                                  | package | 1.3.0-8.1                                 | x86_64 | (System Packages)         
i+ | libwebp5                                 | package | 0.4.3-9.3                                 | x86_64 | (System Packages)         
i+ | libx264-148                              | package | 0.148svn20170816-1.3                      | x86_64 | (System Packages)         
i+ | libx264-152                              | package | 0.152svn20180305-3.1                      | x86_64 | (System Packages)         
i+ | libx265-146                              | package | 2.6-1.2                                   | x86_64 | (System Packages)         
i+ | libx265-151                              | package | 2.7-2.2                                   | x86_64 | (System Packages)         
i+ | libxvidcore4                             | package | 1.3.5-1.2                                 | x86_64 | (System Packages)         
i+ | mapnik                                   | package | 3.0.20-lp150.2.26                         | x86_64 | (System Packages)         
i+ | mapnik-devel                             | package | 3.0.20-lp150.2.26                         | x86_64 | (System Packages)         
i+ | normalize                                | package | 0.7.7-4.2                                 | x86_64 | (System Packages)         
i+ | openSUSE-release-dvd                     | package | 15.0-lp150.111.1                          | x86_64 | (System Packages)         
i+ | postgresql10-postgis                     | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | postgresql10-postgis-utils               | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | postgresql96-postgis                     | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | postgresql96-postgis-devel               | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | postgresql96-postgis-utils               | package | 2.5.1-lp150.1.1                           | x86_64 | (System Packages)         
i+ | python2-Shapely                          | package | 1.5.17-lp150.24.5                         | x86_64 | (System Packages)         
i+ | python2-mapnik                           | package | 3.0.16-lp150.3.1                          | x86_64 | (System Packages)         
i+ | python3-Shapely                          | package | 1.5.17-lp150.24.5                         | x86_64 | (System Packages)         
i+ | python3-mapnik                           | package | 3.0.16-lp150.3.1                          | x86_64 | (System Packages)         
i+ | python3-pyproj                           | package | 1.9.5.1-lp150.8.13                        | x86_64 | (System Packages)         
i+ | qgis                                     | package | 3.4.1-lp150.1.4                           | x86_64 | (System Packages)         
i+ | qgis-sample-data                         | package | 3.4.1-lp150.1.4                           | x86_64 | (System Packages)         
i+ | transcode                                | package | 1.1.7-4.8                                 | x86_64 | (System Packages)         
i+ | yarn                                     | package | 1.6.0-1                                   | noarch | (System Packages)

**Sauerland** · 24-Nov-2018, 13:06

Many packages are not "native" Leap 15.0 packages.
Leap 15.0 packages are marked with lp150 in the Version string.

So where are the other packages from?
Was this an Upgrade to Leap from an older openSUSE?

**tsu2** · 24-Nov-2018, 14:19

I just did an install on a fully updated LEAP 15 and mysql-workbench launched without a problem as a regular user.
When I launch from a console, a minor error displays that the ldconfig command is not found so some options may not be available, but that does not prevent the app from launching. When launched from a root console, the ldconfig command is found but causes other errors.

So, some questions...
- Did you run "zypper up" before installing mysql-workbench?
- The following is from my system. Verify when you run the same command you see the same result

Code:

zypper info mysql-workbench Loading repository data...
Reading installed packages...


Information for package mysql-workbench:
----------------------------------------
Repository     : Main Repository (OSS)                                             
Name           : mysql-workbench                                                   
Version        : 6.3.10-lp150.3.1                                                  
Arch           : x86_64                                                            
Vendor         : openSUSE                                                          
Installed Size : 84.5 MiB                                                          
Installed      : Yes                                                               
Status         : up-to-date                                                        
Source package : mysql-workbench-6.3.10-lp150.3.1.src                              
Summary        : A MySQL visual database modeling, administration and querying tool

I don't know if Sauerland's observation about System Packages would affect mysql-workbench...
I'm more inclined to suspect that the system might just not be updated.
Perhaps simply running "zypper up" should be tried and if that doesn't work to list and post your repositories with the command

Code:

zypper lr -d

TSU

**tsu2** · 24-Nov-2018, 14:30

Also,
Comparing your original error to my machine,
mysql-workbench found the following which your installation doesn't

Code:

/usr/lib64/libproj.so.12

I installed mysql-workbench from the OSS whereas I suspect you installed using the web search.
There shouldn't be a difference, but maybe there is in this case (again, compare the app version in my previous post to yours).

Maybe the proper solution is to uninstall mysql-workbench, and then do a force install with the following command

Code:

zypper in -f mysql-workbench

TSU

Participation Requested

Thread: MySQl-Workbench doesn't start

Thread Tools

Display