Installation problems&questions

[Topper]

Hi everyone,

I'm trying to install SugarCRM on the webserver of the company i just joined.
At step 2 of the installation process i get these two red lights:

1) SQL Server Database Not Available
2) Writable Session Save Path (/tmp) Not A Valid Directory



1) I'm not too experienced with installations like this, so maybe you can help me out.
I believe the webserver is using MySQL 3.23.58 and SugarCRM requires 4.1.2. correct?

Means i have 2 options, install a new version of mySQL or install SQL. My problem is, i'm afraid i will somehow mess up the server if i upgrade mySQL. If i install SQL couldl it somehow create problem for mySQL? There is a website on the webserver and i dont want to destroy it somehow.

2) I dont have a clue what this means, anyone who can explain what this means and how i can solve it?

I hope some of you can take a minute and help my out, thanks in advance.

[sacramentojoe]

Hey there,
take a look at this link on MySQL.
http://dev.mysql.com/doc/refman/4.1/...from-3-23.html

It tells you exactly what to do during an upgrade.

The most important step if you ask me is to back up your current data.

Joe

[cywolf]

By the way, SQL is not a product - it stands for Structured Query Language. MySQL is one database which implements it. When SugarCRM refers to the "SQL server" it means your MySQL server (unless you're using MS-SQL instead).

#2 is saying that the session.save_path variable in your php.ini configuration file points to a directory where the webserver application isn't allowed to create files. This is probably covered in more depth in the Sugar Wiki. Without knowing what platform you're on (Windows, Linux, etc) it's hard to say any more, although I suspect you're on Linux.

[Topper]

By the way, SQL is not a product - it stands for Structured Query Language. MySQL is one database which implements it. When SugarCRM refers to the "SQL server" it means your MySQL server (unless you're using MS-SQL instead).

#2 is saying that the session.save_path variable in your php.ini configuration file points to a directory where the webserver application isn't allowed to create files. This is probably covered in more depth in the Sugar Wiki. Without knowing what platform you're on (Windows, Linux, etc) it's hard to say any more, although I suspect you're on Linux.

Yes the server is running on linux.

Should i locate the php.ini file, find out what directory it is using and make it a writable map?
I tried to find more information in the Sugar Wiki but unfortunatly i did not find it yet.

Thanks for your help so far!

[Topper]

Hey there,
take a look at this link on MySQL.
http://dev.mysql.com/doc/refman/4.1/...from-3-23.html

It tells you exactly what to do during an upgrade.

The most important step if you ask me is to back up your current data.

Joe

Hi,

Thanks for the url, i already made a backup of all the webfiles, but how do i backup the database?
(i went to the phpmyadminl, exported and i believe i have the database in .zip on my desktop although i'm not sure if this file contains all the data)


I will go and read the url now, maybe i got the guts to update it

[cywolf]

The database export is in a readable text format (SQL statements), so you should be able to open it up and verify that the data is there.

Should i locate the php.ini file, find out what directory it is using and make it a writable map?

Yup, that's about right. You'll need to make the directory writable by the user the webserver is running as, which depends on your Linux distribution and configuration. You can probably find the username and group by looking through Apache's .conf file(s), usually located in /etc/httpd/conf or /etc/apache2/conf/. They're often both 'apache' or 'nobody'.

Under Linux, php.ini is almost always located in /etc/ unless you used a packaged installer like BitRock.

Sounds like you're on the way.

[paikmoses]

Hi Topper,

If you are installing Sugar on Fedora Core 5 then you need to install php-mysql library to connect php with mysql. Basically it will look for the sockets to connect to mysql. Here you have to define an external socket in the php.ini file to connect php and mysql.

Have a look at this conversation: http://www.openapp.org/f2/upload/viewtopic.php?id=29

Hope this helps.

Regards,