Installation hang on hostgator. They provided an strace error

Permalink 1 user found helpful
Hi,

I am attempting to install concrete5 8.1 on a hostgator hosting server. First of all, I have done this in the past. I have been running version 8.1 since May on this service.

When attempting to install the installer hangs (continues to say installing but never errors out) on "Creating database tables." I have replicated this using multiple browsers and two different MySQL databases (including the shell of the one I had a working install in).

When I attempt to go to the website with another browser after hours of waiting I also get an error I would expect... the installer says this:
There are already 249 tables in this database. concrete5 must be installed in an empty database.
with a bunch of trace code.

Hostgator has provided an strace file. It is attached. Down toward the bottom it gives an error and here is an excerpt:
0.017396 sendto(3, "I\0\0\0\3INSERT INTO SystemDatabaseMigrations (version) VALUES ('20170118000000')", 77, 0, NULL, 0) = 77 <0.000014>
0.000268 recvfrom(3, "\7\0\0\1\0\1\0\2\0\0\0", 16384, 0, NULL, NULL) = 11 <0.019184>
0.019460 write(1, "Content-type: text/html; charset=UTF-8", 38) = 38 <0.000018>
0.000144 write(1, "\r\n", 2) = 2 <0.000011>
0.000104 write(1, "\r\n", 2) = 2 <0.000010>
0.000137 write(1, "{\"error\":false}", 15) = 15 <0.000010>
0.000191 chdir("/home2/g2p2k2f2/public_html") = 0 <0.000020>
0.000323 setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0 <0.000010>
0.001621 sendto(3, "\1\0\0\0\1", 5, 0, NULL, 0) = 5 <0.000022>
0.000143 shutdown(3, SHUT_RDWR) = 0 <0.000009>
0.000094 close(3) = 0 <0.000015>

The support representative also attempted to create a new database to install it into himself with the same outcome.

Any assistance in getting concrete5 reinstalled would be great.
thanks

1 Attachment

View Replies:
bayleafmedia replied on at Permalink Reply
I found a work around. I chose to install into a subdirectory so I could easily swap main directories in case I ever run into issues with HG and Concrete5 again. These are the step I took to get concrete5 version 8.1 installed on a hostgator business cloud server:

1. Install concrete5 on a local machine using MAMP.
a. Make note of db_name, user and password (the db_name and user must follow HG naming scheme)
2. Upload archived CMS you used for the isntall to /public_html/cms#/ and extract
3. Export sql databse from local phpmyadmin system.
a. Use custom method
b. Save as file
c. Check the boxes for create/use database and tables
d. Export
4. Create database in HG customer portal
a. Give necessary permissions to the user for the database in question
5. Upload sql database to a directory in /home on the server.
6. Contact HG support and have them import the sql database file
It will take several minutes.

I have sucessfully installed two concrete5 sites this way. Total time depoends on hold time (Use the local phone number rather than toll-free, or use the chat system), but both transfers completed on two separate calls within 15minutes each.

It's a hassle, but it works.

Hey Concrete5 developers, could someone give HG a call and work out a process for this and make an official write-up or get them to make a concession to allow for C5 installation?

thanks
mlipenk replied on at Permalink Reply
Thanks this helped a lot!

I also got this working for C5 vers. 8, without the help of HostGator, by exporting the MAMP localhost database SQL and running it in the PHPMyAdmin tool on HostGator. I previously created a mirror database and permissions on HostGator through their database creation tool.

To get the SQL statement, I opted not to use "Add Create / Database / Use Statement" (because I had already created the database), but I did select "Add Drop Table / View / Procedure / Trigger /....statement" Then I selected "View Output Text" vs. Save Output to a file, to get the raw SQL. (You could "Save Output to File", then open with a text editor, as well)

In Hostgator PHPMyAdmin I went to the previously created table and then dropped the copied SQL text into the SQL editor and ran it. All the tables were created successfully.

Finally, I had to go to the HostGator concrete5 "application/config/database.php" file and reconcile the DB user name and password to match what I set in HostGator and change it from the default MAMP DB root / root.
bayleafmedia replied on at Permalink Reply
That works. If you set the database user names and passwords to match before install there will be no need for reconciling in the database.php file.

However, in my situation, I could not get an accurate upload of my local database to the PHPMyAdmin interface on HG. I had to get them to import.

I'm glad to hear you got it working, and I'm glad to know there are two options in case one doesn't work.
bayleafmedia replied on at Permalink Reply
Another update.

I was able to successfully install C5 8.2 on hostgator without any of the shenanigans version 8.0 and 8.1 required!!