[gentoo-user] mysql is being pulled in again!

[gentoo-user] mysql is being pulled in again!

[Mick]

I am trying to understand what is pulling in mysql again.  This
morning a load of qt packages were being updated and I noticed a bunch
of perl and virtual packages in there too.  Rest assured dev-db/mysql
was in there, again.  This is despite the fact that the mysql use flag
seem to be not active as far as portage is concerned:

# euse -i mysql
global use flags (searching: mysql)
************************************************************
[-    ] mysql - Adds mySQL Database support

local use flags (searching: mysql)
************************************************************
[-    ] mysql (app-admin/ulogd):
Build MYSQL output plugin to save packets in a mysql database.

[-    ] mysql (net-misc/mediatomb):
Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
disabled, dev-db/sqlite is used in its stead.

Looking into it further I see that the virtual package is pulling the
database in:

# equery depends dev-db/mysql
[ Searching for packages depending on dev-db/mysql... ]
virtual/mysql-5.0 (=dev-db/mysql-5.0*)

# equery depends virtual/mysql
[ Searching for packages depending on virtual/mysql... ]
dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)

So, is this telling me the virtual mysql package depends of the real
mysql and vice versa?  Should I give up and accept that just like a
LAMP build, from now on a Linux desktop *must* run mysql and nothing
else will do?  I've read that sqlite is borked and won't do what
semantic-desktop wants, but what about people who for arguments sake
want to run postgress or some other database?
-- 
Regards,
Mick

Re: [gentoo-user] mysql is being pulled in again!

[Alan McKinnon]

On Thursday 04 March 2010 17:37:23 Mick wrote:
> I am trying to understand what is pulling in mysql again.  This
> morning a load of qt packages were being updated and I noticed a bunch
> of perl and virtual packages in there too.  Rest assured dev-db/mysql
> was in there, again.  This is despite the fact that the mysql use flag
> seem to be not active as far as portage is concerned:
> 
> # euse -i mysql
> global use flags (searching: mysql)
> ************************************************************
> [-    ] mysql - Adds mySQL Database support
> 
> local use flags (searching: mysql)
> ************************************************************
> [-    ] mysql (app-admin/ulogd):
> Build MYSQL output plugin to save packets in a mysql database.
> 
> [-    ] mysql (net-misc/mediatomb):
> Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
> disabled, dev-db/sqlite is used in its stead.
> 
> Looking into it further I see that the virtual package is pulling the
> database in:
> 
> # equery depends dev-db/mysql
> [ Searching for packages depending on dev-db/mysql... ]
> virtual/mysql-5.0 (=dev-db/mysql-5.0*)
> 
> # equery depends virtual/mysql
> [ Searching for packages depending on virtual/mysql... ]
> dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
> dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
> dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
> dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
> x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)
> 
> So, is this telling me the virtual mysql package depends of the real
> mysql and vice versa?  Should I give up and accept that just like a
> LAMP build, from now on a Linux desktop *must* run mysql and nothing
> else will do?  I've read that sqlite is borked and won't do what
> semantic-desktop wants, but what about people who for arguments sake
> want to run postgress or some other database?

The tool you want to answer this question is

emerge -t

There will be a reason why mysql is being pulled in, most likely a package 
that must have it. 

If a user wants postgres, he should install and run postgres. How would this 
affect the presence or absence of mysql?
 
-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 368 bytes --]

On Thu, 4 Mar 2010 17:57:15 +0200, Alan McKinnon wrote:

> The tool you want to answer this question is
> 
> emerge -t
> 
> There will be a reason why mysql is being pulled in, most likely a
> package that must have it. 

I notice qt-sql is in the list, does that have the mysql flag forced on?


-- 
Neil Bothwick

