I got this error when i executed admin/InitDB.pl: DBI connect('dbname=template1','postgres',...) failed: FATAL: role "postgres" does not exist at /home/ubuntu/perl5/lib/perl5/DBIx/Connector.pm line 32.
2014-08-28 24002, 2014
yanggao
did I neglect something? since I never specified dbname as template1 and role as postgres; did I forget to change something?
2014-08-28 24001, 2014
ianmcorvidae
that's for the system user/superuser, which is needed for some parts of the database setup
2014-08-28 24006, 2014
ianmcorvidae
it's the SYSTEM key in DBDefs
2014-08-28 24027, 2014
yanggao
what should I do, ian?
2014-08-28 24056, 2014
ianmcorvidae
figure out what the issue is, probably :) I don't know why your system wouldn't have a postgres user, so you'll need to figure out what the superuser name is and then update the configuration
2014-08-28 24014, 2014
LordSputnik
yanggao: I had this issue the other day, let me see if I can remember for you
2014-08-28 24032, 2014
yanggao
thanks!!
2014-08-28 24025, 2014
LordSputnik
I think it was to do with the setup of the database authentication (pg_hba.conf/pg_ident.conf) - I think I got it working by using the "alternative" setup for development purposes (listed below the main authentication setup)
2014-08-28 24002, 2014
ianmcorvidae
that wouldn't tell you it doesn't exist, at worst it'd tell you you don't have access
2014-08-28 24051, 2014
LordSputnik
if I'd wanted to set up the mb server, I would've found a proper solution, but since I only wanted access to the database, I decided to just use the "local all all trust" line
2014-08-28 24017, 2014
yanggao
I removed all lines in “/etc/postgresql/9.3/main/pg_hba.conf”, and inserted this: “/etc/postgresql/9.3/main/pg_hba.conf” as in “Alternatively”
yanggao: how are you running the command? Just "./admin/InitDb.pl --createdb --import ..."? Also, did you restart the database server after you updated the pg_* files ("sudo service postgresql restart")?
2014-08-28 24056, 2014
yanggao
do you mean instead of “./admin/InitDb.pl”, I should use “sudo ./admin/InitDb.pl”?
2014-08-28 24039, 2014
LordSputnik
no, I don't think so... I attempted "sudo -u postgres ./admin/InitDB.pl" a few times, but the last one I ran was just a plain "./admin/InitDB.pl"
2014-08-28 24050, 2014
yanggao
I see.
2014-08-28 24031, 2014
yanggao
LordSputnik: I am using your pg_hba.conf, and restarted server, does not work…
2014-08-28 24017, 2014
LordSputnik
hmm, what does the output of "sudo -u postgres ./admin/InitDB.pl" give you? Is it any different?
2014-08-28 24012, 2014
yanggao
$ sudo -u postgres ./admin/InitDB.pl
2014-08-28 24013, 2014
yanggao
sudo: ./admin/InitDB.pl: command not found
2014-08-28 24050, 2014
LordSputnik
oh sorry, "./admin/InitDb.pl"
2014-08-28 24005, 2014
LordSputnik
I put a B instead of a b
2014-08-28 24025, 2014
yanggao
Can't locate MooseX/Singleton.pm in @INC (you may need to install the MooseX::Singleton module) (@INC contains: /home/ubuntu/tools/musicbrainz-server/admin/../lib /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl .) at /home/ubuntu/tools/musicbrainz-server/admin/../lib/MusicBrainz/Server/Translation.pm line 2.
2014-08-28 24026, 2014
yanggao
BEGIN failed--compilation aborted at /home/ubuntu/tools/musicbrainz-server/admin/../lib/MusicBrainz/Server/Translation.pm line 2.
2014-08-28 24027, 2014
yanggao
Compilation failed in require at /home/ubuntu/tools/musicbrainz-server/admin/../lib/DBDefs/Default.pm line 33.
2014-08-28 24029, 2014
yanggao
BEGIN failed--compilation aborted at /home/ubuntu/tools/musicbrainz-server/admin/../lib/DBDefs/Default.pm line 33.
2014-08-28 24030, 2014
yanggao
Compilation failed in require at /usr/share/perl/5.18/parent.pm line 20.
2014-08-28 24031, 2014
yanggao
BEGIN failed--compilation aborted at /home/ubuntu/tools/musicbrainz-server/admin/../lib/DBDefs.pm line 29.
2014-08-28 24032, 2014
yanggao
Compilation failed in require at ./admin/InitDb.pl line 35.
2014-08-28 24033, 2014
LordSputnik
aha
2014-08-28 24033, 2014
yanggao
BEGIN failed--compilation aborted at ./admin/InitDb.pl line 35.
2014-08-28 24037, 2014
LordSputnik
I also got that
2014-08-28 24043, 2014
ianmcorvidae
yeah, that'll happen when you switch to a different user
2014-08-28 24055, 2014
ianmcorvidae
also, if you're putting a lot of lines in chat, you should be using a pastebin
2014-08-28 24007, 2014
yanggao
I see… thanks.
2014-08-28 24014, 2014
ianmcorvidae
as I said already, permissions are not going to be your problem, you're missing a superuser or have it under a different nabe
2014-08-28 24017, 2014
ianmcorvidae
name*
2014-08-28 24040, 2014
yanggao
could you be more detailed what I should do?
2014-08-28 24010, 2014
LordSputnik
yanggao: following that, I tried installing MooseX::Singleton, but that wasn't the right thing to do
2014-08-28 24029, 2014
yanggao
me either! tried that.
2014-08-28 24030, 2014
LordSputnik
I also checked the dependencies using "cpanm ."
2014-08-28 24033, 2014
ianmcorvidae
LordSputnik: do you just have me ignored? you seem to be fond of saying worthless things that won't be helpful after I've told you they won't
2014-08-28 24006, 2014
yanggao
sorry! that is my fault
2014-08-28 24043, 2014
LordSputnik
ianmcorvidae: all I'm doing is trying to repeat what worked for me
2014-08-28 24059, 2014
LordSputnik
perhaps the manual needs fixing if two users run into the exact same problem less than two weeks apart?
2014-08-28 24056, 2014
ianmcorvidae
apparently it didn't work for you, or you had a different problem, since all of your proposed steps have been obviously wrong
2014-08-28 24057, 2014
ianmcorvidae
the solution here is to figure out what is wrong with your postgresql install, since that's the issue. possibly some distribution is doing something destructive with their postgres package and that's the root of it -- maybe that warrants adding to the instructions if it can be narrowed to that
I can't give specific recommendations becaus it's specific to whatever's broken about your server, which obviously I can't determine
2014-08-28 24000, 2014
TheCanadianBaker
Hey guys
2014-08-28 24024, 2014
TheCanadianBaker
I just upgraded to the dev 1.3 from 1.2
2014-08-28 24028, 2014
TheCanadianBaker
and HOLY SHIT
2014-08-28 24033, 2014
TheCanadianBaker
It is fast, and slick
2014-08-28 24044, 2014
TheCanadianBaker
You guys are doing awesome!
2014-08-28 24051, 2014
TheCanadianBaker
Thank you for all your hard work
2014-08-28 24052, 2014
bitmap
glad to hear that, it's a nice departure from the angry support emails we normally get XD
2014-08-28 24059, 2014
TheCanadianBaker
Well, some people are just dumb
2014-08-28 24011, 2014
TheCanadianBaker
:p
2014-08-28 24037, 2014
LordSputnik has left the channel
2014-08-28 24035, 2014
yanggao
Thanks ian. It makes a lot of sense.
2014-08-28 24029, 2014
Lotheric joined the channel
2014-08-28 24002, 2014
TheCanadianBaker has left the channel
2014-08-28 24050, 2014
Cuan joined the channel
2014-08-28 24021, 2014
CallerNo6 joined the channel
2014-08-28 24031, 2014
CallerNo6 joined the channel
2014-08-28 24050, 2014
ohrstrom joined the channel
2014-08-28 24033, 2014
nikki joined the channel
2014-08-28 24047, 2014
Gentlecat joined the channel
2014-08-28 24019, 2014
ijabz joined the channel
2014-08-28 24051, 2014
nikki joined the channel
2014-08-28 24002, 2014
Mineo
TIL that using abbreviations as project names only makes sense if you actually write down their meaning somewhere <.<
2014-08-28 24006, 2014
ianmcorvidae
heh, which one? :P
2014-08-28 24057, 2014
ruaok joined the channel
2014-08-28 24053, 2014
Mineo
I had started to write some code a few months ago to generate one of those top 10 albums lists on last.fm, just with images from the CAA
2014-08-28 24015, 2014
Mineo
turns out it's not obvious that "dhis" means "das hör ich so" :P
2014-08-28 24027, 2014
ianmcorvidae
haha
2014-08-28 24029, 2014
ianmcorvidae
anyway cool
2014-08-28 24050, 2014
Gentlecat
ruaok: getting visa wasn't so hard after all :)
2014-08-28 24014, 2014
ruaok
wow, good.
2014-08-28 24018, 2014
ruaok
glad to hear it.
2014-08-28 24047, 2014
Gentlecat
probably because we are too far from all the action
2014-08-28 24033, 2014
Gentlecat
is it possible in CAA for some release group or release to have multiple images with the same type?
2014-08-28 24052, 2014
ianmcorvidae
release groups always have exactly one image and it's always a front
2014-08-28 24006, 2014
ianmcorvidae
releases can have multiple images of the same type, however
2014-08-28 24041, 2014
ianmcorvidae
(the release group image is really just a pointer to a release to use the so-called "frontiest" image (i.e. the one marked Front closest to the front of the list) from)
2014-08-28 24050, 2014
Gentlecat
okay, thanks
2014-08-28 24023, 2014
demonimin joined the channel
2014-08-28 24043, 2014
TheCanadianBaker joined the channel
2014-08-28 24011, 2014
TheCanadianBaker
Hey, to anyone on the picard team
2014-08-28 24005, 2014
TheCanadianBaker
I have been running some large collections through 1.3, and I have noticed that if there are a large group of files selected while saving it seems to go much slower
2014-08-28 24037, 2014
TheCanadianBaker
I would assume this is because it is updating the Original and New panes, but I can't be sure
2014-08-28 24020, 2014
TheCanadianBaker
However, when I deselect the tracks being saved, and select a single release, track or even a group that isnt being saved, this behaviour does not occur
2014-08-28 24007, 2014
TheCanadianBaker
Just though I would through it out there... Maybe try suspending the updates on save and see if there is a significant performance gain
2014-08-28 24021, 2014
TheCanadianBaker
or if I am just crazy :p
2014-08-28 24035, 2014
TheCanadianBaker
Thank you guys for all your hard work (all of the teams)
hello there… there is a multiple barcodes ticket assigned to Sean Burke, it was decided long tim ago to deploy this change but it seems the assignee is no longer active in MB, is he ? should the tickets (2) be re-assigned ?
oh but i gues iít taken care ò usually when someone “leaves”, the tickets are páed…
2014-08-28 24031, 2014
reosarevok
Well Leftmost is still around :p
2014-08-28 24039, 2014
reosarevok
But I don't know if he's planning to write that
2014-08-28 24011, 2014
jesus2099
leftmost ! ok great that rings a bell, i didn’t know his real name was S.B. :)
2014-08-28 24052, 2014
ijabz joined the channel
2014-08-28 24007, 2014
CatQuest joined the channel
2014-08-28 24046, 2014
Guest86471 joined the channel
2014-08-28 24035, 2014
jesus2099 joined the channel
2014-08-28 24042, 2014
jesus2099_ joined the channel
2014-08-28 24027, 2014
jesus2099_
it’s me again… we have a track entity with an editsPending property and an associated recording entity with a editsPending… as far as i know, only recordings can have pending edits, am I right ?
2014-08-28 24050, 2014
jesus2099_
only releases and recordings… how can a track have pending edits ?
