Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 13, 2013 04:54PM

I set my machine to a static IP address , for example: 129.0.30.100

I set the static IP address for the entire application sharing my home network .

So first of all I modified the httpd.conf file
     Allow Order
     Allow from all
is correct to write that?
I should change any other parameter ?

I set up a user in the database with the following characteristics:
User: root
Host: localhost
Password: Yes
Global Privileges : ALL PRIVILEGES

To connect to my database (I used wordpress ) :
/ ** The name of the database for WordPress * /
define ( ' DB_NAME ' , ' wp_wordpress ');

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

/ ** MySQL database password * /
define ( ' DB_PASSWORD ' , ' wpPassRoot ' ) ;

/ ** MySQL hostname * /
define ( ' DB_HOST ' , '127 .0.0.1 ');

Obviously there is a mismatch between the settings of phpMyAdmin and Wordpress :
- In the first as I host localhost
- In the second I 127.0.0.1

I ask this because I notice a slowness in using the system , especially with Internet Explorer 9 on Windows Server 2008 R2 64bit.

Thank you.



Edited 1 time(s). Last edit at 11/13/2013 05:00PM by robertosalemi.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 13, 2013 06:26PM

Hi Roberto,


First, what versions of WAMP Server and APACHE are you using????




I set the static IP address for the entire application sharing my home network .
Not sure what this actually means?

Do you mean you use 'http://192.168.0.100' when you try to access your site from another PC?

So first of all I modified the httpd.conf file
Allow Order
Allow from all
is correct to write that?
I should change any other parameter ?


There is more than one place in the httpd.conf file that contains security settings like this !!!!

Exactly which ones did you change?

The syntax for Apache 2.2 is either

    Order allow,deny
    Deny from all
OR
    Order Deny,Allow
    Deny from all
Then either
    Allow from all
OR a better ways to do it woudl be to specify the first 3 quartiles of the IPV4 ip address
which will allow any PC on your router access BUT NOT THE UNIVERSE
    Allow from 127.0.0.1 ::1 192.168.2




I set up a user in the database with the following characteristics:
User: root
Host: localhost
Password: Yes
Global Privileges : ALL PRIVILEGES


Actually WAMPServer or rather MySQL comes with the 'root' user already setup. Well 3 of them actually, root@127.0.0.1, root@localhost and root@::1 and none of them have a password by default. So I assume you added a password to at least one of the re-existing root userids.


Thats a good idea as it keeps your site a little more secure. It woudl be better to create a new userid just for the wordpress site and only allow that userid access to the one database you create for that site, but your way will work.


Now if you only set a password on root@localhost then when you use root@127.0.0.1 in the Wordpress site with a password it probably wont work. you need to set the password for each user@host pair.




Regarding slow running Wordpress, If you are using
/ ** MySQL hostname * /
define ( ' DB_HOST ' , '127 .0.0.1 ');

That is that fastest method, and better than using localhost.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.10-87-r.retail.telecomitalia.it)
Date: November 14, 2013 12:16AM

I'm sorry, I'm using the version of Wampserver 2.4

That's right, I set a static IP on my computer so who enter [129.0.30.100] display my website.

The httpd.conf file I changed the line:
     #
     # Controls who can get stuff from this server.
     #

I can send you the file httpd.conf in order to examine it?

phpMyAdmin
I modified the existing user, the root user (host: localhost).
So I have to set the password for all existing root users?

Tomorrow change the host of my DB in Wordpress wp-config.php and see if anything changes.

For the moment, thanks.



Edited 1 time(s). Last edit at 11/14/2013 09:39AM by robertosalemi.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 11:53AM

Roberto,

MySQL Users:

We tend to think of a mysql user as a userid, like 'root' for example.

However MySQL thinks of a user as a userid that is connecting from a location (host).
So a complete MySQL Userid is userid@host.

So as in the case of the root userid that comes by default with a MySQL installation it is actually 3 userid's

root@localhost
root@127.0.0.1
root@::1

It just happens that each of these HOSTS is actually 3 different ways of addressing the local PC.

Now each of these userid can have its own password and the password is unique to the userid@host instance.


So you could have

root@localhost with a password of 'aaa'
root@127.0.0.1 with a password of 'bbb'
root@::1 with a password of 'ccc'

And if you wanted to allow root to login from a PC somewhere else in the world you could also setup a new userid as

root@111.222.333.444 with a password of 'ddd'
And then you woudl be able to signin as root from that ONE SPECIFIC ip address somewhere else in the world, whereever that may be, but only from that ip address.


Hope this helps in your understanding of MySQL Userid's

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.xeniaprogetti.it)
Date: November 14, 2013 12:03PM

Hello,
then saw that my IP address is 129.0.30.100 is correct if:
- PhpMyAdmin create a user root@129.0.30.100 and Password;
- And I write on Wordpress
define ('DB_HOST', '129 .0.30.100 ');

