Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #384] modify string escaping again (mysql, pgsql) #173

Closed
icinga-migration opened this issue Apr 28, 2010 · 1 comment
Closed

Comments

@icinga-migration
Copy link

This issue has been migrated from Redmine: https://dev.icinga.com/issues/384

Created by mfriedrich on 2010-04-28 16:12:10 +00:00

Assignee: mfriedrich
Status: Resolved (closed on 2010-04-29 14:25:24 +00:00)
Target Version: 1.0.2
Last Update: 2010-04-29 14:25:24 +00:00 (in Redmine)


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

Changesets

2010-04-29 14:25:04 +00:00 by mfriedrich 0a98462

modify string escaping again for mysql, pgsql

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

fixes #384
@icinga-migration
Copy link
Author

Updated by mfriedrich on 2010-04-29 14:25:24 +00:00

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

Applied in changeset commit:"0a98462f01f6cdf7b4fda3ad0b78e0c8658f5761".

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant