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

[bbergmann]

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:

 $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.

[AlpinWay]

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.

[Szymik]

a have the same problem

Help!

[kcore]

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:

 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:

                 $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:

 $link = getMysqliHandle(); 
  

5. Have fun

Regards,
Thorsten Boock

[bbergmann]

this really helped!
Tested with actual Version 5.1.0b.

[vantagejuan]

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?

[beuvema]

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

[Johnnaris]

simulation credit

Thanks for sharing. It's great.

[stephsalvador]

simulation rachat de credit

this is what i was looking for. thanks!