KasperFridolin / mysql_forensics

Scripts and Modules for forensical analyses of mysql database systems
22 stars 17 forks source link

NoT Run iblogfile_parser.py #1

Open vipinbeni opened 9 years ago

vipinbeni commented 9 years ago

Hi Sir @KasperFridolin ,

when i run it on window always show 0 0 0 out put for insert delete and update. pls help me and if any document for this pls give me i want to do same in c++.

Pls Help Me .

thanks vipin.

KasperFridolin commented 9 years ago

Hi,

Can u provide more info? I know this parser is really buggy :( never had time to finish it. If u want to do the same for c it would be great . I can provide u some background info how MySQL creates these files.

Cheers

Marcel

On 03 Apr 2015, at 10:01, vipinbeni notifications@github.com wrote:

Hi Sir @KasperFridolin ,

when i run it on window always show 0 0 0 out put for insert delete and update. pls help me and if any document for this pls give me i want to do same in c++.

Pls Help Me .

thanks vipin.

— Reply to this email directly or view it on GitHub.

vipinbeni commented 9 years ago

Hi Sir , Thanks for your quick reply. i run this script it also show 0 for inset 0 for update and 0 for delete however there are many record i see in my file . Could you please provide me the detail file format structure how we read data from this log file as i don't understand python if i got doc of file internal detail then it will better for me .Please help me . thanks a lot.

logfile

vipinbeni commented 9 years ago

Dear Sir , tableIDs always empty. and i got following out put

Start of analyses: 03.04.2015 - 15:29:47 Results of analysing the test database:

---- INSERTS ----

---- UPDATES ---- OUT OF ORDER :)

---- DELETES ---- ---- Overview ----

Type Block No
Insert
---- --------
Update

OUT OF ORDER :)

---- -------- Delete

-- Total number of Insert-Statements found: 0 -- Total number of Update-Statements found: 0 -- Total number of Delete-Statements found: 0

End of analyses: 03.04.2015 - 15:30:00

vipinbeni commented 9 years ago

Dear Sir,

if possible i will send you my log file . but here is no option of attachment.

vipinbeni commented 9 years ago

variable Here you can see splitList is empty and ibdataList is also empty

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin , I want to make a viewer of insertion deletion and update oprtion from log pls help me .

please provide me how can i trace these data from file binary . as i note down block is start at 0x800 and after that i am not able to trace data please provide step to trace records.

thanks very much.

vipin

KasperFridolin commented 9 years ago

Sorry I'm not home at the moment. But this is an old presentation about MySQL forensics from me. May it helps u https://digital-forensics.sans.org/summit-archives/dfirprague14/Forensic_Analysis_of_MySql_DB_Systems_Marcel_Niefindt.pdf

Regards

On 03 Apr 2015, at 12:27, vipinbeni notifications@github.com wrote:

Dear Sir @KasperFridolin , I want to make a viewer of insertion deletion and update oprtion from log pls help me .

please provide me how can i trace these data from file binary . as i note down block is start at 0x800 and after taht i am not able to trace data please provide step to trace records.

thanks very much.

vipin

— Reply to this email directly or view it on GitHub.

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin ,

I am trying to read using help you provide me but i am not able to read even a single record in log file so i am sending you detail of my log file having only one single insert statement please tell me how can i read it please Sir help me.

insert

in the above i have only one inset stament but here i am not found 94 or 14 and also iam not under stand these two line Update / Delete == mlog_undo_insertentries (Starts with Offset 0x14) Insert == mlog_comp_rec_insertentries (starts with offset 0x26)

sir please tell me how can i read this give statemnt it is insert ino sachin values (80,beniw);

Please explain me how you read this from given block.

thanks a lot Sir.

vipin.

vipinbeni commented 9 years ago

Dear Sir

Please Explain me this block give in image above Byte how we can read. Here 94 is start after that i read table id but in between byte how can i seek / read them please tell me what is these byte and how can i read this block please Sir explain this for me. byte desc

Please Sir tell me how can i read data in any of give record .

thanks .

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin I am waiting for your help i have some issue please help me out if you are free now.

Sir i am not able to track the records data

iblog pls help me.

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin Please Help Me.

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin Please Help me sir as i am stuck in this.

KasperFridolin commented 9 years ago

Did you get my slides?

----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 29 Apr 2015 07:40:57 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Dear Sir @KasperFridolin Please Help me sir as i am stuck in this.


Reply to this email directly or view it on GitHub: https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97313378

vipinbeni commented 9 years ago

yes Sir

vipinbeni commented 9 years ago

@KasperFridolin Sir Could you explain me algo how can we parse.as above problem is not resolved or i can send you my filr you can parse it using the script then i use this script for my work.

vipinbeni commented 9 years ago

@KasperFridolin Sir Please Help me ...

KasperFridolin commented 9 years ago

Ok Send me your files. When do you need it back? ----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 29 Apr 2015 10:36:42 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Could you explain me algo how can we parse.as above problem is not resolved or i can send you my filr you can parse it using the script then i use this script for my work.


Reply to this email directly or view it on GitHub: https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97352448

vipinbeni commented 9 years ago

Hi Sir ,

Thanks a lot for your quick response and Please find attached log file. i need them with in 10 -15 days when u free please do my help .

On Thu, Apr 30, 2015 at 8:35 PM, KasperFridolin notifications@github.com wrote:

Ok Send me your files. When do you need it back? ----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 29 Apr 2015 10:36:42 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Could you explain me algo how can we parse.as above problem is not resolved or i can send you my filr you can parse it using the script then i use this script for my work.


Reply to this email directly or view it on GitHub:

https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97352448

— Reply to this email directly or view it on GitHub https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97829890 .

Thanks Vipin Kumar Beniwal

vipinbeni commented 9 years ago

Dear Sir if you got file then please acknowledge me.

thanks.

On Thu, Apr 30, 2015 at 8:35 PM, KasperFridolin notifications@github.com wrote:

Ok Send me your files. When do you need it back? ----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 29 Apr 2015 10:36:42 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Could you explain me algo how can we parse.as above problem is not resolved or i can send you my filr you can parse it using the script then i use this script for my work.


Reply to this email directly or view it on GitHub:

https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97352448

— Reply to this email directly or view it on GitHub https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97829890 .

Thanks Vipin Kumar Beniwal

KasperFridolin commented 9 years ago

Can't see the file?

----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Fri, 01 May 2015 04:43:25 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Hi Sir ,

Thanks a lot for your quick response and Please find attached log file. i need them with in 10 -15 days when u free please do my help .

On Thu, Apr 30, 2015 at 8:35 PM, KasperFridolin notifications@github.com wrote:

Ok Send me your files. When do you need it back? ----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 29 Apr 2015 10:36:42 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

Could you explain me algo how can we parse.as above problem is not resolved or i can send you my filr you can parse it using the script then i use this script for my work.


Reply to this email directly or view it on GitHub:

https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97352448

— Reply to this email directly or view it on GitHub https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-97829890 .

Thanks Vipin Kumar Beniwal


Reply to this email directly or view it on GitHub: https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-98029957

vipinbeni commented 9 years ago

@KasperFridolin Sir How can i send file to u as it take only image please give me your email id so i can send the same.

vipinbeni commented 9 years ago

@KasperFridolin Sir How can i send file to u as it take only image please give me your email id so i can send the same.

vipinbeni commented 9 years ago

@KasperFridolin Dear Sir please help me how can i send you file . please please help me.

vipinbeni commented 9 years ago

@KasperFridolin Sir Please help

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin Please parse record for me a its my project mysql fornsic of log file and i got stuck in it it and my project is going delay i will enable to send you file i will send you image you can just parse few record and make screen point for me how you can parse the record . I am using mysql 5.0 on windows os . mysql

Sir if you give some of your important time to me i am really thankful to you .

Sir could you give me id so can i send you file

Thanks a lot

KasperFridolin commented 9 years ago

Hi, dont know how to send attachments. Sorry. Would it help, if I provide you more information about the algorithms?

Von: "vipinbeni" notifications@github.com An: "KasperFridolin/mysql_forensics" mysql_forensics@noreply.github.com CC: "KasperFridolin" niefindt@fh-brandenburg.de Gesendet: Donnerstag, 7. Mai 2015 12:47:06 Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

