CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • [SOLVED] Godaddy.com hosting issues...
Pages: [1]

Author Topic: [SOLVED] Godaddy.com hosting issues...  (Read 14466 times)

donovan

  • Guest
[SOLVED] Godaddy.com hosting issues...
December 10, 2007, 10:38:24 pm
yes, yet another....


I have setup the hosting account per the directions for joomla 1.5 rc3 and civicrm 1.9. I have php 5 enabled...I've setup the php5.ini with the appropriate values of:

max_execution_time 600
memory_limit = 36M

but I am still having problems. Here is the output of the resulting attempt to install:

        * Component Install: DB function failed with error number 2006
          MySQL server has gone away SQL=INSERT INTO jos_components VALUES( "", 'CiviCRM', 'option=com_civicrm', 0, 0, 'option=com_civicrm', 'CiviCRM', 'com_civicrm', 0, 'js/ThemeOffice/component.png', 0, 'task=civicrm/profile\nreset=1\n', 1 )
          SQL =

          INSERT INTO jos_components VALUES( "", 'CiviCRM', 'option=com_civicrm', 0, 0, 'option=com_civicrm', 'CiviCRM', 'com_civicrm', 0, 'js/ThemeOffice/component.png', 0, 'task=civicrm/profile\nreset=1\n', 1 )

        * It was not possible to copy the selected file.
        * JInstaller::install: Failed to copy file: /home/content/f/o/u/DOMAINNAME/html/www/CLIENTDOMAIN/com_civicrm/civicrm.xml to /home/content/f/o/u/DOMAINNAME/html/www/CLIENTDOMAIN/administrator/components/com_civicrm/civicrm.xml
        * Component Install: Could not copy setup file

does anyone know of a manual installation how-to similar to cirvicrm-drupal manual installation method to install this on joomla? I suppose I could go and read the installation script but wanted to check here. Better yet has anyone gotten this to install on godaddy.com's economy linux hosting service?
« Last Edit: December 12, 2007, 09:19:36 am by donovan »

speleo

  • Ask me questions
  • ****
  • Posts: 396
  • Karma: 28
  • CiviCRM version: 4.3.1
  • CMS version: J! 2.5,9
  • MySQL version: 5.1
  • PHP version: 5.3.24
Re: Godaddy.com hosting issues...
December 11, 2007, 12:36:37 am
A quick google search on the error shows this error means "MySQL server has gone away" indicating that the connection was closed during the process. Some users have indicated that running a tool to optimise your db tables cures the issue.

http://www.joomlaplug.com/component/option,com_fireboard/Itemid,89/func,view/catid,12/id,1592/
http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,868/Itemid,35/

donovan

  • Guest
Re: Godaddy.com hosting issues...
December 11, 2007, 02:25:31 am
mmm, after ironing out some bugs with the sm2 db heath component I was able to run the check. I found no errors in the database. Now what?

speleo

  • Ask me questions
  • ****
  • Posts: 396
  • Karma: 28
  • CiviCRM version: 4.3.1
  • CMS version: J! 2.5,9
  • MySQL version: 5.1
  • PHP version: 5.3.24
Re: Godaddy.com hosting issues...
December 11, 2007, 03:48:01 am
Hmmm. A bit of lateral thinking. I wonder if it is possible to manually run the mysql creation scripts in myPHPadmin and then run the install as an upgrade?

You'd need to look at the code specifically to work out which scripts to run.

Since this is a mysql timeout I suspect that the value of mysql.connect_timeout might be important. Mine is set to 60.

donovan

  • Guest
Re: Godaddy.com hosting issues...
December 11, 2007, 04:13:54 pm
Quote from: speleo on December 11, 2007, 03:48:01 am
Hmmm. A bit of lateral thinking. I wonder if it is possible to manually run the mysql creation scripts in myPHPadmin and then run the install as an upgrade?

You'd need to look at the code specifically to work out which scripts to run.

Since this is a mysql timeout I suspect that the value of mysql.connect_timeout might be important. Mine is set to 60.

On the phone now with godaddy.com now and checking on that value. It seems to be at the heart of what I am seeing here. I was thinking of trying this by hand...sort of using the drupal manual install as a reference and looking at the specific install steps taken in the setup script. Will post back with my results soon.

donovan

  • Guest
Re: Godaddy.com hosting issues...
December 11, 2007, 04:33:39 pm
that was the ticket....

in php5.ini I set this:

mysql.connect_timeout = 60

seems that godaddy.com sets the default value to 30....

now I need to clean things up and I should be on my way...thanks again.

cjrhoads

  • Guest
Re: [SOLVED] Godaddy.com hosting issues...
December 15, 2007, 02:46:47 pm
I just thought you'd like to know that this thread solved my problem installing on Godaddy as well.  I added the line you suggested to my php.ini file, and it uploaded successfully (at least that's what it said). 

So - I'm on to my next problem - thanks so much to everyone to posted to this thread.

Regards
CJ Rhoads

cjrhoads

  • Guest
Re: Godaddy.com hosting issues...
December 16, 2007, 09:56:44 am
Well - the problem is back.  I had to upgrade from PHP4 to PHP5, and now I'm trying to reinstall everything again.  Here's my question - I still only see a php.ini file in the home directory.  Shouldn't I now see a php5.ini file?  And if I create it, what else needs to be there?  I've tried having both php.ini and php5.ini with the following in it, and I still get the same mysql went away error:
Quote
register_globals = off
allow_url_fopen = off
mysql.connect_timeout = 60
expose_php = Off
max_input_time = 60

max_execution_time 600
memory_limit = 36M

variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[Zend]
zend_extension=/usr/local/zo/ZendExtensionManager.so
zend_extension=/usr/local/zo/4_3/ZendOptimizer.so
rg_emulation=off

Any help would be greatly appreciated.

Thanks
CJ
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Joomla! Installations (Moderator: Deepak Srivastava) »
  • [SOLVED] Godaddy.com hosting issues...

This forum was archived on 2017-11-26.