Windows 2003 Server + PhpWcms instalation problems

antonis · Post by **antonis** » Mon 7. Jun 2004, 15:08

I' ve installed succesfuly phpwcms RC2 - RC4 on my Linux servers many times in the past.

Now, I am trying to install it on Win2003 server. I 've used 2 ways nad both gave the same result...:
a) IIS+mySQL+PHP b) Apache+mySQL+PHP

I start the instalation (setup.php) and at the 3rd step (step2.php) where the ADMIN account is created I get the following error:
"Please Check username and password".

Normally on Linux, when I get this, I just have to CHMOD the files in the SETUP folder to 777 and everything works fine... This is NOT the case with Windows.

The only way I thought of by-passing this problem was to manually configure "conf.inc.php" and copy the DB tables from another installation that I have in Linux.
When I do that, the installation finishes, but I cannot login!!! (even if I use the Admin username and password of my Linux installation)

Please HELP!

frold · Post by **frold** » Mon 7. Jun 2004, 18:29

maybe the "Please Check username and password" username and password is wrong?

antonis · Post by **antonis** » Mon 7. Jun 2004, 18:55

frold wrote:maybe the "Please Check username and password" username and password is wrong?

no, that's not the problem...

the step is where you must choose the username & password and check the Create Admin account check box.

I imagine that the problem is with file permissions.

I tried installing the script on my pc at home (WinXP - with FAT 32, NO file & user permissions etc. +apache+mphp+mysql).

the steps that I follow are:
1. create database + user (plus connect them together)
2. copy all phpwcms files in root folder "htdocs"
3. Start setup.php
4. passing steps 1&2 fine
5. step 3: "check username & password"

I even tried leaving the defaults (webmaster, admin), without any luck!!

Post by **Oliver Georgi** » Mon 7. Jun 2004, 20:21

remember to check against $_SERVER['DOCUMENT_ROOT'] var too.

You have to add that in conf.inc.php (uncomment line).

Oliver

antonis · Post by **antonis** » Tue 8. Jun 2004, 00:45

Oliver Georgi wrote:remember to check against $_SERVER['DOCUMENT_ROOT'] var too.

You have to add that in conf.inc.php (uncomment line).

Oliver

I've used the document_root.php file and the path in conf.inc.php is correct...

These are the warnings that I am getting:

Warning: mysql_connect(): Access denied for user: 'portal@localhost' (Using password: YES) in c:\appserv\www\portal\setup\setup.php on line 100

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\portal\setup\setup.php on line 101

The error message is this:
Check your admin user name and password!

Could anybody provide some quick overview of how would you realise (or have already realized) a Windows installation using either IIS or/and APACHE.
Is there a webpage with the above info...? I searched the forum but I can't find any "organised" Windows installation info. Something like a How to Guide

I would really like to thank you all for your replies!!!

antonis · Post by **antonis** » Tue 8. Jun 2004, 01:31

I checked the following:

1. is safe_mode on -> recommend safe_mode Off

2. register_globals should be set OFF

3. New!!! session.use_trans_sid set On otherwise you will not have a chance to login.

---------------------------

1. is OFF

2. is ON

3. is OFF

how can I change 2 & 3 to the correct values? I cannot find any php.ini file in my AppServ installation...[/list]

DeXXus · Post by **DeXXus** » Tue 8. Jun 2004, 03:45

"php.ini" may have wound up in "c:\windows" with IIS

In Apache you may need to find and rename one of these:

"php.ini-recommended" -or- "php.ini-dist"
------------------------------------------------
"php.ini" SETTINGS (if you didn't know):

Code: Select all

; Whether or not to register the EGPCS variables as global variables.  You may
; want to turn this off if you don't want to clutter your scripts' global scope
; with user data.  This makes most sense when coupled with track_vars - in which
; case you can access all of the GPC variables through the $HTTP_*_VARS[],
; variables.
;
; You should do your best to write your scripts so that they do not require
; register_globals to be on;  Using form variables as globals can easily lead
; to possible security problems, if the code is not very well thought of.
register_globals=Off

Code: Select all

; trans sid support is disabled by default.
; Use of trans sid may risk your users security. 
; Use this option with caution.
; - User may send URL contains active session ID
;   to other person via. email/irc/etc.
; - URL that contains active session ID may be stored
;   in publically accessible computer.
; - User may access your site with the same session ID
;   always using URL stored in browser's history or bookmarks.
session.use_trans_sid=0

Post by **Oliver Georgi** » Tue 8. Jun 2004, 07:08

The mysql warning has nothing to do with path settings. So - check these first.

Oliver

antonis · Post by **antonis** » Thu 10. Jun 2004, 01:17

First of all I would like to thank all of you for your support! You are all great!!!

Unfortunately, my problem is still here... I am trying to setup PHPWCMS on my WInXP Pro (FAT32)+APPServ (Apache,MySQL,PHP) system at home before doing it on the Win2003 Server IIS system at work.

Here is my system overview as described by PHPCMS:
system: Windows NT A17 5.1 build 2600
server: Apache/1.3.29 (Win32) PHP/4.3.4
php: v4.3.4
path: c:/appserv/www/

The step that I am having problems with is:

create site infos and admin account
http://localhost/setup/setup.php?step=2

The warning-error message that I get and prevents me from getting pasted that step is:

Check your admin user name and password!
I must point out that in order to make it simple I leave the default username, password & e-mail and I just check the Create Admin Account check box.

Other than that: my paths seem to be correct (checked using document_root.php)
DOCUMENT_ROOT test
1) your default $_SERVER['DOCUMENT_ROOT']: c:/appserv/www
2) real DOCUMENT_ROOT based on this file : c:/appserv/www

My php.ini file is configured according to the instructions given in the relevant post. (user_trans_id_use is ON, etc).

Like I said in my previous post, when I install the script on my Linux web server I get the same error, which is resolved easily by applying CMOD 777 to the script "SETUP" folders & files using Cute FTP.

I really do not understand what am I doing wrong..!!!

DeXXus · Post by **DeXXus** » Thu 10. Jun 2004, 02:48

antonis wrote:These are the warnings that I am getting:

Warning: mysql_connect(): Access denied for user: 'portal@localhost' (Using password: YES) in c:\appserv\www\portal\setup\setup.php on line 100

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\appserv\www\portal\setup\setup.php on line 101

The error message is this:
Check your admin user name and password!

Is "portal" the username that you have created in mySQL for the phpWCMS installation to use? Or is that just the OS assigning your login name as it tries to connect to the database?

Post by **Oliver Georgi** » Thu 10. Jun 2004, 07:35

Yes - check your MySQL settings.

Oliver

antonis · Post by **antonis** » Thu 10. Jun 2004, 08:44

Dear all, after spent the whole yesterday night checking *.log, *.ini and config files of PHP, APACHE, MySQL, PHPWCMS etc.

I finally got it working!!!

The solution: php.ini MUST be configured according to the sticky note! and Although that is NOT the case when installing on my Linux server, the create all db tables must be CHECKED in step1 in order to proceed succesfully to the next step!!!

My feelings consist half of joy and half of stupidity...

Thank you all for your support!!!