createuser: could not connect to database postgres: FATAL: role "xbmc" does not exist
2012-08-17 23042, 2012
Orcie
xbmc is my linux user
2012-08-17 23044, 2012
Orcie
ubuntu..
2012-08-17 23042, 2012
ianmcorvidae
-U postgres
2012-08-17 23004, 2012
ianmcorvidae
psql/createuser/etc. connect as the role by the same name as your system user when not told otherwise
2012-08-17 23005, 2012
Orcie
ianmcorvidae: with what cmd?
2012-08-17 23022, 2012
ianmcorvidae
any of them provided by postgres, they're very consistent about their command line flags
2012-08-17 23037, 2012
ianmcorvidae
presumably in this case for createuser
2012-08-17 23050, 2012
Orcie
ianmcorvidae: sorry I dont get it :)
2012-08-17 23049, 2012
Mineo
oh, luks and bitmap are both here: is there a planned release date for picard "bring-back-some-menus-for-german-users" 1.0.1?:)
2012-08-17 23022, 2012
ianmcorvidae
Orcie: http://www.postgresql.org/docs/9.1/static/referen… if you're running any of those commands, pass -U <some valid postgresql role name> or it will use the name of your system user (in your case, xmbc)
2012-08-17 23046, 2012
ianmcorvidae
the error message you pasted was saying 'createuser:' so I assume that's what you were running
2012-08-17 23018, 2012
Orcie
yup
2012-08-17 23031, 2012
Orcie
I am just confused by how the different users connect
2012-08-17 23044, 2012
Orcie
there is a linux user and a postgresql user
2012-08-17 23049, 2012
ianmcorvidae
yes
2012-08-17 23002, 2012
ianmcorvidae
by default postgresql assumes you want the postgresql user with the same name as your linux user -- but they are separate users
2012-08-17 23003, 2012
Orcie
what would be a good setup here
2012-08-17 23014, 2012
Orcie
ok
2012-08-17 23029, 2012
Orcie
so in this case I was trying to make a musicbrainz user
2012-08-17 23038, 2012
Orcie
then the linux user should be musicbrainz aswell?
2012-08-17 23045, 2012
djce joined the channel
2012-08-17 23053, 2012
ocharles
good morning
2012-08-17 23020, 2012
ianmcorvidae
I don't know what convenience features mbslave provides; I know the perl server will create the user for you and you can just use a different command to get direct access that passes the user for you
2012-08-17 23046, 2012
ianmcorvidae
these questions are all yours to answer, in any case, dependent on what you're looking for
2012-08-17 23015, 2012
ianmcorvidae
you probably just need to learn how postgres works, which is something you should read the documentation for rather than limping along here :)
2012-08-17 23018, 2012
Orcie
I just want to query the database
2012-08-17 23029, 2012
Orcie
ianmcorvidae: figures...
2012-08-17 23038, 2012
ianmcorvidae
or presumably mbslave has instructions, so just follow them
2012-08-17 23028, 2012
ianmcorvidae
yeah, look at the mbslave README, it has a list of commands to follow
2012-08-17 23029, 2012
bitmap
Mineo: no, sadly…I forgot hack weekend is today so maybe next weekend? luks does 99.9% of the release process, so as long as he's not busy
2012-08-17 23051, 2012
ianmcorvidae
bitmap: still got 9.5 hours until the opening meeting!
2012-08-17 23021, 2012
bitmap
uh-oh, that's just enough time to sleep :P
2012-08-17 23028, 2012
ianmcorvidae
oh, heh, that :P
2012-08-17 23009, 2012
ianmcorvidae
meh, I still don't know what I even want to do :P
2012-08-17 23054, 2012
bitmap
afaik I was going to integrate ruaok's rss stuff into picard, but we'll see
2012-08-17 23016, 2012
ianmcorvidae
huh, by maintaining a database of when files were last updated, or just writing last-updated stuff to tags?
2012-08-17 23059, 2012
nikki totally wishes picard had a database of what else she has so it would be able to figure out if she needs to disambiguate two releases
2012-08-17 23006, 2012
warp
ianmcorvidae: make a rename folder feature for picard for me!
2012-08-17 23052, 2012
ianmcorvidae
warp: rename folder?
2012-08-17 23031, 2012
bitmap
ianmcorvidae: I was thinking writing it to tags, but keeping a small database has some advantages
2012-08-17 23004, 2012
bitmap
and disadvantages :)
2012-08-17 23022, 2012
ianmcorvidae
starting with writing it to tags is probably a good place to go for the hack weekend, I suppose
2012-08-17 23035, 2012
bitmap nods
2012-08-17 23053, 2012
nikki
how will that work?
2012-08-17 23031, 2012
nikki
I would've thought the idea was that you don't need to load files into picard again to find out if they've been updated or not
2012-08-17 23034, 2012
warp
ianmcorvidae: something which renames the folder a release is in according to some format, but doesn't otherwise move it around (nor the files inside of it).
2012-08-17 23040, 2012
nikki
but if the info is in the files, then...
2012-08-17 23039, 2012
Leftmost joined the channel
2012-08-17 23018, 2012
ianmcorvidae
I feel like the idea is you load the files and it'll be like nope no need to query the real WS this hasn't updated
2012-08-17 23015, 2012
ianmcorvidae
i.e. load a file, or hit a button, or whatever you do to trigger it and it'll check the RSS feeds from the file's last-updated date until the present; if nothing relevant's in there, it says "you're good" and doesn't bother hitting the WS
2012-08-17 23032, 2012
ianmcorvidae
and then you cache the RSS stuff so if you load any file that old or newer it doesn't need to hit *anything* to check
2012-08-17 23042, 2012
nikki
ah
2012-08-17 23053, 2012
nikki
although changing tagger script makes that awkward
2012-08-17 23055, 2012
ianmcorvidae
bitmap's ideas may be different, of course, but that's how I'd think about it anyway
2012-08-17 23005, 2012
warp
ianmcorvidae: I have the problem nikki describes. not the problem you're describing. so whatever nikki is referring to seems like a more interesting thing to solve.
2012-08-17 23018, 2012
ianmcorvidae
if your tagger script strips mbids it won't work, I guess, but
2012-08-17 23039, 2012
warp
why would you do that? the whole point of using picard is to get mbids in the files! :D
2012-08-17 23049, 2012
ianmcorvidae
warp: it's pretty common, I don't understand it either :/
2012-08-17 23049, 2012
nikki
ianmcorvidae: I mean right now I have $unset(asin), if I later remove that, my tags no longer match what picard thinks they should be if it loads the data from the real ws
2012-08-17 23002, 2012
ianmcorvidae
ah
2012-08-17 23012, 2012
ianmcorvidae
that's harder, and presumably a case where you'd just need to retag everything then
2012-08-17 23035, 2012
nikki
or cache the ws data so you can compare it without actually requesting it
2012-08-17 23028, 2012
ianmcorvidae
I feel like fully caching all the WS calls picard makes is mostly just a really good way to use up disk space :P
2012-08-17 23008, 2012
nikki
maybe, maybe not :P
2012-08-17 23021, 2012
ianmcorvidae
though it would allow picard to calculate etags for webservice stuff, which can at least save bandwidth :P
2012-08-17 23022, 2012
nikki
I've never tried so I wouldn't know
2012-08-17 23057, 2012
ianmcorvidae
I mean, other than the "changing your tagger script" use case it's basically totally duplicate
2012-08-17 23009, 2012
ianmcorvidae
I guess "picard learns how to write a new tag" would also fill in there
2012-08-17 23033, 2012
ianmcorvidae
anything that changes the XML -> tags mapping, basically, but that's relatively stable for most use cases I think
2012-08-17 23046, 2012
ianmcorvidae
most people decide what they want and stick with it is my impression :P
2012-08-17 23049, 2012
nikki
oh, and you can edit files outside of picard too
2012-08-17 23039, 2012
ianmcorvidae
sure, you could also open whatever database it ostensibly creates (I'd bet on either XML or sqlite :P)
2012-08-17 23054, 2012
ianmcorvidae
or screw with the database's mapping by moving a file other than with picard
2012-08-17 23058, 2012
ianmcorvidae
or whatever
2012-08-17 23022, 2012
nikki
I think it's far more likely that someone will change their files with another program than it is that they'll edit the cached data
2012-08-17 23013, 2012
nikki
I'm just saying that "mb data has not been changed since this file was tagged" does not mean "this file's tags match the mb data"
2012-08-17 23038, 2012
ianmcorvidae
true
2012-08-17 23055, 2012
ianmcorvidae
but I think in most cases they'll both be true/false at the same times, and it's a lot easier to implement the former
2012-08-17 23054, 2012
ianmcorvidae
(especially initially -- moving to a real cache/database/etc. system later wouldn't be impossible or anything)
2012-08-17 23032, 2012
ianmcorvidae
totally roundabout reminder but: ocharles: at some point we should talk about varnish and the paid WS so I can take over that work (probably after the hack weekend though)
2012-08-17 23038, 2012
bitmap
nikki: "mb data has not been changed since this file was tagged" is what I was planning
2012-08-17 23004, 2012
bitmap
nikki: I was thinking with a database, you'd open a window to see a list of albums that have changed
2012-08-17 23004, 2012
ianmcorvidae
ocharles: well, unless it's a small enough task I could just do it *for* the hack weekend, in which case I probably should just do that :)
2012-08-17 23023, 2012
nikki
ianmcorvidae: sure, I'm not expecting perfection immediately :P
2012-08-17 23039, 2012
ianmcorvidae
haha
2012-08-17 23041, 2012
ianmcorvidae
fair enough :P
2012-08-17 23052, 2012
ocharles
ianmcorvidae: sure, feel free to email if you want to move the discussion offline too
2012-08-17 23056, 2012
nikki
bitmap: yeah, that sounds like what I'd expect. it could maybe even notify the user when they open picard if there's stuff that's changed
2012-08-17 23057, 2012
bitmap was planning on an icon in the statusbar for that :)
2012-08-17 23008, 2012
bitmap
I also wanted to store the file paths so you could double click on the album to load it and all of the files, but that's kind of iffy
2012-08-17 23019, 2012
ianmcorvidae
easily broken if anyone moves their files around
2012-08-17 23032, 2012
ianmcorvidae
unless picard runs a daemon and watches everything with inotify
2012-08-17 23036, 2012
ianmcorvidae
but that would be pretty crazy XD
2012-08-17 23048, 2012
ianmcorvidae
er, well, inotify and equivalents on other platforms
2012-08-17 23024, 2012
nikki
it could just tell the user it can't find the files and ask them to locate them manually
2012-08-17 23041, 2012
nikki
I mean, most music players I've tried require manually updating the library if you move files around, so I don't think it would be too unexpected that picard can't find it if you've moved it
2012-08-17 23042, 2012
bitmap
yep, that's what I had in mind
2012-08-17 23031, 2012
bitmap
I don't think itunes even updates your library automatically yet :P
2012-08-17 23043, 2012
nikki
I guess it would also need a delete option, in case they deleted it rather than moved it
2012-08-17 23057, 2012
bitmap nods
2012-08-17 23009, 2012
ianmcorvidae
ocharles: duly emailed :)
2012-08-17 23031, 2012
Orcie_ joined the channel
2012-08-17 23044, 2012
Orcie_
luks: I am getting a error on mbslave import
2012-08-17 23008, 2012
Orcie_
File "./mbslave-import.py", line 43, in <module>
2012-08-17 23009, 2012
Orcie_
psycopg2.OperationalError: fe_sendauth: no password supplied