The configuration file httpd.conf is correct?

Thank you for your availability.



Edited 1 time(s). Last edit at 11/14/2013 12:04PM by robertosalemi.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 14, 2013 03:30PM

I ran another test:

I installed Wampserver 2.4 64bit on another computer with Windows 7 64bit.

I open Firefox and Chrome: I type [localhost], I see the home page of Wampserver.

I open Internet Explorer 9: I type [localhost], the broser goes in a loop and I can not see the home page of Wampserver.

Why?

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 05:15PM

What is in the HOSTS file of this new computer.

c:\windows\system32\drivers\etc\hosts

Post it its not a security risk

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 14, 2013 05:21PM

Here it is:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

# localhost name resolution is handled within DNS itself.
#	127.0.0.1       localhost
#	::1             localhost

127.0.0.1       localhost
127.0.0.1       localhost
127.0.0.1       localhost

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 05:26PM

Try

127.0.0.1 localhost
::1 localhost

Whats probably happening is Chrome and FF are using IPV4 and IE has decided to use IPV6 (i.e. ::1 ) but you dont have localhost defines on IPV6

Browsers, especially IE tend to use the IPV6 and IPV4 address range, but I have no idea why it picks one over the other and when.

If this is the problem, try with no changes to use IE with address 'http://127.0.0.1' and it should show the WAMP homepage.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 14, 2013 05:42PM

RiggsFolly, It does not work.

There is a tutorial that allows me to simply configure the httpd.conf file avenvo a computer that has IP Static and dynamic?

Thank you.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 06:04PM

Please make sure you have the latest version of all of these Microsoft C++ Redistributable runtime libraries.

The 2008 Redist is used by wampmanager
The 2010 Redist is used by some versions of Apache ( depending on compiler used )
The 2012 Redist is used by some versions of Apache ( depending on compiler used )

FOR WAMP 32bit
Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) [www.microsoft.com]
Microsoft Visual C++ 2010 SP1 Redistributable Package (x86) [www.microsoft.com]

If you are using WampServer 2.4
Microsoft Visual C++ 2012 [www.microsoft.com]
And select vcredist_x86.exe


FOR WAMP 64bit
Microsoft Visual C++ 2008 SP1 Redistributable Package (x86) [www.microsoft.com]
Yes you need the x86 Package regardless
Microsoft Visual C++ 2008 Redistributable Package (x64) [www.microsoft.com]
Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) [www.microsoft.com]
If you are using WampServer 2.4
Microsoft Visual C++ 2012 [www.microsoft.com]
And select vcredist_x64.exe

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 06:05PM

Also check all the error log's for any useful information

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 14, 2013 06:10PM

Yes, I have the latest version of the Microsoft C + + Redistributable, I had to install WampServer to start, otherwise the icon was always red.

Which LOG file should I see?
What Apache?

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 14, 2013 09:51PM

Well check all of them to see if they give any help

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.18-87-r.retail.telecomitalia.it)
Date: November 15, 2013 12:31AM

Ok, tomorrow check them one by one and see if anything changes.

But beyond all, I do not think that it can depend on this.

Behavior so different across different browsers!

Thank you.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 15, 2013 10:08AM

Hello,
I'm sorry to bother again.
Today I made ​​another test:
- Now 9:52: I open the site with Firefox;
- Now 9:57: I opened the site with Internet Explorer 9, stoppato da me dopo 2 minuti.

Carry the LOG file, could you help me to understand if you notice any line is not good?

mysql.log
2013-11-15 09:52:03 4732 [Note] Plugin 'FEDERATED' is disabled.
2013-11-15 09:52:03 4732 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-15 09:52:03 4732 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-11-15 09:52:03 4732 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-15 09:52:03 4732 [Note] InnoDB: Not using CPU crc32 instructions
2013-11-15 09:52:03 4732 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-11-15 09:52:03 4732 [Note] InnoDB: Completed initialization of buffer pool
2013-11-15 09:52:03 4732 [Note] InnoDB: Highest supported file format is Barracuda.
2013-11-15 09:52:04 4732 [Note] InnoDB: 128 rollback segment(s) are active.
2013-11-15 09:52:04 4732 [Note] InnoDB: Waiting for purge to start
2013-11-15 09:52:04 4732 [Note] InnoDB: 5.6.12 started; log sequence number 56665189
2013-11-15 09:52:05 4732 [Note] Server hostname (bind-address): '*'; port: 3306
2013-11-15 09:52:05 4732 [Note] IPv6 is available.
2013-11-15 09:52:05 4732 [Note]   - '::' resolves to '::';
2013-11-15 09:52:05 4732 [Note] Server socket created on IP: '::'.
2013-11-15 09:52:05 4732 [Note] Event Scheduler: Loaded 0 events
2013-11-15 09:52:05 4732 [Note] wampmysqld: ready for connections.
Version: '5.6.12-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

