Follow these instructions to start the appropriate WAMP services on start-up. UAC will not interfere here and there is no need to log in to start your web-server:

1. Log in as an administrator.

2. Start -&gt; Run &quot;services.msc&quot;

3. Right click the service **wampapache** (may also be called **wampapache64**). Go to properties and set start-up type to &#39;Automatic&#39;

4. If you want MySQL to also be available on startup, then repeat step 3 for **wampmysqld** (or **wampmysqld64**)

![enter image description here][1]

Tried and tested on Windows 7-10


  [1]: http://i.stack.imgur.com/m6d3n.png

1) Open Task Scheduler&lt;br/&gt;
2) Under &quot;Action&quot; &gt; Create a Task&lt;br/&gt;
3) Give some name&lt;br/&gt;
4) Trigger &gt; New &gt; Begin The Task &gt; “At Startup”&lt;br/&gt;
5) Actions &gt; New &gt; Browse &gt; c:\wamp\wampmanager.exe&lt;br/&gt;
6) Hit OK&lt;br/&gt;
7) Restart and Check

1) What you need is to create a batch file with path of **wampserver.exe**
2) Make Windows Task Scheduler Run the Batch file
3) Open **Startup:shell** to make the batch file run automatically when the computer Start
4) Disable **UAC** put it on **NERVER NOTIFY** mode so that you don&#39;t have message when Wamp Server starts. 

