logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Linux ODMBC onCreate Failed - any chance of a hand?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development
View previous topic :: View next topic  
Author Message
Baaleos



Joined: 02 Sep 2007
Posts: 830

PostPosted: Sun Aug 04, 2013 20:13    Post subject: Linux ODMBC onCreate Failed - any chance of a hand? Reply with quote

I've got a MySQL Server running on the same Linux box as the server I am trying to get nwnx & nwserver working on.

I am able to connect to the MySQL database from my windows server- which is across the web - but I cant get my Linux one to connect even though its on the same host.


Quote:

NWNX2 ODBC2 version 1.0.1 for Linux.
(c) 2005-2006 dumbo (dumbo@nm.ru)
(c) 2006-2010 virusman (virusman@virusman.ru)
MySQL engine is supported
Plugin link: B76D54C0
Plugin link: B76D54C0
o SCO located at 82d9c44.
o RCO located at 82d9b60.
! Error while connecting to database: Access denied for user 'NWN'@'IPADDRESSHERE' (using password: YES)
o Shutdown.



I've tried various things : I tried localhost as the server, and now im trying the ip address.
I've changed the User several times, added new users etc. and changed the passwords etc

Is there anything I need to know about the ODBC Plugin in nwnx2 Linux to get it to work.

Heres the rest of the log info

Quote:

NWN Extender v2.8-dev
RESET plugin registered.
CONNECT plugin registered.
MNX plugin registered.
FIXES plugin registered.
SERVERLIST plugin registered.
TWEAKS plugin registered.
EVENTS plugin registered.
AREAS plugin registered.
FUNCTIONS plugin registered.
FUNCSEXT plugin registered.
DEFENSES plugin registered.
NAMES plugin registered.
HAKS plugin registered.
DMACTIONS plugin registered.
OPTIMIZATIONS plugin registered.
CHAT plugin registered.
SYSTEM plugin registered.
RESMAN plugin registered.
VISIBILITY plugin registered.
PROFILER plugin registered.
WEAPONS plugin registered.
EXTEND plugin registered.
HASHSET plugin registered.
ERROR: ODMBC_MYSQL: OnCreate() failed.
STRUCTS plugin registered.
TMI plugin registered.
FUNCS plugin registered.
SPELLS plugin registered.
* NWNX2 activated.





Quote:

[NWNX]
disablenwnxinit=y #Set to "y" to not enforce the NWNX!INIT requirement

[Debug]
debuglevel=0 #Set to 1 or higher to output successively
# # verbose debug information

[LogDir]
logdir=logs.0 #Set to the relative root of the log directory.


[FIXES]
copy_vars = 1 # Copy local variables on stack split and on store transaction,
# fire OnDisturbed when you merge a stack from a placeable
compare_vars = 1 # If set to 1, items with different local vars don't stack
keep_hidden_in_conversation = 1 # If set to 1, creatures don't unhide when they start a conversation
hp_limit = -10 # Negative HP limit - values up to -127 are allowed

hide_charlist_all = 0 # Hide the whole online characters list on login (appears empty)
hide_charlist_levels = 1 # Hide the class(es) (displays nothing instead of class list)
hide_charlist_portraits = 0 # Hide the portrait (shows default male/female portrait)
hide_charlist_dms = 1 # Hide DMs and possessed NPCs

cap_ability_inc = 75 # If greater than zero, set ability increase cap.
cap_ability_dec = 75 # If greater than zero, set ability decrease cap.
cap_atkbonus_inc = 75 # If greater than zero, set attack bonus increase cap.
cap_atkbonus_dec = 75 # If greater than zero, set attack bonus decrease cap.
cap_skill_inc = 75 # If greater than zero, set skill increase cap.
cap_skill_dec = 75 # If greater than zero, set skill decrease cap.


[ODBC2]
; for sqlite3
;source=SQLITE
;file=./test.sqlite3

; for mysql
source=MYSQL
server=ip.add.res.s
user=NWN
pass=12345
pwd=12345
db=nwn


; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco=true

[RESOURCEMANAGER]
MaxLogSize = 512;
LogLevel = 1;
SourcePath = externalsources\;
Folders = 1;

[CHAT]
chat_script=fky_chat;
server_script=fky_chat_srv;






Please help?!
Back to top
View user's profile Send private message
Baaleos



Joined: 02 Sep 2007
Posts: 830

PostPosted: Sun Aug 04, 2013 20:17    Post subject: Reply with quote

ok - got it

Think I realised that Linux requires a lot of things to be in lower case.
So I changed the user to be lowercase and it suddenly worked.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group