FreeBSD 6.1 installation issues.

[ggroth9]

FreeBSD 6.1 stable
sugarcrm-3.5.1
apache-2.2.3
php5-5.1.6_1
mysql-server-5.0.24a

I found this thread, and seem to be having the same exact issue.

http://www.sugarcrm.com/forums/showthread.php?t=13925

In the second step of the install, where it should say MySQL, the line is blank and states Not Available. On the advice of another thread, I successfully tested the following script:

<?php
$con = mysql_connect('localhost', 'user_name', 'user_pass') or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
?>

Any ideas on what I should take a look at? PHP & MySQL seem to be configured correctly, but for some reason SugarCRM can't seem to see the database. Server name / DNS issue perhaps? What I mean by this is that I successfully used 'localhost' in the above script, I haven't tried the FQD name of the server.

TIA,
Greg

[ggroth9]

Well, the SQL database problem is fixed, not sure what happened. I went back today and tried again, and everything seemed fine in step 2. I did nothing to the server in the meantime, the only thing I noticed different is that the first time I attempted to start this process, the first screen that appeared was the license. This time the first page that appeared explained the installation process, and the second page that came up was the license. Strange.

It appears that I've hit another snag though. When trying to complete the installation process, I get the following error on step 6:

Creating the table bugs...Error creating table: bugs: Query Failed:create table bugs (id char(36) NOT NULL ,bug_number int(11) NOT NULL auto_increment,date_entered datetime NOT NULL ,date_modified datetime NOT NULL ,modified_user_id char(36) NOT NULL ,assigned_user_id char(36) ,deleted bool DEFAULT 0 NOT NULL ,name varchar(255) ,status varchar(25) ,priority varchar(25) ,description text ,created_by char(36) ,resolution varchar(255) ,release varchar(255) ,type varchar(255) ,fixed_in_release varchar(255) ,work_log text ,source varchar(255) ,product_category varchar(255) , PRIMARY KEY (id), KEY bug_number (bug_number), KEY idx_bug_name (name))::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release varchar(255) ,type varchar(255) ,fixed_in_release varchar(255) ,wo' at line 1

All the other tables are created correctly up until this point. I tried to track down the sql that was causing this error, but could not locate the file in which that above sql is located. Any ideas on where I can track this down to see if I have a typo in a sql statement?

TIA ,
Greg

[ggroth9]

After spending some more time searching the forums, I found the answer. It appears that sugarcrm-3.5.1 uses reserved words for tbale names in MySQL 5.0. Apparently the FreeBSD ports tree is somewhat out of date. I've deleted the 3.5.1 install, and trying to install from source.

Greg