Chatpion - Facebook Chatbot for E‑Commerce, SMS & Email Marketing

# Example SSH login
ssh [email protected]

# Ubuntu/Debian
apt update && apt install -y nginx php8.2 php8.2-fpm php8.2-mbstring php8.2-openssl php8.2-pdo php8.2-mysql composer unzip curl

# CentOS/AlmaLinux
dnf install -y epel-release
dnf install -y nginx php php-mbstring php-openssl php-pdo php-mysqlnd composer unzip curl

# Install UFW (Ubuntu)
apt install -y ufw
ufw allow OpenSSH
ufw allow 'Nginx Full'
ufw enable

-- Log into MySQL as root
mysql -u root -p

-- Create database
CREATE DATABASE chatpion_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Create user with strong password
CREATE USER 'chatpion_user'@'localhost' IDENTIFIED BY 'StrongP@ssw0rd!';

-- Grant privileges
GRANT ALL PRIVILEGES ON chatpion_db.* TO 'chatpion_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

# From the project root after extracting files
php artisan migrate --force

mysql -u chatpion_user -p chatpion_db < database/seeders/chatpion_initial.sql

# Use wget or curl to fetch the zip from your order
wget https://217g.com/downloads/chatpion.zip -O /tmp/chatpion.zip

# Assuming /var/www/html is your web root
unzip /tmp/chatpion.zip -d /var/www/html/chatpion

cd /var/www/html/chatpion
# Directories need write access for storage & cache
find . -type d -exec chmod 775 {} \;
# Files should be readable
find . -type f -exec chmod 664 {} \;
# Ensure the web server user (www-data or nginx) owns the files
chown -R www-data:www-data .

# Inside the project root
composer install --optimize-autoloader --no-dev

# If you need to compile assets (optional)
npm install
npm run prod

<IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^(.*)$ public/$1 [L]
</IfModule>

# Protect .env
<Files .env>
    Order allow,deny
    Deny from all
</Files>

server {
    listen 80;
    server_name chatpion.example.com;
    root /var/www/html/chatpion/public;

    index index.php;

    # Laravel pretty URLs
    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    # PHP handling
    location ~ \.php$ {
        include fastcgi_params;
        fastcgi_pass unix:/var/run/php/php8.2-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        fastcgi_param DOCUMENT_ROOT $realpath_root;
        internal;
    }

    # Security headers (optional)
    add_header X-Content-Type-Options nosniff;
    add_header X-Frame-Options SAMEORIGIN;
}

# Enable site and reload Nginx
ln -s /etc/nginx/sites-available/chatpion.conf /etc/nginx/sites-enabled/
nginx -t && systemctl reload nginx

apt install -y certbot python3-certbot-nginx
certbot --nginx -d chatpion.example.com

cp .env.example .env
php artisan key:generate

APP_NAME="Chatpion"
APP_ENV=production
APP_KEY=base64:GENERATED_KEY_HERE
APP_URL=https://chatpion.example.com

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=chatpion_db
DB_USERNAME=chatpion_user
DB_PASSWORD=StrongP@ssw0rd!

# Facebook Graph API
FACEBOOK_APP_ID=your_facebook_app_id
FACEBOOK_APP_SECRET=your_facebook_secret
FACEBOOK_PAGE_ID=your_page_id

# Twilio
TWILIO_SID=your_twilio_sid
TWILIO_TOKEN=your_twilio_auth_token
TWILIO_FROM=+1234567890

# SendGrid
SENDGRID_API_KEY=your_sendgrid_api_key
[email protected]
MAIL_FROM_NAME="Chatpion"

# Clear caches and optimize
php artisan config:cache
php artisan route:cache
php artisan view:cache