mysql workbench - dependency problem

ITs saying that the application needs a library called 'libgdk-pixbuf2' in order to operate, and yes, it needs to be above that version.

Unfortunately, libgdk-pixbuf2 is very very old, and is part of GTK1, which has been discontinued for quite some time.

What version of mysql workbench did you download? The mysql website has packages for ubuntu 10.04 and 10.10

http://www.mysql.com/downloads/workbench/#downloads

mycae -thanks for looking at this.

It was downloaded yesterday from the site you've mentioned. I downloaded it twice to make sure I had selected the right option. The file name suggests it's correct.

The version downloaded is mysql-workbench-gpl-5.2.30-1ubu1010-i386.deb.

I had a look around before asking for help and noticed that pixbuf seemed to date from around 2002 and seems to have something to do with picture rendering?

Ted

mycae

I found this which suggests that something is currently happening with pixbuf -

https://launchpad.net/ubuntu/+source/gdk-pixbuf/2.22.1-0ubuntu4

It has download files in it but I'm ignorant enough to not know if this is a possible solution for 10.10 or not!

Ted

Good searching!

OK, it looks like they are resurrecting this from the old stable, as of july, there has been an experimental package, and yes, this has been imported into maverick and natty. Guess I was not seeing the whole story before with libgdk-pixbuf -- my bad.

This package (gdk-pixbuf) must be getting some special attention -- the debian import freeze was in July 24, yet the maverick package was updated recently. It is possible that your local package database is out of date.

Can you enter the following commands (enter in a terminal, (from the applications menu, or CTRL+ALT+T)).

sudo aptitude update
sudo aptitude show gdk-pixbuf

then try re-installing the package. If it does not install post the output from those commands back here.

Ack,
commands should be:

sudo aptitude update
sudo aptitude show gdk-pixbuf
sudo aptitude install gdk-pixbuf

mycae - output below. Also see under that what I tried to solve GPG error - not 'effective'!

ted@ted-laptop:~$ sudo aptitude update
Hit http://au.archive.ubuntu.com lucid Release.gpg
Hit http://au.archive.ubuntu.com/ubuntu/ lucid/main Translation-en_AU
Hit http://au.archive.ubuntu.com/ubuntu/ lucid/restricted Translation-en_AU
Ign http://au.archive.ubuntu.com/ubuntu/ lucid/universe Translation-en_AU
Hit http://au.archive.ubuntu.com/ubuntu/ lucid/multiverse Translation-en_AU
Hit http://au.archive.ubuntu.com lucid-updates Release.gpg
Ign http://au.archive.ubuntu.com/ubuntu/ lucid-updates/main Translation-en_AU
Ign http://au.archive.ubuntu.com/ubuntu/ lucid-updates/restricted Translation-en_AU
Ign http://au.archive.ubuntu.com/ubuntu/ lucid-updates/universe Translation-en_AU
Ign http://au.archive.ubuntu.com/ubuntu/ lucid-updates/multiverse Translation-en_AU
Hit http://au.archive.ubuntu.com lucid Release
Hit http://au.archive.ubuntu.com lucid-updates Release
Hit http://au.archive.ubuntu.com lucid/main Packages
Hit http://au.archive.ubuntu.com lucid/restricted Packages
Hit http://au.archive.ubuntu.com lucid/main Sources
Hit http://au.archive.ubuntu.com lucid/restricted Sources
Hit http://au.archive.ubuntu.com lucid/universe Packages
Hit http://au.archive.ubuntu.com lucid/universe Sources
Hit http://au.archive.ubuntu.com lucid/multiverse Packages
Hit http://au.archive.ubuntu.com lucid/multiverse Sources
Hit http://au.archive.ubuntu.com lucid-updates/main Packages
Hit http://au.archive.ubuntu.com lucid-updates/restricted Packages
Hit http://au.archive.ubuntu.com lucid-updates/main Sources
Hit http://au.archive.ubuntu.com lucid-updates/restricted Sources
Hit http://au.archive.ubuntu.com lucid-updates/universe Packages
Hit http://au.archive.ubuntu.com lucid-updates/universe Sources
Hit http://au.archive.ubuntu.com lucid-updates/multiverse Packages
Hit http://au.archive.ubuntu.com lucid-updates/multiverse Sources
Hit http://security.ubuntu.com lucid-security Release.gpg
Ign http://security.ubuntu.com/ubuntu/ lucid-security/main Translation-en_AU
Ign http://security.ubuntu.com/ubuntu/ lucid-security/restricted Translation-en_AU
Get:1 http://ppa.launchpad.net lucid Release.gpg [316B]
Ign http://ppa.launchpad.net/tsbarnes/indicator-keylock/ubuntu/ lucid/main Translation-en_AU
Hit http://archive.canonical.com lucid Release.gpg
Ign http://archive.canonical.com/ubuntu/ lucid/partner Translation-en_AU
Hit http://archive.canonical.com lucid Release
Ign http://security.ubuntu.com/ubuntu/ lucid-security/universe Translation-en_AU
Ign http://security.ubuntu.com/ubuntu/ lucid-security/multiverse Translation-en_AU
Hit http://security.ubuntu.com lucid-security Release
Get:2 http://ppa.launchpad.net lucid Release [57.3kB]
Ign http://ppa.launchpad.net lucid Release
Hit http://archive.canonical.com lucid/partner Packages
Hit http://security.ubuntu.com lucid-security/main Packages
Hit http://ppa.launchpad.net lucid/main Packages
Hit http://security.ubuntu.com lucid-security/restricted Packages
Hit http://security.ubuntu.com lucid-security/main Sources
Hit http://security.ubuntu.com lucid-security/restricted Sources
Hit http://security.ubuntu.com lucid-security/universe Packages
Hit http://security.ubuntu.com lucid-security/universe Sources
Hit http://security.ubuntu.com lucid-security/multiverse Packages
Hit http://security.ubuntu.com lucid-security/multiverse Sources
Fetched 317B in 2s (129B/s)
Reading package lists... Done
W: GPG error: http://ppa.launchpad.net lucid Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 7384429D471E4486

ted@ted-laptop:~$ sudo aptitude show gdk-pixbuf
E: Unable to locate package gdk-pixbuf
ted@ted-laptop:~$ sudo aptitude install gdk-pixbuf
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Couldn't find package "gdk-pixbuf". However, the following
packages contain "gdk-pixbuf" in their name:
  libgdk-pixbuf2-ruby1.8-dbg libgdk-pixbuf2-ruby libgdk-pixbuf2-ruby1.8
Couldn't find package "gdk-pixbuf". However, the following
packages contain "gdk-pixbuf" in their name:
  libgdk-pixbuf2-ruby1.8-dbg libgdk-pixbuf2-ruby libgdk-pixbuf2-ruby1.8
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done

ted@ted-laptop:~$
--------------------------------------------------

Tried this for the GPG Error from ubuntugeek.com

Method 1

Try to run the following comamnds from terminal

    $ sudo -i

    # apt-get clean

    # cd /var/lib/apt

    # mv lists lists.old

    # mkdir -p lists/partial

    # apt-get clean

    # apt-get update

Method 2

Try to run the following comamnds from terminal

    sudo aptitude -o Acquire::http::No-Cache=True -o Acquire::BrokenProxy=true update

    sudo apt-get update

... same sort of response ...

W: GPG error: http://ppa.launchpad.net lucid Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 7384429D471E4486

------------------------------------------------------------------

Is the 'GPG error' the basic problem?

[Info question: would the original workbench install process been able to 'go and get' the needed pixbuf library file without me doing anything if there was no GPG error ?]

Trying to understand what's going on!

Again thanks for your help.

Ted

Ted

ps if I can get SQL Server Express on windows7 to work with all options then with some help this should work as well!!!

mycae

Missed mentioning I tried to get the key as well -

ted@ted-laptop:~$ sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 7384429D471E4486
[sudo] password for ted:
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /etc/apt/secring.gpg --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --recv-keys --keyserver keyserver.ubuntu.com 7384429D471E4486
gpg: requesting key 471E4486 from hkp server keyserver.ubuntu.com
gpgkeys: HTTP fetch error 7: couldn't connect to host
gpg: no valid OpenPGP data found.
gpg: Total number processed: 0

Tried the MIT server as well. There must be a local 'au' one but haven't been able to find the address for it.

Ted

mycae,

Past the GPG problem.

Now have:

