GRRRRR! Error message after Step 4

Burgerman · August 16th, 2006, 10:11 PM

I'm trying to integrate SMF with my new install of ReviewPost 3.3.1. I am getting the following message after Step 4 (where "XXXXXXXX" = usr name):

Quote:

Warning: mysql_connect(): Access denied for user 'XXXXXXXX_smf1'@'localhost' (using password: YES) in /home/XXXXXXXX/public_html/reviews/install.php on line 1064
I cannot connect to the Members database.

From this I am assuming that my config-inc.php file contains incorrect connection info (either username or password) to the SMF database. Is this a correct assumption?

I'm fairly certain I had them correctly input.

Burgerman · August 16th, 2006, 11:50 PM

Okay. I solved that problem (the password for the SMF database was incorrect in my config-inc.php file. Fixed it.

Now I'm having other problems. And after the seventh time of dropping the database, re-loading the Reviewpost files, setting permissions, and running the install only to get hit with multiple errors, I'm giving up for now and going to bed. Six hours is far too long to spend trying to load a "simple-to-install" program.

Tomorrow I'll try to get some help from you all; and if that doesn't work, I'll be asking for a refund.

Chuck S · August 17th, 2006, 06:55 AM

Installation errors are always a result of a user installing incorrectly answering or inputting the wrong information always. I can definately say this with utmost certainty. An install takes about 20mins tops counting upload time.

Burgerman · August 17th, 2006, 12:04 PM

Well, it certainly warms my heart to know that it's all my fault.

Sarcasm aside, one thing that causes me to wonder is that my version of SMF is 1.0.7, while the drop down menu in the install indicates SMF 1.1+. But my understanding is that SMF 1.1 is still in beta (they are calling it SMF 1.1RC2 or Release Candidate #2. I'm reluctant to upgrade to a non-finalized application.

I suppose I will try installing Reviewpost without any forum integration to see if that works by itself. If it does, that will tell me that the problem is either with the version of SMF, or the settings that I've set for it, and not necessarily with Reviewpost.

Chuck S · August 17th, 2006, 12:15 PM

I ran your install and it resulted in a good install with your SMF which is why I posted the obvious reasons users have install issues and sorry if you think thats not the case but 99% of the time there are always issues with things not being answered correctly on install. Also a side note on install I saw also that per the install instructions your directory permissions had not been set correctly.

This looks fine to me just double check your directory permissions

http://nationsbestburgers.com/reviews/

Burgerman · August 17th, 2006, 06:03 PM

Quote:

Originally Posted by Chuck S

I ran your install and it resulted in a good install with your SMF which is why I posted the obvious reasons users have install issues and sorry if you think thats not the case but 99% of the time there are always issues with things not being answered correctly on install. Also a side note on install I saw also that per the install instructions your directory permissions had not been set correctly.

This looks fine to me just double check your directory permissions

http://nationsbestburgers.com/reviews/

The install instructions indicate that the permissions should be as follows:

images directory - 755
uploads directory - 777
help directory - 755
data directory - 777
data/1 directory - 777
data/2 directory - 777

Also it says that all php and sql files should be set to 644.

During installation, I set all these files/directories to the specified permissions, but when the installer checked my server, it gave me a red-text message saying that it could not write to config-inc.php or config-intr.php. So in order for the installation to proceed, I changed the permissions on these files to 666.

Was that an error on my part? If I followed procedure and kept those php files at 644, I would have to ignore the red-text warning in the install menu (and I wouldn't be able to make any changes to the files via the install process). If I went ahead and changed the permissions to 666, I would be ignoring the installation procedure as written. It's contradictory information like this which led to my frustration; I couldn't help wondering what else might be wrong.

I'm perfectly willing to admit mistakes. I make them enough, that's for sure. But what I don't need or appreciate is technical support that immediately assumes I am in error without any information either way.

At any rate, I went through the install procedure yet again. After customizing the config-inc.php file, uploading all the files, setting permissions (666 for config-inc.php and config-intr.php, 644 for the other files), and running the installation, after Step 4 I get the following errors above the "Step 5: Configuration Verification" form (again, XXX = my user name):

Quote:

Warning: fopen(/home/XXX/public_html/reviews/data/1/thumbs/index.htm): failed to open stream: Permission denied in /home/XXX/public_html/reviews/install.php on line 1028

Warning: fclose(): supplied argument is not a valid stream resource in /home/XXX/public_html/reviews/install.php on line 1029

Warning: fopen(/home/XXX/public_html/reviews/data/1/large/index.htm): failed to open stream: Permission denied in /home/XXX/public_html/reviews/install.php on line 1034

Warning: fclose(): supplied argument is not a valid stream resource in /home/XXX/public_html/reviews/install.php on line 1035

Warning: fopen(/home/XXX/public_html/reviews/data/2/thumbs/index.htm): failed to open stream: Permission denied in /home/XXX/public_html/reviews/install.php on line 1028

Warning: fclose(): supplied argument is not a valid stream resource in /home/XXX/public_html/reviews/install.php on line 1029

Warning: fopen(/home/XXX/public_html/reviews/data/2/large/index.htm): failed to open stream: Permission denied in /home/XXX/public_html/reviews/install.php on line 1034

Warning: fclose(): supplied argument is not a valid stream resource in /home/XXX/public_html/reviews/install.php on line 1035

I really have no clue what is going on here. I am able to verify everything on Step 5, and finish the installation, but I am unable to log-in using my SMF user name and password.

You mention that my permissions are in error. But they appear to be set correctly. Which directories are you referring to?

Burgerman · August 17th, 2006, 06:13 PM

When I attempt to go to the adm-index.php file after the install, I am asked for my UN and PW, which I enter (the same ones I use for SMF - they should work, right?), but I get an "invalid" user message. When I try to register, I get this message:

Quote:

Session verification failed. Please try logging out and back in again, and then try again.

I would like this to work. But it ain't workin. And I am out of ideas. And running out of patience.

Burgerman · August 17th, 2006, 06:19 PM

Okay. I tried logging in from the main page (reviews/index.php) and at first it gave me the same "invalid log-in" message. But then I clicked on the "login" button at the top and my UN and PW were accepted, and I finally made it to the friggin' admin page!

So, it appears to be working, although I'm worried about all those error messages on install and whether the problems they represent will affect users to my site. Forcing them to log-in several times will clearly be a deterrent to membership.

Burgerman · August 17th, 2006, 06:28 PM

So I make it to the Admin page but I can't do anything because I am forced to log-in anytime I select a task to do; and I keep getting the "invalid login" message.

Chuck S · August 17th, 2006, 06:52 PM

Our last tested version is SMF 1.06 as our integration thread states. You still have yet to set your data directory at every level to 777

You can PM with ftp phpmyadmin and reviewpost logins to do some testing on the integration part

Burgerman · August 18th, 2006, 06:46 PM

Okay. I ditched SMF because for some reason it was not playing nice with ReviewPost. I loaded phpBB2 and it seems to work very well so far.

I think because my web host offered SMF as an automatic install, it screwed things up somehow in regards to integration with ReviewPost. Anyway, it's gone and replaced, and things are working fine (I think).

This is not to say that SMF won't work with ReviewPost. The folks here say it does, and that's probably true most of the time, but in my situation, something went hinky.