| View previous topic :: View next topic |
| Author |
Message |
TormentedBlood
Joined: 22 Jul 2008
Posts: 14
|
 Posted: Wed Jul 23, 2008 2:11 Post subject: problem getting my connection to the mysql to connect. |
 |
|
| Quote: | NWNX2 ODBC2 version 0.3 for Linux.
(c) 2005-2006 by dumbo (dumbo@nm.ru) & virusman (virusman@virusman.ru)
o SCO located at 82d9c44.
o RCO located at 82d9b60.
! Error while connecting to database: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
o Shutdown. |
any ideas on what can cause this? i have the obdc section of nwnx2.ini filled out:: (ommited password here)
| Quote: | [ODBC2]
; Log File
MaxLogSize = 1024 ; in Kbyte
LogLevel = 2; 0=Nothing, 1=only errors, 2=everything
source = mysql
server = localhost #name of the database server
user = Donait #username to access db
pass = #password for username
db = nwn #database to connect to
hookscorco = true |
| Quote: | NWNX2lib: Init
NWNX2lib: org SetString() at 0x81f41b4, new SetString() at 0xb7fa3f00
NWNX2lib: org GetObj() at 0x81f40bc, new GetObj() at 0xb7fa3f28
* Parsing configuration...
NWN Extender v2.7-beta4
(c) 2004 by the APS/NWNX Linux Conversion Group
(c) 2007-2008 by virusman
Based on the Win32 version (c) 2003 by Ingmar Stieger (Papillon)
and Jeroen Broekhuizen
visit us at http://www.avlis.org
* Loading modules...
PROFILER plugin Registerred.
TMI plugin Registerred.
MNX plugin Registerred.
STRUCTS plugin Registerred.
RESETPLUGIN plugin Registerred.
EVENTS plugin Registerred.
FIXES plugin Registerred.
HASHSET plugin Registerred.
CHAT plugin Registerred.
ERROR: ODBC: OnCreate() failed.
LETO plugin Registerred.
FUNCTIONS plugin Registerred.
RESMAN plugin Registerred.
* NWNX2 activated.
Neverwinter Nights Server
Build:8109
Copyright BioWare Corp 1998-2004
Server: Loading...
Server: Running...
Server: Loading module "aps_demo"...
Server: Module loaded
NWNX!INIT enforcement disabled, using 0x082041ec
* Library ODBC!SPACER does not exist.
|
|
|
| Back to top |
|
 |
TormentedBlood
Joined: 22 Jul 2008
Posts: 14
|
| Posted: Wed Jul 23, 2008 4:25 Post subject: dumb question |
|
|
| i haven't found it in any of the documentation on the newer nwnx_odbc links and threads, but is there a specific odbc driver needed on a linux system in order to get it to connect properly? |
|
| Back to top |
|
|
Fireboar
Joined: 17 Feb 2008
Posts: 323
|
| Posted: Wed Jul 23, 2008 16:08 Post subject: |
|
|
It should only need the MySQL server and MySQL client developer's libraries (for compiling). I don't think you even need the MySQL program. The dependencies haven't changed since previous versions.
What distribution are you using? Have you tried previous versions of NWNX then upgraded (I don't suggest that you try downgrading). |
|
| Back to top |
|
|
TormentedBlood
Joined: 22 Jul 2008
Posts: 14
|
| Posted: Wed Jul 23, 2008 19:34 Post subject: |
|
|
mysql 5.1 and i had it working breifly but only if i logged in as root to the mysql server.. highly not desired. but even that stopped working.
linux ubuntu 8.04 |
|
| Back to top |
|
|
Fireboar
Joined: 17 Feb 2008
Posts: 323
|
| Posted: Thu Jul 24, 2008 11:31 Post subject: |
|
|
| Ah, do you have the user and database set up yet? MySQL uses a different user system than the rest of your system. If you don't have it, download phpmyadmin and browse to http://localhost/phpmyadmin to set up the users and database. |
|
| Back to top |
|
|
Campbell
Joined: 29 Jul 2008
Posts: 9
|
| Posted: Wed Jul 30, 2008 7:20 Post subject: |
|
|
| Was this problem ever figured out? I'm having the same issue when I try to use all the updated plugins from Virusman. As I posted in a different part of the forum, I'm currently using Fireboar's nwnx_easy which at least lets me connect to MySQL with all functions except for GetPersistentObject when the object is an NPC. It makes the server hang and I have to kill the process. This all worked great in Windows using SQLite, but I converted the comp to Ubuntu Server 8.04 and been having nothing but problems trying to set it up. |
|
| Back to top |
|
|
virusman
Joined: 30 Jan 2005
Posts: 1020
Location: Russia
|
| Posted: Thu Jul 31, 2008 12:58 Post subject: |
|
|
| The path to the mysql socket is hardcoded in this binary. If it doesn't work on your system, set the "server" setting to 127.0.0.1 instead of localhost. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
