MySQL Administrator

k-dub · 2004-12-03 03:55:45

... please?

cactus · 2004-12-03 04:18:45

?
phpmyadmin ?

k-dub · 2004-12-03 06:47:17

http://dev.mysql.com/downloads/administrator/1.0.html

... and ...

http://dev.mysql.com/downloads/query-browser/1.1.html

... while I'm at it.

Bzillins8906 · 2004-12-03 23:44:05

Is the Mysql admin X or Text in linux? I really like the GUI utility in doze... However i am porting all my desktops over to arch... Currently i am stuck using phpmyadmin and was wondering if this was a more viable solution..

cactus · 2004-12-04 00:05:29

http://www.mysql.com/products/administr … _users.png

http://www.mysql.com/products/administrator/index.html

k-dub · 2004-12-11 02:38:31

I've been trying to build these today, but I'm not having much luck.

Here's the Administrator pkg:

pkgname=mysql-administrator
pkgver=1.0.16
pkgrel=1
pkgdesc="Qt-based administration GUI for MySQL server"
url="http://www.mysql.com/"
license="GPL2"
depends=('mysql' 'gtkmm' 'libxml2' 'libglade' 'qt')
source=(http://mysql.orst.edu/Downloads/MySQLAdministrationSuite/$pkgname-$pkgver.tar.gz)
md5sums=('719ba87b0a7bf912808c15ec42a00bb7')

build() {
  cd $startdir/src/$pkgname-$pkgver/$pkgname
  ./configure --prefix=/usr
  make || return 1
  make DESTDIR=$startdir/pkg install
}

... and here's the query browser:

pkgname=mysql-query-browser
pkgver=1.1.2
pkgrel=1
pkgdesc="Qt-based query GUI for MySQL server"
url="http://www.mysql.com/"
license="GPL2"
depends=('mysql' 'gtkmm' 'libxml2' 'libglade' 'glibc' 'libgtkhtml' 'qt')
source=(http://mysql.orst.edu/Downloads/MySQLAdministrationSuite/$pkgname-$pkgver.tar.gz)
md5sums=('5cc86410146dd1fd0170fe71bf19f9eb')

build() {
  cd $startdir/src/$pkgname-$pkgver/$pkgname
  ./configure --prefix=/usr
  make || return 1
  make DESTDIR=$startdir/pkg install
}

I installed gtkmm, but the pkgconfig file is version 2.4, not 2.0. My machine has libgtkhtml, but it's version 2.6.2, not 3.0.

I'll probably make a pre-compiled package for my own use, but I don't know if it will work. Hopefully someone who knows what's going on can fix the dependency issues.

siimo · 2004-12-17 11:15:21

any progress on this? im interested in it too.

k-dub · 2004-12-17 16:11:39

Nope. I'm hoping someone within Arch can fix it.

cactus · 2004-12-17 23:30:32

the build/install instructions for mysql-administrator recommend you use the binaries that they have pre-compiled.
http://dev.mysql.com/doc/administrator/ … ction.html

I looked at the configure.in for the gui-common portion, and it appears that they have hard-coded a requirement for gtkmm-2.0 and are checking it with pkg-conf macros. I would just save yourself the trouble, and try to package up the binaries.

Should you wish to persevere, you should read this:
http://dev.mysql.com/doc/administrator/ … sites.html
and this
http://dev.mysql.com/doc/administrator/ … iling.html

lanrat · 2004-12-18 00:55:10

It looks like this is still about gtkmm version. Current is 2.4.7. Mysql administrator needs 2.0 or 2.2. There are too many differences between these versions.
http://bugs.mysql.com/bug.php?id=4622
http://bugs.mysql.com/bug.php?id=3936
http://dev.mysql.com/doc/administrator/ … sites.html
http://gentoo-portage.com/ebuild?e=dev- … 17a.ebuild

Patience...

Meanwhile you can try gmysqlcc:
http://bbs.archlinux.org/viewtopic.php?t=7053

siimo · 2004-12-18 02:23:41

It would be good if someone knowledgable were to make pkgbuilds of the binary packages for mysql-administrator and mysql-query-browser they run fine on my system but its always better to have a arch package instead of extracting these somewhere manually.

k-dub · 2004-12-18 05:05:14

I tried builds of both package styles. I could not even get the binaries to *run* on my system, so I assumed that compiling from source would solve the dependencies problems.

I guess Gentoo was more addictive than I thought. :?

cactus · 2004-12-18 06:47:01

addictive?
Likely there just aren't many included packages that REQUIRE an older library (gtkmm-2.0 or 2.2, not 2.4). As arch grows, things like this will become less common.
I really never used mysql-administrator, so I have very little impetus to persue getting it running. The fact that the authors don't even have a compile how to README distributed with the source, that included configure args, tells me that they would rather have people using the binaries. The fact that the binaries don't run could be attributed to many things...
But again, I have never used it, so I don't know. For my needs, phpmyadmin is good enough.

lanrat · 2004-12-18 11:58:20

Ok. I made a pkgbuild for the binary version of mysql-administrator. It starts fine but I can't test it more right now so please post any suggestions and opinions. Looks like all problematic libs are compiled in it statically. I think there is no automatic mirror selection on mysql webpages so I chose one of the .ca. It works well for me but you can change it to some closer to you:
http://dev.mysql.com/get/Downloads/MySQ … /from/pick
mysql-administrator PKGBUILD

pkgname=mysql-administrator
pkgver=1.0.17a
pkgrel=1
pkgdesc="A GUI tool for MySql server management, configuration and monitoring"
url="http://www.mysql.com/products/administrator/"
depends=('bash' 'gtk2')
source=(http://mysql.mirrored.ca/Downloads/MySQLAdministrationSuite/$pkgname-$pkgver-linux.tar.gz)
md5sums=('0c21cfbb3467cca1a785510e3af903fa')

build() {

    install -d -m755 $startdir/pkg/opt/$pkgname/bin
    install -d -m755 $startdir/pkg/opt/$pkgname/doc/images
    install -d -m755 $startdir/pkg/opt/$pkgname/share/applications
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/administrator
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/common
    install -d -m755 $startdir/pkg/usr/bin

    cd $startdir/src/$pkgname/bin
    install -m755 * $startdir/pkg/opt/$pkgname/bin

    cd $startdir/src/$pkgname/doc
    install -m664 *.html $startdir/pkg/opt/$pkgname/doc

    cd $startdir/src/$pkgname/doc/images
    install -m664 * $startdir/pkg/opt/$pkgname/doc/images

    cd $startdir/src/$pkgname/share/applications
    install -m644 * $startdir/pkg/opt/$pkgname/share/applications

    cd $startdir/src/$pkgname/share/mysql-gui/administrator
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/administrator

    cd $startdir/src/$pkgname/share/mysql-gui/common
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/common

    cd $startdir/src/$pkgname/share/mysql-gui
    install -m644 *.png $startdir/pkg/opt/$pkgname/share/mysql-gui

    cd $startdir/src/$pkgname
    install -m444 COPYING FAQ $startdir/pkg/opt/$pkgname

    cd $startdir/pkg/usr/bin
    ln -s ../../opt/$pkgname/bin/$pkgname $pkgname

    sed -i "s/^MYPATH=.*$/MYPATH=/opt/$pkgname/bin/" $startdir/pkg/opt/$pkgname/bin/$pkgname

}

I'm working on mysql-querybrowser now. I will post it here soon.

lanrat · 2004-12-18 12:47:29

Done.
mysql-query-browser PKGBUILD

pkgname=mysql-query-browser
pkgver=1.1.3a
pkgrel=1
pkgdesc="A GUI tool for creating, executing and optimizing SQL queries for MySql server"
url="http://www.mysql.com/products/query-browser/"
depends=('bash' 'gtk2' 'gconf')
source=(http://mysql.mirrored.ca/Downloads/MySQLAdministrationSuite/$pkgname-$pkgver-linux.tar.gz)
md5sums=('e99f88a92e87156841cb8c796f7a46b9')

build() {

    install -d -m755 $startdir/pkg/opt/$pkgname/bin
    install -d -m755 $startdir/pkg/opt/$pkgname/doc/images
    install -d -m755 $startdir/pkg/opt/$pkgname/share/applications
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/query-browser
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/common
    install -d -m755 $startdir/pkg/usr/bin

    cd $startdir/src/$pkgname/bin
    install -m755 * $startdir/pkg/opt/$pkgname/bin

    cd $startdir/src/$pkgname/doc
    install -m664 *.html $startdir/pkg/opt/$pkgname/doc

    cd $startdir/src/$pkgname/doc/images
    install -m664 * $startdir/pkg/opt/$pkgname/doc/images

    cd $startdir/src/$pkgname/share/applications
    install -m644 * $startdir/pkg/opt/$pkgname/share/applications

    cd $startdir/src/$pkgname/share/mysql-gui/query-browser
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/query-browser

    cd $startdir/src/$pkgname/share/mysql-gui/common
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/common

    cd $startdir/src/$pkgname/share/mysql-gui
    install -m644 *.png $startdir/pkg/opt/$pkgname/share/mysql-gui

    cd $startdir/src/$pkgname
    install -m444 COPYING $startdir/pkg/opt/$pkgname

    cd $startdir/pkg/usr/bin
    ln -s ../../opt/$pkgname/bin/$pkgname $pkgname

    sed -i "s/^MYPATH=.*$/MYPATH=/opt/$pkgname/bin/" $startdir/pkg/opt/$pkgname/bin/$pkgname

}

Warning! Looks like mysql-query-browser depends on gconf (unlike mysql-administrator) which means a lot of gnome stuff...
I'm not sure if this is 100% correct but that's what namcap and ldd shows. If you want to try it without gconf just remove it from dependencies and tell us if this works.

k-dub · 2004-12-18 16:01:15

cactus wrote:

addictive?

That compiling from source would solve my problems.

k-dub · 2004-12-18 16:29:44

I just build and installed lanrat's packages, and both worked fine for me. I use Gnome, though, so YMMV.

Thanks lanrat!

oscar · 2004-12-18 17:13:25

oh shiat, this application was sweet!
I think I'm a soon-to-be-addicted-to-mysql-administrator

siimo · 2004-12-22 12:42:58

thanks for the packages man, i havent tried them yet but i will when i can get my internet working again my internet at home is down cause i recently moved.

oscar · 2005-01-04 13:03:19

I can't connect to my MySQL with the query browser...
Time to RTFM

oscar · 2005-05-10 15:04:42

pkgname=mysql-query-browser
pkgver=1.1.7
pkgrel=3
pkgdesc="A GUI tool for creating, executing and optimizing SQL queries for MySql server"
url="http://www.mysql.com/products/query-browser/"
depends=('bash' 'gtk2' 'gconf' 'gnome-vfs')
source=(http://mysql.mirrored.ca/Downloads/MySQLAdministrationSuite/$pkgname-$pkgver-linux.tar.gz)
md5sums=('f3f58e7578471e5c87ca7c68820f4780')

build() {

    install -d -m755 $startdir/pkg/opt/$pkgname/bin
    install -d -m755 $startdir/pkg/opt/$pkgname/doc/images
    install -d -m755 $startdir/pkg/opt/$pkgname/share/applications
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/query-browser
    install -d -m755 $startdir/pkg/opt/$pkgname/share/mysql-gui/common
    install -d -m755 $startdir/pkg/usr/bin

    cd $startdir/src/$pkgname/bin
    install -m755 * $startdir/pkg/opt/$pkgname/bin

    cd $startdir/src/$pkgname/doc
    install -m664 *.html $startdir/pkg/opt/$pkgname/doc

    cd $startdir/src/$pkgname/doc/images
    install -m664 * $startdir/pkg/opt/$pkgname/doc/images

    cd $startdir/src/$pkgname/share/applications
    install -m644 * $startdir/pkg/opt/$pkgname/share/applications

    cd $startdir/src/$pkgname/share/mysql-gui/query-browser
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/query-browser

    cd $startdir/src/$pkgname/share/mysql-gui/common
    install -m644 * $startdir/pkg/opt/$pkgname/share/mysql-gui/common

    cd $startdir/src/$pkgname/share/mysql-gui
    install -m644 *.png $startdir/pkg/opt/$pkgname/share/mysql-gui

    cd $startdir/src/$pkgname
    install -m444 COPYING $startdir/pkg/opt/$pkgname

    cd $startdir/pkg/usr/bin
    ln -s ../../opt/$pkgname/bin/$pkgname $pkgname

    sed -i "s/^MYPATH=.*$/MYPATH=/opt/$pkgname/bin/" $startdir/pkg/opt/$pkgname/bin/$pkgname

}

Latest version :-)

Moo-Crumpus · 2006-02-27 16:35:33

Btw there are packages at the AUR that no longer work. They did once and no one knows why the heck they don't do anymore

Arch Linux

#1 2004-12-03 03:55:45

MySQL Administrator

#2 2004-12-03 04:18:45

Re: MySQL Administrator

#3 2004-12-03 06:47:17

Re: MySQL Administrator

#4 2004-12-03 23:44:05

Re: MySQL Administrator

#5 2004-12-04 00:05:29

Re: MySQL Administrator

#6 2004-12-11 02:38:31

Re: MySQL Administrator

#7 2004-12-17 11:15:21

Re: MySQL Administrator

#8 2004-12-17 16:11:39

Re: MySQL Administrator

#9 2004-12-17 23:30:32

Re: MySQL Administrator

#10 2004-12-18 00:55:10

Re: MySQL Administrator

#11 2004-12-18 02:23:41

Re: MySQL Administrator

#12 2004-12-18 05:05:14

Re: MySQL Administrator

#13 2004-12-18 06:47:01

Re: MySQL Administrator

#14 2004-12-18 11:58:20

Re: MySQL Administrator

#15 2004-12-18 12:47:29

Re: MySQL Administrator

#16 2004-12-18 16:01:15

Re: MySQL Administrator

#17 2004-12-18 16:29:44

Re: MySQL Administrator

#18 2004-12-18 17:13:25

Re: MySQL Administrator

#19 2004-12-22 12:42:58

Re: MySQL Administrator

#20 2005-01-04 13:03:19

Re: MySQL Administrator

#21 2005-05-10 15:04:42

Re: MySQL Administrator

#22 2006-02-27 16:35:33

Re: MySQL Administrator

Board footer