Re: [Perfparse-users] addslashes

[Ben C. <Be...@cl...>]

Julien,

The '\' in the C:\ is an escape character in MySQL.  (Which it NOT 
ANSI-SQL standard, but never mind :)

I'll adjust our functions and release another version soon.  Sorry about 
the haste,

Regards, Ben.


Julien TOUCHE wrote:

> 
> i'm currently testing perfparse 0.100.4 on a linux whitebox and have the
> following problem:
> 
> # sh -x /opt/nagios/bin/perfparse.sh
> + BASE_DIR=/opt/nagios
> + PERFPARSE=/opt/nagios/bin/perfparse
> + LOG=/opt/nagios/var/perfparse.log
> + TMP_LOG=/tmp/perfparse.20545.log
> + TMP_ERR=/tmp/perfparse.20545.err
> + PERF_FILE=/opt/nagios/var/serviceperf.log
> + '[' '!' -f /opt/nagios/var/serviceperf.log ']'
> + /opt/nagios/bin/perfparse -s -r
> + RETURN=254
> + '[' -f /tmp/perfparse.20545.err ']'
> + cat /tmp/perfparse.20545.err
> "SELECT COUNT(*) FROM perfdata_service_metric WHERE host_name =
> '192.168.1.96' AND service_description = 'NRPE_NT_C' AND metric = 'C:\'"
> failed:
> 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 ''C:\'' at
> line 1
> + '[' -f /tmp/perfparse.20545.log ']'
> + rm /tmp/perfparse.20545.log
> + '[' -f /tmp/perfparse.20545.err ']'
> + rm /tmp/perfparse.20545.err
> + exit
> 
> it seems there is no addslashes function uses ... so is there any
> available ?
> 
> Regards
> 
>         Julien
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. 
> Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> Perfparse-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/perfparse-users
>