In the begining, there was nothing.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 4 March 2010 15:57, Alan McKinnon <alan.mckinnon@gmail.com> wrote:
> On Thursday 04 March 2010 17:37:23 Mick wrote:
>> I am trying to understand what is pulling in mysql again.  This
>> morning a load of qt packages were being updated and I noticed a bunch
>> of perl and virtual packages in there too.  Rest assured dev-db/mysql
>> was in there, again.  This is despite the fact that the mysql use flag
>> seem to be not active as far as portage is concerned:
>>
>> # euse -i mysql
>> global use flags (searching: mysql)
>> ************************************************************
>> [-    ] mysql - Adds mySQL Database support
>>
>> local use flags (searching: mysql)
>> ************************************************************
>> [-    ] mysql (app-admin/ulogd):
>> Build MYSQL output plugin to save packets in a mysql database.
>>
>> [-    ] mysql (net-misc/mediatomb):
>> Use dev-db/mysql as backend rather than SQLite3. If this USE flag is
>> disabled, dev-db/sqlite is used in its stead.
>>
>> Looking into it further I see that the virtual package is pulling the
>> database in:
>>
>> # equery depends dev-db/mysql
>> [ Searching for packages depending on dev-db/mysql... ]
>> virtual/mysql-5.0 (=dev-db/mysql-5.0*)
>>
>> # equery depends virtual/mysql
>> [ Searching for packages depending on virtual/mysql... ]
>> dev-db/mysql-5.0.84-r1 (=virtual/mysql-5.0)
>> dev-libs/cyrus-sasl-2.1.23-r1 (mysql? virtual/mysql)
>> dev-libs/redland-1.0.10-r1 (mysql? virtual/mysql)
>> dev-perl/DBD-mysql-4.00.5 (virtual/mysql)
>> x11-libs/qt-sql-4.6.2 (mysql? virtual/mysql)
>>
>> So, is this telling me the virtual mysql package depends of the real
>> mysql and vice versa?  Should I give up and accept that just like a
>> LAMP build, from now on a Linux desktop *must* run mysql and nothing
>> else will do?  I've read that sqlite is borked and won't do what
>> semantic-desktop wants, but what about people who for arguments sake
>> want to run postgress or some other database?
>
> The tool you want to answer this question is
>
> emerge -t

Right, but I started this mammoth emerge before I spent enough time
looking at its contents I'm afraid.  :-(  I could of course uninstall
them and try again, but there's steam coming out the back of this old
box and I would rather not have to rinse and repeat.

This is what was pulled in today and most of the perl stuff seemed
like new installs:

     Thu Mar  4 09:20:24 2010 >>> dev-libs/libffi-3.0.9
     Thu Mar  4 09:20:49 2010 >>> dev-db/mysql-init-scripts-1.2
     Thu Mar  4 09:26:49 2010 >>> net-dns/bind-tools-9.4.3_p5
     Thu Mar  4 09:33:38 2010 >>> dev-perl/Net-Daemon-0.43
     Thu Mar  4 09:34:57 2010 >>> perl-core/Storable-2.20
     Thu Mar  4 09:35:22 2010 >>> dev-perl/yaml-0.68
     Thu Mar  4 09:35:56 2010 >>> perl-core/Test-Harness-3.17
     Thu Mar  4 09:36:32 2010 >>> perl-core/Package-Constants-0.02
     Thu Mar  4 09:37:07 2010 >>> perl-core/Sys-Syslog-0.27
     Thu Mar  4 09:37:26 2010 >>> virtual/perl-Storable-2.20
     Thu Mar  4 09:37:41 2010 >>> virtual/perl-Test-Harness-3.17
     Thu Mar  4 09:37:57 2010 >>> virtual/perl-Package-Constants-0.02
     Thu Mar  4 09:38:15 2010 >>> virtual/perl-Sys-Syslog-0.27
     Thu Mar  4 09:38:46 2010 >>> dev-perl/PlRPC-0.2020-r1
     Thu Mar  4 09:39:19 2010 >>> perl-core/IO-Zlib-1.09
     Thu Mar  4 09:39:35 2010 >>> virtual/perl-IO-Zlib-1.09
     Thu Mar  4 09:40:09 2010 >>> perl-core/Archive-Tar-1.54
     Thu Mar  4 09:40:27 2010 >>> virtual/perl-Archive-Tar-1.54
     Thu Mar  4 09:41:03 2010 >>> perl-core/Module-Build-0.34.0201
     Thu Mar  4 09:41:19 2010 >>> virtual/perl-Module-Build-0.34.0201
     Thu Mar  4 09:41:52 2010 >>> perl-core/ExtUtils-CBuilder-0.26.03
     Thu Mar  4 09:42:08 2010 >>> virtual/perl-ExtUtils-CBuilder-0.26.03
     Thu Mar  4 09:42:48 2010 >>> perl-core/File-Spec-3.30
     Thu Mar  4 09:43:21 2010 >>> perl-core/ExtUtils-ParseXS-2.20.0401
     Thu Mar  4 09:43:37 2010 >>> virtual/perl-ExtUtils-ParseXS-2.20.0401
     Thu Mar  4 09:43:53 2010 >>> virtual/perl-File-Spec-3.30
     Thu Mar  4 09:44:48 2010 >>> dev-perl/DBI-1.609
     Thu Mar  4 09:47:31 2010 >>> dev-util/boost-build-1.41.0
     Thu Mar  4 09:55:19 2010 >>> media-gfx/exiv2-0.19
     Thu Mar  4 11:49:55 2010 >>> dev-libs/boost-1.41.0-r3
     Thu Mar  4 12:29:27 2010 >>> dev-db/mysql-5.0.84-r1
     Thu Mar  4 12:29:44 2010 >>> virtual/mysql-5.0
     Thu Mar  4 12:30:32 2010 >>> dev-perl/DBD-mysql-4.00.5
     Thu Mar  4 13:08:28 2010 >>> x11-libs/qt-core-4.6.2-r1
     Thu Mar  4 13:12:49 2010 >>> x11-libs/qt-dbus-4.6.2
     Thu Mar  4 13:28:44 2010 >>> x11-libs/qt-script-4.6.2
     Thu Mar  4 13:32:06 2010 >>> x11-libs/qt-sql-4.6.2
     Thu Mar  4 13:33:58 2010 >>> x11-libs/qt-test-4.6.2
     Thu Mar  4 14:01:18 2010 >>> x11-libs/qt-xmlpatterns-4.6.2
     Thu Mar  4 15:45:26 2010 >>> x11-libs/qt-gui-4.6.2
     Thu Mar  4 16:11:12 2010 >>> x11-libs/qt-qt3support-4.6.2
     Thu Mar  4 16:17:31 2010 >>> x11-libs/qt-opengl-4.6.2
     Thu Mar  4 16:21:11 2010 >>> x11-libs/qt-svg-4.6.2


> There will be a reason why mysql is being pulled in, most likely a package
> that must have it.

If a package must have it, wouldn't the USE flag mysql switch to + ?

> If a user wants postgres, he should install and run postgres. How would this
> affect the presence or absence of mysql?

Well, I am assuming that if postgres can do what mysql does, then it
could work in its place.  Like if syslog-ng will do what metalog does,
then the virtual/log-thingie will not insist in pulling in metalog.
Anyway, the postgres is just an example of asking why are we locking
down the choice of a database to a particular package/provider.

I am thinking that x11-libs/qt-sql-4.6.2 may be what started this
emerge of mysql.
-- 
Regards,
Mick

[gentoo-user] Re: mysql is being pulled in again!

[Nikos Chantziaras]

On 03/04/2010 07:07 PM, Mick wrote:
> On 4 March 2010 15:57, Alan McKinnon<alan.mckinnon@gmail.com>  wrote:
>> There will be a reason why mysql is being pulled in, most likely a package
>> that must have it.
>
> If a package must have it, wouldn't the USE flag mysql switch to + ?

No.  The USE flag is only for packages where MySQL is optional.  If a 
package can't be used without MySQL, there's no "mysql" USE flag for it.


> I am thinking that x11-libs/qt-sql-4.6.2 may be what started this
> emerge of mysql.

No, that one has MySQL as an optional dep and therefore it obeys the 
"mysql" USE flag.  To see which installed packages pull-in mysql, use:

   equery depends mysql

If the output starts with "(mysql?" then that package only pulls mysql 
if the USE flag is set.  If it shows a package pulling mysql without the 
"(mysql?" part, then you've found the culprit.

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 1687 bytes --]

On Thu, 4 Mar 2010 17:07:22 +0000, Mick wrote:

> > The tool you want to answer this question is
> >
> > emerge -t
> 
> Right, but I started this mammoth emerge before I spent enough time
> looking at its contents I'm afraid.

