Olá, boa noite.
Estou tentando conectar com o mysqldb mas fica dando falha e eu não estou entendendo o motivo, alguém pode ajudar? Segue os arquivos:
Vagrantfile
$script_mysql = <<-SCRIPT
apt-get update && \
apt-get install -y mysql-server-5.7 && \
mysql -e "create user 'phpuser'@'%' identified by 'pass';"
SCRIPT
Vagrant.configure("2") do |config|
config.vm.box = "ubuntu/bionic64"
config.vm.define "mysqldb" do |mysql|
mysql.vm.network "public_network", ip: "192.168.1.24"
mysql.vm.provision "shell",
inline: "cat /configs/id_bionic.pub >> .ssh/authorized_keys"
mysql.vm.provision "shell", inline: $script_mysql
mysql.vm.provision "shell",
inline: "cat /configs/mysqld.cnf > /etc/mysql/mysql.conf.d/mysqld.cnf"
mysql.vm.provision "shell", inline: "service mysql restart"
mysql.vm.synced_folder "./configs", "/configs"
mysql.vm.synced_folder ".", "/vagrant", disabled: true
end
config.vm.define "phpweb" do |phpweb|
phpweb.vm.network "forwarded_port", guest: 8888, host: 8888
phpweb.vm.network "public_network", ip: "192.168.1.25"
phpweb.vm.provision "shell",
inline: "apt-get update && apt-get install -y puppet"
phpweb.vm.provision "puppet" do |puppet|
puppet.manifests_path = "./configs/manifests"
puppet.manifest_file = "phpweb.pp"
end
end
end
phpweb.pp
# execute 'apt-get update'
exec { 'apt-update':
command => '/usr/bin/apt-get update'
}
exec { 'run-php7':
require => Package['php7.2'],
command => '/usr/bin/php -S 0.0.0.0:8888 -t /vagrant/src &'
}
package { ['php7.2', 'php7.2-mysql']:
require => Exec['apt-update'],
ensure => installed,
}
index.php
<?php
echo "Testando conexao <br /> <br />";
$servername = "192.168.1.24";
$username = "phpuser";
$password = "pass";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Conexão falhou: " . $conn->connect_error);
}
echo "Conectado com sucesso";
?>