Bug#431598: jffnms: MySQL error in SLA Individual Conditions creation

2007-07-04 Thread Mathieu PARENT 

On 7/4/07, Craig Small <[EMAIL PROTECTED]> wrote:

For some reason you have not updated the database even though the change
is shipped in the package.  I'm not sure exactly why this is the case
but running the following in a mysql cli will do it:

ALTER TABLE `slas_cond` CHANGE `condition` `cond` CHAR( 250 ) NOT NULL;

It's present in the patch and also in the new install scripts so I'm
not sure how you have slipped through.

 - Craig


OK. Thanks ! it's working now. You can close the bug.

Before etch, we were using upstream version of jffnms. The upgrade
seems to be fine. But it wasn't.


--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Bug#431598: jffnms: MySQL error in SLA Individual Conditions creation

2007-07-03 Thread Craig Small 
On Tue, Jul 03, 2007 at 07:50:40PM +0200, Mathieu PARENT wrote:
> Query failed - db_update(slas_cond) - Update slas_cond set description = 
> 'test',event = 'test',cond = '1=2',variable_show = 
> 'test',variable_show_info = '' where slas_cond.id = '10003' - Unknown 
> column 'cond' in 'field list'

For some reason you have not updated the database even though the change
is shipped in the package.  I'm not sure exactly why this is the case
but running the following in a mysql cli will do it:

ALTER TABLE `slas_cond` CHANGE `condition` `cond` CHAR( 250 ) NOT NULL;

It's present in the patch and also in the new install scripts so I'm 
not sure how you have slipped through.

 - Craig
-- 
Craig Small  GnuPG:1C1B D893 1418 2AF4 45EE  95CB C76C E5AC 12CA DFA5
http://www.enc.com.au/ csmall at : enc.com.au
http://www.debian.org/  Debian GNU/Linux, software should be Free 


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Bug#431598: jffnms: MySQL error in SLA Individual Conditions creation

2007-07-03 Thread Mathieu PARENT 
Package: jffnms
Version: 0.8.3dfsg.1-2.1
Severity: normal

Steps to reproduce :
* Go in ''Administration'' > SLA Definitions > Individual Definintions
* Add
** Description : test
** Show info : test
** COndition : 1=2
** Show expression : test
** Show unit :
* Click: Save

Actual result :
19:48:05 db_ping(mysql) Connection to DB Restored...
19:48:06 db_ping(mysql) Connection to DB Restored... 
19:48:07 db_ping(mysql) Connection to DB Restored... 
19:48:08 db_ping(mysql) Connection to DB Restored... 
19:48:09 db_ping(mysql) Connection to DB Restored... 
Query failed - db_update(slas_cond) - Update slas_cond set description = 
'test',event = 'test',cond = '1=2',variable_show = 
'test',variable_show_info = '' where slas_cond.id = '10003' - Unknown 
column 'cond' in 'field list'

Expected result : condition added to table.

It seems to be an upstream bug. But i can't find upstream issue tracker.


-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-4-686-bigmem
Locale: LANG=fr_FR, LC_CTYPE=fr_FR (charmap=ISO-8859-1)

Versions of packages jffnms depends on:
ii  adduser3.102 Add and remove users and groups
ii  apache22.2.3-4   Next generation, scalable, extenda
ii  apache2-mpm-prefork [httpd 2.2.3-4   Traditional model for Apache HTTPD
ii  cron   3.0pl1-100management of regular background p
ii  dbconfig-common1.8.29+etch1  common framework for packaging dat
ii  debconf [debconf-2.0]  1.5.11Debian configuration management sy
ii  libapache2-mod-php55.2.0-8+etch4 server-side, HTML-embedded scripti
ii  mysql-client-5.0 [mysql-cl 5.0.32-7etch1 mysql database client binaries
ii  php5-cli   5.2.0-8+etch4 command-line interpreter for the p
ii  php5-gd5.2.0-8+etch4 GD module for php5
ii  php5-mysql 5.2.0-8+etch4 MySQL module for php5
ii  php5-snmp  5.2.0-8+etch4 SNMP module for php5
ii  rrdtool1.2.15-0.3Time-series data storage and displ

Versions of packages jffnms recommends:
ii  fping  2.4b2-to-ipv6-14  sends ICMP ECHO_REQUEST packets to
ii  nmap   4.11-1The Network Mapper
ii  ntp1:4.2.2.p4+dfsg-2 Network Time Protocol daemon and u
ii  ttf-bitstream-vera 1.10-7The Bitstream Vera family of free 

-- debconf information excluded


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]