Whoops, accidentally sent too soon!
This added the field to the table:
update/467.sql:ALTER TABLE `users` ADD `type` VARCHAR(16) NOT NULL DEFAULT 'mysql' AFTER `user_options`;
If you don' thave this field, you might just have very old schema and for some reason no automated discovery.php -u. You can manually run ./discovery.php -u from the observium directory and see if it updates the schema.
If not, something very odd has happened, and it might not be easily possible to retain the database without manually checking every one of hundreds of changes to make sure they've all been performed correctly.
Hopefully forcing the schema update works!
Thanks,. adam,.
Adam Armstrong wrote on 07/09/2023 23:16:
Hi Anthony,
It looks like your database hasn't been updated to the latest schema. This should happen automatically even if you forget to run "./discovery.php -u" after an upgrade, so I'm not sure how this might have happened.
You can look at the "dbSchema" entry in the observium_attribs table to see if it matches the highest filename in the updates/ directory.
The type field you're missing was added in schema 467 :
adam.
Anthony Polselli via observium wrote on 06/09/2023 18:22:
Hi all,
Been using Observium for many years and it’s been great. But finally trying to migrate it to a new server running Ubuntu 22 (from Ubuntu 14) and it’s been a struggle. I’ve followed these steps (https://docs.observium.org/server-migration/) but I’m not a Ubuntu / MySQL tech. I built a new Ubuntu server, installed Observium with the script and was able to login. Now, after I restore the rrd files and MySQL DB, I can’t login to the web interface. I setup debug and got this below. I tried adding a new user with adduser.php and it looks like it worked, but can’t login still. Thanks!
Thanks,
*Anthony Polselli*
*Chief Technology Officer*
*Natural Networks, Inc.*
7047 Carroll Rd.
San Diego, CA 92121
anthony@naturalnetworks.com mailto:anthony@naturalnetworks.com__
http://www.naturalnetworks.com http://www.naturalnetworks.com/
(619) 222-3232, ext: 101 office
observium mailing list --observium@lists.observium.org To unsubscribe send an email toobservium-leave@lists.observium.org
