I updated to the latest version of yosemite last night.

You apparently have to go to your MAMP folder in Applications. Go to `bin` -&gt; `apache2` -&gt; `bin`.

Then rename the file from `envvars` to `_envvars`.


I also came across another problem of it not working correctly. Make sure the ports are Apache defaults, NOT MAMP defaults (port 80 etc). If it works straight away, this should not apply to you.

Installing the latest release of MAMP 3 Version 3.0.7.3 in my case seems to solve this issue.

I&#39;m trying to figure out how to declare a static variable scoped only locally to a function in Swift.

In C, this might look something like this:

    int foo() {
        static int timesCalled = 0;
        ++timesCalled;
        return timesCalled;
    }

In Objective-C, it&#39;s basically the same:

    - (NSInteger)foo {
        static NSInteger timesCalled = 0;
        ++timesCalled;
        return timesCalled;
    }

But I can&#39;t seem to do anything like this in Swift.  I&#39;ve tried declaring the variable in the following ways:

    static var timesCalledA = 0
    var static timesCalledB = 0
    var timesCalledC: static Int = 0
    var timesCalledD: Int static = 0

But these all result in errors.

 - The first complains &quot;Static properties may only be declared on a type&quot;.
 - The second complains &quot;Expected declaration&quot; (where `static` is) and &quot;Expected pattern&quot; (where `timesCalledB` is)
 - The third complains &quot;Consecutive statements on a line must be separated by &#39;;&#39;&quot; (in the space between the colon and `static`) and &quot;Expected Type&quot; (where `static` is)
 - The fourth complains &quot;Consecutive statements on a line must be separated by &#39;;&#39;&quot; (in the space between `Int` and `static`) and &quot;Expected declaration&quot; (under the equals sign)

Static function variables in Swift

How do you set the text for a `UILabel` to bold in Swift programmatically? 
My code so far:

        var label = UILabel(frame:theFrame)
        label.text = &quot;Foo&quot;


Setting UILabel text to bold

Apache wont start and it throws an error:

![Starting Apache failed screenshot][1]

OR
Apache couldn&#39;t be started. Please check the log file for more information.

&gt;dyld: Symbol not found: _iconv
  Referenced from: /usr/lib/libmecabra.dylib
  Expected in: /Applications/MAMP/Library/lib/libiconv.2.dylib
 in /usr/lib/libmecabra.dylib
/Applications/MAMP/Library/bin/apachectl: line 80:  2799 Trace/BPT trap: 5       $HTTPD &quot;$

This is the same for multiple ports. The reccomended MAMP ports AND the regular apache ports.

MySQL starts perfectly fine.

Any suggestions?


  [1]: http://i.stack.imgur.com/mgMeP.png

Apache not starting on MAMP Pro

Apache wont start and it throws an error:
<img src="http://i.stack.imgur.com/mgMeP.png" alt="Starting Apache failed screenshot">
OR
Apache couldn't be started. Please check the log file for more information.
>dyld: Symbol not found: _iconv
Referenced from: /usr/lib/libmecabra.dylib
Expected in: /Applications/MAMP/Library/lib/libiconv.2.dylib
in /usr/lib/libmecabra.dylib
/Applications/MAMP/Library/bin/apachectl: line 80: 2799 Trace/BPT trap: 5 $HTTPD "$
This is the same for multiple ports. The reccomended MAMP ports AND the regular apache ports.
MySQL starts perfectly fine.
Any suggestions?

I&#39;m trying to follow the instructions here https://github.com/go-sql-driver/mysql#installation and http://go-database-sql.org/accessing.html to create a sql.db.

The first line of my code has this

    db, err := sql.Open(&quot;mysql&quot;, &quot;username@localhost/my_db&quot;)

When I ran the program on the terminal, I got this:

    Default addr for network &#39;&#39;localhost&#39;&#39; unknown

Why is this? When I checked the user and host to mysql it states &#39;username&#39; and &#39;localhost&#39;. I followed the parameters like this:

    [username[:password]@][protocol[(address)]]/dbname[?param1=value1&amp;...&amp;paramN=valueN]

error connecting to database with mysqldriver

When we create a table in MySQL with a `VARCHAR` column, we have to set the length for it. But for `TEXT` type we don&#39;t have to provide the length. 

What are the differences between `VARCHAR` and `TEXT`?

Difference between VARCHAR and TEXT in MySQL

