Page 1 of 2

securing XAMPP in CENTOS 6

PostPosted: 18. November 2015 17:04
by logtech

You will probably redirect me to another forum or some sort of but I would like to test that first :) If I use security script build in XAMPP installation - /opt/lampp/lampp security whats going to happen? Well its obvious XAMPP would be a bit more secure than it is. PHP will get new password and that is ok. MySQL root will get the password. I use Mr. Password (another cheap software without any support) and get the feelings after applying that script Mr. password will stop working.

But let me first try and let you know. Thank You.

Re: securing XAMPP in CENTOS 6

PostPosted: 18. November 2015 17:12
by Altrea

I don't see any question here to answer :!: :?:

logtech wrote:If I use security script build in XAMPP installation - /opt/lampp/lampp security whats going to happen?

On Windows the security functions are obsolet.

logtech wrote:PHP will get new password and that is ok.

no. The folder where the admin page is saved gets password protected (if that is the same as on Windows)

logtech wrote:MySQL root will get the password.


logtech wrote:Well its obvious XAMPP would be a bit more secure than it is.

Security is always based on the environment you want to achieve.

logtech wrote:I use Mr. Password (another cheap software without any support) and get the feelings after applying that script Mr. password will stop working.

These are completely independent security tools.

best wishes,

Re: securing XAMPP in CENTOS 6

PostPosted: 18. November 2015 17:21
by logtech
Hello Mr. Altrea,

here is my first question :) :

XAMPP: Quick security check...
XAMPP: Your XAMPP pages are NOT secured by a password.
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Password:
XAMPP: Password (again):
/opt/lampp/share/xampp/checkapache: line 41: /opt/lampp/htdocs/xampp/.htaccess: No such file or directory
cp: cannot stat `/opt/lampp/htdocs/xampp/.htaccess': No such file or directory
cp: cannot stat `/opt/lampp/htdocs/xampp/.htaccess': No such file or directory
chmod: cannot access `/opt/lampp/htdocs/xampp/.htaccess': No such file or directory
chmod: cannot access `/opt/lampp/htdocs/webalizer/.htaccess': No such file or directory
chmod: cannot access `/opt/lampp/phpmyadmin/.htaccess': No such file or directory

My concern is "No such file or directory" should I worry about that?

Re: securing XAMPP in CENTOS 6

PostPosted: 18. November 2015 17:40
by Altrea
Simply don't use the security script so you don't need to be worried about such messages.

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 03:04
by logtech
OK fair enough, then how can I secure MySQL and PHP since I am worry about these two the most

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 06:21
by Altrea
Security is always related to the environment you want to achieve.
Xampp is by default secure enough to run as local test and development environment.
So please tell us why you think you had to add extra security.

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 14:06
by logtech
I use internally, so I would like to secure as much as possible. I can open http://IP/phpmyadmin/ without any passwords.

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 16:44
by Altrea
Then you have two problems:
- You are using XAMPP in an environment it is not designed and configured for (as live production server). Don't use XAMPP, instead install and secure the single components on your own. That is far more secure, performant, stable and scalable.
- Your new XAMPP security concept does not work properly. Either you have changed something or the it is broken in the current release. To check that please show us your Apache httpd.conf and httpd-xampp.conf files. Normally you can not access phpmyadmin from your network. You should get an HTTP status code 403 with some words about the new security concept.

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 17:26
by logtech
when I use this: http://SERVERIP/security/xamppsecurity.php I have 404

Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404

but when I use http://SERVERIP/phpmyadmin - it opens without asking for any users or passwords. Here re my configs:

# This is the main Apache HTTP server configuration file. It contains the
# configuration directives that give the server its instructions.
# See <URL:> for detailed information.
# In particular, see
# <URL:>
# for a discussion of each configuration directive.
# Do NOT simply read the instructions in here without understanding
# what they do. They're here only as hints or reminders. If you are unsure
# consult the online docs. You have been warned.
# Configuration and logfile names: If the filenames you specify for many
# of the server's control files begin with "/" (or "drive:/" for Win32), the
# server will use that explicit path. If the filenames do *not* begin
# with "/", the value of ServerRoot is prepended -- so 'log/access_log'
# with ServerRoot set to '/www' will be interpreted by the
# server as '/www/log/access_log', where as '/log/access_log' will be
# interpreted as '/log/access_log'.

# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
# Do not add a slash at the end of the directory path. If you point
# ServerRoot at a non-local disk, be sure to specify a local disk on the
# Mutex directive, if file-based mutexes are used. If you wish to share the
# same ServerRoot for multiple httpd daemons, you will need to change at
# least PidFile.
ServerRoot "/opt/lampp"

# Mutex: Allows you to set the mutex mechanism and mutex file directory
# for individual mutexes, or change the global defaults
# Uncomment and change the directory if mutexes are file-based and the default
# mutex file directory is not on a local disk or is not appropriate for some
# other reason.
# Mutex default:logs

# Listen: Allows you to bind Apache to specific IP addresses and/or
# ports, instead of the default. See also the <VirtualHost>
# directive.
# Change this to Listen on specific IP addresses as shown below to
# prevent Apache from glomming onto all bound IP addresses.
Listen 80

# Dynamic Shared Object (DSO) Support
# To be able to use the functionality of a module which was built as a DSO you
# have to place corresponding `LoadModule' lines at this location so the
# directives contained in it are actually available _before_ they are used.
# Statically compiled modules (those listed by `httpd -l') do not need
# to be loaded here.
# Example:
# LoadModule foo_module modules/
LoadModule authn_file_module modules/
LoadModule authn_dbm_module modules/
LoadModule authn_anon_module modules/
LoadModule authn_dbd_module modules/
LoadModule authn_socache_module modules/
LoadModule authn_core_module modules/
LoadModule authz_host_module modules/
LoadModule authz_groupfile_module modules/
LoadModule authz_user_module modules/
LoadModule authz_dbm_module modules/
LoadModule authz_owner_module modules/
LoadModule authz_dbd_module modules/
LoadModule authz_core_module modules/
LoadModule authnz_ldap_module modules/
LoadModule access_compat_module modules/
LoadModule auth_basic_module modules/
LoadModule auth_form_module modules/
LoadModule auth_digest_module modules/
LoadModule allowmethods_module modules/
LoadModule file_cache_module modules/
LoadModule cache_module modules/
LoadModule cache_disk_module modules/
LoadModule socache_shmcb_module modules/
LoadModule socache_dbm_module modules/
LoadModule socache_memcache_module modules/
LoadModule dbd_module modules/
LoadModule bucketeer_module modules/
LoadModule dumpio_module modules/
LoadModule echo_module modules/
LoadModule case_filter_module modules/
LoadModule case_filter_in_module modules/
LoadModule buffer_module modules/
LoadModule ratelimit_module modules/
LoadModule reqtimeout_module modules/
LoadModule ext_filter_module modules/
LoadModule request_module modules/
LoadModule include_module modules/
LoadModule filter_module modules/
LoadModule substitute_module modules/
LoadModule sed_module modules/
LoadModule charset_lite_module modules/
LoadModule deflate_module modules/
LoadModule mime_module modules/
LoadModule ldap_module modules/
LoadModule log_config_module modules/
LoadModule log_debug_module modules/
LoadModule logio_module modules/
LoadModule env_module modules/
LoadModule mime_magic_module modules/
LoadModule cern_meta_module modules/
LoadModule expires_module modules/
LoadModule headers_module modules/
LoadModule usertrack_module modules/
LoadModule unique_id_module modules/
LoadModule setenvif_module modules/
LoadModule version_module modules/
LoadModule remoteip_module modules/
LoadModule proxy_module modules/
LoadModule proxy_connect_module modules/
LoadModule proxy_ftp_module modules/
LoadModule proxy_http_module modules/
LoadModule proxy_fcgi_module modules/
LoadModule proxy_scgi_module modules/
LoadModule proxy_ajp_module modules/
LoadModule proxy_balancer_module modules/
LoadModule proxy_express_module modules/
LoadModule session_module modules/
LoadModule session_cookie_module modules/
LoadModule session_dbd_module modules/
LoadModule slotmem_shm_module modules/
LoadModule ssl_module modules/
LoadModule lbmethod_byrequests_module modules/
LoadModule lbmethod_bytraffic_module modules/
LoadModule lbmethod_bybusyness_module modules/
LoadModule lbmethod_heartbeat_module modules/
LoadModule unixd_module modules/
LoadModule dav_module modules/
LoadModule status_module modules/
LoadModule autoindex_module modules/
LoadModule info_module modules/
LoadModule suexec_module modules/
LoadModule cgi_module modules/
LoadModule cgid_module modules/
LoadModule dav_fs_module modules/
LoadModule vhost_alias_module modules/
LoadModule negotiation_module modules/
LoadModule dir_module modules/
LoadModule actions_module modules/
LoadModule speling_module modules/
LoadModule userdir_module modules/
LoadModule alias_module modules/
LoadModule rewrite_module modules/

