vTiger Install

Hi Jamie,

It logs the error I gave in the initial post

[Thu Apr 25 10:46:02 2013] [warn] [client 203.45.8.247] (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: http://team.modakboard.com.au/install.php

[Thu Apr 25 10:46:02 2013] [error] [client 203.45.8.247] Premature end of script headers: install.php, referer: http://team.modakboard.com.au/install.php

Yes CentOS 6.4. I did a local install first on the Mac and that worked perfectly. I then uploaded to the server and tried the install there. All works fine except after the "additional modules" window of the install... the page fades to about 50% opacity and stays like that for about 10min until it comes up with an error (the error in previous posts in the log). I tried changing the PHP script timeout to 1200 under Virtualmin/Server Configuration/Website Options but it timed out at the same point. I also tried changing the Maximum execution time to 1200 under Virtualmin/Services/PHP 5 Configuration and then finally Virtualmin/Services/Configure Website/PHP Same problem kept happening. I read in some posts that people had been having time-out errors but mainly on Ubuntu servers. One post said the Virtualmin pro version had the installers in it and they worked seamlessly so I dumped the virtual server, bought the licence, upgraded, recreated the virtual server for that domain and installed via the install script. It set the execution times to 600 automatically so I felt confident it would work. I got to the same point the scrren faded, stayed like that for 10min then errored out. I have put the execution time up to 2400 but it still times out after 10min. I uninstalled the package then reinstalled with fresh DB... exactly the same problem. Looks like it tried to install as there was some movement in the database tables... I then tried migration to a new DB... more errors. If I look at the Edit Databases screen then choose the original DB I get the follow SQL error:

SQL show index from com_vtiger_workflows failed : Can't open file: './team_vtigercrm/com_vtiger_workflows.frm' (errno: 24)

If I do same with the DB set up for Migration I get the following error:

SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Out of resources when opening file '/tmp/#sql_7d7e_0.MYD' (Errcode: 24)

If I go to the install page it allows for a migration but following the set up comes with the same problems at the same time.

If you go to the index page you get the following error displayed:

Notice: Undefined index: parenttab in /home/team/public_html/index.php on line 445 Notice: Undefined variable: rows in /home/team/public_html/include/database/PearDatabase.php on line 627 Parse error: syntax error, unexpected ';' in /home/team/public_html/user_privileges/user_privileges_1.php on line 13

I'm at a loss... my server is pretty standard setup and I don't usually have any probs installing scripts.

Any help would be great... I'd really like to get this setup... thanks!

Hmm.. ok, Virtualmin just had a couple of MySQL updates come in today so I uninstalled vtiger, updated MySQL, installed vTiger again and went through the same set up... same thing happened, same message in the error log BUT I can now login to vTiger! I will start playing around to see if there are any problems but it's a step forward. Will update this if I have any issues.... Thanks!

Well it didn't install properly... appeared to work (could add company info etc) but just wishful thinking, couldn't do much else. I have just tried installing on another virtual server (same server). Same problem.

I've just now managed to install it. As the script seemed to time out as it was trying to fill the tables I set up a new install on my home system, dumped the DB, set up a new DB on the site and imported that... script ended again after 10min but could reestablish through phpmyadmin.. then when back to the install page and migrated using the DB I'd uploaded... All seems to be working now but it's a concern the DB took so long to write. Thanks for the help offer... let's hope I don't need it ;)

Hi Jamie, Well I decided to get a new server (faster, more RAM), new install of virtualmin pro with 10 domain licence and tried to install vtiger again... exactly the same issue. I set the time out to 1200 but it hasn't helped at all... I'm really at a loss... may have to take up that offer.

Well I continued trawling forums etc and finally managed to install it.

Basically... if you get the following error when installing:

(104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server

Go to Server Configuration / Website Options and change PHP script execution mode to mod_php

No time-out... perfect installation.

Yes... bit strange. Always would hang at 10min with fCGI regardless of the time-out settings.

Did you do the install from the web UI (and if so on what page), or from the command line?

You mean vTiger? I installed through the UI (not sure what you mean by "what page"

Um... OK, I'm being a bit thick here... Brand new server, then brand new Virtualmin install, created virtual server, installed vTiger through Virtualmin install script.... is that what you mean?

Ah... ok, No, don't use it and I set each one up based on it's requirement.