Help getting MySQL stuff running

[Leigt]

>>mysql -u root -p

gave me

>>password:

I entered my password there and got the mysql> prompt

>>use mysql

gave database changed, like you said it should.

>>SELECT User, Host, Password FROM users;

gave Table 'mysql.users' doesn't exist

>>SELECT Db, User, Host, Select_priv FROM db;

gave:

+-------+----------+------+-------------+
| Db | User | Host | Select_priv |
+-------+-----------+------+-------------+
| test | nwserver| % | N |
| mysql | nwserver| % | N |
| nwn | nwserver| % | Y |
+-------+-----------+------+-------------+
3 rows in set (0.01 sec)

>>use nwn

gave Unknown database 'nwn'

I'm confused. It lists 'nwn' under "Db".

And I did install an ODBC driver... I think. The file name is MyODBC-3.51.10-2-win.exe It didn't make any tests when I installed.

Oh, and I found a new file called nwnx_odbc.txt in my logs.0 folder IT has the following lines repeated over and over:

o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using ODBC connection.
o Hooking SCO....hooked at 5c4320
o Hooking RCO....hooked at 5c4200
! Error while connecting to database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Got request: SELECT identifier FROM player_tracking WHERE playername='Leigt' AND charname='Leigt Niac'
! SQL Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
o Got request: INSERT INTO player_tracking(playername, charname, pc_dm,level_1,level_2,level_3,class_1,class_2,class_3,experience,gender,public_cdkey,ip_address,subrace,deity,last_seen) VALUES('Leigt','Leigt Niac','0','3','3','0','Ranger','Dragon','Invalid','20783','M','FTRMTTJ4','192.168.2.100','Silver Half-Dragon','Selune',now())
! SQL Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
...

[NoMercy]

I rarely go anywhere near the controll database inside MySQL, so I can't see why you should have to worry aobut it. To create users you don't even need to touch it, to first find out what databases exist use:

[Leigt]

Boy do I feel sheepish. Realized my biggest problem was forgetting to put the semicolon at the end of each command. Anyway, everything is working nicely now. Thanks all!

[Leigt]

I wonder if you can put up with me for a little longer. Almost to my goal. The website now doesn't want to load the server status page. It just sits there trying to load. I'm using the following php file with the listed settings... well, now that I'm looking at it I notice it's written by you guys.

serverstatus.php

// Specify ip address or name of NWN server
// If behind a router with the server, fill this with the internal IP of the game server.
// otherwise give the normal ip used by players for direct connect.
$ipaddr = '83.130.93.8';
//direct connect ip for displaying.
$directconnip = '83.130.93.8'; // Example: The World Of Talus
// Specify port of server (5121 is default)
$port = '5121';
// Specify timeout (maximum time to wait for connection and data)
$timeout = 1; // changed to 1 seconds;

//mysql port. 3306 is default.
$mysqlport = '5212';
//mysql server ip address. default for local instance is 'localhost'
$mysqlipaddr = '83.130.93.8';
//mysql username.
$mysqluser = 'nwserver';
//mysql password. seriously folks, you better have a firewall in place.
$mysqlpass = 'nwpass';
//mysql database name.
$mysqldb='nwn';
//default server name used if offline.
$servername = "Isles of the Red Phoenix";
//default module name used if offline.
$modulename = "Red Phoenix";
//set this to 0 if you don't want all the extra junk displayed.
$printjunk=0;

And, yes, I changed the port in use by MySQL to 5212. At least, I did using the administrator. I also set up a Virtual Server port forwarder through my router for 5212 only; exact same setup I have for the module.

Thanks!

[NoMercy]

Couln't possibly say, that problem looks a bit specific to your setup, others might have some ideas.

[Lokey]

The GRANT command adds lines to those control databases...if you add by hand you just need to call FLUSH PRIVILEGES; to get your changes to work immediately (reloads the permissions for the active server).

Error files with NWNx: MySQL server running when you tried (just checking)? I'd guess it's your ODBC setup offhand if you're not using ODBC2 (Admin Tools/ODBC Data Sources)...which it sounds like you may not have done. Click that, add new data source (user, system or file depending on your setup) select MySQL ODBC 3.51morenumbers and fill in the options (Resource name, user name, pass, db, port). Then click that test datasource button (with your flavor MySQL server running).

MySQL runs on 3306 by default, you need to specify the port to run the server on when you start it, i.e. mysqlnt --port 5212. Then you may need to add port numbers to the current users, i.e. nwnx@localhost:5212 or root@localhost:5212. I don't know if % means any port, but it may...RTFM and all that. Then create a user account for your webserver account@ip:5212. Uncharted territory for me, never had cause to use a port besides the default.
_________________
Neversummer PW NWNx powered mayhem

[Leigt]

Okay, I didn't really understand that first paragraph about GRANT and FLUSH.

The second paragraph I did for User and System just now with no change. When I clicked Test each time I got a success message, so I guess that part is working. Log files for NWNX are showing no problems, too.

The third, I set up port 5212 using the Administrator but it may not have actually done anything. I don't know how to add ports via the command prompt. Anywhere I can get a list of prompt commands for MySQL? I tried using \h but I just got confused.

All of this just to display on a website how many players are in the module.

[NoMercy]

If you want to just count how many players there are there are php scripts which will query servers using UDP sockets, the database route does give a lot more flexibility.

Something I use on my webserver is:

[Leigt]

Okay, well, I finally figured out two things. First, the port is still 3306, so any changes I make in Administrator don't actually happen. But I can't figure out how to change the port setting and when I do to keep it permanent.

Second, information gets written to the table and it doesn't overwrite old info so I have multiple copies of the same records.

[Leigt]

The database is working fine now. It's just getting the webserver to log in and retrieve it for display that's the problem.

Oh, and I found the initialization file for MySQL. I changed the Client port from 3306 to 5212. Server port was already 5212. But now I can't use mysql -u... so on to log in. I get an error. :/

Ack! And after changing it back to 3306 I still can't get in.

EDIT: Okay, well everything's back to before. Changed things around so I'm now using the default port but no luck. I've figured out enough that I fixed the repeating entries thing for the table. Strange since I'm pretty sure I followed the directions for installing that setup correctly. Anyway, I can only assume from here on out that the problem resides in the php file. Thanks for all the help.

[window229]