LoadModule php4_module modules/
LoadModule php5_module modules/

<IfModule unixd_module>
# If you wish httpd to run as a different user or group, you must run
# httpd as root initially and it will switch.
# User/Group: The name (or #number) of the user/group to run httpd as.
# It is usually good practice to create a dedicated user and group for
# running httpd, as with most system services.
User daemon
Group daemon

# 'Main' server configuration
# The directives in this section set up the values used by the 'main'
# server, which responds to any requests that aren't handled by a
# <VirtualHost> definition. These values also provide defaults for
# any <VirtualHost> containers you may define later in the file.
# All of these directives may appear inside <VirtualHost> containers,
# in which case these default settings will be overridden for the
# virtual host being defined.

# ServerAdmin: Your address, where problems with the server should be
# e-mailed. This address appears on some server-generated pages, such
# as error documents. e.g.
ServerAdmin myemail

# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
# If your host doesn't have a registered DNS name, enter its IP address here.
ServerName localhost

# Deny access to the entirety of your server's filesystem. You must
# explicitly permit access to web content directories in other
# <Directory> blocks below.
<Directory />
AllowOverride none
Require all denied

# Note that from this point forward you must specifically allow
# particular features to be enabled - so if something's not working as
# you might expect, make sure that you have specifically enabled it
# below.

# DocumentRoot: The directory out of which you will serve your
# documents. By default, all requests are taken from this directory, but
# symbolic links and aliases may be used to point to other locations.
DocumentRoot "/opt/lampp/htdocs/"
<Directory "/opt/lampp/htdocs/">
# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
# The Options directive is both complicated and important. Please see
# for more information.
#Options Indexes FollowSymLinks
Options Indexes FollowSymLinks ExecCGI Includes

# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#AllowOverride None
# since XAMPP 1.4:
AllowOverride All

# Controls who can get stuff from this server.
Require all granted

# DirectoryIndex: sets the file that Apache will serve if a directory
# is requested.
<IfModule dir_module>
#DirectoryIndex index.html
DirectoryIndex index.html index.html.var index.php index.php3 index.php4

# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
<Files ".ht*">
Require all denied

# ErrorLog: The location of the error log file.
# If you do not specify an ErrorLog directive within a <VirtualHost>
# container, error messages relating to that virtual host will be
# logged here. If you *do* define an error logfile for a <VirtualHost>
# container, that host's errors will be logged there and not here.
ErrorLog "logs/error_log"

# LogLevel: Control the number of messages logged to the error_log.
# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn

<IfModule log_config_module>
# The following directives define some format nicknames for use with
# a CustomLog directive (see below).
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common

<IfModule logio_module>
# You need to enable mod_logio.c to use %I and %O
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio

# The location and format of the access logfile (Common Logfile Format).
# If you do not define any access logfiles within a <VirtualHost>
# container, they will be logged here. Contrariwise, if you *do*
# define per-<VirtualHost> access logfiles, transactions will be
# logged therein and *not* in this file.
CustomLog "logs/access_log" common

# If you prefer a logfile with access, agent, and referer information
# (Combined Logfile Format) you can use the following directive.
#CustomLog "logs/access_log" combined

<IfModule alias_module>
# Redirect: Allows you to tell clients about documents that used to
# exist in your server's namespace, but do not anymore. The client
# will make a new request for the document at its new location.
# Example:
# Redirect permanent /foo

