-
nikki_
heh, I hate postgres and ident auth
2006-02-02 03356, 2006
-
nikki_
it never works as I want it to
2006-02-02 03316, 2006
-
yalaforge joined the channel
2006-02-02 03326, 2006
-
nikki_
2006-02-02 03329, 2006
-
nikki_
hi yalaforge!
2006-02-02 03335, 2006
-
yalaforge
tach
2006-02-02 03336, 2006
-
enjayhch
I am doing a fresh install on Debian/sarge
2006-02-02 03344, 2006
-
nikki_
wie gehts?
2006-02-02 03355, 2006
-
yalaforge
gut, danke. und selbst?
2006-02-02 03324, 2006
-
nikki_
painful :(
2006-02-02 03335, 2006
-
yalaforge
oh?
2006-02-02 03347, 2006
-
nikki_
dentist gave me toothache :/
2006-02-02 03302, 2006
-
GURT
i hope you didn't pay him
2006-02-02 03303, 2006
-
yalaforge
armes mädchen!
2006-02-02 03320, 2006
-
GURT
or her
2006-02-02 03322, 2006
-
nikki_
jaaa. :(
2006-02-02 03327, 2006
-
yalaforge can't remember when was at the dentist's for the last time
2006-02-02 03329, 2006
-
nikki_
GURT: no, and him
2006-02-02 03330, 2006
-
ruaok
grrrr. I hate fucking rude peope.
2006-02-02 03350, 2006
-
Shepard
ruaok: you asshat :)
2006-02-02 03354, 2006
-
mustaqil_
Yeah, fucking damn all those little shits to hell for being so goddamned fucking rude and cuntish by swearing
2006-02-02 03308, 2006
-
ruaok
esp when they have a rude spam bot that auto replies when they try to confirm their email.
2006-02-02 03318, 2006
-
ruaok
I hope that person didn't need their MB account anymore.
2006-02-02 03340, 2006
-
mustaqil_
"Fuck off and stop emailing me, I've gone to take a shit" <-- An auto response like that? ;)
2006-02-02 03340, 2006
-
ruaok
moin yalaforge
2006-02-02 03345, 2006
-
yalaforge
moin mr overlord, sir ;-)
2006-02-02 03325, 2006
-
ruaok
mustaqil, yes. "Stop spamming me" was the actual text.
2006-02-02 03340, 2006
-
mustaqil_
: o Oh my, that's faaaar worse!
2006-02-02 03310, 2006
-
ruaok
nikki_: yes
2006-02-02 03349, 2006
-
yalaforge
how far did you get with the embeddable html search, btw?
2006-02-02 03328, 2006
-
nikki_
me?
2006-02-02 03339, 2006
-
yalaforge
if you know something about it, yes :-)
2006-02-02 03332, 2006
-
nikki_
I don't know what to put on the submit button :o
2006-02-02 03345, 2006
-
ruaok
Search!
2006-02-02 03347, 2006
-
yalaforge
"Search"?
2006-02-02 03311, 2006
-
yalaforge thinks a form with an id attribute would be enough anyway
2006-02-02 03313, 2006
-
nikki_ looks for the file...
2006-02-02 03323, 2006
-
yalaforge
people can do their own layouting with css if they want to
2006-02-02 03340, 2006
-
nikki_
bah, this is what happens when I clean up my ~
2006-02-02 03348, 2006
-
yalaforge
:-)
2006-02-02 03316, 2006
-
enjayhch
IDENT authentication failed for user "musicbrainz_user" at /home/mbserver/cvs/mb_server/cgi-bin/MusicBrainz.pm
2006-02-02 03319, 2006
-
nikki_
hmm, I wonder how Shepard and chocomo are getting on...
2006-02-02 03321, 2006
-
enjayhch
what do I do?
2006-02-02 03327, 2006
-
nikki_
enjayhch: I switched to using passwords
2006-02-02 03343, 2006
-
enjayhch
which was an easy change?
2006-02-02 03349, 2006
-
nikki_
hmm.
2006-02-02 03303, 2006
-
yalaforge
enjayhch: did you follow the instructions in mb_server's INSTALL?
2006-02-02 03306, 2006
-
enjayhch
don't want to change tooo much from CVS
2006-02-02 03313, 2006
-
nikki_
ah
2006-02-02 03320, 2006
-
enjayhch
2006-02-02 03343, 2006
-
nikki_
I just edited the pg_hba.conf or whatever it is and DBDefs.pm
2006-02-02 03302, 2006
-
yalaforge
enjayhch: try INSTALL, forget the wiki for now
2006-02-02 03314, 2006
-
yalaforge
and don't forget, order matters in pg_hba.conf
2006-02-02 03318, 2006
-
enjayhch
ok
2006-02-02 03339, 2006
-
enjayhch
so it should be at the top?
2006-02-02 03348, 2006
-
enjayhch
(of that section)
2006-02-02 03315, 2006
-
yalaforge
if there's nothing critical in your file then put it on pastebin or somewhere
2006-02-02 03353, 2006
-
yalaforge
is your postgres install fresh?
2006-02-02 03359, 2006
-
enjayhch
yup
2006-02-02 03306, 2006
-
yalaforge
local all postgres ident sameuser
2006-02-02 03309, 2006
-
yalaforge
you have this line?
2006-02-02 03323, 2006
-
enjayhch
nope
2006-02-02 03329, 2006
-
enjayhch
local all postgres ident localmap
2006-02-02 03345, 2006
-
yalaforge
hmmm, ok. doesn't matter.
2006-02-02 03352, 2006
-
yalaforge
after this line, you can put this:
2006-02-02 03358, 2006
-
yalaforge
local musicbrainz_db musicbrainz_user ident mb_map
2006-02-02 03318, 2006
-
yalaforge
and in pg_ident.conf:
2006-02-02 03319, 2006
-
enjayhch
got that
2006-02-02 03343, 2006
-
yalaforge
directly after the other line?
2006-02-02 03301, 2006
-
enjayhch
yup
2006-02-02 03309, 2006
-
yalaforge
ok. then in pg_ident.conf:
2006-02-02 03316, 2006
-
yalaforge
mb_map postgres musicbrainz_user
2006-02-02 03356, 2006
-
yalaforge
hmm, wait :-)
2006-02-02 03316, 2006
-
yalaforge
mb_map www-user musicbrainz_user
2006-02-02 03347, 2006
-
yalaforge
"www-user" is the OS username which is going to access the database
2006-02-02 03359, 2006
-
enjayhch
www-data on Debain?
2006-02-02 03306, 2006
-
yalaforge
yup
2006-02-02 03315, 2006
-
yalaforge
do you have this account?
2006-02-02 03328, 2006
-
enjayhch
yup
2006-02-02 03331, 2006
-
yalaforge
ok
2006-02-02 03336, 2006
-
enjayhch
and apache-perl is configured to use it
2006-02-02 03354, 2006
-
enjayhch
well it still doesn't work
2006-02-02 03355, 2006
-
yalaforge
so, if you changed the postgres config files, you have to reload postgres
2006-02-02 03322, 2006
-
enjayhch
done that lots :)
2006-02-02 03337, 2006
-
yalaforge
ok. then log in as www-data.
2006-02-02 03352, 2006
-
enjayhch
su - www-data
2006-02-02 03355, 2006
-
yalaforge
try "psql musicbrainz_db musicbrainz_user"
2006-02-02 03357, 2006
-
yalaforge
yup
2006-02-02 03316, 2006
-
enjayhch
yup - that works
2006-02-02 03333, 2006
-
yalaforge
try "SELECT * FROM artist WHERE id = 60;"
2006-02-02 03353, 2006
-
enjayhch
yup, that works - only I don't have any data yet
2006-02-02 03320, 2006
-
enjayhch
so what is apache doing wrong? :(
2006-02-02 03321, 2006
-
yalaforge
that shouldn't matter. mb_server should be able to access your DB
2006-02-02 03332, 2006
-
nikki_
2006-02-02 03339, 2006
-
yalaforge
wait a minute, what's in mb_server/cgi-bin/DBDefs.pm?
2006-02-02 03309, 2006
-
ruaok
nikki_: yes
2006-02-02 03342, 2006
-
enjayhch
yalaforge: what section?
2006-02-02 03348, 2006
-
Shepard
<nikki_> hmm, I wonder how Shepard and chocomo are getting on... <- with the search thingy?
2006-02-02 03354, 2006
-
nikki_
ja
2006-02-02 03354, 2006
-
yalaforge
enjayhch: "The Database"
2006-02-02 03346, 2006
-
yalaforge
enjayhch: you have to make sure apache really runs as user www-data
2006-02-02 03348, 2006
-
Shepard
2006-02-02 03351, 2006
-
Shepard
mo wanted
2006-02-02 03305, 2006
-
nikki_
ah
2006-02-02 03314, 2006
-
enjayhch
yalaforge: is it possible it is still running as root while it is starting up?
2006-02-02 03337, 2006
-
yalaforge
yes, but it should change its user id to www-data
2006-02-02 03305, 2006
-
yalaforge
check your httpd.conf, you should be able to configure a user account there
2006-02-02 03320, 2006
-
enjayhch
Group www-data
2006-02-02 03332, 2006
-
yalaforge
hmm, that's correct :-/
2006-02-02 03301, 2006
-
yalaforge
we checked www-data can access the db.
2006-02-02 03324, 2006
-
yalaforge
run apache without mb_server and find out which user account it uses
2006-02-02 03339, 2006
-
yalaforge is out of ideas, to be honest
2006-02-02 03341, 2006
-
yalaforge
did you create an mbserver user, as per instructions on that wiki page?
2006-02-02 03351, 2006
-
enjayhch
yup
2006-02-02 03310, 2006
-
yalaforge
if we solve this problem, the mbserver user will be the next one :-)
2006-02-02 03319, 2006
-
enjayhch
woooot - it just works
2006-02-02 03321, 2006
-
enjayhch
ed
2006-02-02 03343, 2006
-
enjayhch
I added to pg_indent.conf:
2006-02-02 03344, 2006
-
enjayhch
mb_map root musicbrainz_user
2006-02-02 03358, 2006
-
yalaforge
eeek.
2006-02-02 03317, 2006
-
yalaforge
apache runs MB code with root privs. great
2006-02-02 03346, 2006
-
enjayhch
but ps xau shows that it is now running as www-data
2006-02-02 03307, 2006
-
yalaforge
yeah. I think I remember this problem, but not how I solved it
2006-02-02 03321, 2006
-
enjayhch
heh
2006-02-02 03330, 2006
-
yalaforge
anyway, the mbserver user problem:
2006-02-02 03344, 2006
-
yalaforge
you need several directories for mb_server to keep sessions etc.
2006-02-02 03300, 2006
-
yalaforge
they all have to be owned by www-data, not mbserver.
2006-02-02 03311, 2006
-
enjayhch
ok, yup
2006-02-02 03343, 2006
-
yalaforge
good, then that's it.
2006-02-02 03307, 2006
-
LTjake has quit
2006-02-02 03320, 2006
-
enjayhch
thank you for your help yalaforge :)
2006-02-02 03330, 2006
-
yalaforge
np, good luck :-)
2006-02-02 03350, 2006
-
enjayhch
now I just need to try and persuade the university to open up the firewall
2006-02-02 03303, 2006
-
enjayhch
not sure if my machine will cope as a public mirror or not though...
2006-02-02 03334, 2006
-
nikki_
how do I stop trac from converting underscores to underlined text?
2006-02-02 03353, 2006
-
nikki_
slap me if I get a bit too wontfix-happy.
2006-02-02 03319, 2006
-
ruaok
keep it up. :)
2006-02-02 03301, 2006
-
nikki_ grins
2006-02-02 03309, 2006
-
nikki_
down to 42 open for mbtagger
2006-02-02 03310, 2006
-
luks
nikki_: use ! before the underscore
2006-02-02 03318, 2006
-
nikki_
before every one?
2006-02-02 03332, 2006
-
luks
i guess only the first one
2006-02-02 03336, 2006
-
nikki_
ahh, yup
2006-02-02 03359, 2006
-
ruaok
I guess I have 42 more mails to look for then?
2006-02-02 03311, 2006
-
nikki_ chuckles
2006-02-02 03320, 2006
-
nikki_
39 now
2006-02-02 03350, 2006
-
nikki_
do you get an email for every change?
2006-02-02 03315, 2006
-
ruaok
if the bug was assigned to me, yes.
2006-02-02 03321, 2006
-
nikki_
ahh
2006-02-02 03323, 2006
-
ruaok
"stop spamming me!"
