SongKong Jaikoz

SongKong and Jaikoz Music Tagger Community Forum

Pro License, local musicbrainz server

Cant see speedup captain :slight_smile:

U mean speed up downloading the torrent or actually using the virtual server with jaikoz

Torrent of course :slight_smile:

ive imported apliance into Virtualbox and ran.
Whats user/pass ? default musicbrainz (both) wont work

Is it user:musicbrainz_user and password:musicbrainz ?

nope

User/pass was musicbrainz/mbserver when I exported the VM. Glad to see there is so much interest in the VM! Good on ya scribebox!!

The Ourea

I hope that server will be updated when new release come :slight_smile:

I’m d/l’ing now, will also seed… thx!

downloaded and run. I run replication when downloaded, then i was exploring. I tried to update index ( i hope thats right way ) But i get error. Any way how to fix it ?

org.postgresql.util.PSQLException: FATAL: role "musicbrainz_user" does not exist
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:444)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:99)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:29)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:386)
        at org.postgresql.Driver.connect(Driver.java:260)
        at java.sql.DriverManager.getConnection(DriverManager.java:620)
        at java.sql.DriverManager.getConnection(DriverManager.java:169)
        at org.musicbrainz.search.index.IndexOptions.getMainDatabaseConnection(IndexOptions.java:49)
        at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.update(LiveDataFeedIndexUpdater.java:75)
        at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.main(LiveDataFeedIndexUpdater.java:263)
tmp_artistcredit:Started at:04:34:55
Exception in thread "main" java.lang.NullPointerException
        at org.musicbrainz.search.index.CommonTables.createArtistCreditTableUsingDb(CommonTables.java:66)
        at org.musicbrainz.search.index.CommonTables.createTemporaryTables(CommonTables.java:214)
        at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.update(LiveDataFeedIndexUpdater.java:100)
        at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.main(LiveDataFeedIndexUpdater.java:263)
musicbrainz@mbserver:~/search_server/updater$

You need to edit updateindex.sh it looks like it is expecting the musicbrainz user to be called ‘musicbrainz_user’ when in fact according to the VM creator it is musicbrainz


MAIN_DB_HOST=localhost
INDEXES_DIR=../index/data
SERVLET_HOST=localhost:8080

LIVE_UPDATE_REPO=http://test.musicbrainz.org:82/pub/musicbrainz/data/replication/

SEARCH_UPDATER_JAR=target/updater-2.0-SNAPSHOT-jar-with-dependencies.jar
LOCK_FILE=/tmp/.mb-search-updater

if [ -e $LOCK_FILE ]; then
    echo "Index updater is already running, existing..."
    exit
fi

if [ ! -e $SEARCH_UPDATER_JAR ]; then
    echo "JAR '$SEARCH_UPDATER_JAR' not found..."
    echo "You should maybe run 'mvn package'..."
    exit
fi

touch $LOCK_FILE
java -Xmx512M -jar $SEARCH_UPDATER_JAR --db-host $MAIN_DB_HOST --replication-repository $LIVE_UPDATE_REPO --indexes-dir $INDEXES_DIR "$@"

if [ -n "$SERVLET_HOST" ] ; then
    wget --quiet --spider http://$SERVLET_HOST/?reload
fi
rm $LOCK_FILE

Cant see any musicbrainz user

The user/pass for the machine login (right when you ssh to it) was musicbrainz/mbserver. This is not necessarily the password for other things in the setup like postgres/apache/tomcat/whatever else I can’t remember setting up. I’m reasonably sure I used default values throughout the installation. The only reason the default machine login password was changed: I found ‘musicbrainz’ to be an annoying password to type and changed it to ‘mbserver’.

My guess is you are trying to download the latest changes to the database (new albums and the like). If that is what you want, use ~/run_replication.sh.

That command is run as a cron every 10min, so you shouldn’t have to use it.
Check /tmp/replication.log.

Or maybe I’m misunderstanding your problem, in which case, happy index updating!

The Ourea

[quote=theourea]

Or maybe I’m misunderstanding your problem, in which case, happy index updating!

The Ourea[/quote]

I wnat update search index

OK, why? Maybe I want to update mine too!

The Ourea

pschomann is right.

Replication updates the slave database from the Musicbrainz Database.
But then for searches (as opposed to lookups) to use the latest data in the database you need to rebuild or update your indexes.

Now the shell script update the index, this code is not actually used on production yet but I think it works okay. It connects to the musicbrainz database using the defaults in the indexer code which are that the musicbrainz user is called musicbrainz_user with a blank password, so I think this is the problem.

So find out what the real user and password for are for the database, probably musicbrainz/musicbrainz.

Then edit

[```
java -Xmx512M -jar $SEARCH_UPDATER_JAR --db-host $MAIN_DB_HOST --replication-repository $LIVE_UPDATE_REPO --indexes-dir $INDEXES_DIR “$@”


to 

java -Xmx512M -jar $SEARCH_UPDATER_JAR --db-host $MAIN_DB_HOST --db-user musicbrainz --db-password musicbrainz --replication-repository $LIVE_UPDATE_REPO --indexes-dir $INDEXES_DIR “$@”



and see if that works.

After making the described changes I get the following output:

tmp_artistcredit:Started at:09:06:10
tmp_artistcredit:Finished:65.0 secs
tmp_artistcredit:Created Indexes:3.0 secs
tmp_release :Started at:09:07:19
tmp_release :Finished:251.0 secs
tmp_release :Created Indexes:4.0 secs
Thu Sep 06 09:11:35 PDT 2012 INFO
Thu Sep 06 09:11:35 PDT 2012 INFO Started updating index: artist
Exception in thread “main” java.lang.IllegalArgumentException: No matches in the index for the given Term.
at org.musicbrainz.search.index.DatabaseIndex.readReplicationInformationFromIndex(DatabaseIndex.java:96)
at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.updateDatabaseIndex(LiveDataFeedIndexUpdater.java:148)
at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.update(LiveDataFeedIndexUpdater.java:116)
at org.musicbrainz.search.update.LiveDataFeedIndexUpdater.main(LiveDataFeedIndexUpdater.java:263)

Looks like updating the db user/pass worked but then another bump in the road was encountered?

-The Ourea

Yeah password problem resolved but looks like there is a bug in indexUpdater, I’m not familiar with how it works.

Is there a createindex.sh file you can modify in a similar way and rebuild the indexes from scratch instead. Of course this will take much longer.

Ahh I only need 2% more, all seeders went offline :frowning:

Right, just got round to trying this virtual machine.

It starts up but only in console mode, is there a way to get an X11 Windowing display ?