Added to precise repository: handbrake, mysql-query-browser

Written by

I’ve just upgraded to Ubuntu 12.04 LTS “Precise Pangolin” on a number of devices. It’s been smooth so far, and I’ll write up the issues I’ve found soon. In the mean time, I’ve added a few packages to the precise repository.

handbrake-gtk and handbrake-cli, taken directly from the official PPA. The oneiric package runs in precise so I haven’t rebuilt it.
mysql-query-browser, mysql-admin, and their dependencies, taken directly from oneiric. These have been replaced by MySQL Workbench and dropped from precise. However, Workbench doesn’t support MySQL 4, so if you are still forced to work with that ancient release, you still need mysql-query-browser.
loco, from the lucid repo. I like to colourise logs whilst debugging.
system-profile, a bash script with cron job that I wrote to take a summary of all installed hardware and running settings which aren’t easily found in the filesystem. Sure, you can run “cat /proc/cpuinfo” while the server is running, but what about when it’s dead? system-profile gives you the same information, provided you made a backup of the filesystem. You do have backups, right?
aircrack-ng, taken directly from oneiric.

Comments

19 responses to “Added to precise repository: handbrake, mysql-query-browser”

2012-05-17

John K

I can’t stand MySQL Workbench, hopefully they’ll keep mysql-query-browser available for a looooong time.

Reply
1. 2012-05-18
  
  Tyler Wagner
  
  http://myjgui.com/screenshots/
  
  Reply
2012-05-22

KaiO

Thank you very much for making MySQL query browser (and Handbrake!) easily available.
I cannot use the MySQL Workbench (database too old…) so this is perfect.
:-)

Reply
2012-07-31

Kevin A

Thank you so much for making mysql-gui-tools easily available in 12.04 – I hate MySQL workbench and was somewhat peeved to find that it had disappeared from the 12.04 repos!

Reply
2012-09-23

evgeniy

plz, can u whrite manual step by step, how to install mysql-query-browser? my email : [redacted]@gmail.com

Reply
1. 2012-09-24
  
  Tyler Wagner
  
  Add my repository, using the instructions on the “APT Repository” page. Then install mysql-query-browser using any package manager (Ubuntu Software Centre, Synaptic, apt-get, aptitude).
  
  Reply
2012-10-18

Andrew Thompson

I have added your repository for Lucid using the auto method (im running Precise) done an “apt-get Update” but still when i do an “apt-get install mysql-admin” it says – Unable to locate package. Any ideas please?

Reply
1. 2012-10-18
  
  Tyler Wagner
  
  Yes. Configure the precise repo. Why did you use the lucid one?
  
  Reply
2012-10-18

Andrew Thompson

Yes apolgoies for the mix up – i have now installed mysql-admin into Precise.

However it erros.

After logging in – when i go to click on the Root user in User Administration it errors with:

Could not retrieve user information for ‘root’
MySQL Error Nr. 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MYISAM COMMENT=’Stores additional user information’ CHARACTER SET UTF8 COLL’ at line 1

Reply
1. 2012-10-18
  
  Tyler Wagner
  
  That problem is likely specific to your server. This package has no trouble connecting to my MySQL 4, 5.1, and 5.5 servers.
  
  Reply
2. 2012-10-18
  
  Tyler Wagner
  
  Sorry, that was incorrect. Testing again, I can see that MySQL Administrator can connect to my MySQL 4.0.16 and 5.1.59 servers. However, when testing against a 5.5.25a server, it gives the same warning you see.
  
  Unfortunately, these tools are deprecated and unmaintained. I doubt they’ll work for 5.5 onward. You’ll have to use MySQL Workbench for them.
  
  Reply
2012-10-18

Andrew Thompson

Can i manually install a MySQL 5.1 server into Precise do you know?

Reply
1. 2012-10-18
  
  Tyler Wagner
  
  Probably, by backporting mysql 5.1. That is a very bad idea. I strongly suggest you use phpmyadmin or MySQL Workbench.
  
  Reply
2012-10-20

Adeel

I hate using workbench. By providing mysql-admin & mysql-query-browser for ubuntu precise, you really made my life a lot easier. Thank you very much.

Reply
2016-12-02

LACS

hi tolaris… can you add mysql-query-browser and mysql administrator to xenial ubuntu 16.04? i really hate mysql workbench…

Reply
1. 2016-12-02
  
  Tyler Wagner
  
  I’ll be happy to add it, which would just be matter of adding the binary packages to the 16.04 repo. But I suspect there’s a big issue of backporting libraries involved, and I don’t care enough to do it.
  
  Please do this:
  1. Add my repo for Ubuntu 14.04 to your 16.04 installation. Instructions here: https://www.tolaris.com/apt-repository/
  2. apt-get update && apt-get install mysql-query-browser
  
  If that works and runs, please report back here and I’ll add it to 16.04.
  
  Reply
  1. 2016-12-05
    
    LACS
    
    hi tyler, glad you still read comments from this page, yeah ive been using 12.04 for the longest time now, but need to upgrade to 16.04 to accomodate sstp vpn, too bad im used to, and i mean “really used to” working with mysql-query-browser and mysql-administrator if you can port it for me and perhaps to other people who loves these two applications it would be for the best… I’ve tried your 14.04 repo as well as 12.04 to no avail below are the error messages i got:
    
    sudo apt-get install mysql-query-browser
    Reading package lists… Done
    Building dependency tree
    Reading state information… Done
    Some packages could not be installed. This may mean that you have
    requested an impossible situation or if you are using the unstable
    distribution that some required packages have not yet been created
    or been moved out of Incoming.
    The following information may help to resolve the situation:
    
    The following packages have unmet dependencies:
    mysql-query-browser : Depends: libatkmm-1.6-1 (>= 2.22.1) but it is not installable
    Depends: libglibmm-2.4-1c2a (>= 2.28.0) but it is not installable
    Depends: libgtkhtml3.14-19 (>= 1:3.30.2) but it is not installable
    Depends: libgtkhtml3.14-19 (= 1:2.24.0) but it is not installable
    Depends: libpangomm-1.4-1 (>= 2.27.1) but it is not installable
    Depends: libsigc++-2.0-0c2a (>= 2.0.2) but it is not installable
    E: Unable to correct problems, you have held broken packages.
    
    sad times…
    
    Reply
    1. 2016-12-05
      
      Tyler Wagner
      
      Sorry, you’ve entered the realm of dependency troubles on a package deprecated 5 years ago. It’s possible you can rebuild these packages to use the modern dependency libraries (see reprepro), or you can force-install those older libraries and deal with all the things that will break in the rest of your system when the modern equivalents are removed due to conflicts in package versions.
      
      I suggest switching to Workbench. I stopped using mysql-query-browser 4 years ago. Good luck!
      
      Reply
      1. 2016-12-06
        
        LACS
        
        indeed.
        
        Reply