Problems installing on IIS

[bkss]

Hello,

I am trying to set up SugarCRM on Microsoft's Small Business Server 2003(without MS SQL)

I want to use the IIS 6 that came with SBS 2003

First I unzipped the sugar zip file into the inetpub/wwwroot directory and renamed it to sugarcrm.

Then I went into the IIS management and set the permission to read and write

I installed PHP 5.1.4

I installed MySQL(essentials only) 5.0.22 and then MySQL Administrator and was able to run the administrator and have it say that the database is running

Up until this point everything seems to install fine, but then I go to the URL http://localhost/sugarcrm/install.php and accept the terms.

This is where the problem surfaces. It says it cannot detect the MySQL database.

I have tried this with different versions of MySQL, and Sugar. I don't understand why it can't recognize that the MySQL DB is functional and running.

If anyone has any ideas it would be much appreciated.

Thanks,

Jason

[sacramentojoe]

Hello,

I am trying to set up SugarCRM on Microsoft's Small Business Server 2003(without MS SQL)

I want to use the IIS 6 that came with SBS 2003

First I unzipped the sugar zip file into the inetpub/wwwroot directory and renamed it to sugarcrm.

Then I went into the IIS management and set the permission to read and write

I installed PHP 5.1.4

I installed MySQL(essentials only) 5.0.22 and then MySQL Administrator and was able to run the administrator and have it say that the database is running

Up until this point everything seems to install fine, but then I go to the URL http://localhost/sugarcrm/install.php and accept the terms.

This is where the problem surfaces. It says it cannot detect the MySQL database.

I have tried this with different versions of MySQL, and Sugar. I don't understand why it can't recognize that the MySQL DB is functional and running.

If anyone has any ideas it would be much appreciated.

Thanks,

Jason

Have you tried using / writing a regular php & mysql app to see if it works?
I know that on my IIS box the password doesn't work I had to update the password using the old_passowrd() method.

Take a look:
mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

Whats the error that you're getting?

[bkss]

Hi,

I just tried the Old_Password() method that you described above, but it didn't fix my problem. So here is where I'm stuck, I'll just paste the component test screen in here. I'm most concerned with the MySQL DB error.


Component Status
PHP Version Unsupported PHP Version Installed: ( ver 5.1.4 )
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.
XML Parsing OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 32M OK (Unlimited)
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path (C:\PHP\sessiondata) OK
Optional Components Status
IMAP Module Not found: InboundEmail and Campaigns (Email) require the IMAP libraries. Neither will be functional.
cURL Module Not found: Sugar Scheduler will run with limited functionality.
PHP-JSON Module (v 1.1.1) Not found: The PHP-JSON PHP module reaps enormous performance benefits.
ZLIB Compression Module OK

Note: Your php configuration file (php.ini) is located at:
C:\WINDOWS\php.ini

[ruchida]

Hi,

There are two things I would like you to double-check.

1. php.ini setting

Is the line below uncommented?

 extension=php_mysql.dll 
  

2. Does Windows have access to the PHP directory? It should be able to load libmysql.dll in the PHP directory. Or you can copy libmysql.dll to the Windows system directory.

[bkss]

Ok so I went through the php.ini and uncommented the extensions cURL, mysql, imap and mbstring.

I copied these files into C:/WINDOWS:

php_curl.dll
php_imap.dll
php_mysql.dll
php_mbstring.dll
libmysql.dll

The extensions path in php.ini is set to "./" so it finds them now but the errors have changed from Cannot Find to Access Denied

Here's the error printout from the bottom of the screen

PHP Warning: PHP Startup: Unable to load dynamic library './php_curl.dll' - Access is denied. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_mysql.dll' - Access is denied. in Unknown on line 0

I checked the permissions on these files and the users on the list all have full permissions. Making progress but I'm still missing something. Where do fix this Access Denied problem?

Thanks,
Jason

[ruchida]

Hi,

IUSR_COMPUTERNAME should also have a permission to the directory. And copy libeay32.dll and ssleay32.dll also to the Windows directory, which php_curl requires.

Ok so I went through the php.ini and uncommented the extensions cURL, mysql, imap and mbstring.

I copied these files into C:/WINDOWS:

php_curl.dll
php_imap.dll
php_mysql.dll
php_mbstring.dll
libmysql.dll

The extensions path in php.ini is set to "./" so it finds them now but the errors have changed from Cannot Find to Access Denied

Here's the error printout from the bottom of the screen

PHP Warning: PHP Startup: Unable to load dynamic library './php_curl.dll' - Access is denied. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_mysql.dll' - Access is denied. in Unknown on line 0

I checked the permissions on these files and the users on the list all have full permissions. Making progress but I'm still missing something. Where do fix this Access Denied problem?

Thanks,
Jason

[bkss]

How exactly do I change the permissions on the user IUSER_COMPUTERNAME

I found the user listed in the server management browser, but it doesnt show up when i go to the windows folder and try to change permissions there. If you could walk me through how to do this, I would much appreciate it.

Thanks,
Jason

[ruchida]

How exactly do I change the permissions on the user IUSER_COMPUTERNAME

I found the user listed in the server management browser, but it doesnt show up when i go to the windows folder and try to change permissions there. If you could walk me through how to do this, I would much appreciate it.

Thanks,
Jason

Hi,

Here is a good document. (the "Testing PHP Installation" section will be the one.)http://codex.gallery2.org/index.php/...P_Installation

[Videira]

Hello all.

I am having the same problem, when installing Sugar Suite 4.5, on a development Windows XP, with PHP 5.0.4 and MySql 5.0.2. All configuration parameters are OK, only the Database is not.

I have a MySql Database, but the Step 2 of the installation "System Check Acceptance" considers instead a Sql Server Database, which I do not have installed on my computer. Does anyone have any idea why?

Thanks