LgHS Members

Management interface for our Hackerspace members.

Install

composer install
create a pgsql database (See below)
copy .env.example to .env and adapt to your configuration
php artisan key:generate
php artisan config:cache
php artisan optimize
php artisan migrate --seed
php artisan passport:install to create keys for Oauth
check that laravel can write to storage/ and bootstrap/cache
point a web server to public/ directory or use php artisan serve for dev
use admin credentials you defined in .env to login. Don't forget to change those credentials to something different and robust.

Run

Run php artisan serve to run locally.

Test

./vendor/bin/phpunit to run tests.

./vendor/bin/phpunit-watcher watch to run tests each time a file is saved.

./vendor/bin/phpunit --filter=MyTest to run a single test (also works for phpunit-watcher).

Other

Create a PGSQL Database

Install Postgresql, create a user and a database:

create database lghs_members;
create user lghs_members_root with password '<password>';
grant all on database lghs_members to lghs_members_root;

Nginx

Add this to your nginx config :

# redirect stuff to the public inner folder
location / {
   root {DOCROOT}/public;
   try_files $uri public/$uri/ /public/index.php?$query_string;
} 

# merged the stuff people suggests for laravel inside the php block
# mind the 'merge' keyword that did the trick
location ~ \.php$ { ##merge##
   fastcgi_split_path_info ^(.+\.php)(/.+)$;
   fastcgi_pass unix:/var/run/php5-fpm.sock;
   fastcgi_index index.php;
   include fastcgi_params;
   fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
   fastcgi_intercept_errors off;
   fastcgi_buffer_size 16k;
   fastcgi_buffers 4 16k;
}

Testing

Add a pgsql user and a database :

create database lghs_members_test;
grant all on database lghs_members_test to lghs_members_root;

Make sure you have installed dependencies with composer install.

Then run ./vendor/bin/phpunit.

Migrating mysql to postgresql

If you are using an old database, you can use pgloader to migrate it to postgres.

First things first, install postgresql and create a database and a user.

create database lghs_members;
create user lghs_members_root with password '<password>';
grant all on database lghs_members to lghs_members_root;

Then run the below script using pgloader.

load database
     from mysql://<user>:<password>@localhost/lghs-sign-in
     into pgsql://lghs_members_root:<password>@localhost/lghs_members
-- FIXME translate sequences
 WITH include drop, create tables, no truncate,
      create indexes, reset sequences, foreign keys

 SET maintenance_work_mem to '128MB', work_mem to '12MB', search_path to '"lghs-sign-in", public'

 CAST type datetime to timestamp
                drop default drop not null using zero-dates-to-null,
      type timestamp to timestamp
                drop default drop not null using zero-dates-to-null,
      type date drop not null drop default using zero-dates-to-null,
      type tinyint to boolean drop typemod using tinyint-to-boolean

 ALTER SCHEMA 'lghs-sign-in' RENAME TO 'public'
;

After the migration, make sure the schema imported is correctly named public. To do so, open a psql console (psql lghs_members) and type \dn.

If you have two schemas:

drop schema public;
alter schema <name> rename to public;

LgHS / sign-in

readme