apt-get update apt-get install software-properties-common apt-add-repository 'deb http://security.debian.org/debian-security stretch/updates main' apt-get update apt-get install openjdk-8-jdk
apt-get update apt-get install aptitude vim nmap mc screen screenfetch dfc sudo unzip rsync rpm gcc make
sudo visudo
username ALL=NOPASSWD:ALL
sudo dpkg-reconfigure locales
Install Java 8
https://blog.cssoft.pl/post/java-8-install-od-debian-10
wget -c https://download.acronis.com/AcronisCyberProtect15/Release/AcronisCyberProtect_15_64-bit.x86_64
chmod +x AcronisCyberProtect_15_64-bit.x86_64 ./AcronisCyberProtect_15_64-bit.x86_64
After instalation use your root credentials to login to admin panel
http://10.20.30.40:9877
Install agent
Linux:
wget -c https://download.acronis.com/AcronisCyberProtect15/Release/AcronisCyberProtect_15_64-bit.x86_64
chmod +x AcronisCyberProtect_15_64-bit.x86_64 ./AcronisCyberProtect_15_64-bit.x86_64
Windows:
https://download.acronis.com/AcronisCyberProtect15/Release/AcronisCyberProtect_15_64-bit.exe
mkdir -p /scripts/photo
vim /scripts/photo_every_hour.sh
DATE=`date "+%Y.%m.%d_%H.%M.%S"` DAY=`date "+%Y.%m.%d"` mkdir -p /scripts/photo/$DAY /usr/bin/raspistill -n -rot 90 -o /scripts/photo/$DAY/photo_$DATE.jpg rsync -aogv --log-file=/scripts/RSYNC_LOGS/rsync_photo_$DATE.log /scripts/photo/* pizero@192.168.1.100:/data/pizero/photo/
crontab -e
0 * * * * /scripts/photo_every_hour.sh
ob_start(); var_dump($data); $result = ob_get_clean();
1. Instalacja podstawowych paczek i konfiguracja
apt-get update apt-get install aptitude vim nmap mc screen screenfetch dfc sudo unzip rsync net-tools xvfb cifs-utils libqtwebkit4 ldap-utils libsasl2-modules-gssapi-mit winbind snmp samba odbcinst libodbc1 dpkg-dev
sudo visudo
username ALL=NOPASSWD:ALL
sudo dpkg-reconfigure locales
Zobacz całość
$this->db->where('user_status', NULL);
$query_1 = $this->db->get_compiled_select('users');
$this->db->where('user_status', 'inactive');
$query_2 = $this->db->get_compiled_select('users');
$query_union = $this->db->query($query_1 . " UNION " . $query_2);
https://stackoverflow.com/questions/2040655/union-query-with-codeigniters-active-record-pattern
1. Dodaj repo mysql do APT
aptitude update aptitude install gnupg wget https://dev.mysql.com/get/mysql-apt-config_0.8.16-1_all.deb #wget https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb #dpkg -i mysql-apt-config_0.8.16-1_all.deb dpkg -i mysql-apt-config* aptitude update
2. Zainstaluj MySQL Server
#aptitude install mysql-community-server aptitude install mysql-server
"Use Legacy Authentication Method"
3. Uruchom usługę
systemctl status mysql.service
4. Ustaw hasło roota do mysql
mysql_secure_installation
5. Sprawdzamy info o mysql-server
mysqladmin -u root -p version
https://www.digitalocean.com/community/tutorials/how-to-install-the-latest-mysql-on-debian-10
#https://serverspace.io/support/help/how-to-install-mysql-on-debian-10/
dnf remove libreswan
dnf remove strongswan
dnf install strongswan
systemctl stop xl2tpd.service
https://ask.fedoraproject.org/t/cannot-connect-to-vpn/5602/34
nm-applet
albo
aptitude install plasma-nm plasma-nm
https://askubuntu.com/questions/963847/missing-network-settings-in-kde
1. Install packages
sudo aptitude install libreswan network-manager-l2tp network-manager-l2tp-gnome ike-scan
2. Check encryption
sudo service xl2tp stop
ike-scan 10.20.30.40
Starting ike-scan 1.9.4 with 1 hosts (http://www.nta-monitor.com/tools/ike-scan/)
10.20.30.40 Main Mode Handshake returned HDR=(CKY-R=0305c49ff43d987b) SA=(Enc=3DES Hash=SHA1 Auth=PSK Group=2:modp1024 LifeType=Seconds LifeDuration(4)=0x00007080)
3. Add VPN Connection
Layer 2 Tunneling Protocol (L2TP)
Name: My VPN
Gateway: 10.20.30.40
User name: username@domain.com
Password: *****
4. IPsec Settings
[+] Enable IPsec tunnel to L2TP host
[Advanced]
Phase1 Algorithms: 3des-sha1-modp1024
Phase2 Algorithms: 3des-sha1
[OK]
5. Disable xl2tp service
sudo systemctl disable xl2tpd
6. Connect to VPN
7. If not connecting
sudo aptitude purge libreswan sudo aptitude install strongswan
Źródło: https://askubuntu.com/questions/904217/unable-to-connect-l2tp-ipsec-vpn-from-ubuntu-16-04
SELECT pagename, COUNT(DISTINCT ipaddress) AS visit_count FROM log_visitors GROUP BY pagename ORDER BY visit_count DESC;
Źródło: https://stackoverflow.com/questions/1841426/is-it-possible-to-group-by-multiple-columns-using-mysql
vim system/helpers/url_helper.php
Change this:
function current_url()
{
$CI =& get_instance();
return $CI->config->site_url($CI->uri->uri_string());
}
into that:
function current_url()
{
$CI =& get_instance();
return $CI->config->site_url($CI->uri->uri_string()). (isset($_SERVER['QUERY_STRING']) ? '?' . $_SERVER['QUERY_STRING'] : '');
} W php 7.4 jest problem jeśli w treści komórki wstawiamy integer.
Daje wówczas taki błąd:
Severity: Notice Message: Trying to access array offset on value of type int Filename: Cell/DefaultValueBinder.php
Trzeba go zamienić na string i jest ok.
Było:
'A' . $cell_index => array($lp),
Ma być:
'A' . $cell_index => array(strval($lp)),
1. Default configuration
System -> Reset Configuration -> [check] No Default Configuration -> [Reset Configuration]
System -> Users -> [admin] -> Password -> ***** -> [OK]
System -> Identity -> [MyMikrotik] -> [OK]
System -> Clock
Time: [current time]
Date: [current date]
Time Zone Name: Europe/Warsaw
Zobacz całośćGmail nie pozwala na dostęp z "mniej bezpiecznych aplikacji" jaką jest php-imap.
Żeby zezwolić na ten dostęp należy:
1. Zalogować się na swoje konto - https://accounts.google.com
2. Zezwolić na dostęp mniej bezpiecznych aplikacji - https://myaccount.google.com/lesssecureapps
3. Zezwolić swojej aplikacji na dostęp do konta - https://accounts.google.com/b/0/DisplayUnlockCaptcha
Wciśnij "cmd + s" podczas uruchamiania.
Wpisz w wierszu poleceń:
mount -uw / rm /var/db/.applesetupdone shutdown -h now
Uruchom ponownie.
Przeklikaj podstawową konfigurację.
Po zalogowaniu wejdź do Menu -> System Preferences -> Users & Groups
Kliknij w "Lock".
Wybierz użytkownika i zmień hasło.
https://www.wikigain.com/reset-macos-high-sierra-password-macbook-pro-air/
Go to BIOS.
Get computer serial number (example 1234567-595B).
Go to https://bios-pw.org/
Put your serial number and click "Get password".
You will get something like this: "Dell from serial number: UbRv8meGbVzr502t"
Go to BIOS.
Enter admin password (UbRv8meGbVzr502t).
Hit "Ctrl + Enter" (important!). Just "Enter" won't work.
Type new password and save.
aptitude install ipmitool
ipmitool user list
ipmitool user set password [id] [password]
https://support.oneidentity.com/kb/261220/reset-the-bmc-ipmi-password