I found a blog that gave all the steps plus video here: [https://ddroid509ht.blogspot.com/2019/07/open-wamp-server-on-startup.html][1]


  [1]: https://ddroid509ht.blogspot.com/2019/07/open-wamp-server-on-startup.html

In Java I might do:

    public static void doSomething();

And then I can access the method statically without making an instance:

    className.doSomething(); 

How can I do that in Ruby? this is my class and from my understanding `self.` makes the method static:

    class Ask
    
      def self.make_permalink(phrase)
        phrase.strip.downcase.gsub! /\ +/, &#39;-&#39;
      end
    
    end

But when i try to call:

    Ask.make_permalink(&quot;make a slug out of this line&quot;)

I get:

    undefined method `make_permalink&#39; for Ask:Class

Why is that if i haven&#39;t declared the method to be private?  

 

Ruby: How to make a public static method?

How can I import a large (14 GB) MySQL dump file into a new MySQL database?

I&#39;m looking to have WAMP start when I switch on the computer. Ideally it would start without users even having to log on. I&#39;ve added WAMP to the start-up in the registry but a user needs to have logged on and UAC is still playing it&#39;s annoying part.

Is there a way to accomplish this without logging on or UAC interfering?

Thanks.

Have WAMP start automatically upon Windows start-up (without logging on or any UAC interference)

I'm looking to have WAMP start when I switch on the computer. Ideally it would start without users even having to log on. I've added WAMP to the start-up in the registry but a user needs to have logged on and UAC is still playing it's annoying part.
Is there a way to accomplish this without logging on or UAC interfering?
Thanks.

I&#39;ve had MAMP working for a few months and recently installed PostgreSQL.  It recommended installing Apache as well, which I did to make sure PostgreSQL worked.  I then uninstalled PostgreSQL and the apache build and tried to restart MAMP.  It fired up the MySQL database (green light) but Apache didn&#39;t start.  I uninstalled and reinstalled MAMP only to face the same problem.

Apache doesn&#39;t seem to be logging any errors in the MAMP folder, so without any errors to report I&#39;m struggling with where to begin fixing it.  I&#39;m hoping its to do with the fact that I installed another version (and deleted it) that has caused the problem but I&#39;m too inexperienced to know what I&#39;ve done.

Where might I find any errors if not in the MAMP folder? Not in:

- /Applications/MAMP/Library/logs
- /Applications/MAMP/bin/logs



Apache not starting in MAMP (but MySQL working) in OSX


Looking at the Apache config file, I see Prefork and Worker MPM defined. What is the difference and which one is Apache using?

Apache Prefork vs Worker MPM

I have the following htaccess code:

    &lt;IfModule mod_rewrite.c&gt;
    
    RewriteEngine On
    RewriteCond !{HTTPS} off
    RewriteRule ^(.*)$ https://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
    RewriteCond %{HTTP_HOST} !^www\.
    RewriteRule ^(.*)$ https://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
    
    &lt;/IfModule&gt;

I want my site to be redirected to `https://www.` with HTTPS, and enforcing the `www.` subdomain,
but when I access `http://www.` (without HTTPS), it does not redirect me to `https://www` with HTTPS.


htaccess redirect to https://www

I&#39;m building a personal stock platform (not distributed). A component I would like to have is the EPS graph on this page:

https://eresearch.fidelity.com/eresearch/evaluate/fundamentals/earnings.jhtml?stockspage=earnings&amp;symbols=AAPL&amp;showPriceLine=yes

As you can see, the page is `https`, so after days of hammering things out, I enabled `openssl` and now it seems to work for all `https` pages such as the homepages of facebook and twitter, however it is still not working for the one I need.

    file_get_contents(&#39;https://facebook.com&#39;); /* works */
    file_get_contents(&#39;https://twittercom&#39;); /* works */
    file_get_contents(&#39;https://eresearch.fidelity.com/eresearch/evaluate/fundamentals/earnings.jhtml?stockspage=earnings&amp;symbols=AAPL&amp;showPriceLine=yes&#39;);

I&#39;m getting the warning:

    Warning: file_get_contents(): SSL: crypto enabling timeout in C:\xampp\htdocs\index.php on line 3
    Warning: file_get_contents(): Failed to enable crypto in C:\xampp\htdocs\index.php on line 3
    Warning: file_get_contents(https://eresearch.fidelity.com/eresearch/evaluate/fundamentals/earnings.jhtml?stockspage=earnings&amp;symbols=AAPL&amp;showPriceLine=yes): failed to open stream: operation failed in C:\xampp\htdocs\index.php on line 3
    Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\index.php on line 3

The only difference I can see is that the fidelity page has a triangle near the https label.

![fidelity https label][1]


  [1]: http://i.stack.imgur.com/RWYvz.png

OPENSSL file_get_contents(): Failed to enable crypto

We have an Apache Webserver installed on a machine which also serves pages using Perl.

For a project I&#39;ve decided to use Node.js instead of Perl/Ruby. Just wondering if it&#39;s possible to use Apache as my webserver (so it serves the pages) and use Node.js to dynamically create the web pages (this is for a web app I am creating)?

So in other words can they work hand in hand just like Apache/Perl or Apache/PHP etc..

Running Node.js in apache?

This sounds like it should be so simple... I must be dumb.

All I want is to make a windows short-cut that opens Powershell into a specific directory:

I&#39;m using the target:

    %SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe 
        -noexit -command {cd c:/path/to/open}

Put it just spits out the command as text.

Open Powershell in a specific directory from shortcut

I&#39;ve got a batch file. After it finished running, i.e. all command lines have been executed, the *cmd.exe* window stays open. However, I&#39;d like to have it closed right after the batch file finishes its job. 

So far I&#39;ve tried using the `exit` command within the batch file to close the cmd window (I also have a shortcut on the desktop) but it doesn&#39;t seem to work:

    tncserver.exe C:\Work -p4 -b57600 -r -cFE -tTNC426B
    exit

How to close the command line window after running a batch file?

I&#39;m trying to speed up the answer [here][1] using Cython. I try to compile the code (after doing the `cygwinccompiler.py` hack explained [here][2]), but get a `fatal error: numpy/arrayobject.h: No such file or directory...compilation terminated` error. Can anyone tell me if it&#39;s a problem with my code, or some esoteric subtlety with Cython?

Below is my code. 

    import numpy as np
    import scipy as sp
    cimport numpy as np
    cimport cython

    cdef inline np.ndarray[np.int, ndim=1] fbincount(np.ndarray[np.int_t, ndim=1] x):
        cdef int m = np.amax(x)+1
        cdef int n = x.size
        cdef unsigned int i
        cdef np.ndarray[np.int_t, ndim=1] c = np.zeros(m, dtype=np.int)

        for i in xrange(n):
            c[&lt;unsigned int&gt;x[i]] += 1

        return c

    cdef packed struct Point:
        np.float64_t f0, f1

    @cython.boundscheck(False)
    def sparsemaker(np.ndarray[np.float_t, ndim=2] X not None,
                    np.ndarray[np.float_t, ndim=2] Y not None,
                    np.ndarray[np.float_t, ndim=2] Z not None):
    
        cdef np.ndarray[np.float64_t, ndim=1] counts, factor
        cdef np.ndarray[np.int_t, ndim=1] row, col, repeats
        cdef np.ndarray[Point] indices

        cdef int x_, y_
        
        _, row = np.unique(X, return_inverse=True); x_ = _.size
        _, col = np.unique(Y, return_inverse=True); y_ = _.size
        indices = np.rec.fromarrays([row,col])
        _, repeats = np.unique(indices, return_inverse=True)
        counts = 1. / fbincount(repeats)
        Z.flat *= counts.take(repeats)

        return sp.sparse.csr_matrix((Z.flat,(row,col)), shape=(x_, y_)).toarray()


  [1]: https://stackoverflow.com/a/14469557/1658908
  [2]: https://stackoverflow.com/questions/6034390/compiling-with-cython-and-mingw-produces-gcc-error-unrecognized-command-line-o/6035864#6035864

Cython: &quot;fatal error: numpy/arrayobject.h: No such file or directory&quot;

I need to store some user-specific configuration data for my program.  Both Application Data/AppData (in the user&#39;s directory) and ProgramData (in the root of the system drive) seem like reasonable places to put it.

What is the difference between Program Data and Application Data and which should I use?

What is the difference between ProgramData and AppData?

When I try to run `netsh wlan start hostednetwork`, I get the following message:

    C:\Windows\system32&gt;netsh wlan start hostednetwork
    The hosted network couldn&#39;t be started.
    The group or resource is not in the correct state to perform the requested operation.

I&#39;m running this with admin privileges, so it&#39;s not the notorious

    C:\Users\Kevin&gt;netsh wlan start hostednetwork
    You must run this command from a command prompt with administrator privilege.

How do I get the hosted network &quot;in the correct state&quot;?

Can&#39;t start hostednetwork

When I tried to install **WAMP**, that popped up the following alert,
![MSVCR100.dll is missing][2]

I clicked **OK**, it continued to install WAMP. When I start, the WAMP logo is always &#39;yellow&#39;. It isn&#39;t turning &#39;green&#39;, meaning there&#39;s something wrong. What exactly is the `MSVCR100.dll` file? How do I obtain it and fix this error?

  [2]: http://i.stack.imgur.com/C1dkH.png

WAMP shows error &#39;MSVCR100.dll&#39; is missing when install

I&#39;m new to php and wanted to run php from command line. I have installed WAMP and set the &quot;System Variables&quot; to my php folder ( which is `C:\wamp\bin\php\php5.4.3`).

When i go to `Run` -&gt; `CMD` -&gt; Type `php -a` and hit enter, it says `interactive mode enabled`. But when I write `echo &#39;Hi&#39;;` it shows nothing.

I even don&#39;t see anything like &#39;php &gt;&quot; when i type `php -a` and hit enter.

How To Run PHP From Windows Command Line in WAMPServer

What is maximum query size for mysql? Some times the server stops working when I fire a too long query.


What is maximum query size for mysql?

I just recently downloaded WAMP Server to view and edit php webpages but now I would also like other people in my network (connected to the same wifi) to be able to access localhost and all the files that I have saved. I have already tried to access localhost and my WAMP server was already online, however that didn&#39;t work. Can someone help me out? Thanks in advance!

How can I access localhost from another computer in the same network?

I&#39;m using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the &#39;root&#39; user (with &#39;localhost&#39; host) and gave it a password of &#39;root&#39;. This turned out to be a big mistake that I&#39;m trying to revert. Now when I go to **localhost/phpmyadmin/** I get the menu of databases on the left, but the main frame has an error that reads:

    #1045 - Access denied for user &#39;root&#39;@&#39;localhost&#39; (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.

If I go to **127.0.0.1/phpmyadmin**, I do *not* get the error and everything works fine.

I tried changing the user&#39;s password back to no password; I tried modifying config.inc.php file to add the new password (but that made phpMyAdmin error-out completely); I tried removing and recreating the root/localhost user. Nothing seems to work. The root/localhost user appears to have no password and all privileges, but the error remains.

Any ideas or how I can get this user&#39;s access back to normal without having to reinstall WAMP?

Fix Access denied for user &#39;root&#39;@&#39;localhost&#39; for phpMyAdmin

Trying to install [Composer][1] dependency management tool on **Win7/64 + WampServer 2.2** via the [Setup Installer][2] and I am getting the following message:

&gt; The openssl extension is missing, which will reduce the security and stability of Composer.
If possible you should enable it or recompile php with --with-openssl  

So here is what I did...

 1. From my Wamp icon in Tray,  clicked `php &gt; php extensions &gt; php_openssl`
 2. This showed that task was completed by placing a **check mark** beside the extension
 3. I then restarted WampServer
 4. Then from the Wamp icon in tray, I clicked `php &gt; php.ini` and searched for openssl to verifiy it was NOT commented) out. It was not.
 5. I then went back to Composer-Setup.exe and tried again. **Same Warning Message**: &quot;openssl extension is missing&quot;
 6. Having **never** worked with OpenSSL, I&#39;m not sure what is supposed to be set, so I tried to browse to one of my local sites using https. It Failed.

What am I missing?

Please advise.

  [1]: http://getcomposer.org/
  [2]: http://getcomposer.org/download/

Composer Warning: openssl extension is missing. How to enable in WAMP

I know this question has been asked a lot of times 

I followed Most of the answers in the internet But I still get the same Message

&gt; 403 Forbidden
&gt; 
&gt; You don&#39;t have permission to access / on this server.


It is weird that when I access using the same PC to **`localhost:1234`** it runs normally but if I access using my IP address **`192.168.0.188:1234`** 

Also which is really weird is that I tried to install WAMP on other PC and without any configuration I could access to that PC.

So I thought it&#39;s because McAfee and Firewall so I open port on Widows and McAfee and nothing changed also I turned off Firewall and still nothing change.

Then for no reason I opened  port through the Router “port forwarding” and still nothing changed.

I don&#39;t think that it&#39;s because my configuration in WAMP since I am still able to get this `403 Forbidden` Message and also by using other PC without any configuration I could access it.

***Both PCs are setup like this:***

**Windows 8 Pro**

 - **WAMP Wampserver:** 2.4 
 - **Apache Version:** 2.4.4  
 - **PHP Version:** 5.4.12  
 - **MySQL Version:** 5.6.12  

The accessible PC uses *Microsoft Security Essentials*.

The inaccessible PC uses *McAfee Internet Security*.

I tried to turn **off WAMP** and **start IIS** For Microsoft Server (I works perfectly From any PC) but WAMP is still not not working

I followed these tutorial: 

 - [How to Access WAMP Server in LAN or WAN][1]
 - [Install &amp; Setup Virtual Host Guide for WAMP][2]
 - [Install &amp; Setup LAN &amp; Worldwide Access Guide for WAMP][3]

And the Stack Overflow answers here: 

 - [Cannot access wamp server on local network][4]
 - [WAMP 403 Forbidden message on Windows 7][5]


  [1]: http://www.codeproject.com/Tips/395286/How-to-Access-WAMP-Server-in-LAN-or-WAN
  [2]: http://guides.jlbn.net/setvh/setvh1.html
  [3]: http://guides.jlbn.net/setaccess/setaccess1.html
  [4]: https://stackoverflow.com/questions/8219062/cannot-access-wamp-server-on-local-network
  [5]: https://stackoverflow.com/questions/8204902/wamp-403-forbidden-message-on-windows-7

WAMP Cannot access on local network 403 Forbidden

I am installing the Wamp Server on another computer to run a mid-sized database and UI. I have been successful in blocking IIS and routing the server to Localhost:8080. But whenever I try to access on of my projects from the localhost homepage, in the www file; I get redirected to a Page not found error. 

When I hover above the links the directory always comes up &quot;http:// ProjectFolderNameHere /&quot;. when it&#39;s supposed to be &quot;http:// LocalHost:8080 / ProjectFolderNameHere /&quot;. What can I do to get the links working properly?

My Machine runs on Windows 7 Home Edition 64-bits, and I already have Microsoft&#39;s IIS disabled.

Content Type	Original Author	Original Content on Stackoverflow
Question	George	View Question on Stackoverflow
Solution 1 - Apache	George	View Answer on Stackoverflow
Solution 2 - Apache	Sariban D'Cl	View Answer on Stackoverflow
Solution 3 - Apache	DoctorDroid Haiti	View Answer on Stackoverflow

Have WAMP start automatically upon Windows start-up (without logging on or any UAC interference)

Apache Problem Overview

Apache Solutions

Solution 1 - Apache

Solution 2 - Apache

Solution 3 - Apache

How can I import a large (14 GB) MySQL dump file into a new MySQL database?

Ruby: How to make a public static method?

Attributions