terça-feira, 10 de outubro de 2017

KASPERSKY SECURITY CENTER QUERY DATABASE

sexta-feira, 6 de outubro de 2017

HOW TO CLONE VIRTUAL MACHINE FROM ORACLE VM (VIRTUAL BOX)

After copy/ past your virtual machine, just open terminal and access the folder of virtual machine and execute this command:
VBoxManage internalcommands sethduuid <youmachine>.vdi

sexta-feira, 29 de setembro de 2017

HOW TO INSTALL GRAFANA IN UBUNTU 16.04 LTS AND INTEGRATE WITH GRAFANA

wget https://s3-us-west-2.amazonaws.com/grafana-releases/release/grafana_4.5.2_amd64.deb
sudo apt-get install -y adduser libfontconfig
sudo dpkg -i grafana_4.5.2_amd64.deb
sudo service grafana-server start
sudo update-rc.d grafana-server defaults
sudo systemctl enable grafana-server.service
http://<yourip>:3000/login

for access your grafana server :
http://<your.ip>:3000

default user: admin
defaul pass: admin

for integration with zabbix execute:

sudo grafana-cli plugins list-remote

sudo grafana-cli plugins install alexanderzobnin-zabbix-app




plugins granafa installed:

grafana-cli plugins install raintank-worldping-app


terça-feira, 26 de setembro de 2017

HOW TO GRANT REMOTE ACCESS ON MYSQL 14.14 AND UBUNTU 16.04 LTS

Access you mysql server by terminal :
vi /etc/mysql/mysql.conf.d/mysqld.cnf
comment the line:

from: bind-address = 127.0.0.1
for: #bind-address = 127.0.0.1

execute: service mysql restart

after that, connect on your mysql server and execute this command: 

GRANT ALL PRIVILEGES ON *.* TO '<YOURUSERNAME>'@'<YOUIPD>' IDENTIFIED BY '<YOUPASSWORD>' WITH GRANT OPTION;



SHOW GRANTS;

LINUX COMMANDS

In terminal execute vi and if you want copy past line execute: Y Y P
For include start service: update-rc.d <linux service> enable/disable
For list services for list to start automatically: ls /etc/rc*.d
For check distr:  lsb_release -a

HOW TO USE SQLCMD ON UBUNTU FOR QUERY MICROSOFT SQL

First
apt-get install  -y libgss3
After   download the mssodbc
execute download  https://mega.nz/#!zM9x3DLZ

key for download:

!jFEs2CIynSBWLDMwmctXJsMM35DeIPn24EQj1rbQzWM


tar -zxvf msodbcsql-13.0.0.0.tar.gz

access the folder msodbcsql-13.0.0.0 for check if there are some library missing for start the instalation. execute this command:

ldd /lib64/libmsodbcsql-13.0.so.0.0



If there is no missing lib execute:


Accept the terms and waiting the installation.

After installation finish eheck if there is a lib msql installed:


For execute the test follow the command syntax:

detail syntax:

sqlcmd -S <yourserver>\\<yourdatabase>,<yourportsql> -U <youruser> -P <yourpassword> -i <yourscriptsql>.sql

Normaly the script sql is your query sql





segunda-feira, 18 de setembro de 2017

HOW TO ALLOW ACCESS TO ENTERPRISE ONX SAT SYSTEM

server_onix_sat  189.113.152.153
            189.113.149.200
            189.113.149.70 8080


onix_sat 80 tcp
              5398 tcp

urls:

www.google-analytics.com
maplink.uol.com.br
www.onixsat.com.br
go.onixsat.com.br
arquivos.onixsat.com.br
enterprise.onixsat.com.br
lbs.onixsat.com.br
service.onixsat.com.br
transito.lbslocal.com

source: http://enterprise.onixsat.com.br/conn-tutorial/?linkid=80001

sábado, 16 de setembro de 2017

HOW TO FIX "I CANT DELETE ANY FILES" MY USER IS ROOT (SUDOERS) BUT ICAN'T DELETE ANY FILES

When was detect this problem "icant delete any file"
was reboted my host, after that was detect the message  busybox-built-in-shell and following this commands:
https://vi4nn4network.blogspot.com.br/2017/09/how-to-fix-error-busybox-built-in-shell.html

HOW TO FIX ERROR BUSYBOX BUILT-IN SHELL (INITRAMFS) ON EVERY BOOT

execute:
after this message put:

fsck /dev/sda1