DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO)

Submitted by giriji on Sat, 04/30/2016 - 11:35

Hi,

My client have a CentOS 7 machine in which I install webmin/virtualmin every 4months... Today facing a problem on new installation of Virtualmin. I have already checked with reinstalling CentOS as well.

I have a server with following OS installation [root@prowog ~]# uname -a Linux prowog.com 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux [root@prowog ~]# [root@prowog ~]# cat /etc/redhat-release CentOS Linux release 7.2.1511 (Core)

I have run webmain installation and virtualmin installation from scripts rpm -U webmin-1.791-1.noarch.rpm & wget http://software.virtualmin.com/gpl/scripts/install.sh sh install.sh

Now after this I log in to https://IP:10000/ with root credentials

After that start mailman service from webmin>Bootup and shutdown.. and then go to Virtualmin>System Settings>Re-check configuration.

Now it goes to basic pre server installation script ... where need to check different setting.. Normally it goes smoothly but this time when I put MySQL password (First Time), I get following error " DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO) " After that I went to Webmin>Server>MySQL Module but nothing... there they also ask username and pass... since I didn't set pass yet so I don't know what to do .

This issue is also with another server ... same CentOS 7 installation and Virtualmin installation.. Please check

Is it CentOS installation or something else??

Parent issue: 
#21499: DBI connect failed : Access denied for user 'root'@'localhost'
Status: 
Active

Comments

Submitted by giriji on Sat, 04/30/2016 - 11:36

Hi, If you require to check then I can send you login credentials.... Thanks

Submitted by giriji on Sat, 04/30/2016 - 11:54

Got it working...

Actually at wizard after you set mysql password it says DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO)

and interupts the installation wizard... and if you go to recheck configuration page again it says you need to go to MySQL config module

and if you go to Webmin>Servers>Mysql Database server it will ask for username and password. Just put username root and password which you add at time of wizard (after which you get DBI Connection failed error) and press login and done.. It will login normally and then you can go to Virtualmin > System settings>Re check configuration and this time it will not show the DBI connection failed error...

It is my request to make this request public so others don't panic like me :D :D

Thanks Kishan Giri

Submitted by andreychek on Sat, 04/30/2016 - 12:35

Glad you got it figured out!

That's an unusual set of problems you ran into, setting the password during the post-install wizard should be all you need to do.

We'll look deeper into that to see if we can make the process smoother.

Submitted by p8092040 on Thu, 05/12/2016 - 02:29

I have exactly the same problem, first with the GPL and also with the purchased Pro version.

The solution for the PRO version is as described by Kishan Giri timestamped April 30, 2016.

For your current GPL version, I was unable to get past this problem. I'm using a Grade A operating system, per your list.

Submitted by paulzag on Mon, 06/13/2016 - 09:22 Pro Licensee

Rebuilt VPS (OpenVZ SSD 2GB RAM) today with Ubuntu server 14.04.2 x86 (32-bit) with Virtualmin GPL via install.sh

DBI connect failed : Access denied for user 'root'@'localhost' (using password: NO)

I have to go to MySQL module index and enter password again. But now I can't re-run the post install wizard.

Re-Check configuration

Your Postfix configuration is missing the system's mail hostname UNKNOWN from the mydestination line, which will cause mail to bounce. The current value is localdomain, localhost, localhost.localdomain, localhost, subdomain.tld.com.

.. your system is not ready for use by Virtualmin.

I now have to fix each step manually.

Submitted by andreychek on Mon, 06/13/2016 - 09:40

Howdy -- the next version of Virtualmin will better handle the issue of a MySQL password being set prior to Virtualmin being installed.

However, you can re-run the install wizard by going into System Settings... though it's possible that won't show up until the Re-Check Config passes.

Note that the error you're seeing in the Re-Check config isn't related to the post-install wizard not finishing. That just looks like a general configuration issue you're seeing there. If you continue to experience that email error, you may want to start a new Forum thread about that (if you're using Virtualmin GPL, if you're using Virtualmin Pro you can start a new support ticket too).

Submitted by pixelpadre on Tue, 06/21/2016 - 13:21

I had the same password problem during wizard. I did as suggested and rechecked config. It gave me the chance to enter a password.

Submitted by andreychek on Tue, 06/21/2016 - 13:33

Are things working properly now for you pixelpadre?

Submitted by pixelpadre on Tue, 06/21/2016 - 13:42

YES works after your advice to recheck config from left menu.