Adam no. I didn't press ctrl-c

On Wednesday, December 23, 2015, <observium-request@observium.org> wrote:
Send observium mailing list submissions to
        observium@observium.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
or, via email, send a message with subject or body 'help' to
        observium-request@observium.org

You can reach the person managing the list at
        observium-owner@observium.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of observium digest..."


Today's Topics:

   1. error when upgrading (Mehmet Akcin)
   2. Re: error when upgrading (Adam Armstrong)
   3. using postfix_qshape (Andry Nata wijaya)


----------------------------------------------------------------------

Message: 1
Date: Wed, 23 Dec 2015 15:07:45 -0800
From: Mehmet Akcin <mehmet@akcin.net>
To: observium@observium.org
Subject: [Observium] error when upgrading
Message-ID: <404A1A6C-BCA5-45ED-8619-6B866E51A5FA@akcin.net>
Content-Type: text/plain; charset="utf-8"

hey there

just moving from community edition to latest subscriber edition

I am getting an error here

root@observium.lax:/opt/observium# ./discovery.php -u

  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
 \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
                        Observium Professional 0.15.12.7231
                                   http://www.observium.org

-- Updating database/file schema
185 -> 186 ... (db) done (9 errors).

any idea how to fix this? here is how my logs look like

root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log
[2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `devices` ADD INDEX `disabled_lastpolled` (`disabled`, `last_polled_timetaken`);
[2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'disabled_lastpolled'
[2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`);
[2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv4_address'
[2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`);
[2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'ipv6_address'
[2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`);
[2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate key name 'device_ma'
[2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE `dbSchema` ADD PRIMARY KEY (`version`);
[2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate entry '185' for key ?PRIMARY'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postman.memetic.org/pipermail/observium/attachments/20151223/8d837973/attachment-0001.html>

------------------------------

Message: 2
Date: Wed, 23 Dec 2015 23:27:41 +0000
From: Adam Armstrong <adama@memetic.org>
To: Observium Network Observation System <observium@observium.org>
Subject: Re: [Observium] error when upgrading
Message-ID:
        <151d12b65c8.2766.0fa97865a0e1ab36152b6b2299eedb49@memetic.org>
Content-Type: text/plain; charset="utf-8"; Format="flowed"

Did you press ctrl-c during an attempted upgrade then restart?

Adam.

Sent with AquaMail for Android
http://www.aqua-mail.com


On 23 December 2015 23:08:06 Mehmet Akcin <mehmet@akcin.net> wrote:

> hey there
>
> just moving from community edition to latest subscriber edition
>
> I am getting an error here
>
> root@observium.lax:/opt/observium# ./discovery.php -u
>
>   ___   _                              _
>  / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
> | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
> | |_| || |_) |\__ \|  __/| |    \ V / | || |_| || | | | | |
>  \___/ |_.__/ |___/ \___||_|     \_/  |_| \__,_||_| |_| |_|
>                         Observium Professional 0.15.12.7231
>                                    http://www.observium.org
>
> -- Updating database/file schema
> 185 -> 186 ... (db) done (9 errors).
>
> any idea how to fix this? here is how my logs look like
>
> root@observium.lax:/opt/observium# tail /opt/observium/logs/update-errors.log
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE
> `devices` ADD INDEX `disabled_lastpolled` (`disabled`,
> `last_polled_timetaken`);
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate
> key name 'disabled_lastpolled'
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE
> `ipv4_addresses` ADD INDEX `ipv4_address` (`ipv4_address`);
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate
> key name 'ipv4_address'
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE
> `ipv6_addresses` ADD INDEX `ipv6_address` (`ipv6_address`);
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate
> key name 'ipv6_address'
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE
> `mac_accounting` ADD INDEX `device_ma` (`device_id`, `ma_id`);
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1061) Duplicate
> key name 'device_ma'
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Query: ALTER TABLE
> `dbSchema` ADD PRIMARY KEY (`version`);
> [2015/12/23 23:03:15 +0000] discovery.php(5774): Error: (1062) Duplicate
> entry '185' for key ?PRIMARY'
>
>
> ----------
> _______________________________________________
> observium mailing list
> observium@observium.org
> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postman.memetic.org/pipermail/observium/attachments/20151223/d5282a1e/attachment-0001.html>

------------------------------

Message: 3
Date: Thu, 24 Dec 2015 03:16:19 +0000 (UTC)
From: Andry Nata wijaya <andrynata_phoenix@yahoo.co.id>
To: "observium@observium.org" <observium@observium.org>
Subject: [Observium] using postfix_qshape
Message-ID:
        <194273203.2788018.1450926979046.JavaMail.yahoo@mail.yahoo.com>
Content-Type: text/plain; charset="utf-8"

Hi everyone,
can any body explain how to using?postfix_qshape working with observium, i'm already setting and work install check-mk-agent on target server has i want to monitored.
i'm already copy script from /observium_install_folder/scripts/agent-local/postfix_qshape to /usr/share/check-mk-agent/local. i test telnet port check-mk-agent service and get output :
bla bla bla blabla bla bla blaMail queue is empty
<<<job>>>
<<<local>>>
<<<postfix_qshape>>>
incoming:0
active:0
deferred:0
hold:0
<<<logins>>>
2
Connection closed by foreign host.

but if i'm check to observium web gui no app shown for postfix_qshape
please help to make postfix qshape work to our monitored server observium
Best regards,Anja
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://postman.memetic.org/pipermail/observium/attachments/20151224/ffc475dd/attachment.html>

------------------------------

Subject: Digest Footer

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium


------------------------------

End of observium Digest, Vol 65, Issue 120
******************************************