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 
 
First Installation of MySQL

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
juliam



Joined: 09 Aug 2008
Posts: 16
Location: Québec Canada

PostPosted: Sat Jul 25, 2009 21:33    Post subject: First Installation of MySQL Reply with quote

First Installation of MySQL

window xp sp2
i got nwnx4 1.09
i go mysql-5.1.36-win32
xp_mysql.ini: server = localhost, user = administrateur, password = , schema = nwnx
nwn2.ini: database=c:\mysql\data, nwnx.ini =-module nwnx_demo_mysql
mysql.cnf in c:\mysql\data (from my-medium.ini): password commented,

for xp_mysql.ini: server = localhost, user = administrateur, password = none, schema = nwnx
or xp_mysql.ini: server = localhost, user = nwn, password = nwn, schema = nwnx
or xp_mysql.ini: server = localhost, user = nwn2, password = nwn2, schema = nwnx4
or xp_mysql.ini: server = oldbox, user = nwn, password = nwn, schema = nwnx

i get this in xp_mysql.txt: Connecting to server localhost, Connection to MySQL server failed: Access denied for user ''@'localhost' to database "nwnx'
or this in xp_mysql.txt: Connecting to server oldbox, Connection to MySQL server failed: Host '192.168.0.193' is not allowed to connect to this MySQL server

Obviously, i need to set a user, perhaps a password and a schema...
Shouldnt i start a service? Shouldnt run an exe file?
it's so obvious when we know but so stupid when we dont Sad
it would be faster if you help me please, did i forget some files?

What i am doing:
i dont know database, first time i check this, after few hours reading, i finally google and download 5.1.36
xp_mysql.dll and demo and runtime vcredist_86.exe, i already had...
i install this on a test server to run it and understand the settings

What i want do:
i want set MySQL on the network and connect the servers to it
i would share that MySQL folder and map a logical drive to access it
and each box would have database=<logical drive>: in nwn2.ini file
i have few boxes and many virtual servers of nwn2
they would all share the same database... classical i bet Smile

to ease the installation of MySQL and a step by step for anyone, someone could stick this and remove unuseful information
i learn alot reading all those posts but after 5 hours, i get tired hehe

....
hahaha Rolling Eyes
i'm reading the docs...
it's so complicated Shocked
Back to top
View user's profile Send private message
juliam



Joined: 09 Aug 2008
Posts: 16
Location: Québec Canada

PostPosted: Sun Jul 26, 2009 0:43    Post subject: Reply with quote

(built using mysql-5.0.27 source)

* Log level set to 1 (only errors)
* Connecting to server 'localhost'
* Plugin initialized.
* Registering under function class SQLoff

i put away the first download of MySQL 5.1.36
and i downloaded the one with the installation wizard
then i logged with MySQL administrator
i created a shema and an empty table with one column
shema = nwnx, table = nwn, column = number int(10)
i created a user = nwn password = nwn
hehe

i obviously miss that table in the mysqldemo.mod
but the module on the server connected to something hahaha

then, i logged on that server from the lan
and the guy (mmm.. sorry, i dont remember the name of that vilain hehe)
and the guy says that there's a problem... hahaha

now.. should i modify that demo mod to create column etc...?
i bet that i miss something... i assumed that the test in module loading
would create something...
Back to top
View user's profile Send private message
juliam



Joined: 09 Aug 2008
Posts: 16
Location: Québec Canada

PostPosted: Sun Jul 26, 2009 1:05    Post subject: Reply with quote

hahaha
the class was SQLoff, i changed it to SQL
now it works

i opened the toolset to check the test in your module.mod, so i saw that you use SQL as class,
i wonder why xp_mysql.ini had SQLoff instead of SQL?

alright, now i will test many users on the same table...
i just hope that the nezt starter like me doesnt have to go through
all those difficulties
Back to top
View user's profile Send private message
juliam



Joined: 09 Aug 2008
Posts: 16
Location: Québec Canada

PostPosted: Mon Jul 27, 2009 21:54    Post subject: Reply with quote

this is great Very Happy
i love that toy
thanks Papillon Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related 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