"The website declined to show this webpage" error

**AnthonySterling** · Oct 19, 2010 04:37

Ah ah, good.

So, next step then.

Place the following in the script, edit the $database settings (hostname, username, password, schema) at the top accordingly and upload.

PHP Code:


<?php
error_reporting(-1);
ini_set('display_errors', true);

/*
  Edit these
*/
$database = array(
  'hostname'  => 'localhost',
  'username'  => 'anthony',
  'password'  => 'super-secret',
  'schema'    => 'my_cms'
);

$conn = mysql_connect(
  $database['hostname'],
  $database['username'],
  $database['password']
);

if(false === is_resource($conn)){
  echo 'Cannot connect to database: ' . mysql_error() ;
  exit;
}

if(false === mysql_select_db($database['schema'], $conn)){
  echo 'Cannot select schema: ' . mysql_error() ;
  exit;
}
?>
<html>
  <head>
    <title>Test</title>
  </head>
  <body>
    <h1>
      Connected successfully!
    </h1>
    <p>
      <?php printf("MySQL server version: %s", mysql_get_server_info($conn)); ?>
    </p>
  </body>
</html>

What do we get now?

**calicouk** · Oct 19, 2010 04:58

it doesn't seem to be returning anything

**AnthonySterling** · Oct 19, 2010 05:01

Are you using 'localhost' as the hostname? If so, try changing it to '127.0.0.1' and give that a go.

Very strange.

**calicouk** · Oct 19, 2010 05:23

afraid i'm still not getting anything...

**AnthonySterling** · Oct 19, 2010 05:24

You're still getting a denied message?

If it hasn't beaten you into submission yet, can you post the output of this script please?

PHP Code:


<?php
error_reporting(-1);
ini_set('display_errors', true);
?>
<h3>
  Available extensions
</h3>
<ul>
  <?php foreach(get_loaded_extensions() as $extension): ?>
    <li>
      <?php echo $extension; ?>
    </li>
  <?php endforeach; ?>
</ul>

**calicouk** · Oct 19, 2010 05:32

ha , I probably would have been but I need to try and work out if the issue lays at our door or if it's the IT company who need to fix something.

Like I say - very grateful for your help on this.

This is what the script outputs:

Available extensions

* date
* libxml
* openssl
* pcre
* zlib
* bz2
* calendar
* ctype
* hash
* filter
* ftp
* gettext
* gmp
* session
* iconv
* pcntl
* readline
* Reflection
* standard
* shmop
* SimpleXML
* SPL
* sockets
* exif
* tokenizer
* xml
* cgi-fcgi
* imagick
* bcmath
* curl
* dbase
* dom
* gd
* imap
* json
* mbstring
* mcrypt
* mysql
* mysqli
* PDO
* pdo_mysql
* pdo_sqlite
* soap
* SQLite
* wddx
* xmlreader
* xmlwriter
* xsl
* zip
* ionCube Loader
* Zend Optimizer

**AnthonySterling** · Oct 19, 2010 05:41

Ok, let's try using MySQLi then instead as a last ditch attempt.

PHP Code:


<?php
error_reporting(-1);
ini_set('display_errors', true);

/*
  Edit these
*/
$database = array(
  'hostname'  => 'localhost',
  'username'  => 'anthony',
  'password'  => 'super-secret',
  'schema'    => 'my_cms'
);

$conn = mysqli_connect(
  $database['hostname'],
  $database['username'],
  $database['password'],
  $database['schema']
);

if(false === ($conn instanceof MySQLi)){
  echo 'Cannot connect to database: ' . mysqli_connect_error() ;
  exit;
}
?>
<html>
  <head>
    <title>Test</title>
  </head>
  <body>
    <h1>
      Connected successfully!
    </h1>
    <p>
      <?php printf('MySQL server version: %s', mysqli_get_server_info($conn)); ?>
    </p>
  </body>
</html>

**calicouk** · Oct 19, 2010 05:52

urgh - getting :

Warning: mysqli_connect() [function.mysqli-connect]: (28000/1045): Access denied for user '***'@'localhost' (using password: YES) in /data/www/vhosts/***/***/***/second_homes_edit.php on line 20
Cannot connect to database: Access denied for user '***'@'localhost' (using password: YES)

same password etc as else where, I don't use the schema in the other config file though

**AnthonySterling** · Oct 19, 2010 06:12

Yay, this is good - progress... Kinda.

So, you're saying the host, username, password and schema that you're using are definitely correct? The error message suggests otherwise.

Anthony.

**calicouk** · Oct 19, 2010 06:44

everything apart from the schema is definitely ok.

The schema I assume is essentially the db name, which if it is - should be correct...

Sorry to ask for clarification on this but wanting to be certain

**AnthonySterling** · Oct 19, 2010 06:48

Are you saying you can connect successfully, with the same credentials, using a different script? Yeah, the schema is database name.

**calicouk** · Oct 19, 2010 07:43

well.. yes. The front end still works fine and the content of the front end is all
content generated from the database.

All the files essentially start with this include:

PHP Code:


<?php



$con = mysql_connect("localhost","***","***");

mysql_select_db("***", $con);



?>

What's even stranger is that I can still edit certain other things through the cms

**AnthonySterling** · Oct 19, 2010 08:01

Then I have no idea, I'm out.

Maybe another member can help and/or offer some more advice?

**calicouk** · Oct 19, 2010 08:28

great no problem - your help and advice was much appreciated.

I think the problem here is with coniguration of the database. I will let you know once concluded - hopefully soon ; )

**rguy84** · Oct 19, 2010 08:33

cali make a new file, have it only have as its contents.

PHP Code:


<?php  



$link = mysqli_connect('localhost', 'fake_user', 'my_password', 'my_db');



if (!$link) {

    die('Connect Error: ' . mysqli_connect_error());

}

?>

**calicouk** · Oct 20, 2010 07:44

Hi Ryan,

thanks for your response, the IT company are checking the site today so have asked me not to change anything.

Will try tomorrow if no joy.

**rguy84** · Oct 20, 2010 08:09

Hi Cali,

I cannot speak for hosts. My host, you have to create a hostname for your database, so mydb.example.com, and you use that vs localhost for your host.

User Tag List

Thread: "The website declined to show this webpage" error

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions