Migration to new server:  404 error - need help with mysql and windows server 2008 permissions
Posted: 22 April 2010 09:58 PM   [ Ignore ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

1. I upgraded EE to 1.6.9 on server 2003
2. Now I’ve moved EE to server 2008 x64/HeliconAPE/WAMP
3. The mysql EE DB was imported to 2008
4. The EE files wereall moved
3. The wizard.php comes up with a 404 error.

What permissions do I set inside mySQL and how do I do that [newbie to mysql]?
What does this actually mean [for newbies]: “The files and directories that need to be set to 666 or 777 on Unix servers need to be set as writeable on Windows servers.”

Thanks for always excellenet support.
Chris

Profile
 
 
Posted: 23 April 2010 01:03 AM   [ Ignore ]   [ # 1 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  14993
Joined  03-22-2004

Chris,
What does the address to the wizard look like?
Are you able to view any files via your browser on the new server?
Try a simple html file in your root.
What version of PHP are you running?

Profile
 
 
Posted: 23 April 2010 02:28 AM   [ Ignore ]   [ # 2 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi John:

What does the address to the wizard look like?  404 error

Are you able to view any files via your browser on the new server?  We can see all files [lots] but nothing in EE - all 404 page

Try a simple html file in your root.  Complex HTML pages with flash, css and bells and whistles work fine.

What version of PHP are you running? Latest wamp server 2 [Apache 2.2.11, php5.3.0, mysql 5.1.36]

Running EE 1.6.9, which worked fine after the upgrade on server 2003 but ran into this problem after migration to new 2008 server.

Any help is appreciated.
Chris

Profile
 
 
Posted: 23 April 2010 08:10 AM   [ Ignore ]   [ # 3 ]  
Chancellor's Fellow
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  30388
Joined  04-29-2002

Can you create a phpinfo.php file with the following code?

<?php phpinfo(); ?> 

and see if it works?

Profile
MSG
 
 
Posted: 25 April 2010 10:16 PM   [ Ignore ]   [ # 4 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi Sue: I couldn’t get it to work. Chris

Profile
 
 
Posted: 26 April 2010 01:23 AM   [ Ignore ]   [ # 5 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  14993
Joined  03-22-2004

Chris,

OK lets try a basic PHP page. If this does not work then you will have to troubleshoot PHP in your installation and set-up of WAMP.

<?php
   
echo "Hello world";
?> 
Profile
 
 
Posted: 13 May 2010 05:45 PM   [ Ignore ]   [ # 6 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi:

php definitely works. 

Still get:  Error message 404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Tried shebangs, doublechecked no strict mode etc, but simply don’t know what the next step to try is. 

Thank you in advance for excellent help.
Chris

Profile
 
 
Posted: 13 May 2010 11:59 PM   [ Ignore ]   [ # 7 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi:  It is really hard for me to troubleshoot this Server 2008 related problem because I’m literally just following steps blindly.  When I did the server 2003 upgrade from 1.52 to 1.6.9 everything was working just fine. 

Because I don’t understand the logic of what I’m doing - ie how ee works to pull from contents, commons and so forth, I couuld be at this forever.  Could you point me to something that explains for non-developers exactly what is under the hood so I can troubleshoot each link in the chain in a methodical way?

Many thanks
Chris

Profile
 
 
Posted: 14 May 2010 05:49 AM   [ Ignore ]   [ # 8 ]  
Chancellor's Fellow
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  30388
Joined  04-29-2002

Chris, I’m going to be perfectly blunt here. The first thing you need to do is to move this EE install over to Linux hosting instead of Windows hosting. I recommend EngineHosting. They’re geared towards running EE sites.

Would that be an option for you?

Profile
MSG
 
 
Posted: 14 May 2010 03:52 PM   [ Ignore ]   [ # 9 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi Sue:

The php/apache/mysql are now running fine but I need to connect the EE properly.  We run our own windows servers virtualized on VMware sphere4. EE has run phenomenally well alongside multiple windows proprietary web apps. Server 2008 integrates mysql and MSsqlserver so you can work on both directly inside IIS7. The Zend server CE for windows includes optimizer and should make the upgrade to EE2 much easier for us.

I’m new to EE.  What would help is where I might find a reference(s) that clarifies basic EE “path” logic for non-developers.

Thank you for your patience
Chris

Profile
 
 
Posted: 14 May 2010 04:32 PM   [ Ignore ]   [ # 10 ]  
Chancellor's Fellow
Avatar
RankRankRankRankRankRankRankRank
Total Posts:  33338
Joined  05-15-2004
Enviromed - 14 May 2010 07:52 PM

The php/apache/mysql are now running fine but I need to connect the EE properly.

EE doesn’t need any special treatment. A working web server with PHP and MySQL should be all that’s required.

I’m new to EE.  What would help is where I might find a reference(s) that clarifies basic EE “path” logic for non-developers.

I am not sure I follow here completely. Unfortunately we won’t be able to assist you much with server side issues. I recommend not to use a Windows server environment if you can possibly help it, though.

Profile
MSG
 
 
Posted: 16 May 2010 02:40 AM   [ Ignore ]   [ # 11 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Turns out I needed to assign two IP’s - one for Apache and one for IIS7 so they can both listen on port 80.  Our website uses two DB’s: EE/my sql and webapps/mssql [http://www.shanewelldon.com/2009/02/04/apache-and-iis7-together-on-sbs2008/]
Hope this helps other EE windows users.  Thank you for your patience.  Chris

Profile
 
 
Posted: 17 May 2010 12:45 AM   [ Ignore ]   [ # 12 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  14993
Joined  03-22-2004

Chris, can I confirm you are up and running and now without issue?

Profile
 
 
Posted: 17 May 2010 01:52 AM   [ Ignore ]   [ # 13 ]  
Research Assistant
RankRankRank
Total Posts:  339
Joined  08-16-2005

Hi John:  In transition but you can close this thread.  Thank you.  Chris

Profile
 
 
Posted: 17 May 2010 02:03 AM   [ Ignore ]   [ # 14 ]  
Professor
Avatar
RankRankRankRankRankRankRank
Total Posts:  14993
Joined  03-22-2004

Thanks Chris. Feel free to start a new thread if you have any more questions.

Profile