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

2012-05-16 20:26 +00:00 | 19 comments

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.

Tags: dev, mysql, precise, repo, ubuntu

19 comments

Comments feed for this article

Trackback link: https://www.tolaris.com/2012/05/16/added-to-precise-repository-handbrake-mysql-query-browser/trackback/

John K on 2012-05-17 at 19:08 +00:00

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

Reply
1. Tyler Wagner on 2012-05-18 at 20:48 +00:00
  
  http://myjgui.com/screenshots/
  
  Reply
2. KaiO on 2012-05-22 at 14:20 +00:00
  
  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
3. Kevin A on 2012-07-31 at 13:32 +00:00
  
  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
4. evgeniy on 2012-09-23 at 22:40 +00:00
  
  plz, can u whrite manual step by step, how to install mysql-query-browser? my email : [redacted]@gmail.com
  
  Reply
  1. Tyler Wagner on 2012-09-24 at 06:59 +00:00
    
    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
  2. Andrew Thompson on 2012-10-18 at 09:55 +00:00
    
    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. Tyler Wagner on 2012-10-18 at 12:31 +00:00
      
      Yes. Configure the precise repo. Why did you use the lucid one?
      
      Reply
    2. Andrew Thompson on 2012-10-18 at 13:34 +00:00
      
      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. Tyler Wagner on 2012-10-18 at 14:49 +00:00
        
        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. Tyler Wagner on 2012-10-18 at 14:56 +00:00
        
        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
      3. Andrew Thompson on 2012-10-18 at 14:58 +00:00
        
        Can i manually install a MySQL 5.1 server into Precise do you know?
        
        Reply
        
        Tyler Wagner on 2012-10-18 at 15:02 +00:00
        
        Probably, by backporting mysql 5.1. That is a very bad idea. I strongly suggest you use phpmyadmin or MySQL Workbench.
        
        Reply
        
        Adeel on 2012-10-20 at 13:55 +00:00
        
        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
        
        LACS on 2016-12-02 at 13:53 +00:00
        
        hi tolaris… can you add mysql-query-browser and mysql administrator to xenial ubuntu 16.04? i really hate mysql workbench…
        
        Reply
        
        Tyler Wagner on 2016-12-02 at 16:01 +00:00
        
        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
        
        LACS on 2016-12-05 at 09:28 +00:00
        
        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
        
        Tyler Wagner on 2016-12-05 at 13:41 +00:00
        
        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
        
        LACS on 2016-12-06 at 08:23 +00:00
        
        indeed.
        
        Reply