Harsha's questions

Requirement: Alert if there is any package installed or removed in the ubuntu server.

For this requirement, I'm trying to use inotifywait to continuously monitor dpkg.log, if there are any changes using regex pattern for installed and removed package and alert based on that.

How can I take the modified content of a file which is being monitored by inotifywait to another file or store it in a variable, so that I can apply some regex and alert based on that?

Please help me how can I do this, or Is there any other way that I can achieve this requirement using any other tool.

This is what I was trying but this is not working.

  #!/bin/sh
   while inotifywait -e modify /var/log/dpkg.log; do   
      if tail -n1 /var/log/dpkg.log | grep installed; then
         // alert script    
       fi 
    done

I'm trying to delete files older than 2 days and write the deleted file names to a log file along with creation/modified time and deletion time.

Eg: filename creationTime deletetionTime

test1 11-08-2020T08:38:16+05:30 12-08-2020T10:18:42+05:30
test2 11-08-2020T08:38:16+05:30 12-08-2020T10:18:42+05:30

I have script to delete files older than 2 days and log the filename to file but not getting how to print along with creation/modified date and deletion time.

#!/bin/bash

path="/test"
filename=*.txt
logfile=/tmp/$(date +%d-%m-%Y).log
days=-60

find $path -mmin $days -name "*.wav" -type f -print0 -delete | xargs -0 basename -a >> $logfile

Can someone help me to achieve that above output?

I have a CSV file it includes some columns, in that I have the start time and end time. My requirement is to get the difference between the time and add the difference to a new column.

I'm getting the difference between time but not able to add it into new column properly for each line.

This is my sample csv.

4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1 3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1 2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1 1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1

This is the script.

    #!/bin/bash
    cat a.csv | while read line
       do
              created_at=$(date -d $(echo $line | awk -F "," '{print $3}') +%s)
              merged_at=$(date -d $(echo $line | awk -F "," '{print $6}') +%s)
              echo $created_at $merged_at
              diff=$(( $merged_at - $created_at ))
              h=`expr $diff / 3600`
              m=`expr $diff  % 3600 / 60`
              s=`expr $diff % 60`
              diff=$(printf "%02d:%02d:%02d\n" $h $m $s)
              echo $diff
              awk -v v1="$diff" -F"," 'BEGIN { OFS = "," } {$9=v1; print}' a.csv >> b.csv
done

I'm getting the output something like this.

4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1,00:00:22
3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1,00:00:22
2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1,00:00:22
1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1,00:00:22
4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1,00:00:30
3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1,00:00:30
2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1,00:00:30
1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1,00:00:30
4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1,00:02:20
3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1,00:02:20
2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1,00:02:20
1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1,00:02:20
4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1,00:00:33
3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1,00:00:33
2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1,00:00:33
1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1,00:00:33

Which is append the difference to all the line.

But my requirement to get the difference of time only for that line. The output should be like this.

4,ganesh-28,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1,00:00:22
3,ganesh-28,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1,00:00:30
2,ganesh-28,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1,00:02:20
1,ganesh-28,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1,00:00:33

Please someone help me to achieve this.

I have file which contains something like below

5,test,2019-09-27T11:06:23Z,closed,harshavardhanc,2019-09-27T11:09:28Z,2,2
4,test,2019-09-26T16:56:40Z,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1
3,test,2019-09-26T16:54:25Z,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1
2,test,2019-09-26T16:52:59Z,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1
1,test,2019-09-26T16:46:52Z,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1

I want to trim the 3rd column 2019-09-27T11:06:23Z to 2019-09-27 Basically I want to remove time and just keep date here.

4,test,2019-09-26,closed,harshavardhanc,2019-09-26T16:57:02Z,1,1
3,test,2019-09-26,closed,harshavardhanc,2019-09-26T16:54:55Z,1,1
2,test,2019-09-26,closed,harshavardhanc,2019-09-26T16:55:19Z,1,1
1,test,2019-09-26,closed,harshavardhanc,2019-09-26T16:47:25Z,1,1

I tried using awk with gsub awk '{gsub("T","",$3);print}' test

But no luck, please help how can I achieve this.

I'm getting a curl command output as below

curl -s https://api.github.com/repos/harshavardhanc/dockerfile-ansible/pulls\?state\=all | jq -r '.[]|(.number|tostring)+" "+.user.login+" "+.created_at+" "+.merged_at'

5 test 2019-09-27T11:06:23Z 2019-09-27T11:09:28Z
4 test1 2019-09-26T16:56:40Z 2019-09-26T16:57:02Z
3 test2 2019-09-26T16:54:25Z 2019-09-26T16:54:55Z
2 test3 2019-09-26T16:52:59Z 2019-09-26T16:55:19Z
1 test4 2019-09-26T16:46:52Z 2019-09-26T16:47:25Z

