WEBVTT
00:00:15.420 --> 00:00:19.820
Can you show me the source of this time, like from where did you pick this up?
00:00:19.860 --> 00:00:24.020
So I was here and then I took the log time here.
00:00:25.320 --> 00:00:31.680
Let's read where did you take the timestamp from?
00:00:34.260 --> 00:00:34.840
Here.
00:00:34.840 --> 00:00:42.020
Log database backup. This is the time when database backup was completed.
00:00:42.120 --> 00:00:46.060
This might be after it was completed, but the question has asked this.
00:00:47.380 --> 00:00:49.540
So you might have to look it into the access logs.
00:00:50.900 --> 00:00:51.820
Okay, thank you.
00:00:52.460 --> 00:00:56.120
So I'm looking at the access logs, right?
00:00:56.220 --> 00:00:57.660
And I can see some of the time steps.
00:00:58.860 --> 00:01:00.220
Wait, maybe can you go to my...
00:01:01.020 --> 00:01:03.560
Yeah, sure. I'll be there.
00:01:04.480 --> 00:01:07.860
Oh, I'll have...
00:01:07.860 --> 00:01:08.560
Sorry.
00:01:11.440 --> 00:01:16.740
Okay, we have found something with database in it.
00:01:17.780 --> 00:01:19.060
Is it?
00:01:19.060 --> 00:01:24.760
ACP database, it is a modus backup.
00:01:25.480 --> 00:01:30.840
And ADM backup in action download.
00:01:31.860 --> 00:01:34.220
So we're just trying to download ACP database.
00:01:35.060 --> 00:01:38.240
Let's have a look like what is ACP database,
00:01:38.300 --> 00:01:40.500
because we have been asked to download the SQL database.
00:01:41.860 --> 00:01:48.380
ACP database national verifier of the affordable connectivity program.
00:01:48.380 --> 00:01:52.700
So I don't think it resembles our problem, right?
00:01:53.160 --> 00:01:58.520
ACP doesn't meet the code.
00:01:58.780 --> 00:01:59.580
ACP database.
00:02:01.760 --> 00:02:03.160
Oh, can I see the hit?
00:02:03.740 --> 00:02:08.680
Yeah, I think what we're looking for is more on the SQL side.
00:02:10.020 --> 00:02:10.680
Sorry.
00:02:14.880 --> 00:02:16.640
The instruction manual.
00:02:17.320 --> 00:02:21.360
But yeah, both of you guys are really close to the answer.
00:02:21.700 --> 00:02:23.120
Let's see who gets there first.
00:02:27.880 --> 00:02:32.960
Maybe we can look for SQL databases instead of just going for database.
00:02:33.320 --> 00:02:38.040
Yeah, so when I search database, all I'm seeing is the ACP.
00:02:38.180 --> 00:02:40.460
So maybe let me just change to SQL.
00:02:40.460 --> 00:02:44.420
Yeah, that's the end.
00:02:45.020 --> 00:02:45.820
That's the end, guys.
00:02:46.980 --> 00:02:48.960
You know, I know I should give away the answer,
00:02:48.960 --> 00:02:50.480
but I don't want to give away the answer.
00:02:50.620 --> 00:02:53.000
You guys are so close, like multiple of you.
00:02:53.300 --> 00:02:54.860
So I don't want to give the answer.
00:02:55.340 --> 00:02:58.680
You guys tell me when you want to give me the answer, right?
00:02:59.240 --> 00:03:00.940
That way, it's better.
00:03:06.800 --> 00:03:07.960
JNN is very close.
00:03:08.580 --> 00:03:09.760
Yeah, I can see that.
00:03:09.760 --> 00:03:10.760
Well, it's great.
00:03:11.140 --> 00:03:12.800
Let's see if we can figure that out.
00:03:15.140 --> 00:03:16.660
Everything is in the timestamp portion itself.
00:03:16.940 --> 00:03:18.100
That's I'll give you that much.
00:03:18.480 --> 00:03:24.420
Everything is in the timestamp folder, like the timestamp area.
00:03:24.520 --> 00:03:28.000
Okay, so I'm looking at the correct portion, the correct rate.
00:03:28.160 --> 00:03:29.100
Yes, you are.
00:03:30.000 --> 00:03:30.060
You are.
00:03:30.080 --> 00:03:31.060
We don't figure it out.
00:03:31.120 --> 00:03:34.480
Like, why is there something after the timestamp?
00:03:35.080 --> 00:03:36.060
What does it mean?
00:03:36.180 --> 00:03:37.340
Like, what can that be?
00:03:38.200 --> 00:03:41.400
No, that's the GMT that you're asking about earlier.
00:03:41.560 --> 00:03:42.100
Ah, right.
00:03:42.220 --> 00:03:42.920
We have to give the answer again.
00:03:42.920 --> 00:03:45.560
But I've been testing it now and it wasn't okay, correct.
00:03:47.500 --> 00:03:49.140
You have to adjust it again.
00:03:49.340 --> 00:03:50.620
Like, you have to adjust this one.
00:03:50.760 --> 00:03:52.640
Epochs aren't supposed to be not adjusted,
00:03:53.140 --> 00:03:54.840
but you see why Epochs are so important.
00:03:55.540 --> 00:03:57.440
Now you have to adjust this to the correct time.
00:03:57.460 --> 00:04:01.200
Okay, so then we have to add one equal to 13 instead.
00:04:03.400 --> 00:04:06.360
It is, this time is for GMT plus one.
00:04:06.360 --> 00:04:10.980
So if you minus one hour from that time, you will get the GMT time, right?
00:04:15.740 --> 00:04:16.040
So, got it.
00:04:17.840 --> 00:04:18.240
That's it.
00:04:18.500 --> 00:04:19.060
Voila.
00:04:20.980 --> 00:04:23.380
So, Daniel has got the flag.
00:04:23.840 --> 00:04:24.480
That's great.
00:04:24.960 --> 00:04:25.240
Let's see.
00:04:27.900 --> 00:04:33.740
Daniel, do you want to explain to us, like, how you got to that conclusion?
00:04:34.760 --> 00:04:36.040
Let's hear it from you.
00:04:36.740 --> 00:04:40.000
Yeah, that is, yeah, share your screen.
00:04:40.160 --> 00:04:44.080
I think if, like, if you want to, there's no competition at all.
00:04:45.840 --> 00:04:49.560
So initially I was looking, so actually initially I looked at the logs
00:04:49.560 --> 00:04:53.100
and then looked at the operations to see when it was backed up,
00:04:53.220 --> 00:04:56.120
but then it gave the time that it ended, not that it started.
00:04:56.660 --> 00:05:02.540
So then I looked at the access logs and initially I just searched for backup,
00:05:02.720 --> 00:05:03.700
but then it was backing up.
00:05:03.780 --> 00:05:05.920
It was showing the logs for backing up the wrong database.
00:05:05.920 --> 00:05:09.480
So then when you sent the hint of it to SQL database,
00:05:09.740 --> 00:05:14.000
I just searched the SQL flag and then found the correct record.
00:05:15.120 --> 00:05:20.200
And then I just took the corresponding time and then converted it to UTC.
00:05:21.820 --> 00:05:23.380
Now, there's a small trick here.
00:05:24.020 --> 00:05:25.560
That's that plus zero one hundred.
00:05:26.100 --> 00:05:28.780
Now that is, that is, that is a time,
00:05:29.440 --> 00:05:34.660
like this timestamp is one hour ahead of the GMT time.
00:05:34.660 --> 00:05:37.480
And that is denoted by this plus one hundred.
00:05:38.000 --> 00:05:41.040
So if you subtract one hour from this time, the timestamp,
00:05:41.280 --> 00:05:43.080
you get the GMT time, which is being lost.
00:05:43.820 --> 00:05:46.780
So even though, like when I was doing this one,
00:05:47.120 --> 00:05:50.220
I was, I was very, like, you know, I was very kind of irritated
00:05:50.220 --> 00:05:52.840
that why am I not getting the correct one?
00:05:53.320 --> 00:05:57.840
Even though I've given that one, but then I had to look it up
00:05:57.840 --> 00:05:59.200
and yeah, I found this one.
00:05:59.260 --> 00:06:01.120
It was, it was this plus one.
00:06:03.720 --> 00:06:07.220
So then you can also do that, like the 10th one also,
00:06:07.220 --> 00:06:08.880
like it's, it's just from the same line.
00:06:10.720 --> 00:06:13.240
Again, the information is present in the trivia.
00:06:14.860 --> 00:06:15.680
Yeah, that's the one.
00:06:17.920 --> 00:06:18.960
Well done.
00:06:20.620 --> 00:06:21.840
So we have that.
00:06:24.500 --> 00:06:26.240
So anyone has any doubts?
00:06:26.820 --> 00:06:29.220
Or I think Lucy has cleared all of your doubts, right?
00:06:29.220 --> 00:06:32.160
Like, I think Lucy has cleared all the doubts.
00:06:33.140 --> 00:06:34.800
Does anyone have any other doubts in this law?
00:06:36.400 --> 00:06:39.040
Or if you guys want me to do it, you know,
00:06:39.300 --> 00:06:41.720
explaining in more detail, then I can also do it.
00:06:41.780 --> 00:06:44.020
If you guys need that, just give me,
00:06:44.140 --> 00:06:46.520
anyone give me a hands up if you want me to explain.
00:06:46.660 --> 00:06:47.720
Okay, that's great.
00:06:50.860 --> 00:06:51.260
That's great.
00:06:51.720 --> 00:06:54.580
So we have, yeah.
00:06:54.580 --> 00:06:56.900
I think everyone's tired now.
00:06:58.540 --> 00:06:59.540
Yeah, I can see that.
00:07:00.460 --> 00:07:04.520
Okay, so I'm open for questions for any of the five labs.
00:07:05.020 --> 00:07:08.080
All of them are open and I'll just share my screen
00:07:08.080 --> 00:07:10.260
and show you guys the solution manuals.
