[gentoo-user] Has mysql become compulsory - Part 2

[gentoo-user] Has mysql become compulsory - Part 2

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 1111 bytes --]

This morning I woke up to amarok-2.2.0 requiring mysql.  No matter what USE 
flags I tried (-mysql, -semantic-desktop, -embedded, minimal) the darn thing 
wants mysql.  The strange thing is that even when I specify -embedded +minimal 
I get this:

# USE="-embedded minimal" emerge -upDv amarok 
These are the packages that would be merged, in order:

Calculating dependencies... done!

emerge: there are no ebuilds built with USE flags to satisfy ">=dev-
db/mysql-5.0.76-r1[embedded,-minimal]".
!!! One of the following packages is required to complete your request:
- dev-db/mysql-5.0.84-r1 (Change USE: +embedded -minimal)
(dependency required by "media-sound/amarok-2.2.0" [ebuild])
(dependency required by "amarok" [argument])

I don't udnerstand, are my USE choices ignored?

On this old and small laptop I do not want to install mysql.  I am already 
cursing Akonadi for starting up every time I fire up Kmail (despite having all 
the right flags according to advice from this list).  Is there anything I can 
do now to keep my laptop slim and free from mysql?
-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Volker Armin Hemmann]

this has been discussed to death.

Why don't you use google?

amarok has a hard dependency on mysql. There is nothing you can do about it 
with useflags. The amarok devs have explained that several times.

(sqlite too slow with big collections, no way to share collections, too much 
work to support more than one db etc pp).

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Mick]

[-- Attachment #1: Type: Text/Plain, Size: 589 bytes --]

On Tuesday 10 November 2009 07:44:14 Volker Armin Hemmann wrote:
> this has been discussed to death.
> 
> Why don't you use google?
> 
> amarok has a hard dependency on mysql. There is nothing you can do about it
> with useflags. The amarok devs have explained that several times.
> 
> (sqlite too slow with big collections, no way to share collections, too
>  much work to support more than one db etc pp).

Thanks Volker, I remember it being discussed, but didn't recall that mysql is 
a must - I thought that the USE flags could still offer a way out.
-- 
Regards,
Mick

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Neil Bothwick]

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

On Tue, 10 Nov 2009 08:10:03 +0000, Mick wrote:

> Thanks Volker, I remember it being discussed, but didn't recall that
> mysql is a must - I thought that the USE flags could still offer a way
> out.

Amarok 2 does not have a mysql USE flag.


-- 
Neil Bothwick

What's this script doing? unzip ; touch ; finger ; mount ; gasp ; yes ;
umount ; sleep

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

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Alan McKinnon]

On Tuesday 10 November 2009 10:57:51 Neil Bothwick wrote:
> On Tue, 10 Nov 2009 08:10:03 +0000, Mick wrote:
> > Thanks Volker, I remember it being discussed, but didn't recall that
> > mysql is a must - I thought that the USE flags could still offer a way
> > out.
> 
> Amarok 2 does not have a mysql USE flag.
> 

Don't use Amarok. Especially not 2.2.0 since it doesn't appear to be working 
for many people - mysql problems :-)

music players are a dime a dozen, out of the 100s of choices out there, there 
must be one other than amarok that suits your needs

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Dale]

Volker Armin Hemmann wrote:
> this has been discussed to death.
>
> Why don't you use google?
>
> amarok has a hard dependency on mysql. There is nothing you can do about it 
> with useflags. The amarok devs have explained that several times.
>
> (sqlite too slow with big collections, no way to share collections, too much 
> work to support more than one db etc pp).
>
>
>   

Quick question that is related.  I currently have sqlite installed, with
USE flags set as sqlite and -mysql.  If I change the USE flags to the
opposite, mysql and -sqlite, and run emerge -uvNDa world, would that fix
all the stuff that needs fixing?  Sine I am having "issues" with KDE 4,
I may as well bite the bullet here.  According to equery there are quite
a few things that depend on sqlite.


root@smoker / # equery depends sqlite
[ Searching for packages depending on sqlite... ]
app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
                        (sqlite3? dev-db/sqlite:3)
dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
root@smoker / #   



Thanks.

Dale

:-)  :-) 

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Volker Armin Hemmann]

