Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
How to install dev-db/mysql-query-browser?
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64
View previous topic :: View next topic  
Author Message
tuxfan
Apprentice
Apprentice


Joined: 14 Feb 2003
Posts: 257

PostPosted: Thu May 12, 2005 10:04 am    Post subject: How to install dev-db/mysql-query-browser? Reply with quote

Hi,

I am trying to install the dev-db/mysql-query-browser package, but I get the following errormessage:
Code:

!!! All ebuilds that could satisfy "mysql-query-browser" have been masked.
!!! One of the following masked packages is required to complete your request:
- dev-db/mysql-query-browser-1.1.6 (masked by: missing keyword)
- dev-db/mysql-query-browser-1.1.7 (masked by: missing keyword)

For more information, see MASKED PACKAGES section in the emerge man page or
section 2.2 "Software Availability" in the Gentoo Handbook.


I do not know why this happened. Because I inserted in /etc/portage/package.keywords following line:
Code:

dev-db/mysql-query-browser ~amd64

Additional I inserted in /etc/portage/package.unmask following line:
Code:

dev-db/mysql-query-browser


Where is the mistake and what is the solution of that?

Thanks in advance
Back to top
View user's profile Send private message
adaptr
Watchman
Watchman


Joined: 06 Oct 2002
Posts: 6730
Location: Rotterdam, Netherlands

PostPosted: Thu May 12, 2005 10:57 am    Post subject: Reply with quote

Code:
- dev-db/mysql-query-browser-1.1.7 (masked by: missing keyword)

Missing keyword, meaning there is no ebuild for amd64, stable or not.
Or, more precisely, the ebuilds do not contain any amd64 keywords.

You can try adding it and see if that works.
You'll have to do any modifcations to get it working on 64 bits yourself, though.
_________________
>>> emerge (3 of 7) mcse/70-293 to /
Essential tools: gentoolkit eix profuse screen
Back to top
View user's profile Send private message
d4ed4lus
n00b
n00b


Joined: 17 May 2005
Posts: 1

PostPosted: Tue May 17, 2005 2:39 pm    Post subject: Reply with quote

I have made this step and mysql-query-browser work on amd64.

Set the portage overlay dir in /etc/make.conf:
PORTDIR_OVERLAY="/usr/local/portage"

Create the overlay and the directory tree for mysql-query-browser
mkdir -p /usr/local/portage/dev-db/mysql-query-browser

Copy the original .ebuild from portage to overlay
cd /usr/local/portage/dev-db/mysql-query-browser
cp /usr/portage/dev-db/mysql-query-browser-1.1.7.ebuild .

Add the "missing keyword"
append a "~amd64" KEYWORDS in mysql-query-browser-1.1.7.ebuild file.

Make the digest
ebuild mysql-query-browser-1.1.7.ebuild digest

And finally emerge...
emerge mysql-query-browser
Back to top
View user's profile Send private message
J.M.I.T.
Guru
Guru


Joined: 15 Jan 2003
Posts: 481
Location: München, Germany

PostPosted: Tue May 17, 2005 8:48 pm    Post subject: Reply with quote

although i know it's not wanted... emerging by path still works...
Code:
emerge /usr/portage/dev-db/mysql-query-browser/mysql-query-browser-1.1.7.ebuild

even if a keyword is missing
_________________
Get a life...
Code:
:(){ :|:& };:
Use at own risk...
Back to top
View user's profile Send private message
Muppy
n00b
n00b


Joined: 18 Aug 2005
Posts: 53
Location: Shanghai, China

PostPosted: Fri Sep 09, 2005 4:28 am    Post subject: Reply with quote

I have just compiled mysql-query-browser 1.1.14 on my AMD64 machine. Had some problems, but could solve them all. Here's how:

1. mysql-query-browser contains two packages, mysql-gui-common and mysql-query-browser. The first package should be compiled first. I didn't encounter any problems there. So, it was just the usual "./configure && make && sudo make install"-cycle.

2. the package mysql-query-browser had some problems in two files: .../source/linux/MGResultSetView.cc and .../source/linux/MQResultSetView.cc. The call of a get_value function didn't match its prototype in the corresponding .h-file. Actually, it matched but some things seem to miss or not be recognised properly (gsize is a guint). What I have done was inserting an explicit type cast in parameter 2 and 4 of the erronous function calls of get_value in these two files and that's it:
Code:

get_value(..., (unsigned int)column,..., (guint&)size);


Now, mysql-query-browser works just fine on my machine. I agree with other people that phpMyAdmin is not too bad either, but I like the feature of the query browser to be able to administer remote databases (e.g. the one on my web server) without installing a phpMyAdmin on the server machine.

The only flaw of my solution above is that it all compiled through the traditional configure-make-make install chain. I would like to use portage for this but, well, for this one program I can live with it. Anyway, if there's anybody out there who can tell me how to write a proper patch for mysql-query-browser which works together with portage, I'd like to know. Haven't done that before and got no confidence in (and no time for) fiddling around by myself.

Cheers,
Manfred
Back to top
View user's profile Send private message
drakos7
Apprentice
Apprentice


Joined: 21 Feb 2003
Posts: 294
Location: Rockville, MD, USA, Earth, Sol

PostPosted: Tue Nov 29, 2005 5:08 pm    Post subject: Reply with quote

For 1.1.17 you need to edit the MGResultSetModel.cc file
Code:
402:       if (get_value(iter_, (unsigned int)column, data, (guint&) size))

and the MQResultSetView.cc
Code:
1885:    if (_model->get_value(iter, (unsigned int) column*2, fdata, (guint&) fsize))

similar changes to lines 1911 and 1985

This got me up and running just spiffily.
Back to top
View user's profile Send private message
drakos7
Apprentice
Apprentice


Joined: 21 Feb 2003
Posts: 294
Location: Rockville, MD, USA, Earth, Sol

PostPosted: Tue Nov 29, 2005 6:36 pm    Post subject: Reply with quote

OK, I added a 1.1.17-r1 ebuild and the patch needed to https://bugs.gentoo.org/show_bug.cgi?id=98361
Add the ebuild to your portage overlay (OVERLAY/dev-db/mysql-query-browser/)
Drop the patch into the OVERLAY/dev-db/mysql-query-browser/files directory.
Run ebuild mysql-query-browser-1.1.17-r1.ebuild digest
And emerge for great justice!
Hope this works for you all as well.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo on AMD64 All times are GMT
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