PHP Warning: mysqli_connect(): (28000/1045)

[tbokich]

Hello
I am currently running a fresh install of 154 with the responsive_avonlee_contempo template. I have Image Handler installed and google site map. I am generating debug logs that read:

[22-Feb-2015 14:56:46 America/Denver] PHP Warning:  mysqli_connect(): (28000/1045): Access denied for user 'cwrealey'@'localhost' (using password: NO) in /home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php on line 62

I checked the query factory php page line 62 and it reads:
$this->link = mysqli_connect($zf_host, $zf_user, $zf_password);
$connectionRetry--;
The script surrounding this entry is:

 function connect($zf_host, $zf_user, $zf_password, $zf_database, $zf_pconnect = 'false', $zp_real = false) {
    $this->database = $zf_database;
    $this->user = $zf_user;
    $this->host = $zf_host;
    $this->password = $zf_password;
    $this->pConnect = $zf_pconnect;
    $this->dieOnErrors = $dieOnErrors;
    if (defined('DB_CHARSET')) $dbCharset = DB_CHARSET;
    if (isset($options['dbCharset'])) $dbCharset = $options['dbCharset'];
    if (!function_exists('mysqli_connect')) die ('Call to undefined function: mysqli_connect().  Please install the MySQL Connector for PHP');
    $connectionRetry = 10;
    while (!isset($this->link) || ($this->link == FALSE && $connectionRetry !=0) )
    {
      $this->link = mysqli_connect($zf_host, $zf_user, $zf_password);
      $connectionRetry--;
    }
    if ($this->link) {
      if (mysqli_select_db($this->link, $zf_database)) {
        if (isset($dbCharset) ) {
          mysqli_query($this->link, "SET NAMES '" . $dbCharset . "'");
          if (function_exists('mysqli_set_charset')) {
            mysqli_set_charset($this->link, $dbCharset);
          } else {
            mysqli_query($this->link, "SET CHARACTER SET '" . $dbCharset . "'");
          }
        }
        $this->db_connected = true;
        if (!defined('DISABLE_MYSQL_TZ_SET')) {
          mysqli_query($this->link, "SET time_zone = '" . substr_replace(date("O"),":",-2,0) . "'");
        }
        return true;
      } else {
        $this->set_error(mysqli_errno($this->link), mysqli_error($this->link), $dieOnErrors);
        return false;
      }
    } else {
      $this->set_error(mysqli_connect_errno(), mysqli_connect_error(), $dieOnErrors);
      return false;

I saw a similar thread from 2012 but not solved and this was a while ago. Any suggestions on how to fix it would be appreciated. I download the new version of Zen Cart from the Zen website. My site is www.makupartist.com and to get to zen cart you will need to www.makupartist.com/154
Thanks
T

[lhungil]

That message typically indicates an issue communicatung (authenticating) with the database. Common causes are invalid cedentials, server denial by security rules, or 3rd party code still using direct "mysql_*" function calls.

Would suggest searching for the phrase "mysql_" in all files (and update or remove the 3rd party code if found). Mixed mysql_ and mysqli_ calls are the most common cause (Zen Cart > 1.5.1 uses mysqli_ internally).

If intermitten may also be worth asking the hosting provider (can check server logs / enable logging) to further assist tracking down the cause.

[mc12345678]

Which version of each of the plugins is being run? Were the latest version of those plugins (compatible with ZC 1.5.4) downloaded?

[DrByte]

Access denied for user 'cwrealey'@'localhost' (using password: NO)

Is "cwrealey" really the username for your MySQL database INSIDE the MySQL settings?
Why is there no password for that user? (It only says "using password: NO" if you've given it no password in your configure.php files)

[tbokich]

Is "cwrealey" really the username for your MySQL database INSIDE the MySQL settings?
Why is there no password for that user? (It only says "using password: NO" if you've given it no password in your configure.php files)

Hi. No the data base user name is not cwrealey. I did a search of all the php files on the site and cannot find a reference to cwrealey so do not know where it is coming from. I also searched the data base and could not find this entry either

[mc12345678]

Might I suggest installing lat9's MyDebug Backtrace: http://www.zen-cart.com/downloads.php?do=file&id=1879

It should provide a better indication of the origin of the error rather than just starting at the query_factory.

[RodG]

Hello
I am currently running a fresh install of 154 with the responsive_avonlee_contempo template. I have Image Handler installed and google site map. I am generating debug logs that read:

How often is this error occurring? Same time every day? Only when you generate a new sitemap, or is it seemingly random?

[22-Feb-2015 14:56:46 America/Denver] PHP Warning:  mysqli_connect(): (28000/1045): Access denied for user 'cwrealey'@'localhost' (using password: NO) in /home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php on line 62

I checked the query factory php page line 62 and it reads:

This isn't the file where you'll find the error. The error will be caused by whatever module/code is calling this function.

Although it was mentioned that the problem could be caused by the use of a 'mysql_*' function call, this *isn't* the cause of your problem. The log file provided clearly shows that it is using the correct (for V1.5.4) mysqli_* function call.

I have Image Handler installed and google site map.

The image handler appears to be functioning correctly, so I doubt that that will be the cause.

The Google Sitemap *is* a *very strong* suspect though, because this module runs somewhat independently of any other store code, and will be one of the few places where the Database credentials used could be different than any other store function.

No the data base user name is not cwrealey

This name is being picked up for *somewhere*, and my guess is that it could be the account name used to access your server?

It is my suspicion that the Google Sitemap (or some other module) isn't loading the 'application_top' or is missing a 'global $db' variable setting, and because of this there are no $db login credentials to be had, and the server is trying to use a default 'account_username@password' (which is obviously failing).

If your account name *isn't* "cwrealey" then I feel that you have a really serious issue (such as the site being compromised with a poorly written hacker script), but I'd rather not consider this possibly at this stage, at least not until you can determine which add-on module is calling the mysqli_connect function and/or the source of the 'cwrealey' name.

Cheers
RodG

[RodG]

ps. I take back my previous 'diagnosis' of the problem.

I've not been able to find a cause , BUT, after typing "cwrealey@localhost" into Google I'm seeing over 5000 matches from many different sites that don't appear to be ZenCart related.

If this isn't due to some sort of hack attempt (SQL injection?) it could be a default server setting (I found one reference to this, but seem to have lost it again).

In other words, I don't think that this a a 'zencart' issue at all.

I'll let you know if I can find out anything more.

Cheers
RodG

[tbokich]

Might I suggest installing lat9's MyDebug Backtrace: http://www.zen-cart.com/downloads.php?do=file&id=1879

It should provide a better indication of the origin of the error rather than just starting at the query_factory.

Hi, Thanks I installed it and got this:
[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'cwrealey'@'localhost' (using password: NO) in /home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php on line 62
[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[15-Mar-2015 11:42:16 America/Denver] #1 mysqli_connect() called at [/home2/latexinn/public_html/154/includes/classes/db/mysql/query_factory.php:62]
#2 queryFactory->connect() called at [/home2/latexinn/public_html/154/includes/classes/class.phpbb.php:32]
#3 phpBB->phpBB() called at [/home2/latexinn/public_html/154/includes/autoload_func.php:79]
#4 require(/home2/latexinn/public_html/154/includes/autoload_func.php) called at [/home2/latexinn/public_html/154/includes/application_top.php:158]
#5 require(/home2/latexinn/public_html/154/includes/application_top.php) called at [/home2/latexinn/public_html/154/index.php:26]

[lat9]

Look in your /includes/configure.php file. There's a constant there named DIR_WS_PHPBB.

Look in the folder that that constant specifies; there's a file named config.php (the phpBB configuration file). The credentials for the phpBB database are parsed out of that file, which apparently has invalid database information.