MyRunUO not logging to MySQL

[Caoboth]

Hi all

Ok ive spent abt 2 hours repeating the same tasks over and over again so ive posted for some enlightenment.

Ive got Mysql 4.1 running with latest RunUO (which is workign perfectly) however ive configured myRunOU to the relevant mysql database ive created (alot with said tables) however nothign being logged into it.

Ive intalled the ODBC client , ive got .net v1.1 installed and the .net odbc addon bit (im running on a win2003 enterprise server here)

Ive set Mysql to use the old style autehntication (i did this when i confiured phpbb2) so i know the mysql install is good.

When i run runuo is shows that its updating the database (i.e status database updateing in 0.1 seconds etc) however when i sql query the database i get nothing. (grrr)

The myrunou cs file is standard but ive put it below in case ir help.

// Is MyRunUO enabled?
public static bool Enabled = true;

// Details required for database connection string
public static string DatabaseDriver = "{MySQL ODBC 3.51 Driver}";
public static string DatabaseServer = "localhost";
public static string DatabaseName = "MyRunUO";
public static string DatabaseUserID = "root";
public static string DatabasePassword = "XXXXXXX";


Also just on off chance i tried somethign i found on the forum and changed the follwoign to flase to test (didnt work) so set it back to true

// Use optimized table loading techniques? (LOAD DATA INFILE)
public static bool LoadDataInFile = true;

Any help greatly appreciated.

Cao

[Phantom]

What backend are you using, MyRunUO clearly won't work without one, and depending on which one you use the database might need to be updated.

[Caoboth]

The backend is IIS.

Ive been using the myrunuo supplied with the latest version of runuo. As an alternative i also downloaded myrunuo v1 and also tried that one. (must admit this is a cracking one its got me well puzzled)


cao

[Phantom]

Originally Posted by Caoboth

The backend is IIS.

Ive been using the myrunuo supplied with the latest version of runuo. As an alternative i also downloaded myrunuo v1 and also tried that one. (must admit this is a cracking one its got me well puzzled)


cao

So your uisng the APS code, which is the original code, instead of the php port.

Without more information I couldn't help you, can you test custom code, to see if you can do your own query?

[Caoboth]

Im not even looking at the php or asp at the moment, ive been using navicat (graphical mysql browser) to examine the database and there are 0 entries.

[Phantom]

Originally Posted by Caoboth

Im not even looking at the php or asp at the moment, ive been using navicat (graphical mysql browser) to examine the database and there are 0 entries.

Do what I suggested, do your own query, it might not be the code.

If its not the code, then its nothing we can do to help you.

[Axle]

public static bool LoadDataInFile = true;

set this to false and see what happens.

[Caoboth]

Well ive queried the database manually and 0 entries.

Axel ive already tried that one (but cheers for help though bud)

On searches ive seen a couple of people with same issue howeer never seen a resolution.

Cao