ispCP - Board - Support
Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (/thread-7274.html)

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - minjaverde - 07-22-2009 04:55 PM

Hi all,

i tried to make the update from RC4 to 1.0.0. After a Connection interruption during the first update, i did the upgrade again. And now i am having some Problems.

everything works fine except the admin.my-domain.com Page, where i am getting a the Error Message Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

so no Problem ;-) i know my root Passwort for the mysql Database and i can connect localy to my mysql instance, having all the rights on the mysql database and all the other databases.

so my idea was the maybe the Passwort in the /etc/ispcp/ispcp.conf is wrong, but neather the old crypthed password nor the new crypthed password was working.

Probably i lost my Keystore (i think i lost this one, because the default upgrade guide copys the backup to var, witch will be erased i case of a reboot on my server <- i know, i didn't think a lot on the installation) for that would speak that the crypthed Password changed (mysql root password is still the same).

i already tryed to new install over the existing installation without any success. Is there a way to create the crypthed Database Password manualy ?

i just want to be sure before i launch the rescue mission i tried everything Smile

greez minja

Systesm : debian-etch

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - minjaverde - 07-22-2009 07:46 PM

okay guys i' am a step closer :
new problem de encrypth and decrypth returns not de the same value Sad

i add the following lines to my the sql.php fiel ( located ../ispcp/gui/include)
Code:
$password_cx="1234bla7";
$password_en=encrypt_db_password($password_cx);
echo "Passwort en:\" $password_en \"<br>";
$password_de=decrypt_db_password($password_en);
echo "Passwort de:\" $password_de \"<br>";

and the output is :
Passwort en:" w+VvihwpIvEMvQOXxu3ETw== "
Passwort de:" 1234bla€ "

is this a problem or do i need jusst another component ?
sorry this is all a bit confusing for me :-(
okay i am step closer ..

it looks like the script has allways a Problem with the sign on 8 position, because on the decodeing always the 8 postion is bad translated.

01234567890
Passwort en:" ctsbH5XBP8LHVEwDMmL8uQ== "
Passwort de:" 0123456€890 "

good01234567890
Passwort en:" +5e86IBynDN2TSAVvWzEuA== "
Passwort de:" good012„4567890 "

1234567
Passwort en:" JJWr5Bwjc4Y= "
Passwort de:" 1234567 "

is this a know issue ?

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - ephigenie - 07-22-2009 10:15 PM

no its not.

can you give us some details about your system, perl & module Versions, please ?

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - kilburn - 07-22-2009 10:28 PM

No, it isn't known AFAIK. It would be great if you can provide more info:

- OS/Distro/Version
- PHP version

Can you also try to change the key and iv in /var/www/ispcp/gui/include/ispcp-db-keys.php and check if there are any changes?

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - minjaverde - 07-22-2009 10:37 PM

anything you need Smile
perl -version says : 5.8.8
perl-modules/etch uptodate 5.8.8-7etch6
os debian etch
kernel 2.6.18-6-686
php -version says : PHP 5.2.0-8+etch15 (cli) (built: May 1 2009 10:25:25)


Code:
libnet-ssleay-perl      1.30-1  install ok installed
libxml-sax-perl 0.12-5  install ok installed
libio-multiplex-perl    1.08-3  install ok installed
libnet-netmask-perl     1.9012-2        install ok installed
libsys-syslog-perl      0.18-1  install ok installed
libparse-yapp-perl      1.05-10 install ok installed
libconfig-inifiles-perl 2.39-2  install ok installed
libxml-namespacesupport-perl    1.09-3  install ok installed
libplrpc-perl   0.2017-1.1      install ok installed
libtimedate-perl        1.1600-5        install ok installed
libdigest-sha1-perl     2.11-1  install ok installed
libossp-uuid-perl       1.5.1-1 install ok installed
libtk-tablematrix-perl  1.22-1  install ok installed
libxml-writer-perl      0.602-1 install ok installed
libapt-pkg-perl 0.1.20  install ok installed
libwww-perl     5.805-1 install ok installed
libwww-mechanize-perl   1.18-1  install ok installed
libhtml-parser-perl     3.55-1  install ok installed
libnet-xwhois-perl      0.90-3  install ok installed
libdbd-mysql-perl       3.0008-1        install ok installed
libcrypt-passwdmd5-perl 1.3-8   install ok installed
libnet-cidr-perl        0.11-1  install ok installed
perl    5.8.8-7etch6    install ok installed
libsoap-lite-perl       0.69-1  install ok installed
liblogfile-rotate-perl  1.04-3  install ok installed
libio-socket-inet6-perl 2.51-1  install ok installed
libhtml-tagset-perl     3.10-2  install ok installed
libtext-charwidth-perl  0.04-4  install ok installed
libio-socket-ssl-perl   1.01-1  install ok installed
perl-base       5.8.8-7etch6    install ok installed
libterm-readkey-perl    2.30-3  install ok installed
libconfhelper-perl      0.12.5  install ok installed
libdate-calc-perl       5.4-5   install ok installed
libxml-libxml-common-perl       0.13-5  install ok installed
libxml-parser-perl      2.34-4.2        install ok installed
libtext-wrapi18n-perl   0.06-5  install ok installed
libfcgi-perl    0.67-2  install ok installed
libnet-dns-perl 0.59-1etch1     install ok installed
libterm-readpassword-perl       0.05-1  install ok installed
libnet-libidn-perl      0.07-1  install ok installed
libcarp-clan-perl       5.8-1   install ok installed
libhtml-tree-perl       3.19.01-2       install ok installed
libcrypt-cbc-perl       2.22-1  install ok installed
libhttp-cache-transparent-perl  0.7-1   install ok installed
libmime-lite-perl       3.01-8  install ok installed
libmd5-perl     2.03-1  install ok installed
libxml-perl     0.08-1  install ok installed
libconvert-binhex-perl  1.119-2 install ok installed
libsnmp-session-perl    1.08-1  install ok installed
libnet-ssleay-perl      1.30-1  install ok installed
libxml-sax-perl 0.12-5  install ok installed
libio-multiplex-perl    1.08-3  install ok installed
libnet-netmask-perl     1.9012-2        install ok installed
libsys-syslog-perl      0.18-1  install ok installed
libparse-yapp-perl      1.05-10 install ok installed
libconfig-inifiles-perl 2.39-2  install ok installed
libxml-namespacesupport-perl    1.09-3  install ok installed
libplrpc-perl   0.2017-1.1      install ok installed
libtimedate-perl        1.1600-5        install ok installed
libdigest-sha1-perl     2.11-1  install ok installed
libossp-uuid-perl       1.5.1-1 install ok installed
libtk-tablematrix-perl  1.22-1  install ok installed
libxml-writer-perl      0.602-1 install ok installed
libapt-pkg-perl 0.1.20  install ok installed
libwww-perl     5.805-1 install ok installed
libwww-mechanize-perl   1.18-1  install ok installed
libhtml-parser-perl     3.55-1  install ok installed
libnet-xwhois-perl      0.90-3  install ok installed
libdbd-mysql-perl       3.0008-1        install ok installed
libcrypt-passwdmd5-perl 1.3-8   install ok installed
libnet-cidr-perl        0.11-1  install ok installed
perl    5.8.8-7etch6    install ok installed
libsoap-lite-perl       0.69-1  install ok installed
liblogfile-rotate-perl  1.04-3  install ok installed
libio-socket-inet6-perl 2.51-1  install ok installed
libhtml-tagset-perl     3.10-2  install ok installed
libtext-charwidth-perl  0.04-4  install ok installed
libio-socket-ssl-perl   1.01-1  install ok installed
perl-base       5.8.8-7etch6    install ok installed
libterm-readkey-perl    2.30-3  install ok installed
libconfhelper-perl      0.12.5  install ok installed
libdate-calc-perl       5.4-5   install ok installed
libxml-libxml-common-perl       0.13-5  install ok installed
libxml-parser-perl      2.34-4.2        install ok installed
libtext-wrapi18n-perl   0.06-5  install ok installed
libfcgi-perl    0.67-2  install ok installed
libnet-dns-perl 0.59-1etch1     install ok installed
libterm-readpassword-perl       0.05-1  install ok installed
libnet-libidn-perl      0.07-1  install ok installed
libcarp-clan-perl       5.8-1   install ok installed
libhtml-tree-perl       3.19.01-2       install ok installed
libcrypt-cbc-perl       2.22-1  install ok installed
libhttp-cache-transparent-perl  0.7-1   install ok installed
libmime-lite-perl       3.01-8  install ok installed
libmd5-perl     2.03-1  install ok installed
libxml-perl     0.08-1  install ok installed
libconvert-binhex-perl  1.119-2 install ok installed
libsnmp-session-perl    1.08-1  install ok installed
(07-22-2009 10:28 PM)kilburn Wrote:  Can you also try to change the key and iv in /var/www/ispcp/gui/include/ispcp-db-keys.php and check if there are any changes?

hm the file looks like this ? should this values be removed by a script ?
Code:
<?php

$ispcp_db_pass_key = '{KEY}';

$ispcp_db_pass_iv = '{IV}';

?>

okay inserting varios signs in the fields, it seems to work for the admin gui .. but login to webmail not, are this passwords also crypthed with this values ?
i am trying to find a backup of this file .. mybe this helps

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - srissman - 08-18-2009 10:46 AM

I ran into the same problem "Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost'" and finally discovered the solution:

My password contained a special character.. specifically a '$'. Once I updated the password in mysql, then updated it in ispcp with '/var/www/ispcp/engine/ispcp-db-passwd' I was able to complete the install.

I hope this helps others... now to test to see if the updated succeeded for true!

Congratulations!
ispCP '1.0.0 OMEGA' Update completed successfully!

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - Hunter2x - 09-09-2009 03:32 PM

I find myself in : Instalation > configuration of MAgento

1. Database Connection
Host: localhost/magento/
Database name : Magento
User name : root
Pasword : xxxx

2. Web acces options
Base url: http://localhost/magento/

I did everything Magento suggested I in their guide I should do.,but I got this message.

o SQLSTATE[28000] [1045] Access denied for user ‘lieven23’@’localhost’ (using password: YES)
o Database connection error

What I don’t understand is that the password (using password: YES) is not the pasword I used to make my database.
I created a database and a table in it.


________________
Freelance writing jobs

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - gOOvER - 09-09-2009 04:07 PM

Maybe you have a typo or you press capslock?

RE: Connection failed: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' - joximu - 09-09-2009 04:49 PM

(09-09-2009 03:32 PM)Hunter2x Wrote:  I find myself in : Instalation > configuration of MAgento

1. Database Connection
Host: localhost/magento/

what the heck is this?
a hostname does not contain a /

(09-09-2009 03:32 PM)Hunter2x Wrote:  Database name : Magento
User name : root
Pasword : xxxx

2. Web acces options
Base url: http://localhost/magento/

I did everything Magento suggested I in their guide I should do.,but I got this message.

o SQLSTATE[28000] [1045] Access denied for user ‘lieven23’@’localhost’ (using password: YES)
o Database connection error

What I don’t understand is that the password (using password: YES) is not the pasword I used to make my database.

I created a database and a table in it.

of course, the password is not "YES"... it's only an information that a password was given (in contrast to a password less db connect).

/J