BobRoberts123

I don’t know what you mean by “address you’re using” – do I change it to the internal address (192.168…), the external address that is being translated to the 192.168 address (209.184…), or to the domain name – https://www.thenameofthesite.com?

I’ve already changed it to the internal adddress and it doesn’t work. I constructed a detailed post reporting what is going on, but no one will respond to it. The document you link to above is too vague to help me.

Good question. Yes, the IP that the network administrator said was made public does start with 192.168, but the 9.999 is fictitious and stands for the real number. I noticed that a prior address that he had made public and worked (though this was with IIS) started with 209.184. That address did strike me as fishy – so, I I’ll go back to him and find out what the deal is.

I do have an addendum to my question. Once I do get a good external IP, should I make these additional changes to the conf\httpd.conf file to accomplish what I want (get the IP accessed externally)?:

Listen 192.168.9.999:80

<VirtualHost 192.168.9.999>
ServerAdmin [email protected]
DocumentRoot /www/nameofsite
ServerName server-name
ErrorLog logs/nameofsite-error_log
TransferLog logs/nameofsite.com-access_log
</VirtualHost>

I finally determined that it is indeed a different site – but learned a lot in finding that out. Thanks for your help.

Actually, I was able to reset my login to the local WordPress and view the text in the Administration Panel. It became obvious that the site was indeed a different rendition of the one currently on the web, so it appears this issue has been resolved.

Part of my problem is that I didn’t “install” WordPress – I just unzipped a file containing an already-existing WordPress site. The “Edit Users Table” in the Login Trouble site is what directed me to reset the password, which let me log on – thanks!

I’m not sure what happened – I rebooted and now it’s finding the WordPress login screen. The problem is that I don’t know what username and password it wants. The documentation appears to be no help, it just says, “log in” without telling you how to get a login.

I’m trying to username and password to the database in wp-config.php, and it doesn’t like those. I’m trying the username and password I use to login to this forum, and it rejects those. When I try to have my password emailed to me, it says that email address is not found, even though it’s the one associated with my forum account. Then I went to wordpress.com and signed up for a “blog”, putting in a username, password, and email. I’m able to log in to my “blog” administrative page, but when I try to use that username and password to log in to my local site, it thinks the username and passwords are invalid, and when I try to reset the password, it claims that, “ERROR: There is no user registered with that email address.”

The above must be an extremely difficult question! So I guess that it just isn’t me – there must be something very fundamentally complicated and inscrutable about viewing WordPress from this sort of perspective. Unfortunately, it seems to be necessary to get the site to perform as envisioned.

I’ll post another question about simply modifying the above text – maybe that will point me in a closer direction.

Well, I do need to know how to disable the plugin. I’ve found all sorts of vague references to doing that, but no specific instructions. Also, I’m puzzled about something – how can the Really-Static plugin be enabled if I can delete the …\plugins\really-static folder structure and have the WordPress site run the same, without an error? And if it’s not enabled, why do I have to concern myself with deleting it?

I’ll go ahead and post the results of your suggested tests above in trying to determine if the WordPress site can connect to the database:

Sunny, I know you suggest that the reason this WordPress site is running in “static-html” mode is because, “3. There is no alternative mode being triggered it is just because wordpress is not setup properly and as there is no database connection that is why it is displaying the file/folder structure in your site.”

But I tried a little test – I modified the wp-config.php and put in an invalid database password. If the site is displaying in static-html because it can’t log in to the database, then that would not have any effect – it would look the same. But when I did that, the site gives a “the website cannot display the page” error.

I decided to create a new database in phpMyAdmin (wpdb) and I remembered that before I had used utf8_unicode_ci, and so I made sure it said utf8_general_ci. I also had specified MYSQL323 in the “Format-specific options”, and this time I left it as “None”. I also used the “Privileges” tab in phpMyAdmin to setup a new user with an auto-generated password.

I followed your suggested tests above, deleting the wp-config.php, and want to comment that of course changing “Database Host” to “localhost:81” is not going to work, because only the web server is set to “localhost:81” – the database is at “localhost”. So, if I change the database server to “localhost:81”, with or without a password, it does nothing, trying to run “localhost” in the browser tab above.

If I leave the Datbase Host at “localhost”, and either blank out the password or put in a wrong one, I get:

“Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server

at localhost. This could mean your host’s database server is down.
?Are you sure you have the correct username and password?
?Are you sure that you have typed the correct hostname?
?Are you sure that the database server is running?”

And if I use an old database with an old user, I get:

Can’t select database

We were able to connect to the database server (which means your username and password is okay) but not able to select the newwordpressitedb

database.
?Are you sure it exists?
?Does the user pauser have permission to use the newwordpresssitedb database?
?On some systems the name of your database is prefixed with your username, so it would be like username_newwordpresssitedb. Could that be the problem?”

However if I use either an old database, new user and new auto-generated password or a new database, new user and new auto-generated password, I get this:

