Access Denied to User Error

[Vngi]

Hello, it's been a long time since I touched retros.

now, I'm using HabbieCMS Release & when I load the client, I see " Error: Access denied for user 'root'@'localhost' (using password: YES) " all I can find is people saying in correct password, but I can assure you, I am using the correct password etc!

 

[JayC]

Incorrect username or password to connect to your database.

If you are already at the client page, chances are its trying to connect to the database in php code on your client.php file. Check there.

Close Thread, Only solution.

 

[Vngi]

Incorrect username or password to connect to your database.

If you are already at the client page, chances are its trying to connect to the database in php code on your client.php file. Check there.

Close Thread, Only solution.

Thanks for the response, I've checked both of these, I do not see them to see anything relating it in the client.php file, and again I've checked username, password & all of that stuff, it matches.. if I change it, I receive an error and it clearly states that I've entered the wrong information.

If I enter invalid password:

You must be registered for see links

Valid Password but on Client Page:

You must be registered for see links

so unless I'm blind or clearly missing it in the client.php, then I've no idea.

- I also checked in mysql & navicat, both the username is also correct, it's root@localhost

 

[n4te]

It'd help if you'd provide your config files, just so that we can look at it ourselves. You may have missed something and not have realized it. It happens.

 

[Vngi]

It'd help if you'd provide your config files, just so that we can look at it ourselves. You may have missed something and not have realized it. It happens.

Spoiler: Config

<?php
if(!defined('BRAIN_CMS'))
{
die('Sorry but you cannot access this file!');
}

/* Database Setting */
$db['host'] = '127.0.0.1'; //Mysql's Host
$db['port'] = '3306'; //Mysql's port
$db['user'] = "root"; //Mysql's user
$db['pass'] = '******'; //Mysql's password
$db['db'] = "hotel"; //Mysql's database

/* Emu Settings */
$config['hotelEmu'] = 'plusemu'; // plusemu // arcturus

/* Client Setting */
$hotel['emuHost'] = "*****"; //IP of VPS//IP of Proxy
$hotel['emuPort'] = "3306"; //Port of VPS//Port of Proxy
$hotel['staffCheckClient'] = false; //Enable the staff pin in the client (true) or disable it (false)
$hotel['staffCheckClientMinimumRank'] = 3; //Minium staff rank to get the staff pin in the client
$hotel['homeRoom'] = ''; //Set the start room when you get in the hotel
$hotel['external_Variables'] = "http://**/swf/gamedata/external_variables.txt";
$hotel['external_Variables_Override'] = "http:/**/swf/gamedata/override/external_override_variables.txt";
$hotel['external_Texts'] = "http://**/swf/gamedata/external_flash_texts.txt";
$hotel['external_Texts_Override'] = "http://**/swf/gamedata/override/external_flash_override_texts.txt";
$hotel['productdata'] = "http://**/swf/gamedata/productdata.txt";
$hotel['furnidata'] = "http://**/swf/gamedata/furnidata.xml";
$hotel['figuremap'] = "http:/**/swf/gamedata/figuremap.xml";
$hotel['figuredata'] = "http://**/swf/gamedata/figuredata.xml";
$hotel['swfFolder'] = "http://**/swf/gordon/PRODUCTION-201602082203-712976078";
$hotel['swfFolderSwf'] = "http://**/swf/gordon/PRODUCTION-201602082203-712976078/Habbo.swf"; /*HabbieClient.swf*/

/* Website Setting */
$config['hotelUrl'] = "http://**";//Address of your hotel. Does not end with a "/"
$config['skin'] = "material"; //Skin/template of your website
$config['lang'] = "en"; //Language of your website /en/nl/es
$config['hotelName'] = "Lala"; //Name of your hotel
$config['favicon'] = "http://**templates/material/style/images/favicon/favicon.png";
$config['staffCheckHk'] = false; //Enable the staff pin in the housekeeping (true) or disable it (false)
$config['staffCheckHkMinimumRank'] = 6; //Minium staff rank to get the staff pin in the housekeeping
$config['maintenance'] = false; //Enable the maintenance of your website (true) or disable it (false)
$config['maintenancekMinimumRankLogin'] = 6; //Minium staff rank to login when the website is in maintenance
$config['groupBadgeURL'] = "http://**/swf/habbo-imaging/badge.php?badge=";
$config['badgeURL'] = "http://**/swf/c_images/album1584/";
$config['userLikeEnable'] = true; // Enable user likes
$config['newsCommandEnable'] = true; //Enable news commands
$config['newsCommandFilter'] = true; //Enable wordfilter on news commands (the filter use the db tabels wordfilter and wordfilter_characters)

Sorry, here's the CMS Config File.


Client.php

Spoiler: Client

