9:53 AM
Senilix
cp file.txt file_new_version.txt and edit on the production server :)
2008-08-01 21445, 2008
9:53 AM
Remosi
:)
2008-08-01 21404, 2008
9:54 AM
Remosi
why would you need anything more than that?
2008-08-01 21412, 2008
9:57 AM
FauxFaux
alastair, Senilix; both of those methods are scarily better than cvs.
2008-08-01 21441, 2008
9:57 AM
FauxFaux
Assuming you don't throw away the pieces of paper / old copies when you rename the files.
2008-08-01 21407, 2008
9:58 AM
MrQwerty has quit
2008-08-01 21431, 2008
9:58 AM
Senilix
FauxFaux: hehe.. true.. :)
2008-08-01 21438, 2008
9:58 AM
Muz
Back in INGERLAND FauxFaux? :)
2008-08-01 21447, 2008
9:58 AM
FauxFaux
Yes!
2008-08-01 21405, 2008
9:59 AM
FauxFaux
It's all, like, cold. :|
2008-08-01 21449, 2008
9:59 AM
Muz
You missed the decent weather heh
2008-08-01 21440, 2008
10:01 AM
k2be has quit
2008-08-01 21451, 2008
10:01 AM
FauxFaux
Winnor. \o/
2008-08-01 21456, 2008
10:01 AM
k2be joined the channel
2008-08-01 21441, 2008
10:08 AM
xlotlu joined the channel
2008-08-01 21453, 2008
10:25 AM
MrQwerty joined the channel
2008-08-01 21403, 2008
10:44 AM
MrQwerty` has quit
2008-08-01 21413, 2008
10:57 AM
Amblin joined the channel
2008-08-01 21440, 2008
10:57 AM
Amblin
Amblin is now known as Guest14927
2008-08-01 21407, 2008
11:17 AM
MrQwerty` joined the channel
2008-08-01 21425, 2008
11:35 AM
MrQwerty has quit
2008-08-01 21425, 2008
11:40 AM
phatmonkey joined the channel
2008-08-01 21454, 2008
11:44 AM
clemmonsm joined the channel
2008-08-01 21459, 2008
12:10 PM
jacknetgb joined the channel
2008-08-01 21439, 2008
12:12 PM
slaad has quit
2008-08-01 21441, 2008
12:13 PM
slaad joined the channel
2008-08-01 21401, 2008
12:31 PM
Sargun has quit
2008-08-01 21422, 2008
12:41 PM
niklas joined the channel
2008-08-01 21408, 2008
12:46 PM
Aquaguy joined the channel
2008-08-01 21410, 2008
12:46 PM
Aquaguy
Hey
2008-08-01 21420, 2008
12:46 PM
Aquaguy
is it possible to have a copy of the database?
2008-08-01 21437, 2008
12:47 PM
alastair
yeah, you can download it off the website
2008-08-01 21450, 2008
12:47 PM
jacknetgb
2008-08-01 21454, 2008
12:47 PM
jacknetgb
Thats the dumps
2008-08-01 21440, 2008
12:48 PM
Aquaguy
ok
2008-08-01 21415, 2008
12:49 PM
Aquaguy
[jacknetgb] and it is possible to update it as the main musicbrainz database is updated, for example checking for updates every sunday
2008-08-01 21446, 2008
12:49 PM
luks
yes, ideally by checking every hour, not once a week
2008-08-01 21447, 2008
12:49 PM
jacknetgb
Theres a cron script in the svn
2008-08-01 21415, 2008
12:50 PM
Aquaguy
great
2008-08-01 21404, 2008
12:51 PM
Freso joined the channel
2008-08-01 21408, 2008
12:52 PM
Aquaguy
One more thing, the database is written in PostgreSQL but I'd like to use mySQL is there any way to manage that? Since mySQL is faster and better I think, or that's what I've heard
2008-08-01 21403, 2008
12:53 PM
alastair
I think you'd be best off using postgres
2008-08-01 21422, 2008
12:53 PM
Remosi
postgres is more featureful
2008-08-01 21429, 2008
12:53 PM
Remosi
and MB uses a lot of postgres's features
2008-08-01 21430, 2008
12:53 PM
Freso
"mySQL is faster and better" - that's a highly subjective statement there.
2008-08-01 21455, 2008
12:53 PM
luks
2008-08-01 21452, 2008
12:54 PM
alastair
oh, wow
2008-08-01 21457, 2008
12:54 PM
alastair
sounds like a lot of work
2008-08-01 21413, 2008
12:55 PM
luks
yeah, and I don't see the benefit :)
2008-08-01 21431, 2008
13:08 PM
nikki
it's nice here today
2008-08-01 21401, 2008
13:09 PM
jacknetgb
back to the weather i see :)
2008-08-01 21407, 2008
13:09 PM
nikki
ah and that was a very late reply to what looked like recent conversation since I'd managed to scroll up a bit ¬_¬
2008-08-01 21436, 2008
13:09 PM
nikki
and hey, I'm british, that's what we're supposed to do! talk about the weather! :P
2008-08-01 21454, 2008
13:09 PM
jacknetgb
yep, i'm british too :)
2008-08-01 21413, 2008
13:10 PM
jacknetgb
Which county you from?
2008-08-01 21417, 2008
13:10 PM
nikki
north lincolnshire
2008-08-01 21420, 2008
13:10 PM
jacknetgb
cool
2008-08-01 21442, 2008
13:10 PM
nikki
boooooring! everyone goes to other counties for interesting stuff :P
2008-08-01 21425, 2008
13:11 PM
jacknetgb
lol
2008-08-01 21434, 2008
13:11 PM
jacknetgb
there must be something intresting there
2008-08-01 21456, 2008
13:11 PM
nikki
are you from durham or just living there?
2008-08-01 21406, 2008
13:12 PM
FauxFaux
Weather!
2008-08-01 21429, 2008
13:12 PM
jacknetgb
Yep from Durham
2008-08-01 21433, 2008
13:12 PM
nikki
I actually spend more time in london and cologne, I just occasionally come back to see my family
2008-08-01 21439, 2008
13:12 PM
FauxFaux
(Suffolk! Yarrrrrrrrrrrr!)
2008-08-01 21449, 2008
13:12 PM
nikki
well... we have steel works! they're big and dirty!
2008-08-01 21458, 2008
13:12 PM
nikki
but still rather boring...
2008-08-01 21408, 2008
13:14 PM
jacknetgb
I dont have to travel to see my family, cause i live with them which i think is permittable at my age
2008-08-01 21424, 2008
13:14 PM
chefkoch joined the channel
2008-08-01 21455, 2008
13:14 PM
chefkoch_AW has quit
2008-08-01 21457, 2008
13:14 PM
chefkoch
chefkoch is now known as chefkoch_AW
2008-08-01 21454, 2008
13:15 PM
nikki thinks...
2008-08-01 21401, 2008
13:16 PM
MrQwerty joined the channel
2008-08-01 21449, 2008
13:16 PM
jacknetgb
Anyone going anywhere nice on holiday this summer?
2008-08-01 21444, 2008
13:17 PM
nikki
I'm going back to germany next week, but it's not really a holiday to me
2008-08-01 21407, 2008
13:18 PM
jacknetgb
Nice, is that where you usually stay?
2008-08-01 21431, 2008
13:21 PM
nikki
my bf lives there :)
2008-08-01 21441, 2008
13:21 PM
jacknetgb
:) cool
2008-08-01 21419, 2008
13:22 PM
jacknetgb
Its starting to brighten up here woo!
2008-08-01 21449, 2008
13:31 PM
jacknetgb
Anyone know what the table is called that holds the links for artists e.g. to wikipedia
2008-08-01 21406, 2008
13:33 PM
MrQwerty` has quit
2008-08-01 21444, 2008
13:35 PM
nikki
l_artist_url
2008-08-01 21445, 2008
13:35 PM
luks
l_artist_url
2008-08-01 21401, 2008
13:36 PM
jacknetgb
lol
2008-08-01 21403, 2008
13:36 PM
jacknetgb
thanks
2008-08-01 21433, 2008
13:37 PM
alastair has quit
2008-08-01 21454, 2008
13:42 PM
jacknetgb
2008-08-01 21441, 2008
13:43 PM
luks
you have FK constraints on your server
2008-08-01 21451, 2008
13:43 PM
jacknetgb
Whats that?
2008-08-01 21452, 2008
13:43 PM
luks
they are not supposed to be on a DB mirror
2008-08-01 21409, 2008
13:44 PM
jacknetgb
Hmm how can i fix that
2008-08-01 21427, 2008
13:44 PM
luks
first check what type of server is set in DBDefs.pm
2008-08-01 21445, 2008
13:44 PM
luks
is it RT_SLAVE?
2008-08-01 21455, 2008
13:44 PM
jacknetgb
ye[
2008-08-01 21457, 2008
13:44 PM
jacknetgb
yep*
2008-08-01 21410, 2008
13:45 PM
luks
and the DB was created with RT_STANDALONE?
2008-08-01 21416, 2008
13:45 PM
jacknetgb
yes
2008-08-01 21422, 2008
13:45 PM
luks
that's the problem :)
2008-08-01 21444, 2008
13:45 PM
jacknetgb
ruaok made me run some scripts before that changed the db and then replication worked but its just stopped suddenly
2008-08-01 21402, 2008
13:46 PM
luks
./admin/psql READWRITE <admin/sql/DropFKConstraints.sql
2008-08-01 21430, 2008
13:46 PM
luks
and also ./admin/psql READWRITE <admin/sql/DropTriggers.sql
2008-08-01 21459, 2008
13:46 PM
luks
oh, I know
2008-08-01 21403, 2008
13:47 PM
jacknetgb
on the DropFK... one there was lots of errors saying that certain things exist and only one alter table
2008-08-01 21416, 2008
13:47 PM
luks
there was a bug in the branch, and the drop scripts were not complete
2008-08-01 21421, 2008
13:48 PM
jacknetgb
Is there any complete ones?
2008-08-01 21427, 2008
13:48 PM
luks
one moment
2008-08-01 21438, 2008
13:50 PM
luks
2008-08-01 21400, 2008
13:51 PM
luks
and run: admin/psql READWRITE <thefile
2008-08-01 21451, 2008
13:51 PM
jacknetgb
Thanks replication is now working again
2008-08-01 21436, 2008
13:52 PM
jacknetgb
PendingData still contains data (rows=1728)! at /home/mbserver/svn/mb_server/admin/replication/ProcessReplicationChanges line 21
2008-08-01 21441, 2008
13:52 PM
jacknetgb
and then it ends
2008-08-01 21458, 2008
13:52 PM
jacknetgb
That line number should be 214 bw
2008-08-01 21401, 2008
13:53 PM
jacknetgb
btw*
2008-08-01 21422, 2008
13:53 PM
luks
no, it's not
2008-08-01 21452, 2008
13:53 PM
luks
it happens when it crashes and doesn't clean up the pendingdata table
2008-08-01 21432, 2008
13:54 PM
jacknetgb
how can i clean it manually
2008-08-01 21417, 2008
13:55 PM
luks
echo 'DELETE FROM "PendingData"' | ./admin/psql READWRITE
2008-08-01 21437, 2008
13:55 PM
luks
(I think)
2008-08-01 21445, 2008
13:55 PM
luks
er, missing ;
2008-08-01 21410, 2008
13:57 PM
jacknetgb
Ran that and it said DELETE 1728, so i ran the replication script again and it said that same error as before but (rows=3365)
2008-08-01 21452, 2008
13:57 PM
luks
hmm
2008-08-01 21419, 2008
13:58 PM
luks
go into psql, run the delete command
2008-08-01 21433, 2008
13:58 PM
luks
and then check how many rows is in table "Pending"
2008-08-01 21440, 2008
13:59 PM
jacknetgb
theres no rows in pendingData
2008-08-01 21450, 2008
13:59 PM
jacknetgb
but theres rows in Pending?
2008-08-01 21455, 2008
13:59 PM
luks
delete them
2008-08-01 21428, 2008
14:00 PM
jacknetgb
thats DELETED 3365
2008-08-01 21440, 2008
14:00 PM
jacknetgb
seems to be running fine now
2008-08-01 21442, 2008
14:00 PM
luks
so both Pending and PendingData are empty now?
2008-08-01 21443, 2008
14:01 PM
jacknetgb
yep
2008-08-01 21426, 2008
14:02 PM
clemmonsm
hello everyone - does anyone have a link to instruction on setting up pgadmin iii to connect to mb on the vmware virtual server?
2008-08-01 21422, 2008
14:03 PM
jacknetgb
On the wiki theres a line to add to pg_hba.conf that allows all computers on the network to access it
2008-08-01 21437, 2008
14:03 PM
jacknetgb
and in postgresql.conf you need to add listen_address='*'
2008-08-01 21419, 2008
14:04 PM
jacknetgb
2008-08-01 21420, 2008
14:04 PM
chefkoch_AW has quit
2008-08-01 21428, 2008
14:05 PM
clemmonsm
jacknetgb: thanks
2008-08-01 21436, 2008
14:05 PM
jacknetgb
no problem :)
2008-08-01 21421, 2008
14:16 PM
clemmonsm
jacknetgb: one quick question due to my unix experience limitation...i'm attempting to perform: /etc/init.d/postgresql-8.1 restart
2008-08-01 21433, 2008
14:16 PM
jacknetgb
right
2008-08-01 21434, 2008
14:16 PM
clemmonsm
is postgresql-8.1 not a directory?
2008-08-01 21449, 2008
14:16 PM
jacknetgb
no its a init script
2008-08-01 21403, 2008
14:17 PM
clemmonsm
./postgresql-8.1 restart
2008-08-01 21405, 2008
14:17 PM
clemmonsm
?
2008-08-01 21411, 2008
14:17 PM
jacknetgb
what do you mean?
2008-08-01 21425, 2008
14:17 PM
jacknetgb
just run /etc/init.d/postgresql-8.1 restart to restart it
2008-08-01 21447, 2008
14:17 PM
jacknetgb
the postgresql-8.1 is just a normal script in the init.d directory
2008-08-01 21454, 2008
14:17 PM
clemmonsm
ok. i'm in etc/init.d right now
2008-08-01 21409, 2008
14:18 PM
clemmonsm
how do i run it?
2008-08-01 21411, 2008
14:18 PM
jacknetgb
you didnt have to be in the dir
2008-08-01 21421, 2008
14:18 PM
clemmonsm
ah
