Cant connect to Photopost database

[stingray352796]

Hi Chuck,
thanks for the help on my path issues yesterday. I'm learning. Next issue: reading through the posts I see most people that have trouble with db connections have the config.inc database parms wrong. I'm getting the same:

Could not connect to PhotoPost databaseAccess denied for user: 'vettescene@localhost' to database 'vettescene_vettescene'

I've gone back through the parms several times and I think they are correct:

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

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

// 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="vettescene";
$mysql_password="74990396";

// 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 = "pp_";

// 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="vettescene_vettescene";

// 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="vettescene";
$password_bb="74990396";

The thing is, these are exactly the same parameters in the VB config.php, but I can get into VB just fine:

// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'vettescene';
$config['MasterServer']['password'] = '74990396';

I also get the same access denied if I change to a regular mysql user/pswd and not the master.

Your expertise would again be appreciated!!!

Sorry for the lengthy post


thanks
Lee

[Chuck S]

You need to verify your mysql setup on the new server. Most likely the database user or password is incorrect.

You sure the user is not this?

vettescene_vettescene

Usually on servers that prefix database names they also prefix the usernames

[stingray352796]

Hi Chuck,
I tried it, same results. Also for VB, the user name is 'vettescene', and I get in fine. Could this have something to do with the new database type being mysqli? When I change that setting to 'mysql' in vb config.inc tho, I get a database error trying to get into VB where as with 'mysqli' I get in fine. Is there a database 'type' setting somewhere in the photopost configs? On my localhost environment where I migrated from the database type was 'mysql'.
thanks, I know you are beyond your day

[Chuck S]

mysqli or mysql should not matter I think

You have checked that the host database name user and password are the same under both config spots in photopost config-inc.php file?

Helps to provide a link also to your gallery

[stingray352796]

Hi Chuck,
Yes, the user & password are the same. The problem was the Mysql5 connection settings for my host site needed to be localhost:/tmp/mysql5.sock, for the database host address. That got me past the connection error to the admin cp, but now all of the links in the navbar are pointing to my old localhost environment so obviously it cant find any of them. What file would I find all of those links to change to the new host path? Plus I'm getting these errors on the top of the admin page:

Warning: opendir(C:/Program Files/xampp/htdocs/photopost/data/) [function.opendir]: failed to open dir: No such file or directory in /home/vettescene/www/www/photopost/adm-inc.php on line 691

Warning: readdir(): supplied argument is not a valid Directory resource in /home/vettescene/www/www/photopost/adm-inc.php on line 694

Warning: closedir(): supplied argument is not a valid Directory resource in /home/vettescene/www/www/photopost/adm-inc.php on line 711

Obviously pointing to my old localhost environment

[Chuck S]

As noted in that HOW TO MOVE SERVERS THREAD I linked you to in your email you sent you need to in admin global options and storage options update your data server paths to the correct new one like so.

/home/vettescene/www/www/photopost/data/

[stingray352796]

Hi Chuck,

Here is where I am since this is getting really confusing:

1. I have changed the paths in the config.int (exactly as you show above)and resolved the database connection issue in config.inc.
2. Last night I was able to get in to the admin cp but could not use any of the functions since when I click on any of them, it would show a link to my old localhost environment. Therefore I cannot do anything in the cp. Thats why I was asking where I could update all of those paths to the new host paths /home/vettescene/www/www/photopost/ etc.
3. Now, I cannot login at all to the cp, and when doing so again, it shows a link to my old site (http://localhost/photopost/misc.php instead of http://vettescene.com/photopost/misc.php
Here are the links:
site: vettescene.com and if you then click on Photos on the nav bar you see Photopost come up with all the wrong links.
for the admin cp:
user: stingray35
pswd: vspw1970%&MINE&
and you'll see what I am referring to above

thanks for your help and patience!

[stingray352796]

Hi Chuck,
The site URL needs a index.php to come up (vettescene.com)

[stingray352796]

Chuck,
Here is the stuff from my config.int:

// We need to know the server paths to both your vB installation and your PhotoPost installation
$vbpath = "/home/vettescene/www/www/forums";
$pppath = "/home/vettescene/www/www/photopost";

// We need the URL path to your PhotoPost and vb installation
$url_path = "http://vettescene.com/photopost";
$vb_urlpath = "http://vettescene.com/forums";

[Chuck S]

This has nothing to do with config files.

How to Move Servers and/or Change Directories

You can essentially rerun the install script and overwrite settings in the database to fix your issue and gain access to admin.

[stingray352796]

Hi Chuck,
Ok, now I've rerun the install script, as you recommended, and now when I try to bring up the adm cp I get the cp login screen. If I'm using VB's users and I'm also logged into the admincp for VB, I dont know why its asking for user and password in Photopost. In the past its gone directly to the cp panel (when I had it running in localhost).So I used the user/pswd for VB admin and instead of it bringing up the admin cp it brings up the Photopost page in my site! Which, by the way looks good. If I click on Admin in the Photopost page it goes back to the same login screen and I still cannot get in to the cp.
Is there a procedure for uninstalling Photopost such that it removes the tables from VB and I could basically start over? It may take less time than to continue to fix one thing after the next ,etc.

What do you think?

thanks!

[Chuck S]

Are you sure you specified the correct vb license number not customer number on config and on step 4 the correct vb cookie prefix

sounds to me like you did not

try reinstalling with the correct info. You dont want to start over because you will lose everything.

[stingray352796]

Chuck,
Step:1 license is good
Step: 4 added cookie prefix bb - hadnt done that before
Step:5 reset all the server and url paths where necessary - maybe I missed something before
Brought up the adm-index logged in with same creds as VB admincp - it went to my sites Photopost main page, and when I click on Admin I get into the CP!!!

It's enough to make a grown man cry - you made my day!!

Lee

[Chuck S]

have a good weekend glad to assist.