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 
 
I don't know what I've done wrong...
Goto page Previous  1, 2
 
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support
View previous topic :: View next topic  
Author Message
NoMercy



Joined: 03 Jan 2005
Posts: 123
Location: UK

PostPosted: Mon Jan 17, 2005 3:28    Post subject: Reply with quote

I'm also expierencing problems with the object storage, objects seem to be saved out fine under SQLite but crash nwserver in a similar fassion to the original poster when trying to read them back.

Files generated, no change to default module:
DrWatson Dump
NWNX ODBC log

Upgraded to 0.9.2.1, and tested with MySQL, and it seems it can't connect anymore, "Client does not support authentication protocol requested by server" (then crashed when issueing the CREATE statement), hey ho :)
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Mon Jan 17, 2005 20:44    Post subject: Reply with quote

MacLir, since I am not able to reproduce the crash on my computers, we will have to test several things to nail the problem down. I will create a special odbc2 module for you, which hooks sco/rco a bit differently, and we will see how that goes.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
MacLir



Joined: 13 Jan 2005
Posts: 22

PostPosted: Mon Jan 17, 2005 21:37    Post subject: Reply with quote

Sounds good to me. At this point, I'm willing to try anything. Very Happy
Back to top
View user's profile Send private message Send e-mail
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Mon Jan 17, 2005 21:40    Post subject: Reply with quote

Try this one: http://nwnx.org/fileadmin/user_upload/nwnx_odbc.zip
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Mon Jan 17, 2005 22:11    Post subject: Reply with quote

And this one: http://nwnx.org/fileadmin/user_upload/nwnx_odbca.zip
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Mon Jan 17, 2005 22:22    Post subject: Reply with quote

Btw, please also test both methods in demo_obj_load, they work quite different internally.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
MacLir



Joined: 13 Jan 2005
Posts: 22

PostPosted: Tue Jan 18, 2005 0:45    Post subject: Reply with quote

Ok, testing done.

As an aside, I just wanted to point out that my testing has, from the start (3 days ago), been on the downloadable Stand-Alone Server. I placed it in the Neverwinter Nights directory as the 'Server' directory (full path is 'E:\Neverwinter Nights\Server\nwserver.exe').

I've also noticed that storage to MySQL 4.1.8 seems instantaneous, whereas SQLite lags a bit and increases as more items are stored.

Sorry, results:

Method 1 - 1st plugin
    SQLite
      3 items - 4 retrieve calls - Success

      5 items - 5 retrieve calls - Failure

      6 items - 3 retrieve calls - Failure


    MySQL
      3 items - 2 retrieve calls - Failure

      5 items - 2 retrieve calls - Failure

      6 items - 2 retrieve calls - Failure



Method 2 - 1st plugin
    SQLite
      3 items - 1 retrieve call* - Failure

      5 items - 1 retrieve call* - Failure

      6 items - 1 retrieve call* - Failure


    MySQL
      3 items - 1 retrieve call* - Failure

      5 items - 1 retrieve call* - Failure

      6 items - 1 retrieve call* - Failure



Method 1 - 2nd plugin
    SQLite
      3 items - 2 retrieve calls - Failure

      5 items - 3 retrieve calls - Failure

      6 items - 2 retrieve calls - Failure


    MySQL
      3 items - 2 retrieve calls - Failure

      5 items - 2 retrieve calls - Failure

      6 items - 3 retrieve calls - Failure



Method 2 - 2nd plugin
    SQLite
      3 items - 1 retrieve call* - Failure

      5 items - 1 retrieve call* - Failure

      6 items - 1 retrieve call* - Failure


    MySQL
      3 items - 1 retrieve call* - Failure

      5 items - 1 retrieve call* - Failure

      6 items - 1 retrieve call* - Failure



* - Indicates that the retrieve call never finished in full, it was always a 'partial' retrieve call.
Success - retrieval worked with no crash. Smile
Failure - server crashed.

At least we're getting somewhere, one success is better than none. Very Happy
Back to top
View user's profile Send private message Send e-mail
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Tue Jan 18, 2005 21:35    Post subject: Reply with quote

Can someone who experiences these crashes give me remote desktop access to one of his machines ? I'd like to step through this with OllyDbg (my debugger of choice). Please PM if possible.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
MacLir



Joined: 13 Jan 2005
Posts: 22

PostPosted: Wed Jan 19, 2005 0:39    Post subject: Reply with quote

Grr... If I had access to configure the router I'm behind, I'd be more than happy to... As it stands, I can't even host for friends; unless we do a seperate LAN, in which case internet access is gone as I only have one NIC... Razz
Back to top
View user's profile Send private message Send e-mail
MacLir



Joined: 13 Jan 2005
Posts: 22

PostPosted: Mon Jan 24, 2005 3:42    Post subject: Reply with quote

Well on a positive note, it works now... But I have just 'upgraded' to WinXP Home. Razz

At least now I can play with some ideas I have... Very Happy
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Windows technical support All times are GMT + 2 Hours
Goto page Previous  1, 2
Page 2 of 2

 
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