4 replies to this topic

[Infernus]

ok for some reason my tables are not being configured, i retraced my steps in the starting of the PWData table

ok i build the table in MYsql command center np

then ive seen in some places the following

create a new text file in the C:\mysql\bin folder name it db.txt

then open new file and copy/paste

USE nwn;
CREATE TABLE pwdata (
player varchar(64) default '',
tag varchar(64) default '',
name varchar(64) default '',
val text,
expire int(11) default '0',
last timestamp(14) NOT NULL,
KEY idx (player,tag,name)
) TYPE=MyISAM;

Exit/save new text

now go to the command prompt window and enter the following

mysql -u nwnuser -p nwn <db.txt

everytime i do this nothing happens no confirmation or what have you the command is not recognized

am i entering it wrong?

anyway ive followed Tiggers example for setting up

mysql server
mysql control
setting up the database(did the test np)

NWNX.INI FILE IS AS FOLLOWS

; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = "Nordock-CEP-PRC-Plagued"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 5

[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 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 = localhost
;user = nwnuser
;pwd = nwnuser
;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

and all .dll files\leto\haks with haks\tlk with tlk you get the idea:)

my problem seems to be the data tables being made i used the mini mod and made one of each class type, i thought eveything was going well the character creation was speeding up

put the main mod in and i keep timming out and then i looked in mysql and only the PWData tables are there, so theres a dissconnect, but me being computer challenged

i could use some guidance

any help as always greatly appreciated

[dingosatemybaby]

ok for some reason my tables are not being configured, i retraced my steps in the starting of the PWData table

ok i build the table in MYsql command center np

then ive seen in some places the following

create a new text file in the C:\mysql\bin folder name it db.txt

then open new file and copy/paste

USE nwn;
CREATE TABLE pwdata (
player varchar(64) default '',
tag varchar(64) default '',
name varchar(64) default '',
val text,
expire int(11) default '0',
last timestamp(14) NOT NULL,
KEY idx (player,tag,name)
) TYPE=MyISAM;

Exit/save new text

now go to the command prompt window and enter the following

mysql -u nwnuser -p nwn <db.txt

everytime i do this nothing happens no confirmation or what have you the command is not recognized

am i entering it wrong?

anyway ive followed Tiggers example for setting up

mysql server
mysql control
setting up the database(did the test np)

NWNX.INI FILE IS AS FOLLOWS

; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = "Nordock-CEP-PRC-Plagued"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 5

[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 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 = localhost
;user  = nwnuser
;pwd    = nwnuser
;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

and all .dll files\leto\haks with haks\tlk with tlk you get the idea:)

my problem seems to be the data tables being made i used the mini mod and made one of each class type, i thought eveything was going well the character creation was speeding up

put the main mod in and i keep timming out and then i looked in mysql and only the PWData tables are there, so theres a dissconnect, but me being computer challenged

i could use some guidance

any help as always greatly appreciated

Are you using the sql control center gui? Tiggerlickers instructions here show how to install that.

Then his instructions on setting up the db on this page show how to cut & paste the query into the db and execute it.

I am no sql expert, but I think the instructions here are still valid and these are what I used I think when I set up v8 and it worked good.

./Dingo

[muaddib]

Here is your problem:

; 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 = localhost
;user = nwnuser
;pwd = nwnuser
;db = nwn


Notice your using sqlite for the database NOT mysql...change it to this

; 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 = localhost
user = nwnuser
pwd = nwnuser
db = nwn


Now try it.

[Infernus]

Here is your problem:

; 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 = localhost
;user  = nwnuser
;pwd    = nwnuser
;db    = nwn


Notice your using sqlite for the database NOT mysql...change it to this

; 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 = localhost
user  = nwnuser
pwd    = nwnuser
db    = nwn


Now try it.

well computer savvy im not

that was it these were in the wrong place ";"

that was my whole problem tyvm for your help and pateince with my inncessant bothering and pestering :thumb:

[Jacquel137]

Same Problem here with the SQLite settings uncommented and the MYSql settings commented. I know alot of people arnt compy savvy, might want to add a nwnx.ini to the module with the MYSQL settings... set up. its hard to notice that a line that starts with a ';' is a comment and not parsed by NWNX.

just thought i would say it plain as day.

Any line in the nwnx.ini file that begins with a semi-colon ; is a comment and not loaded when the server is started.

if you want a setting to be used, remove the semi-colon.

dont forget to also comment the SQLite settings
just add a ; at the beginning of the source and db lines under the SQLite heading.