Difference between revisions of "TheSchwartz Setup"

Revision as of 21:13, 29 September 2010

To run any jobs that require queueing, such as the journal content importer and the sending of email (if you have email set up to send through TheSchwartz), you'll need to set up TheSchwartz. This requires that you set up the database and define it in etc/config-local.pl.

On your own install

In etc/config-local.pl, find the following block of code:

    # Schwartz DB configuration
    @THESCHWARTZ_DBS = (
            {
                dsn => 'dbi:mysql:dw_schwartz;host=localhost',
                user => 'dw',
                pass => 'password',     # CHANGETHIS
            },
        );

In this block of code, dw_schwartz represents the database name used by TheSchwartz, and dw represents the username. If you wish, you can change these to different values - but it's probably best not to use the same database as your main Dreamwidth installation uses, just in case. You should change the 'password' setting to a new database password used only for TheSchwartz.

(The rest of this page assumes that you're not changing the database name and username.)

You then need to create the database. Run the following two commands, changing databasepass to the password you created above, and entering the MySQL root password when prompted:

echo "create database dw_schwartz" | mysql -uroot -p
echo "grant all on dw_schwartz.* to 'dw'@'localhost' identified by 'databasepass'" | mysql -uroot -p

Then, initialise the database, entering the MySQL root password when prompted:

mysql -uroot -p dw_schwartz < $LJHOME/cvs/TheSchwartz/doc/schema.sql

The initial setup of TheSchwartz is now complete. To actually *use* TheSchwartz you'll need to run the worker for whatever jobs you need, and in the case of the importer you'll need to run the import scheduler too. More information on using the importer can be found at Importer Testing.

On a Dreamhack

To set up TheSchwartz on a Dreamhack, see Dreamhack getting started.