# Alias: Maps web paths into filesystem paths and is used to
# access content that does not live under the DocumentRoot.
# Example:
# Alias /webpath /full/filesystem/path
# If you include a trailing / on /webpath then the server will
# require it to be present in the URL. You will also likely
# need to provide a <Directory> section to allow access to
# the filesystem path.

# ScriptAlias: This controls which directories contain server scripts.
# ScriptAliases are essentially the same as Aliases, except that
# documents in the target directory are treated as applications and
# run by the server when requested rather than as documents sent to the
# client. The same rules about trailing "/" apply to ScriptAlias
# directives as to Alias.
ScriptAlias /cgi-bin/ "/opt/lampp/cgi-bin/"


<IfModule cgid_module>
# ScriptSock: On threaded servers, designate the path to the UNIX
# socket used to communicate with the CGI daemon of mod_cgid.
#Scriptsock logs/cgisock

# "/opt/lampp/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
<Directory "/opt/lampp/cgi-bin">
AllowOverride None
Options None
Require all granted

<IfModule mime_module>
# TypesConfig points to the file containing the list of mappings from
# filename extension to MIME-type.
TypesConfig etc/mime.types

# AddType allows you to add to or override the MIME configuration
# file specified in TypesConfig for specific file types.
#AddType application/x-gzip .tgz
# AddEncoding allows you to have certain browsers uncompress
# information on the fly. Note: Not all browsers support this.
#AddEncoding x-compress .Z
#AddEncoding x-gzip .gz .tgz
# If the AddEncoding directives above are commented-out, then you
# probably should define those extensions to indicate media types:
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz

# AddHandler allows you to map certain file extensions to "handlers":
# actions unrelated to filetype. These can be either built into the server
# or added with the Action directive (see below)
# To use CGI scripts outside of ScriptAliased directories:
# (You will also need to add "ExecCGI" to the "Options" directive.)
#AddHandler cgi-script .cgi
# XAMPP, since LAMPP 0.9.8:
AddHandler cgi-script .cgi .pl

# For type maps (negotiated resources):
#AddHandler type-map var

# Filters allow you to process content before it is sent to the client.
# To parse .shtml files for server-side includes (SSI):
# (You will also need to add "Includes" to the "Options" directive.)
AddType text/html .shtml
AddOutputFilter INCLUDES .shtml

# The mod_mime_magic module allows the server to use various hints from the
# contents of the file itself to determine its type. The MIMEMagicFile
# directive tells the module where the hint definitions are located.
#MIMEMagicFile etc/magic

# Customizable error responses come in three flavors:
# 1) plain text 2) local redirects 3) external redirects
# Some examples:
#ErrorDocument 500 "The server made a boo boo."
#ErrorDocument 404 /missing.html
#ErrorDocument 404 "/cgi-bin/"
#ErrorDocument 402

# MaxRanges: Maximum number of Ranges in a request before
# returning the entire resource, or one of the special
# values 'default', 'none' or 'unlimited'.
# Default setting is to accept 200 Ranges.
#MaxRanges unlimited

# EnableMMAP and EnableSendfile: On systems that support it,
# memory-mapping or the sendfile syscall may be used to deliver
# files. This usually improves server performance, but must
# be turned off when serving from networked-mounted
# filesystems or if support for these functions is otherwise
# broken on your system.
# Defaults: EnableMMAP On, EnableSendfile Off
EnableMMAP off
EnableSendfile off

# Supplemental configuration
# The configuration files in the etc/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server, or you may simply copy their contents here and change as
# necessary.

# Server-pool management (MPM specific)
#Include etc/extra/httpd-mpm.conf

# Multi-language error messages
Include etc/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include etc/extra/httpd-autoindex.conf

# Language settings
#Include etc/extra/httpd-languages.conf

# User home directories
#Include etc/extra/httpd-userdir.conf

# Real-time info on requests and configuration
#Include etc/extra/httpd-info.conf

# Virtual hosts
#Include etc/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
#Include etc/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include etc/extra/httpd-dav.conf