On Dienstag 10 November 2009, Alan McKinnon wrote:
> On Tuesday 10 November 2009 10:57:51 Neil Bothwick wrote:
> > On Tue, 10 Nov 2009 08:10:03 +0000, Mick wrote:
> > > Thanks Volker, I remember it being discussed, but didn't recall that
> > > mysql is a must - I thought that the USE flags could still offer a way
> > > out.
> >
> > Amarok 2 does not have a mysql USE flag.
> 
> Don't use Amarok. Especially not 2.2.0 since it doesn't appear to be
>  working for many people - mysql problems :-)
> 
> music players are a dime a dozen, out of the 100s of choices out there,
>  there must be one other than amarok that suits your needs
> 

amarok works great here.

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Neil Bothwick]

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

On Tue, 10 Nov 2009 11:26:33 +0100, Volker Armin Hemmann wrote:

> amarok works great here.

Everything works great somewhere, even Windows :P


-- 
Neil Bothwick

Picard: 'What do the sensors say Mr Data?'
Data:   'They tell us that we can't say "F*ck" Sir."
Picard: 'I meant the ship's sensors Mr Data'

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

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Volker Armin Hemmann]

On Dienstag 10 November 2009, Neil Bothwick wrote:
> On Tue, 10 Nov 2009 11:26:33 +0100, Volker Armin Hemmann wrote:
> > amarok works great here.
> 
> Everything works great somewhere, even Windows :P
> 

seroiously, what does not work great with amarok? it compiles, it installes, 
it scans my collection, it plays my stuff.

just because you can not use emerge does not mean that others share your 
handicap :P

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Alan McKinnon]

On Tuesday 10 November 2009 13:34:08 Volker Armin Hemmann wrote:
> On Dienstag 10 November 2009, Neil Bothwick wrote:
> > On Tue, 10 Nov 2009 11:26:33 +0100, Volker Armin Hemmann wrote:
> > > amarok works great here.
> >
> > Everything works great somewhere, even Windows :P
> 
> seroiously, what does not work great with amarok? it compiles, it
>  installes, it scans my collection, it plays my stuff.
> 
> just because you can not use emerge does not mean that others share your
> handicap :P
> 

amarok consistently crashes here:

amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "trash" for 
KUrl("trash:/")                                 
amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: 
Listening on  "local:/home/alan/.kde4/socket-nazgul/amarokx12157.slave-socket"                                                                                              
amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "file" for 
KUrl("file:///home/alan/downloads/music")        
amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: 
Listening on  "local:/home/alan/.kde4/socket-nazgul/amarokN12157.slave-socket"                                                                                              
amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: 
Listening on  "local:/home/alan/.kde4/socket-nazgul/amarokm12157.slave-socket"                                                                                              
amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "file" for 
KUrl("file:///usr/share/apps/amarok/images//info_frontpage_logo.png")                                                                                                       
amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote: 
Listening on  "local:/home/alan/.kde4/socket-nazgul/amarokz12157.slave-socket"                                                                                              
amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::instance: 
instance(): ... initialised                         
amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readConfig: 
readConfig(): local zone= "Africa/Johannesburg"   
amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readZoneTab: 
readZoneTab( "/usr/share/zoneinfo/zone.tab" )    
amarok(12157)/kio (KDirListerCache) KDirListerCache::slotResult: finished 
listing KUrl("file:///home/alan/downloads/music")
amarok(12157)/kio (AccessManager) KDEPrivate::AccessManagerReply::jobDone: 0 -
> QNetworkReply::NoError                     
amarok(12157)/kio (KIOConnection) 
KIO::SocketConnectionBackend::socketReadyRead: 
KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes                                                                                                 
amarok(12157)/kio (KIOConnection) 
KIO::SocketConnectionBackend::socketReadyRead: 
KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes                                                                                                 
amarok(12157)/kio (KIOConnection) 
KIO::SocketConnectionBackend::socketReadyRead: 
KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes                                                                                                 
amarok(12157)/kio (KDirListerCache) KDirListerCache::slotResult: finished 
listing KUrl("trash:/")                          
*** glibc detected *** amarok: free(): invalid pointer: 0x0000000003295080 ***                                             
-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Nagatoro]

On Tuesday 10 November 2009 13.14.13 Alan McKinnon wrote:
[...]
> *** glibc detected *** amarok: free(): invalid pointer: 0x0000000003295080
>  ***

This is a highly debated issue, glibc has new checks for various things and it 
seems like some think the checks are to strict or even wrong while others 
think that the checks are ok and the applications are wrong.

I suffer from the same issue but with KDevelop and Qt-Creator.

Time will tell what side is right and what side is wrong I guess...

/Naga

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Alex Schuster]

Volker Armin Hemmann writes:

> On Dienstag 10 November 2009, Neil Bothwick wrote:
> > On Tue, 10 Nov 2009 11:26:33 +0100, Volker Armin Hemmann wrote:
> > > amarok works great here.
> >
> > Everything works great somewhere, even Windows :P
> 
> seroiously, what does not work great with amarok? it compiles, it
>  installes, it scans my collection, it plays my stuff.

The tag editor trashed my .ogg files. Might also be an effect of some 
vorbis tools, it does not happen any more.
The collection get screwed up, tracks show up with wrong artist.
The scanning process takes incredibly long. When I move an album folder 
into another location, it takes quite a while for amarok to re-scan it. 
And it does not respond during that time. System load gehts rather high, 
even dolphin is slow then.
I have all my audio files in /data/mp3, with many sub-directories I 
included in the collection paths, but amarok seems to scan the whole 
/data/mp3 directory, with folders that are not marked to scan.
When I select a single folder somewhere else and let amarok rescan the 
collection, all the other stuff is still in the collection. At least 
sometimes, I just did that again and now it seems to work.
I had a few crashes also, when moving audio folders.

But I still like it. It looks really nice, I like features like the 
wikipedia information or song texts. The bugs will be solved eventually, 
missing features like transkode integration or visualization will probably 
come. I am patient. Amarok really rocks.

	Wonko

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Alan McKinnon]

On Tuesday 10 November 2009 14:27:26 Volker Armin Hemmann wrote:
> On Dienstag 10 November 2009, you wrote:
> > On Tuesday 10 November 2009 13:34:08 Volker Armin Hemmann wrote:
> > > On Dienstag 10 November 2009, Neil Bothwick wrote:
> > > > On Tue, 10 Nov 2009 11:26:33 +0100, Volker Armin Hemmann wrote:
> > > > > amarok works great here.
> > > >
> > > > Everything works great somewhere, even Windows :P
> > >
> > > seroiously, what does not work great with amarok? it compiles, it
> > >  installes, it scans my collection, it plays my stuff.
> > >
> > > just because you can not use emerge does not mean that others share
> > > your handicap :P
> >
> > amarok consistently crashes here:
> >
> > amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "trash"
> > for KUrl("trash:/")
> > amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote:
> > Listening on
> >  "local:/home/alan/.kde4/socket-nazgul/amarokx12157.slave-socket"
> >  amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "file"
> > for KUrl("file:///home/alan/downloads/music")
> > amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote:
> > Listening on
> >  "local:/home/alan/.kde4/socket-nazgul/amarokN12157.slave-socket"
> >  amarok(12157)/kio (KIOConnection)
> > KIO::ConnectionServer::listenForRemote: Listening on
> >  "local:/home/alan/.kde4/socket-nazgul/amarokm12157.slave-socket"
> >  amarok(12157)/kio (Slave) KIO::Slave::createSlave: createSlave "file"
> > for KUrl("file:///usr/share/apps/amarok/images//info_frontpage_logo.png")
> > amarok(12157)/kio (KIOConnection) KIO::ConnectionServer::listenForRemote:
> > Listening on
> >  "local:/home/alan/.kde4/socket-nazgul/amarokz12157.slave-socket"
> >  amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::instance:
> >  instance(): ... initialised
> > amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readConfig:
> > readConfig(): local zone= "Africa/Johannesburg"
> > amarok(12157)/kdecore (K*TimeZone*) KSystemTimeZonesPrivate::readZoneTab:
> > readZoneTab( "/usr/share/zoneinfo/zone.tab" )
> > amarok(12157)/kio (KDirListerCache) KDirListerCache::slotResult: finished
> > listing KUrl("file:///home/alan/downloads/music")
> > amarok(12157)/kio (AccessManager)
> > KDEPrivate::AccessManagerReply::jobDone: 0 -
> >
> > > QNetworkReply::NoError
> >
> > amarok(12157)/kio (KIOConnection)
> > KIO::SocketConnectionBackend::socketReadyRead:
> > KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes
> > amarok(12157)/kio (KIOConnection)
> > KIO::SocketConnectionBackend::socketReadyRead:
> > KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes
> > amarok(12157)/kio (KIOConnection)
> > KIO::SocketConnectionBackend::socketReadyRead:
> > KIO::SocketConnectionBackend(0x2f0cfd0) Jumbo packet of 308680 bytes
> > amarok(12157)/kio (KDirListerCache) KDirListerCache::slotResult: finished
> > listing KUrl("trash:/")
> > *** glibc detected *** amarok: free(): invalid pointer:
> > 0x0000000003295080 ***
> 
> never had that problem.
> 
> opened a bug with amarok already?

