Player Resource Consortium

Neverwinter Nights => Help => Topic started by: Moixa on July 27, 2010, 01:21:45 PM

Title: Help with ConvoCC for server
Post by: Moixa on July 27, 2010, 01:21:45 PM
Hi all,

It seems that when I log into my server that I am unable to use the PRC ConvoCC, it just hangs and I am unable to select anything, I am using the latest PRC and CEP and as far as am aware I have merged them all correctly.  I beleive that my problem is that I may have set up my switches incorrectly possibly as I do not really understand that part.

I have attached an image of how I set up the variables so any help would be greatly appreciated I have read every post in the help section but seems I am either not understanding something or just plain missed it, and hope it is that which is causing the problem.

Thanks in advance :)
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 27, 2010, 04:26:44 PM
Quote from: Moixa

Hi all,

It seems that when I log into my server that I am unable to use the PRC ConvoCC, it just hangs and I am unable to select anything, I am using the latest PRC and CEP and as far as am aware I have merged them all correctly.  I beleive that my problem is that I may have set up my switches incorrectly possibly as I do not really understand that part.

I have attached an image of how I set up the variables so any help would be greatly appreciated I have read every post in the help section but seems I am either not understanding something or just plain missed it, and hope it is that which is causing the problem.

Thanks in advance :)


Post your logs please.
Title: Help with ConvoCC for server
Post by: xwarren on July 27, 2010, 05:30:17 PM
Quote from: Moixa

Hi all,

It seems that when I log into my server that I am unable to use the PRC ConvoCC, it just hangs and I am unable to select anything, I am using the latest PRC and CEP and as far as am aware I have merged them all correctly.  I beleive that my problem is that I may have set up my switches incorrectly possibly as I do not really understand that part.

I have attached an image of how I set up the variables so any help would be greatly appreciated I have read every post in the help section but seems I am either not understanding something or just plain missed it, and hope it is that which is causing the problem.

Thanks in advance :)


Try this:
Code: [Select]
PRC_LETOSCRIPT_NWN_DIR  -> E:/NeverwinterNights/NWN/
Title: Help with ConvoCC for server
Post by: Moixa on July 28, 2010, 07:04:06 AM
Hi,

Xwarren I have tried the code you mentioned.  Still the same result.

Here is a copy of my Log file I hope I included the correct ones, it seems that in the nwnx-odbc it mentions that it had trouble connecting to MYSQL, but I am using SQlite.

Thanks
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 28, 2010, 08:35:33 AM
Quote from: Moixa

Here is a copy of my Log file I hope I included the correct ones, it seems that in the nwnx-odbc it mentions that it had trouble connecting to MYSQL, but I am using SQlite.


Is your NWNx.ini setup to use SQLite?
Title: Help with ConvoCC for server
Post by: Moixa on July 28, 2010, 08:40:43 AM
Hi,

I have the ini file set at the standard settings, I assumed it would work automatically?, if stoclk settings are not right could you post an example of what it should look like please.
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 28, 2010, 09:10:06 AM
Quote from: Moixa

Hi,

I have the ini file set at the standard settings, I assumed it would work automatically?, if stoclk settings are not right could you post an example of what it should look like please.


Yours should look something like this:

Code: [Select]
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = SERVERNAME
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = yes
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 15
ServerVault = .\servervault

