Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: How to install SugarCRM 5.0 on MySQL with non-standard port?

  1. #11
    bbergmann is offline Member
    Join Date
    Apr 2008
    Posts
    8

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    Quote Originally Posted by julian
    A similar fix for mysqli can be made in ./include/database/MysqliManager.php if you need to.
    In the MysqliManager you have to change the given lines to something like that:

    PHP Code:
    $this->database=@mysqli_connect($configOptions['db_host_name'],$configOptions['db_user_name'],$configOptions['db_password'],$configOptions['db_name'],$configOptions['db_port']); 
    (have a look at http://php.net/manual/en/mysqli.connect.php)

    That should work.

    but thank you very much for your reply.

  2. #12
    AlpinWay is offline Junior Member
    Join Date
    Aug 2008
    Posts
    2

    Unhappy Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    Hi, is anyone has fixed that problem yet?

    I've try to install SugarCRM 5.1.0 on MySQL with non-standard port 3305 and I've got error in installer:

    The provided database username and/or password is invalid, and a connection to the database could not be established. Please enter a valid user name and password. 2005: Unknown MySQL server host 'sql.some_name.some_name.pl:3305'

    I know that there is work around for this problem, but it solve only a connection to an exist database with allredy installed SugarCRM. In this case I don't have any created databases and any installed versions of SugarCRM. What I need to do is install SugarCRM 5.1.0 from a beginning on clean system without possibility to do it on standard port 3306. All my applications are stored on remote servers so I haven't access to configuration files of PHP and MySQL.

    Can anyone help me with that ?
    Best regards.

  3. #13
    Szymik is offline Sugar Community Member
    Join Date
    Nov 2006
    Posts
    14

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    a have the same problem

    Help!

  4. #14
    kcore is offline Junior Member
    Join Date
    Dec 2008
    Posts
    1

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    Today i stumbled upon the same missing feature.

    You can fix it the following way:

    1. Open install/checkDBSettings.php
    2. Add the following function before or after the checkDBSettings function:

    PHP Code:
    function &getMysqliHandle() {
        if(
    strpos($_SESSION['setup_db_host_name'], ':')) {
            
    $hostData explode(':'$_SESSION['setup_db_host_name']);
            
    $mysql_hostname = &$hostData[0];
            
    $mysql_port = &$hostData[1];
        } else {
            
    $mysql_hostname = &$_SESSION['setup_db_host_name'];
            
    $mysql_port 3306// use the default port if none is specified
        
    }
        
    $link = @mysqli_connect(
                                    
    $mysql_hostname,
                                    
    $_SESSION['setup_db_sugarsales_user'],
                                    
    $_SESSION['setup_db_sugarsales_password'],
                                    
    $_SESSION['setup_db_database_name'],
                                    
    $mysql_port
                                
    );
        return 
    $link;

    3. Search for occurencies of the following function call:
    PHP Code:
                    $link = @mysqli_connect$_SESSION['setup_db_host_name'],
                                            
    $_SESSION['setup_db_sugarsales_user'],
                                            
    $_SESSION['setup_db_sugarsales_password'] ); 
    4. Replace it with the following function call:
    PHP Code:
    $link getMysqliHandle(); 
    5. Have fun

    Regards,
    Thorsten Boock

  5. #15
    bbergmann is offline Member
    Join Date
    Apr 2008
    Posts
    8

    Thumbs up Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    this really helped!
    Tested with actual Version 5.1.0b.

  6. #16
    vantagejuan is offline Sugar Community Member
    Join Date
    Dec 2007
    Posts
    70

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    I tried this for an attempted fresh installation where I don't have php access and did not have success. is there some sort of customization beyond this that i'm missing. i no longer got the "socket (2)" message, but my installation freezes at:

    "Creating Sugar configuration file (config.php)

    Creating Sugar application tables, audit tables and relationship metadata
    ........................................"

    any help?

  7. #17
    beuvema is offline Member
    Join Date
    Jan 2009
    Posts
    9

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    Being new to the Sugar matter I am curious about what you are trying to achieve.

    Scrolling through this thread it seems that you have trouble accessing the database for some reason.
    I tried SugarCRM several years ago and had a similar problem, I was not able to do an initial installation because I could not acces the MySQL database through the SugarCRM installation process.

    In the previous version I found, a workaround (in a first time installation) was filling the database manually.
    In the older sugar version I was able to find the file containing the MySQL commands to create tha tables within the database.

    For the latest version I am trying to figure out from which file SugarCRM creates the MySQL databade during the installation.

    Anyone whith a clue?

    For your question:
    Re: How to install SugarCRM 5.0 on MySQL with non-standard port?
    Might your hosting company prohibit the way SugarCRM accesses the database in some way?
    So the problem might not be a port issue, but a hosting setting issue?

    I found a solution to my installation problem by using 127.0.0.1 in stead of localhost for the server that the database is located on.

    Regards,
    Beuvema
    Last edited by beuvema; 2009-01-09 at 09:27 AM.

  8. #18
    Johnnaris is offline Junior Member
    Join Date
    Jun 2009
    Posts
    1

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?

    simulation credit

    Thanks for sharing. It's great.

  9. #19
    stephsalvador is offline Junior Member
    Join Date
    Jun 2009
    Posts
    1

    Default Re: How to install SugarCRM 5.0 on MySQL with non-standard port?


    this is what i was looking for. thanks!

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting blank page
    By rept in forum Installation and Upgrade Help
    Replies: 0
    Last Post: 2008-05-29, 06:50 PM
  2. Awnsers Re: How to both Install and Uninstall SugarCRM
    By chrisky in forum Installation and Upgrade Help
    Replies: 3
    Last Post: 2007-08-06, 02:35 AM
  3. Quick Create not working in Contacts popup
    By pniranjan in forum Developer Help
    Replies: 1
    Last Post: 2007-04-26, 02:10 PM
  4. Replies: 2
    Last Post: 2004-12-16, 02:16 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •