chukwa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ariel Rabkin <asrab...@gmail.com>
Subject Re: possible hicc problems?
Date Fri, 22 May 2009 17:24:53 GMT
Will do.  I think I'd like to actually work on CHUKWA-258, rather than
doing this ad-hoc.  How does that strike you?

--Ari

On Fri, May 22, 2009 at 10:10 AM, Eric Yang <eyang@yahoo-inc.com> wrote:
> "hostname" was replaced with %22hostname%22 because the quote characters and
> < and > sign are escaped to prevent SQL injection attacks and cross site
> scripting attacks.
>
> The condition part of the SQL statement should be prepared and execute the
> statement with the list of selected host.  I think this is fixed for the
> trunk version of HICC.  If this doesn't resolve the problem, could you
> output the query string before SQL execution in
> single-series-javascript-chart.jsp, and see what has executed.
> List out the content of the parms ArrayList as well.
>
> Regards,
> Eric
>
>
> On 5/21/09 8:52 PM, "Ariel Rabkin" <asrabkin@gmail.com> wrote:
>
>> Howdy all.
>>
>> So I now have HICC displaying Hadoop metrics (yay!)
>>
>> But it seems to work wonkily.  I was messing around with adding new
>> things to display, and wound up injuring hicc somehow.  Symptom: a
>> whole bunch of graphs refuse to display, just drawing whitespace.
>> And intead of showing actual machine names, the host selector widget
>> has HTTP escapes around the names.
>> So "hostname" got replaced with  %22hostname%22.  Why?
>>
>> I had the following in my catalina.out:
>>
>> May 21, 2009 5:31:46 PM org.apache.catalina.startup.Catalina start
>> -----------
>> INFO: Server startup in 23689 ms
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: SQLException: Unknown
>> column 'heartbeat_avg_time' in 'field list'
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: SQLState: 42S22
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: VendorError: 1054
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: SQLException: Unknown
>> column 'heartbeat_avg_time' in 'field list'
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: SQLState: 42S22
>> 09/05/21 20:28:57 ERROR hicc.DatasetMapper: VendorError: 1054
>> 09/05/21 20:33:08 ERROR hicc.DatasetMapper: SQLException: You have an
>> error in your SQL syntax; check the manual that corresponds to your
>> MySQL server version for the right syntax to use near '%27
>> %27,process_name) as process,threads_blocked from hadoop_jvm_479_month
>> where' at line 1
>> 09/05/21 20:33:08 ERROR hicc.DatasetMapper: SQLState: 42000
>> 09/05/21 20:34:02 ERROR hicc.DatasetMapper: VendorError: 1064
>> 09/05/21 20:39:13 INFO util.XssFilter: XssFilter.getParameterValues:
>> cannot get parameter for: table
>> 09/05/21 20:39:13 ERROR hicc.DatasetMapper: SQLException: You have an
>> error in your SQL syntax; check the manual that corresponds to your
>> MySQL server version for the right syntax to use near 'from
>> cluster_system_metrics_2055_week where timestamp >= '2009-05-22 02:39'
>> and ' at line 1
>> 09/05/21 20:39:13 ERROR hicc.DatasetMapper: SQLState: 42000
>> 09/05/21 20:39:13 ERROR hicc.DatasetMapper: VendorError: 1064
>> 09/05/21 20:43:16 ERROR hicc.DatasetMapper: SQLException: Unknown
>> column 'hosts' in 'field list'
>> 09/05/21 20:43:16 ERROR hicc.DatasetMapper: SQLState: 42S22
>> --------
>>
>
>



-- 
Ari Rabkin asrabkin@gmail.com
UC Berkeley Computer Science Department

Mime
View raw message