I&#39;ve read a lot of questions about that but i couldn&#39;t find one that is fast enough. I think there are better ways to insert a lot of rows into a MySQL Database

 
I use the following code to insert 100k into my MySQL-Database:

    public static void CSVToMySQL()
    {
        string ConnectionString = &quot;server=192.168.1xxx&quot;;
        string Command = &quot;INSERT INTO User (FirstName, LastName ) VALUES (@FirstName, @LastName);&quot;;
        using (MySqlConnection mConnection = new MySqlConnection(ConnectionString))
        {
            mConnection.Open();

            for(int i =0;i&lt; 100000;i++) //inserting 100k items
            using (MySqlCommand myCmd = new MySqlCommand(Command, mConnection))
            {
                myCmd.CommandType = CommandType.Text;
                myCmd.Parameters.AddWithValue(&quot;@FirstName&quot;, &quot;test&quot;);
                myCmd.Parameters.AddWithValue(&quot;@LastName&quot;, &quot;test&quot;);
                myCmd.ExecuteNonQuery();
            }
        }
    }


This takes for 100k rows about 40 seconds. How can i make this faster or a little more efficient? 

Might be faster to insert multiple rows via a DataTable/DataAdapter or at once:

    INSERT INTO User (Fn, Ln) VALUES (@Fn1, @Ln1), (@Fn2, @Ln2)...

Due to security issues i can&#39;t load the data into a file and MySQLBulkLoad it.

Most efficient way to insert Rows into MySQL Database

So I have read the following post&quot;

[What the difference between mysql and mysql2 gem][1]

So far I have only used MongoDB with NodeJS and I want to be able to learn MySQL for any of my relational database needs. While researching MySQL &amp; NodeJS I have found repositories for MySQL2 and it appears to have nothing in relation to the MySQL website, I&#39;m assuming that there have been API&#39;s created that make it faster for developing with languages like NodeJS &amp; Ruby. From a NodeJS standpoint, I&#39;m assuming that I still run the regular MySQL database o my server, but I need to interact with it using these new API&#39;s like:

https://github.com/sidorares/node-mysql2/blob/master/README.md

I have also seen a site where they do performance benchmarks and NodeJS &amp; MySQL come in very low for performance. and NodeJS &amp; MySQL2 very High

Source for this info:
[php-nodejs-mysql-and-mongo][2]

Image  from this post:

![enter image description here][3]

Question: Do I simply use the regular MySQL database on my server and use this mysql2 API or is there a different implementation of MySQL that works with this API?

I have not used MySQL in about 10 years. I have only Used Microsoft&#39;s SQL Server. So I&#39;m severely behind. I have started using NodeJS and figured that my best relational database options were MySQL, Is there something else I should look for?

  [1]: https://stackoverflow.com/questions/5411551/what-the-difference-between-mysql-and-mysql2-gem
  [2]: http://zzarbi.tumblr.com/post/16870870471/php-nodejs-mysql-and-mongo
  [3]: http://i.stack.imgur.com/6BkJB.png

What is the difference between MySQL &amp; MySQL2 considering NodeJS

First off, yeah, I&#39;ve already seen this: 

[pip install mysql-python fails with EnvironmentError: mysql_config not found][1]

**The problem**

I am trying to use Django on a Google App Engine project. However, I haven&#39;t been able to get started as the server fails to start properly due to: 

    ImproperlyConfigured(&quot;Error loading MySQLdb module: %s&quot; % e)
    ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb

I did some research and it all pointed to having to install Mysql-python, as apparently it isn&#39;t on my system. I actually tried uninstalling it and got this: 

    Cannot uninstall requirement mysql-python, not installed

Whenever I actually do try to install via: 

    sudo pip install MySQL-python

I get an error stating: 

    raise EnvironmentError(&quot;%s not found&quot; % (mysql_config.path,))
    EnvironmentError: mysql_config not found

I&#39;ve already tried running: 

    export PATH=$PATH:/usr/local/mysql/bin

but that didn&#39;t seem to help, as I ran the installation command again and it still failed. 

Any ideas? 

Please note I&#39;m not in a virtualenv. 

  [1]: https://stackoverflow.com/questions/5178292/pip-install-mysql-python-fails-with-environmenterror-mysql-config-not-found

Mac OS X - EnvironmentError: mysql_config not found

I&#39;m trying to integrate Tomcat with Apache. My aim is to redirect all the requests with
`http://localhost/myapp` to `http://localhost:8080`

I followed this guide: http://tomcat.apache.org/tomcat-8.0-doc/proxy-howto.html

My `httpd.conf` looks like this:

    Include conf.modules.d/*.conf
    LoadModule proxy_module  modules/mod_proxy.so
    
    ProxyPass         /myapp  http://localhost:8080 retry=0 timeout=5
    ProxyPassReverse  /myapp  http://localhost:8080

My server.xml in apache-tomcat looks like this:

    &lt;Connector port=&quot;8080&quot; protocol=&quot;HTTP/1.1&quot; connectionTimeout=&quot;20000&quot; redirectPort=&quot;8443&quot; proxyPort=&quot;80&quot; /&gt;

Now when I try the url `http://localhost/myapp`, it gives `503 Service Unavailable` error.

Both Tomcat and Apache are up and running. The URL `http://localhost:8080` works fine. 

Can there be an issue with file permissions?

For `tomcat` the user and group are `root/root` and for `httpd`, the user and group are `apache/apache`

Am I missing something or am I doing it wrong?

Httpd version is 2.4.6 and Tomcat&#39;s version is 8.0


The httpd error logs:

    [proxy:error] [pid 19905] (13)Permission denied: AH00957: HTTP: attempt to connect to 127.0.0.1:8080 (localhost) failed
    
    [proxy:error] [pid 19905] AH00959: ap_proxy_connect_backend disabling worker for (localhost) for 0s
    
    [proxy_http:error] [pid 19905] [client ::1:51615] AH01114: HTTP: failed to make connection to backend: localhost

**Solved!**

The answer is here: http://sysadminsjourney.com/content/2010/02/01/apache-modproxy-error-13permission-denied-error-rhel/

Httpd returning 503 Service Unavailable with mod_proxy for Tomcat 8

I want to know what exactly it means when a web server describes itself as a pre-fork web server. I have a few examples such as [unicorn][1] for ruby and [gunicorn][2] for python.

More specifically, these are the questions:

- What problem does this model solve?
- What happens when a pre-fork web server is initially started?
- How does it handle requests?

Also, a more specific question for unicorn/gunicorn:

Let&#39;s say that I have a webapp that I want to run with (g)unicorn. On initialization, the webapp will do some initialization stuff (e.g. fill in additional database entries). If I configure (g)unicorn with multiple workers, will the initialization stuff be run multiple times?

  [1]: http://unicorn.bogomips.org/
  [2]: http://gunicorn.org/

What exactly is a pre-fork web server model?

I am trying to install Xampp win32-1.8.2 on Windows 8.1. I get a message saying&quot; Because an activated user account User Account on your system some functions of XAMPP are possibly restricted.&quot; I&#39;ve tried to change the user account control settings but still the warning is there. And the APACHE does not start. I&#39;ve also disabled my IIS but still, its not working. What should I do? Thanks.![enter image description here][1]


  [1]: http://i.stack.imgur.com/cNdNF.png

XAMPP installation on Win 8.1 with UAC Warning

I just recently upgraded to OSX 10.10 Yosemite and I since the upgrade I can&#39;t do Curl POST to a SSL url anymore.

I first used wordpress&#39;s `wp_remote_request` call and also tried to use curl in php.
Both (as expected) give the same error message:

&gt; 
Error Number:56

&gt; Error String:SSLRead() return error -9806

Note: when I curl POST to HTTP it works fine.
I reckon it is a setting in PHP.ini or in my apache (I lost my original HTTPD.conf file after upgrade...).

Can anyone help me out?

osx 10.10 Curl POST to HTTPS url gives SSLRead() error

I&#39;m currently trying to read the authorization header in a PHP script that I&#39;m calling with a POST request. The Authorization header is populated with a token. It seems the Authorization header is somehow removed before it arrives at my PHP script. I&#39;m executing the post request with Postman (Chrome addon) and I enabled CORS in my PHP script. I don&#39;t have access to the apache server directly.

HTTP Request:

    Accept:*/*
    Accept-Encoding:gzip,deflate
    Accept-Language:de-DE,de;q=0.8,en-US;q=0.6,en;q=0.4,ja;q=0.2
    Authorization:Bearer mytoken
    Cache-Control:no-cache
    Connection:keep-alive
    Content-Length:32
    Content-Type:text/plain;charset=UTF-8
    Host:www.myhost.com
    Origin:chrome-extension://fdmmgilgnpjigdojojpjoooidkmcomcm
     User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)       
     Chrome/38.0.2125.104 Safari/537.36


PHP script:

    header(&quot;Access-Control-Allow-Origin: *&quot;);
    header(&quot;Access-Control-Allow-Headers: Authorization, Origin, X-Requested-With, Content-Type,      Accept&quot;);
    header(&quot;Content-Type: application/json&quot;);

    $headers = getallheaders();
    echo $headers[&#39;Authorization&#39;];

The above script outputs &#39;&#39; (= nothing).

Authorization header missing in PHP POST request

I know this is a very popular question but I haven&#39;t been able to find a working solution for Laravel 5. I&#39;ve been trying to migrate from Codeigniter for a long time, but this convoluted installation process keeps putting me off.

I don&#39;t want to run a VM, this just seems awkward when switching between projects.

I don&#39;t want to set my document root to the public folder, this is also awkward when switching between projects.

I&#39;ve tried the .htaccess mod_rewrite method

    &lt;IfModule mod_rewrite.c&gt;
      RewriteEngine On
      RewriteRule ^(.*)$ public/$1 [L]
    &lt;/IfModule&gt;

This just gives me a Laravel NotFoundHttpException in compiled.php line 7610.

When I tried L4 a while ago, I used the method of moving the contents of the public folder into the root. The structure of L5 is quite different and following the same steps completely broke Laravel (the server would only return a blank page).

Is there a decent method of removing &#39;public&#39; in a development environment that:

1. Works with L5
2. Allows me to switch between projects with ease (I&#39;m usually working on 2 or 3 at any one time).

Thanks

** I&#39;m using MAMP and PHP 5.6.2

Laravel 5 – Remove Public from URL

I&#39;m building a set of code diagnostics using Roslyn (in VS2015 Preview). Ideally, I&#39;d like any errors they produce to act as persistent errors, just as if I were violating a normal language rule.

There are a bunch of options, but I&#39;m having a hard time getting any of them to work consistently. I&#39;ve managed to implement a rudimentary syntax node action, i.e. one registered with 

    context.RegisterSyntaxNodeAction(AnalyzeSyntaxNode, SyntaxKind.InvocationExpression);

in the `Initialize` method of my diagnostic class. Lo and behold, when I open up a file which violates this diagnostic (while running the VSIX project), VS2015 shows an error:

- Red squiggle under the right bit of code
- Red block in the margin
- Error in the error list

However, the error goes away when I close the file.

I&#39;ve tried using `context.RegisterCompilationEndAction` as well, but this has two problems:

- It seems to fire inconsistently. *Usually* when I open the solution it fires, but not always. It doesn&#39;t fire on a clean/rebuild, which seems odd.
- Although diagnostics created *directly* in the analysis method fire, in order to implement the diagnostics I&#39;m using a visitor, like this - which may be inept:

        private static void AnalyzeEndCompilation(CompilationEndAnalysisContext context)
        {
            foreach (var tree in context.Compilation.SyntaxTrees)
            {
                var visitor = new ReportingVisitor(context.Compilation.GetSemanticModel(tree));
                visitor.Visit(tree.GetRoot());
                foreach (var diagnostic in visitor.Diagnostics)
                {
                    context.ReportDiagnostic(diagnostic);
                }
            }
        }

 I know that the diagnostics are being created - a breakpoint on the `ReportDiagnostic` line is hit several times - but I&#39;m not seeing anything in the error list. (Whereas a similar `ReportDiagnostic` call at the start of the method, or one per syntax tree with the file path, *does* get shown.)

What am I doing wrong here? The first approach (a syntax node action) would be ideal if feasible - it gives me exactly the context I need. Is there some setting in the project properties that I need to make the compiler use that for &quot;full project&quot; compilation as well as just interactive &quot;in the IDE&quot; handling? Is this perhaps just a bit of Roslyn integration which isn&#39;t quite finished yet?

(I can include the full code for the class if it would be useful - in this case I suspect it would be more noise than signal though.)

Content Type	Original Author	Original Content on Stackoverflow
Question	Toby Mellor	View Question on Stackoverflow
Solution 1 - Mysql	Toby Mellor	View Answer on Stackoverflow
Solution 2 - Mysql	rii	View Answer on Stackoverflow

Apache not starting on MAMP Pro

Mysql Problem Overview

Mysql Solutions

Solution 1 - Mysql

Solution 2 - Mysql

Setting UILabel text to bold

Static function variables in Swift

Attributions