|
Post by baaleos on Sept 2, 2007 17:45:30 GMT
; Use these five settings for MySQL connections source = mysql server = 74.220.204.131 user = azmodann_##### pwd = ###### db = azmodann_nwn just hashed out the username and password.. Everything else is how it should be i think. Ive experience using mysql for setting up forums and such, so thought this would have been all required. but then again, ive never tried connecting two servers together.
|
|
|
Post by FunkySwerve on Sept 2, 2007 19:15:45 GMT
That looks no different than ours, in principle (though ours does have certain differences due to being linux instead of windows). All six of ours connect to a db on the lan, with server=216.144.214.110. This leads me to suspect that you are doing something else wrong, either with respect to connectivity, or with mysql. I'll ask our resident MySQL guru what he thinks. Funky
|
|
|
Post by FunkySwerve on Sept 2, 2007 19:21:03 GMT
Please post your nwnx_odbc.txt log from logs.0 in your nwn folder. It sounds like you have a permission problem, and that should tell the tale. It should look something like this:
NWNX ODBC2 plugin V.0.9.2.4 (c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes o Log level: Everything will be logged. o Using MySQL connection. o Hooking SCO....hooked at 5d3560 o Hooking RCO....hooked at 5d3440 o Connect successful. o Disconnecting from database.
Funky
|
|
|
Post by baaleos on Sept 2, 2007 21:50:34 GMT
I dont seem to have a log file called that.
I do have the nwnx_odbc.dll in the nwn directory. And the server is initiated via nwnx . . does some sort of erf have to be imported into my module for it to use the dll file?
I thought the simtools test module might have had it installed for me..
- To clarify, I think the issue might be with the odbc thingi, no log file, tells me its not getting used.
|
|
|
Post by FunkySwerve on Sept 2, 2007 22:57:14 GMT
No, you don't need an erf to use it. It sounds like you are missing a dll. Did you install all the dlls from the exe on the SIMTools page into your directory? You should have all of the following: LetoScript, madCHook, nwnx-module, nwnx_chat, nwnx_leto, nwnx_odbc, nwnx_resetplugin
Funky
|
|
|
Post by baaleos on Sept 3, 2007 0:04:22 GMT
Ok, the weird thing - First - no log called odbc - even though i have all the dll files there.. secondly - on my live game server, the live 24/7 one, it has got an odbc file, which has the content reading.
NWNX ODBC2 plugin V.0.9.2.4 (c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen visit us at http://www.nwnx.org
o Logfile maximum size limit is: 524288 bytes o Log level: Everything will be logged. o Using SQLite connection. o Hooking SCO....hooked at 5d3560 o Hooking RCO....hooked at 5d3440 o Connect successful.
Im unsure what set up is different about my live game server, opposed to my local machine, however, i can see here, that my game server tried using the normal sqlite db. Possible fix would be - making sure the new nwnx.ini file is put into the game server, upload a copy of my mod, and make sure that this copy has a database creation placeable. (I actually have to e-mail some guy to get him to restart it... bummer...)
(I used to be hosted with dungeonserver.com but they had my game server offline for 3 whole days, and didnt respond to my e-mails. so I left them, and got a new host... i am unable to admin the server though... no interface for windows server)
|
|
|
Post by FunkySwerve on Sept 3, 2007 0:44:16 GMT
Lol, we used to be with dungeonserver as well, but they left us offline for a week and then acted surprised when we left. Funky
|
|
|
Post by baaleos on Sept 3, 2007 1:07:56 GMT
Im convinced dungeonserver is run by one person who has either gone on holiday, or has died...
I canceled my subscription with them on friday, due to their website being frigged up, and my server off for 3 days, and went to adl-hosting or somthing like that.. They offer same player slots, for £5 cheaper. Minus the server control interface though.... bummer... I would only go back to dungeonserver if they offered me a really nice permanent discount. Lol
Dont suppose you know any windows server control programs out there?
I know of RAT... BUT it has a level cap of 20.. Making it a no no.
|
|
|
Post by FunkySwerve on Sept 3, 2007 1:30:45 GMT
I'll pm you our host's contact information. Formerly known as fragism, they are a small op and only want reletively knowledgeable admins, but you seem like you qualify. We've been with them ever since we left DS without a day's regret. Slightly cheaper, and phenomenal service to boot.
Did you get a chance to verify that you had all the dlls I listed?
Funky
|
|
|
Post by baaleos on Sept 3, 2007 6:25:09 GMT
Hi Funky Yes all those dll files are accounted for.. Question - Does the odbc log file generate connection log when nwnx is engaged? Because I asked the server guys to restart, and they have done so, and I have it set to use the mysql settings, and the files still read as an sqllite log. This is what currently appears in it (this file is in the root directory... for some reason i cant access the one in the logs.0 directory - they come up as page cannot be displayed... bummer. I dunno if this is a new file, or the old one. Also, could you send me ur hosts website info? I couldnt see it in your pm. Thx NWNX ODBC2 plugin V.0.9.2.4 (c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen visit us at www.nwnx.orgo Logfile maximum size limit is: 524288 bytes o Log level: Everything will be logged. o Using SQLite connection. o Hooking SCO....hooked at 5d3560 o Hooking RCO....hooked at 5d3440 o Connect successful.
|
|
|
Post by baaleos on Sept 3, 2007 6:49:38 GMT
Wooo hooooo. Its working. Sorta....
The simtools commands are working... but there is still no database tables made... weird? I guess this means there isnt currently any persistancy?
Also, can you tell me, where abouts is the dm targeter item?
I cant find it.
(how does one target ones self?)
|
|
|
Post by FunkySwerve on Sept 3, 2007 6:58:30 GMT
The command targeter is automatically created on you when you use a command that requires a target without sending it in a tell. You can target yourself by eihter typing someingthing to get text in the chat box and then clicking on the portrait next to the text, or by typing the following:
/tp "<playername>" command to be sent
for example, if I wanted to playerinfo myself:
/tp "FunkySwerve" !playerinfo
If I simply type !playerinfo in talk, a command targeter will be created and I will be prompted to use it.
After changing the database setup script to the MySQL configuration, did you then compile the script and save? Without that, it's still trying to do the SQLite setup. Funky
|
|
|
Post by baaleos on Sept 3, 2007 7:50:50 GMT
Ahhh, so the player targeter item will be created auto"magically" when a command is used that requires it?
Interesting.
I only managed to get it working this morning, about an hour ago, now im in work. So it will be 7 or so hours before I get to try to fix it and all.
However, I am pretty sure I did compile all the scripts, thats what I usually do.
I dont usually do a rebuild, they always take ages. Is a rebuilt required?
|
|
|
Post by FunkySwerve on Sept 3, 2007 9:23:13 GMT
For any edits that you make to scripts to take effect, you MUST compile them and then save them. You neen't rebuild the whole mod, but with a mod the size of the SIMTools demo it'll only take a few seconds anyway. That's why you aren't connecting - it's trying to use SQLite. Funky
|
|
|
Post by baaleos on Sept 6, 2007 20:16:46 GMT
Ok, its now using mysql, but its giving the following errors ! SQL Error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'pwdata'. Make sure it exists and that its name is spelled correctly. I have my nwnx.ini saying the following. ; NWNX2 configuration file ; These are the default values for NWNX2. Values specified on the command ; line take precedence. [NWNX] ServerPort = 5121 ModuleName = "A world of Rhun v2-11a" WatchdogProcess = yes UpdateIntervalProcess = 5 WatchdogGamespy = yes UpdateIntervalGamespy = 5 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 = sqlite ;file = sqlite.db ; Use these two settings for ODBC connections source = odbc dsn = nwn ; Use these five settings for MySQL connections source = mysql server = 74.220.204.131 user = azmodann_Baaleos pwd = ###### db = azmodann_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 [CHAT] chat_script = fky_chat server_script = fky_chat_srv I managed to create the table pwdata manually, for some reason, sql didnt like the format of the setup script This is how the pwdata table looks.
|
|