[RESOLVED] db login change

TobyRT

Hi,

For one of my pages I have to log in to 2 databases - the CMS and the membership

The page loads by seeing if a user is logged in, and if ncessary connecting to the db to log them in. (using memconn.php)

It then connects to the CMS to bring content through for display (using cmsconn.php)

If the user is logged in, it uses an include to display user info. This include connects to the membership db again, and again uses memconn.php

The problem is that it tries to connect using the cmsconn.php credentials.

I've checked that it's finding memconn.php correctly, and it is. It also echoes the $dbhost/user/pass values correctly and gives the correct username and password for connecting to the membership db.

If I take the contents of memconn.php and paste them directly into the include, it works without a problem, but it won't work when I do a require_once("memconn.php");

Any idea how I can fix this please? I don't really want to hve the login credentials in the include!

Thanks

TobyRT

Hi guys,

I'm still wrestling with this - it happens every time I try to connect to this particular database?

Could someone please help?

There might be a pint in it for you?

Let me know what info you need, as I'm really not sure what to give!

Thanks in advance!

bradgrafelman

So.. you have two separate connections for two separate DB's? Why is this? Do you need different credentials to access them?

Without seeing the two conn .php files, we don't know how you're connecting/using these connections. Perhaps show us a bit of both, and how they are used?

TobyRT

Thanks Brad,

I'm afraid I DO need separate credentials - those're the rules of my host 🙂

The code, like me in many ways, is really very simple:

cmsconn.php

$cmshost = 'localhost';
$cmsuser = 'sypcms';
$cmspass = 'my_pass';
$cmsname = 'sypcms';

mysql_connect($cmshost, $cmsuser, $cmspass);
mysql_select_db($cmsname);

memconn.php is almost identical - just replace anything that says "cms" with "memm".

In my pages, the code would be along the line of:

<?php
//Check user is logged in and process login script
//this uses memconn.php succesfully with the code
//require_once("../includes/memconn.php");

include ("/logincheck.inc");

//now connect to the cms to get page/nav content
require_once("../includes/cmsconn.php");
mysql_query("select * from sypcms");

//now (on certain pages) connect to membership db again to retrieve user info allowing them to edit their profile
require_once("../includes/memconn.php");
mysql_query("select * from membership");

The problem is occurring with this second instance of memconn.php. I get the error message "Error in Query: .Access denied for user: 'sypcms@localhost' to database 'membership' " indicating that it's still trying to use the credentials from cmsconn.php, however when I echo those credentials as part of the page load process, it's bringing up the correct stuff.

If I just paste the contents of memconn.php directly into the page, it works fine!

I'm thinking (as I type) that require_once() might be part of the problem, but I don't know what to do about it!

Thanks again for your help!

TobyRT

Typical isn't it? You start researching something else and the solution pops up for you!

I didn't realise you can vary the connection used in the mysql_query.

I've always done something like:

$result = mysql_query("SELECT * FROM foo");

//or

$query = ("SELECT * FROM foo");
$result = mysql_query($query);

What I've just picked up on is the concept of:


$cmshost = 'localhost'; 
$cmsuser = 'sypcms'; 
$cmspass = 'my_pass'; 
$cmsname = 'sypcms'; 

$cmsconn = mysql_connect($cmshost, $cmsuser, $cmspass); 
mysql_select_db($cmsname); 

$query = ("SELECT * FROM foo");

//this is my revelation :)
$result = mysql_query($query, $cmsconn);

Changing my code thusly appears to have done the trick, but I'd still love to know why it wasn't picking up the other variables properly...

How will I learn otherwise 😉

bradgrafelman

Either way, if you're going to have two connections to a database, it is definitely to your advantage to store these connection resources into a variable and explicity specify which connection to use when querying the databases.

Don't forget to mark this thread resolved.