PFMIS
Deployment Guide

1.1  Create the database and user

1. cPanel → MySQL® Databases.
2. Under Create New Database, name it pfmis → Create. Note the full prefixed name it returns (e.g. acct_pfmis).
3. Under MySQL Users → Add New User, create a user with a strong password. Record both.
4. Under Add User To Database, select the user + database → grant ALL PRIVILEGES.

1.2  Import the schema

1. cPanel → phpMyAdmin. In the left sidebar, click your database so it is selected.
2. Top menu → Import → choose sql/schema.sql → Go.
3. Confirm ~26 tables appear in the left sidebar with no red error.

1.3  Seed the dropdown lists (recommended)

With your database still selected, Import sql/seed-lists.sql. This fills the app's dropdowns (houses, breeds, feed types, vaccines, sale items, etc.) with sensible defaults. It is safe to re-run and everything is editable later in the app under Configurations.

1.4  Create your first admin login

No user accounts ship with the system, and you can't create one without logging in — so the first admin is inserted by hand, once. First generate a scrambled ("hashed") password:

1. In cPanel File Manager, inside pfmis-backend/public, create a file hash.php containing:

   <?php echo password_hash('YOUR-ADMIN-PASSWORD', PASSWORD_BCRYPT);

2. Visit https://api.houseofloveafrica.org/hash.php and copy the $2y$… string it prints.
3. Delete hash.php immediately.

Then in phpMyAdmin → your database → SQL tab, run (substitute your name, email, and the hash):

-- 1) your farm
INSERT INTO farms (name) VALUES ('House of Love Africa');

-- 2) an Admin role with full access
INSERT INTO roles (farm_id, name, description, is_system, permissions) VALUES
  (1, 'Admin', 'Full access to every module', 1,
   '{"dashboard":"edit","flocks":"edit","daily":"edit","eggs":"edit","feed":"edit","health":"edit","vaccination":"edit","inventory":"edit","sales":"edit","expenses":"edit","hr":"edit","payroll":"edit","reports":"edit","settings":"edit"}');

-- 3) you (paste your $2y$ hash where shown)
INSERT INTO users (farm_id, role_id, name, email, password_hash, status) VALUES
  (1, 1, 'Your Name', 'you@houseofloveafrica.org', 'PASTE-THE-HASH-HERE', 'active');

2.1  Upload the code

1. In cPanel File Manager, go to your home folder (above public_html).
2. Upload the pfmis-backend ZIP, then Extract it.
3. Rename the resulting folder to pfmis-backend. Delete the ZIP.

2.2  Create the API subdomain

1. cPanel → Domains (or Subdomains) → create api under houseofloveafrica.org.
2. Set the Document Root to exactly:

   pfmis-backend/public

2.3  Create the config file

1. In pfmis-backend/config, copy config.example.php to config.php.
2. Edit config.php — after each ?: put your real values:

'host' => getenv('DB_HOST') ?: 'localhost',
'name' => getenv('DB_NAME') ?: 'acct_pfmis',
'user' => getenv('DB_USER') ?: 'acct_pfmis',
'pass' => getenv('DB_PASS') ?: 'your-db-password',
...
'cors_allow_origin' => getenv('CORS_ORIGIN') ?: 'https://farms.houseofloveafrica.org',

2.4  Fix "logged out one second after logging in"

RewriteEngine On

RewriteCond %{HTTP:Authorization} .
RewriteRule ^ - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^ index.php [QSA,L]

2.5  Enable HTTPS

cPanel → SSL/TLS Status → tick api.houseofloveafrica.org → Run AutoSSL. Usually a certificate is issued automatically for new subdomains.

2.6  Test the API

Open https://api.houseofloveafrica.org/healthz. You should see exactly:

{"ok":true,"service":"pfmis-api"}

If you see that, the backend is live. If not, see Troubleshooting before continuing.

3.1  Point the frontend at the API

1. Vercel → your project → Settings → Environment Variables.
2. Add:

   VITE_API_URL = https://api.houseofloveafrica.org

   (no trailing slash; scope: Production)
3. Vercel → Deployments → open the latest → Redeploy (the variable only applies to a fresh build).

3.2  Fix "404: NOT_FOUND" when refreshing an inner page

{
  "rewrites": [
    { "source": "/(.*)", "destination": "/index.html" }
  ]
}

3.3  Custom domain

Vercel → project → Settings → Domains → add farms.houseofloveafrica.org, then create the CNAME record Vercel shows you (pointing to cname.vercel-dns.com) in your DNS. Wait for it to verify and issue SSL.