logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
MySQL 5.0

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Xildjian



Joined: 08 Jan 2005
Posts: 100

PostPosted: Tue Nov 08, 2005 20:35    Post subject: MySQL 5.0 Reply with quote

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
View user's profile Send private message
Frang



Joined: 22 May 2005
Posts: 32

PostPosted: Sun Nov 13, 2005 3:41    Post subject: Reply with quote

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
View user's profile Send private message
chris



Joined: 27 Jul 2005
Posts: 4

PostPosted: Fri Dec 02, 2005 15:42    Post subject: Reply with quote

I'll test it also in the next days , i give a reportif i get it wrking
Back to top
View user's profile Send private message
cma_dev



Joined: 22 May 2005
Posts: 6

PostPosted: Mon Dec 12, 2005 20:12    Post subject: Reply with quote

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
View user's profile Send private message
dougnoel



Joined: 21 Mar 2005
Posts: 27
Location: VA

PostPosted: Tue Sep 26, 2006 4:47    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
kungfoowiz



Joined: 12 Oct 2006
Posts: 61

PostPosted: Fri Oct 13, 2006 13:22    Post subject: Reply with quote

Doug, did you call SQLInit() when your module loads?

---
kung
Back to top
View user's profile Send private message
Katy



Joined: 16 Jan 2007
Posts: 17

PostPosted: Tue Jan 16, 2007 21:43    Post subject: Reply with quote

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
View user's profile Send private message
Katy



Joined: 16 Jan 2007
Posts: 17

PostPosted: Tue Jan 16, 2007 22:54    Post subject: Reply with quote

Embarassed It *does* help to configure to allow TCP/IP connections...
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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