Stackposts - Social Media Auto Posting & Scheduling Tool

# Update packages
sudo apt update && sudo apt upgrade -y

# Install required software
sudo apt install -y nginx php8.2 php8.2-fpm php8.2-mysql php8.2-xml php8.2-mbstring php8.2-bcmath php8.2-zip unzip git composer nodejs npm mysql-server

# Verify versions
php -v
nginx -v
node -v
npm -v

sudo mysql -u root -p

CREATE DATABASE stackposts CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'sp_user'@'127.0.0.1' IDENTIFIED BY 'StrongP@ssw0rd!';
GRANT ALL PRIVILEGES ON stackposts.* TO 'sp_user'@'127.0.0.1';
FLUSH PRIVILEGES;
EXIT;

# Navigate to the web root (cPanel: public_html or VPS: /var/www/html)
cd /var/www/html

# If you have a zip file from the vendor
unzip stackposts.zip -d stackposts
# Or clone from a private repo
git clone https://github.com/your‑repo/stackposts.git

cd stackposts
composer install --no-dev --optimize-autoloader

npm ci
npm run prod   # Generates minified CSS/JS for production

# Apply permissions recursively
sudo chown -R www-data:www-data /var/www/html/stackposts
find /var/www/html/stackposts -type d -exec chmod 775 {} \;
find /var/www/html/stackposts -type f -exec chmod 664 {} \;
chmod 640 /var/www/html/stackposts/.env

# /etc/nginx/sites-available/stackposts.conf
server {
    listen 80;
    server_name app.yourdomain.com;
    root /var/www/html/stackposts/public;

    index index.php;
    charset utf-8;
    gzip on;
    gzip_types text/css application/javascript image/svg+xml;

    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }

    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;
        fastcgi_intercept_errors on;
        fastcgi_buffers 16 16k;
    }

    # Security headers
    add_header X-Content-Type-Options nosniff;
    add_header X-Frame-Options SAMEORIGIN;
    add_header Referrer-Policy strict-origin-when-cross-origin;
}

sudo ln -s /etc/nginx/sites-available/stackposts.conf /etc/nginx/sites-enabled/
sudo nginx -t && sudo systemctl reload nginx

# /etc/apache2/sites-available/stackposts.conf
<VirtualHost *:80>
    ServerName app.yourdomain.com
    DocumentRoot /var/www/html/stackposts/public

    <Directory /var/www/html/stackposts/public>
        AllowOverride All
        Require all granted
    </Directory>

    ErrorLog ${APACHE_LOG_DIR}/stackposts_error.log
    CustomLog ${APACHE_LOG_DIR}/stackposts_access.log combined
</VirtualHost>

sudo a2ensite stackposts.conf
sudo a2enmod rewrite
sudo systemctl restart apache2

cp .env.example .env

APP_NAME=Stackposts
APP_ENV=production
APP_KEY=base64:GENERATED_KEY_HERE
APP_DEBUG=false
APP_URL=https://app.yourdomain.com

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=stackposts
DB_USERNAME=sp_user
DB_PASSWORD=StrongP@ssw0rd!

CACHE_DRIVER=file
QUEUE_CONNECTION=database
SESSION_DRIVER=file

php artisan key:generate

php artisan migrate --force
php artisan db:seed --force   # Optional default data

location ~* \.(js|css|png|jpg|jpeg|svg|gif)$ {
    expires 1y;
    add_header Cache-Control "public, immutable";
}

# /etc/systemd/system/stackposts-queue.service
[Unit]
Description=Laravel Queue Worker for Stackposts
After=network.target

[Service]
User=www-data
Group=www-data
Restart=always
ExecStart=/usr/bin/php /var/www/html/stackposts/artisan queue:work --sleep=3 --tries=3

[Install]
WantedBy=multi-user.target