PP5, New Installation, No Integration, Problems at Step

thechameleon · March 8th, 2005, 03:35 PM

Hi,

I am new to Photopost and all the backened stuff (MySQL, PHP, etc.). I am running PP5 on a Win2003 box with IIS and PHP 4.3.10 and MySQL 4.1. I have correctly setup my photopost database in MySQL and have created an account with full permissions to the database. I have given all of the photopost directory files and folders read & execute, read, and write permissions. I have mananged to get through all 4 of the first steps. After I enter enter the admin account details and click next for the final setup, I get a bunch of fopen errors:

Warning: fopen(c:\inetpub\wwwroot/data/thumbs/index.htm): failed to open stream: No such file or directory in <b>c:\inetpub\wwwroot\install.php on line <b>965<br />

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 966

Warning: fopen(c:\inetpub\wwwroot/data/medium/index.htm): failed to open stream: No such file or directory in c:\inetpub\wwwroot\install.php on line 971

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 972

Warning: fopen(c:\inetpub\wwwroot/data/mini/index.htm): failed to open stream: No such file or directory in c:\inetpub\wwwroot\install.php on line 977

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 978

Warning: fopen(c:\inetpub\wwwroot/data/500/thumbs/index.htm): failed to open stream: Permission denied in c:\inetpub\wwwroot\install.php on line 965

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 966

Warning: fopen(c:\inetpub\wwwroot/data/500/medium/index.htm): failed to open stream: Permission denied in c:\inetpub\wwwroot\install.php on line 971

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 972

Warning: fopen(c:\inetpub\wwwroot/data/500/mini/index.htm): failed to open stream: Permission denied in c:\inetpub\wwwroot\install.php on line 977

Warning: fclose(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\install.php on line 978

etc. It goes on for a bit going through data directories 1 + 2 as well. At the bottom it says installation finished and lets me go to the admin page, but I think something is messed up and not working as once I try to login with my created admin account from the main page, it says my account doesn't exist and asks me to register. I obviously has my old account as if I try to register with that username, it says it already exists.

Any help would be greatly appreciated! Thanks so much!

thechameleon · March 8th, 2005, 03:41 PM

opps, forgot to mention that I think it could be a directory issue, as the errors seem to have the incorrect backslashes, but my install directory is c:\inetpub\wwwroot because it is windows but the install.php wants to use forward slashes. I have tried changing the install directory to c:/inetpup/wwwroot but that doesn't seem to work either...

Chuck S · March 8th, 2005, 03:41 PM

The uploads and data directories need to be set to linux 777 or in a windows world this would be

EVERYONE,IWAM,IUSER have READ WRITE AND EXECUTE TO THOSE DIRECTORIES

thechameleon · March 8th, 2005, 04:11 PM

Thanks Omegatron, I know you have said numerous times in teh forums to check the permissions and I had like a dozen time so I apologize...stupid windows, I had done them all but for some reason data and uploads didn't get the correct permissions... okay, so next issue is once I click to the admin-main.php page, I get these errors:

Warning: opendir(c:inetpubwwwroot/data): failed to open dir: Invalid argument in c:\inetpub\wwwroot\adm-main.php on line 19

Warning: readdir(): supplied argument is not a valid Directory resource in c:\inetpub\wwwroot\adm-main.php on line 21

Warning: closedir(): supplied argument is not a valid Directory resource in c:\inetpub\wwwroot\adm-main.php on line 29

now it looks to me like the $dir variable in admin-main is having issues since it is throwing opendir errors. any thoughts? I assume it should be c:\inetpub\wwwroot but it hasn't put in that backslash but I don't know how I should fix that.

Finally, as I mentioned previously, once I exit the admin screen and try to login from the front page, it says:

Invalid login. Please check your username and password, or register.

I have checked the MySQL database and the admin user is listed there under usergroups with a groupid of 5. My admin user is listed under the users with a groupid of 5, so I assume I should have full admin access and be able to login, but I can't.

Thanks omegatron, I appreciate it greatly!

thechameleon · March 8th, 2005, 04:17 PM

nevermind on the $dir problem, it was in the settings, fixed that, so now only the login issue... :-) Thanks!

Chuck S · March 8th, 2005, 04:56 PM

Depending on your integration I would check cookie values

If you let me know what forum your integrating with I can post the norms

thechameleon · March 8th, 2005, 05:05 PM

I have no integration, I am using just PP5 for everything. I correctly entered (and double-checked) the same database information for the PP database and the User database and the same login infomation. I have tried clearing my cookies from the login problems screen on three different computers. I have searched the forums here, but everyone seems to be using vb3 or some other forum with integration, while I am just using PP5. Thx!

Chuck S · March 8th, 2005, 05:15 PM

Do you have the ability to use phpmyadmin to view the database?

thechameleon · March 8th, 2005, 05:50 PM

yep, its my machine, so sure, I am having difficulties getting it to connect to the database... are you looking for a GUI MySQL program? Because I have Aqua Data Studio installed to browse the db and tables...

thechameleon · March 8th, 2005, 06:02 PM

nice, I am into phpmyadmin, had to set old password garbage for the root account, I had already done it for my photopost MySQL user...

so, yes, I have phpmyadmin, just let me know what I should be doing or checking...

Chuck S · March 8th, 2005, 06:44 PM

Check and see what the password field says for your password in the users table. I was just curious what was in that field

You can from the login screen of your photopost install reset your password.

thechameleon · March 8th, 2005, 08:20 PM

Under the password column for my admin user in the user table is my plain text password which I put during the PP5 installation in step 4.

Is that okay? Should it be encrypted?

Chuck S · March 8th, 2005, 08:43 PM

Exactly it should be encrypted. Renew the password as I staged by hitting the forgot password link on your installs login page

thechameleon · March 8th, 2005, 08:50 PM

okay, I changed my password on the forgot password portion of the first page of the install.php. It let me change it and dropped me back into the admin-main.php. I then logged out, tried to login and had the same problem. I then checked the user table and my password is still plain text.

Is there something else I should try?

thechameleon · March 9th, 2005, 03:12 PM

okay, so what I have learned in the past 24 hours, is that when I change the password through the install.php it drops me back into admin-main but does no encode the password. However, once in admin-main, if I edit users, and reset my password, then it is encoded and emailed to me (needed to configure my php.ini send_mail). And then I can login with full permissions as I should. So I guess for now everything is working but I don't understand why the install.php can't encode the password you give it. Oh well, at least it is working now... Thanks for all of your help