Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

During install/upgrade, database tests are not performed correctly #3055

Closed
eschoeller opened this issue Oct 28, 2019 · 5 comments
Closed

During install/upgrade, database tests are not performed correctly #3055

eschoeller opened this issue Oct 28, 2019 · 5 comments
Assignees
Labels
bug Undesired behaviour resolved A fixed issue
Milestone

Comments

@eschoeller
Copy link

I'm running through new installs on two remote pollers I'm spinning up.

All of the "test connection" checks pass, but the installer bombs out at the end with this in the log:

2019/10/27 21:58:52 - INSTALL: always: Installation was started at 2019-10-28 03:57:47, completed at 2019-10-28 03:58:52
2019/10/27 21:58:52 - INSTALL: always: Failed to connect database
2019/10/27 21:58:52 - INSTALL: always: Finished INSTALL Process for v1.2.7 

The main cacti server has dozens of these in it's mysql log:

2019-10-27 22:01:07 83390 [Warning] Access denied for user 'apache'@'xyz.colorado.edu' (using password: YES)
2019-10-27 22:01:07 83390 [Warning] Access denied for user 'apache'@'xyz.colorado.edu' (using password: YES)
2019-10-27 22:01:07 83390 [Warning] Access denied for user 'apache'@'xyz.colorado.edu' (using password: YES)
2019-10-27 22:01:07 83390 [Warning] Access denied for user 'apache'@'xyz.colorado.edu' (using password: YES

Clearly I have messed up my GRANT directives on the main data collector's database (it's very confusing to get these right in a remote poller setup). But regardless, whatever the "test connection" functions are doing earlier in the installer, they aren't fully verifying that the connection actually works and then the installer bombs out at a complete dead-end. the only way back is to dump the remote poller database and start the installer all over again.

@netniV
Copy link
Member

netniV commented Oct 30, 2019

I will have to see what the test connection is doing. More than likely, it's only checking local database connectivity.

@netniV netniV self-assigned this Oct 30, 2019
@eschoeller
Copy link
Author

I watched communication between the remote data collector and the main data collector during the install. There was lots of traffic from the remote collector to the main data collector's mysql database. Every time I hit "Test Connection" I saw this traffic. But then, in the end, the database connection was still reported as a failure. So, I guess perhaps it's checking to make sure it can hit the database port, but not actually logging in during the test?

@eschoeller
Copy link
Author

Or perhaps I was seeing the login errors on the main collector's database during each one of these checks ... and the remote collector wasn't verifying that it was actually successfully logging in. I can't recall now.

@cigamit cigamit added the unverified Some days we don't have a clue label Nov 9, 2019
@cigamit
Copy link
Member

cigamit commented Nov 9, 2019

@eschoeller, I have not forgotten you. Just so busy. I'm working a few hours today. Marking unverified to the time being.

@cigamit cigamit added bug Undesired behaviour and removed unverified Some days we don't have a clue labels Nov 29, 2019
@cigamit cigamit added this to the v1.2.8 milestone Nov 29, 2019
cigamit added a commit that referenced this issue Nov 29, 2019
Installer database connection checks for remote pollers
@cigamit
Copy link
Member

cigamit commented Nov 29, 2019

This is resolved now.

@cigamit cigamit added the resolved A fixed issue label Nov 29, 2019
@cigamit cigamit assigned cigamit and unassigned netniV Nov 29, 2019
@cigamit cigamit closed this as completed Nov 29, 2019
cigamit added a commit that referenced this issue Nov 29, 2019
@netniV netniV changed the title Installer database connection checks for remote pollers During install/upgrade, database tests are not performed correctly Dec 7, 2019
@github-actions github-actions bot locked and limited conversation to collaborators Jun 30, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Undesired behaviour resolved A fixed issue
Projects
None yet
Development

No branches or pull requests

3 participants