Error ao conectar no Firebird Análise: Ao verificar o log do firebird idetificado erro xinetd per_source limit issues Causa Excedido o número de conexões. Solução Ao analisar o /etc/xinetd.conf verificado que o per_source estava padrão
|
1 |
per_source = 10 |
Aumentar o per_source
|
1 2 3 4 5 |
per_source = 100 ou per_source = UNLIMITED |
Resolvido!
Erro ao Conectar client OpenVPN Gui Windows 7/8/10
|
1 |
ROUTE: route addition failed using CreateIpForwardEntry: The parameter is incorrect. [status=87 if_index=14] |
Resolvendo Adicione as seguintes linhas no conf do client.
|
1 2 |
route-method exe route-delay |
Erro ao criar uma database teste no SQL Server
|
1 2 |
CREATE DATABASE TESTE2 GO |
Erro
|
1 2 3 4 |
Msg 1807, Level 16, State 3, Line 1 Could not obtain exclusive lock on database 'model'. Retry the operation later. Msg 1802, Level 16, State 4, Line 1 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. |
Solução Tinha outra seção lockando a database ‘model’
Erro ao tentar criar a tabela criptografada
|
1 2 3 4 5 |
mysql> CREATE TABLE faturamento (empresa varchar(50), fatura int) ENGINE=InnoDB ENCRYPTION='Y'; ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring plugin is loaded and initialized successfully. |
Verificando plugin instalado
|
1 2 3 4 5 6 7 |
mysql> show variables like '%keyring%'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | keyring_operations | ON | +--------------------+-------+ 1 row in set (0.00 sec) |
Instalando o plugin ‘keyring_file.so’
|
1 2 |
mysql> install plugin keyring_file soname 'keyring_file.so'; Query OK, 0 rows affected (0.01 sec) |
Verificando plugin instalado
|
1 2 3 4 5 6 7 8 |
mysql> show variables like '%keyring%'; +--------------------+--------------------------------+ | Variable_name | Value | +--------------------+--------------------------------+ | keyring_file_data | /var/lib/mysql-keyring/keyring | | keyring_operations | ON | +--------------------+--------------------------------+ 2 rows in set (0.00 sec) |
Criando tabela criptografada
|
1 2 3 |
mysql> CREATE TABLE faturamento (empresa varchar(50), fatura int) -> ENGINE=InnoDB ENCRYPTION='Y'; Query OK, 0 rows affected (0.01 sec) |
ERROR 1290 ao exportar para .csv
|
1 2 3 4 5 6 7 |
mysql> SELECT * FROM alunos INTO OUTFILE '/tmp/alunos.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n'; ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement |
Edite o arquivo /etc/my.cnf Adicione a linha
|
1 |
secure-file-priv = "" |
Exportando novamente
|
1 2 3 4 5 6 7 |
mysql> SELECT * FROM alunos -> INTO OUTFILE '/tmp/alunos.csv' -> FIELDS ENCLOSED BY '"' -> TERMINATED BY ';' -> ESCAPED BY '"' -> LINES TERMINATED BY '\r\n'; Query OK, 8000 rows affected (0.00 sec |
Resolvido!