Ubuntu
netams package

does not work correctly with mysql 5.5

Bug #1060320 reported by Dmitriy Alexandrov on 2012-10-02

This bug affects 1 person

	Status	Importance	Assigned to
netams (Ubuntu)	Invalid	Undecided	Dmitriy Alexandrov
Precise	Fix Released	High	Unassigned
Quantal	Invalid	Undecided	Dmitriy Alexandrov

Bug Description

[IMPACT]
I'm using MySQL database as "service storage".
But netams does not save information to database and writes to log:

02.10.2012 20:22:33.8491 storage:1 [WARN]: mysql DB:1 connection to database net
02.10.2012 20:22:33.8497 storage:1 [WARN]: SQL Load data: Malformed packet
02.10.2012 20:22:33.8497 storage:1 [WARN]: mysql show command failed: Lost conne
02.10.2012 20:22:33.8498 storage:1 [WARN]: mysql show command failed: MySQL serv
02.10.2012 20:22:33.8498 storage:1 [WARN]: Failed load data into sql for raw try

At the same time, MySQL writes to log:
121002 20:22:33 99 Connect netams@localhost on netams
99 Query show tables like 'raw'
99 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.raw' INTO TABLE raw FIELDS TERMINATED BY ','
100 Connect netams@localhost on netams
100 Query show tables like 'summary'
100 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.sum' REPLACE INTO TABLE summary FIELDS TERMINATED BY ','

And according to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html), this bug can be fixed by setting in program "MYSQL_OPT_LOCAL_INFILE" option to "true".

[TESTCASE]
Using of MySQL database as "service storage", for example "service storage" config in file /etc/netams/netams.conf:

service storage 1
type mysql
host "localhost"
user "netams"
password "password"
dbname "netams"
socket "/var/run/mysqld/mysqld.sock"

[Other Info]

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: netams 3.4.5-2ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic 3.2.28
Uname: Linux 3.2.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Tue Oct 2 20:37:17 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: netams
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.netams: [modified]
mtime.conffile..etc.default.netams: 2012-10-02T20:07:05

See original description

Tags:

Related branches

lp:ubuntu/precise-proposed/netams

Revision history for this message

Dmitriy Alexandrov (d06alexandrov) wrote on 2012-10-02:

Dependencies.txt Edit (827 bytes, text/plain; charset="utf-8")

16_fix_mysql_load_data.patch Edit (698 bytes, text/plain)

Changed in netams (Ubuntu):
assignee:	nobody → Dmitriy Alexandrov (d06alexandrov)
status:	New → Fix Released

Dmitriy Alexandrov (d06alexandrov) on 2012-10-02

description:

updated

Dmitriy Alexandrov (d06alexandrov) on 2012-10-02

description:

updated

Revision history for this message

Dmitriy Alexandrov (d06alexandrov) wrote on 2012-10-02:

netams.debdiff Edit (1.9 KiB, text/plain)

Changed in netams (Ubuntu Precise):
status:	New → Fix Released
Changed in netams (Ubuntu):
status:	Fix Released → New

Revision history for this message

Dimitri John Ledkov (xnox) wrote on 2012-10-03:

This package has been removed in quantal:
Removal requested 22 hours ago.
Deleted 22 hours ago by Colin Watson
(From Debian) ROM; Abandoned upstream, buggy.; Debian bug #685954; LP: #1059008

So, closing quantal task, keeping precise task.

Changed in netams (Ubuntu Quantal):
status:	New → Invalid
Changed in netams (Ubuntu Precise):
status:	Fix Released → Confirmed
importance:	Undecided → High

Revision history for this message

Martin Pitt (pitti) wrote on 2012-10-08:

Uploaded to precise-proposed queue for SRU team review. Unsubscribing sponsors. Thanks!

Changed in netams (Ubuntu Precise):
status:	Confirmed → In Progress

Revision history for this message

Clint Byrum (clint-fewbar) wrote on 2012-11-07: Please test proposed package

Hello Dmitriy, or anyone else affected,

Accepted netams into precise-proposed. The package will build now and be available at http://launchpad.net/ubuntu/+source/netams/3.4.5-2ubuntu3 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation how to enable and use -proposed. Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please change the bug tag from verification-needed to verification-done. If it does not, change the tag to verification-failed. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

Changed in netams (Ubuntu Precise):
status:	In Progress → Fix Committed
tags:	added: verification-needed

Dmitriy Alexandrov (d06alexandrov) on 2012-11-10

tags:

added: verification-done
removed: verification-needed

Revision history for this message

Dmitriy Alexandrov (d06alexandrov) wrote on 2012-11-10:

It works good with the same "service storage" config as in Bug description's TESTCASE.
(and now there is no warnings in Netams's log)

Revision history for this message

Clint Byrum (clint-fewbar) wrote on 2012-11-15: Update Released

The verification of this Stable Release Update has completed successfully and the package has now been released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regresssions.

Revision history for this message

Launchpad Janitor (janitor) wrote on 2012-11-15:

This bug was fixed in the package netams - 3.4.5-2ubuntu3

---------------
netams (3.4.5-2ubuntu3) precise-proposed; urgency=low

* debian/patches/16_fix_mysql_load_data.patch: fix errors with usage
of mysql's statement "LOAD DATA LOCAL INFILE". (LP: #1060320)
-- Dmitriy Alexandrov <email address hidden> Sun, 05 Aug 2012 15:45:07 +0400