ted@ted-laptop:~$ sudo aptitude update
Hit http://archive.ubuntu.com lucid Release.gpg
Hit http://archive.ubuntu.com/ubuntu/ lucid/main Translation-en_AU
Hit http://archive.ubuntu.com/ubuntu/ lucid/restricted Translation-en_AU
Hit http://archive.canonical.com lucid Release.gpg
Ign http://archive.canonical.com/ubuntu/ lucid/partner Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid/universe Translation-en_AU
Hit http://archive.ubuntu.com/ubuntu/ lucid/multiverse Translation-en_AU
Hit http://archive.ubuntu.com lucid-updates Release.gpg
Hit http://ppa.launchpad.net lucid Release.gpg
Ign http://ppa.launchpad.net/tsbarnes/indicator-keylock/ubuntu/ lucid/main Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid-updates/main Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid-updates/restricted Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid-updates/universe Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid-updates/multiverse Translation-en_AU
Hit http://archive.ubuntu.com lucid-security Release.gpg
Ign http://archive.ubuntu.com/ubuntu/ lucid-security/main Translation-en_AU
Ign http://archive.ubuntu.com/ubuntu/ lucid-security/restricted Translation-en_AU
Hit http://archive.canonical.com lucid Release
Ign http://archive.ubuntu.com/ubuntu/ lucid-security/universe Translation-en_AU
Hit http://ppa.launchpad.net lucid Release
Ign http://archive.ubuntu.com/ubuntu/ lucid-security/multiverse Translation-en_AU
Hit http://archive.ubuntu.com lucid Release
Hit http://archive.canonical.com lucid/partner Packages
Hit http://archive.ubuntu.com lucid-updates Release
Hit http://archive.ubuntu.com lucid-security Release
Hit http://ppa.launchpad.net lucid/main Packages
Hit http://archive.ubuntu.com lucid/main Packages
Hit http://archive.ubuntu.com lucid/restricted Packages
Hit http://archive.ubuntu.com lucid/main Sources
Hit http://archive.ubuntu.com lucid/restricted Sources
Hit http://archive.ubuntu.com lucid/universe Packages
Hit http://archive.ubuntu.com lucid/universe Sources
Hit http://archive.ubuntu.com lucid/multiverse Packages
Hit http://archive.ubuntu.com lucid/multiverse Sources
Hit http://archive.ubuntu.com lucid-updates/main Packages
Hit http://archive.ubuntu.com lucid-updates/restricted Packages
Hit http://archive.ubuntu.com lucid-updates/main Sources
Hit http://archive.ubuntu.com lucid-updates/restricted Sources
Hit http://archive.ubuntu.com lucid-updates/universe Packages
Hit http://archive.ubuntu.com lucid-updates/universe Sources
Hit http://archive.ubuntu.com lucid-updates/multiverse Packages
Hit http://archive.ubuntu.com lucid-updates/multiverse Sources
Hit http://archive.ubuntu.com lucid-security/main Packages
Hit http://archive.ubuntu.com lucid-security/restricted Packages
Hit http://archive.ubuntu.com lucid-security/main Sources
Hit http://archive.ubuntu.com lucid-security/restricted Sources
Hit http://archive.ubuntu.com lucid-security/universe Packages
Hit http://archive.ubuntu.com lucid-security/universe Sources
Hit http://archive.ubuntu.com lucid-security/multiverse Packages
Hit http://archive.ubuntu.com lucid-security/multiverse Sources
Reading package lists... Done

ted@ted-laptop:~$ sudo aptitude show gdk-pixbuf
E: Unable to locate package gdk-pixbuf
ted@ted-laptop:~$ sudo aptitude install gdk-pixbuf
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done
Couldn't find package "gdk-pixbuf". However, the following
packages contain "gdk-pixbuf" in their name:
  libgdk-pixbuf2-ruby1.8-dbg libgdk-pixbuf2-ruby libgdk-pixbuf2-ruby1.8
Couldn't find package "gdk-pixbuf". However, the following
packages contain "gdk-pixbuf" in their name:
  libgdk-pixbuf2-ruby1.8-dbg libgdk-pixbuf2-ruby libgdk-pixbuf2-ruby1.8
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reading extended state information
Initializing package states... Done

ted@ted-laptop:~$
----------------------------------------------------

So clean aptitude update but can't then find the new pix-buf file.

Is it only in 11.04 ??

Ted

>Is it only in 11.04 ??
No, it is in 10.10, but according to your output, you are running 10.04, which it is not in.

They have a 10.04 version available -- I downloaded it and looked through the package. It appears that the deps you report are not required.

