MuCore problem

Results 1 to 5 of 5
  1. #1
    Valued Member karipidis is offline
    MemberRank
    Feb 2012 Join Date
    121Posts

    MuCore problem

    Recently i hired a vps and i want to host my Mu Online website to the vps. i have moved everything from mucore to the vps but still i'm getting Connection with SQL Server #1 could not be established. . The config.php is like that :

    Code:
    <?
    /*------------------------------------------*\
    | Server Databases:                          |
    |                                            |
    |  0 : MuOnline [database]                   |
    |  1 : MuOnline and Me_Muonline [databases]  |
    \*------------------------------------------*/
    /**
    * @+===========================================================================+
    * @¦ MuCore 1.0.8 English.       					       ¦
    * @¦ Credits: Isumeru & MaryJo  					       ¦
    * @¦ +=======================================================================+ ¦
    * @¦ ¦  "He who Copy/Pastes Shall Inherit My Mistakes But Not My Knowledge"  ¦ ¦
    * @¦ +=======================================================================+ ¦
    * @¦ Official Site:   http://bizarre-networks.com                              ¦
    * @+===========================================================================+
    * @¦ Our Allied Site: http://chileplanet.org                                   ¦
    * @+===========================================================================+
    */
    
    $core['server_use_2_db'] = "0"; 
    
    ##############################################
    
    
    
    
    /*-------------------------------------*\
    | MUCore SQL Connection Type:           |
    |                                       |
    |  MSSQL : Connect using mssql_conect() |
    |  ODBC : Connect using odbc            |
    \*-------------------------------------*/
    
    $core['connection_type'] = "ODBC";
    
    #########################################
    
    
    
    
    /*--------------------------------------------------*\
    | MuOnline Database Connection Settings              |
    |                                                    |
    | $core['db_host'] : Database host address           |
    | $core['db_name'] : Database name                   |
    | $core['db_use'] : SQL Authentication user          |
    | $core['db_password'] : SQL Authentication password |
    \*--------------------------------------------------*/
    
    $core['db_host'] = "78.46.***.***";
           
    $core['db_name'] = "MuOnline";    
         
    $core['db_user']= "sa";
    
    $core['db_password'] = "******";
    
    ######################################################
    
    
    
    
    /*------------------------------------------------------------------*\
    | NOTE:                                                              |
    | Edit this only if $core['server_use_2_db'] value is set to 1,      |
    | this mean your server use MuOnline and Me_MuOnline databases.      |
    |                                                                    |
    | Me_MuOnline Database Connection Settings                           |
    |                                                                    |
    | $core['db_host2'] : Database host address                          |
    | $core['db_name2'] : Database name                                  |
    | $core['db_use2'] : SQL Authentication user                         |
    | $core['db_password2'] : SQL Authentication password                |
    \*------------------------------------------------------------------*/
    
    $core['db_host2'] = "127.0.0.1";
           
    $core['db_name2'] = "MuOnline";    
         
    $core['db_user2']= "sa";
    
    $core['db_password2'] = "SQL-Pass";
    
    ######################################################################
    
    
    
    
    /*-------------------------------------------------*\
    | MUCore Admin Control Panel:                       |
    |                                                   |
    |  $core['admin_username'] : Administrator user     |
    |  $core['admin_password'] : Administrator password |
    \*-------------------------------------------------*/
    
    $core['admin_username'] = '****';
    
    $core['admin_password'] = '******';
    
    #####################################################
    
    
    
    
    /*-----------------------------------------------------*\
    | MUCore's MUCoins SQL Table Settings:                  |
    |                                                       |
    |  MU_COINS_TABLE : MUCoins table name                  |
    |  MU_COINS_COLUMN : MUCoins (Credits) column name      |
    |  MU_COINS_USERID_COLUMN : MUCoins User ID column name |
    \*-----------------------------------------------------*/
    
    define('MU_COINS_TABLE','memb_credits');
    
    define('MU_COINS_COLUMN','credits');
    
    define('MU_COINS_USERID_COLUMN','memb___id');
    
    define('MU_SCOINS_TABLE','memb_scredits');
    
    define('MU_SCOINS_COLUMN','scredits');
    
    define('MU_SCOINS_USERID_COLUMN','memb___sid');
    
    #########################################################
    
    
    
    
    /*--------------------------------------*\
    | MUCore Debug Settings:                 |
    |                                        |
    |  1 : Debug enabled                     |
    |  0 : Debug disabled                    |
    |                                        |
    | Note: Enable debug only if necessary.  |
    \*--------------------------------------*/
    
    $core['debug'] = 0;
    
    ##########################################
    /**
    * @+===========================================================================+
    * @¦ MuCore 1.0.8 English.       					       ¦
    * @¦ Credits: Isumeru & MaryJo  					       ¦
    * @¦ +=======================================================================+ ¦
    * @¦ ¦  "He who Copy/Pastes Shall Inherit My Mistakes But Not My Knowledge"  ¦ ¦
    * @¦ +=======================================================================+ ¦
    * @¦ Official Site:   http://bizarre-networks.com                              ¦
    * @+===========================================================================+
    * @¦ Our Allied Site: http://chileplanet.org                                   ¦
    * @+===========================================================================+
    */
    ?>
    how can i fix it? please help me


  2. #2
    Proficient Member R3jectZ is offline
    MemberRank
    Jun 2011 Join Date
    PhilippinesLocation
    198Posts

    Re: MuCore problem

    Quote Originally Posted by karipidis View Post
    Recently i hired a vps and i want to host my Mu Online website to the vps. i have moved everything from mucore to the vps but still i'm getting Connection with SQL Server #1 could not be established. . The config.php is like that :

    Code:
    <?
    /*------------------------------------------*\
    | Server Databases:                          |
    |                                            |
    |  0 : MuOnline [database]                   |
    |  1 : MuOnline and Me_Muonline [databases]  |
    \*------------------------------------------*/
    /**
    * @+===========================================================================+
    * @¦ MuCore 1.0.8 English.       					       ¦
    * @¦ Credits: Isumeru & MaryJo  					       ¦
    * @¦ +=======================================================================+ ¦
    * @¦ ¦  "He who Copy/Pastes Shall Inherit My Mistakes But Not My Knowledge"  ¦ ¦
    * @¦ +=======================================================================+ ¦
    * @¦ Official Site:   http://bizarre-networks.com                              ¦
    * @+===========================================================================+
    * @¦ Our Allied Site: http://chileplanet.org                                   ¦
    * @+===========================================================================+
    */
    
    $core['server_use_2_db'] = "0"; 
    
    ##############################################
    
    
    
    
    /*-------------------------------------*\
    | MUCore SQL Connection Type:           |
    |                                       |
    |  MSSQL : Connect using mssql_conect() |
    |  ODBC : Connect using odbc            |
    \*-------------------------------------*/
    
    $core['connection_type'] = "ODBC";
    
    #########################################
    
    
    
    
    /*--------------------------------------------------*\
    | MuOnline Database Connection Settings              |
    |                                                    |
    | $core['db_host'] : Database host address           |
    | $core['db_name'] : Database name                   |
    | $core['db_use'] : SQL Authentication user          |
    | $core['db_password'] : SQL Authentication password |
    \*--------------------------------------------------*/
    
    $core['db_host'] = "78.46.***.***";
           
    $core['db_name'] = "MuOnline";    
         
    $core['db_user']= "sa";
    
    $core['db_password'] = "******";
    
    ######################################################
    
    
    
    
    /*------------------------------------------------------------------*\
    | NOTE:                                                              |
    | Edit this only if $core['server_use_2_db'] value is set to 1,      |
    | this mean your server use MuOnline and Me_MuOnline databases.      |
    |                                                                    |
    | Me_MuOnline Database Connection Settings                           |
    |                                                                    |
    | $core['db_host2'] : Database host address                          |
    | $core['db_name2'] : Database name                                  |
    | $core['db_use2'] : SQL Authentication user                         |
    | $core['db_password2'] : SQL Authentication password                |
    \*------------------------------------------------------------------*/
    
    $core['db_host2'] = "127.0.0.1";
           
    $core['db_name2'] = "MuOnline";    
         
    $core['db_user2']= "sa";
    
    $core['db_password2'] = "SQL-Pass";
    
    ######################################################################
    
    
    
    
    /*-------------------------------------------------*\
    | MUCore Admin Control Panel:                       |
    |                                                   |
    |  $core['admin_username'] : Administrator user     |
    |  $core['admin_password'] : Administrator password |
    \*-------------------------------------------------*/
    
    $core['admin_username'] = '****';
    
    $core['admin_password'] = '******';
    
    #####################################################
    
    
    
    
    /*-----------------------------------------------------*\
    | MUCore's MUCoins SQL Table Settings:                  |
    |                                                       |
    |  MU_COINS_TABLE : MUCoins table name                  |
    |  MU_COINS_COLUMN : MUCoins (Credits) column name      |
    |  MU_COINS_USERID_COLUMN : MUCoins User ID column name |
    \*-----------------------------------------------------*/
    
    define('MU_COINS_TABLE','memb_credits');
    
    define('MU_COINS_COLUMN','credits');
    
    define('MU_COINS_USERID_COLUMN','memb___id');
    
    define('MU_SCOINS_TABLE','memb_scredits');
    
    define('MU_SCOINS_COLUMN','scredits');
    
    define('MU_SCOINS_USERID_COLUMN','memb___sid');
    
    #########################################################
    
    
    
    
    /*--------------------------------------*\
    | MUCore Debug Settings:                 |
    |                                        |
    |  1 : Debug enabled                     |
    |  0 : Debug disabled                    |
    |                                        |
    | Note: Enable debug only if necessary.  |
    \*--------------------------------------*/
    
    $core['debug'] = 0;
    
    ##########################################
    /**
    * @+===========================================================================+
    * @¦ MuCore 1.0.8 English.       					       ¦
    * @¦ Credits: Isumeru & MaryJo  					       ¦
    * @¦ +=======================================================================+ ¦
    * @¦ ¦  "He who Copy/Pastes Shall Inherit My Mistakes But Not My Knowledge"  ¦ ¦
    * @¦ +=======================================================================+ ¦
    * @¦ Official Site:   http://bizarre-networks.com                              ¦
    * @+===========================================================================+
    * @¦ Our Allied Site: http://chileplanet.org                                   ¦
    * @+===========================================================================+
    */
    ?>
    how can i fix it? please help me
    bro.. change the ip: "78.46.***.***"; to 127.0.0.1 ..

    GOOD LUCK AND HAVE FUN!

  3. #3
    Valued Member karipidis is offline
    MemberRank
    Feb 2012 Join Date
    121Posts

    Re: MuCore problem

    Quote Originally Posted by R3jectZ View Post
    bro.. change the ip: "78.46.***.***"; to 127.0.0.1 ..

    GOOD LUCK AND HAVE FUN!
    MuCore and Mu Online server are not on the same dedicated machine.. Thats why i have put the IP . I'm asking how to make MuCore listen to the Mu Online server that is in differend PC

  4. #4
    Don Corleone Cryingsoul is offline
    MemberRank
    Mar 2009 Join Date
    DenmarkLocation
    702Posts

    Re: MuCore problem

    Quote Originally Posted by karipidis View Post
    MuCore and Mu Online server are not on the same dedicated machine.. Thats why i have put the IP . I'm asking how to make MuCore listen to the Mu Online server that is in differend PC
    Step 1: Make sure that port 1433 is open in the server machine, the port is used for MSSQL remote connection.
    Step 2: At config.php change the db_host to 78.46.***.***:1433 and change from ODBC to MSSQL
    Step 3: ???
    Step 4: Profit
    Last edited by Cryingsoul; 23-12-12 at 01:21 PM.

  5. #5
    Enthusiast varcush is offline
    MemberRank
    Jun 2008 Join Date
    <?=$Romania;?>Location
    45Posts

    Re: MuCore problem

    try changin connection to mssql



Advertisement