Gentoo Forums
Gentoo Forums
Quick Search: in
Unmask Mysqlcc, scrap that, put mysqlcc back !!
View unanswered posts
View posts from last 24 hours

rackathon
 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
sigmalll
Guru
Guru


Joined: 24 Aug 2003
Posts: 332

PostPosted: Fri Dec 31, 2004 1:54 pm    Post subject: Unmask Mysqlcc, scrap that, put mysqlcc back !! Reply with quote

Blocking a package because its upstream development has ceased BEFORE the replacement applications have made it into the tree as stable is just stupid.

Last edited by sigmalll on Mon Oct 10, 2005 6:01 am; edited 1 time in total
Back to top
View user's profile Send private message
sigmalll
Guru
Guru


Joined: 24 Aug 2003
Posts: 332

PostPosted: Mon Oct 10, 2005 5:59 am    Post subject: Reply with quote

*sigh* replying to my own rant with another....

I am now sat in front of a freshly installed amd64 boxen, mysqlcc isnt in the tree and the alternative mysql provided applications are masked. (amd64 keyword does not enable them)

I HAVE NO LOCAL GUI TO A REMOTE MYSQL SERVER.

WTF is the point of a meta distribution if end-of-line software is deleted from the tree, sometimes end-of-line software is all that works / is needed. This is especially important when the replacements for said end-of-line software hasn't made the stable tree!

I understand and appreciate all the hard work the package maintainers put in and am not having a go, but really.

Anybody know where I can get an ebuild for mysqlcc?
Back to top
View user's profile Send private message
hasues
n00b
n00b


Joined: 04 Mar 2004
Posts: 39

PostPosted: Mon Oct 24, 2005 9:21 pm    Post subject: I agree Reply with quote

I totally agree. I don't know who made the "wise" idea of remove mysqlcc from the portage tree, but this has got to stop. It's ideas like this that kill distributions of Linux, or at least prevent me from using them. I think it is interesting that Gentoo had so much "choice" involved in its roots, yet now I am "forced" into using x.org instead of XFree86, even when x.org has compatibility problems porting X displays across network connections. Yes, I understand the default choice should be x.org, but some of us may AGREE to the terms? Now mysqlcc is gone? WTH!!!
_________________
Lettuce, Pickles, hold the mayo!
Back to top
View user's profile Send private message
hasues
n00b
n00b


Joined: 04 Mar 2004
Posts: 39

PostPosted: Mon Oct 24, 2005 9:30 pm    Post subject: Sigh.. Reply with quote

http://thread.gmane.org/gmane.linux.gentoo.devel/20395

So the application is no longer in development, and it was decided to be removed from portage. How about keeping it, and merely requiring an older version of Qt to be around as it ages? It seems to me we can't get rid of Gtk1 over Gtk2 for the same reasons?

I'll start using mysqladministrator, but good grief.

Has
_________________
Lettuce, Pickles, hold the mayo!
Back to top
View user's profile Send private message
Monkeh
Veteran
Veteran


Joined: 06 Aug 2005
Posts: 1470
Location: England

PostPosted: Mon Oct 24, 2005 9:30 pm    Post subject: Reply with quote

If they're not in the tree, that means devs aren't willing to work on packages which have superior replacements. If it's not in portage, you can just grab the most recent ebuild from cvs, put it in your overlay, and go. Or, alternatively, you could just build it yourself (not exactly hard).
Back to top
View user's profile Send private message
sigmalll
Guru
Guru


Joined: 24 Aug 2003
Posts: 332

PostPosted: Fri Oct 28, 2005 6:30 am    Post subject: Reply with quote

You want mysqlcc - heres an ebuild, grabbed it and the patches from googles cache (had to tweak the ebuild to get all the patches applied, so its not exactly the same as the ebuild of the same version that was in the tree, but as its not in the tree anymore, who cares.)

In your portage overlay...
Code:
mkdir dev-db
mkdir dev-db/mysqlcc
mkdir dev-db/mysqlcc/files


