232 lines
8.0 KiB
PHP
Executable File
232 lines
8.0 KiB
PHP
Executable File
<!DOCTYPE html>
|
|
<html lang="pt-BR">
|
|
<head>
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<title>LEMP Stack - Docker</title>
|
|
<style>
|
|
* { margin: 0; padding: 0; box-sizing: border-box; }
|
|
body {
|
|
font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, Oxygen, Ubuntu, sans-serif;
|
|
line-height: 1.6;
|
|
color: #333;
|
|
max-width: 1200px;
|
|
margin: 0 auto;
|
|
padding: 20px;
|
|
background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
|
|
min-height: 100vh;
|
|
}
|
|
.container {
|
|
background: white;
|
|
border-radius: 12px;
|
|
padding: 40px;
|
|
margin: 20px 0;
|
|
box-shadow: 0 10px 30px rgba(0,0,0,0.2);
|
|
}
|
|
h1 {
|
|
color: #667eea;
|
|
margin-bottom: 20px;
|
|
font-size: 2.5em;
|
|
text-align: center;
|
|
}
|
|
.section {
|
|
background: #f8f9fa;
|
|
border-left: 4px solid #667eea;
|
|
padding: 20px;
|
|
margin: 20px 0;
|
|
border-radius: 0 8px 8px 0;
|
|
}
|
|
.status {
|
|
display: flex;
|
|
flex-wrap: wrap;
|
|
gap: 15px;
|
|
margin: 20px 0;
|
|
}
|
|
.status-item {
|
|
flex: 1;
|
|
min-width: 200px;
|
|
background: #e7f5ff;
|
|
border: 1px solid #74b9ff;
|
|
border-radius: 8px;
|
|
padding: 15px;
|
|
text-align: center;
|
|
}
|
|
.status-item.success {
|
|
background: #d4edda;
|
|
border-color: #28a745;
|
|
color: #155724;
|
|
}
|
|
.status-item h3 {
|
|
margin-bottom: 10px;
|
|
font-size: 1.2em;
|
|
}
|
|
.phpinfo {
|
|
margin-top: 30px;
|
|
padding: 20px;
|
|
background: #fff;
|
|
border: 1px solid #ddd;
|
|
border-radius: 8px;
|
|
}
|
|
pre {
|
|
background: #f4f4f4;
|
|
padding: 15px;
|
|
border-radius: 4px;
|
|
overflow-x: auto;
|
|
font-size: 14px;
|
|
}
|
|
code {
|
|
background: #f4f4f4;
|
|
padding: 2px 6px;
|
|
border-radius: 3px;
|
|
font-family: 'Courier New', monospace;
|
|
}
|
|
.footer {
|
|
text-align: center;
|
|
margin-top: 30px;
|
|
color: #666;
|
|
font-size: 0.9em;
|
|
}
|
|
</style>
|
|
</head>
|
|
<body>
|
|
<div class="container">
|
|
<h1>🐳 LEMP Stack no Docker</h1>
|
|
|
|
<div class="section">
|
|
<h2>Stack em Funcionamento</h2>
|
|
<p><strong>Linux</strong> + <strong>Nginx</strong> + <strong>MySQL/MariaDB</strong> + <strong>PHP-FPM</strong></p>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>Status dos Serviços</h2>
|
|
<div class="status">
|
|
<div class="status-item success">
|
|
<h3>✅ Nginx</h3>
|
|
<p>Porta 80</p>
|
|
</div>
|
|
<div class="status-item success">
|
|
<h3>✅ PHP-FPM</h3>
|
|
<p>PHP 8.3 (Ubuntu)</p>
|
|
</div>
|
|
<div class="status-item success">
|
|
<h3>✅ MariaDB</h3>
|
|
<p>Porta 3306</p>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>Teste de Conexão com Banco de Dados</h2>
|
|
<?php
|
|
// Configurações do banco (lidas do .env ou usar defaults)
|
|
$host = getenv('MYSQL_HOST') ?: 'mysql';
|
|
$dbname = getenv('MYSQL_DATABASE') ?: 'app_db';
|
|
$username = getenv('MYSQL_USER') ?: 'app_user';
|
|
$password = getenv('MYSQL_PASSWORD') ?: 'app_password';
|
|
|
|
try {
|
|
$pdo = new PDO(
|
|
"mysql:host=$host;dbname=$dbname;charset=utf8mb4",
|
|
$username,
|
|
$password,
|
|
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
|
|
);
|
|
|
|
echo "<p style='color: #28a745;'><strong>✅ Conexão com banco de dados bem-sucedida!</strong></p>";
|
|
echo "<p><strong>Host:</strong> $host</p>";
|
|
echo "<p><strong>Banco:</strong> $dbname</p>";
|
|
|
|
// Listar tabelas (se houver)
|
|
$stmt = $pdo->query("SHOW TABLES");
|
|
$tables = $stmt->fetchAll(PDO::FETCH_COLUMN);
|
|
|
|
if (count($tables) > 0) {
|
|
echo "<h3>Tabelas no banco:</h3><ul>";
|
|
foreach ($tables as $table) {
|
|
echo "<li><code>$table</code></li>";
|
|
}
|
|
echo "</ul>";
|
|
} else {
|
|
echo "<p><em>Nenhuma tabela encontrada. Execute o script de inicialização em <code>mysql/init.sql</code></em></p>";
|
|
}
|
|
|
|
} catch (PDOException $e) {
|
|
echo "<p style='color: #dc3545;'><strong>❌ Erro na conexão:</strong> " . $e->getMessage() . "</p>";
|
|
echo "<p><em>Verifique se o container MySQL está rodando e as credenciais no arquivo <code>.env</code></em></p>";
|
|
}
|
|
?>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>Informações do PHP</h2>
|
|
<div class="phpinfo">
|
|
<?php
|
|
// Informações básicas do PHP
|
|
echo "<h3>Versão do PHP</h3>";
|
|
echo "<p><strong>" . phpversion() . "</strong></p>";
|
|
|
|
echo "<h3>Extensiones Carregadas</h3>";
|
|
$extensions = get_loaded_extensions();
|
|
sort($extensions);
|
|
echo "<p>" . implode(", ", $extensions) . "</p>";
|
|
|
|
echo "<h3>Configurações Importantes</h3>";
|
|
echo "<ul>";
|
|
echo "<li><strong>memory_limit:</strong> " . ini_get('memory_limit') . "</li>";
|
|
echo "<li><strong>upload_max_filesize:</strong> " . ini_get('upload_max_filesize') . "</li>";
|
|
echo "<li><strong>post_max_size:</strong> " . ini_get('post_max_size') . "</li>";
|
|
echo "<li><strong>max_execution_time:</strong> " . ini_get('max_execution_time') . "s</li>";
|
|
echo "<li><strong>display_errors:</strong> " . (ini_get('display_errors') ? 'On' : 'Off') . "</li>";
|
|
echo "<li><strong>opcache.enable:</strong> " . (ini_get('opcache.enable') ? 'On' : 'Off') . "</li>";
|
|
echo "</ul>";
|
|
?>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="section">
|
|
<h2>Como Usar</h2>
|
|
<h3>1. Variáveis de Ambiente</h3>
|
|
<p>Crie um arquivo <code>.env</code> na raiz com suas configurações:</p>
|
|
<pre><code>MYSQL_ROOT_PASSWORD=sua_senha_root
|
|
MYSQL_DATABASE=app_db
|
|
MYSQL_USER=app_user
|
|
MYSQL_PASSWORD=sua_senha_app</code></pre>
|
|
|
|
<h3>2. Comandos Docker</h3>
|
|
<pre><code># Iniciar a stack
|
|
docker-compose up -d
|
|
|
|
# Parar a stack
|
|
docker-compose down
|
|
|
|
# Ver logs
|
|
docker-compose logs -f
|
|
|
|
# Reiniciar um serviço
|
|
docker-compose restart php
|
|
|
|
# Executarcomando no container
|
|
docker-compose exec php php -v
|
|
docker-compose exec mysql mysql -u app_user -p</code></pre>
|
|
|
|
<h3>3. Configuração Nginx</h3>
|
|
<p>Personalize em <code>nginx/conf.d/default.conf</code></p>
|
|
|
|
<h3>4. Configuração PHP</h3>
|
|
<p>Personalize em <code>php/php.ini</code></p>
|
|
</div>
|
|
|
|
<div class="footer">
|
|
<hr style="margin: 20px 0; border: none; border-top: 1px solid #ddd;">
|
|
<p><strong>Autor:</strong> Marco Costa</p>
|
|
<p><strong>Email:</strong> <a href="mailto:marcocosta@syspanel.com.br">marcocosta@syspanel.com.br</a></p>
|
|
<p><strong>Licença:</strong> MIT License</p>
|
|
<p><small>Copyright (c) 2026 - Uso livre para fins comerciais e não-comerciais</small></p>
|
|
<p style="margin-top: 15px; font-size: 0.85em; color: #999;">
|
|
LEMP Stack Docker - Powered by Nginx + PHP-FPM + MariaDB + Docker
|
|
</p>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html>
|