Sugar 401 install and remote MySQL database

[cosjef]

I cannot figure out how to point the installer to a remote MySQL server. At Step 3, Database Configuration, I enter the hostname of the remote MySQL server in fully-qualified format. I have installed the MySQL client on the Sugar server, and can successfully connect over TCP/IP with this command: mysqladmin version -h <servernam> --port=3306 version -u root

I build PHP with support for MySQL (./configure --prefix=/usr/local/php5 --with-apxs2=/d01/httpd/bin/apxs --with-curl=/usr/ --with-mysql=/usr/)

When I get to Step 6 of the installer, I get this message:

Creating the config file...done

Installation is proceeding... the output will appear below once it is complete. Please wait.
Creating the database sugarcrm on usatl01la207.amer.lendlease.com...done
Creating the db username and password...Creating the db username and password for localhost...done

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /d01/httpd/htdocs/sugarcrm401/include/database/PearDatabase.php on line 632
Unable to select database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


The installer successfully creates the database on the remote MySQL server (I checked), but it then bombs out trying to connect through a local MySQL socket which doesn't exist (because there is no MySQL server installed locally).

What is the workaround for this? How can I get the installer to point at the remote MySQL server?

Jeff

[kpit]

You might want to see if MySQL is configured to talk on external network and not just configured for local host.

Look for bind-address in my.cnf file on your database server. This may tell you what IP address mysql is listening. If it is 127.0.0.1 only the localhost can see MySQL. Set this to an external IP addreess that the other system can see.

Example:

bind-address 192.168.0.249

Replace IP address with your address for the database server. You might also want to check any firewall or filter rules you may have in play.

Cheers,

Max

[kbrill]

Your PHP and mysql must be set upright if the database is being created... I would edit your /include/database/PearDatabase.php and either comment out the mysql_close command around line #628 (Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution).

Or you can try just removing the $this->database from the mysql_close command and that might work too.

Let me know if this works or if you need more help.

[badai]

I face similar problem with it also, please take a look at my error messages :

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /var/www/html/FOCUREM/include/database/PearDatabase.php on line 632
Unable to select database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

It's install at linux, php441, mysql3.23.49, apache 2.0.53 (unix)

please help

thanks.
Badai

[badai]

I've tried to remove the line, can skip the process, but the problem look like still same. pls find following error message :

Creating the table relationships...Unable to select database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Thanks,
Badai

[stevec]

Hi,

I've got as 4.0.1 system running with a remote mysql server. no problems with the install. - though I started with a 4.0.0 and upgradeded.

Can you post the contents of your my.cnf file on the db server and your php.ini and sugar's config.php files? (Hiding any sensitinve passwords, IP addresses etc)?