After the initial boot screen, the following message is displayed: Press <Ctrl-P> to enter MEBx Setup.
Press Ctrl+P.
root@testwww:/var/www# aptitude update Hit http://deb.debian.org/debian buster InRelease Get: 1 http://deb.debian.org/debian buster-updates InRelease [51,9 kB] Err http://security.debian.org/debian-security buster/updates InRelease Cannot initiate the connection to debian.map.fastlydns.net:80 (2a04:4e42:62::644). - connect (101: Network is unreachable) Could not connect to debian.map.fastlydns.net:80 (199.232.138.132), connection timed out Cannot initiate the connection to security.debian.org:80 (2a04:4e42:200::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42:400::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42:600::644). - connect (101: Network is unreachable) Could not connect to security.debian.org:80 (151.101.66.132), connection timed out Could not connect to security.debian.org:80 (151.101.194.132), connection timed out Could not connect to security.debian.org:80 (151.101.130.132), connection timed out Could not connect to security.debian.org:80 (151.101.2.132), connection timed out Fetched 51,9 kB in 1min 1s (846 B/s) W: Failed to fetch http://security.debian.org/debian-security/dists/buster/updates/InRelease: Cannot initiate the connection to debian.map.fastlydns.net:80 (2a04:4e42:62::644). - connect (101: Network is unreachable) Could not connect to debian.map.fastlydns.net:80 (199.232.138.132), connection timed out Cannot initiate the connection to security.debian.org:80 (2a04:4e42:200::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42:400::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42::644). - connect (101: Network is unreachable) Cannot initiate the connection to security.debian.org:80 (2a04:4e42:600::644). - connect (101: Network is unreachable) Could not connect to security.debian.org:80 (151.101.66.132), connection timed out Could not connect to security.debian.org:80 (151.101.194.132), connection timed out Could not connect to security.debian.org:80 (151.101.130.132), connection timed out Could not connect to security.debian.org:80 (151.101.2.132), connection timed out W: Some index files failed to download. They have been ignored, or old ones used instead.
Rozwiązanie
chmod o+r /etc/resolv.conf
Występuje przy przełączaniu na php5.6 w ubuntu 20.
Rozwiązanie:
1. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'pass';
2. Na końcu pliku /etc/mysql/my.cnf dodać:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
default-authentication-plugin=mysql_native_password
redmine Cannot serve directory /opt/redmine/public/: No matching DirectoryIndex
cd /var/www/redmine gem install passenger passenger-install-apache2-module
Źródło: https://serverfault.com/questions/859256/redmine-with-apache-403-forbidden
net rpc -S 192.168.1.100 -U [username]%[password] shutdown -t 1 -f
Źródło: https://stackoverflow.com/questions/9936986/shutdown-windows-machine-from-linux-terminal
vim /etc/netplan/01-netcfg.yaml
network:
version: 2
renderer: networkd
ethernets:
ens3:
dhcp4: no
addresses:
- 192.168.121.199/24
gateway4: 192.168.121.1
nameservers:
addresses: [8.8.8.8, 1.1.1.1]
sudo netplan apply
źródło: https://linuxize.com/post/how-to-configure-static-ip-address-on-ubuntu-18-04/
sudo update-alternatives --set php /usr/bin/php7.4
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
aptitude install libreswan network-manager-l2tp network-manager-l2tp-gnome ike-scan
2. Check encryption
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
Ź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