# Various default settings
Include etc/extra/httpd-default.conf

# Configure mod_proxy_html to understand HTML4/XHTML1
<IfModule proxy_html_module>
Include etc/extra/proxy-html.conf

# Secure (SSL/TLS) connections
<IfModule ssl_module>
<IfDefine SSL>
Include etc/extra/httpd-ssl.conf
# Note: The following must must be present to support
# starting without SSL on platforms with no /dev/random equivalent
# but a statically compiled-in mod_ssl.
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin

Include etc/extra/httpd-xampp.conf
Include "/opt/lampp/apache2/conf/httpd.conf"

HERE IS httpd-xampp.conf:

#<IfDefine PHP4>
#LoadModule php4_module modules/
#<IfDefine PHP5>
#LoadModule php5_module modules/

# We will enable it by default
#<IfDefine PHP>
LoadModule php5_module modules/

LoadModule perl_module modules/

Alias /phpmyadmin "/opt/lampp/phpmyadmin"
Alias /phpsqliteadmin "/opt/lampp/phpsqliteadmin"

# since XAMPP 1.4.3
<Directory "/opt/lampp/phpmyadmin">
AllowOverride AuthConfig Limit
Require all granted

<Directory "/opt/lampp/phpsqliteadmin">
AllowOverride AuthConfig Limit
Require all granted

# since LAMPP 1.0RC1
AddType application/x-httpd-php .php .php3 .php4

XBitHack on

# since 0.9.8 we've mod_perl
<IfModule mod_perl.c>
AddHandler perl-script .pl
PerlHandler ModPerl::PerlRunPrefork
PerlOptions +ParseHeaders
PerlSendHeader On

# demo for mod_perl responsehandler
#PerlModule Apache::CurrentTime
#<Location /time>
# SetHandler modperl
# PerlResponseHandler Apache::CurrentTime

# AcceptMutex sysvsem is default but on some systems we need this
# thanks to jeff ort for this hint
#AcceptMutex flock
#LockFile /opt/lampp/logs/accept.lock

# this makes mod_dbd happy - oswald, 02aug06
# mod_dbd doesn't work in Apache 2.2.3: getting always heaps of "glibc detected *** corrupted double-linked list" on shutdown - oswald, 10sep06
#DBDriver sqlite3

# New XAMPP security concept
<LocationMatch "^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-status|server-info))">
# Require local
Require all granted
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 17:41
by Altrea
logtech wrote:but when I use http://SERVERIP/phpmyadmin - it opens without asking for any users or passwords.

Sure. Because the security concept is not activated (any more)

logtech wrote:#
# New XAMPP security concept
<LocationMatch "^/(?i:(?:xampp|security|licenses|phpmyadmin|webalizer|server-status|server-info))">
# Require local
Require all granted
ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var

remove the # in front of the line Require local, remove the line Require all granted completely and restart Apache.
Then you can access phpmyadmin only from the server XAMPP is running from as it was on default.

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 17:54
by logtech
Oh MAN!!!!

Access forbidden!
New XAMPP security concept:
Acces to the requested object is only available from the local network.
This setting can be configured in the file "httpd-xampp.conf".
If you think this is a server error, please contact the webmaster.
Error 403
Apache/2.4.16 (Unix) OpenSSL/1.0.1p PHP/5.6.12 mod_perl/2.0.8-dev Perl/v5.16.3

THATS WHAT I NEED !!!!!!! Hmmm what about MYSQL and access from network?

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 18:02
by Altrea
Did you define any MySQL User that are permitted to access from external hosts?

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 18:36
by logtech
well, MYSQL is accessible via network and I believe MYSQL ha no root password set according to the ./xampp security

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 19:16
by Altrea
root can by default only connect from localhost unless you changed that too

Re: securing XAMPP in CENTOS 6

PostPosted: 19. November 2015 20:12
by logtech
I can change that. If I change in my config:


skip-networking uncommitted I have this:

Mr Password Error
Type: sql_connect_error
Message: SQLSTATE[HY000] [2002] Connection refused

is there any way to limit the connection from that server IP only? I have used bind-address=serverIP in # The MySQL server
[mysqld], I have both on the same serevr