MySql on DMZ
Web Server Setup:
-- Windows 2000 Server
-- IIS
-- PHP
-- MySql
-- MySQL ODBC 3.51 driver
Network Setup:
-- RunUO server on LAN side of Firewall
-- Web Server on DMZ side
-- All ports from the LAN to DMZ are open
Files edited:
Config.cs
-- public static bool Enabled = true;
-- public static string DatabaseDriver = "{MySQL ODBC 3.51 Driver}";
-- public static string DatabaseServer = "###.###.###.###"; //DMZ Address of server
-- public static string DatabaseName = "MyRunUO";
-- public static string DatabaseUserID = "root";
-- public static string DatabasePassword = "********"; //root password
myrunuo.inc.php
-- $SQLhost = "localhost";
-- $SQLport = "3306";
-- $SQLuser = "root";
-- $SQLpass = "********";
-- $SQLdb = "myrunuo";
Everything compiles fine but RunUO cannt connect to mysql:
MyRunUO: Updating Status Database
MyRunUO: Unable to connect to the database
System.Data.Odbc.OdbcException: Error [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
at System.Data.Odbc.OdbcConnection.Open()
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
-- Edit 1 --
Installd MySQL ODBC Driver on Shard Server, now the error reported is:
MyRunUO: Updating Status Database
MyRunUO: Unable to connect to the database
System.Data.Odbc.OdbcException: Error [HY000] [MySQL][ODBC 3.51 Driver] Access denied for user 'root@
Stuff' (Using password: YES)
ERROR [HY000] [MySQL][ODBC 3.51 Driver] Access denied for user 'root@
Stuff' (Using password: YES)
at System.Data.Odbc.OdbcConnection.Open()
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
root@% has All Global Privlidges
-- Edit 2 --
Solved above issue by adding an IP address specific user into MySQL (although I would thing root@% sould have worked)
[UpdateMyRunUO now completes successfully and the tables are populated.
New error when [UpdateWebStatus is run:
MyRunUO: Updating Status Database
MyRunUO: Excption caught in database thread
System.Data.Odbc.OdbcException: ERROR[HY000] [MySQL][ODBC 3.51 Driver] [mysqld-4.0.18-nt]Column count doesn't match value count at row 1
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hTyte, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject (CommandBehavior behavior, String method)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
MyRunUO: Status database updated in 0.0 Seconds
-- Edit 3 --
Solved above issue by replacing the following line in MyRunUOStatus.cs
Code:
m_Command.Enqueue( String.Format( "INSERT INTO myrunuo_status VALUES ({0})", mob.Serial.Value.ToString() ) );
with
Code:
m_Command.Enqueue( String.Format( "INSERT INTO myrunuo_status (char_id, char_location, char_map, char_Karma, char_fame) VALUES ({0},'{1},{2},{3}','{4}',{5},{6})", mob.Serial.Value.ToString(), mob.X.ToString(),mob.Y.ToString(),mob.Z.ToString(), mob.Map, mob.Karma, mob.Fame ));
-- Edit 4 --
My last issue is the ever popular Red X.
Where would uofiles and ultima.dll need to be placed for a phpbb install.
I have tried several different locations with no success. Here is my current directory structure.
-- Domain Home Directory c:\Inetpub\wwwroot\phpBB2
-- MyRunUO Home Directory: c:\Inetpub\wwwroot\phpBB2\myrunuo
When trying to go directly to the paperdoll.php as suggested by Panther i get the following error: (
http://domain.com/myrunuo/paperdoll.php?id=555)
-- Fatal error: Call to undefined function: imagecreatefrompng() in C:\Inetpub\wwwroot\phpBB2\myrunuo\paperdoll.php on line 396