and I'm storing it in a variable and trying to pass echo the variable to pass the value to another command to parse the output. But when I'm trying to echo the variable it is printing all the lines as a single line.

prlist=$(curl -s https://api.github.com/repos/harshavardhanc/dockerfile-ansible/pulls\?state\=all | jq -r '.[]|(.number|tostring)+" "+.user.login+" "+.created_at+" "+.merged_at')
echo $prlist

5 test 2019-09-27T11:06:23Z 2019-09-27T11:09:28Z 4 test1 2019-09-26T16:56:40Z 2019-09-26T16:57:02Z 3 test2 2019-09-26T16:54:25Z 2019-09-26T16:54:55Z 2 test3 2019-09-26T16:52:59Z 2019-09-26T16:55:19Z1 test4 2019-09-26T16:46:52Z 2019-09-26T16:47:25Z

How to avoid this printing in different line? Please help.

I'm trying get some data using github API's and print in a csv file. I'm get output something like below

4
3
2
1
user-1
user-2
user-3
user-4

I'm trying to achieve that the data should be displayed column-wise, something like this.

4    user-4
3    user-3
2    user-2
1    user-1

And the data will vary every time and I may need to add some more columns similar to this.

Please someone help to achieve this.

I'm using keycloak and it is running on public ip and admin console also accessible via public ip and I'm using nginx web server. I have a requirement that the admin console should be accessible only on private ip. Other URL's should work normally on public ip/domain name.

Now, Ex: domain_name/auth and domanin_name/auth/realm/admin and other urls is accessible publicly.

Requirement: Only this admin console domanin_name/auth/realm/admin url should be accessible only through private ip.

Can this be done through nginx rules?

Please anyone help me on this.

Below is the configuration which I'm trying but it is not working as expected.

server {
    listen 80 default_server;
    listen [::]:80 default_server;
    server_name _;

    location / {
        # First attempt to serve request as file, then
        # as directory, then fall back to displaying a 404.

        rewrite ^/(.*) /$1 break;
        proxy_ignore_client_abort on;
        proxy_pass http://localhost:8880;
        proxy_set_header  X-Real-IP  $remote_addr;
        proxy_set_header  X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header  Host $http_host;
    }

    location /auth/realms/master {
        allow 127.0.0.1;
        deny all;
        #try_files $uri $uri/ =404
    }
}

I'm trying to write a bash script to read a file as input and append the values/data in that file into variables and the values of the variables should be updated each iteration based on the input line from the file.

Eg: Input file looks like below:

100  Thomas  Manager    Sales       $5,000
200  Jason   Developer  Technology  $5,500
300  Sanjay  Sysadmin   Technology  $7,000
400  Nisha   Manager    Marketing   $9,500
500  Randy   DBA        Technology  $6,000

While reading this through my shell script, I'll define 5 variables let's a,b,c,d,e.

First iteration:

The variable values should be assigned with first line of input file.

a=100
b=Thomas
c=Manager
d=Sales
e=$5000

Second iteration:

The variable values should be assigned with second line of input file.

a=200
b=Jason
c=Developer
d=Technology
e=$5500

And so on...

Please anyone give some input on how to write a script to read values in this format.

I'm using postfix and mail from mailutils to send email using my gmail address through command line in Ubuntu. It works fine when I provide both from and to address like below:

mail -s "Some random subject" -a "From: [email protected]" [email protected]

But I need to configure to send email from default gmail address without specifying from address everytime. How can I do that?

Please help me!

I stuck with this issue, googled it around and got some solutions but unlikely it is not working properly. Can anyone give a solution for this please,

I'm running Apache2 in Ubuntu 14.04 machine. Have only one virtual host running in it and have a document root under /var/www/html where our resides.

Inside html directory our code contains sub-directories. For eg. dir1, dir2. I need the error log should be customized like all the error log related to code under dir1 should resides inside dir1 and same for dir2.

How I can customize the error logs?

I need to change the network interface in Ubuntu 14.04 from eth0 to br0 bridge interface. I tried to install bridge-utils package but I couldn't find that package. Can anyone help how change it to br0 with static IP address.

Thanks in advance!

I need to get the details of the users logged in from last 6 months to analyze and to increase the cpu of my server. I'm tried the command last -a but it is not giving the complete results. Anyone please help me to get the details of users logged in from last 6 months.

Thanks in advance!

Please anyone can give the solution for this I'm trying to take gitlab backup to another server, script should delete the old files if the file number in the directory exceeds 15?