The use emerge --depclean -pv dev-db/mysql

> > There will be a reason why mysql is being pulled in, most likely a
> > package that must have it.
> 
> If a package must have it, wouldn't the USE flag mysql switch to + ?

USE flags control optional dependencies. If a package must have it, there
won't be a USE flag.

> > If a user wants postgres, he should install and run postgres. How
> > would this affect the presence or absence of mysql?
> 
> Well, I am assuming that if postgres can do what mysql does, then it
> could work in its place.  Like if syslog-ng will do what metalog does,
> then the virtual/log-thingie will not insist in pulling in metalog.

The difference is that the virtual/logger is satisfied by a number of
loggers, while virtual/mysql is satisfied by different mysql variants.
The other difference is that the various loggers present the same face to
other programs, whereas postgresql has a different API to mysql.

> Anyway, the postgres is just an example of asking why are we locking
> down the choice of a database to a particular package/provider.

WE are not doing anything of the sort. The upstream developers have
decided mysql is the storage system they want to use. Supporting multiple
databases would require time or experience they do not have, unless
someone else is prepared to contribute some of their own.


-- 
Neil Bothwick

God: What one human uses to persecute another.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] mysql is being pulled in again!

[Roy Wright]

Since you already merged it in:

# equery depends mysql

then unmerge or correct USE flags for dependent apps.

To have portage error out instead of merging mysql in the future:

# echo "dev-db/mysql" >/etc/portage/package.mask/I_said_no_mysql

HTH,
Roy

Re: [gentoo-user] mysql is being pulled in again!

[Alan McKinnon]

On Thursday 04 March 2010 19:07:22 Mick wrote:
> > There will be a reason why mysql is being pulled in, most likely a
> > package that must have it.
> 
> If a package must have it, wouldn't the USE flag mysql switch to + ?

Your post seems to indicate a lack of understanding of how these things work.

Often-times things are not optional, that's what "must" means. USE is 
diametrically opposed to that as it has to imply a meaning of "may". If a 
package if hard-coded to use mysql, then it must have it, and putting it in 
USE in pointless.

There's no rule about this. If mysql is a hard dep, then that's the way it is. 

> > If a user wants postgres, he should install and run postgres. How would
> > this affect the presence or absence of mysql?
> 
> Well, I am assuming that if postgres can do what mysql does, then it
> could work in its place.  Like if syslog-ng will do what metalog does,
> then the virtual/log-thingie will not insist in pulling in metalog.
> Anyway, the postgres is just an example of asking why are we locking
> down the choice of a database to a particular package/provider.

Again, you appear to fail to understand. metalog supports a variety of 
database backends. Not all apps are like this, some are hard-coded. If you 
want to use an app like this, you have no choice but to install mysql.

If you don't like this, then your choices number two:

1. Tough, get over it;
2. Use a different app

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 546 bytes --]

On Thu, 4 Mar 2010 22:07:14 +0200, Alan McKinnon wrote:

> Again, you appear to fail to understand. metalog supports a variety of 
> database backends. Not all apps are like this, some are hard-coded. If
> you want to use an app like this, you have no choice but to install
> mysql.
> 
> If you don't like this, then your choices number two:
> 
> 1. Tough, get over it;
> 2. Use a different app

3. Patch the code to support a different database.


-- 
Neil Bothwick

Better to understand a little than to misunderstand a lot.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 4 March 2010 20:07, Alan McKinnon <alan.mckinnon@gmail.com> wrote:
> On Thursday 04 March 2010 19:07:22 Mick wrote:
>> > There will be a reason why mysql is being pulled in, most likely a
>> > package that must have it.
>>
>> If a package must have it, wouldn't the USE flag mysql switch to + ?
>
> Your post seems to indicate a lack of understanding of how these things work.

