theem guesses he has both installed and is running regular apache
2005-02-03 03433, 2005
g0l
yay
2005-02-03 03441, 2005
g0l
how could that happen?
2005-02-03 03446, 2005
cikkolata giggles evilly as she gets mpd to work with her power/sleep/wake as play-pause/prev/next
2005-02-03 03451, 2005
theem
debian lets you install as many apaches as you want
2005-02-03 03406, 2005
theem
you should probably have them runnin on different ports if you do want to run more than one
2005-02-03 03414, 2005
g0l
i don't want that :)
2005-02-03 03422, 2005
theem
but you dont need regular apache anymore, you can safely remove it
2005-02-03 03427, 2005
g0l
i had a minimal install and run the from-debian-base scripts
2005-02-03 03431, 2005
theem
:)
2005-02-03 03449, 2005
yalaforge
g0l: listen to theem and remove apache :-)
2005-02-03 03452, 2005
g0l
theem: if i remove, i surely remove the wrong one *g*
2005-02-03 03458, 2005
g0l
good idea
2005-02-03 03402, 2005
g0l
*lol*
2005-02-03 03404, 2005
yalaforge
apt-get remove apache
2005-02-03 03418, 2005
g0l
not kidding?
2005-02-03 03422, 2005
theem
nope, thats it
2005-02-03 03422, 2005
yalaforge
no configuration is removed, so you can easily reinstall the package if necessary
2005-02-03 03433, 2005
yalaforge
no danger at all, really
2005-02-03 03400, 2005
g0l
827kb disk space will be freed, i can use that for additional data now ;)
2005-02-03 03421, 2005
theem
lol... are you loading the full db ?
2005-02-03 03434, 2005
g0l
no
2005-02-03 03444, 2005
yalaforge
4 GB aren't enough
2005-02-03 03451, 2005
g0l
yalaforge: what do i have in the db with the first 220mb
2005-02-03 03405, 2005
theem
we really do need just a "test" dataset (i had to make my own by hand)
2005-02-03 03414, 2005
theem
ah! thats a good idea too
2005-02-03 03428, 2005
yalaforge
the first 220mb? you imported the core data?
2005-02-03 03430, 2005
g0l
search does not work
2005-02-03 03436, 2005
g0l
yes
2005-02-03 03407, 2005
yalaforge
search? you mean on your local machine? does your mb_server run now?
2005-02-03 03436, 2005
g0l
sure
2005-02-03 03438, 2005
yalaforge
the search tables aren't included in the core data. they're in the derived data set, IIRC
2005-02-03 03447, 2005
g0l
if i browse there are artists, but search returns no results
2005-02-03 03457, 2005
g0l
ah, that makes sense i guess
2005-02-03 03404, 2005
g0l
albums are not there either?
2005-02-03 03412, 2005
yalaforge
no?
2005-02-03 03434, 2005
g0l
In Flames: this artist has no albums. my mb_server is a liar :)
2005-02-03 03403, 2005
theem
did you import some from each table?
2005-02-03 03411, 2005
yalaforge
hm. connect to the DB as user www-data via psql
2005-02-03 03438, 2005
yalaforge
then check if the album relation contains data
2005-02-03 03448, 2005
g0l
could you point me to a db-schema?
2005-02-03 03455, 2005
g0l
have no idea how the tables are called
2005-02-03 03417, 2005
yalaforge
select count(*) from album;
2005-02-03 03440, 2005
g0l
nada
2005-02-03 03448, 2005
yalaforge
mb_server/admin/sql/CreateTables.sql
2005-02-03 03450, 2005
g0l
doesnt even output anything
2005-02-03 03455, 2005
yalaforge
but you have artists?
2005-02-03 03401, 2005
g0l
yeah
2005-02-03 03425, 2005
yalaforge
ok, I think this import has failed :-)
2005-02-03 03436, 2005
cikkolata
are you sure it didn't run out of space?
2005-02-03 03446, 2005
yalaforge
probably during import
2005-02-03 03457, 2005
g0l
there's still 30%, eg 1.7gb fee
2005-02-03 03400, 2005
g0l
+free
2005-02-03 03407, 2005
cikkolata
it had to extract the bz2s
2005-02-03 03413, 2005
theem
g0l: what are you wanting to do with this test data?
2005-02-03 03420, 2005
yalaforge
how much does your db eat at the moment?
2005-02-03 03422, 2005
g0l
guess case script
2005-02-03 03444, 2005
yalaforge
well, you can enter a few albums manually, that's no problem
2005-02-03 03449, 2005
theem
a slightly simpler way (and more time consuming) would be just to make an account and enter some data manually
2005-02-03 03457, 2005
yalaforge
yup
2005-02-03 03411, 2005
yalaforge
enough to play with the java script stuff
2005-02-03 03412, 2005
g0l
i couldnt come up with as worse data than the one already there
2005-02-03 03414, 2005
g0l
;)
2005-02-03 03435, 2005
yalaforge
then you have to delete the existing database and start import again
2005-02-03 03436, 2005
g0l
uh oh, superb english of mine
2005-02-03 03437, 2005
theem
lol, your test cases seemed good :)
2005-02-03 03409, 2005
g0l
theem, don't recognize your nick. who is you?
2005-02-03 03412, 2005
theem
i would make 1 album with about 50 tracks of trash you can find somewhere off the web i'm sure
2005-02-03 03425, 2005
theem is undergoing a nick change from spooge
2005-02-03 03437, 2005
cikkolata
ahh
2005-02-03 03438, 2005
theem
we've spoken a few times through email
2005-02-03 03444, 2005
g0l underst�nds
2005-02-03 03445, 2005
g0l
now
2005-02-03 03412, 2005
g0l
lucky you that others helped me install the server :>
2005-02-03 03424, 2005
theem
what kind of problems did you have?
2005-02-03 03435, 2005
g0l being a n00b mostly
2005-02-03 03437, 2005
yalaforge
g0l: could you please check how big your database is at the moment?
2005-02-03 03442, 2005
yalaforge
nothing serious
2005-02-03 03442, 2005
theem
i think i only had two stopping ponits, and they were easy chmod fixes
2005-02-03 03447, 2005
g0l
ah sorry. how do i do that
2005-02-03 03402, 2005
yalaforge tries to remember where the db is
2005-02-03 03406, 2005
theem
hmm
2005-02-03 03410, 2005
cikkolata
/var/lib/postgres?
2005-02-03 03419, 2005
g0l
good guess
2005-02-03 03430, 2005
yalaforge
/var/lib/postgres/data
2005-02-03 03433, 2005
yalaforge
cikkolata: thanks!
2005-02-03 03435, 2005
cikkolata
:)
2005-02-03 03442, 2005
g0l
i'm in that directory now
2005-02-03 03445, 2005
theem
du -h
2005-02-03 03402, 2005
g0l
df -h, du -h can it get any more criptic than that`?
2005-02-03 03412, 2005
g0l
dont answer me, i read the scripts of djce :)
2005-02-03 03423, 2005
theem
"disk usage, humanize"
2005-02-03 03424, 2005
mrneil has quit
2005-02-03 03433, 2005
yalaforge
df = disk free
2005-02-03 03437, 2005
g0l
wow, it says: 2.0G
2005-02-03 03447, 2005
yalaforge
the -h switch is gnu specific, AFAIK
2005-02-03 03457, 2005
g0l
theem: ta
2005-02-03 03411, 2005
yalaforge
2.0G?
2005-02-03 03421, 2005
g0l
i'll just post the trace here:
2005-02-03 03427, 2005
yalaforge
that can't all be indexes
2005-02-03 03429, 2005
g0l
1.9G ./base
2005-02-03 03431, 2005
g0l
140K ./global
2005-02-03 03433, 2005
g0l
129M ./pg_xlog
2005-02-03 03435, 2005
g0l
12K ./pg_clog
2005-02-03 03437, 2005
g0l
2.0G .
2005-02-03 03403, 2005
yalaforge
do you want to remove the database and try another import?
2005-02-03 03409, 2005
g0l
sure, why not
2005-02-03 03425, 2005
yalaforge
ok, as user postgres:
2005-02-03 03430, 2005
yalaforge
dropdb musicbrainz_db
2005-02-03 03435, 2005
yalaforge
dropuser musicbrainz_user
2005-02-03 03446, 2005
yalaforge
then restart the InitDB stuff
2005-02-03 03403, 2005
g0l
ehm, i have to stop it first hmm?
2005-02-03 03413, 2005
yalaforge
does it complain?
2005-02-03 03420, 2005
g0l
"is in use by other users"
2005-02-03 03427, 2005
yalaforge
shut down apache
2005-02-03 03437, 2005
yalaforge
apache uses the database
2005-02-03 03448, 2005
yalaforge
/etc/init.d/apache-perl stop
2005-02-03 03459, 2005
g0l
thanks, could have thought of that myself
2005-02-03 03409, 2005
yalaforge
np
2005-02-03 03414, 2005
cikkolata is surprised at how many of the things she guessed at were what you said to do.
2005-02-03 03401, 2005
g0l
could you explain what you just said? :>
2005-02-03 03415, 2005
yalaforge is glad it isn't just me :-)
2005-02-03 03431, 2005
g0l
hehe
2005-02-03 03402, 2005
cikkolata
um...
2005-02-03 03426, 2005
yalaforge still tries to decipher
2005-02-03 03427, 2005
g0l
created a clean an empty db.
2005-02-03 03436, 2005
cikkolata
the things yalaforge and other people have said to do were what I guessed at when I was messing things up the first million times I was trying to set things up
2005-02-03 03402, 2005
yalaforge
ahh
2005-02-03 03416, 2005
yalaforge
g0l: ./admin/InitDb.pl --createdb
2005-02-03 03439, 2005
g0l
did that, but with the --clean bit
2005-02-03 03442, 2005
g0l
was that wrong?
2005-02-03 03442, 2005
cikkolata
and I'm surprised that they were right.
2005-02-03 03414, 2005
yalaforge
g0l: don't know. never used --clean
2005-02-03 03444, 2005
g0l
arf, now it does complain stuff exists when running the --import part
