Page 1 of 1

Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 4:42 am
by Darwin Web Design
Hello
I am trying to install cmsms on a remote web hosting service:

Windows 2003 server
MySQL 4
PHP 4.4.2

I have FTP'd all of the original CMS 13 Canary files to the root of the site.  I have double checked the database information and been assured it is correct.

1)  When I try to install with an empty config file (ie file size = 0), and then point to: /install/install.php - I get a browser message saying: Cannot modify c:\domains\xyz.com\wwwroot/config.php, please change permissions to allow this (although Filezilla tells me it is set to 666).  I can't seem to change the other folders to 777 - being Windows Server?  How do I go about this and is it essential for installation.

2) When I delete the config file from the host with the hope that the installation might create one for me, I can install up to step 4, where I input the database info (carefully copying and pasting) - it comes up with the error that I cannot connect to the database.

3) After trying the above two methods with no luck, I wrote all my server paths and database passwords etc in the config file itself and uploaded that.  When I try this method, the login admin screen comes up but it won't let me login, says invalid user name/pwd.

My web hosting company says the database is connecting for them.  They have even imported my backup file into it for me (which I'm willing to override if I can connect!)

ANY help or ideas would be much appreciated.  I hope I have given enough info.  If it is something to do with permissions, how do I go about changing them on a Windows server myself, or do I rely on my hosting company somehow.  

Thank you  :-[

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 9:05 am
by tsw
Aussie Gecko wrote: 1)  When I try to install with an empty config file (ie file size = 0), and then point to: /install/install.php - I get a browser message saying: Cannot modify c:\domains\xyz.com\wwwroot/config.php, please change permissions to allow this (although Filezilla tells me it is set to 666).  I can't seem to change the other folders to 777 - being Windows Server?  How do I go about this and is it essential for installation.
windows has multiple levels of access rights. It might be that you dont have modify rights (which I dont think ftp clients will even tell you) or some strange ACL restriction (which Im sure ftp clients wont tell about)
Aussie Gecko wrote: 2) When I delete the config file from the host with the hope that the installation might create one for me, I can install up to step 4, where I input the database info (carefully copying and pasting) - it comes up with the error that I cannot connect to the database.
Which mysql driver you tried to use (there is a dropdown which has few options). Have you tried connecnting to the db from somewhere else?
Aussie Gecko wrote: 3) After trying the above two methods with no luck, I wrote all my server paths and database passwords etc in the config file itself and uploaded that.  When I try this method, the login admin screen comes up but it won't let me login, says invalid user name/pwd.
Installer creates the first user for you in the db, as installer didnt go through there wont be any users and you cannot login. (you could create one user by hand if you get connection to the db right)

