[error] 403 Forbidden with admin account

[gtg182s]

I did a fresh installation on sugarcrmce 5.0.0f. I made a small changes to Contact module to add active_ind field. Here's what I've done:

===vardef.php==== //add active_ind
'active_ind' =>
array (
'name' => 'active_ind',
'vname' => 'LBL_ACTIVE_IND',
'type' => 'varchar',
'len' => '6',
),

===en_us.lang.php=== //add active_ind lable
'LBL_ACTIVE_IND' => 'Active Indicator',


With that I click on "Quick Repair and Rebuild" and repair Contact module. It shows:

Differences Found Between Database and Vardefs
....
/* Table : contacts */
/*COLUMNS*/
/*MISSING IN DATABASE - active_ind - ROW*/
/* INDEXES */
ALTER TABLE contacts add column active_ind varchar(6) NULL ;

I click on Execute and it gives me 403 Forbidden both on IE and Firefox.

I can manually add a column in the database but I prefer not to do it this way. Anyone know how I can resolve this?


I'm using IE7 and Firefox 2.0.0.14


Thank You,
Tri

[ptemplin7]

403 is an authentication error. You do not have access to change the database with the user you are using.

Is you sugar user the admin? If not try it and run it again.

Good luck, Paris

[roblaus]

What happens if you add the field in studio instead? Or is there a particular reason to do it manually?
Re. the 403 error: It's strange because this means that your webserver doesn't have access to a file or a directory. I do not think that this is a db error. Set the permissions for the entire Sugar directory (incl. subs) to 777 (don't forget to reset it afterwards) and try again.

And just in case I'm wrong - check your db user in config.php and his permissions for your Sugar db. He should be able to alter a table. If not change accordingly and try again.

[gtg182s]

I'm using admin account and I can add it in studio. The reason I dont add it in studio is because if I add a new field in studio it will be in another table "contact_cust" or something like that. If I added in vardef it will be in the same table.

I've check role list for admin user and it has all access to module and action.
Yes I've checked config.php and it uses the correct db user, root(admin user for mysql). So the problem is not DB permission.

Now how do I set permission for Sugar directory to 777? I'm using window and it doesnt have chmod command (maybe a cacls). I think I've full access, I've look in Sugar directory properties and it has all permission (under Security Tab).

Thanks,
Tri

What happens if you add the field in studio instead? Or is there a particular reason to do it manually?
Re. the 403 error: It's strange because this means that your webserver doesn't have access to a file or a directory. I do not think that this is a db error. Set the permissions for the entire Sugar directory (incl. subs) to 777 (don't forget to reset it afterwards) and try again.

And just in case I'm wrong - check your db user in config.php and his permissions for your Sugar db. He should be able to alter a table. If not change accordingly and try again.

[gtg182s]

Another strange but related problem.

On Firefox, I click on Account (or other module Contact, etc), and I click on |> (next page), will give me 403 forbidden.
On IE7, I did the same thing and it's working fine.


I'm wondering if this problem is cause by javascript or browser or something else.

Sugar is ran on
PHP Version 5.1.5 and MySQL - 5.0.24 and Window XP

also I've enable javascript on both IE and firefox.

[roblaus]

Are you using English? If not switch and try again. Although this is very remote.
Are you using IIS or Apache?
Permissions under Win - file properties.

[gtg182s]

Yes I'm using English and Apache.

yes I've check Sugarcrm file properties, all permission are allowed.

Any other suggestions?

Thanks,
Tri

Are you using English? If not switch and try again. Although this is very remote.
Are you using IIS or Apache?
Permissions under Win - file properties.

[roblaus]

Did you check your site_url settings in config.php? I can't think of anything more...