MySQL does not answer

Mr-XXS · Joined: 14 Jan 2005 Posts: 8

I have some problemes with NwnX and the odbc plugin. The connection with the mysql database works fine, when the serveur send requests, their are executed, but when i need a response, as in a SELECT request, there is no response.
In the logs, i could'nt found any errors, and all the "Got request:" are correctly printed but no "Sent response" can be found, even for the SELECT request.

What do you think of that ? Have i to upgrade MySQL to the latest version ? Or anything else ?

Liberty Valance · Posted: Sat Jan 15, 2005 0:05 Post subject:

well first off, try using the direct mysql plugin rather than odbc. that notwithstanding, do you know if ODBC has successfully established a connection to mysql? could an erroneous username or password have been input into ODBC, therefore preventing it from connecting (although NWNX connects successfully to ODBC, thus no errors? not sure if you'd get errors in this circumstance)... just a few random thoughts while i'm at work Smile

_________________
A Persistent World West2 | APWW2 Forums
Wirehead Studios

Mr-XXS · Joined: 14 Jan 2005 Posts: 8

In fact, i have 2 servers on the same computer, each using a nwnx connected to the same modules, and the same database (i have only one installation, so i couldn't separate the settings).
Few minutes ago, i found that for one server, there is some responses from the odbc module, and for the other, no response ... should i use only one nwnx at the same time ? or perhaps is it impossible to connect two odbc plugins at the same time ?
I will try with the MySQL module.

Manuel · Joined: 30 Dec 2004 Posts: 51

Have a look here: http://www.nwnx.org/phpBB2/viewtopic.php?t=26
_________________
I only know enough to be dangerous.

Mr-XXS · Joined: 14 Jan 2005 Posts: 8

Huhu, in fact, I've forgotten to call the function SQLInit in my scripts Mr. Green

... Yes, shame on me Embarassed

The NWNX Community Forum