php_error.log
empty

apache_error.log
[Fri Nov 15 09:52:02.574241 2013] [mpm_winnt:notice] [pid 1924:tid 404] AH00455: Apache/2.4.4 (Win64) PHP/5.4.12 configured -- resuming normal operations
[Fri Nov 15 09:52:02.574241 2013] [mpm_winnt:notice] [pid 1924:tid 404] AH00456: Server built: Feb 22 2013 22:08:37
[Fri Nov 15 09:52:02.574241 2013] [core:notice] [pid 1924:tid 404] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d C:/wamp/bin/apache/Apache2.4.4'
[Fri Nov 15 09:52:02.589865 2013] [mpm_winnt:notice] [pid 1924:tid 404] AH00418: Parent: Created child process 4560
[Fri Nov 15 09:52:03.996088 2013] [mpm_winnt:notice] [pid 4560:tid 304] AH00354: Child: Starting 150 worker threads.
[Fri Nov 15 09:59:29.737530 2013] [mpm_winnt:warn] [pid 4560:tid 1620] (OS 64)The specified network name is no longer available.  : AH00341: winnt_accept: Asynchronous AcceptEx failed.

access.log
129.0.30.100 - - [15/Nov/2013:09:52:07 +0100] "POST /wp_xenia/wp-admin/admin-ajax.php HTTP/1.1" 200 47
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/jquery-collapse-o-matic/light_style.css?ver=1.5.2 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/dark/style.css?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/standard/style.css?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/thumbnails/style.css?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/contact-form-7/includes/css/styles.css?ver=3.5.4 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/recent-posts-slider/css/style.css?ver=3.6.1 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/jquery-collapse-o-matic/js/collapse.min.js?ver=1.5.2 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/custom/style.css?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-includes/css/admin-bar.min.css?ver=3.6.1 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:10 +0100] "GET /wp_xenia/ HTTP/1.1" 200 47582
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/default/style.css?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/themes/architecture/js/superfish.js?ver=3.3.1 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/themes/architecture/js/smthemes.js?ver=1841 HTTP/1.1" 200 9111
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/contact-form-7/includes/js/jquery.form.min.js?ver=3.45.0-2013.10.17 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-includes/js/admin-bar.min.js?ver=3.6.1 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/libs/cycle2/jquery.cycle2.min.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/libs/cycle2/jquery.cycle2.carousel.min.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/libs/cycle2/jquery.cycle2.tile.min.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/custom/script.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/dark/script.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/libs/cycle2/jquery.cycle2.video.min.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/default/script.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/standard/script.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-includes/js/comment-reply.min.js?ver=3.6.1 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/js/client.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/templates/thumbnails/script.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/cyclone-slider-2/libs/cycle2/jquery.cycle2.swipe.min.js?ver=2.7.6 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/contact-form-7/includes/js/scripts.js?ver=3.5.4 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/uploads/2013/11/focusFormazione.png HTTP/1.1" 200 151725
129.0.30.100 - - [15/Nov/2013:09:52:14 +0100] "GET /wp_xenia/wp-content/plugins/my-custom-css/my_style.css?1384427516 HTTP/1.1" 304 -
129.0.30.100 - - [15/Nov/2013:09:52:15 +0100] "GET /wp_xenia/chi-siamo/dove-siamo-e-contatti/ HTTP/1.1" 200 46327
129.0.30.100 - - [15/Nov/2013:09:55:22 +0100] "POST /wp_xenia/wp-admin/admin-ajax.php HTTP/1.1" 200 47
129.0.30.100 - - [15/Nov/2013:09:59:29 +0100] "POST /wp_xenia/wp-admin/admin-ajax.php HTTP/1.1" 200 47
129.0.30.100 - - [15/Nov/2013:09:59:29 +0100] "POST /wp_xenia/wp-admin/admin-ajax.php HTTP/1.1" 200 47

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 15, 2013 10:12AM

Caio Roberto,

I see you have Apache 2.4.4. Have you read through this fix document?

[forum.wampserver.com]

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 15, 2013 10:34AM

No, I just run the FIX.

But from the log files you see something wrong?

Thank you.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: RiggsFolly (---.as13285.net)
Date: November 15, 2013 11:16AM

Try this.

Open a command prompt as Administrator

Run
>netsh winsock reset

Reboot or Restart Apache and try again.

Options: ReplyQuote
Re: Static IP: I have configured correctly?
Posted by: robertosalemi (---.243-95-b.business.telecomitalia.it)
Date: November 15, 2013 02:22PM

Yeah, I followed the instructions in the link and fixed some bugs.

In particular this:
Listen 0.0.0.0:80
Listen [::0]:80

Thanks for your help and your kindness.

Thank you!

Options: ReplyQuote


Sorry, only registered users may post in this forum.