How to automatically fetch missing dependencies when installing software from .deb?

I'm trying to install MySQL Workbench on my Ubuntu box (11.04). The website has a Ubuntu .deb available for download (for 10.10 and 10.04 so I chose 10.10).


sudo dpkg -i mysql-workbench-gpl-5.2.34-1ubu1010-amd64.deb


(Reading database ... 194069 files and directories currently installed.)
Preparing to replace mysql-workbench-gpl 5.2.34-1ubu1010 (using mysql-workbench-gpl-5.2.34-1ubu1010-amd64.deb) ...
Unpacking replacement mysql-workbench-gpl ...
dpkg: dependency problems prevent configuration of mysql-workbench-gpl:
 mysql-workbench-gpl depends on libctemplate0; however:
  Package libctemplate0 is not installed.
 mysql-workbench-gpl depends on libpython2.6 (>= 2.6); however:
  Package libpython2.6 is not installed.
 mysql-workbench-gpl depends on libzip1 (>= 0.8); however:
  Package libzip1 is not installed.
 mysql-workbench-gpl depends on python-paramiko; however:
  Package python-paramiko is not installed.
 mysql-workbench-gpl depends on python-pysqlite2; however:
  Package python-pysqlite2 is not installed.
dpkg: error processing mysql-workbench-gpl (--install):
 dependency problems - leaving unconfigured
Processing triggers for bamfdaemon ...
Rebuilding /usr/share/applications/bamf.index...
Processing triggers for desktop-file-utils ...
Processing triggers for python-gmenu ...
Rebuilding /usr/share/applications/desktop.en_US.utf8.cache...
Processing triggers for python-support ...
Errors were encountered while processing:

My question is, is there a way to tell dpkg to automatically fetch missing dependencies, or do I need to manually apt-get install missing packages like libctemplate0 and libpython2.6?

(Or alternatively, is there some other way to get MySQL Workbench easily up & running?)

Answers 7

  • You can install a package and get dependencies from repositories with

    sudo gdebi package.deb

    If you already installed the package with missed dependencies, you can dowload and install dependencies automatically with

    sudo apt-get -f install

    Also available is a graphical version gdebi-gtk, linked to .deb nautilus right click action "Open With GDebi Package Installer".

  • From the 1.1 branch onwards, apt-get supports installing local packages along with dependencies in the way of:

    sudo apt-get install ./your-package.deb

    Note the ./ in front of package file name, which is mandatory otherwise the name will be used as package name, not a file name.

  • dpkg itself is not capable of managing repositories. A higher-level tool like apt-get is required to fetch anything from repositories. dkpg is only the core tool that installs/removes/configures packages, taking care of dependencies and other factors. apt-get and aptitude are tools that manage repositories, download data from them, and use dkpg to install/remove packages from them. This means that apt-get and aptitude can resolve dependencies and get required packages from repository, but dpkg cannot, because it knows nothing about repositories.

  • You can use apt-get -f install to install all the packages dpkg -i complains about (but looking at your question you probably knew that ;) ).

    gdebi might be a better alternative.

    Description: Simple tool to install deb files
    gdebi lets you install local deb packages resolving and installing its 
    dependencies. apt does the same, but only for remote (http, ftp) located 

    On a 3rd note... gdebi was replaced by the Ubuntu Software Center. If you install the .deb from within GDM (nautilus) USC will take over and try to install the deb. And that includes the dependencies. That is if you are not bound to command line ;)

  • That particular library(libctemplate0) I downloaded it from

    The direct link

    The mySQL-workbench installation went smoothly after that.

Related Questions