ERROR: unable to connect to database.

[Amun Quoi]

I am getting the following error message whenever I start Talus Listener.exe:

ERROR: unable to connect to database.

I have NWNX running peachy well on MySQL, and the speech setup mod creates the proper tables in the database. Only the Listener seems to be having problems connecting.

Strangely enough, the program continues to run after the error message, asking me for interface number, and then saying that it's listening.

My own speech isn't displayed, but that's a different issue apparently. Other players' text is displayed in the Listener program's command window. However, the *help* command doesn't do anything in the game. And when I check the nwnx_odbc.txt log, it only displays zero-byte responses.

Obviously, the Listener can't communicate with the database, but what can I do about it? There doesn't seem to be a configuration file or anything where I could change the username and password for connecting to the MySQL server.

Thanks in advance,

Amun Quoi

[Lanthar D'Alton]

check nwnx_talus.ini

change the line that says

UseDatabase=1
to
UseDatabase=0

This should fix that issue. Beyond that, ensure that the name of the module in the module properties (edit->module properties) dialog is an exact match to the filename.

Try it with my setup module before anything else.

The ini file change must be made without the server running. The nwnx_speech.dll rewrites the nwnx_talus.ini file on exiting, so it you want to make changes, make them without nwn server loaded.

Let me know if that doesn't help. I'd recommend you get icq or aim and contact me if it doesn't help.

Additionally... you cannot connect to LAN server if your client and server are running on the same machine. Instead connect using the Internet game choice, and then choose your server from that list. This forces your machine to send network packets out and back to yourself. The listener sniffs network packets, so if you are connecting to yourself, localhost doesn't cut it.

If nothing else, try going to www.ipchicken.com. Write down the IP address displayed there. Then, launch nwn and use the direct connect button. Type the address ipchicken gave you into the server address blank for direct connect. This forces your machine to go outside itself and actually send network packets that the listener captures.

-Lanthar

[Amun Quoi]

There is no file named nwnx_talus.ini. There is nwnx_speech.ini though, which I assume has to do with the NWNX module version of the Listener, not the separate program. This file doesn't have a UseDatabase line at all. I tried adding it, but this did not solve the issue.

As a side note, I cannot get the NWNX module to work either. The NWNX log file contains this error message: "An error occured while loading extension speech (126: The specified module could not be found. )" I assume that this is the same issue as with the Talus Listener.exe program, and will be fixed when I get the program to run correctly.

Also, my internal IP is the same as the external one. I always use the real IP address instead of localhost. I did try connecting via "Join Internet game", but the listener still didn't hear what I said (as a DM).

By the way, which version of the .exe is the one I should use? The one on NWVault is 88kB and dated March 2nd 2004, and the one on your home page is 216kB and dated October 19th 2003.

[Lanthar D'Alton]

Egads. Those are very out of date. Go here and get the newest beta. (currently 3.03b. I just added a link to it on my download site)

lanthar.dyndsl.com/downloads.html

then delete your nwnx_speech.ini, and overwrite the existing nwnx_speech.dll with the one in my rar. On first launching, it will prompt for configuration. Note your interface number from the standalone listener, then launch with the dll. Be sure you choose NOT to Use Database when it asks you to configure it.

[Amun Quoi]

Heh, well that solved the database issue. ;D With the latest version it would appear to be working. I had someone log in and test the *help* command, which brought out the help.

The listener still doesn't hear my own speech though. I would guess it's because I don't have NAT, so my external IP is the same as the internal one. Since there is no actual network traffic going on, there's nothing to listen to.

Is there anything I can do about the situation? The main reason I'm testing out your listener is because my own NPC-based one is unreliable with DMs.

[Lanthar D'Alton]

Wel, you could buy a router and set up an internal ip network and then connect by connecting to the one outside it... *shrug*

-Lanthar

[Amun Quoi]

Not really worth it for one weekly session of NWN. I am only running a fully DMed game for 6 players once a week. If I was hosting a big persistent world, things would be different.

Thanks for all the support though.

[LuckyDay]

Lanthar
I've had the same problem and fixed it by setting UseDatabase=0. I have most of the functionality working in my test mod now.

However, I'm wanting to use the Database.

I can use the aps_demo with MySQL fine but when I try to use the Speech Plugin it gives the same error: unable to connect to database.

This is not an erroneus message is it? I can see the lds_ etc tables in MySQL so it looks like they were created fine at least one of the times I iniitalized. I can't find the any of the actual dialog as data however.

I'm using MySQL 5.0 and viewing it with the administrator and the 3.04b version of the speech.

thanks
Lucky Day

[Lanthar D'Alton]

why do you want to use the database? this only affects whether the system populates the tables with what is said. Since 3.04 can directly go to the dll for this info (which is way faster btw), using the database is silly. Do you have your own systems that rely on the "nwn_speech" table? That is all this affects... Other tables still get used normally as before. Well, the Actions list is now stored in an INI... but that's easy for you to move too... and the new way is also much faster. These changes take mysql out of the loop only for action number lookups, and for grabbing what was said.

So, you *should* have UseDatabase=0
Do you still get problems if you do that?