Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'XX.X

[mowax]

hey chaps,

i'm trying to install a version of pschostats it's a good clan reader for our stats that connects to our server see example here (http://f098.free.speed-stats.de/index.php)

Thank one isn't worning correctly so i'd like to do my own, thing is i'm stuck on the below.

Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'XX.XXX.XX.XX' (using password: YES)

this is the config i'm using

<?php
// Basic database and user configuration.
// All other configuration is stored in the database.
$dbtype = 'mysql';
$dbhost = 'mysql';
$dbport = '';
$dbname = 'mowax_stats';
$dbuser = 'mowax_mowax';
$dbpass = 'password';
$dbtblprefix = '_ps';
$userhandler = 'normal';?>

Now i've went into control panel and created a data base called

mowax_stats

i have a user called

mowax_mowax

and i've let it have full access....i've also chmod the files that i need to.

the people over at the stats page asked me this

know somewhere in that control panel of yours it'll allow you to assign the host the user can connect as. I just don't know where it would be listed. Or it's possible your host doesn't allow remote connections. Talk to you host to find out.

So...any ideas?

Thank you

 

[Christopher]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

$dbhost = 'mysql';
that should be
$dbhost = 'localhost';

 

[mowax]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

Thank you i have now changed that but the following error is what i'm getting now.

Fatal Session Error at line 259: ERR 1146: Table 'mowax_stats._pssessions' doesn't exist

I thought i was on top of this as i've created a database as per below.

Modify Databases
Check DB:
mowax_nuke1
mowax_stats

Repair DB:
mowax_nuke1
mowax_stats

Current Databases
Search

Database Size Users Actions

mowax_nuke1 1.98 MB mowax_nuke1
mowax_stats 0.01 MB mowax_mowax



Jump to MySQL Databases
MySQL Users
Add New User
Username: *Seven characters max
Password:
Password Strength: Very Weak (0/100)
Password (Again):


Add User To Database
User: mowax_mowax mowax_nuke1
Database: mowax_nuke1, mowax_stats


Current Users
mowax_mowax
mowax_nuke1

But i'm not sure if i have to create a table with the php settings, according to the set up then you don't need to it should be automaticly created for you.

Thanks for your help.

 

[Fedlerner]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

Have you imported a .sql file to your database? Or made an installation?
The error tells you that the table "mowax_stats._pssessions" doesn't exist on the database. So there's something wrong with it.

 

[mowax]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

hi there, thanks, i have tried importing a data base for the stas and then running it but according to the makers they say that it should make the tables it's self.

just wondering, do i need this enabled?

 

[Fedlerner]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

When you're on PhpMyAdmin, on the left menu click on "_stats". It will open this tables and the option to "Import" will appear at the top of the page, with many other options.

Let me know if you still can't get to that page.

 

[mowax]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

Thank you very much, it would seem that they know there's a fault with that version (could of deleted the download they could...lol) and they have advised me to wait until the next version is out, which shouldn't be long i hope.

So thanks again for a wonderful host.......cheers

 

[Fedlerner]

Re: Fatal Session Error at line 259: ERR 1045: Access denied for user 'mowax_mowax'@'

No problem.
Feel free to re-open this thread if you need further assistance.