“All right sparky! You’ve made it through this part of the installation. WordPress can now communicate with your database. If you are ready, time now to…Run the Install”

When I click the Run the Install button, it then it tells me WordPress is already installed: “Already Installed

You appear to have already installed WordPress. To reinstall please clear your old database tables first.

Log In”

But the fact is, the site still displays different than the production one on the web, which, as I mention above, causes me to question whether I was given the current version of the site.

Hold off on this issue – I’ve compared the pages of the production on-line site and the one I’m displaying from the zip file, and I have found slight differences in wording. So what I could be looking at is an old version of the WordPress site – though I had brought this to the attention of the site administrator weeks ago with full screen shots, he says the zip reflects the current site.

In addition, there is a folder that seems to contain the “static-html” pages:

C:\wamp\www\newwordpressite\wp-content\plugins\really-static

Well, I deleted this entire folder, and it didn’t affect the way the site looks!

Yes, I’m using the full site that I’ve unzipped into the C:\wamp\www\newwordpresssite folder. I did stop the IIS services, but keep in mind that I installed Wamp to user localhost:81, and I changed the configuration files to reflect that, and that seems to work. I had rebooted my PC, and now I can run phpMyAdmin from the Wamp menu group. The WordPress database “newwordpresssitedb” I had created before is still there. The tables have names such as newwordpresssitedb_options, and the columns reflect the URL change in the 3 SQL queries I ran before. This is the first query:

UPDATE newwordpressite_options SET option_value = replace(option_value, ‘https://currentsite.com/newwordpresssite&#8217;, ‘https://localhost:81/newwordpresssite&#8217;) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

Could the problem be that phpMyAdmin is not asking for a login, so it isn’t clear what user is creating the database, loading it, and changing it, and if that user matches the one in the wp-config.php file? wp-config.php:

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘newwordpresssitedb’);

/** MySQL database username */
define(‘DB_USER’, ‘root’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘wp123456’);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

One question I have is the “MySQL hostname” above. I assume it should not be “localhost:81”, since it is referring to the MySQL server and not the web server.

I think I might have run this in the MySQL console:

UPDATE mysql.user
->SET Password=PASSWORD(“wp123456”)
->WHERE User=”root”;
mysql>FLUSH PRIVILEGES;

And I also made this change:
C:\wamp\apps\phpmyadmin3.4.5\config.inc.php:
$cfg[‘Servers’][$i][‘password’] = ‘wp123456’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

Is there any way to tell if the WordPress site is able to login to the newwordpresssitedb database? Or to simplify the login so it is more likely to work?

Thanks Sunny, and that is the first half of it, but I had to modify the C:\wamp\apps\phpmyadmin3.4.5\config.inc.php file for the following parameters:

$cfg[‘Servers’][$i][‘password’] = ‘yourpassword’;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

But even after doing that, the WAMPSERVER phpMyAdmin still won’t let me in. But fortunately, if I type “https://localhost:81/phpMyAdmin&#8221; in Firefox, that lets me in.

Well, at least in Wamp it lets me create a unique folder structure for my WordPress site, but it still displays the site in “static-html” mode – it does not look like the production WordPress site. The basic functionality is there, but it looks quite different. To reiterate, it has a folder structure of “C:\wamp\www\newwordpresssite\wp-content\plugins\really-static\static” that contains index.html files that are the ones displayed for all the pages. I presume that these display instead of the index.php files. Obviously, something somewhere is triggering or toggling this alternate display mode.

I went to “install” wordpress-3.3.1, and was surprised (or perhaps not so surprised) that all it did was create a WordPress folder structure – it’s not an actual install at all. Yet I had asked someone on the forum if it needed to be installed prior to my unzipping the exported site, and someone told me “yes”. So the lack of a true WordPress installation wouldn’t account for the site displaying in “static-html” mode.

I installed the WordPress site under WampServer, and it still displays in “static-html”mode. Big mystery at this point.

Uninstalled and reinstalled Wamp, and still getting the above error trying to go into MySQL.

Problem. After installing wamp and going into phpMyAdmin, I noticed that it didn’t ask for a username and password, even to create the wordpress mySQL database, which I was able to do. So then what am I supposed to put for the database username and password in the wp-config.php file? In order to give it something, I entered this in phpMyAdmin:

GRANT ALL PRIVILEGES ON newwordpressdb.* TO ‘root’@’localhost’ IDENTIFIED BY ‘pass12345’;

Subsequently any time I try to run the phyMyAdmin or MySQL console, it gives this error:

“#1045 – Access denied for user ‘root’@’localhost’ (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.”

In the MySQL console, it doesn’t even give you the opportunity to put in a password – only a username, and so doesn’t let you in there either. And, of course, in phpMyAdmin, it doesn’t ask for either a username or password.

Thanks, Sunny, I will try wamp. Not sure if I want to uninstall IIS though – I’ll see if I can get by with running them both.