Your message dated Tue, 02 Oct 2012 17:43:21 +0200
with message-id <[email protected]>
and subject line Re: Bug#689435: netams: "does not work correctly with mysql
5.5+"
has caused the Debian Bug report #689435,
regarding netams: "does not work correctly with mysql 5.5+"
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
689435: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=689435
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: netams
Version: 3.4.5-2
Severity: normal
Tags: patch
User: [email protected]
Usertags: origin-ubuntu quantal ubuntu-patch
In Ubuntu, the attached patch was applied to achieve the following:
Netams does not work correctly with current version of MySQL (5.5).
When program uses "LOAD DATA CONCURRENT LOCAL INFILE ..." statement,
MySQL's "Malformed package" error occurs.
The reason is that in previous version of mysqlclient "local infile"
option is set to "true" by default and all works correctly,
but in the latest version it is set to "false".
So according to MySQL manual
(http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html),
using of "LOAD DATA LOCAL" statement requires call of
mysql_options(..., MYSQL_OPT_LOCAL_INFILE, 0) between mysql_init()
and mysql_connect().
-- System Information:
Debian Release: wheezy/sid
APT prefers precise-updates
APT policy: (500, 'precise-updates'), (500, 'precise-security'), (500,
'precise'), (100, 'precise-backports')
Architecture: amd64 (x86_64)
Kernel: Linux 3.2.0-31-generic (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
=== modified file 'debian/changelog'
=== added file 'debian/patches/16_fix_mysql_load_data.patch'
--- debian/patches/16_fix_mysql_load_data.patch 1970-01-01 00:00:00 +0000
+++ debian/patches/16_fix_mysql_load_data.patch 2012-08-05 13:14:42 +0000
@@ -0,0 +1,18 @@
+Description: Set 'local-infile' option for using with MySQL.
+ According to MySQL's manual, using of "LOAD DATA LOCAL INFILE"
+ statement requires 'local-infile' option set to 'true'. Without that,
+ 'Malformed packet' error occurs.
+Author: Dmitriy Alexandrov <[email protected]>
+Index: netams.dev/src/st_sql_mysql.c
+===================================================================
+--- netams.dev.orig/src/st_sql_mysql.c 2012-08-05 15:38:01.000000000 +0400
++++ netams.dev/src/st_sql_mysql.c 2012-08-05 15:45:01.000000000 +0400
+@@ -56,6 +56,8 @@
+ return NULL;
+ }
+
++ mysql_options(fd, MYSQL_OPT_LOCAL_INFILE, 0);
++
+ my_host=cfg->hostname;
+ my_user=cfg->username;
+ my_pass=cfg->password;
=== modified file 'debian/patches/series'
--- debian/patches/series 2010-07-06 03:29:43 +0000
+++ debian/patches/series 2012-08-05 11:41:54 +0000
@@ -7,3 +7,4 @@
13_netams_web_conf.diff
14_fix_pthread.diff
15_fix_ftbfs_kfreebsd.diff
+16_fix_mysql_load_data.patch
--- End Message ---
--- Begin Message ---
Dmitriy Alexandrov <[email protected]> writes:
> Package: netams
The netams package was removed from Debian a little while ago:
http://packages.qa.debian.org/n/netams/news/20120828T155554Z.html
Since the package does not exist anymore, neither in sid, nor anywhere
else, I'm closing this bug.
--
|8]
--- End Message ---
