PhotoPost Community - Install Problem

PhotoPost Community (http://www.photopost.com/forum/)

- ReviewPost Installation & Upgrades (http://www.photopost.com/forum/reviewpost-installation-upgrades/)

- - Install Problem (http://www.photopost.com/forum/reviewpost-installation-upgrades/109802-install-problem.html)

Ok, I've tried everything I can think of and I can't get passed this error.

Quote:

Warning: mysql_connect(): Access denied for user: 'hpisavag_@localhost' (Using password: YES) in /home/hpisavag/public_html/tempforum/PhotoPost/install.php on line 258

I check the mysql and hpisavag_ has all privliges. I'm so confused it's not even funny. Also where are you supposed to upload the PhotoPost folder. the instruction don't say so I uploaded it to the forum folder.

any help would be great
thanks,

You upload it to where you want it. Most likely a subfolder like gallery on your site unless it is the only thing on your site which means you might put it as the root

Now as far as your mysql you have entered something incorrect

If the user is correct make sure you entered the right password and proper database name and that user has access to that database

Also make sure the localhost is right as some servers have a setting other than localhost to mysql

hmm, ok, I'll have to figure that out. The original admin/owner that did all the stuff to the forum decided he wasn't out and gave me all the login and pass word info. So I'm tryin to pick up where he left off, and it's takin some time to figure everything out.

If you have a forum that the product shares a database with you can cheap and get the connect info from the forums config file ;)

well, I tried that and I still gettin the same error. Here is the code for the forum which works perfectlly.

Quote:

Originally Posted by Code From Forum's config.php

// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'localhost';

// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = 'hpisavag_admin';
$dbpassword = 'pa$$word';

// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'hpisavag_hpisavagvbulletinTest';

And here is the code for config-inc.php.

Quote:

Originally Posted by Code From PhotoPost's config-inc.php

// Path to your PhotoPost installation - no end slashes
$PP_PATH = "home/hpisavag/public_html/tempforum/PhotoPost";

//**************** MySQL Database Configuration ****************//

// PhotoPost database host address, or leave as localhost
$host="localhost";

// PhotoPost's database name
$database="hpisavag_hpisavagvbulletinTest";

// MySQL username and password to access PhotoPost's database
//
// These two variables are for the userid and password needed to access
// the PhotoPost database named above.
$mysql_user="hpisavag_admin";
$mysql_password="pa$$word";

// User database host address, or leave as localhost
$host_bb="localhost";

// If you want to use a prefix for your database, enter it here.
// NOTE: This variable can only be set PRIOR to your first installation of PhotoPost;
// existing databases will not be changed and you will be unable to connect if you change
// this variable after performing a default installation.
$pp_db_prefix = "";

// User database MySQL database name
//
// This is the variable for the User Database; if you are using Internal
// as your registration system, then these variables are the same as the
// ones above. If you are linking to a message board system,
// thse variables should be set to the database, user and password for that
// database.
$database_bb="hpisavag_hpisavagvbulletinTest";

// MySQL username and password to access user database
//
// These two variables are for the userid and password needed to access
// the PhotoPost or BB database.
$user_bb="hpisavag_admin";
$password_bb="pa$$word";

opps I notice that the error is for hpisavag_@localhost. I've tried both of them hpisavag_ and hpisavag_admin. both of them have all privliged and both of them get the same error.

Here is what I have for mysql

Quote:

hpisavag_hpisavagvbulletinTest
Users in hpisavagvbulletinTest

hpisavag_ (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:hpisavag_hpisavagvbulletinTest:localhost","hpisavag_","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "hpisavag_", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("hpisavag_hpisavagvbulletinTest");

hpisavag_admin (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:hpisavag_hpisavagvbulletinTest:localhost","hpisavag_admin","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "hpisavag_admin", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("hpisavag_hpisavagvbulletinTest");

well, I guess I'm gonna have to call!

We would not know your mysql settings. All I can say is for you to verify your mysql connection information

Are you using another database for Photopost other than Vbulletin?

No, We planned on usin the same database.

Well then as long as your connection info is the same as VB from their config file you should be fine installing. You can also try adding another user to the database say photopost and try it that way

allright I'll try that. I have them as the same as the forum's config.php, which I listed up there. I have a feelin that we will get the installation service and let you guys do it if I can't figure it out by then.

Okay I have no idea if the mysql is the same why it would not work thus the suggestion of creating a new user to that database

Man, I have no clue. I tried making a new user, I tried a different database, I tried copyin the info from the Forum's config and none work. The weird thing is I just tried another hack(phpAds) and it asked for the same info as this PhotoPost does and it got to the database with now problem. So I have no clue.

Quote:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock:3306'

Thats the connection I use on countless databases including forums and thye all work without fail. Something is up with the install.

what port do you use? is it different than 3306?

Pretty sure it is the standard port.

# netstat -an |grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

All vb, phpads, phpmyadmin, etc. install without problem using that connection.

Ok I've taken the port out of the install file and it seems to connect, but now I get a different config error, one you might be able to help with.

-------
Failed MySQL Query: [Resource id #5]:UPDATE rp_settings SET setting='vb3' WHERE id=41
Error: Table 'vbdatabase.rp_settings' doesn't exist
-------

I'm having trouble understanding why its putting the vbdatabase there, when it should be the review post database.rp_settings, because thats what its installing. Of course the VB user db is not going to have the table rp_settings.

Weird error. Taking the port number out of the install file on line 880 can't be the cause of this?

Ok installation worked.
Here is the solution if you connect to databases like I do.

LEAVE the review or photo post (this case reviewpost) connection as:
$host ="localhost";

when you use the vb database use the connection you do for VB.

in my case it was:
$host_bb="localhost:/var/lib/mysql/mysql.sock";

That makes no sense at all what your trying to do or posted above especially adding the mysql socket path in the host statement.

If you have a proper database with proper user permissions set up for reviewpost you should connect to it. I have done on tons upon tons of installs and as long as you enter the proper mysql info things are fine.

Any errors are always user error whether it be a wrong user or password or host for the mysql settings or the wrong table prefix.

If you look at the mysql site which backs me up here you will see by also looking at the code in our pp-inc.php file here

$db_link = mysql_connect("$host_bb", "$user_bb", "$password_bb")

that this is the way to connect to a mysql database. As long as you enter the proper information it will connect. There is no mystery and is the same format VB phpADS and others use as well.