Is there some kind of script that converts all your logs into a MySQL db and displays them on a searchable php script?

It sounds ridculas I know, but I'm just wondering.

actually its a good idea in my opinion. That way one can store things where it can be retrieved even when at a different location.
perhaps I can write the c++ and -dt- can do the backend .

(if he is willing to help me out again that is )

Hehe, I just have a SHITLOAD of log files (dating back a few years atleast) all MSGPlus Encrypted.

I'd just like to have them all in some sort of database and then the ability to display and search them.

It's a long story, me and my friends would all be using it too.. Hard to explain hehe.

Was this attempted before?

I dont believe that it has been attempted before.

Ah okay, I see.

I'd try to help out on the backend, but I'm not really that good in PHP...

Good luck if you try to start a project.

quote:

---

Originally posted by ipab
I can write the c++ and -dt- can do the backend .

(if he is willing to help me out again that is )

---

sweet, now for some research . I will contact you when I need you I guess.

I think it's a great idea, I can't wait.

Good idea, can't wait fopr some wip responses.
Better make those databases password protected huh!

the problem with it, which I was pondering upon this morning was that converting all the current logs and putting them in the db. The encryption on the logs is the problem. Patchou please provide me an alternative :*). I was actually thinking of a way to encrypt the stuff stored in the db. Seeing as it is encrypted in the harddrive it is wise to do the same online.

You woudn't need to really secure anything. MySQL databases itself are secure (providing you've setup the user accounts correctly) - among other things..

You can use an .htaccess method for web security along with Apache-SSL. - Among other things...

Getting the logs decryped from MSGPlus, I have no idea. Maybe Patchou can help you with that?

quote:

---

Originally posted by ipab
Patchou please provide me an alternative :*).

---

quote:

---

Originally posted by ipab
Seeing as it is encrypted in the harddrive it is wise to do the same online.

---

here is how I figure it can be done.

user prompted for pass (plugin prompt). The pass is verified with online md5 salt value in db. If correct then they are authorised to the search/delete functions of the logs. As for the logs itself, they are satled and hashed, only problem is that we are going to have to figure out a way to not show the salting method in the php file itself. Perhaps  the plugin adds a bunch of selected chars (we choose) and then salts it, therefore it is constant always. Only downfall to that is that they would have to use the plugin to check their logs (otherwise they have no other way of decrypting the hashes).

* -dt- just votes for it to be stored with a user configurable "Salt"
or make work easier for dt and store as plain text

searching encoded content would be hard , if you go that way we will have to download all the logs (or just a certain time period if the user chooses) from the mysql db then unencode them then run some crazy word finding thing /return the logs...

plain text is easy..... store it then use mysql's built in search function (though i do wish for this to be easy to port to other database's like sqlite...)


so ehhhhhhhhhhhhhhhhhhhhhhh maybe the best thing would be to ask the user how we store it? and impliment both

sounds good. Problem is I feel that we are getting ahead of ourselves here . I cant seem to figure out a mass port for the logs into the db.

quote:

---

Originally posted by ipab
sounds good. Problem is I feel that we are getting ahead of ourselves here . I cant seem to figure out a mass port for the logs into the db.

---

code:

---

$x = file_get_contents('./chatlog.txt');


//this regexp matches the body of the text (the part where you talk )
$match = "/\.-{68}\.(?:.+)\.-{68}(.+)-{68}\./smUx";


//this regexp matches the header (part with dates n stuff)
$head = "/\.-{68}\.(.+)\.-{68}/smUx";

preg_match_all($match,$x,$data);
preg_match_all($head,$x,$header);

//show the first header
echo $header[1][0];

//show the first body
echo $data[1][0];

---

i'm sorry to kick this message, but i hope Patchou will read it...

if patchou is able to allow us to create a second event log, with the following data: email, time/date, message and message-code*, I will volunteer to write a web-based script that allows you to read out the event log to statistics. (just not-encrypted files...)...

*a message code stands for the action taken, e.g. 1001 is OFFLINE, 1002 is CHANGE NAME .... never mind what codes, just to distinguish the messages