Nagios XI Installer fails on a fresh EC2 instance

[MatteoSp]

I've just launched an EC2 instance based on the official AMI ami-ff142c8b (nagiosxi/centos/6/2.2-SNAPSHOT-1/x86_64).

The installer fails at very first step with message "Unable to get user id for admin account". On the top of the page I see what it seems to be a debug message, saying "SQL: SQL Error [nagiosxi] : ERROR: relation "xi_users" does not exist LINE 1: SELECT * FROM xi_users WHERE username='nagiosadmin' ^".

What can i do?

thanks
m.

[scottwilkerson]

I am trying to replicate this, I will report back once I have dug in a little more

[scottwilkerson]

What was the page where you saw this error? Was it on the /nagiosxi/install.php page?

I just started the same image
waited for the install to complete (about 15 minutes)
and could not replicate the error

[MatteoSp]

Yes, it was that page. How can I know when the installation completes?

[scottwilkerson]

Once you can reach that page it should be complete.

Somehow the initial setup of postgres must not have happened.

As of now we have the installer running on first boot. Can you launch a new instance, if the problem persists, I could make an AMI that has XI fully installed and ready to go.

[MatteoSp]

I tried another time, changing instance type from micro to small. I was able to complete the installation and now I'm experimenting nagios, thank you.

By the way: have you ever thought about an RDS based AMI? Could help to run on micro instance...

[scottwilkerson]

This has been a thought, but certainly not for the reason of having the ability to run on a micro instance. this would not be prudent because the cost of the RDS + micro instance would exceed the cost of a small instance.

Additionally, a micro instance has severely reduced network and disk IO which will be a problem.

Setting up RDS for the database would be a good idea for performance, you could follow our offload MySQL document steps.

[MatteoSp]

I was thinking to customers (like me) who already have RDS, but I got your point.

tks
m.

[scottwilkerson]

Yeah, if you have RDS already setup, offloading the MySQL will help performance a ton.