Using the extension

Having a problem - bought this to use because of reason below

I am using Xxamp locally. My user name is ROOT and my Password is authorise - no problems and I use the same login for all sites locally.

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_chesterbeer = "localhost";
$database_chesterbeer = "chesterbeer";
$username_chesterbeer = "root";
$password_chesterbeer = "auth0r1se";
$chesterbeer = mysql_pconnect($hostname_chesterbeer, $username_chesterbeer, $password_chesterbeer) or trigger_error(mysql_error(),E_USER_ERROR);
?>


However on my Web Server I AM NOT ALLOWED TO USE ROOT

So my connections file for the server has to be


<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_chesterbeer = "localhost";
$database_chesterbeer = "chesterbeer";
$username_chesterbeer = "chesterbeer";
$password_chesterbeer = "auth0r1se";
$chesterbeer = mysql_pconnect($hostname_chesterbeer, $username_chesterbeer, $password_chesterbeer) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Please can you tell me how to enter this in Dynamic Connections. When I entered as above I got problems . I set up the Local data in the main connection and the Live Server date on the additional connections - but it doesnt work

At the moment - I have to go into my connections file and change the user name to ROOT to do my local testing - and then I am having to change it back to chesterbeer and having to re ftpo the file for it to work on the LIVE server. I had hoped this was the solution.

Please advise where i am going wrong

Thank you

That first screen looks correct. What did you enter on the additional connections tab?

On the second connnections tab I entered

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_chesterbeer = "localhost";
$database_chesterbeer = "chesterbeer";
$username_chesterbeer = "chesterbeer"; ** Instead of ROOT on my local server**
$password_chesterbeer = "auth0r1se";
$chesterbeer = mysql_pconnect($hostname_chesterbeer, $username_chesterbeer, $password_chesterbeer) or trigger_error(mysql_error(),E_USER_ERROR);
?>

Hi

Try to use the IP for the remote host. I don't own the script, but seeing that both local and remote host names are set to "localhost" seems to be a possible reason for your problem.

HTH

Willi

I think you may be overlooking the additional connections tab in the UI? Do you have a screen shot of what you have entered in that tab of the UI?

This post has been deleted.

Hi Ray

Please find attached new screen grab showing both screens
of the GUI

Regards

John

It looks like it is a problem with the value you have in the "For Domains" field on the second page. This value should be the domain that appears in the url of the site where you want to use this dynamic connection.

Please see below Ray
. I have entered the full URLK but srill this will not connect. Here is the code from the Connections file

<?php
# FileName="WADYN_CONN.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Cumberland = "localhost";
$database_Cumberland = "cumberland";
$username_Cumberland = "root";
$password_Cumberland = "author";
@session_start();
$foundConnection = false;
if ($foundConnection == false) {
$domains = explode(",","http://www.cumberlandpackaging.co.uk");
for ($domindex = 0; $domindex<sizeof($domains) && !$foundConnection; $domindex++) {
$domainCheck = trim($domains[$domindex]);
if (strpos(strtolower($_SERVER["SERVER_NAME"]),strtolower($domainCheck)) !== false && ($domainCheck == "" || strpos(strtolower($_SERVER["SERVER_NAME"]),strtolower($domainCheck)) == strlen($_SERVER["SERVER_NAME"])-strlen($domainCheck))) {
$hostname_Cumberland = "localhost";
$database_Cumberland = "cumberland";
$username_Cumberland = "cumberland";
$password_Cumberland = "author";
$foundConnection = true;
}
}
}

$Cumberland = mysql_pconnect($hostname_Cumberland, $username_Cumberland, $password_Cumberland) or trigger_error(mysql_error(),E_USER_ERROR);

?>

Please can you tell me why this doesnt work. I only want to be able to connect with

user name: root locally

user name : cumberland on the live server

Thanks

Can you confirm that you have visited your remote site's control panel, and in the database/mySql section of the control panel, that you have created a database called 'cumberland', a username 'cumberland' and set up that username with a password 'author' ?

Very often the database prefix is set by the account itself.