installing sugar suite on existing system

[pdeschen]

Hello,

I m trying to install sugar suite (SugarSuite-Full-4.5.0d) on a existing linux server with the folling LAMP config

* CentOS release 4.3 (Final)
* httpd-2.0.52-22.ent.centos4
* mysql-4.1.20-1.RHEL4.1
* php-5.0.4-5.centos4

I have both mbstring/mysql php module installed (php-mbstring-5.0.4-5.centos4, php-mysql-5.0.4-5.centos4).

But I still can't get SugarSuite to install. I have the following message:

MySQL Database Not Available

MB Strings Module Not found: SugarCRM will not be able to process multi-byte characters. This will impact receiving emails in character sets other than UTF-8

Also, would it be possible to use an existing database on a remote server?

Thanks

[kpit]

is the mysql server running?

yes you can set it to use a remote database you just change the localhost to an IP address or domain name of the server you want to connect. You also have to have the mysql server accepting tcp connections. By default mysql does not listen to tcp for security reasons.

[pdeschen]

Mysql is obviously running and serving other databases on a distributed environment.

I d like to change this hostname but could not figure where. The config.php is empty (I guess because I could not terminate the install process...) I d like to bypass this wizard thing and configure the necessary manually...

Any clue?

Thanks for such a quick response.

[kpit]

Actually you specify it in the install wizard itself. It is much better to use the wizard to install as it does more than just set up the database.

I was refering to MySQL running on the local machine when I asked if it was running.

You need the MySQL client libraries installed on the local machine in order to connect to MySQL remotely. If they are not installed sugar can not find MySQL because PHP depends on the client libraries to Communicate with MySQL. You might want to check to see if MySQL Support is installed for PHP while you are at it.

During the install you will see a refrence to "localhost" This you need to point to the remote MySQL server. You can use a domain name or IP address to point at the correct MySQL server. you should create a database and user for that database and fill those entries in so sugar can create the tables in the databases and populate defaults into the database.

You should use the wizard to do the instal as it is a complex setup and configuration. The system checks for dependancies before you install it is a good practice to make sure all the dependancies are there before you install.

Also this document is a good read for installing the system:
SugarOpenSource_InstallGuide_4.5.pdf

[pdeschen]

mysql is currently up and running on the server on which I am trying to install sugar and I know it is working properly (we have bugzilla and wikimedia databases running)

I would be glad to change the database ip through the wizard but I can't get passed through the System Check Acceptance step as it keeps on saying

MySQL Database Not Available

As mentionned in my first post, I have all the necessary packages up and running along with libraries.

Thanks for the link but I have already read the install guide but it is quite limited in terms of Troubleshooting.

Is there some debug logging info I could check?

Pascal

[kpit]

does php have the extension for mysql installed?

put this on the server somewhere in phpinfo.php:

<?php phpinfo(); ?>

then browse to phpinfo.php this will show you your php configuration as it is installed.

[pdeschen]

I got phpMyAdmin up and running well.

[kpit]

Did you run the phpinfo on the server you are having the problem with?

[pdeschen]

Well, I am not sure how I did get it to work but both error are now gone I can proceed with the installation.

mbstring was installed but I had to restart apache to make it available (my mistake). However, I am not sure if this should have a relation with the MySQL being Not Available...

Anyways...

Now I get this problem related to the memory size while the wizard tries to create the database and tables. According to the config check my php config was > 32Mb (unlimited) and ok butI have find out that it was not the case (8Mb limit). Besides, I had this error in my http log

PHP Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to allocate 2 bytes) in /var/www/html/SugarSuite-Full-4.5.0d/include/templates/TemplateGroupChooser.php on line 83, referer: http://truffaut.nuecho.ad/SugarSuite/install.php
Allowed memory size of 12582912 bytes exhausted (tried to allocate 21 bytes)

So I just allocated more memory and it end out ok. According to the install script, the database creation used:

Approximate memory used: 15349128 bytes.

I am now up and running. Thanks for your help.

[kpit]

I set my memory limit in the php.ini to be 50MB - 64MB Sugar in certian circumstances can be a memory monster. Better to more memory available just in case you run out.