
Next release includes:
-
distant file reading
[sqli],
- config saving
[gui],
- user interface tweaks
[gui] -- context menus copy/cut/paste/select all, shortcuts Ctrl+z/Ctrl+y/Ctrl+s, menubar, about/preference windows, etc
- data saving
[gui] -- tab separated values for tables, text for files
The engine I used for a whole table inspection works as well for a file, so it wasn't much work to add it.
If you are a website administrator, file reading shouldn't bother you very much because the default user logged into the database must have the FILE privilege, which is disabled most of the time. But you may test it with no harm in your LAMP/WAMP as a PoC. Also this threat should stay asleep as long as no db user is granted FILE, and/or if the default user does not change for another one who does
have FILE grantee... so I may work on distant table update next and also distant file write, if only I find enough documentary ressources on that stuff ; apparently there's no stack query therefore I wonder if table update is doable ; I looked at file write in the past but couldn't figure how to deal with it (first
if it works, then what you do next if it works - mainly reverse tcp?).
Technically you are blind (again), you don't know what file is at reach, you have no file name and no path. But first you can try system files ; /etc/mysql/my.cnf, C:/Windows/system.ini, /etc/hosts, C:/Windows/System32/drivers/etc/hosts. Furthermore other tools like spiders can retreive a complete path and file name for you, jSQL won't, nevertheless it will read it if the path+filename are corrects.
Also I did take a break for some weeks until now, but I thought recently
that this read-a-file thing may integrate nicely, so voila :)
And I always need materials and new ideas to keep this project alive, so stay in touch and bring food at the picnic :) !
I will clean the code for now (take a break, have exams) and release the v0.3 soon.