Re: [Observium] Cannot login to my observium UI after the upgrade

24 Aug 2020

      That seems to totally work! Thanks!
Regards
Renuka Arya
On Mon, Aug 24, 2020 at 11:03 AM Adam Armstrong adama@observium.org wrote:
...
Hi,
We drop sessions when the IP changes. I’m not quite sure why anymore, but
it was a security thing we added a few years ago.
You can disable this behaviour with :
$config['web_session_ip']       = FALSE;     // Bind user sessions to his
IP address
This setting is in the web config in Authentication -> Sessions -> Session
bind to IP
Thanks,
Adam.
*From:* Renuka Arya rarya@uchicago.edu
*Sent:* 24 August 2020 16:52
*To:* Adam Armstrong adama@observium.org; Renuka Arya via observium <
observium@observium.org>
*Subject:* Re: [Observium] Cannot login to my observium UI after the
upgrade
Hi Adam!
Few update!
We figured that we are able to access the observium server just fine (no
authentication issues); if we access it directly.
The issue arises when we try to thought our F5 load balancer setup; where
the Virtual IP/host is configure on F5 pointing to the server running the
observium. We have opened up a case with F5 to investigate more into it.
But was wondering if you have seen any issues with new code [20.7.10549]
going via a LB/proxy or as such.
Please see the attached screenshots for reference;
Regards
Renuka Arya
On Mon, Aug 10, 2020 at 10:16 AM Adam Armstrong adama@observium.org
wrote:
You should probably upgrade the system to 18.04 (and then probably 20.04,
Observium gets a lot of benefit from performance improvements in the newer
PHP and RRDtool) and then svn up again.
It might well be quicker to transplant the install to a new 20.04 install,
Observium is only the MySQL db, the rrd directory and the config.php.
You can follow the install guide and then replace these at the end of the
install.
Adam.
*From:* Renuka Arya rarya@uchicago.edu
*Sent:* 10 August 2020 15:52
*To:* Adam Armstrong adama@observium.org
*Subject:* Re: [Observium] Cannot login to my observium UI after the
upgrade
So,  what are your suggestions?
Our current database is for 20.7.10615. But the code it is running is
19.6.9932
I understand, we prolly need to upgrade PHP to 7.1 or 7.2 ; not sure in
what sequence should be running the svp updates?
Regards
Renuka Arya
On Mon, Aug 10, 2020 at 8:55 AM Adam Armstrong adama@observium.org
wrote:
I think the problems come from PHP 7.0, I think it has some issues. Our
minimum requirement is 7.1, though I think we need to change that to 7.2
now.
The latest stable is whatever the revision of the last change to the
stable tree is:
https://www.observium.org/versions.php
https://urldefense.com/v3/__https:/www.observium.org/versions.php__;!!BpyFHLRN4TMTrA!tp_P30ZrHNpexNCEypNBUPr3R6h1k0EL4bjTMJRmUdvxh_eV-vVVNwYb6NqlFL8N$
"stable":{"version":"20.7.10549","revision":"10549","date":"2020-07-03"}
"current":{"version":"20.7.10614","revision":"10614","date":"2020-07-24"}
The versions are not important numbers, they’re just autogenerated
revisions within svn.
Adam.
*From:* Renuka Arya rarya@uchicago.edu
*Sent:* 10 August 2020 14:37
*To:* Adam Armstrong adama@observium.org
*Subject:* Re: [Observium] Cannot login to my observium UI after the
upgrade
lacadmin@kh26-42:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.5 LTS
Release: 16.04
Codename: xenial
lacadmin@kh26-42:~$ php -v
PHP 7.0.33-0ubuntu0.16.04.15 (cli) ( NTS )
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
    with Zend OPcache v7.0.33-0ubuntu0.16.04.15, Copyright (c) 1999-2017,
by Zend Technologies
lacadmin@kh26-42:~$ mysql -V
mysql  Ver 15.1 Distrib 10.2.21-MariaDB, for debian-linux-gnu (x86_64)
using readline 5.2
What is the latest stable version of Observium?
Version 20.7.10614 ?
On Mon, Aug 10, 2020 at 8:24 AM Adam Armstrong adama@observium.org
wrote:
You’re still running schema 432, the database can’t be downgraded. I’m not
sure exactly what has changed in that time, but likely a number of things
will be broken.
What is this running on? What is the PHP and MySQL/Mariadb version?
Adam.
*From:* Renuka Arya rarya@uchicago.edu
*Sent:* 10 August 2020 14:18
*To:* Adam Armstrong adama@observium.org
*Subject:* Re: [Observium] Cannot login to my observium UI after the
upgrade
Hello
We run the following commands, when we first were trying to upgrade:

svn update

./discovery.php -u

It ran as:
root@kh26-42:/opt/observium# ./discovery.php -u  ___   _                              _
 / _ \ | |__   ___   ___  _ __ __   __(_) _   _  _ __ ___
| | | || '_ \ / __| / _ | '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |__ |  __/| |    \ V / | || |_| || | | | | |
 ___/ |_.__/ |___/ ___||_|     _/  |_| __,_||_| |_| |_|
                          Observium Professional 20.7.10615
                                  https://www.observium.org https://urldefense.com/v3/__https:/www.observium.org/__;!!BpyFHLRN4TMTrA!u_K5h8PRhlXJ3BK0rjjUtAm_SPuYo7VVjwBiW8Q51dGfCU5suHx5AK97blB9dPs3$-- Updating database/file schema
412 -> 413 # (php)  Done (0s).
413 -> 414 # (db) . Done (15s).
414 -> 415 # (php) Unificate GEO Country names: . Done (1s).
415 -> 416 # (db) .. Done (2s).
416 -> 417 # (db) .. Done (4s).
417 -> 418 # (db) . Done (1s).
418 -> 419 # (db) .... Done (3s).
419 -> 420 # (db) .. Done (3s).
420 -> 421 # (db) ... Done (2s).
421 -> 422 # (db) .. Done (0s).
422 -> 423 # (db) ...... Done (9s).
423 -> 424 # (php) Update IPv4 addresses: ...........................................................................................................................................................................................................................................................................................................
Update IPv6 addresses: .....................
 Done (0s).
424 -> 425 # (db) . Done (29s).
425 -> 426 # (db) ............... Done (16s).
426 -> 427 # (db) ... Done (44s).
427 -> 428 # (db) ... Done (3s).
428 -> 429 # (db) ..... Done (7s).
429 -> 430 # (db) (WARNING! Required MySQL version 5.6+ or MariaDB 10.0+)... Done (0s).
430 -> 431 # (db) ..... Done (4s).
431 -> 432 # (php)  Done (1s).
-- Done.
This upgraded  from Observium 19.6.9932 to Observium Professional
20.7.1061
We noticed this
429.sql:ALTER TABLE `autodiscovery` ADD INDEX `remote_hostname_ip` (`poller_id`, `remote_hostname`, `remote_ip`);
430.sql:ALTER TABLE `autodiscovery` ADD INDEX `remote_hostname_ip` (`poller_id`, `remote_hostname`, `remote_ip`);
When  we tried to login as my user/admin; it will let me in but as an
`unauthenticated` user BUT will not display stuff properly; infact will
kick me out , when I tried to click on things. It seems the poller were
still working but authentication was broken
At this point we downgraded observium as:

svn update -r 9932.

And we could see the schema in /opt/observium/update was upto 412.sql

We did not run ./discovery -u after this.

After doing this I can login to observium just fine and see all the graphs
etc just fine
Thanks!
Regards
Renuka Arya
./
On Sun, Aug 9, 2020 at 9:44 PM Adam Armstrong adama@observium.org wrote:
You don’t run discovery after downgrading, you run it after upgrading.
You can’t downgrade because database changes are not reversible.
Downgrading will probably break your database.
The latest stable version is whatever Observium says it is after you do
“svn up”. Ignore what SVN says, that’s just the repository revision.
Did you run discovery -u after the initial upgrade attempt?
Adam.
*From:* Renuka Arya rarya@uchicago.edu
*Sent:* 07 August 2020 14:23
*To:* Adam Armstrong adama@observium.org
*Cc:* Renuka Arya via observium observium@observium.org
*Subject:* Re: [Observium] Cannot login to my observium UI after the
upgrade
Hi Adam,
Thanks for your reply!
No we didn't run  ./discovery.php -u after downgrading to 19.6.9932. I am
supposing we should not run it as it's going to break the DB?
What options do we have now?
Also, what is the latest stable release; svn update, updates it to 20.7.10615
whereas observium says it is Version 20.7.10614
On Thu, Aug 6, 2020 at 8:57 PM Adam Armstrong adama@observium.org wrote:
Hi,
Did you run ./discovery.php -u ?
If you didn't, that'd explain it. If you did, downgrading will break your
database.
But if it you had done that and it wasn't working, the likely causes are
either database desync or local modifications.
The former is pretty difficult and time consuming to track down, and
usually involves removing the database and readding all of the devices.
Adam.
Sent from BlueMail
https://urldefense.com/v3/__http:/www.bluemail.me/r?b=15919__;!!BpyFHLRN4TMTrA!pbbFF3mknkvJI1iDdDz-c24Sof8OpK0cjS5z5IqsyUaMOopTjybHQdOXWbWl43L5$
On 6 Aug 2020, at 19:18, Renuka Arya via observium <
observium@observium.org> wrote:
Update ; so we rolled back to the current version - O bservium 19.6.9932
and it seems to be fixed now.
However, we noticed two things:

when we run 'svn update' it never prompts for user/pwd. Please note

that we have a valid subscription & user/pwd

After we run 'svn update' it updates to  20.7.10615 . However, our

observium site says : So lookslike just running svn update is not updating
to current stable version?
There is a newer revision of Observium available!
Version 20.7.10614 (6th August 2020) is 682 revisions ahead.
On Thu, Aug 6, 2020 at 11:18 AM Renuka Arya < rarya@uchicago.edu> wrote:
Hello Team,
I upgraded my Observium from  Observium 19.6.9932 to Observium
Professional 20.7.10615 this morning.
I cannot login to the UI now; With my user and admin user it lets me in as
unauthenticated, shows broken graphs and kicks me out or would say  *Remote
IP has changed.*
and we see this
[2020/08/06 09:47:42 -0500] discovery.php(8383): ====== Schema update 429 -> 430 ==============
[2020/08/06 09:47:42 -0500] discovery.php(8383): Query: ALTER TABLE `autodiscovery` ADD INDEX `remote_hostname_ip` (`poller_id`, `remote_hostname`, `remote_ip`);
[2020/08/06 09:47:42 -0500] discovery.php(8383): Error: (1061) Duplicate key name 'remote_hostname_ip'
Any help will be appreciated!
Thank you!
Regards
Renuka Arya

observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium https://urldefense.com/v3/__http:/postman.memetic.org/cgi-bin/mailman/listinfo/observium__;!!BpyFHLRN4TMTrA!pbbFF3mknkvJI1iDdDz-c24Sof8OpK0cjS5z5IqsyUaMOopTjybHQdOXWV_nyKiA$

Renuka Arya

tags (0)

participants (1)