Say that you have a table called myTable with several rows and a column called URL that contains the IP address of a log server. Now imagine that you want to change the value of URL so IP address is substituted by the server name. One way to do that is as follows:
use dbname
update myTbl set URL=replace(URL,’172.16.1.10′,’logserver’);
OpenSSH provides a per-user configuration file usually located in ~/.ssh/config. This file can help ease your life as Sysadmin. Let’s say that you frequently connect to a server in this way:
ssh admin@boring-servername.boring-domain.com
With OpenSSH there is an easy way to do the job. Edit or create a config file:
vi ~/.ssh/config
and then add the following:
Host servername
User admin
HostName boring-servername.boring-domain.com
Where Host is the alias for the remote server you want to connect to, HostName is the full name of the remote server and User is the login name.
References:
I finally have the time to dedicate in moving KarkomaOnline to the WordPress content manager and made some changes to the look&feel. As always your feedback and posts are very welcome.
Hope you enjoy!
A note for registered users: I’m not going to port the accounts and settings from the old site as this implies a lot of work for me. Please take a minute to register again. Sorry for the inconvenience.
SecurityFocus: Vulnerabilities SecurityFocus: News Slashdot