Talk:Virtual MusicBrainz Server

Comments

There are a few things missing from the VM image that would make it a whole lot easier to use. For example, emacs and java (needed to run the /admin/jsdeploy/run.sh script). Also, trying to get VMWare Tools installed was a bit of a pain because there were some dependencies missing, like linux-headers-2.6.18-4-686 and gcc 4.1.2 (the version used to build the kernel). Finally, it would be nice if the /etc/apt/sources.list file were set to include the standard debian locations so that apt-get were more useful. Something like:

deb http://http.us.debian.org/debian stable main contrib non-free
deb http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free
deb http://security.debian.org stable/updates main contrib non-free
     
# Uncomment if you want the apt-get source function to work
#deb-src http://http.us.debian.org/debian stable main contrib non-free
#deb-src http://non-us.debian.org/debian-non-US stable/non-US main contrib non-free

lynx question

Could someone please explain howto mark files in lynx? That's not that easy for most of us (windows-)users.

keyboard question

For those of us with a non-US-keyboard, you should explain how to enter the ~ sign (in front of your import-file)

vi (Editor) question

For all the windows-users out there: If you have to change some lines (like changing the replication mode), you can use the built-in editor vi.

Without any knowledge of vi, you can't really use it, but this are the most important things:

To enter Vi type:

vi FILENAME

Vi has two modes: Normal (command) mode and edit mode.

Switch to normal mode:     <ESC>
Switch to edit mode:       i or a

Getting out of Vi (change to normal mode <ESC>):

Exit Vi:                       :q
Exit Vi (ignore changes):      :q!
Save:                          :w
Save and Exit:                 :wq

Apply the 3 *.sql-commandfiles

I had to do it this way (every other syntax I used, wasn't successfull):

cd svn

cd mb_server (you can start with m and b and press TAB)

cd admin

then execute the 3 lines with this syntax:

./psql READWRITE < ./sql/DropFKConstraints.sql

./psql RAWDATA < ./sql/vertical/rawdata/DropFKConstraints.sql

./psql READWRITE < ./sql/DropTriggers.sql