</body>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title><?= $config['hotelName'] ?> - Game</title>
<script src="/templates/brain/client/js/jquery-latest.js" type="text/javascript"></script>
<script src="/templates/brain/client/js/jquery-ui.js" type="text/javascript"></script>
<script src="/templates/brain/client/js/flashclient.js"></script>
<script src="/templates/brain/client/js/flash_detect_min.js"></script>
<script src="/templates/brain/client/js/client.js" type="text/javascript"></script>
<link rel="shortcut icon" href="/favicon.ico" />
</head>
<body>
<center>
<div id="client-ui">
<div id="client" style='position:absolute; left:0; right:0; top:0; bottom:0; overflow:hidden; height:100%; width:100%;'></div>
</div>
<script>
var Client = new SWFObject("<?= $hotel['swfFolderSwf'] ?>", "client", "100%", "100%", "10.0.0");
Client.addVariable("client.allow.cross.domain", "0");
Client.addVariable("client.notify.cross.domain", "1");
Client.addVariable("connection.info.host", "<?= $hotel['emuHost'] ?>");
Client.addVariable("connection.info.port", "<?= $hotel['emuPort'] ?>");
Client.addVariable("site.url", "<?= $config['hotelUrl'] ?>");
Client.addVariable("url.prefix", "<?= $config['hotelUrl'] ?>");
Client.addVariable("client.reload.url", "<?= $config['hotelUrl'] ?>/me");
Client.addVariable("client.fatal.error.url", "<?= $config['hotelUrl'] ?>/me");
Client.addVariable("client.connection.failed.url", "<?= $config['hotelUrl'] ?>/me");
Client.addVariable("external.override.texts.txt", "<?= $hotel['external_Texts_Override'] ?>");
Client.addVariable("external.override.variables.txt", "<?= $hotel['external_Variables_Override'] ?>");
Client.addVariable("external.variables.txt", "<?= $hotel['external_Variables'] ?>");
Client.addVariable("external.texts.txt", "<?= $hotel['external_Texts'] ?>");
Client.addVariable("external.figurepartlist.txt", "<?= $hotel['figuredata'] ?>");
Client.addVariable("flash.dynamic.avatar.download.configuration", "<?= $hotel['figuremap'] ?>");
Client.addVariable("productdata.load.url", "<?= $hotel['productdata'] ?>");
Client.addVariable("furnidata.load.url", "<?= $hotel['furnidata'] ?>");
Client.addVariable("use.sso.ticket", "1");
Client.addVariable("sso.ticket", "<?= User::userData('auth_ticket') ?>");
Client.addVariable("processlog.enabled", "0");
Client.addVariable("client.starting", "<?= $config['hotelName'] ?> Hotel is aan het laden...");
Client.addVariable("flash.client.url", "<?= $hotel['swfFolder'] ?>/");
Client.addVariable("flash.client.origin", "popup");
Client.addVariable("nux.lobbies.enabled", "true");
Client.addVariable("country_code", "NL");
Client.addParam('base', '<?= $hotel['swfFolder'] ?>/');
Client.addParam('allowScriptAccess', 'always');
Client.addParam('menu', false);
Client.addParam('wmode', "opaque");
Client.write('client');

FlashExternalInterface.signoutUrl = "<?= $config['hotelUrl'] ?>/logout";
</script>
</center>
<script type="text/javascript">
$(document).ready(function(e) {
$.ajaxSetup({
cache:true
});
setInterval(function() {
$('#onlineCount').load('/templates/material/counter.php');
}, 2000);
$( "#onlineCount").click(function() {
$('#onlineCount').load('/templates/material/counter.php');
});

});
</script>
<style type="text/css">
#onlineCount {
background-color:#757575;cursorointer;-moz-transition:all 1s ease-in;-webkit-transition:all 1s ease-in;-o-transition:all 1s ease-in;transition:all 1s ease-in;
position:absolute;background-color:#585858;z-index:1;color:white;top:0px;padding:3px;
}
</style>

<div id="client"></div>
<div id="onlineCount" style="border-radius: 4px;
top: 0px;
padding-top: 10px; padding-bottom: 10px; padding-left: 20px; padding-right: 20px; font-size: 12px;
right: 200px;
border: 2px #54524D solid;
border-top-left-radius: 0px;
border-top-right-radius: 0px;
font-family: ubuntu, arial;
border-top: 0px;
background color: b;
box-shadow: 1px 2px black;
background-color: #24231E;
">Laden ...</div>
</body>
</html>
</center>
</div>
<script>
//no flash?!
if(!FlashDetect.installed){
window.location.href = "<?= $config['hotelUrl'] ?>/noflash";
}
</script>
</head>

If I am missing anything and you wanna see, let me know and I'll edit the post

 

[Joe]

Simple. Don’t use BrainCMS

 

[Vngi]

Simple. Don’t use BrainCMS

I was thinking about it, but I don't see any decent or up to date CMS that would be a good place to start :/


Edit: I swapped out the Client Page, for a fresh one, that's resolved the issue now I just need to get it to load past 76% now.
< which is something I've tried everything for, no errors in debug etc. >