Slotted MySQL Mess

ralphschindler · n00b Joined: 03 Feb 2006 Posts: 2

So far, not a fan. Ive emerged eselect-mysql 1.0.0-r1, using the ~x86 keyword installed 5.0.18-r30.

after installing (clean) ran this:

# eselect mysql list
Available MySQL versions:
[1] 5.0.x
# eselect mysql show
Current default MySQL version:
(unset)
# eselect mysql set 1
# eselect mysql show
Current default MySQL version:
(unset)
# mysql
-bash: mysql: command not found

# pwd; ls -l *mysql*
/usr/bin
-rwxr-xr-x 1 root root 1466 Feb 1 12:56 msql2mysql-500
-rwxr-xr-x 1 root root 74396 Feb 1 12:56 mysql-500
-rwxr-xr-x 1 root root 330472 Feb 1 12:56 mysql_client_test-500
.... etc ....

Eselect does not make links to the -500 binairies. Not only that, but I feel like this slotting technique dirtied up my file system.. Now I have a /etc/mysql link and a /etc/mysql-500... a /var/log/mysql-500 and a /var/lib/mysql-500

This is silly IMO. Can I have a non-slotted mysql? I dont compile things against the libs in /usr/lib so I have no interest in maintaining version compatibllity across dynamically linked libs.

How do I get my old ebuilds for mysql5 to compile to the standard non-500 locations?

-Ralph

hielvc · Posted: Sat Feb 04, 2006 8:25 pm Post subject:

Check " man portage ' for details but yo should be able to useing /etc/portage/package.mask or maybe its package.provided block out all mysqls but the version you want. Heck "emerge unmerge mysql -p " and unmerge the versions you no longer use, its like the every other day kernel updates :lol:

_________________
An A-Z Index of the Linux BASH command line

blossa · Apprentice Joined: 13 Jan 2005 Posts: 169

I just had the same issue (but using ~amd64) and I ended up unmerge mysql. Then I manually removed all remaining mysql-files and then emerged mysql again. I now only have *mysql-500* and no *mysql* directory names. I don't like it but atleast it works now. If I remember right I had a symlink like: '/etc/mysql/mysql-500 > /etc/mysql/mysql-500' (it pointed to itself) that totaly screwed up my mysql.

ralphschindler · n00b Joined: 03 Feb 2006 Posts: 2

So does anyone know if there is a keyword or a switch to turn off slotting? Has anyone seen this in any other slotted ebuild?

-Ralph

hielvc · Posted: Tue Feb 07, 2006 3:29 am Post subject:

The abilty to slot is one of portages advantages. If you do an "emerge system -ep|grep make " you'll get 6 automake's listed. You need all six to handel old programs to new programs. In this instances, mysql, its problematic.Gentoo isnt a cookie cuter solution. The Devs try hard but when you runmning cutin edge ...... boo boo's happem.
_________________
An A-Z Index of the Linux BASH command line

Narada · Guru Joined: 12 Dec 2002 Posts: 300 Location: London, UK

I'm getting the same problem.

djsmiley2k · Posted: Sun Feb 12, 2006 3:16 pm Post subject:

I also had this problem, in the end i've stopped running a unstable system after a friend on irc went mental at me about it.

So back to version 4. something for me i guess. Im only installing it so i can use cacti and amarok properly anyway. :-/

boaglio · Posted: Mon Feb 13, 2006 2:29 am Post subject:

How I solved this mess today:

Narada · Guru Joined: 12 Dec 2002 Posts: 300 Location: London, UK

Yeah. I did the same.

XtAzY · n00b Joined: 18 Jan 2005 Posts: 23

i hope this bug will be fixed asap =] .... now im using the non slotted version

cobalt027 · n00b Joined: 11 Sep 2004 Posts: 3 Location: Columbus, OH

I've tried removing all referenes to the mysql installs. But everytime i the emerge =dev-db/mysql-5.0.18-r30. It still gives me the -500 stuff, and it doesnt work. I dont get the slotted message from portage, but it just doesnt work. Am i not removing something from the snapshot? What is a snapshot?

Im not that new to gentoo, just never wanted to have a bleeding edge server, and therefore never ran into these issues.

hielvc · Posted: Wed Feb 15, 2006 1:20 am Post subject:

Have any of you filed a bug report about this? Heres 2 that sound like they are about this prob bug 122668 and bug 12858. the last bug will probably be marked as a duplicate.
_________________
An A-Z Index of the Linux BASH command line

p_ansell · n00b Joined: 12 May 2005 Posts: 33 Location: Brisbane, AU

I filed a more specific bug than those two, IMHO, here,

https://bugs.gentoo.org/show_bug.cgi?id=126369

p_ansell · n00b Joined: 12 May 2005 Posts: 33 Location: Brisbane, AU

Despite the misleading name of the following link, It is actually the "Highly Publicised" notice that mysql is no longer slotted, with instructions on how to upgrade from slotted to unslotted.

http://www.gentoo.org/doc/en/mysql-upgrade-slotted.xml