ron...@ymail.com
unread,Sep 3, 2012, 7:06:19 PM9/3/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to jsql-in...@googlegroups.com
I'm actually developping and testing time based method, I'm re-using the blind module I had already created before for that purpose. Time based is very similar to blind and is even simpler, and the code should be less dirty, much more clear. For local testing, you can easily validate blind and timebased methods, each one is fast and the informations and databases appear both in place without problem, but it's different behind your network connection or worth, behind a proxy. I have tested blind using a proxy and this is very slow, I can hardly wait a very long time before validating some of my script live, so if you know open and free ways to test that faster, feel free to leave a message.
Blind and timebased need actually a valid initial tag for the job to work (tag 1 in [...]ulate_get?id=1), and I will try to make it work with any bad tag if it's possible, like [...]ulate_get?id=-1.
Also, for a safe extraction and parsing, I use hex encoding and it greatly multiplies the number of characters you have to read to obtain the final information, in fact the data is a long sequence of encoded characters, so maybe I can speed up blind and timebased with some tweaks, and if there are similar stuff to apply to normal and errorbased it should be an extra fast extraction. Speed-wise, the search for the initial tag (0,0',',-1,1,",-1)) and for the number of fields in normal mode is now threaded (select 1,2,3,...,100), also the proxy connection is tested, evasion is added (case sensitive, space, equal sign). I have read that you could break keywords with the stream comment /**/, like in sEl/**/EcT, but it seems it's not really working, I wonder if the database should match a specific version.
I think I will add a contextual menu to table names with entries 'load 1 row', 'load 10 rows', 'load all rows' because blind and timebased are awfully longer than normal and errorbased and you must wait too much before expecting any results.
For errorbased, I didn't notice the error was localized, in fact the message "Duplicate entry '%-.192s' for key %d" can be in another language, so I will change the code to match sentences that you can find in the files errmsg.sys located in \mysql\share.
Actually I manage to add features to the tool without very much problems, but I think it could become very ugly from the inside if I don't pay attention to design. I have read some papers on design pattern recently but for now I don't see the use of any of them, only MVC is actually present in it but I think some other pattern may help me and fit well somewhere (any advice will be greatly appreciated).