Skip to content

Instantly share code, notes, and snippets.

@carliedu

carliedu/quickStart.php

Last active February 19, 2021 22:01
Show Gist options
  • Save carliedu/b9bdf07df3b9a3b3f044355790480077 to your computer and use it in GitHub Desktop.
Save carliedu/b9bdf07df3b9a3b3f044355790480077 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL problem
Raw
quickStart.php
<?php
error_reporting(E_ALL);
define("HSMN_corCliDefault", "\033[39m\033[49m");
define("HSMN_corCliAzul", "\033[104m\033[97m");
define("HSMN_corCliVerde", "\033[102m\033[97m");
define("HSMN_corCliAmarelo", "\033[103m\033[30m");
define("HSMN_corCliVermelho", "\033[101m\033[97m");
echo(date("d/m/Y-G:i:s")." (/quickStart.php) ".HSMN_corCliAzul."*---".
"INI---INI---INI---INI---INI---INI---INI---INI---INI---INI---INI---".
HSMN_corCliDefault."\n");
use React\MySQL\Factory;
use React\MySQL\QueryResult;
require __DIR__ . '/vendor/autoload.php';
$loop = React\EventLoop\Factory::create();
$factory = new Factory($loop);
$uri = 'localhost/test';
$connection = $factory->createLazyConnection($uri);
echo(date("d/m/Y-G:i:s")." (/quickStart.php) Criou LazyConnection\n");
echo(date("d/m/Y-G:i:s")." (/quickStart.php) Vai select\n");
$connection->query('SELECT * FROM test')->then(
function (QueryResult $command) {
echo(date("d/m/Y-G:i:s")." (/quickStart.php) QueryResult\n");
print_r($command->resultFields);
print_r($command->resultRows);
echo "\n".Count($command->resultRows) . ' row(s) in set' ."\n";
},
function (Exception $error) {
echo(date("d/m/Y-G:i:s")." (/quickStart.php) ERRO\n");
echo 'Error: [' . $error->getMessage() ."]\n";
}
);
echo(date("d/m/Y-G:i:s")." (/quickStart.php) Connection-quit\n");
$connection->quit();
$loop->run();
echo(date("d/m/Y-G:i:s")." (/quickStart.php) FIM\n");
?>
------------------Result on console:
root@aws:/usr/local/src/clueMysql# php quickStart.php
19/02/2021-22:41:13 (/quickStart.php) *---INI---INI---INI---INI---INI---INI---INI---INI---INI---INI---INI---
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Instanciou metodo __construct(LOOP, CONNECTOR)
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Instancia Connector(LOOP)
19/02/2021-22:41:13 (/vendor/react/socket/src/Connector.php) Instanciou metodo __construct(LOOP, ARRAY)
19/02/2021-22:41:13 (/vendor/react/socket/src/TcpConnector.php) Instancia __construct(LOOP, CONTEXT)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnector.php) Instanciou metodo __construct(LOOP, CONNECTOR, RESOLVER)
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Instanciou metodo createLazyConnection(localhost/test)
19/02/2021-22:41:13 (/quickStart.php) Criou LazyConnection
19/02/2021-22:41:13 (/quickStart.php) Vai select
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Instanciou metodo createConnection(localhost/test)
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Param.conex: host=[localhost] scheme=[mysql]
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) connecting=this->connector->connect(localhost:3306...
19/02/2021-22:41:13 (/vendor/react/socket/src/Connector.php) Instanciou metodo connect(localhost:3306)
19/02/2021-22:41:13 (/vendor/react/socket/src/Connector.php) isset(1)
19/02/2021-22:41:13 (/vendor/react/socket/src/Connector.php) vai connect (localhost:3306)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnector.php) Instanciou metodo connect(localhost:3306)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnector.php) Vai instanciar metodo HappyEyeBallsConnectionBuilder(LOOP, CONNECTOR, RESOLVER, URI, HOST, PATRS)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo __construct(LOOP, CONNECTOR, RESOLVER, localhost:3306, localhost, PARTS)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo connect()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Passou aqui
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo resolve(TYPE, REJECT)
19/02/2021-22:41:13 (/react/dns/src/Query/Query.php.php) Instanciou o metodo __construct(NAME, TYPE, CLASS
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo __construct(CANCELLER)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo __construct(CANCELLER)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo resolve(TYPE, REJECT)
19/02/2021-22:41:13 (/react/dns/src/Query/Query.php.php) Instanciou o metodo __construct(NAME, TYPE, CLASS
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo __construct(CANCELLER)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Conectou no host [localhost]
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) Vai instanciar Deferred
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo __construct(CANCELLER)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/quickStart.php) Connection-quit
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo parseMessage(DATA)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo parse(DATA, MESSAGE)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo parseQuestion(MESSAGE)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo readLabel(DATA, CONSUMED)
19/02/2021-22:41:13 (/react/dns/src/Query/Query.php.php) Instanciou o metodo __construct(NAME, TYPE, CLASS
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo parseRecord(MESSAGE)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo readDomain(DATA, CONSUMED)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo readLabel(DATA, CONSUMED)
19/02/2021-22:41:13 (/react/dns/src/Protocol/Parser.php) Instanciou metodo readLabel(DATA, CONSUMED)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo resolve(VALUE)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo resolve(VALUE)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo mixIpsIntoConnectQueue(IPS)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo check(RESOLVE, REJECT)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo attemptConnection(::1)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo resolve(VALUE)
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo mixIpsIntoConnectQueue(IPS)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Exception
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo check(RESOLVE, REJECT)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo attemptConnection(127.0.0.1)
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo hasBeenResolved()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Exception
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo hasBeenResolved()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo cleanup()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo error()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo hasBeenResolved()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) IF failurecount [Connection to localhost:3306 failed: Last error for IPv4: Connection to tcp://127.0.0.1:3306?hostname=localhost failed: Connection refused. Previous error for IPv6: Connection to tcp://[::1]:3306?hostname=localhost failed: Connection refused]
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo error()
19/02/2021-22:41:13 (/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php) Instanciou metodo hasBeenResolved()
19/02/2021-22:41:13 (/vendor/react/mysql/src/Factory.php) error-deferred
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo reject(RuntimeException: Connection to localhost:3306 failed: Last error for IPv4: Connection to tcp://127.0.0.1:3306?hostname=localhost failed: Connection refused. Previous error for IPv6: Connection to tcp://[::1]:3306?hostname=localhost failed: Connection refused in /usr/local/src/clueMysql/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php:210
Stack trace:
#0 /usr/local/src/clueMysql/vendor/react/promise/src/RejectedPromise.php(28): React\Socket\HappyEyeBallsConnectionBuilder->React\Socket\{closure}(Object(RuntimeException))
#1 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(134): React\Promise\RejectedPromise->then(Object(Closure), Object(Closure))
#2 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(168): React\Promise\Promise::React\Promise\{closure}(Object(React\Promise\RejectedPromise))
#3 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(148): React\Promise\Promise->settle(Object(React\Promise\RejectedPromise))
#4 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(237): React\Promise\Promise->reject(Object(RuntimeException))
#5 /usr/local/src/clueMysql/vendor/react/socket/src/TcpConnector.php(104): React\Promise\Promise::React\Promise\{closure}(Object(RuntimeException))
#6 /usr/local/src/clueMysql/vendor/react/event-loop/src/StreamSelectLoop.php(253): React\Socket\TcpConnector->React\Socket\{closure}(Resource id #77)
#7 /usr/local/src/clueMysql/vendor/react/event-loop/src/StreamSelectLoop.php(212): React\EventLoop\StreamSelectLoop->waitForStreamActivity(59997714)
#8 /usr/local/src/clueMysql/quickStart.php(39): React\EventLoop\StreamSelectLoop->run()
#9 {main}
Next RuntimeException: Unable to connect to database server in /usr/local/src/clueMysql/vendor/react/mysql/src/Factory.php:214
Stack trace:
#0 /usr/local/src/clueMysql/vendor/react/promise/src/RejectedPromise.php(28): React\MySQL\Factory->React\MySQL\{closure}(Object(RuntimeException))
#1 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(134): React\Promise\RejectedPromise->then(Object(Closure), Object(Closure))
#2 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(168): React\Promise\Promise::React\Promise\{closure}(Object(React\Promise\RejectedPromise))
#3 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(148): React\Promise\Promise->settle(Object(React\Promise\RejectedPromise))
#4 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(237): React\Promise\Promise->reject(Object(RuntimeException))
#5 /usr/local/src/clueMysql/vendor/react/promise/src/RejectedPromise.php(42): React\Promise\Promise::React\Promise\{closure}(Object(RuntimeException))
#6 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(135): React\Promise\RejectedPromise->done(Object(Closure), Object(Closure), Object(Closure))
#7 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(168): React\Promise\Promise::React\Promise\{closure}(Object(React\Promise\RejectedPromise))
#8 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(148): React\Promise\Promise->settle(Object(React\Promise\RejectedPromise))
#9 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(237): React\Promise\Promise->reject(Object(RuntimeException))
#10 /usr/local/src/clueMysql/vendor/react/promise-timer/src/functions.php(37): React\Promise\Promise::React\Promise\{closure}(Object(RuntimeException))
#11 /usr/local/src/clueMysql/vendor/react/promise/src/RejectedPromise.php(28): React\Promise\Timer\{closure}(Object(RuntimeException))
#12 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(134): React\Promise\RejectedPromise->then(Object(Closure), Object(Closure))
#13 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(168): React\Promise\Promise::React\Promise\{closure}(Object(React\Promise\RejectedPromise))
#14 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(148): React\Promise\Promise->settle(Object(React\Promise\RejectedPromise))
#15 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(237): React\Promise\Promise->reject(Object(RuntimeException))
#16 /usr/local/src/clueMysql/vendor/react/socket/src/HappyEyeBallsConnectionBuilder.php(210): React\Promise\Promise::React\Promise\{closure}(Object(RuntimeException))
#17 /usr/local/src/clueMysql/vendor/react/promise/src/RejectedPromise.php(28): React\Socket\HappyEyeBallsConnectionBuilder->React\Socket\{closure}(Object(RuntimeException))
#18 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(134): React\Promise\RejectedPromise->then(Object(Closure), Object(Closure))
#19 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(168): React\Promise\Promise::React\Promise\{closure}(Object(React\Promise\RejectedPromise))
#20 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(148): React\Promise\Promise->settle(Object(React\Promise\RejectedPromise))
#21 /usr/local/src/clueMysql/vendor/react/promise/src/Promise.php(237): React\Promise\Promise->reject(Object(RuntimeException))
#22 /usr/local/src/clueMysql/vendor/react/socket/src/TcpConnector.php(104): React\Promise\Promise::React\Promise\{closure}(Object(RuntimeException))
#23 /usr/local/src/clueMysql/vendor/react/event-loop/src/StreamSelectLoop.php(253): React\Socket\TcpConnector->React\Socket\{closure}(Resource id #77)
#24 /usr/local/src/clueMysql/vendor/react/event-loop/src/StreamSelectLoop.php(212): React\EventLoop\StreamSelectLoop->waitForStreamActivity(59997714)
#25 /usr/local/src/clueMysql/quickStart.php(39): React\EventLoop\StreamSelectLoop->run()
#26 {main})
19/02/2021-22:41:13 (/vendor/react/promise/src/Deferred.php) Instanciou metodo promise()
19/02/2021-22:41:13 (/quickStart.php) ERRO
Error: [Unable to connect to database server]
19/02/2021-22:41:13 (/quickStart.php) FIM
root@aws:/usr/local/src/clueMysql#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment