Check your servers error log, typically `/var/log/apache2/error.log`.

You should look for the error in the file error_log in the log directory. Maybe there are differences between your local and server configuration (db user/password etc.etc.) 

usually the log file is in

    /var/log/apache2/error.log

or

    /var/log/httpd/error.log

I am struggling to find a clean solution to my problem and was wondering if anyone could offer some tips.

I have &quot;templates.html&quot; which contains a collection of HTML snippets which I want to load into JavaScript and use.  What is a good way to access the templates/snippets bearing in mind that templates.html is not a loaded DOM document?

I was thinking about using `document.open` to create a DOM to access but I think this has issues on certain browsers.

Load HTML template with JavaScript

I&#39;m trying to use jsoup to login to a site and then scrape information, I am running into in a problem, I can login successfully and create a Document from index.php but I cannot get other pages on the site. I know I need to set a cookie after I post and then load it when I&#39;m trying to open another page on the site. But how do I do this? The following code lets me login and get index.php

&lt;!-- language: lang-java --&gt;

    Document doc = Jsoup.connect(&quot;http://www.example.com/login.php&quot;)
                   .data(&quot;username&quot;, &quot;myUsername&quot;, 
                         &quot;password&quot;, &quot;myPassword&quot;)
                   .post();


I know I can use apache httpclient to do this but I don&#39;t want to. 

jsoup posting and cookie

    The server encountered an internal error or misconfiguration and was unable to complete your request.
    
    Please contact the server administrator, nkutty@bics.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
    
    More information about this error may be available in the server error log.
    Apache/2.2.0 (Fedora) Server at bbt.com Port 80

This works fine in my local system but it is not working in the server. Can anyone help to figure out why it is?
Thanks in advance!

The server encountered an internal error or misconfiguration and was unable to complete your request

<pre><code class="hljs language-lua">The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, nkutty@bics.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Apache/2.2.0 (Fedora) Server at bbt.com Port 80
</code></pre>
This works fine in my local system but it is not working in the server. Can anyone help to figure out why it is?
Thanks in advance!

For whatever reason, I need to go through a MySQL result set twice. Is there a way to do it?

I don&#39;t want to run the query twice and I don&#39;t want to have to rewrite the script so that it stores the rows somewhere and then reuses them later.

How can I loop through a MySQL result set more than once using the mysql_* functions?

I wrote some function used by a php webpage, in order to interact with a mysql database. When I test them on my server I get this error:
    
    &quot;Connect failed: Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: YES)&quot; 

I am able to use them on my pc (using XAMPP) and I can navigate through the tables of the database using the command line in the server. However, the webpage fails to connect. I&#39;ve checked the password but with no results. It&#39;s correct (otherwise I could not log in to mysql from the command line). 

The call of the function is the following:

    $conn = new mysqli(&quot;localhost&quot;, &quot;root&quot;, &quot;password&quot;, &quot;shop&quot;);

Do I have to set something in my server? Thanks

Edit:
PHP version 5.3.3-7+squeeze1
mysql version:  5.1.49-3
both on debian

&quot;Connect failed: Access denied for user &#39;root&#39;@&#39;localhost&#39; (using password: YES)&quot; from php function

I am trying to perform a backup/restore function for static properties of classes. I can get a list of all of the static properties and their values using the reflection objects `getStaticProperties()` method. This gets both `private` and `public static` properties and their values.

The problem is I do not seem to get the same result when trying to restore the properties with the reflection objects `setStaticPropertyValue($key, $value)` method. `private` and `protected` variables are not visible to this method as they are to `getStaticProperties()`. Seems inconsistent.

Is there any way to set a private/protected static property using reflection classes, or any other way for that matter?

**TRIED**

	class Foo {
		static public $test1 = 1;
		static protected $test2 = 2;
		
		public function test () {
			echo self::$test1 . &#39;&lt;br&gt;&#39;;
			echo self::$test2 . &#39;&lt;br&gt;&lt;br&gt;&#39;;
		}
		
		public function change () {
			self::$test1 = 3;
			self::$test2 = 4;
		}
	}

	$test = new foo();
	$test-&gt;test();
	
	// Backup
	$test2 = new ReflectionObject($test);
	$backup = $test2-&gt;getStaticProperties();
	
	$test-&gt;change();
	
	// Restore
	foreach ($backup as $key =&gt; $value) {
		$property = $test2-&gt;getProperty($key);
		$property-&gt;setAccessible(true);
		$test2-&gt;setStaticPropertyValue($key, $value);
	}
	
	$test-&gt;test();

Is there any way to set a private/protected static property using reflection classes?

Context: 

 - We have a PHP/MySQL application. 
 - Some portions of the calculations are done in SQL directly. eg: All users created in the last 24 hours would be returned via an SQL query ( NOW() – 1 day)

There&#39;s a debate going on between a fellow developer and me where I&#39;m having the opinion that we should:

 A. Keep all calculations / code / logic in PHP and treat MySQL as a &#39;dumb&#39; repository of information

His opinion:

 B. Do a mix and match depending on whats easier / faster. http://www.onextrapixel.com/2010/06/23/mysql-has-functions-part-5-php-vs-mysql-performance/

I&#39;m looking at maintainability point-of-view. He&#39;s looking at speed (which as the article points out, some operations are faster in MySQL).


----------
@bob-the-destroyer
@tekretic
@OMG Ponies 
@mu is too short 
@Tudor Constantin
@tandu 
@Harley

I agree (and quite obviously) efficient WHERE clauses belong in the SQL level. However, what about examples like:

  1. Calculating a 24 period using NOW() - 1 day in SQL to select all users created in last 24 hours?
  2. Return capitalized first name and last name of all users?
  3. Concatenating a string?
  4. (thoughts, folks?)

Clear examples belonging in the SQL domain:

  1. specific WHERE selections
  2. Nested SQL statements
  3. Ordering / Sorting
  4. Selecting DISTINCT items
  5. Counting rows / items



Doing calculations in MySQL vs PHP

In my web application using codeigniter. I am trying to use base_url() function but it shows empty results. I have also used autoload helper through autoload file, but then too it doesn&#39;t seem to work. Also I had defined base constants but all in vain.

    &lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
        &lt;head&gt;
            &lt;title&gt;&lt;?php echo $title; ?&gt;&lt;/title&gt;        
            &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=UTF-8&quot;/&gt;
            &lt;link rel=&quot;stylesheet&quot; href=&quot;&lt;?php echo base_url();?&gt;/css/template/default.css&quot; type=&quot;text/css&quot; /&gt;
            &lt;script type=&quot;text/javascript&quot;&gt;
                //&lt;![CDATA[
                base_url = &#39;&lt;?= base_url();?&gt;&#39;;
                //]]&gt;
            &lt;/script&gt;
        &lt;/head&gt;

base_url() function not working in codeigniter

I&#39;m trying to populate a SQL table with a list of words. The table itself it pretty simple:


    CREATE TABLE WORDS(
      ID BIGINT AUTO_INCREMENT, 
      WORD VARCHAR(128) NOT NULL UNIQUE, 
      PRIMARY KEY(ID)
    );

The problem I&#39;m running into is this: when I do the following inserts back to back

    INSERT INTO WORDS(WORD) VALUES(&#39;Seth&#39;);
    INSERT INTO WORDS(WORD) VALUES(&#39;seth&#39;);

The second insert fails with a constraint violation (&quot;Duplicate entry &#39;seth&#39; for key &#39;WORD&#39;&quot;).

How can I get the `UNIQUE` constraint on `WORD` to be case sensitive?

SQL unique varchar case sensitivity question

I have a simple website where I establish a connection to a MySQL server using PDO.

    $dbh = new PDO(&#39;mysql:host=localhost;dbname=DB;port=3306&#39;,
                   &#39;USER&#39;,
                   &#39;SECRET&#39;, 
                   array(PDO::MYSQL_ATTR_INIT_COMMAND =&gt; &quot;SET NAMES utf8&quot;));

I had some traffic on my site and the server&#39;s connection limit was reached, and the website throws this error, with my *plain* password in it!

&gt; Fatal error: Uncaught exception
&gt; &#39;PDOException&#39; with message
&gt; &#39;SQLSTATE[08004] [1040] Too many
&gt; connections&#39; in
&gt; /home/domain/html/index.php:xxx
&gt; Stack trace: #0
&gt; /home/domain/html/index.php(64):
&gt; PDO-&gt;__construct(&#39;mysql:host=loca...&#39;,
&gt; &#39;USER&#39;, &#39;SECRET&#39;, Array) #1
&gt; {main} thrown in
&gt; /home/domain/html/index.php on
&gt; line 64

Ironically I switched to PDO for security reasons, so this really shocked me, because this exact error is something you can provoke very easily on most sites using simple HTTP flooding.

I have now wrapped my connection in a try/catch block, but still I think this is catastrophic!

I am new to PDO and so my question is: what do I have to do to consider to be safe? How do I establish a connection in a secure way? Are there other known security holes like this one that I have to be aware of?




Why does PDO print my password when the connection fails?

I am trying to deploy mod_wsgi with apache to run a django application but I am getting an error 500 internal server error The apache logs shows:


    [Thu Jun 23 14:01:47 2011] [error] [client 152.78.95.64] mod_wsgi (pid=16142): Exception occurred processing WSGI script &#39;/home/user/bms/apache/django.wsgi&#39;.
    [Thu Jun 23 14:01:47 2011] [error] [client 152.78.95.64] Traceback (most recent call last):
    [Thu Jun 23 14:01:47 2011] [error] [client 152.78.95.64]   File &quot;/home/user/bms/apache/django.wsgi&quot;, line 13, in &lt;module&gt;
    [Thu Jun 23 14:01:47 2011] [error] [client 152.78.95.64]     import django.core.handlers.wsgi
    [Thu Jun 23 14:01:47 2011] [error] [client 152.78.95.64] ImportError: No module named django.core.handlers.wsgi

My apache virtual host is as follows:

    &lt;VirtualHost *:80&gt;
    
        DocumentRoot /home/user/bms
    
        &lt;Directory /home/user/bms&gt;
            Order allow,deny
            Allow from all
        &lt;/Directory&gt;
    
    WSGIDaemonProcess bms user=user group=user processes=2 threads=25 python-path=/usr/local/lib/python2.7/site-packages

    
        WSGIProcessGroup bms
    
        WSGIScriptAlias / /home/user/bms/apache/django.wsgi
    
    &lt;/VirtualHost&gt;

And the referenced wsgi file in my app directory with 0777 permissions:

    import os
    import sys
    
    path = &#39;/home/user/bms&#39;
    if path not in sys.path:
        sys.path.append(path)
    
    os.environ[&#39;DJANGO_SETTINGS_MODULE&#39;] = &#39;bms.settings&#39;
    
    import django.core.handlers.wsgi
    application = django.core.handlers.wsgi.WSGIHandler()


I heard that this may be because the apache user does not have the correct permissions. However I have no idea how to fix this. I also tried starting the deamon with the www-data user and this did not solve the issue.

**EDIT**:

I solved this by copying the virtual hosts file into the default one and then disabling the old one with a2dissite. I have no idea how I can do it &quot;properly&quot; and set it so apache goes to the virtual host I want it to though.

Target WSGI script cannot be loaded as Python module

I have a Ubuntu server running Apache2 with PHP 5. In the php.ini I set `display_errors =  On` and `error_reporting =  E_ALL | E_STRICT`, but PHP is still not displaying error messages. I&#39;m also using Apache virtual hosts.

Also, what is the most strict error reporting PHP5.3 has to offer? I want my code to as up-to-date and future-proof as possible.

PHP not displaying errors even though display_errors = On

We have some very basic mod_rewrite rules:

    RewriteRule ^something.swf$ http://www.newdomain.com/something.swf [R=302,L]

mod_rewrite seems to do its job, and if the user is accessing:

`something.swf?param=value`, it is redirected correctly to `http://www.newdomain.com/something.swf?param=value`

the problem is in this situation:

    www.olddomain.com/something.swf?param=URL_ENCODED_VALUE

what ends up happening is mod_rewrite takes it upon it self to re-urlencode the query string param

so what the user ends up with is:

    www.olddomain.com/something.swf?param=URL_ENCODED_VALUE

REDIRECTED TO

    www.newdomain.com/something.swf?param=URL_ENCODED_VALUE_OF_URL_ENCODED_VALUE

so we end up with a double-urlencoded value. boourns!

While I do understand we could make a `\?(.*)` ... `?$1` rule for this, I am thinking there must be a way to tell mod_rewrite NOT to urlencode the query string params... we would like to avoid using 2 rules since valid paths are:

    something.swf (no query string)

and

    something.swf?someparams...

so yea, ideally... just tell mod_rewrite: please, no urlencoding of query string params... just direct passthru to the new URL via `R=302`.

mod_rewrite urlencoding an already urlencoded query string parameter - any way to disable this?

I want to define a variable in Apache server&#39;s `httpd.conf` configuration file.

Ex: variable static_path = `C:\codebase\snp_static`

and I want to use this variable (static_path) in `httpd.conf` where ever required.

Please tell me how can define a variable in `httpd.conf` file ? 

How to define a variable in apache&#39;s httpd.conf file?

&gt; **Possible Duplicate:**  
&gt; [Unable to locate tools.jar](https://stackoverflow.com/questions/5730815/unable-to-locate-tools-jar)  

&lt;!-- End of automatically inserted text --&gt;

I&#39;m trying to use ant to compile using this command :

     ant compile

I don&#39;t know if the problem comes from my windows 64bit, or by something else. Because I have java Installed in the 64 &amp; 32 prog files. 

![Java 64 &amp; 32][1]

I downloaded `apache-ant-1.8.2-bin` and putted it in C:\Program Files\apache-ant-1.8.2

I tried to put ant everywhere, I switched also the ENV PATH between java 64 and 32 but everytime I get this error message :

&gt; Unable to locate tools.jar. Expected to find it in C:\Program
&gt; Files\Java\jre6\lib\tools.jar

I searched for tools.jar in the ant lib folder, in the java 64 and 32, but no trace of it in the system.

What do you think ? 

  [1]: http://i.stack.imgur.com/Rezya.png

Content Type	Original Author	Original Content on Stackoverflow
Question	anbusekar	View Question on Stackoverflow
Solution 1 - Php	Konerak	View Answer on Stackoverflow
Solution 2 - Php	Nicola Peluchetti	View Answer on Stackoverflow

The server encountered an internal error or misconfiguration and was unable to complete your request

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

jsoup posting and cookie

Load HTML template with JavaScript

Attributions