@KasperFridolin Dear Sir please help me how can i send you file . please please help me.

— Reply to this email directly or view it on GitHub .

vipinbeni commented 9 years ago

@KasperFridolin Dear Sir Thanks you for your reply i send you image please tell me more about algorithms including trace data from this image it will really helpful to me. i need that how can i read block given in this image manully. thanks a lot .

vipinbeni commented 9 years ago

@KasperFridolin Dear Sir Please help me

KasperFridolin commented 9 years ago

Hi, once more. I cannot find any attachement in your e-mail. Greetz

Von: "vipinbeni" notifications@github.com An: "KasperFridolin/mysql_forensics" mysql_forensics@noreply.github.com CC: "KasperFridolin" niefindt@fh-brandenburg.de Gesendet: Dienstag, 19. Mai 2015 05:08:18 Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

@KasperFridolin Dear Sir Please help me

— Reply to this email directly or view it on GitHub .

vipinbeni commented 9 years ago

dear sir could you send me your mail id

On Tue, May 19, 2015 at 1:45 PM, KasperFridolin notifications@github.com wrote:

Hi, once more. I cannot find any attachement in your e-mail. Greetz

Von: "vipinbeni" notifications@github.com An: "KasperFridolin/mysql_forensics" mysql_forensics@noreply.github.com CC: "KasperFridolin" niefindt@fh-brandenburg.de Gesendet: Dienstag, 19. Mai 2015 05:08:18 Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

@KasperFridolin Dear Sir Please help me

— Reply to this email directly or view it on GitHub .

— Reply to this email directly or view it on GitHub https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-103393593 .

Thanks Vipin Kumar Beniwal

KasperFridolin commented 9 years ago

Send it to spam-johnny@web.de

----- Ursprüngliche Mail ----- Von: vipinbeni notifications@github.com An: KasperFridolin/mysql_forensics mysql_forensics@noreply.github.com CC: KasperFridolin niefindt@fh-brandenburg.de Gesendet: Wed, 20 May 2015 08:33:56 +0200 (CEST) Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

dear sir could you send me your mail id

On Tue, May 19, 2015 at 1:45 PM, KasperFridolin notifications@github.com wrote:

Hi, once more. I cannot find any attachement in your e-mail. Greetz

Von: "vipinbeni" notifications@github.com An: "KasperFridolin/mysql_forensics" mysql_forensics@noreply.github.com CC: "KasperFridolin" niefindt@fh-brandenburg.de Gesendet: Dienstag, 19. Mai 2015 05:08:18 Betreff: Re: [mysql_forensics] NoT Run iblogfile_parser.py (#1)

@KasperFridolin Dear Sir Please help me

— Reply to this email directly or view it on GitHub .

— Reply to this email directly or view it on GitHub https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-103393593 .

Thanks Vipin Kumar Beniwal


Reply to this email directly or view it on GitHub: https://github.com/KasperFridolin/mysql_forensics/issues/1#issuecomment-103778425

vipinbeni commented 9 years ago

Sir i have sent the file

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin have you finish or i have wait for some more days.

vipinbeni commented 9 years ago

@KasperFridolin Please help me out please sir.

vipinbeni commented 9 years ago

@KasperFridolin Please help me sir. Have you got my message please reply

waiting for your kind reply ......................

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin please reply ...

vipinbeni commented 9 years ago

Dear Sir @KasperFridolin please reply ...

vipinbeni commented 8 years ago

Sir @KasperFridolin please give me help on this i am really helpless now i try a lot but not get success please sir my project is going dead due to this please help me sir. On google no one other help all link redirect to your reference please help me Sir.

thanks a lot
vipin

vipinbeni commented 8 years ago

Sir @KasperFridolin are you got message

vipinbeni commented 8 years ago

Sir @KasperFridolin please provide at least some research document pls sir

vipinbeni commented 8 years ago

Sir are you busy then i will wait but please reply me @KasperFridolin thanks

vipinbeni commented 8 years ago

Sir are you busy then i will wait but please reply me @KasperFridolin thanks

vipinbeni commented 8 years ago

Sir kindly help me