dev-db/mysqlcc/mysqlcc-0.9.4-r1.ebuild
Code:
# Copyright 1999-2004 Gentoo Technologies, Inc.
# Distributed under the terms of the GNU General Public License v2
# $Header: /home/cvsroot/gentoo-x86/dev-db/mysqlcc/mysqlcc-0.9.4.ebuild,v 1.3 2004/03/30 08:38:19 aliz Exp $

inherit eutils

S=${WORKDIR}/${P}-src
DESCRIPTION="a MySQL GUI Client"
HOMEPAGE="http://www.mysql.com/"
SRC_URI="ftp://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQLCC/${P}-src.tar.gz"

LICENSE="GPL-2"
SLOT="0"
KEYWORDS="x86 amd64"
IUSE="ssl"

DEPEND=""

RDEPEND=""

src_unpack() {
        unpack ${A}
         cd ${S}; epatch ${FILESDIR}/${P}-libmysqlclientac.patch
         epatch ${FILESDIR}/${P}-shutdown.patch
}

src_compile() {
        # The config.sub in this distribution appears to be very stale
        # so we replace it with one from a known better source.  I am
        # not attached to using 1.4, but it seemed like it had the best
        # chance of compatibility.
        # Robert Coie <rac@gentoo.org> 2003.03.03
        if [ -e /usr/share/automake-1.4/config.sub ]; then
                cp /usr/share/automake-1.4/config.sub ${S}
        fi
        cd ${S}; autoreconf -f;

        if [ "`use ssl`" ]; then
                SUBLIBS="${SUBLIBS} -lssl"
                echo "libs now ${SUBLIBS}"
        fi

        QMAKESPEC="linux-g++" LIBS=${LIBS} econf --with-qt=${QTDIR} || die

        cp Makefile Makefile.orig
        sed -e "s:CFLAGS   = -pipe -Wall -W -O2:CFLAGS   = ${CFLAGS}:" \
                -e "s:CXXFLAGS = -pipe -Wall -W -O2:CXXFLAGS = ${CXXFLAGS}:" \
                Makefile.orig > Makefile

        QTDIR=$QTDIR
        emake || die
}

