1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

My RunUO

Discussion in 'ServUO Discussion' started by Phred, Feb 16, 2014.

  1. Phred
    Offline

    Phred Member

    Joined:
    Jan 13, 2014
    Messages:
    64
    Likes Received:
    4
    Hi all,

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

    Ce Jayce Member

    Joined:
    Jan 24, 2014
    Messages:
    140
    Likes Received:
    14
    • Like Like x 1
  3. Phred
    Offline

    Phred Member

    Joined:
    Jan 13, 2014
    Messages:
    64
    Likes Received:
    4
    Well, I guess it isn't newbie proof enough.. I am getting stuck on the values to use for the database driver.

    Code (C#):
    1.  
    2. System.Data.Odbc.OdbcException: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified
    3.   at System.Data.Odbc.OdbcConnection.Open () [0x00000] in <filename unknown>:0
    4. MyRunUO: Database statements compiled in 0.44 seconds
    5.  
    Here is the string I am working with

    Code (C#):
    1.  
    2. // Details required for database connection string
    3.   public const string DatabaseDriver  = "MYSQL";
    4.   public const string DatabaseServer  = "localhost";
    5.   public const string DatabaseName  = "myrunuo";
    6.   public const string DatabaseUserID  = "root";
    7.   public const string DatabasePassword  = "ILOVEMYJOB";
    8.  
     
  4. Ce Jayce
    Offline

    Ce Jayce Member

    Joined:
    Jan 24, 2014
    Messages:
    140
    Likes Received:
    14
    Hey, you need to set the DatabaseDriver to the one you have installed so for examle;
    Code (C#):
    1.         public const string DatabaseDriver = "{MySQL ODBC 5.1 Driver}";
    hope that helps! :)
     
  5. Phred
    Offline

    Phred Member

    Joined:
    Jan 13, 2014
    Messages:
    64
    Likes Received:
    4
    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}";
     
  6. Ce Jayce
    Offline

    Ce Jayce Member

    Joined:
    Jan 24, 2014
    Messages:
    140
    Likes Received:
    14
    Hmmm..
    not sure what to suggest next really,..
    You've got the ODBC connector installed & MySQL workbench/equivalent installed?
     
  7. Phred
    Offline

    Phred Member

    Joined:
    Jan 13, 2014
    Messages:
    64
    Likes Received:
    4
    Installed Workbench and it *seems* to be working - how can I verify?
     
  8. Ce Jayce
    Offline

    Ce Jayce Member

    Joined:
    Jan 24, 2014
    Messages:
    140
    Likes Received:
    14
    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.
     
  9. karolbelski
    Offline

    karolbelski New Member

    Joined:
    Jan 27, 2015
    Messages:
    11
    Likes Received:
    1
    And you fins solution for that ? i got the same problem. I install unixODBC

    Code (C#):
    1. System.Data.Odbc.OdbcException: ERROR [IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified
    2.   at System.Data.Odbc.OdbcConnection.Open () [0x00000] in <filename unknown>:0
    3.  
     
Similar Threads: RunUO
Forum Title Date
Archived Bug Reports A Crystal Ball - Why are these still spawning in dungeon chests - They were a RunUO custom Jun 19, 2017
Script Support MyRunUO Database problem May 31, 2017
General Discussion I'm looking to switch from runuo to Servuo May 15, 2017
New Join Forum Diffrence between servuo and runuo Mar 28, 2017
The Back Room Someone killed www.runuo.net Feb 28, 2017
Script Support RunUO 2.0 final repack, conversion RunUO 2.1? Feb 7, 2017
General Discussion Issues with old runuo 2.0 rc1 Feb 7, 2017