eveindy

EVE industrial thingy

Status

Alpha. More alpha than a full fleet of Catalysts, in fact.

Requirements

This software requires:

• Node.js v0.12
• PostgreSQL v9.3 or higher
• Redis (developed using v3.0)
• A CREST API key.

It is tested on Linux, FreeBSD, and OS X. Windows is untested but should work.

Installation

Database

eveindy currently requires two PostgreSQL databases:

• one containing the SDE dump as provided by Steve Ronuken (by default, evetool), and
• one for user data (eveindy).

I'll probably end up using two schemas in one database, but that hasn't happened yet.

This application will require a user to connect to the database.

CREATE ROLE eveindy WITH
  LOGIN
  PASSWORD 'correct horse battery staple';
-- or a different authentication method.

Create a new database for the SDE dump using the instructions provided in evego. Grant the database user to be used by eveindy read permission on everything in this database. (Yes, I know this part is all public data.)

BEGIN;

REVOKE ALL PRIVILEGES ON DATABASE evetool FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM public;
GRANT CONNECT ON DATABASE evetool TO eveindy;
GRANT USAGE ON SCHEMA public TO eveindy;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO eveindy;

COMMIT;

Create a new database (we use eveindy) and run the provided SQL (in the sql directory) to set it all up.

(echo "SET search_path TO eveindy,sde,public;" && cat *.sql) | psql -1 eveindy

You'll then need to configure this database's security using something like the following:

BEGIN;

REVOKE ALL PRIVILEGES ON DATABASE eveindy FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA eveindy FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA eveindy FROM public;
GRANT CONNECT ON DATABASE eveindy TO eveindy;
GRANT USAGE ON SCHEMA eveindy TO eveindy;
GRANT SELECT ON ALL TABLES IN SCHEMA eveindy TO eveindy;

COMMIT;

Cache (Redis)

Operation & Maintenance

To update the local SDE copy, use the update_sde.py script in evego following the instructions in that project's README file.

License

The contents of this repository are © 2014–6 Brad Ackerman and licensed under the Apache License 2.0, the full text of which is in the LICENSE file.