From: Jarkko Hietaniemi Date: 19:56 on 10 Jan 2008 Subject: my(sql) setup agony Why is installing mysql the fun equivalent of picking a zit in your back? It shouldn't be there, you need to do it because it hurts like a damn, but you can't quite reach it, and you fail in mysterious ways, and shouldn't science have progressed far enough by now to now to have to do it? I installed MediaWiki to my Mac last night since I want to try writing something that quite well fits the wiki hyperlinkage model, and I sure as hell don't want to write raw HTML this day and age... I found this: http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X Notice the roughly 27 easy steps of installing mysql. I don't think it's that mysql in OS X in particular, from my past (unfortunately forgotten by now) experience in other UNIXes it was equally painful. Why do I *always* have to disable remote and local (myql) root access and setup passwords? Storing the access rights of a database *IN THE DATABASE*? Please, just shoot me.
From: Gerry Lawrence Date: 20:13 on 10 Jan 2008 Subject: Re: my(sql) setup agony http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X Um, that doesn't seem so bad. Try oracle. No really. I didn't know how much I loved Mysql until I had to work on oracle.... On a *nix system, prebuilt mysql (RPM or otherwise) is a piece of cake. Even compiling from scratch source is not so bad, and in some ways easier. Initial database setup? run the script, you're done. Config changes? -- edit my.cnf -- obvious and easy. Meanwhile in Oracle land... doom, doom, doom.... doomy-doom doom doom. I thought about the pain I'd be in if there was an emergency system failure on our oracle database -- so I automated the oracle install (via kickstart)..... Jarkko Hietaniemi wrote: > Why is installing mysql the fun equivalent of picking a zit in your back? > It shouldn't be there, you need to do it because it hurts like a damn, > but you can't quite reach it, and you fail in mysterious ways, and shouldn't > science have progressed far enough by now to now to have to do it? > > I installed MediaWiki to my Mac last night since I want to try writing something > that quite well fits the wiki hyperlinkage model, and I sure as hell > don't want to > write raw HTML this day and age... I found this: > > http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X > > Notice the roughly 27 easy steps of installing mysql. > > I don't think it's that mysql in OS X in particular, from my past (unfortunately > forgotten by now) experience in other UNIXes it was equally painful. Why do I > *always* have to disable remote and local (myql) root access and setup > passwords? > Storing the access rights of a database *IN THE DATABASE*? Please, > just shoot me. > >
From: H.Merijn Brand Date: 21:03 on 10 Jan 2008 Subject: Re: my(sql) setup agony On Thu, 10 Jan 2008 15:13:23 -0500, Gerry Lawrence <gwlperl@xxxxx.xxx> wrote: > http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X > > > Um, that doesn't seem so bad. > > Try oracle. No really. I didn't know how much I loved Mysql until I > had to work on oracle.... Without X11?
From: Roger Burton West Date: 21:11 on 10 Jan 2008 Subject: Re: my(sql) setup agony On Thu, Jan 10, 2008 at 10:03:46PM +0100, H.Merijn Brand wrote: >On Thu, 10 Jan 2008 15:13:23 -0500, Gerry Lawrence <gwlperl@xxxxx.xxx> wrote: >> Try oracle. No really. I didn't know how much I loved Mysql until I >> had to work on oracle.... >Without X11? Last time I had anything to do with it, Oracle would run quite happily without X11. Its installer was another matter. R
From: H.Merijn Brand Date: 07:13 on 11 Jan 2008 Subject: Re: my(sql) setup agony On Thu, 10 Jan 2008 21:11:38 +0000, Roger Burton West <roger@xxxxxxxxx.xxx> wrote: > On Thu, Jan 10, 2008 at 10:03:46PM +0100, H.Merijn Brand wrote: > >On Thu, 10 Jan 2008 15:13:23 -0500, Gerry Lawrence <gwlperl@xxxxx.xxx> wrote: > >> Try oracle. No really. I didn't know how much I loved Mysql until I > >> had to work on oracle.... > >Without X11? > > Last time I had anything to do with it, Oracle would run quite happily > without X11. So you left Oracle after Oracle 8? A wise decision. > Its installer was another matter.
From: Gerry Lawrence Date: 21:19 on 10 Jan 2008 Subject: Re: my(sql) setup agony H.Merijn Brand wrote: > On Thu, 10 Jan 2008 15:13:23 -0500, Gerry Lawrence <gwlperl@xxxxx.xxx> wrote: > > >> http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X >> >> >> Um, that doesn't seem so bad. >> >> Try oracle. No really. I didn't know how much I loved Mysql until I >> had to work on oracle.... >> > > Without X11? Heh heh -- why would you not have X11? Oh, sorry. Yes indeed, the oracle installer requires X11. Even if you automate the install with a response file, the installer never makes an X11 connection, but it won't run without an X11 server. hateful, hateful. So the trick (that I discovered) is to run the frame buffer X server (xvfb) as a "fake" server, and then the installer can run. But that's just the beginning of your problems if you're trying to do this via kickstart....
From: Jarkko Hietaniemi Date: 20:24 on 10 Jan 2008 Subject: Re: my(sql) setup agony > but you can't quite reach it, and you fail in mysterious ways, and shouldn't > science have progressed far enough by now to now to have to do it? ... by now to not to have to do it. Sorry but my pain made me mistype.
From: Rory McCann Date: 09:48 on 11 Jan 2008 Subject: Re: my(sql) setup agony Jarkko Hietaniemi wrote: > Why is installing mysql the fun equivalent of picking a zit in your back? > It shouldn't be there, you need to do it because it hurts like a damn, > but you can't quite reach it, and you fail in mysterious ways, and shouldn't > science have progressed far enough by now to now to have to do it? > > I installed MediaWiki to my Mac last night since I want to try writing something > that quite well fits the wiki hyperlinkage model, and I sure as hell > don't want to > write raw HTML this day and age... I found this: > > http://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Mac_OS_X > > Notice the roughly 27 easy steps of installing mysql. > > I don't think it's that mysql in OS X in particular, from my past (unfortunately > forgotten by now) experience in other UNIXes it was equally painful. Why do I > *always* have to disable remote and local (myql) root access and setup > passwords? > Storing the access rights of a database *IN THE DATABASE*? Please, > just shoot me. > > See also: http://diveintomark.org/archives/2007/11/11/installing-mysql-on-ubuntu Rory McCann
Generated at 10:26 on 16 Apr 2008 by mariachi