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
"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:
1) svn update
2) ./discovery.php -u
It ran as:
root@kh26-42:/opt/observium# ./discovery.php -u ___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|
Observium Professional 20.7.10615
https://www.observium.org-- 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:
1) svn update -r 9932.
And we could see the schema in /opt/observium/update was upto 412.sql
2. 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
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:
1) when we run 'svn update' it never prompts for user/pwd. Please note that we have a valid subscription & user/pwd
2) 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!RegardsRenuka Arya
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium