My RunUO

[Phred]

Hi all,

Does ServUO use the My RunUO ? If so, is there a recent walk through on how to set this up on MySQL?

 

[Ce Jayce]

Hi there!
You can enable MyRunUO on ServUO however I ran into multiple problems with getting it to work properly and couldn't find any 'recent' tutorial on setting it up.

This is from 2004:
http://www.runuo.com/community/threads/newbie-proof-walk-through.27380/
if you run into a paper doll issue this one might help;
http://www.runuo.com/community/threads/need-help-displaying-paperdoll-image-in-myrunuo-php.532965/
If i find any of the other links I was looking for i'll post them here too!

 

[Phred]

Well, I guess it isn't newbie proof enough.. I am getting stuck on the values to use for the database driver.

System.Data.Odbc.OdbcException: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified
  at System.Data.Odbc.OdbcConnection.Open () [0x00000] in <filename unknown>:0
MyRunUO: Database statements compiled in 0.44 seconds

Here is the string I am working with

// Details required for database connection string
  public const string DatabaseDriver  = "MYSQL";
  public const string DatabaseServer  = "localhost";
  public const string DatabaseName  = "myrunuo";
  public const string DatabaseUserID  = "root";
  public const string DatabasePassword  = "ILOVEMYJOB";

 

[Ce Jayce]

Hey, you need to set the DatabaseDriver to the one you have installed so for examle;

        public const string DatabaseDriver = "{MySQL ODBC 5.1 Driver}";

hope that helps!

 

[Phred]

No go... This is what I get with MySQL...

Your MySQL connection id is 238
Server version: 5.5.35-0ubuntu0.12.04.2 (Ubuntu)

This is what I have now in the string...
public const string DatabaseDriver = "{MySQL ODBC 5.5.35}";

 

[Ce Jayce]

Hmmm..
not sure what to suggest next really,..
You've got the ODBC connector installed & MySQL workbench/equivalent installed?

 

[Phred]

Installed Workbench and it *seems* to be working - how can I verify?

 

[Ce Jayce]

I guess the proper way to test it would be to get the php files upload them to your website and see what happens when you navigate to them
You could test it by firing sql commands at it but off the top of my head I don't know what they would have to be nor what you should expect to see back.

 

[karolbelski]

And you fins solution for that ? i got the same problem. I install unixODBC

System.Data.Odbc.OdbcException: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified
  at System.Data.Odbc.OdbcConnection.Open () [0x00000] in <filename unknown>:0