Not yet, I also want to gather more info on these errors too:

amarok:    [ERROR!] GREPME MySQL query failed! No database selected  on  
"DELETE FROM images;"                             

There's a similar error for every single collection query. Which means that my 
collection cannot get indexed. But first I need to establish if it's some out 
of date code issue that revdep-rebuild misses, or perhaps a peculiarity of 
glibc-2.11 as Nagatoro hinted at

-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Erik]

Nagatoro skrev:
> On Tuesday 10 November 2009 13.14.13 Alan McKinnon wrote:
> [...]
>   
>> *** glibc detected *** amarok: free(): invalid pointer: 0x0000000003295080
>>  ***
>>     
>
> This is a highly debated issue, glibc has new checks for various things and it 
> seems like some think the checks are to strict or even wrong while others 
> think that the checks are ok and the applications are wrong.
>   
Really? A pointer is valid for free() if it has been returned by malloc,
calloc, realloc or strdup, and has not yet been passed to free(). What
could there possibly be to debate?

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Walter Dnes]

  Programmers all seem to have gaming rigs.  It's been a struggle to
keep hal and dbus off my machines.  And I was unhappy when Firefox put
SQLite in as a hard dependancy.  I think you'll simply have to give up
on KDE and its applications.

-- 
Walter Dnes <waltdnes@waltdnes.org>

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Volker Armin Hemmann]

On Mittwoch 11 November 2009, Walter Dnes wrote:
>   Programmers all seem to have gaming rigs.  It's been a struggle to
> keep hal and dbus off my machines.  And I was unhappy when Firefox put
> SQLite in as a hard dependancy.  I think you'll simply have to give up
> on KDE and its applications.
> 

hal and dbus have as much as zero performance impact. And dbus also replaces 
dcop. So there there is a system less running.
mysql embedded is also a very low load.

Re: [gentoo-user] Has mysql become compulsory - Part 2

[Mick]

2009/11/11 Volker Armin Hemmann <volkerarmin@googlemail.com>:
> On Mittwoch 11 November 2009, Walter Dnes wrote:
>>   Programmers all seem to have gaming rigs.  It's been a struggle to
>> keep hal and dbus off my machines.  And I was unhappy when Firefox put
>> SQLite in as a hard dependancy.  I think you'll simply have to give up
>> on KDE and its applications.
>>
>
> hal and dbus have as much as zero performance impact. And dbus also replaces
> dcop. So there there is a system less running.
> mysql embedded is also a very low load.

In an ideal world we would have a light version and a heavy/full
featured version of everything.  However, in reality people develop
what they need/fancy and hardware technology advances - so we have to
find workarounds and make compromises.

KDE used to be more light-footed than Gnome, so I invariably used most
of its applications on my ancient hardware.  It seems that with KDE4
this is becoming increasingly less so.

I've been running this PIII laptop for the last 11 years (wow!!!
doesn't time fly) and it has become increasingly sluggish because most
packages are designed for modern machines which are of course more
powerful.  It is only reasonable that building some of today's apps
for a Pentium 1 or Pentium 2 is not going to work particularly well
... so I'll be breaking the piggy bank and buying something more up to
date any day now.  That should hopefully keep the noise down.
-- 
Regards,
Mick