Yep.  :-(

> Often-times things are not optional, that's what "must" means. USE is
> diametrically opposed to that as it has to imply a meaning of "may". If a
> package if hard-coded to use mysql, then it must have it, and putting it in
> USE in pointless.

I see.  I thought that (some relevant) USE flags reflected
dependencies at some level and that if a dependency changed then this
would reflect those USE flags which would now show up as active.  So I
thought that the mysql USE flag would change from - to +.

> There's no rule about this. If mysql is a hard dep, then that's the way it is.
>
>> > If a user wants postgres, he should install and run postgres. How would
>> > this affect the presence or absence of mysql?
>>
>> Well, I am assuming that if postgres can do what mysql does, then it
>> could work in its place.  Like if syslog-ng will do what metalog does,
>> then the virtual/log-thingie will not insist in pulling in metalog.
>> Anyway, the postgres is just an example of asking why are we locking
>> down the choice of a database to a particular package/provider.
>
> Again, you appear to fail to understand. metalog supports a variety of
> database backends. Not all apps are like this, some are hard-coded. If you
> want to use an app like this, you have no choice but to install mysql.
>
> If you don't like this, then your choices number two:
>
> 1. Tough, get over it;
> 2. Use a different app

No I think you fail to understand what I fail to understand!  Ha, ha!  :-))

I was not talking about what db a syslog app will use as a back end.
I was trying to understand why a virtual package like virtual/mysql is
pulling in dev-db/mysql and I used the syslog virtual/real
relationship as an analogy.  Anyway, I now know two things:

a) qt-sql pulled in mysql

b) when the wife shouts at me to get going with chores, I do not start
an emerge without first checking the contents of it!  :-))

Thanks again for your replies.
-- 
Regards,
Mick

Re: [gentoo-user] mysql is being pulled in again!

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 528 bytes --]

On Fri, 5 Mar 2010 06:53:15 +0000, Mick wrote:

> I was trying to understand why a virtual package like virtual/mysql is
> pulling in dev-db/mysql and I used the syslog virtual/real
> relationship as an analogy.

The clue is in the name of the virtual, it is satisfied by one of the
MySQL packages in portage. You canot simply replace one SQL database with
another, otherwise there's be a virtual/sqldb that would be satisfied by
any of them.


-- 
Neil Bothwick

Last yur I kudnt spel modjerater now I are won.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] mysql is being pulled in again!

[Mick]

On 5 March 2010 09:42, Neil Bothwick <neil@digimed.co.uk> wrote:
> On Fri, 5 Mar 2010 06:53:15 +0000, Mick wrote:
>
>> I was trying to understand why a virtual package like virtual/mysql is
>> pulling in dev-db/mysql and I used the syslog virtual/real
>> relationship as an analogy.
>
> The clue is in the name of the virtual, it is satisfied by one of the
> MySQL packages in portage. You canot simply replace one SQL database with
> another, otherwise there's be a virtual/sqldb that would be satisfied by
> any of them.

Of course!  It was all in the pkg_name.  Thank you Neil.
-- 
Regards,
Mick

[gentoo-user] Re: mysql is being pulled in again!

[Nikos Chantziaras]

On 03/04/2010 05:37 PM, Mick wrote:
> I am trying to understand what is pulling in mysql again.  This
> morning a load of qt packages were being updated and I noticed a bunch
> of perl and virtual packages in there too.  Rest assured dev-db/mysql
> was in there, again.  This is despite the fact that the mysql use flag
> seem to be not active as far as portage is concerned:

That doesn't matter.  USE flags is for optional stuff, not required 
stuff.  It's like having the kde USE flag disabled and wondering why 
emerging a KDE application wants to pull-in kdelibs...

Re: [gentoo-user] Re: mysql is being pulled in again!

[Mick]

On 4 March 2010 16:45, Nikos Chantziaras <realnc@arcor.de> wrote:
> On 03/04/2010 05:37 PM, Mick wrote:
>>
>> I am trying to understand what is pulling in mysql again.  This
>> morning a load of qt packages were being updated and I noticed a bunch
>> of perl and virtual packages in there too.  Rest assured dev-db/mysql
>> was in there, again.  This is despite the fact that the mysql use flag
>> seem to be not active as far as portage is concerned:
>
> That doesn't matter.  USE flags is for optional stuff, not required stuff.
>  It's like having the kde USE flag disabled and wondering why emerging a KDE
> application wants to pull-in kdelibs...

OK, I found out that qt-mysql caused it.  Now I better change the USE
flag and start again.

Thank you all.
-- 
Regards,
Mick