Remote MySQL DB - Installation Wizard Never Finishes

Next topic

Author	Message
Peter Tran	Sunday 28 March 2010 5:15:17 pm Hi Guys, I've been attempting to install a copy of eZ Publish Full 4.2 onto my local machine. However, for development purposes, I wish to create the MySQL database on a development server which resides on a remote location on the Internet (Mediatemple in particular). When I run through the installation wizard to complete the installation of eZ Publish, I enter in all the correct MySQL details and continue on to the last few pages where I am able to select from a dropdown list the database I want to install to. After hitting the confirmation button, I am monitoring the remote MySQL server and I can see that it is creating all the tables required, however the installation wizard never completes. It appears that the script continues to run forever. Has anyone has this issue before and a solution? Any help would be greatly appreciated. Cheers.
Peter Tran	Sunday 28 March 2010 5:26:10 pm Just to add some notes to this issue: 1. When I stop the script and re-open the website again, it prompts me with the Installation Wizard screen and asks me to run throug the install process again. I can see that the directories/sites I have defined earlier have been created in the /settings/siteaccess folder. 2. I have attempted to start another eZ Publish installation, this time on a remote LAMP server, but the MySQL server and the website are on different IP's/Networks - thinking that there were issues with my localhost installation but the same symptoms occur. This issue does not occur when I set the MySQL settings to use a localhost version of the MySQL server. The username/passwords that I am using to connect to the remote MySQL server is correct and it has been granted all permissions and is allowed to connect from any IP address.

Author

Message

Sunday 28 March 2010 5:15:17 pm

Hi Guys,

I've been attempting to install a copy of eZ Publish Full 4.2 onto my local machine. However, for development purposes, I wish to create the MySQL database on a development server which resides on a remote location on the Internet (Mediatemple in particular). When I run through the installation wizard to complete the installation of eZ Publish, I enter in all the correct MySQL details and continue on to the last few pages where I am able to select from a dropdown list the database I want to install to.

After hitting the confirmation button, I am monitoring the remote MySQL server and I can see that it is creating all the tables required, however the installation wizard never completes. It appears that the script continues to run forever.

Has anyone has this issue before and a solution? Any help would be greatly appreciated.

Cheers.

Peter Tran

Sunday 28 March 2010 5:26:10 pm

Just to add some notes to this issue:

1. When I stop the script and re-open the website again, it prompts me with the Installation Wizard screen and asks me to run throug the install process again. I can see that the directories/sites I have defined earlier have been created in the /settings/siteaccess folder.

2. I have attempted to start another eZ Publish installation, this time on a remote LAMP server, but the MySQL server and the website are on different IP's/Networks - thinking that there were issues with my localhost installation but the same symptoms occur.

This issue does not occur when I set the MySQL settings to use a localhost version of the MySQL server.

The username/passwords that I am using to connect to the remote MySQL server is correct and it has been granted all permissions and is allowed to connect from any IP address.

eZ debug

Timing:	Jan 18 2025 02:14:45
Script start
Timing:	Jan 18 2025 02:14:45
Module start 'layout'
Timing:	Jan 18 2025 02:14:45
Module start 'content'
Timing:	Jan 18 2025 02:14:46
Module end 'content'
Timing:	Jan 18 2025 02:14:46
Script end

Main resources:

Total runtime	0.6565 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0055	588.1641	152.6563
Module start 'layout'	0.0055	0.0027	740.8203	39.5078
Module start 'content'	0.0082	0.6468	780.3281	424.5000
Module end 'content'	0.6550	0.0014	1,204.8281	8.1094
Script end	0.6564		1,212.9375

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.4696	16	0.0002
Check MTime	0.0013	0.1999	16	0.0001
Mysql Total
Database connection	0.0008	0.1158	1	0.0008
Mysqli_queries	0.6166	93.9337	52	0.0119
Looping result	0.0005	0.0740	50	0.0000
Template Total	0.6328	96.4	2	0.3164
Template load	0.0019	0.2830	2	0.0009
Template processing	0.6310	96.1200	2	0.3155
Template load and register function	0.0002	0.0300	1	0.0002
states
state_id_array	0.0007	0.1024	1	0.0007
state_identifier_array	0.0008	0.1155	2	0.0004
Override
Cache load	0.0015	0.2354	14	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0704	1	0.0005
Fetch class attribute name	0.0010	0.1592	2	0.0005
XML
Image XML parsing	0.0001	0.0154	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0011	2	0.0000
General
dbfile	0.0006	0.0904	10	0.0001
String conversion	0.0000	0.0014	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs