View previous topic :: View next topic |
Author |
Message |
Xildjian
Joined: 08 Jan 2005 Posts: 100
|
Posted: Tue Nov 08, 2005 20:35 Post subject: MySQL 5.0 |
|
|
I just noticed this has recently been released, and was curious if anyone has tried/played with it in a nwnx2 context? _________________ Member Shadow of Iniquity development team |
|
Back to top |
|
|
Frang
Joined: 22 May 2005 Posts: 32
|
Posted: Sun Nov 13, 2005 3:41 Post subject: |
|
|
I have tried a few times its been out for a little while now but I can never get it to work always get an error in the log0 files that its trying to connect with password"NO" and I have tried everything your better off using 4.1 |
|
Back to top |
|
|
chris
Joined: 27 Jul 2005 Posts: 4
|
Posted: Fri Dec 02, 2005 15:42 Post subject: |
|
|
I'll test it also in the next days , i give a reportif i get it wrking |
|
Back to top |
|
|
cma_dev
Joined: 22 May 2005 Posts: 6
|
Posted: Mon Dec 12, 2005 20:12 Post subject: |
|
|
I've tested MySQL 5.0 and it works very well with NWNX2. The BIGGEST advantage over 4.1 is the fact that views are supported. That will make like infinitely easier when trying to retrieve stored data.
Also, check out their front-ends for Administration and Query writing. |
|
Back to top |
|
|
dougnoel
Joined: 21 Mar 2005 Posts: 27 Location: VA
|
Posted: Tue Sep 26, 2006 4:47 Post subject: |
|
|
I am having trouble with MySQL 5.0.20 not working with NWNX. Everything in the OBDC logs indicates that the values have loaded up correctly, but they are not accessible in-game. Has anyone had similar problems with accessing data using 5.0.x? |
|
Back to top |
|
|
kungfoowiz
Joined: 12 Oct 2006 Posts: 61
|
Posted: Fri Oct 13, 2006 13:22 Post subject: |
|
|
Doug, did you call SQLInit() when your module loads?
---
kung |
|
Back to top |
|
|
Katy
Joined: 16 Jan 2007 Posts: 17
|
Posted: Tue Jan 16, 2007 21:43 Post subject: |
|
|
I'm having trouble getting MySQL configured properly. I can run the command line client and check tables with no problem, but it appears not to be listening on port 3306. Neither NWNX nor something like the MySQL Query Browser can talk to the MySQL service.
For example:
Code: |
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -h127.0.0.1 --port=3306 -uroot -p version
mysqladmin Ver 8.41 Distrib 5.0.27, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27-community-nt
Protocol version 10
Connection Named pipe: mysql
UNIX socket mysql
Uptime: 7 days 22 hours 28 min 49 sec
|
however:
Code: |
C:\Program Files\MySQL\MySQL Server 5.0\bin>telnet 127.0.0.1 3306
Connecting To 127.0.0.1...Could not open connection to the host, on port 3306: Connect failed
C:\Program Files\MySQL\MySQL Server 5.0\bin>telnet 127.0.0.1 3306
Connecting To 127.0.0.1...Could not open connection to the host, on port 3306: Connect failed
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqladmin -uroot -p variables | grep port
| innodb_support_xa | ON
| large_files_support | ON
| port | 0
|
That '0' for port looks suspicious to me. I'm running Windows XP Professional on my development machine; haven't attempted to get things going on the server machine (XP Professional 64 bit) yet.
Any idea where I might be going wrong, or what I should try next?
(Should probably say this is eventually for work with NWN2 and NWNX4). |
|
Back to top |
|
|
Katy
Joined: 16 Jan 2007 Posts: 17
|
Posted: Tue Jan 16, 2007 22:54 Post subject: |
|
|
It *does* help to configure to allow TCP/IP connections... |
|
Back to top |
|
|
|