XAMPP - Access forbidden

Q: Access forbidden! New XAMPP security concept: Access to the requested directory is only available from the local network. This setting can be configured in the file "httpd-xampp.conf". A: Mark the like “Deny from all” as a comment at the

Display phpmyadmin

// ---------------------- this is file config.inc.php -----------------------
// ---------------- locate c:/wampp/apps/phpmyadmin3.2.0.1/ -----------------------

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin3.2.0.1/"

# to give access to phpmyadmin from outside
# replace the lines
#
# Order Deny,Allow
# Deny from all
# Allow from 127.0.0.1
#
# by
#
# Order Allow,Deny
# Allow from all
#


Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
#Allow from 172.30.118.130
Allow from all




// ---------------------- this is file phpmyadmin.conf -----------------------
// ---------------- locate c:/wampp/alias/phpmyadmin.conf -----------------------

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
#$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>PHP

Create Domain in Localhost

1. Edit File httpd.conf then create VirtualHost


ServerName wordpress
ServerAlias wordpress
DocumentRoot "G:/03.DATA.WEB/00A.Personal/020.warungilmu.info"

Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all



2. Edit file Hosts in C:\Windows\System32\drivers\etc\hosts

127.0.0.1 localhost
127.0.0.1 wordpress

3. Restart Apache

Cron PHP script sheduller

## 1. Create php file ##

// your code to run via cron
// Updates stock
< ? php

$dbhost="localhost";// YOUR HOST NAME USUALLY LOCALHOST
$dbuser="root"; // YOUR DATA BASE USER NAME USUALLY ROOT
$dbpass="pass"; // YOUR DATA BASE PASSWORD
$dbname="";// YOUR DATA BASE NAME

mysql_connect($dbhost, $dbuser, $dbpass) or die("CANNOT CONNECT TO DB-HOST");
mysql_select_db($dbname) or die("DATABASE NAME PROBLEM");

$sql = "UPDATE accountinfo a set TAG = (SELECT b.location FROM ocsweb.frisianipmapping b , ocsweb.hardware c where b.IPmapping =c.IPADDR and a.hardware_Id=c.id)";
mysql_query($sql) or die("SQL ERROR:

---

".$sql);


?>


## 2. SETTING ENVIRONMENT ##

- click mycomputer >> properties >> environmen, then add the variable of 'PATH' with ";C:\xampp\php\"

## 3. CREATE BATCH FILE ##

@echo off
echo schedulle_running
php update.location.php

## 4. SETTING CRON SCHEDULE ##

start >> control panel >> schedule, choose the batch file

make_sock: could not bind to port 80

Apache logs error: make_sock: could not bind to port 80
solution : stop the service world wide web apps publishing

Setting SSL Apache

1. Copy Certificate, berikut ini menjadi file *.crt

-----BEGIN CERTIFICATE-----
MIIFxjCCBK6gAwIBAgIQL9k9yqnzZKCwLvjfOH0XezANBgkqhkiG9w0BAQUFADCB
+9jXmJstZGB1m5cE7uQg4sDdU8Z4+vjzBq7PWIXlNqDn5NFuGKlZ6pSL
-----END CERTIFICATE-----

2. Buka file httpd-ssl.conf
3. Cari file *.crt
4. Simpan File
5. Restart Apache

Bagaimana uninstall the Apache 2.x Web server pada Windows platforms?

How to uninstall the Apache 2.x Web server on the Windows platforms?

Prosedure

1. Untuk uninstall Apache sebagai service, buka Command Prompt window.
   
2. Buka pada Apache installation directory, or wherever apache.exe is located. For Example, C:\Program Files\Apache Group\Apache2\bin.
3. Dengan command prompt, ketik 'apache -k uninstall' - tanpa quotes
   
4. Lihat Windows Services and check that Apache2 is no longer listed as a service.
5. Klik Add/Remove Programs in the Control Panel, kemudian remove Apache HTTP Server
6. Hapus the Apache installation directory in Windows Explorer. For example: C:\Apache.

Selamat Mencoba!