LXD install error - access denied for globeadmin

[wells]

I have tried to install nuBuilder in an LXD container following Brian Mullen's How to install nuBuilder on Ubuntu 18.04.

All went well up to the point of testing access by the globeadmin user.

I had configured the mysql root password in nuconfig.conf
I opened ports 80 and 8080

Code: Select all

ufw allow 80
ufw allow 8080

But then attempting to login as globeadmin failed:

Code: Select all

mysql -u globeadmin -p
nu

ERROR 1045 (28000): Access denied for user 'globeadmin'@'localhost' (using password: YES)

I am happy to provide more information. Your help would be appreciated!

[gerese]

Hi, user: globeadmin , is not a database user, globeadmin is use for login interface.

[wells]

@gerese Thank you. As a new user of LXD, I don't know what command to use to login as globeadmin.
Where and how do I use the login interface?

I now understand that globeadmin is a user of LXD, not MySQL.

[gerese]

NuBuilder needs:
Requires: PHP: 5.4.0 (phpMyAdmin that comes with nuBuilder will require PHP 7.1+)
Requires: MySQL: 5.5. (or MariaDB)
Requires: Web server: (for example, Apache or Nginx)


Try : "Installation in LXC Container" from here : https://wiki.nubuilder.cloud/ ... umentation

or

Try: WAMP for Windows on the local station, to get used to nuBuilder, then a back-up of the database, you can load it on any machine with Apache+PHP+MySQL+nuBuilder (windows, linux, lxd, vmware, hyper-v)

[wells]

@gerese I installed the dependencies for nuBuilder in the LXD container. No error messages. I installed nuBuilder and made the changes explained by Brian Mullan. I was able to show the nuBuilder tables, so the MySQL nubuilder4 database is working.

I still have trouble opening nuBuilder and will do more research and work on it. When I open the IP address for the LXD container, http://10.204.58.175, I get an error:
Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'nuadmin'@'localhost' (using password: YES)

I suspect I have a LXD networking or rights issues. If you have a fix, great!

Thank you for the link to the installation instructions in the Wiki:
https://andyblight.wordpress.com/2020/0 ... der-forte/

If I can't get my LXD container working, I will try over again with those instructions for LXD. Thank you again!

[kev1n]

This may happen if your root@localhost database user was not granted the necessary rights to access the database. Or if you provided a wrong password

Run this first to check if the user exists for you nuBuilder database:

Code: Select all

SELECT DB, USER FROM mysql.db;

To GRANT ALL privileges to a user run the following:

Code: Select all

GRANT ALL PRIVILEGES ON nubuilder.* TO 'nuadmin'@'localhost';

[wells]

Unfortunately, I get the same error message after taking your suggestions:

Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'nuadmin'@'localhost' (using password: YES)

The nuadmin user was not previously listed as a MySQL database user.
Granting privileges on nuBuilder to nuadmin worked to add nuadmin to the nuBuilder database:
mysql>SELECT DB, USER FROM mysql.db;

Code: Select all

+--------------------+---------------+
| db                 | user          |
+--------------------+---------------+
| nuBuilder          | nuadmin       |
| performance_schema | mysql.session |
| sys                | mysql.sys     |
+--------------------+---------------+

I also ran the command:
mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Ultvart22';

I have added a password for nuadmin in nuconfig.php:
$nuConfigDBUser = "nuadmin";
$nuConfigDBPassword = "Ultvart22";

As for a password problem, where else do I look? Thank you very much!

[kev1n]

In addition, you could try this:

Code: Select all

GRANT ALL PRIVILEGES ON nubuilder4.* TO 'nuadmin'@'%';

[Janusz]

Are you able to access DB from terminal with the following (on root login)

Code: Select all

mysql -u nuadmin -pUltvart22 nubuilder4

[wells]

Hooray! I am in!

For whatever reason, the user nuadmin did not exist as a MySQL user and did not have an assigned password.
@kev1n - Once again you have patiently solved a nuBuilder user's problem.

The commands that solved the login problem were:

mysql> GRANT ALL PRIVILEGES ON nubuilder.* TO 'nuadmin'@'localhost';
mysql> GRANT ALL PRIVILEGES ON nubuilder4.* TO 'nuadmin'@'%';
mysql> ALTER USER 'nuadmin'@'localhost' IDENTIFIED BY 'your-password-here';

Those commands are issued in the nuBuilder LXD container after logging in to MySQL with:
# mysql -u root -p
and entering the MySQL root password.

It is also my intention to publish an updated step-by-step guide for installing nuBuilder on LXD in Ubuntu.

I am very grateful. My next step will be to make a donation after we stop celebrating!