| View previous topic :: View next topic |
| Author |
Message |
sigmalll Guru


Joined: 24 Aug 2003 Posts: 332
|
Posted: Fri Dec 31, 2004 1:54 pm Post subject: Unmask Mysqlcc, scrap that, put mysqlcc back !! |
|
|
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 |
|
 |
sigmalll Guru


Joined: 24 Aug 2003 Posts: 332
|
Posted: Mon Oct 10, 2005 5:59 am Post subject: |
|
|
*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 |
|
 |
hasues n00b


Joined: 04 Mar 2004 Posts: 42
|
Posted: Mon Oct 24, 2005 9:21 pm Post subject: I agree |
|
|
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 |
|
 |
hasues n00b


Joined: 04 Mar 2004 Posts: 42
|
Posted: Mon Oct 24, 2005 9:30 pm Post subject: Sigh.. |
|
|
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 |
|
 |
Monkeh Veteran


Joined: 06 Aug 2005 Posts: 1625 Location: England
|
Posted: Mon Oct 24, 2005 9:30 pm Post subject: |
|
|
| 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 |
|
 |
sigmalll Guru


Joined: 24 Aug 2003 Posts: 332
|
Posted: Fri Oct 28, 2005 6:30 am Post subject: |
|
|
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 |
|
 |
liryon n00b

Joined: 21 Aug 2003 Posts: 19
|
Posted: Tue Nov 01, 2005 9:24 pm Post subject: |
|
|
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 |
|
 |
Monkeh Veteran


Joined: 06 Aug 2005 Posts: 1625 Location: England
|
Posted: Wed Nov 02, 2005 1:14 am Post subject: |
|
|
| 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?  |
|
| Back to top |
|
 |
Carlo Developer


Joined: 12 Aug 2002 Posts: 3351
|
Posted: Wed Nov 02, 2005 7:39 am Post subject: |
|
|
| 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?  |
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 |
|
 |
Monkeh Veteran


Joined: 06 Aug 2005 Posts: 1625 Location: England
|
Posted: Wed Nov 02, 2005 8:59 am Post subject: |
|
|
| 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?  |
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 |
|
 |
Havin_it l33t

Joined: 17 Jul 2005 Posts: 682 Location: Edinburgh, UK
|
Posted: Sat Mar 24, 2007 1:48 pm Post subject: |
|
|
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 |
|
 |
|
|
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
|
|