[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   = .\db\sqlite.db

; Use these two settings for ODBC connections
;source = odbc
;dsn    = nwn

; Use these five settings for MySQL connections
;source = mysql
;server = localhost
;user   = USER
;pwd    = PASS
;db     = SCHEMA

; 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

[DELETECHAR]
LogLevel = 1               ; 0=nothing, 1=write a log
DeleteOrMove = 1           ; 0=move file out of player dir, 1=delete file
MoveToPath= .\deletevault
Title: Help with ConvoCC for server
Post by: Moixa on July 28, 2010, 11:03:24 AM
Hi Heatstroke,

I have modified my NWNX file accordingly and now seems to hook up to the database (SQLite) properly, but I still have the game locking up when I enter server when it asks you the first question on the ConvoCC dialogue, I am unable to select anything.  Could you please takle a look at these 2 files from my log, these are the only 2 that appear to be indicating errors.

Thanks .
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 28, 2010, 01:51:19 PM
Quote from: Moixa

Hi Heatstroke,

I have modified my NWNX file accordingly and now seems to hook up to the database (SQLite) properly, but I still have the game locking up when I enter server when it asks you the first question on the ConvoCC dialogue, I am unable to select anything.  Could you please takle a look at these 2 files from my log, these are the only 2 that appear to be indicating errors.

Thanks .


I don't know much about SQLite, but it looks it's connecting to an empty DB maybe?  Try precaching the DB again.
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 11:22:21 AM
Hi Heatstroke,

I seem to have a problem regarding the creation of a database when I run the Precatcher for both sqllite and mysql, it seems neither of them either fill up a database or give me a out.sql file.  I was wondering if it could be due to the fact that I am using windows 7 X64? , has anyone got a precached database for sqllite or mysql for the latest 3.3h that I could try please.

Thanks
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 12:22:24 PM
You don't need to catch MySQL and SQLLite. Since you have SQLLite turned on.

After running the SQLLite precatcher and the the MSDOS window close their should be a sqlite.db in the same directory as the batch file. This is the database file for SQLLite.

Do you have a sqlite.db file in your NWN directory?
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 12:31:34 PM
Hi Ken,

It does not create database file :( any ideas?
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 12:33:48 PM
Open up the batch file and add pause to the end of it. Something is going wrong with it. This will let you see any errors that pop up.

Run the batch file again and tell us of any error you see.
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 12:48:40 PM
Hi Ken,

here is image, it was all fine up until the picture shows.

Thanks
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 01:03:17 PM
Quote from: Moixa

Hi Ken,

here is image, it was all fine up until the picture shows.

Thanks


No image.
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 01:10:32 PM
I know, seems it wont accept the image here, I guess too big... ok shruink it
Title: Help with ConvoCC for server
Post by: xwarren on July 29, 2010, 01:13:22 PM
1. you don't have java installed
2. it seems that you are using an older version of ConvoCC

?
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 01:24:24 PM
Okies, which version of Java do I need and ConvoCC can you provide a lionk to make sure I get correct versions please.

Thanks
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 01:25:40 PM
Just update to the latest version of Java.

JRE 6 Update 21 is the latest I think. But as I said just get the latest version/
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 01:41:06 PM
You don't have Java  (http://www.java.com/en/download/manual.jsp)installed.

EDIT: Doh, ninja'd!

I should hit refresh before replying I guess.
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 01:50:01 PM
Sounds silly but where do I get this ConvoCC from I assumed I had everything, but need to double check I am not missing anything.
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 02:03:23 PM
Quote from: Moixa

Sounds silly but where do I get this ConvoCC from I assumed I had everything, but need to double check I am not missing anything.


It's part of the PRC.
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 02:06:24 PM
The fact that xwarren said it was out of date would imply that your not using the latest PRC which is 3.3H. Are you using that version of the PRC?
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 02:14:32 PM
I have 3.3 h on the server and Java that is what I do not understand, I assumed I was missing a download but seems not :(
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 02:19:09 PM
Quote from: Moixa

I have 3.3 h on the server and Java that is what I do not understand, I assumed I was missing a download but seems not :(


Java isn't installed properly if you do have it on your PC.  Also, I'm pretty sure the Precacher doesn't work on a 64 bit OS.
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 02:21:54 PM
hmm, I did mention earlier on in thread that I use a X64 windows system, so does this mean I will be unable to use PRC on my server as I am unable to create a database?
Title: Help with ConvoCC for server
Post by: xwarren on July 29, 2010, 04:05:04 PM
Quote from: DM Heatstroke

Quote from: Moixa

I have 3.3 h on the server and Java that is what I do not understand, I assumed I was missing a download but seems not :(


Java isn't installed properly if you do have it on your PC.  Also, I'm pretty sure the Precacher doesn't work on a 64 bit OS.


I know somebody who did created a database on 64 bit system ;p

When you install Java you just need to run 'precacher sqlite prc.bat' it will generate the database (sqlite.db ). The module seems to be set up correctly, so you just need to edit your nwnx.ini file so it looks like DM Heatstroke's ;)
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 05:07:47 PM
thanks,

 I tried all but still no luck but did not realise it would be so hard to do, I am sure a few years ago running the prc on my server was no problems.    I spent many hours trying to get it to work the way I thought it should, as able to select any class at start, and last few hours I have been hopping in and out of the few prc servers out there, and none of them seem to offer at level 1 the classes offered by prc on initial char selection, and when finally get on the server they seem to have no prc convo conversation and you have to be level 2 before can use prc skills/classes.  Is that the way it is meant to work or are you meant to be able to select class at level on initial server log in?

I am not sure if I am plain confused or maybe the other servers using prc gave up and just able to select  prc classes etc after level 2, like I had iniitially?

But unable to seemingly generate a sqllite database is not good for my situation

Thanks
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 05:14:12 PM
You can't select a PRC class from the character creation screen. This is due to a limitation with the NWN game engine. The PRC fixes this by using the ConvoCC that starts up when you login with a new character. This simulates the character creation process. Allowing you to create a level 1 character with a PRC class.

You said you have Java on your server what version do you have?
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 05:41:48 PM
I have jave 6  update 21, also tried the DB file you offered
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 06:05:02 PM
yes my friend I am 1.8.2
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 06:07:33 PM
I wiped my post as I realized my idea was not applicable. But you replied to fast it seems.

You could try adding the -d32 switch to the java line of the precatcher.

The line would look like this: java -d32 -Xmx100m -jar prc.jar 2datosql precacher2das sqlite
Title: Help with ConvoCC for server
Post by: Moixa on July 29, 2010, 06:17:44 PM
I just tried your last suggestion, that did nor work either :(

Thanks though
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 06:47:13 PM
Try doing some googleing about solutions for the "java is not recognized as an external or internal command" error. If you can find a solution for that the precatcher should work. Then we can move on to the issue with your module.
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 09:10:27 PM
Quote from: KenquinnTheInsaneOne

Try doing some googleing about solutions for the "java is not recognized as an external or internal command" error. If you can find a solution for that the precatcher should work. Then we can move on to the issue with your module.


Maybe Java never got added to his Windows PATH?
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 09:13:31 PM
Quote from: KenquinnTheInsaneOne

I wiped my post as I realized my idea was not applicable. But you replied to fast it seems.

You could try adding the -d32 switch to the java line of the precatcher.

The line would look like this: java -d32 -Xmx100m -jar prc.jar 2datosql precacher2das sqlite


You need to add more RAM to that command.  Try -Xmx512m instead.
Title: Help with ConvoCC for server
Post by: KenquinnTheInsaneOne on July 29, 2010, 09:15:31 PM
Why would it need to be increased over the stock 100?
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 09:18:06 PM
Quote from: Moixa

thanks,

 I tried all but still no luck but did not realise it would be so hard to do, I am sure a few years ago running the prc on my server was no problems.    I spent many hours trying to get it to work the way I thought it should, as able to select any class at start, and last few hours I have been hopping in and out of the few prc servers out there, and none of them seem to offer at level 1 the classes offered by prc on initial char selection, and when finally get on the server they seem to have no prc convo conversation and you have to be level 2 before can use prc skills/classes.  Is that the way it is meant to work or are you meant to be able to select class at level on initial server log in?

I am not sure if I am plain confused or maybe the other servers using prc gave up and just able to select  prc classes etc after level 2, like I had iniitially?

But unable to seemingly generate a sqllite database is not good for my situation

Thanks


Feel free to log into my server if you want to see how it is supposed to work.


Flaming Sword's PRC Multiplayer Tester
IP: 67.223.193.78:5130

or under Tech Support on GameSpy
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 29, 2010, 09:19:14 PM
Quote from: KenquinnTheInsaneOne

Why would it need to be increased over the stock 100?


It won't run on my PC with that command line, I actually have mine kicked up to 1024.
Title: Help with ConvoCC for server
Post by: Moixa on July 30, 2010, 07:02:29 AM
Hi all,

Finally after a lot of reading I have managed to get the precacher and the ConvoCC to work properly, thanks a lot for all who tried to help and I now have a PRC 3.3h and CEP 2.3 server hosted under PW Action server name Moixa so please feel free to hop in :)

And how did I get it to work:

I downloaded the Java Development kit and the Java Runtime enviroment ( I needed both from here)  http://www.oracle.com/technetwork/java/javase/downloads/index.html#need

and installed them both to my server PC.

I then used this to set up my enviromental variables automatically as I am rather lazy and I got this nifty little programme from here http://www.moparscape.org/smf/index.php/topic,375681.0.html

Well the precahcer for sqllite still did not work so I had to change the bottom section of it to this:  

Code: [Select]
del precacher2das\*.2da
mkdir precacher2das
7za x bioware2das.7z -oprecacher2das
erf -x hak\prc_2das.hak
erf -x hak\prc_race.hak
copy cls_feat*.2da precacher2das\*.2da
copy cls_skill*.2da precacher2das\*.2da
copy race_feat*.2da precacher2das\*.2da
copy spells.2da precacher2das\*.2da
copy racialappear.2da precacher2das\*.2da
copy racialtypes.2da precacher2das\*.2da
copy classes.2da precacher2das\*.2da
copy feat.2da precacher2das\*.2da
copy domains.2da precacher2das\*.2da
copy appearance.2da precacher2das\*.2da
copy portraits.2da precacher2das\*.2da
copy soundset.2da precacher2das\*.2da
copy wingmodel.2da precacher2das\*.2da
copy tailmodel.2da precacher2das\*.2da
copy gender.2da precacher2das\*.2da
copy hen_companion.2da precacher2das\*.2da
copy hen_familiar.2da precacher2das\*.2da
copy custom2das\*.2da precacher2das\*.2da
del *.2da
del *.nss
del *.ncs
del sqlite.db
java -Xmx1024m -jar prc.jar 2datosql precacher2das sqlite
sqlite sqlite.db ".read out.sql"
pause


As you can see I removed the -d32 (not sure what that does but would not work with it) also changed the Xmx100m line to Xmx11024m   as seemed I got a memory error when precaching was running even though have 2 gigs of memory on the server.

Well I am extremely happy and thanks again for your help and hopefully the information here willl help someone else.
Title: Help with ConvoCC for server
Post by: DM Heatstroke on July 30, 2010, 08:27:42 AM
Good deal.
Title: Help with ConvoCC for server
Post by: taoistarts on August 07, 2010, 07:09:47 AM
Well I just went to check out your world Moixa and I didn't get the CC convo when I logged in.
Title: Help with ConvoCC for server
Post by: Moixa on August 13, 2010, 10:57:30 AM
Hi,

Sorry, I have been really busy, if you try it, it now works correctly, please feel free to give it another go :)
Title: Help with ConvoCC for server
Post by: Sorathul on August 26, 2010, 07:02:02 AM
I'm having a different problem with the ConvoCC.
Works fine (though the Feat list takes a bit long) until I try to create a Psion or Shaman.
After the skill selection it just throws me out with "Server response timed out" or something similar, right before getting to the Feats.

I wanted to try it out on DM Heatstroke's module, but couldn't find the required haks.
Title: Help with ConvoCC for server
Post by: DM Heatstroke on August 26, 2010, 11:44:32 AM
Quote from: Sorathul

I'm having a different problem with the ConvoCC.
Works fine (though the Feat list takes a bit long) until I try to create a Psion or Shaman.
After the skill selection it just throws me out with "Server response timed out" or something similar, right before getting to the Feats.

I wanted to try it out on DM Heatstroke's module, but couldn't find the required haks.


You didn't look very hard. (http://www.athasreborn.com/smf/index.php?topic=3857.0)
Title: Help with ConvoCC for server
Post by: Moixa on August 26, 2010, 02:12:23 PM
Hi Sorathull,

If unable to get on to DM Heatsrokes module, try mine but needs PR 3.3h and the CEP 2.3 Haks, It is under PW Action under servername Moixa.  Not ever tried those classes, but should be able to make.