Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/lavocat.quebec/public_html/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

# Working Configuration - lavocat.quebec

**Last Updated:** Oct 20, 2025 - 15:47 EDT

## ✅ What's Working Now

### 1. Static Assets
- **Location**: `/_next/static/css/`, `/_next/static/chunks/`, etc.
- **Fixed**: Moved all files from `/_next/` to `/_next/static/` subdirectory
- CSS and JavaScript now loading correctly

### 2. Database
- **Type**: SQLite (NOT MySQL!)
- **File**: `/home/gositeme/domains/lavocat.quebec/public_html/prisma/dev.db`
- **Size**: 1.8MB with data
- **Users**: 20 total (2 SUPERADMIN, 1 ADMIN, 17 LAWYERS)

### 3. Server Setup
- **Node.js**: Running on port 3000 (http://127.0.0.1:3000)
- **Apache**: Proxies `/api/*` to Node server
- **Static HTML**: Served directly by Apache

### 4. Login Credentials (Test)
```
Email: admin@example.com
Password: admin123
```

OR 

```
Email: dannywperez@msn.com  
Password: (check with user)
```

## Configuration Files

### .htaccess (Active)
```apache
RewriteEngine On

# Handle _next static assets
RewriteCond %{REQUEST_URI} ^/_next/
RewriteRule ^_next/(.*)$ /_next/$1 [L]

# Map specific React routes to actual HTML files
RewriteRule ^business-profiles/?$ /profiles.html [L]
RewriteRule ^judicial-directory/?$ /judicial-directory.html [L]
RewriteRule ^live-cases/?$ /live-cases.html [L]
RewriteRule ^about/?$ /about.html [L]

# Handle PHP migration routes
RewriteCond %{REQUEST_URI} ^/php-migration/
RewriteRule ^php-migration/(.*)$ /php-migration/$1 [L]

# Proxy API routes to Node.js server on port 3000
RewriteCond %{REQUEST_URI} ^/api/
RewriteRule ^api/(.*)$ http://127.0.0.1:3000/api/$1 [P,L]

# Serve existing files directly, fallback to index.html
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !^/php-migration/
RewriteCond %{REQUEST_URI} !^/api/
RewriteCond %{REQUEST_URI} !^/_next/
RewriteRule ^(.*)$ /index.html [L]
```

### prisma/schema.prisma
```prisma
datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}
```

### .env.production
```
DATABASE_URL="mysql://..." # NOT USED - Using SQLite instead
NEXTAUTH_URL=https://lavocat.quebec
NEXTAUTH_SECRET=jKp8mN2vQ5wX9zA4bC7dE1fG3hJ6kL8mN0pR2sT5vW8xY1zA4bC7
```

## How to Start Server

```bash
cd /home/gositeme/domains/lavocat.quebec/public_html
npx next start -p 3000 > server.log 2>&1 &
```

## Testing APIs

```bash
# Live cases stats
curl https://lavocat.quebec/api/live-cases/stats

# Login test
curl -X POST https://lavocat.quebec/api/auth/login \
  -H "Content-Type: application/json" \
  -d '{"email":"admin@example.com","password":"admin123"}'
```

## Next Steps
1. Fix NextAuth configuration for proper session handling
2. Test login page at https://lavocat.quebec/auth/login.html
3. Test live-cases page at https://lavocat.quebec/live-cases
4. Verify group chat functionality