Home    |    View Topics    |    Search    |    Contact Us    |   



Category:   Application (Forum/Board/Portal)  >   SPIP Vendors:
SPIP Input Validation Holes Permit SQL Injection and Cross-Site Scripting Attacks
SecurityTracker Alert ID:  1015556
SecurityTracker URL:
CVE Reference:   GENERIC-MAP-NOMATCH   (Links to External Site)
Updated:  Feb 2 2006
Original Entry Date:  Feb 1 2006
Impact:   Disclosure of authentication information, Disclosure of system information, Disclosure of user information, Execution of arbitrary code via network, Modification of user information, User access via network
Fix Available:  Yes  Vendor Confirmed:  Yes  Exploit Included:  Yes  
Version(s): prior to 1.8.2-e; prior to 1.9 Alpha 2 (5539)
Description:   A vulnerability was reported in SPIP. A remote user can inject SQL commands. A remote user can also conduct cross-site scripting attacks.

The software does not properly validate user-supplied input. A remote user can supply a specially crafted parameter value to execute SQL commands on the underlying database. Some of the administrative pages and forum pages are affected.

The 'formulaires/inc-formulaire_forum.php3' script is affected.

Some demonstration exploit URLs are provided:



Various parameters, including id_article, id_breve, and others, are affected.

Other SQL injection flaws were discovered by the vendor, some of which involve the posting of "petitions."

The 'index.php3' script does not properly filter HTML code from user-supplied input in the 'lang' parameter before displaying the input. A remote user can create a specially crafted URL that, when loaded by a target user, will cause arbitrary scripting code to be executed by the target user's browser. The code will originate from the site running the SPIP software and will run in the security context of that site. As a result, the code will be able to access the target user's cookies (including authentication cookies), if any, associated with the site, access data recently submitted by the target user via web form to the site, or take actions on the site acting as the target user.

A demonstration exploit URL is provided:


Kevin Fernandez "Siegfried" and Benoit Sklenard "netcraft" from the Zone-H Research Team discovered these vulnerabilities.

The original advisories are available at:


Impact:   A remote user can access the target user's cookies (including authentication cookies), if any, associated with the site running the SPIP software, access data recently submitted by the target user via web form to the site, or take actions on the site acting as the target user.

A remote user can execute SQL commands on the underlying database.

Solution:   The vendor has issued a fix for the SQL injection vulnerability, available via SVN.
Vendor URL: (Links to External Site)
Cause:   Input validation error
Underlying OS:  Linux (Any), UNIX (Any), Windows (Any)

Message History:   None.

 Source Message Contents

Subject:  [Full-disclosure] ZRCSA-200601: SPIP - Multiple Vulnerabilities

Zone-H Research Center Security Advisory 200601

Date of release: 31/01/2006
Software: SPIP (
Affected versions: < 1.8.2-e , < 1.9 Alpha 2 (5539)
Risk: Medium
"netcraft" from the Zone-H Research Team

SPIP is a publishing system for the Internet.
Come again? It consists of a bundle of files, installed in your web
account and allowing you to take advantage of a number of automated
tasks: multi-user management, laying out your articles without the
need to use HTML, easily modifying the structure of your site. From
the very same application used to browse a site (Netscape, Microsoft
Internet Explorer, Mozilla, Opera...), SPIP enables you to build and
update a site, thanks to a very simple user interface.

Some sql injections and cross-site scripting vulnerabilities have been

-When we contacted the vendor, he already had fixed some of them:
multiple sql injections exploitable in the administrative area.

The ones which weren't fixed when we contacted him were the sql
injections in the forum (public area).

in formulaires/inc-formulaire_forum.php3 :
    // recuperer les donnees du forum auquel on repond, false = forum interdit
         list ($idr, $idf, $ida, $idb, $ids) = $args;
if (!$r = sql_recherche_donnees_forum ($idr, $idf, $ida, $idb, $ids))
                 return '';

It is exploitable via forum.php3 , example:
or with any other variable (id_article, id_breve..) like:

It is exploitable like this with magic_quotes_gpc on or off.

A full path disclosure problem was present in inc-messforum.php3 when
accessing it directly, let's say the spip path is /var/www/spip , it
could then be used to exploit the sql injection (if magic_quotes_gpc
is off) to inject php code in a writable directory(The "IMG" folder,
like 3 others, are writable by default).

So if magic_quotes_gpc = Off , Display_errors = On and SPIP is version
1.8.2 or prior, it can be exploited to compromise a vulnerable system.

The vendor also discovered 2 potential sql injections in the session
handling and when posting "petitions" (maybe others).

-We also notified the vendor of a xss problem, it isn't fixed.

The sql injection vulnerabilities have been fixed in the latest svn
snapshot (5546): svn://
or here:

Original advisories:
Full-Disclosure - We believe in it.
Hosted and sponsored by Secunia -


Go to the Top of This SecurityTracker Archive Page

Home   |    View Topics   |    Search   |    Contact Us

This web site uses cookies for web analytics. Learn More

Copyright 2020, LLC