Aussie Gecko wrote: My web hosting company says the database is connecting for them.  They have even imported my backup file into it for me (which I'm willing to override if I can connect!)
if you have backup database imported it should work if you use the same prefix for table names e.g "cms_" and config.php is about right
Aussie Gecko wrote: ANY help or ideas would be much appreciated.  I hope I have given enough info.  If it is something to do with permissions, how do I go about changing them on a Windows server myself, or do I rely on my hosting company somehow. 
Windows permissions are funny (I dont have enough experience with windows servers to give any advice other than switch to linux ;)

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 10:39 am
by Darwin Web Design
Thank you for your reply,

I connected to the database successfully using mySQL Query Browser, so that went fine.

I tried another install and on screen 4 of installation, I left the table prefix blank and unticked the bottom two items re install tables and sample content (considering I already have the database imported)... thought things were going well when I progressed to the next screen...!! which tells you the document root etc.  Good - then the next screen unfortunately gave me the following error messages:


Warning: fopen(c:\domains\xyz.com.au\wwwroot/config.php): failed to open stream: Permission denied in c:\domains\xyz.com.au\wwwroot\lib\config.functions.php on line 293

Warning: unlink(c:\domains\xyz.com.au\wwwroot/tmp/cache/SITEDOWN): Permission denied in c:\domains\xyz.com.au\wwwroot\install\install.php on line 674
Error: Could not remove the tmp/cache/SITEDOWN file. Please remove manually.

Congratulations, you are all setup.

Here is your CMS site - which actually just takes me to my static temporary home page index.htm.

Any other clues???  :-X

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 12:50 pm
by tsw
Seems to be more permission denied errors. installer tries to delete sitedown file and create config.php but fails with permission denied error

check that config.php has read/write/modify rights and tmp/cache folder has read/write/modify/delete rights for the user running the httpd process (no idea what that is in microsoft systems)

as a test you could try setting those to have all permissions for everybody (not very secure, but if it installs right you can then tighten these settings)

hope this helps

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 2:34 pm
by NickR
Sounds to me like the user that is used to execute the pages on your server does'nt have enough permissions to create/edit/delete files, probably only execute.

Are you using PHP extension for IIS, if so make sure that the user used (by default its IUSR_) has the correct permissions on your website.

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 6:05 pm
by 3dcandy
Is php running correctly?

to change users and to make sure that the scripts will run, you need to add the site in IIS manager.
you then need to make a virtual directory (name it what you want) and make sure this virtual directory has read, write and script running ability's. IIS will warn you that this is insecure, but it won't run unless you do this.

Permissions...hard, where do I start. at least make sure that your default website in IIS manager has anonymous rights....

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 6:25 pm
by tsw
Thank god I work with linux servers  :P

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Wed Jul 26, 2006 11:09 pm
by 3dcandy
Win servers are just as easy...
just different!

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Thu Jul 27, 2006 8:14 am
by Darwin Web Design
Thank you, I appreciate all the help.
Looks like we cannot get this resolved and the client may need Linux server hosting afterall.  A shame, would have liked to stick with their current host but this isn't looking possible.  :'(

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Thu Jul 27, 2006 2:36 pm
by 3dcandy
my homeserver is running win2003 server, I guess that one of the security settings your host is using is killing things.
having both linux servers and windows servers, believe me they both have their pros and cons, but my homeserver
can run standard xp software that I personally use, thus why I went down that route

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Fri Jul 28, 2006 11:56 pm
by Bealers
but my homeserver can run standard xp software that I personally use, thus why I went down that route
VMWare server is now free. Even if you don't have a dedicated machine spare for dev then there's no reason (except mem/cpu load, maybe) why you can't run a virtual machine and better emulate your production environment, e.g. pop Linux on it, isntall PHP/MySQL/Apache/Samba, map a drive to your samba share and dev on a linux machine.

This is not a Windows bash, if production env is Windows then dev on Windows too. My point is that I see no good reason to have a production env running linux but dev running windows.

D

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Sat Jul 29, 2006 6:40 am
by NickR
Bealers wrote:
but my homeserver can run standard xp software that I personally use, thus why I went down that route
VMWare server is now free. Even if you don't have a dedicated machine spare for dev then there's no reason (except mem/cpu load, maybe) why you can't run a virtual machine and better emulate your production environment, e.g. pop Linux on it, isntall PHP/MySQL/Apache/Samba, map a drive to your samba share and dev on a linux machine.

This is not a Windows bash, if production env is Windows then dev on Windows too. My point is that I see no good reason to have a production env running linux but dev running windows.

D
If I installed vware on my server to run linux, could I connect to it like a physical machine from my laptop ?

Re: Win2003 Server install - tried 3 methods, none are working...

Posted: Sat Aug 05, 2006 8:31 am
by 3dcandy
yup, vware is nice...
quite simply, in my setup it made the most sense. I have no issues with either linux or windows, and find it hard pushed
to see a difference in performance. However, for me, having 2 pc's that run windows in my place makes more sense
than a mixed setup, especially when the missus has no feckin idea and want's to check her hotmail account....

:o