Form submit and redirect problem

[gamars]

Hi all,

New to SugarCRM (love it so far) I just installed version 5.0.0f on my Unbuntu server (Apache2, php5 and MySQL). My problem is: any form that I submit (create user, create account, ... anything) works fine but takes a good 2 minutes to redirect to a working page. The browser just waits for the page a long long time. Could anyone please point me toward a solution, it is not usable like this...

Thank you

[andopes]

Hi, gamars.

Do you have proxy or internet connections issue?

[gamars]

Do you have proxy or internet connections issue?

Nope. The server has its own IP. Running Apache with 3 virtual hosts. All of which work fine. I also tried to deploy the CRM solution to one of these vhost (using a running and valid configuration) but the problem remained. Very strange...

The client I am using as well (my laptop) has no proxies and a fine connection (sorry forgot to mention).

[eNick]

Can you post...

Your server spec (memory, disk space, dedicated/shared/virtiual machine?, average cpu useage level etc)
Your database size
Your relavent settings in php.ini (ie. max_execution_time and memory)

Also, is your database dedicated to Sugar or shared with lots of other apps?

Sugar is pretty damn quick on a properly configured server/database.

[gamars]

Server:
---------
The Server is a Dedicated machine solely running 3 sites.

top - 13:53:51 up 13 days, 1:00, 2 users, load average: 0.06, 0.01, 0.00
Tasks: 67 total, 1 running, 66 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.3%us, 0.3%sy, 0.0%ni, 98.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 1018084k total, 938640k used, 79444k free, 29568k buffers
Swap: 522104k total, 64k used, 522040k free, 617148k cached


MySQL:
-----------
MySQL DB is mostly empty (default install and that's about it). The database is dedicated to SugarCRM and is the only one on this machine


PHP:
-------
max_execution_time = 30
max_input_time = 60
memory_limit = 40M

[eNick]

Certainly doesn't look over utilised!

1 gig isn't a lot though.

Does the cpu max out when you try to save a record? Or does the MySqld process max out at that point?

(Clearly you're able to run top so assume you can watch while you do it).

And are you logging slow queries in MySql, if so check whether you're getting any. You might just need to twiddle your mysql setup to get the tables cached.

I'm surprised though, that on such a simple setup it is going slow. (I know that's little help! Sorry! I'm just saying it should be flying)

[gamars]

I just tried and nope: the submit does not choke MySQL or the machine. The slow-log is empty. The submit appears to be going thru just well (the record is present if I don't wait for the page to reload and open the browser a bit later). Interestingly enough it doesn't happen all the time (I'd say 90% of the time). The form submits, the records inserts the url rewrites and then the page hangs...

[eNick]

It's working fine for me!

I logged in, created a lead which saved and redirected within 3 secs or so, and then added a note, which also saved/redirected very quickly.

Moving from tab to tab is quick.

I'm not seeing a problem at all?

Can you try from a different browser or machine?

(oh, and let me know if you want me to go and clean up the records I created!)

[gamars]

No need to clean your records , will do it. Can you try to create an account? With some info, typically name url and notes?

[eNick]

Yup, created an account, a contact, added an opportunity and an activity. Again, it all seems absolutely fine.

It must be something on your machine not the server?