| View previous topic :: View next topic |
| Author |
Message |
raistlinmajere
Joined: 15 Feb 2006
Posts: 3
|
 Posted: Wed Feb 15, 2006 9:09 Post subject: Haveing problem with MySQL 5.0 wondering if i could get help |
 |
|
I installed MySQL 5.0 its up and running but for some reason on command prompt and in nwn it keeps acting like i dont have privelage for my user/ pass i've even tryed granting privelage to another name and got the same results heres what nwnx_odbc reports
| Code: |
o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using MySQL connection.
o Hooking SCO....hooked at 5c65d0
o Hooking RCO....hooked at 5c64b0
! Error while connecting to database: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: DROP TABLE pwdata
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: CREATE TABLE pwdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val text,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: SELECT player FROM pwdata WHERE player='vendaarie' AND tag='Benny Wennard' AND name='demoName'
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Empty set
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('vendaarie','Benny Wennard','demoName','testValue',0)
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: SELECT val FROM pwdata WHERE player='vendaarie' AND tag='Benny Wennard' AND name='demoName'
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Empty set
o Got request: DROP TABLE pwobjdata
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: CREATE TABLE pwobjdata (player varchar(64) NOT NULL default '~',tag varchar(64) NOT NULL default '~',name varchar(64) NOT NULL default '~',val blob,expire int(11) default NULL,last timestamp NOT NULL default CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_0'
! SQL Error: Access denied for user 'nwn'@'localhost' (using password: YES)
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_0',~s,0)
! SQL Error: MySQL server has gone away
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_1'
! SQL Error: MySQL server has gone away
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_1',~s,0)
! SQL Error: MySQL server has gone away
o Got request: SELECT player FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_2'
! SQL Error: MySQL server has gone away
o Empty set
o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('~','Chest1','Item_2',~s,0)
! SQL Error: MySQL server has gone away
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='~' AND tag='Chest1' AND name='Item_0'
! SQL Error: MySQL server has gone away
o Disconnecting from database.
|
Any help with this problem i'm haveing would be greatly appreciated. |
|
| Back to top |
|
 |
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Feb 15, 2006 9:18 Post subject: |
|
|
The error is definately that it doesn't like the username/password combo.
I know others have posted that they have version 5.0 working but I have had nothing but problems with it (and not just with NWNX).
My prefered version is 4.0.18, everything works with it every time and without any oddities  |
|
| Back to top |
|
|
celtic3
Joined: 16 Jul 2005
Posts: 19
|
| Posted: Thu Feb 16, 2006 3:19 Post subject: reply |
|
|
| Are the user and pwd in NWNX.ini set to those you used? |
|
| Back to top |
|
|
odenien
Joined: 26 Sep 2005
Posts: 37
|
| Posted: Fri Feb 17, 2006 15:52 Post subject: |
|
|
| This could also be a permission thing. If you are on linux, then the nwn user needs to have permission to connect and use the resources of the database you are using. I suspect the windows version of MySQL is similar. I think as the versions of MySQL get newer, the permissions get more strict. |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Fri Feb 17, 2006 21:38 Post subject: |
|
|
In version 4.1, they changed the password encryption method. There is a setting in MySQL Administrator that enables the "old style" passwords again. I am thinking this might be the problem here (just guessing, but please do report back if it makes a difference).
_________________
Papillon |
|
| Back to top |
|
|
raistlinmajere
Joined: 15 Feb 2006
Posts: 3
|
| Posted: Sat Feb 18, 2006 3:46 Post subject: |
|
|
| I found the problem after many hours of stareing like a idiot ,I stoped and thought well what if a older install of it had left dorment files that when a new install had been detected wern't so dorment anymore needless to say I had previously installed MySQL and it left files in windows that i had to delete, it was causeing problems with the new install. Hope that little bit of info helps someone in the future because i've heard alot of people have been haveing the same problem with MySQL 5.0. |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
