Results 1 to 10 of 10

Thread: MySQl-Workbench doesn't start

  1. #1

    Default MySQl-Workbench doesn't start

    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.

  2. #2
    Join Date
    Mar 2011
    Location
    Sauerland
    Posts
    4,065

    Default AW: MySQl-Workbench doesn't start

    Post:
    Code:
    zypper lr -d
    Code:
    zypper se -si maria mysql

  3. #3

    Default Re: MySQl-Workbench doesn't start

    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)    
    
    

  4. #4
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,463
    Blog Entries
    2

    Default Re: MySQl-Workbench doesn't start

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  5. #5

    Default Re: MySQl-Workbench doesn't start

    Quote Originally Posted by tsu2 View Post
    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
    
    

  6. #6
    Join Date
    Mar 2011
    Location
    Sauerland
    Posts
    4,065

    Default AW: MySQl-Workbench doesn't start

    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'
    Last edited by Sauerland; 23-Nov-2018 at 11:39.

  7. #7

    Default Re: MySQl-Workbench doesn't start

    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) 
    

  8. #8
    Join Date
    Mar 2011
    Location
    Sauerland
    Posts
    4,065

    Default AW: MySQl-Workbench doesn't start

    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?
    Last edited by Sauerland; 24-Nov-2018 at 13:08.

  9. #9
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,463
    Blog Entries
    2

    Default Re: MySQl-Workbench doesn't start

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  10. #10
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,463
    Blog Entries
    2

    Default Re: MySQl-Workbench doesn't start

    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
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •