Linux: различия между версиями

Материал из MediaWikiWelcom
Перейти к навигации Перейти к поиску
Строка 1: Строка 1:
 
<h3>Configuration Debian Linux:</h3>
 
<h3>Configuration Debian Linux:</h3>
<h5>After fresh install</h5>
+
<h5>Step 1</h5>
<h5>Change default editor</h5>
+
<h5>Step 2</h5>
  
<b>Some use steps</b>
+
<b>Step 1</b>
 
<li>apt install sudo vim  
 
<li>apt install sudo vim  
 
<li>export PATH=$PATH:/sbin
 
<li>export PATH=$PATH:/sbin
Строка 9: Строка 9:
 
<li>apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y
 
<li>apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y
 
<br>
 
<br>
 
+
<h5>Step 2</h5>
 +
<br>
 
<h3>Change default editor</h3>
 
<h3>Change default editor</h3>
 
<li>ls -l /etc/alternatives/editor
 
<li>ls -l /etc/alternatives/editor

Версия 12:02, 5 апреля 2022

Configuration Debian Linux:

Step 1
Step 2

Step 1

  • apt install sudo vim
  • export PATH=$PATH:/sbin
  • export PATH=$PATH:/usr/sbin
  • apt install htop tcpdump mc ncdu pydf pwgen nmap nmon atop hwinfo curl aptitude screen locate -y
    Step 2


    Change default editor

  • ls -l /etc/alternatives/editor
  • update-alternatives --config editor
  • Press <enter> to keep the current choice[*], or type selection number: 3 <choose 3>

    Confluence postgres examples queries

  • \dt все таблицы активной базы
  • SELECT * FROM cwd_user; вся таблица пользователей cwd_user
  • SELECT * FROM cwd_user WHERE active = 'F'; вся таблица активных пользователей cwd_user
  • SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; вся таблица пользователей cwd_user со столбцами...
  • SELECT * FROM logininfo; все данные таблицы logininfo
  • SELECT * FROM user_mapping; все данные таблицы user_mapping
  • SELECT * FROM cwd_user;
  • SELECT username FROM logininfo; username из столбца logininfo
  • SELECT successdate, username FROM logininfo WHERE successdate < '2022-01-01' ORDER BY successdate; List active users who have not logged in since a specific date
  • SELECT id, user_name, display_name, lower_display_name, external_id FROM cwd_user; по полям... из таблицы cwd_user
  • SELECT successdate, prevsuccessdate, faileddate, username FROM logininfo li WHERE successdate > '2022-01-01' ORDER BY successdate;
  • SELECT li.successdate, li.prevsuccessdate, li.faileddate, cu.user_name, display_name, cd.directory_name FROM logininfo li JOIN user_mapping um ON um.user_key = li.username JOIN cwd_user cu ON um.username = cu.user_name JOIN cwd_directory cd ON cu.directory_id = cd.ID WHERE successdate > '2022-01-01' ORDER BY successdate;
  • SELECT cu.user_name, cd.directory_name, prevsuccessdate, li.successdate, faileddate, display_name FROM logininfo li JOIN user_mapping um ON um.user_key = li.username JOIN cwd_user cu ON um.username = cu.user_name JOIN cwd_directory cd ON cu.directory_id = cd.id WHERE cd.directory_name = 'tps.local' and successdate < '2022-01-01' ORDER BY successdate;