Bug #384

modify string escaping again (mysql, pgsql)

Added by dnsmichi almost 4 years ago. Updated almost 4 years ago.

Status:ResolvedStart date:04/28/2010
Priority:NormalDue date:
Assignee:dnsmichi% Done:

100%

Category:Event Broker
Target version:1.0.2
Icinga Version: OS Version:

Description

Basically possible by binding values - done by database. Or ourselves again, removing it was not a good idea.

https://git.icinga.org/?p=icinga-core.git;a=commit;h=68f64df03f7aeccfc49ebb9e5eee56e5d99932db;js=1

http://git.debian.org/?p=pkg-nagios/icinga.git;a=blob;f=debian/patches/80_fix_idoutils_escaping.dpatch;h=149c9cf5111264354d159d7a7d9f0e0a0c663462;hb=HEAD

pgsql report:

[1272467286.439166] [002.0] [pid=9248] UPDATE icinga_servicechecks SET check_type='0', current_check_attempt='1', max_check_attempts='4', state='0', state_type='1', start_time=FROM_UNIXTIME(1272467286), start_time_usec='435724', end_time=FROM_UNIXTIME(0), end_time_usec='0', timeout='60', early_timeout='0', execution_time='0.000000', latency='0.435000', return_code='0', output='IMAP OK - 0.003 second response time on port 143 [* OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready. Copyright 1998-2008 Double Precision, Inc.  See COPYING for distribution information.]', long_output='', perfdata='time=0.002755s;;;0.000000;10.000000' WHERE instance_id=11 AND service_object_id=1820060 AND start_time=FROM_UNIXTIME(1272467286) AND start_time_usec=435724
[1272467286.439919] [001.2] [pid=9248] ndo2db_handle_db_error() start
[1272467286.439928] [001.2] [pid=9248] ndo2db_db_disconnect() start
[1272467286.440097] [001.2] [pid=9248] ndo2db_db_disconnect() stop
[1272467286.440107] [001.2] [pid=9248] ndo2db_handle_db_error() end
[1272467286.440114] [001.2] [pid=9248] ndo2db_db_query(-1) end
[1272467286.440137] [001.2] [pid=9248] ido2db_query_insert_or_update_servicecheckdata_add() end
[1272467286.440145] [001.2] [pid=9248] ndo2db_handle_servicecheckdata() end
[1272467286.440152] [001.2] [pid=9248] ndo2db_free_input_memory() start
[1272467286.440159] [001.2] [pid=9248] ndo2db_free_input_memory() end
[1272467286.440188] [001.2] [pid=9248] ndo2db_end_input_data() end
[1272467286.440196] [001.2] [pid=9248] ndo2db_handle_client_input() end
[1272467286.440204] [001.2] [pid=9248] ndo2db_handle_client_input() start
[1272467286.440212] [001.2] [pid=9248] ndo2db_check_for_client_input() end
[1272467286.440219] [001.2] [pid=9248] ndo2db_db_goodbye() start
[1272467286.440225] [001.2] [pid=9248] ndo2db_db_timet_to_sql() start
[1272467286.440231] [001.2] [pid=9248] ndo2db_db_timet_to_sql() end
[1272467286.440242] [001.2] [pid=9248] ndo2db_db_query() start
[1272467286.440248] [002.0] [pid=9248] UPDATE icinga_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(0), bytes_processed='3526508', lines_processed='354293', entries_processed='9194' WHERE conninfo_id='4368'
[1272467286.440260] [001.2] [pid=9248] ndo2db_child_sighandler() start
[1272467286.440268] [001.2] [pid=9248] Child caught signal '11' exiting
[1272467286.440274] [001.2] [pid=9248] ndo2db_child_sighandler() end
[1272467286.440280] [001.2] [pid=9248] ndo2db_cleanup_socket() start
[1272467286.440321] [001.2] [pid=9248] ndo2db_cleanup_socket() end
[1272467286.440329] [001.2] [pid=9248] ndo2db_free_program_memory() start
[1272467286.440336] [001.2] [pid=9248] ndo2db_free_program_memory() end

Associated revisions

Revision 0a98462f
Added by dnsmichi almost 4 years ago

modify string escaping again for mysql, pgsql

needs a rewrite though. the actual solution is not acceptable anymore.

fixes #384

History

#1 Updated by dnsmichi almost 4 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF