Connecting to the MySQL Database - Revision history

Basilica: Document new SQL log file.

2014-08-16T23:03:38Z

Document new SQL log file.

Basilica at 05:39, 10 August 2014

2014-08-10T05:39:48Z

Foambats4all at 22:13, 18 June 2014

2014-06-18T22:13:16Z

Foambats4all: Created page with "Category:Tech Guides Follow these instructions: # Download and extract the following NWNX4 files from the link below to a dedicated folder on your host machine (eg. C:\NWN..."

2014-01-23T06:12:55Z

Created page with "Category:Tech Guides Follow these instructions: # Download and extract the following NWNX4 files from the link below to a dedicated folder on your host machine (eg. C:\NWN..."

New page

[[Category:Tech Guides]]
Follow these instructions:
# Download and extract the following NWNX4 files from the link below to a dedicated folder on your host machine (eg. C:\NWNX4):
#* NWNX4_Controller.exe
#* NWNX4_GUI.exe
#* madCHook.dll
#* NWNX4_Hook.dll
#* xp_mysql.dll
#* xp_time.dll
#* nwnx.ini
#* xp_mysql.ini
# Copy the madCHook.dll file to your Neverwinter Nights 2 game folder (where the game installed itself).
# You will need to configure nwnx.ini with your module and game information. The most important line is the parameters entry:
#: <code>parameters = -module "'''<My Module>'''" -servervault 1 -publicserver 1</code>
#: If you prefer to launch your module in directory mode, use the -moduledir paramater in place of -module.
# You will need to configure xp_mysql.ini with the correct connection details for the remote database server. Please contact the IA, TA, or DMA for that information.
# Once you have the file configured, you can launch your server using the NWNX4_GUI.exe program (NOT nwn2server.exe as you normally would). It will automatically launch nwn2server for you.
#: Alternatively, you can install NWNX4 as a service on your host machine by issuing the following commands in your NWNX4 folder (only recommended for advanced users):
#:: <code>NWNX4_Controller.exe -installservice</code>
#:: <code>NWNX4_Controller.exe -startservice</code>
#: NWNX4 will show up as a Windows service, which can be started and stopped like any other service on your machine (via Services in Administrative Tools). You can enable the nwn2server dialog window by navigating to the NWNX4 service, clicking on its properties, selecting the "Log On" tab, and checking the "Desktop Interaction" box.
#: Other service commands you can issue using NWNX4_Controller.exe:
#:: <code>-serviceno</code> -- Specify service instance number
#:: <code>-stopservice</code> -- Stop the NWNX service
#:: <code>-uninstallservice</code> -- Uninstall the NWNX service
#:: <code>-interactive</code> -- Start in interactive mode

Note: NWNX logs are recorded in the nwnx.txt file, and MySQL logs are recorded in the xp_mysql.txt file in the install folder. These will help you identify any configuration or run time sql problems (like bad queries).

← Older revision		Revision as of 23:03, 16 August 2014
Line 32:		Line 32:
	#:: <code>-interactive</code> -- Start in interactive mode		#:: <code>-interactive</code> -- Start in interactive mode

−	Note: NWNX logs are recorded in the nwnx.txt file, and MySQL logs are recorded in the xp_mysql.txt file in the install folder. These will help you identify any configuration or run time sql problems (like bad queries).	+	Note: NWNX logs are recorded in the nwnx.txt file, and MySQL logs are recorded in the StandardQueryLog.txt (formerly xp_mysql.txt) file in the install folder. These will help you identify any configuration or run time sql problems (like bad queries).

@@ Line 1: / Line 1: @@
 [[Category:Technical Manuals]]
 Follow these instructions:
 # Download and extract the following NWNX4 files from the link below to a dedicated folder on your host machine (eg. C:\NWNX4):