Sql Type

**Deland02** · 2006-09-22, 08:44 AM

I'm trying to install Sugar CRM for the 1st time but not really sure if the SQL version I have on the server at current is ok to use with Sugar. The server I was going to test sugar on is used for online payments and has Apache installed. Also how would I know if it has PHP installed and whet version?

I have attached a screen dump of the add / remove programmes which lists the SQL version I think?

Can anyone help?

**Angel** · 2006-09-25, 11:58 PM

I think you are missing a few things.

Here is the official list of system requirements for 4.5: http://www.sugarcrm.com/crm/products...platforms.html

You have MS-SQL (MSDE version), but the sys requirements indicate SQL 2005, even if it did support MSDE, I'd hesitate to recommend its use. PostgreSQL is not supported, so that's not an option.

Are you installing it for your own use (pilot?) or are you planning on using it throughout your organization (or portion thereof).

If it is just for your own usage, I would recommend using the XAMPP stack from Apachefriends. That one seems to be the nicest/simplest from all the ones I've played with. It will install Apache, PHP and MySQL for you, even on Windows. You don't have to worry about getting the 3 to talk to each other, it is all done for you. I think this is the most expedited way of deploying Sugar, especially if you are just wanting to check it out. If you get more serious about it, then you can revisit this topic afterwards without much pain.

You can download XAMPP from here:
http://www.apachefriends.org/en/xampp.html

As for checking your PHP version, you can check it by opening a command prompt (Start >> Run >> cmd) and navigating to the PHP folder (if present), then run "php.exe -v"

If you can't find php.exe on your system, you've answered your question about whether it is installed -- Assuming the Windows machine is the server in question.

Good luck!

**Deland02** · 2006-09-28, 03:04 PM

Thanks very much for that, you've been a great help. The problem I'm facing is this, the server I have to play around with also hosts a Secure payment website. It already has Apache and PHP installed on the server & I really don’t want to screw the site up by installing different versions on there. I don’t even know if I could run more than one version of PHP & Apache? I have been tasked with setting Sugar up to hammer it over our LAN and test the performance. The application there currently using isn’t too good.

**stevec** · 2006-09-29, 09:45 AM

One thing to do to find out about versions. Create the following file called phpinfo.php and copy iy somewhere on the server you know you can browse to:

Code:

<?php
phpinfo();
?>

That should give you all the php and apache details you could ever want.....

**Angel** · 2006-10-03, 10:42 PM

Originally Posted by Deland02

Thanks very much for that, you've been a great help. The problem I'm facing is this, the server I have to play around with also hosts a Secure payment website. It already has Apache and PHP installed on the server & I really don’t want to screw the site up by installing different versions on there. I don’t even know if I could run more than one version of PHP & Apache? I have been tasked with setting Sugar up to hammer it over our LAN and test the performance. The application there currently using isn’t too good.

You could try configuring XAMPP's Apache to listen on a different port, other than the one being used by your other instance used for the payment system. I would think that would allow you to run multiple instances of it. If it works, then you could use the second instance for Sugar only and wouldn't have to worry about messing with your other stuff. The drawback would be having to specify the port number when you use Sugar.

**Deland02** · 2006-10-18, 03:24 PM

I luckily managed to acquire my very own dedicated server for Sugar (to be delivered shortly). The question I have now is should I

1> Download & install XAMPP followed by Sugar?
or
2> Download & install MySQL, Apache & PHP & set them up separately, then install Sugar?

Bear in mind I don’t really have a great deal of expertise with MySQL, Apache & PHP. I aim to run Sugar on a private company LAN but it needs to be fairly secure or my boss won’t be too impressed if someone hacks it if you know what I mean.