#musicbrainz-devel

ruaok: hey. wondering if you have aggregate useragent stats yet?

I was working on that earlier.

a few more hours and I have something that will satisfy me.

so it's like

ask me later in the week.

sweet. I'll hit you up some time

if you follow the artist, what do you do?

check the weekly upload for data from them?

no, in this case, I can forward all the data we've received from the label.

but the case you describe relates to new releases?

which, in theory constitues all the releases they care about going into MB>

like that's what we most want to cover, no?

yeah.

and a general look and see if you spot general untidyness.

like I said I am learning to not volunteer for things

but am bummed out, because awesome project.

:)

yeah, NT has been a long time fave of mine.

I need some help. I have been trying desperately to install a mb slave server and everytime I run the 'carton exec -- ./admin/Init.Db.pl --createdb --import tmp/dump/mbdump*.tar.bz2 --echo' command I get the error saying 'DBI connect('dbname=emplate1','postgres',...) failed: could not connect to server: No such file or directory'

I'm about to chuck my computer in the nearest river. This is driving me crazy!!!

that's strange, your 'template1' is missing a 't'

that was my mistype on the irc message

the message suggests the database server isn't running, or misconfigured

so, you have the postgres server running, and can connect via psql as the 'postgres' user?

you can test that with 'psql', so yeah -- 'psql -U postgres template1' -- if that doesn't work then the database server may need to be started or reconfigured

kepstin-laptop: yes I can connect just fine

ianmcorvidae: I can connect with that command. I've tried removing postgresql postgresql-server and any postgresql related program/service and reinstalling

and I still get the same error.

from the musicbrainz-server folder, try: carton exec -- ./admin/psql SYSTEM

(should be the same error, but just confirming)

ianmcorvidae: when i use that command it gives me the exact same result as 'psql -U postgres template1'

no error

hmm. how are postgres connections on the local machine done? are they a unix namespace or filesystem socket?

it's a filesystem socket, usually in /tmp

okay, /admin/psql calls out to regular psql, but it does at least mean it's creating the right shell arguments

it could be that the perl library is linked to the wrong libpg, and is getting the wrong socket name

yeah, that's possible, I guess

how would I change which libpg it is linked to?

it is possible, since I had 8.4 installed the very first time before install 9.1, but I installed everything and reinstalled 9.1

how did you install the perl modules?

it'd be the perl module, installed by carton (though the fact you're using carton is also a bit outdated, but oh well)

disregard that last comment, I'm a retartd and was talking about postgresql

hmm? we were talking about postgresql too :)

(libpq is a part of postgresql)

I installed the perl modules with carton per the instructions in the musicbrainz install file.

man, I really should get myself a musicbrainz server set up again... I have no on-hand reference to check stuff

well if libpq is part of postgresql then my comment still stands. :)

did you either remove or deliberately reinstall DBIx::Connector after upgrading from 8.4 to 9.1?

(also, the main install file hasn't recommended carton in months, that's what I meant about carton being a bit weird)

it is possible i removed it. I definitely did not reinstall it.

do: rm -r local/lib/perl5/DBIx/; carton install DBIx::Connector

though, hm. not sure what DBIx::Connector::Driver::Pg is using to connect

if you feel like doing something kind of clever, try running "strace psql -U postgres template1 </dev/null 2>&1 | grep connect"

ianmcorvidae: I just ran that and still receive the same error.

(on my test ubuntu 12.04 system with postgres 9.1, I get connect(3, {sa_family=AF_FILE, path="/var/run/postgresql/.s.PGSQL.5432"}, 110) = 0)

on my machine I get connect(4, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110 = -1 ENOENT (No such file or directory)

you can ignore the nscd stuff

irrelevant

in that case, I get the same as you

Also for InitDB?

when I run the strace on the initDB command, I get no result at all

hmm. now try "strace carton exec -- ./admin/Init.Db.pl --createdb --import tmp/dump/mbdump*.tar.bz2 2>&1 | grep connect" I suppose

I get nothing.

not sure if that'll work, since the carton command does some forking. hmm.

you can try with "strace -f"

itshim: more modules to delete/reinstall to try: rm -r local/lib/perl5/*/DBD; carton install DBD::Pg;

I'm guessing DBD::Pg is what would have the incorrect linked version, so

(I put * because it depends on your kernel; on my system it's x86_64-linux-gnu-thread-multi

)

itshim: are you sure that that's the *exact same path* "/var/run/postgresql/.s.PGSQL.5432" as you got in the psql trace?

hmm. I wonder if it could be a directory permissions issue

take a look at an 'ls -ld /var/run/postgresql/.s.PGSQL.5432 /var/run/postgresql'; the output should be like https://dpaste.de/WDLn/raw

kepstin-laptop: I get exactly that

... this makes no sense at all.

that's why I said I going to chuck it in the river!

you're running these commands all as the 'musicbrainz' user, right?

you also don't have something like two terminals sshed into two different machines, right? :)

kepstin-laptop: I am sshed into one machine then sshed in to a tmux session on another machine. what what have to do with anything? all the commands are being ran on the machine with musicbrainz server

ianmcorvidae: I deleted and reinstalled those, with no progress :(

itshim: it's just that I've been occasionally confused because I had terminals where ( thought commands were running on the same machine, but they actually weren't ;)

I just can't figure out why it can't connect to the darn database

database server*

kepstin-laptop: if you think of anything else, just ping me.

itshim: I'm all out of ideas, that makes no sense :/

ianmcorvidae: same to you. I'm stuck and don't know where to go.

kepstin-laptop: I'm glad to see we joined the same party now. ;)

itshim: to be honest, I'd probably reformat the machine and start again (following current install instructions)

kepstin-laptop: I was trying to avoid that one, but it may come down to it...

huh, amon tobin is with them? I think at some point I'd actually edited an amon tobin release once.

yeah. he was on emusic back when I worked for them.

how are we linking the ninjatune page to the artist? "biography"?

I see a few have been linked with "official home page" but that doesn't seem right

bio makes sense to me. label pages are not official home pages imho

discography page could be appropriate too

yeah, I'm also good with that

I use "biography"

for those kind of things

it's not technically wrong to use both, I think ;)

hmm. the reason I didn't use 'official homepage' is that the artist already has one of those. A label-page AR makes sense to me.

Picard devs, help welcome on http://tickets.musicbrainz.org/browse/PICARD-592