Depends: libatk1.0-0 (>= 1.29.3), libbonobo2-0 (>= 2.15.0), libc6 (>= 2.4), libcairo2 (>= 1.7.2), libcairomm-1.0-1 (>= 1.6.4), libctemplate0, libfontconfig1 (>= 2.8.0), libfreetype6 (>= 2.2.1), libgcc1 (>= 1:4.1.1), libgl1-mesa-glx | libgl1, libglade2-0 (>= 1:2.6.1), libglib2.0-0 (>= 2.16.0), libglibmm-2.4-1c2a (>= 2.24.0), libgnome-keyring0 (>= 2.22.2), libgnome2-0 (>= 2.17.3), libgtk2.0-0 (>= 2.8.0), libgtkmm-2.4-1c2a (>= 1:2.20.0), liblua5.1-0, libmysqlclient16 (>= 5.1.21-1), liborbit2 (>= 1:2.14.10), libpango1.0-0 (>= 1.18.0), libpangomm-1.4-1 (>= 2.26.0), libpcre3 (>= 7.7), libpopt0 (>= 1.15), libpython2.6 (>= 2.6), libsigc++-2.0-0c2a (>= 2.0.2), libsqlite3-0 (>= 3.6.22), libstdc++6 (>= 4.4.0), libuuid1 (>= 2.16), libx11-6 (>= 0), libxml2 (>= 2.7.4), libzip1 (>= 0.9), zlib1g (>= 1:1.1.4), python-paramiko, python-pexpect, mysql-client, python-pysqlite2

No pixbuf in the direct deps, though I don't have a 10.04 system in front of me at the moment and don't fancy doing manual dep resolution :)

Are you sure you got the 10.04 package, and not the 10.10 package?

mycae

I have a 'sys info' thing I got from the repository - it says 10.04 so I guess that's what's installed ... I was fairly certain 10.10 was what I downloaded!

I've tried the 'update manager' [settings on 'normal']. It seems to find things to do but then says 'your system is up to date.

Also tried [note it didn't ask me for a password] -

ted@ted-laptop:~$ sudo apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
ted@ted-laptop:~$

Any suggestions ??? I thought I downloaded and installed 10.10 ...

Meanwhile floods, wikileaks & economy (good here) providing plenty of entertainment and keeping 24hr news station busy!

regards

somewhat confused Ted

Thanks mycae, that solved my question.

hi all, i get the following dependency error when I try to install on 11.04
 mysql-workbench-gpl depends on libpython2.6 (>= 2.6); however:
Package libpython2.6 is not installed
any suggestion?

Atasa - I got the workbench going on both 10.04 and 10.10. I haven't upgraded to 11.04 yet.

Have you installed Python 2.6 ? It's available to download from the Ubantu Software Centre.

If you have not downloaded that then do it and then try to install Workbench again after that.

The other problem I had with Workbench was that it required a screen height of 768 lines. If you don't have the required screen resolution you cannot access essential 'buttons' at the bottom of the screen. I worked out how to do this.

So try and install Python 2.6 and then the Workbench debs.

On asking questions in here you need to ask a new question to get attention! Adding to an old one won't usually do that - I've seen this one because I did not 'unsubscribe' from it when I marked it as solved.

Thanx Ted,
i was trying to install it on my netbook, so if you say you need 768 height then there is no point doing that in the first place.
But will try it on my desktop...
do you thing python2.6-minimal is enough?

thanx again

Atasa - I just had a look - current version of Python for 10.10 seems to be 2.6.6. On 11.04 it should be the same or better. I didn't have the Python problem at all when I was installing Workbench. So give it a try!

My Netbook will only do 1024x600 as standard screen resolution. I tried many downloads of various recommended stuff to increase this with no satisfactory answer. In the end I have a small 'bash' script saved that can be 'fired' from a icon on the menu bar - clicking on it changes the effective resolution either to the higher resolution or back to the standard. I'm not particularly 'technical' but I got this to work - not hard at all. One text file saved as 'executable' and a 'launcher' icon that points to it.

It is very handy on the netbook when I want to print PDF files as the actual 'print' button was off the bottom of the screen.

Good luck with the Workbench - it should work. If you want the screen resolution increase stuff let me know.

Ted

Dunno if this is the same problem as mine but this is what i did.
I used

$ sudo apt-get install mysql-workbench-gpl

This threw and error since it had some dependencies issuses. So the terminal prompted me with fixin' it by using

$ sudo apt-get -f install

And, even though it took lots of time, it just finished fine and nobody got hurt.

Hope this helps someone.