ai-context/sites.md

Websites & Sites Reference Card

All Sites on DO (165.22.1.228)

Site	Path	GitHub Repo	DB
tomsjavajive.com	/home/tomsjavajive.com/public_html/	myronblair/tomsjavajive	toms_tjj_db
epictravelexpeditions.com	/home/epictravelexpeditions.com/public_html/	myronblair/epictravelexpeditions	epic_epic_db
parkerslingshot (subdomain)	/home/epictravelexpeditions.com/parkerslingshot/	myronblair/parkerslingshot	epic_parkersling
parkerslingshotrentals.com	/home/parkerslingshotrentals.com/public_html/	myronblair/parkerslingshotrentals	parker_db
orbishosting.com	/home/orbishosting.com/public_html/	myronblair/orbishosting	—
orbis.orbishosting.com	/home/orbis.orbishosting.com/public_html/	myronblair/orbis-hosting-portal	—
tomtomgames.com	/home/tomtomgames.com/public_html/	myronblair/tomtomgames	tomt_ttg_db

JARVIS (on PVE1 VM 211, NOT DO)

Site	Path	GitHub Repo	DB
jarvis.orbishosting.com	/var/www/jarvis/ on 10.48.200.211	myronblair/jarvis	jarvis_db

Deploy Workflow

# 1. Edit files on server via SSH (for quick hotfixes)
sshpass -p 'Gonewalk1974!@#' ssh -o StrictHostKeyChecking=no root@165.22.1.228 \
  'nano /home/site.com/public_html/file.php'

# 2. ALWAYS commit + push to GitHub
cd /home/site.com && git add -A && git commit -m "message" && git push

# Auto-deploy triggers within 1 minute via webhook
# Webhook handler: tomtomgames.com/webhook.php (DO sites)
# JARVIS webhook: port 1972 on VM 211

# For immediate deploy (skip 1-min wait):
sshpass -p 'Gonewalk1974!@#' scp -o StrictHostKeyChecking=no \
  /tmp/changed.php root@165.22.1.228:/home/site.com/public_html/changed.php

GitHub PAT

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 — expires ~2026-08-20

Database Credentials

DB	User	Password
jarvis_db	jarvis_user	J4rv1s_Pr0t0c0l_2026!
toms_tjj_db	toms_tjj_user	+60wlPc+55e@gFq4
epic_epic_db	epic_epic	(check config.php)
epic_parkersling	epic_parkersling	Joker1974!!!
parker_db	parker_db	(check config.php)
MySQL root (DO)	root	b71e5c1a8c7457541b9c1db822de37adfa271926a38b6c20

# Quick DB access on DO
sshpass -p 'Gonewalk1974!@#' ssh -o StrictHostKeyChecking=no root@165.22.1.228 \
  'mysql -u toms_tjj_user -p"+60wlPc+55e@gFq4" toms_tjj_db -e "SELECT ..."'

# Quick DB access on JARVIS VM
sshpass -p 'Joker1974!!!' ssh -o StrictHostKeyChecking=no root@10.48.200.211 \
  'mysql -u jarvis_user -pJ4rv1s_Pr0t0c0l_2026! jarvis_db -e "SELECT ..."'

Gitignored Credentials (never in GitHub)

• api/config.php — JARVIS, epictravelexpeditions
• config/database.php — tomsjavajive
• db.php, config.php — parkerslingshot

Tom's Java Jive Quirks

• No slug column on products — URLs use ?id=product_id
• All tables must be utf8mb4_unicode_ci — mixed collation breaks JOINs (error 1267)
• wallet_transactions.type and loyalty_transactions.type have strict enums
• Admin login: admin@tomsjavajive.com / Joker1974!!!

Parker Slingshot Admin

• URL: /admin/index.php
• Auth: HMAC-signed cookie (NOT PHP sessions — sessions unreliable under LiteSpeed caching)
• Login: admin / Parker2026!

Email / SMTP

• All sites: CyberMail (CyberPersons) — API key sk_live_7f9b0f9a29f6de31a0d229d4af75d56b094ad724fc58a57d
• Manage at: platform.cyberpersons.com
• DO blocks SMTP port 587 — use CyberMail API over HTTPS (port 443)

FusionPBX

• URL: https://fusion.orbishosting.com (admin / fY7XP5swgtpbzrYLhkeVYkA4744)
• Server: 134.209.72.226 (SSH: relay via DO → root / Joker1974!@#)
• Timezone: America/Chicago
• SIP profiles via Lua XML handler — config changes need cache delete: rm /var/cache/fusionpbx/FusionPBX.configuration.sofia.conf
• Ext 1000 (Myron T48S), Ext 1001 (Tommy T48S), Ext 1002 (Myron AX86R), Ext 1003 (Kitchen T57W), Ext 1004 (Bedroom T57W)