| View previous topic :: View next topic |
| Author |
Message |
Lassanter
Joined: 14 Feb 2005
Posts: 3
Location: U.S.A.
|
 Posted: Mon Feb 14, 2005 8:03 Post subject: New to NWNX |
 |
|
Howdy, folks... I'm having trouble with my MySQL connection...
I am using the latest version of NWNX and I have the ODBC2 downloaded and installed, the scripts copied to the right places, and the ini file configured appropriately for the MySQL server I plan on using. I enter the demo module, and I click on the signs, and it SAYS that everything occurred correctly, up until I get to the 'retrieve object' sign. That says that it retrieves 0 objects. I checked the database, itself, and NOTHING that it said it did had happened. There were no new tables written, no data entered into the tables... Nothing. This tells me that I am failing to connect to my MySQL server.
I am clearly missing something. Is there a log file I can look at that logs the connection/queries?
Any assistance I could get with this would be fantastic.
Geoffrey Allen
nwnx.ini...
| Code: |
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.
[NWNX]
ServerPort = 5121
ModuleName = "aps_demo"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 5
[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything
; Use these two settings for the SQLite internal database
; source = mysql
; file =
; Use these two settings for ODBC connections
; source = odbc
; dsn = nwn
; Use these five settings for MySQL connections
source = mysql
server = 192.168.1.110
user = nwnuser
pwd = <password>
db = nwn
; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true
[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack
|
|
|
| Back to top |
|
 |
Lassanter
Joined: 14 Feb 2005
Posts: 3
Location: U.S.A.
|
| Posted: Mon Feb 14, 2005 8:46 Post subject: |
|
|
OKay... After a little more fiddling, I discovered that I am, in fact, connecting to the MySQL server. However, the query to build the table is not functioning. I get the following error...
! SQL Error: You have an error in your SQL syntax near 'CURRENT_TIMESTAMP,PRIMARY KEY (player,tag,name)) ENGINE=MyISAM DEFAULT CHARSET=' at line 1
I'm guessing that my MySQL server isn't liking that, for some reason. I am, admittedly, running an older version... I will try to upgrade to a newer version and see where that gets me.
Geoff |
|
| Back to top |
|
|
Papillon
x-man
Joined: 28 Dec 2004
Posts: 1060
Location: Germany
|
| Posted: Mon Feb 14, 2005 9:14 Post subject: |
|
|
The table create statements work with MySQL 4. Alternatively, you could try to simplify the statement so it works with MySQL 3 and post the correct statement here.
_________________
Papillon |
|
| Back to top |
|
|
Lassanter
Joined: 14 Feb 2005
Posts: 3
Location: U.S.A.
|
| Posted: Mon Feb 14, 2005 9:40 Post subject: |
|
|
Well, I've wanted to upgrade my MySQL server to v4.1 for a while, now... I just never had a reason to go through the hassle of figuring out all the interdependencies. But I took care of it, and now I have version 4.1 running peachy keen, and everything works great.
Geoff |
|
| 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