src_install() {
        dobin mysqlcc
        dodir /usr/share/mysqlcc
        insinto /usr/share/mysqlcc
        doins warning.wav information.wav error.wav syntax.txt
        dodir /usr/share/mysqlcc/translations
        insinto /usr/share/mysqlcc/translations
        doins translations/*.qm  translations/*.ts
        dodoc *.txt
}

dev-db/mysqlcc/files/mysqlcc-0.9.4-libmysqlclientac.patch
Code:
--- acinclude.m4.orig   2003-03-04 01:07:26.000000000 -0800
+++ acinclude.m4        2003-03-04 12:46:35.000000000 -0800
@@ -6,34 +6,15 @@
         AC_MSG_CHECKING([for libmysqlclient])
         AC_MSG_RESULT()

-        mysql_ok=no
-
-        SAVE_LIBS=$LIBS
-
-        mysql_lib="$mysql_lib /usr/lib /usr/lib/mysql \
-                   /usr/local/lib /usr/local/lib/mysql \
-                   /usr/local/mysql/lib"
-
-        for dir in $mysql_lib; do
-            if test "x$mysql_found" != "xyes"
-            then
-                AC_CHECK_FILE("$dir/libmysqlclient.a",
-                              mysql_found=yes, mysql_found=no)
-                if test "x$mysql_found" = "xyes"
-                then
-                    LIBS="-L$dir $SAVE_LIBS $LIBZ_LIB"
-                    MYSQL_LIB="$dir/libmysqlclient.a $LIBZ_LIB"
-                    AC_SUBST(MYSQL_LIB)
-                    AC_CHECK_LIB(mysqlclient, mysql_real_connect,
-                                 mysql_ok=yes, mysql_ok=no)
-                fi
-            fi
-        done
-
-        if test "x$mysql_ok" != "xyes"
-        then
-            AC_MSG_ERROR([Could not find libmysqlclient in '$mysql_lib'])
-        fi
+       # dependencies are guaranteed to ensure we have mysql_config
+       # available, and it is a much cleaner way of discovering what
+       # must be linked against libmysqlclient, that transparently
+       # covers USE="ssl" and other issues.
+       # Robert Coie  2003.03.04
+
+       mysql_ok=yes
+       MYSQL_LIB=`mysql_config --libs`
+       LIBS="${LIBS} ${MYSQL_LIB}"
 ])

dev-db/mysqlcc/files/mysqlcc-0.9.4-shutdown.patch
Code:
--- shared/src/CMySQL.cpp.orig  Thu Aug  5 12:26:14 2004
+++ shared/src/CMySQL.cpp       Thu Aug  5 12:29:53 2004
@@ -451,7 +451,11 @@
   if (!isConnected())
     return false;

+#if  ( MYSQL_VERSION_ID >= 40103 )
+  if (mysql_shutdown(mysql,SHUTDOWN_DEFAULT) != 0)
+#else
   if (mysql_shutdown(mysql) != 0)
+#endif
   {
     if (emiterror)
       emitError();


Then make the digest
Code:
ebuild /your/portage/overlay/dev-db/mysqlcc/mysqlcc-0.9.4-r1.ebuild digest

Then emerge as usual
Back to top
View user's profile Send private message
liryon
n00b
n00b


Joined: 21 Aug 2003
Posts: 19

PostPosted: Tue Nov 01, 2005 9:24 pm    Post subject: Reply with quote

The patches provided did not work for me, so I created some new patches that worked for me. They do the same thing as the above ones, basicly just the line numbers and other such things that allow the patch to be applied are changed. Enjoy.

dev-db/mysqlcc/files/mysqlcc-0.9.4-libmysqlclientac.patch
Code:

--- acinclude.m4.orig   2005-11-01 20:52:17.000000000 -0500
+++ acinclude.m4   2005-11-01 20:51:59.000000000 -0500
@@ -6,34 +6,15 @@
         AC_MSG_CHECKING([for libmysqlclient])
         AC_MSG_RESULT()
 
-        mysql_ok=no
-
-        SAVE_LIBS=$LIBS
-   
-        mysql_lib="$mysql_lib /usr/lib /usr/lib/mysql \
-                   /usr/local/lib /usr/local/lib/mysql \
-                   /usr/local/mysql/lib"
-   
-        for dir in $mysql_lib; do
-            if test "x$mysql_found" != "xyes"
-            then
-                AC_CHECK_FILE("$dir/libmysqlclient.a",
-                              mysql_found=yes, mysql_found=no)
-                if test "x$mysql_found" = "xyes"
-                then
-                    LIBS="-L$dir $SAVE_LIBS $LIBZ_LIB"
-                    MYSQL_LIB="$dir/libmysqlclient.a $LIBZ_LIB"
-                    AC_SUBST(MYSQL_LIB)
-                    AC_CHECK_LIB(mysqlclient, mysql_real_connect,
-                                 mysql_ok=yes, mysql_ok=no)
-                fi
-            fi
-        done
-
-        if test "x$mysql_ok" != "xyes"
-        then
-            AC_MSG_ERROR([Could not find libmysqlclient in '$mysql_lib'])
-        fi
+          # dependencies are guaranteed to ensure we have mysql_config
+          # available, and it is a much cleaner way of discovering what
+          # must be linked against libmysqlclient, that transparently
+          # covers USE="ssl" and other issues.
+          # Robert Coie  2003.03.04
+
+          mysql_ok=yes
+          MYSQL_LIB=`mysql_config --libs`
+   LIBS="${LIBS} ${MYSQL_LIB}"
 ])


dev-db/mysqlcc/files/mysqlcc-0.9.4-shutdown.patch
Code:

--- shared/src/CMySQL.cpp.orig   2005-11-01 20:27:55.000000000 -0500
+++ shared/src/CMySQL.cpp   2005-11-01 20:28:55.000000000 -0500
@@ -450,8 +450,12 @@
   
   if (!isConnected())
     return false;

-  if (mysql_shutdown(mysql) != 0)
+
+#if  ( MYSQL_VERSION_ID >= 40103 )
+  if (mysql_shutdown(mysql,SHUTDOWN_DEFAULT) != 0)
+#else
+   if (mysql_shutdown(mysql) != 0)
+#endif 
   {
     if (emiterror)
       emitError();


Oh, and btw, how dare gentoo decide that people don't want this program anymore, just leave it masked in portage forever, like they do with everything else.
Back to top
View user's profile Send private message
Monkeh
Veteran
Veteran


Joined: 06 Aug 2005
Posts: 1470
Location: England

PostPosted: Wed Nov 02, 2005 1:14 am    Post subject: Reply with quote

liryon wrote:
Oh, and btw, how dare gentoo decide that people don't want this program anymore, just leave it masked in portage forever, like they do with everything else.


They removed it from the tree because they don't want to maintain it. Not because people don't want it. Plus, they don't leave 'everything else' masked in the tree, for example, vi used to be there.. Where is it now? :roll:
Back to top
View user's profile Send private message
Carlo
Developer
Developer


Joined: 12 Aug 2002
Posts: 3227

PostPosted: Wed Nov 02, 2005 7:39 am    Post subject: Reply with quote

liryon wrote:
Oh, and btw, how dare gentoo decide that people don't want this program anymore, just leave it masked in portage forever, like they do with everything else.

It is far more important to keep the tree in a sane, maintainable state, than to keep something in the tree just because a very small minority wants it. We primarily maintain ebuilds, not the software behind it. You can always grab removed ebuilds from WebCVS and maintain them yourself.

Monkeh wrote:
Plus, they don't leave 'everything else' masked in the tree, for example, vi used to be there.. Where is it now? :roll:

In WebCVS, plus the comment why it has been removed. Use vim instead.
_________________
Please make sure that you have searched for an answer to a question after reading all the relevant docs.
Back to top
View user's profile Send private message
Monkeh
Veteran
Veteran


Joined: 06 Aug 2005
Posts: 1470
Location: England

PostPosted: Wed Nov 02, 2005 8:59 am    Post subject: Reply with quote

Carlo wrote:
Monkeh wrote:
Plus, they don't leave 'everything else' masked in the tree, for example, vi used to be there.. Where is it now? :roll:

In WebCVS, plus the comment why it has been removed. Use vim instead.


I do use VIM. And I know it's in the cvs, along with every other ebuild which has ever been added to or removed from the tree, right?
Back to top
View user's profile Send private message
Havin_it
Guru
Guru


Joined: 17 Jul 2005
Posts: 537
Location: Edinburgh, UK

PostPosted: Sat Mar 24, 2007 1:48 pm    Post subject: Reply with quote

Apologies for the rather large bump, but I'd rather this than start a new thread on exactly the same subject.

I came to Linux about the same time as MySQL AB were deciding to dump mysqlcc, so I never expected there to be one in Portage. However, I had great frustrations with mysql-administrator and phpmyadmin, and thought I'd see if there was an old ebuild or generic Linux binary to be found.

As a result I discovered that the app was now on SourceForge, and while the project isn't a hive of activity, it has had 2 new releases in the last 9 months (the last, 0.9.8, last October).

I was able to build the 0.9.8 release with no problems against qt-3.3.8 and mysql-5.0.26-r3. It can't be built with mysql-5.0.34, which may be because of the same issue that is currently affecting mysql-administrator and mysql-query-browser. Furthermore, in my usage so far, I haven't experienced any of the segfaults that seem to plague mysql-administrator.

Here's my take: mysqlcc remains the only desktop client app that offers granular, visual control of MySQL. At least, the only one that's moderately stable at present. While upstream development may not be red-hot, the same could be said of the MySQL AB utilities. There is a subset of MySQL users who like this approach to management better than any of the existing tools, and I also think it's a very appealing tool for newbies (as it was for me in my time).

I think I would like to file a request for bringing it back into portage, but I don't want to jump the gun when I may be overlooking other issues. I would very much like to hear if others think this is a good idea, or if there are additional reasons against it.

[EDIT - corrected qt version number]
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum