Where do you store information about your hosts and ports on linux?

Question

SSH

The essence of the problem I have already accumulated 30 servers. And I'm already confused in the slightest. So far, everything is stored in a file.
I mean, I don't need the termius www.termius.com thing which is. there it connects still all sorts of things does.
There is a type of program that naturally encrypts all this with a password. and there is supposedly a database with a host port key and a brief description and that's all.?

Answer 1

KeePass is suitable for this task.
P / S /: Pull up the Russian language. You are asking for help - please respect your interlocutors.

Answer 2

I use SecureCRT, where there is a rather convenient tree with saved sessions, and authorization using keys encrypted with a password.
I do not use descriptions, but I briefly add the necessary information to the name of the server.
Under Linux I use Remmina, about the same.

Answer 3

Something like.
I do not vouch for loyalty.

select comment.id
      ,comment.user
      ,comment.news_id
  from comments as comment order by id desc limit 1
  join comments as new_comments on new_comments.news_id = comment.news_id and  new_comments.id > comment.id

Answer 4

If I understand correctly, you need the condition "there is a comment from user 1 and there is a comment from user not 1 for one particular page". Then here is the condition:

EXISTS (SELECT 1 FROM comments WHERE user=1 AND page_id=1) 
AND 
EXISTS (SELECT 1 FROM comments WHERE user<>1 AND page_id=1)

Answer 5

Well, two requests are possible.
1) Get the last date (lastdate) of our user's comment
2) Get all records after lasttime date
It seems to be possible to combine these two queries together, but this needs to be read up on mysql
PS. And don't forget to index user_id, datetime and page_id. Otherwise performance will be poor...

Answer 6

SELECT *
    FROM (SELECT `page_id`, max(`datetime`) AS `datetime`
              FROM `f_comments`
              WHERE `user` = {$userId}
              GROUP BY `page_id`) AS `my`
        LEFT JOIN `f_comments` AS `other` ON `other`.`page_id` = `my`.`page_id`
    WHERE `other`.`user` != {$userId}
        AND `other`.`datetime` > `my`.`datetime`