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

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.

  1. handbrake-gtk and handbrake-cli, taken directly from the official PPA. The oneiric package runs in precise so I haven’t rebuilt it.
  2. 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.
  3. loco, from the lucid repo. I like to colourise logs whilst debugging.
  4. 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?
  5. aircrack-ng, taken directly from oneiric.

Tags: , , , ,

  1. John K’s avatar

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

    Reply

    1. KaiO’s avatar

      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

    2. Kevin A’s avatar

      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

    3. evgeniy’s avatar

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

      Reply

      1. Tyler Wagner’s avatar

        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’s avatar

        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’s avatar

          Yes. Configure the precise repo. Why did you use the lucid one?

          Reply

        2. Andrew Thompson’s avatar

          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’s avatar

            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’s avatar

            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’s avatar

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

            Reply

            1. Tyler Wagner’s avatar

              Probably, by backporting mysql 5.1. That is a very bad idea. I strongly suggest you use phpmyadmin or MySQL Workbench.

              Reply

            2. Adeel’s avatar

              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

            3. LACS’s avatar

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

              Reply

              1. Tyler Wagner’s avatar

                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. LACS’s avatar

                  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. Tyler Wagner’s avatar

                    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

Reply to LACS Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.