Help. Mysql Database.

[kinshibuya]

Hi. I'm using sugar CE 5.2e, and i installed sugar's DB in another machine, both on ubuntu.
So i have one server (10.69.120.1) wich is my mysql DB, and i have other server 10.69.120.2 wich has the sugarcrm and apache.

On server 10.69.120.1 (mysql db) i added the user:

create user apps@'10.69.120.2' identified by '***'

GRANT ALL PRIVILEGES ON *.* TO 'apps'@'10.69.120.2'

On server 10.69.120.2 i changed the config.php:

  'dbconfig' =>
  array (
    'db_host_name' => '10.69.120.1',
    'db_host_instance' => 'SQLEXPRESS',
    'db_user_name' => 'apps',
    'db_password' => '*****',
    'db_name' => 'sugarcrm',
    'db_type' => 'mysql',
  ),
  'dbconfigoption' =>
  array (
    'persistent' => true,
    'autofree' => false,
    'debug' => 1,
    'seqname_format' => '%s_seq',
    'portability' => 0,
    'ssl' => false,
  ),

When i try to conect: http://10.69.120.2 i get the following error:

Could not connect to server 10.69.120.1 as apps.Lost connection to MySQL server at 'reading initial communication packet', system error: 111

To check the user permissions i called mysql command line:
mysql -h 10.69.120.1 -u apps -p sugarcrm --port=3360
and this works on the cmd but not on sugar. What can i do?

[andopes]

Have a look here.

Regards

[kinshibuya]

Hi.
I changed mysql to standard port 3306 and it's working just fine.
But i still doesn't know how to make sugar connect to a non standard port thow.
I found some threads on how to do this, but they are all for 4.5 or 5.0 versions, anyone knows how to do this on 5.2? Also, i m working with a faststack linux instalation could this be the problem?

[andopes]

Hopefully these links can help you:
Link 1
Link 2

Regards