Stuck on installation after PostgreSQL conversion

[tboyer]

I'm trying to remove Postgres from one of our installations, following the absolutely excellent web page at https://support.nagios.com/kb/article.php?id=560. Existing instance running 5.5.8. Got through the conversion with no errors; I go to log in again and I'm being sent to nagiosxi/install.php. Click past the General System Settings page; get to Admin Account Settings, and getting an error when I click 'Finish Install' - 'Unable to get user id for admin account.'. Create the nagiosadmin account; try again - same thing.

Any suggestions on getting past this? Thanks...

[tboyer]

... and because I omitted it in the original post: RHEL6.10; physical server.

[npolovenko]

Hello, @tboyer. Please run the following commands as root and then upload the support.txt file from the /tmp/ folder in this thread or send it to me in a personal message.

echo "show tables;" | mysql -u root -pnagiosxi nagiosxi > /tmp/support.txt
echo "SELECT * from xi_users\G;" | mysql -u root -pnagiosxi nagiosxi >> /tmp/support.txt
echo "SELECT * from xi_usermeta\G;" | mysql -u root -pnagiosxi nagiosxi >> /tmp/support.txt

[tboyer]

Completed. I will begin troubleshooting the conversion.

[tboyer]

OK, so: The PG to mysql conversion didn't work. It says it works; it looks like it works - but it tosses out a 193 byte file.

Grabbed the latest from Git, and that one *does* work. 140K file. However, going to Nagios says my license isn't valid.

Hunting for my license key now...

[tboyer]

Re-activated, and it looks kike all is good now. Thanks for the nudge in the right direction!

[lmiltchev]

@tboyer, is it safe to lock this topic now?