Build Your Own Debian/Ubuntu LAMP Server – Quick & Easy Do it Yourself Installation
-
- Apache 2 – Linux Web server
-
- MySQL 5 – MySQL Database Server
-
- PHP4/5 – PHP Scripting Language
-
- phpMyAdmin – Web-based database admin software.
Note: Linux + Apache + MySQL + PHP/Perl together commonly known as LAMP Server.
First, let us prepare a system that has a minimum requirement of Debian/Ubuntu version of Linux with at least 256MB of RAM available. Anything less than this minimum ram will cause lot of problems since we are running a server along especially MySQL and Webmin requires lots of RAM to run properly. MySQL will give you this nasty error “cannot connect to mysql.sock” if you don’t have enough memory in your server.
I love Debian/Ubuntu based Linux because of my enormous affinity towards this command apt-get. As a starter knowing this one command, It is so easy to install packages and you don’t need to worry about package dependency and configuration. You need to buy a dedicated server or a VPS package if you want to setup your own server. If you want to experiment with the server and installation it is recommended to buy a VPS package. Believe it or not it is so easy to install and configure your server yourself even though you are new are to Linux and dedicated/VPS hosting.
First download PuTTy if you are accessing your server through SSH. Just enter the IP of your server with root login to access your host. As you probably know, Webmin is a freely available server control panel and we will setup this once we have completed the LAMP server and Mail Server. Webmin makes more easier for us to fine tune our Linux box.
Before proceeding to install, update the necessary packages with Debian with this command.
apt-get install update
1. Installing Apache + PHP
Apache is one of the most famous web server which runs on most Linux based servers. With just few commands you can configure apache to run with PHP 4 or PHP 5.
If you want to install PHP 4, just apt-get
apt-get install apache2 php4 libapache2-mod-php4
To install PHP5, just run the following on Linux shell. Note that if you don’t specify packages with ‘4’, PHP5 will be automatically installed.
apt-get install apache2 php5 libapache2-mod-php5
Apache configuration file is located at: /etc/apache2/apache2.conf and your web folder is /var/www.
To check whether php is installed and running properly, just create a test.php in your /var/www folder with phpinfo() function exactly as shown below.
vi /var/www/test.php
# test.php
System
|
Windows NT AKURA-PC 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) i586 |
Build Date |
Jan 9 2019 15:05:35 |
Compiler |
MSVC11 (Visual C++ 2012) |
Architecture |
x86 |
Configure Command |
cscript /nologo configure.js “–enable-snapshot-build” “–disable-isapi” “–enable-debug-pack” “–without-mssql” “–without-pdo-mssql” “–without-pi3web” “–with-pdo-oci=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared” “–with-oci8-12c=c:\php-sdk\oracle\x86\instantclient_12_1\sdk,shared” “–enable-object-out-dir=../obj/” “–enable-com-dotnet=shared” “–with-mcrypt=static” “–without-analyzer” “–with-pgo” |
Server API |
Apache 2.0 Handler |
Virtual Directory Support |
enabled |
Configuration File (php.ini) Path |
C:\Windows |
Loaded Configuration File |
C:\xampp\php\php.ini |
Scan this dir for additional .ini files |
(none) |
Additional .ini files parsed |
(none) |
PHP API |
20131106 |
PHP Extension |
20131226 |
Zend Extension |
220131226 |
Zend Extension Build |
API220131226,TS,VC11 |
PHP Extension Build |
API20131226,TS,VC11 |
Debug Build |
no |
Thread Safety |
enabled |
Zend Signal Handling |
disabled |
Zend Memory Manager |
enabled |
Zend Multibyte Support |
provided by mbstring |
IPv6 Support |
enabled |
DTrace Support |
disabled |
Registered PHP Streams |
php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar |
Registered Stream Socket Transports |
tcp, udp, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2 |
Registered Stream Filters |
convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, zlib.*, bzip2.* |
This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies |
Configuration
apache2handler
Apache Version |
Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 |
Apache API Version |
20120211 |
Server Administrator |
[email protected] |
Hostname:Port |
localhost:80 |
Max Requests |
Per Child: 0 – Keep Alive: on – Max Per Connection: 100 |
Timeouts |
Connection: 300 – Keep-Alive: 5 |
Virtual Server |
No |
Server Root |
C:/xampp/apache |
Loaded Modules |
core mod_win32 mpm_winnt http_core mod_so mod_access_compat mod_actions mod_alias mod_allowmethods mod_asis mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_groupfile mod_authz_host mod_authz_user mod_autoindex mod_cgi mod_dav_lock mod_dir mod_env mod_headers mod_include mod_info mod_isapi mod_log_config mod_cache_disk mod_mime mod_negotiation mod_proxy mod_proxy_ajp mod_rewrite mod_setenvif mod_socache_shmcb mod_ssl mod_status mod_version mod_php5 |
Directive |
Local Value |
Master Value |
engine |
1 |
1 |
last_modified |
0 |
0 |
xbithack |
0 |
0 |
Apache Environment
Variable |
Value |
REDIRECT_HTTP_AUTHORIZATION |
no value |
REDIRECT_MIBDIRS |
C:/xampp/php/extras/mibs |
REDIRECT_MYSQL_HOME |
\xampp\mysql\bin |
REDIRECT_OPENSSL_CONF |
C:/xampp/apache/bin/openssl.cnf |
REDIRECT_PHP_PEAR_SYSCONF_DIR |
\xampp\php |
REDIRECT_PHPRC |
\xampp\php |
REDIRECT_TMP |
\xampp\tmp |
REDIRECT_STATUS |
200 |
HTTP_AUTHORIZATION |
no value |
MIBDIRS |
C:/xampp/php/extras/mibs |
MYSQL_HOME |
\xampp\mysql\bin |
OPENSSL_CONF |
C:/xampp/apache/bin/openssl.cnf |
PHP_PEAR_SYSCONF_DIR |
\xampp\php |
PHPRC |
\xampp\php |
TMP |
\xampp\tmp |
HTTP_HOST |
localhost |
HTTP_CONNECTION |
keep-alive |
HTTP_UPGRADE_INSECURE_REQUESTS |
1 |
HTTP_USER_AGENT |
Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36 |
HTTP_ACCEPT |
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 |
HTTP_REFERER |
http://localhost/fiverr/news?start=100 |
HTTP_ACCEPT_ENCODING |
gzip, deflate, br |
HTTP_ACCEPT_LANGUAGE |
pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7 |
HTTP_COOKIE |
PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005 |
PATH |
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ |
SystemRoot |
C:\Windows |
COMSPEC |
C:\Windows\system32\cmd.exe |
PATHEXT |
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC |
WINDIR |
C:\Windows |
SERVER_SIGNATURE |
<address>Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 Server at localhost Port 80</address> |
SERVER_SOFTWARE |
Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 |
SERVER_NAME |
localhost |
SERVER_ADDR |
::1 |
SERVER_PORT |
80 |
REMOTE_ADDR |
::1 |
DOCUMENT_ROOT |
C:/xampp/htdocs |
REQUEST_SCHEME |
http |
CONTEXT_PREFIX |
no value |
CONTEXT_DOCUMENT_ROOT |
C:/xampp/htdocs |
SERVER_ADMIN |
[email protected] |
SCRIPT_FILENAME |
C:/xampp/htdocs/fiverr/index.php |
REMOTE_PORT |
61743 |
REDIRECT_URL |
/fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server |
GATEWAY_INTERFACE |
CGI/1.1 |
SERVER_PROTOCOL |
HTTP/1.1 |
REQUEST_METHOD |
GET |
QUERY_STRING |
no value |
REQUEST_URI |
/fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server |
SCRIPT_NAME |
/fiverr/index.php |
HTTP Headers Information
HTTP Request Headers |
HTTP Request |
GET /fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server HTTP/1.1 |
Host |
localhost |
Connection |
keep-alive |
Upgrade-Insecure-Requests |
1 |
User-Agent |
Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36 |
Accept |
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 |
Referer |
http://localhost/fiverr/news?start=100 |
Accept-Encoding |
gzip, deflate, br |
Accept-Language |
pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7 |
Cookie |
PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005 |
HTTP Response Headers |
X-Powered-By |
PHP/5.6.40 |
bcmath
Directive |
Local Value |
Master Value |
bcmath.scale |
0 |
0 |
bz2
BZip2 Support |
Enabled |
Stream Wrapper support |
compress.bzip2:// |
Stream Filter support |
bzip2.decompress, bzip2.compress |
BZip2 Version |
1.0.6, 6-Sept-2010 |
calendar
Core
Directive |
Local Value |
Master Value |
allow_url_fopen |
On |
On |
allow_url_include |
Off |
Off |
always_populate_raw_post_data |
0 |
0 |
arg_separator.input |
& |
& |
arg_separator.output |
& |
& |
asp_tags |
Off |
Off |
auto_append_file |
no value |
no value |
auto_globals_jit |
On |
On |
auto_prepend_file |
no value |
no value |
browscap |
C:\xampp\php\extras\browscap.ini |
C:\xampp\php\extras\browscap.ini |
default_charset |
UTF-8 |
UTF-8 |
default_mimetype |
text/html |
text/html |
disable_classes |
no value |
no value |
disable_functions |
no value |
no value |
display_errors |
On |
On |
display_startup_errors |
On |
On |
doc_root |
no value |
no value |
docref_ext |
no value |
no value |
docref_root |
no value |
no value |
enable_dl |
Off |
Off |
enable_post_data_reading |
On |
On |
error_append_string |
no value |
no value |
error_log |
C:\xampp\php\logs\php_error_log |
C:\xampp\php\logs\php_error_log |
error_prepend_string |
no value |
no value |
error_reporting |
0 |
22527 |
exit_on_timeout |
Off |
Off |
expose_php |
On |
On |
extension_dir |
C:\xampp\php\ext |
C:\xampp\php\ext |
file_uploads |
On |
On |
highlight.comment |
#FF8000 |
#FF8000 |
highlight.default |
#0000BB |
#0000BB |
highlight.html |
#000000 |
#000000 |
highlight.keyword |
#007700 |
#007700 |
highlight.string |
#DD0000 |
#DD0000 |
html_errors |
On |
On |
ignore_repeated_errors |
Off |
Off |
ignore_repeated_source |
Off |
Off |
ignore_user_abort |
Off |
Off |
implicit_flush |
Off |
Off |
include_path |
C:\xampp\php\PEAR |
C:\xampp\php\PEAR |
input_encoding |
no value |
no value |
internal_encoding |
no value |
no value |
log_errors |
On |
On |
log_errors_max_len |
1024 |
1024 |
mail.add_x_header |
On |
On |
mail.force_extra_parameters |
no value |
no value |
mail.log |
no value |
no value |
max_execution_time |
30 |
30 |
max_file_uploads |
20 |
20 |
max_input_nesting_level |
64 |
64 |
max_input_time |
60 |
60 |
max_input_vars |
1000 |
1000 |
memory_limit |
128M |
128M |
open_basedir |
no value |
no value |
output_buffering |
4096 |
4096 |
output_encoding |
no value |
no value |
output_handler |
no value |
no value |
post_max_size |
8M |
8M |
precision |
14 |
14 |
realpath_cache_size |
16K |
16K |
realpath_cache_ttl |
120 |
120 |
register_argc_argv |
Off |
Off |
report_memleaks |
On |
On |
report_zend_debug |
On |
On |
request_order |
GP |
GP |
sendmail_from |
no value |
no value |
sendmail_path |
no value |
no value |
serialize_precision |
17 |
17 |
short_open_tag |
Off |
Off |
SMTP |
localhost |
localhost |
smtp_port |
25 |
25 |
sql.safe_mode |
Off |
Off |
sys_temp_dir |
no value |
no value |
track_errors |
Off |
Off |
unserialize_callback_func |
no value |
no value |
upload_max_filesize |
2M |
2M |
upload_tmp_dir |
C:\xampp\tmp |
C:\xampp\tmp |
user_dir |
no value |
no value |
user_ini.cache_ttl |
300 |
300 |
user_ini.filename |
.user.ini |
.user.ini |
variables_order |
GPCS |
GPCS |
windows.show_crt_warning |
Off |
Off |
xmlrpc_error_number |
0 |
0 |
xmlrpc_errors |
Off |
Off |
zend.detect_unicode |
On |
On |
zend.enable_gc |
On |
On |
zend.multibyte |
Off |
Off |
zend.script_encoding |
no value |
no value |
ctype
curl
cURL support |
enabled |
cURL Information |
7.59.0 |
Age |
4 |
Features |
AsynchDNS |
Yes |
CharConv |
No |
Debug |
No |
GSS-Negotiate |
No |
IDN |
Yes |
IPv6 |
Yes |
krb4 |
No |
Largefile |
Yes |
libz |
Yes |
NTLM |
Yes |
NTLMWB |
No |
SPNEGO |
Yes |
SSL |
Yes |
SSPI |
Yes |
TLS-SRP |
No |
Protocols |
dict, file, ftp, ftps, gopher, http, https, imap, imaps, ldap, pop3, pop3s, rtsp, scp, sftp, smb, smbs, smtp, smtps, telnet, tftp |
Host |
i386-pc-win32 |
SSL Version |
OpenSSL/1.0.2p |
ZLib Version |
1.2.7.3 |
libSSH Version |
libssh2/1.8.0 |
date
date/time support |
enabled |
“Olson” Timezone Database Version |
2016.10 |
Timezone Database |
internal |
Default timezone |
Europe/Berlin |
Directive |
Local Value |
Master Value |
date.default_latitude |
31.7667 |
31.7667 |
date.default_longitude |
35.2333 |
35.2333 |
date.sunrise_zenith |
90.583333 |
90.583333 |
date.sunset_zenith |
90.583333 |
90.583333 |
date.timezone |
Europe/Berlin |
Europe/Berlin |
dom
DOM/XML |
enabled |
DOM/XML API Version |
20031129 |
libxml Version |
2.9.4 |
HTML Support |
enabled |
XPath Support |
enabled |
XPointer Support |
enabled |
Schema Support |
enabled |
RelaxNG Support |
enabled |
ereg
Regex Library |
Bundled library enabled |
exif
EXIF Support |
enabled |
EXIF Version |
1.4 $Id: cad29b729548e4206f0697710cc9e177f26fdff3 $ |
Supported EXIF Version |
0220 |
Supported filetypes |
JPEG,TIFF |
Directive |
Local Value |
Master Value |
exif.decode_jis_intel |
JIS |
JIS |
exif.decode_jis_motorola |
JIS |
JIS |
exif.decode_unicode_intel |
UCS-2LE |
UCS-2LE |
exif.decode_unicode_motorola |
UCS-2BE |
UCS-2BE |
exif.encode_jis |
no value |
no value |
exif.encode_unicode |
ISO-8859-15 |
ISO-8859-15 |
fileinfo
fileinfo support |
enabled |
version |
1.0.5 |
libmagic |
517 |
filter
Input Validation and Filtering |
enabled |
Revision |
$Id: 5b79667bd9a68977a9b4f7505223a8e216e04908 $ |
Directive |
Local Value |
Master Value |
filter.default |
unsafe_raw |
unsafe_raw |
filter.default_flags |
no value |
no value |
ftp
gd
GD Support |
enabled |
GD Version |
bundled (2.1.0 compatible) |
FreeType Support |
enabled |
FreeType Linkage |
with freetype |
FreeType Version |
2.7.0 |
GIF Read Support |
enabled |
GIF Create Support |
enabled |
JPEG Support |
enabled |
libJPEG Version |
9 compatible |
PNG Support |
enabled |
libPNG Version |
1.5.26 |
WBMP Support |
enabled |
XPM Support |
enabled |
libXpm Version |
30512 |
XBM Support |
enabled |
WebP Support |
enabled |
Directive |
Local Value |
Master Value |
gd.jpeg_ignore_warning |
0 |
0 |
gettext
hash
hash support |
enabled |
Hashing Engines |
md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5 |
iconv
iconv support |
enabled |
iconv implementation |
“libiconv” |
iconv library version |
1.14 |
Directive |
Local Value |
Master Value |
iconv.input_encoding |
no value |
no value |
iconv.internal_encoding |
no value |
no value |
iconv.output_encoding |
no value |
no value |
json
json support |
enabled |
json version |
1.2.1 |
libxml
libXML support |
active |
libXML Compiled Version |
2.9.4 |
libXML Loaded Version |
20904 |
libXML streams |
enabled |
mbstring
Multibyte Support |
enabled |
Multibyte string engine |
libmbfl |
HTTP input encoding translation |
disabled |
libmbfl version |
1.3.2 |
mbstring extension makes use of “streamable kanji code filter and converter”, which is distributed under the GNU Lesser General Public License version 2.1. |
Multibyte (japanese) regex support |
enabled |
Multibyte regex (oniguruma) version |
5.9.5 |
Directive |
Local Value |
Master Value |
mbstring.detect_order |
no value |
no value |
mbstring.encoding_translation |
Off |
Off |
mbstring.func_overload |
0 |
0 |
mbstring.http_input |
no value |
no value |
mbstring.http_output |
no value |
no value |
mbstring.http_output_conv_mimetypes |
^(text/|application/xhtml\+xml) |
^(text/|application/xhtml\+xml) |
mbstring.internal_encoding |
no value |
no value |
mbstring.language |
neutral |
neutral |
mbstring.strict_detection |
Off |
Off |
mbstring.substitute_character |
no value |
no value |
mcrypt
mcrypt support |
enabled |
mcrypt_filter support |
enabled |
Version |
2.5.8 |
Api No |
20021217 |
Supported ciphers |
cast-128 gost rijndael-128 twofish cast-256 loki97 rijndael-192 saferplus wake blowfish-compat des rijndael-256 serpent xtea blowfish enigma rc2 tripledes arcfour |
Supported modes |
cbc cfb ctr ecb ncfb nofb ofb stream |
Directive |
Local Value |
Master Value |
mcrypt.algorithms_dir |
no value |
no value |
mcrypt.modes_dir |
no value |
no value |
mhash
MHASH support |
Enabled |
MHASH API Version |
Emulated Support |
mysql
MySQL Support |
enabled |
Active Persistent Links |
0 |
Active Links |
1 |
Client API version |
mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Directive |
Local Value |
Master Value |
mysql.allow_local_infile |
On |
On |
mysql.allow_persistent |
On |
On |
mysql.connect_timeout |
3 |
3 |
mysql.default_host |
no value |
no value |
mysql.default_password |
no value |
no value |
mysql.default_port |
3306 |
3306 |
mysql.default_socket |
MySQL |
MySQL |
mysql.default_user |
no value |
no value |
mysql.max_links |
Unlimited |
Unlimited |
mysql.max_persistent |
Unlimited |
Unlimited |
mysql.trace_mode |
Off |
Off |
mysqli
MysqlI Support |
enabled |
Client API library version |
mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Active Persistent Links |
0 |
Inactive Persistent Links |
0 |
Active Links |
0 |
Directive |
Local Value |
Master Value |
mysqli.allow_local_infile |
On |
On |
mysqli.allow_persistent |
On |
On |
mysqli.default_host |
no value |
no value |
mysqli.default_port |
3306 |
3306 |
mysqli.default_pw |
no value |
no value |
mysqli.default_socket |
no value |
no value |
mysqli.default_user |
no value |
no value |
mysqli.max_links |
Unlimited |
Unlimited |
mysqli.max_persistent |
Unlimited |
Unlimited |
mysqli.reconnect |
Off |
Off |
mysqli.rollback_on_cached_plink |
Off |
Off |
mysqlnd
mysqlnd |
enabled |
Version |
mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
Compression |
supported |
core SSL |
supported |
extended SSL |
not supported |
Command buffer size |
4096 |
Read buffer size |
32768 |
Read timeout |
31536000 |
Collecting statistics |
Yes |
Collecting memory statistics |
Yes |
Tracing |
n/a |
Loaded plugins |
mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password |
API Extensions |
mysql,mysqli,pdo_mysql |
mysqlnd statistics |
|
bytes_sent |
23440949 |
bytes_received |
22423355 |
packets_sent |
37402 |
packets_received |
178992 |
protocol_overhead_in |
715968 |
protocol_overhead_out |
149608 |
bytes_received_ok_packet |
0 |
bytes_received_eof_packet |
0 |
bytes_received_rset_header_packet |
128592 |
bytes_received_rset_field_meta_packet |
0 |
bytes_received_rset_row_packet |
150824 |
bytes_received_prepare_response_packet |
5242782 |
bytes_received_change_user_packet |
16777941 |
packets_sent_command |
18214 |
packets_received_ok |
0 |
packets_received_eof |
0 |
packets_received_rset_header |
14288 |
packets_received_rset_field_meta |
0 |
packets_received_rset_row |
17387 |
packets_received_prepare_response |
68370 |
packets_received_change_user |
77675 |
result_set_queries |
14245 |
non_result_set_queries |
2911 |
no_index_used |
3713 |
bad_index_used |
10 |
slow_queries |
0 |
buffered_sets |
14245 |
unbuffered_sets |
0 |
ps_buffered_sets |
0 |
ps_unbuffered_sets |
0 |
flushed_normal_sets |
0 |
flushed_ps_sets |
0 |
ps_prepared_never_executed |
0 |
ps_prepared_once_executed |
0 |
rows_fetched_from_server_normal |
63430 |
rows_fetched_from_server_ps |
0 |
rows_buffered_from_client_normal |
63430 |
rows_buffered_from_client_ps |
0 |
rows_fetched_from_client_normal_buffered |
63401 |
rows_fetched_from_client_normal_unbuffered |
0 |
rows_fetched_from_client_ps_buffered |
0 |
rows_fetched_from_client_ps_unbuffered |
0 |
rows_fetched_from_client_ps_cursor |
0 |
rows_affected_normal |
62759 |
rows_affected_ps |
0 |
rows_skipped_normal |
63430 |
rows_skipped_ps |
0 |
copy_on_write_saved |
56285 |
copy_on_write_performed |
184385 |
command_buffer_too_small |
401 |
connect_success |
444 |
connect_failure |
0 |
connection_reused |
0 |
reconnect |
0 |
pconnect_success |
399 |
active_connections |
18446744073709551174 |
active_persistent_connections |
18446744073709551217 |
explicit_close |
443 |
implicit_close |
0 |
disconnect_close |
0 |
in_middle_of_command_close |
0 |
explicit_free_result |
14245 |
implicit_free_result |
0 |
explicit_stmt_close |
0 |
implicit_stmt_close |
0 |
mem_emalloc_count |
63545 |
mem_emalloc_amount |
24480383 |
mem_ecalloc_count |
109760 |
mem_ecalloc_amount |
39705560 |
mem_erealloc_count |
32882 |
mem_erealloc_amount |
6212220 |
mem_efree_count |
174743 |
mem_efree_amount |
64412771 |
mem_malloc_count |
124952 |
mem_malloc_amount |
241502910 |
mem_calloc_count |
73201 |
mem_calloc_amount |
9711668 |
mem_realloc_count |
0 |
mem_realloc_amount |
0 |
mem_free_count |
202602 |
mem_free_amount |
251284467 |
mem_estrndup_count |
695 |
mem_strndup_count |
1824 |
mem_estndup_count |
759 |
mem_strdup_count |
2625 |
proto_text_fetched_null |
0 |
proto_text_fetched_bit |
0 |
proto_text_fetched_tinyint |
16707 |
proto_text_fetched_short |
1 |
proto_text_fetched_int24 |
0 |
proto_text_fetched_int |
14497 |
proto_text_fetched_bigint |
32571 |
proto_text_fetched_decimal |
87 |
proto_text_fetched_float |
0 |
proto_text_fetched_double |
0 |
proto_text_fetched_date |
0 |
proto_text_fetched_year |
0 |
proto_text_fetched_time |
0 |
proto_text_fetched_datetime |
9712 |
proto_text_fetched_timestamp |
0 |
proto_text_fetched_string |
105729 |
proto_text_fetched_blob |
0 |
proto_text_fetched_enum |
54151 |
proto_text_fetched_set |
0 |
proto_text_fetched_geometry |
0 |
proto_text_fetched_other |
0 |
proto_binary_fetched_null |
0 |
proto_binary_fetched_bit |
0 |
proto_binary_fetched_tinyint |
0 |
proto_binary_fetched_short |
0 |
proto_binary_fetched_int24 |
0 |
proto_binary_fetched_int |
0 |
proto_binary_fetched_bigint |
0 |
proto_binary_fetched_decimal |
0 |
proto_binary_fetched_float |
0 |
proto_binary_fetched_double |
0 |
proto_binary_fetched_date |
0 |
proto_binary_fetched_year |
0 |
proto_binary_fetched_time |
0 |
proto_binary_fetched_datetime |
0 |
proto_binary_fetched_timestamp |
0 |
proto_binary_fetched_string |
0 |
proto_binary_fetched_json |
0 |
proto_binary_fetched_blob |
0 |
proto_binary_fetched_enum |
0 |
proto_binary_fetched_set |
0 |
proto_binary_fetched_geometry |
0 |
proto_binary_fetched_other |
0 |
init_command_executed_count |
2 |
init_command_failed_count |
0 |
com_quit |
443 |
com_init_db |
341 |
com_query |
17387 |
com_field_list |
0 |
com_create_db |
0 |
com_drop_db |
0 |
com_refresh |
0 |
com_shutdown |
0 |
com_statistics |
0 |
com_process_info |
0 |
com_connect |
0 |
com_process_kill |
0 |
com_debug |
0 |
com_ping |
0 |
com_time |
0 |
com_delayed_insert |
0 |
com_change_user |
0 |
com_binlog_dump |
0 |
com_table_dump |
0 |
com_connect_out |
0 |
com_register_slave |
0 |
com_stmt_prepare |
0 |
com_stmt_execute |
0 |
com_stmt_send_long_data |
0 |
com_stmt_close |
0 |
com_stmt_reset |
0 |
com_stmt_set_option |
43 |
com_stmt_fetch |
0 |
com_deamon |
0 |
bytes_received_real_data_normal |
16218462 |
bytes_received_real_data_ps |
0 |
odbc
ODBC Support |
enabled |
Active Persistent Links |
0 |
Active Links |
0 |
ODBC library |
Win32 |
Directive |
Local Value |
Master Value |
odbc.allow_persistent |
On |
On |
odbc.check_persistent |
On |
On |
odbc.default_cursortype |
Static cursor |
Static cursor |
odbc.default_db |
no value |
no value |
odbc.default_pw |
no value |
no value |
odbc.default_user |
no value |
no value |
odbc.defaultbinmode |
return as is |
return as is |
odbc.defaultlrl |
return up to 4096 bytes |
return up to 4096 bytes |
odbc.max_links |
Unlimited |
Unlimited |
odbc.max_persistent |
Unlimited |
Unlimited |
openssl
OpenSSL support |
enabled |
OpenSSL Library Version |
OpenSSL 1.0.2p 14 Aug 2018 |
OpenSSL Header Version |
OpenSSL 1.0.2q 20 Nov 2018 |
Openssl default config |
c:/openssl-1.0.2p-win32/ssl/openssl.cnf |
Directive |
Local Value |
Master Value |
openssl.cafile |
C:\xampp\apache\bin\curl-ca-bundle.crt |
C:\xampp\apache\bin\curl-ca-bundle.crt |
openssl.capath |
no value |
no value |
pcre
PCRE (Perl Compatible Regular Expressions) Support |
enabled |
PCRE Library Version |
8.38 2015-11-23 |
Directive |
Local Value |
Master Value |
pcre.backtrack_limit |
1000000 |
1000000 |
pcre.recursion_limit |
100000 |
100000 |
PDO
PDO support |
enabled |
PDO drivers |
mysql, sqlite |
pdo_mysql
PDO Driver for MySQL |
enabled |
Client API version |
mysqlnd 5.0.11-dev – 20120503 – $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ |
pdo_sqlite
PDO Driver for SQLite 3.x |
enabled |
SQLite Library |
3.8.10.2 |
Phar
Phar: PHP Archive support |
enabled |
Phar EXT version |
2.0.2 |
Phar API version |
1.1.1 |
SVN revision |
$Id: 6e5cec2462a6ded53d4379ea9a69487a60d5c43c $ |
Phar-based phar archives |
enabled |
Tar-based phar archives |
enabled |
ZIP-based phar archives |
enabled |
gzip compression |
enabled |
bzip2 compression |
enabled |
OpenSSL support |
enabled |
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle. |
Directive |
Local Value |
Master Value |
phar.cache_list |
no value |
no value |
phar.readonly |
On |
On |
phar.require_hash |
On |
On |
Reflection
Reflection |
enabled |
Version |
$Id: 5f15287237d5f78d75b19c26915aa7bd83dee8b8 $ |
session
Session Support |
enabled |
Registered save handlers |
files user |
Registered serializer handlers |
php_serialize php php_binary wddx |
Directive |
Local Value |
Master Value |
session.auto_start |
Off |
Off |
session.cache_expire |
180 |
180 |
session.cache_limiter |
none |
nocache |
session.cookie_domain |
no value |
no value |
session.cookie_httponly |
On |
Off |
session.cookie_lifetime |
0 |
0 |
session.cookie_path |
/ |
/ |
session.cookie_secure |
Off |
Off |
session.entropy_file |
no value |
no value |
session.entropy_length |
0 |
0 |
session.gc_divisor |
1000 |
1000 |
session.gc_maxlifetime |
900 |
1440 |
session.gc_probability |
1 |
1 |
session.hash_bits_per_character |
5 |
5 |
session.hash_function |
0 |
0 |
session.name |
b4aa41ef44f2facba6f8066beaeeab03 |
PHPSESSID |
session.referer_check |
no value |
no value |
session.save_handler |
user |
files |
session.save_path |
C:\xampp\tmp |
C:\xampp\tmp |
session.serialize_handler |
php |
php |
session.upload_progress.cleanup |
On |
On |
session.upload_progress.enabled |
On |
On |
session.upload_progress.freq |
1% |
1% |
session.upload_progress.min_freq |
1 |
1 |
session.upload_progress.name |
PHP_SESSION_UPLOAD_PROGRESS |
PHP_SESSION_UPLOAD_PROGRESS |
session.upload_progress.prefix |
upload_progress_ |
upload_progress_ |
session.use_cookies |
On |
On |
session.use_only_cookies |
On |
On |
session.use_strict_mode |
Off |
Off |
session.use_trans_sid |
0 |
0 |
SimpleXML
Simplexml support |
enabled |
Revision |
$Id: d7077fc935154236afb4fe70814ba358efdbdca4 $ |
Schema support |
enabled |
SPL
SPL support |
enabled |
Interfaces |
Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject |
Classes |
AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException |
standard
Dynamic Library Support |
enabled |
Internal Sendmail Support for Windows |
enabled |
Directive |
Local Value |
Master Value |
assert.active |
1 |
1 |
assert.bail |
0 |
0 |
assert.callback |
no value |
no value |
assert.quiet_eval |
0 |
0 |
assert.warning |
1 |
1 |
auto_detect_line_endings |
0 |
0 |
default_socket_timeout |
60 |
60 |
from |
no value |
no value |
url_rewriter.tags |
a=href,area=href,frame=src,input=src,form=fakeentry |
a=href,area=href,frame=src,input=src,form=fakeentry |
user_agent |
no value |
no value |
tokenizer
Tokenizer Support |
enabled |
wddx
WDDX Support |
enabled |
WDDX Session Serializer |
enabled |
xml
XML Support |
active |
XML Namespace Support |
active |
libxml2 Version |
2.9.4 |
xmlreader
xmlwriter
zip
Zip |
enabled |
Zip version |
1.12.5 |
Libzip version |
0.11.2 |
zlib
ZLib Support |
enabled |
Stream Wrapper |
compress.zlib:// |
Stream Filter |
zlib.inflate, zlib.deflate |
Compiled Version |
1.2.7.3 |
Linked Version |
1.2.7.3 |
Directive |
Local Value |
Master Value |
zlib.output_compression |
Off |
Off |
zlib.output_compression_level |
-1 |
-1 |
zlib.output_handler |
no value |
no value |
Additional Modules
Environment
Variable |
Value |
no value |
::=::\ |
ALLUSERSPROFILE |
C:\ProgramData |
APPDATA |
C:\Users\Akura\AppData\Roaming |
CommonProgramFiles |
C:\Program Files (x86)\Common Files |
CommonProgramFiles(x86) |
C:\Program Files (x86)\Common Files |
CommonProgramW6432 |
C:\Program Files\Common Files |
COMPUTERNAME |
AKURA-PC |
ComSpec |
C:\Windows\system32\cmd.exe |
FP_NO_HOST_CHECK |
NO |
HOMEDRIVE |
C: |
HOMEPATH |
\Users\Akura |
LOCALAPPDATA |
C:\Users\Akura\AppData\Local |
LOGONSERVER |
\\AKURA-PC |
NUMBER_OF_PROCESSORS |
2 |
OS |
Windows_NT |
Path |
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ |
PATHEXT |
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC |
PROCESSOR_ARCHITECTURE |
x86 |
PROCESSOR_ARCHITEW6432 |
AMD64 |
PROCESSOR_IDENTIFIER |
Intel64 Family 6 Model 37 Stepping 5, GenuineIntel |
PROCESSOR_LEVEL |
6 |
PROCESSOR_REVISION |
2505 |
ProgramData |
C:\ProgramData |
ProgramFiles |
C:\Program Files (x86) |
ProgramFiles(x86) |
C:\Program Files (x86) |
ProgramW6432 |
C:\Program Files |
PSModulePath |
C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ |
PUBLIC |
C:\Users\Public |
SESSIONNAME |
Console |
SystemDrive |
C: |
SystemRoot |
C:\Windows |
TEMP |
C:\Users\Akura\AppData\Local\Temp |
TMP |
C:\Users\Akura\AppData\Local\Temp |
USERDOMAIN |
Akura-PC |
USERNAME |
Akura |
USERPROFILE |
C:\Users\Akura |
windir |
C:\Windows |
windows_tracing_flags |
3 |
windows_tracing_logfile |
C:\BVTBin\Tests\installpackage\csilogfile.log |
AP_PARENT_PID |
4240 |
PHP Variables
Variable |
Value |
_REQUEST[“Itemid”] |
1041 |
_REQUEST[“option”] |
com_easyblog |
_REQUEST[“id”] |
61 |
_REQUEST[“view”] |
entry |
_COOKIE[“PHPSESSID”] |
j1dtqpt1g2k9uqfcfqslj8k636 |
_COOKIE[“dff6d4b72e4def426a87277bd6d670d6”] |
jpv39q1mhq8ntcv40gj8nusi21 |
_COOKIE[“__utmc”] |
111872281 |
_COOKIE[“__utmz”] |
111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none) |
_COOKIE[“_ga”] |
GA1.1.1162658711.1550529011 |
_COOKIE[“__utma”] |
111872281.1162658711.1550529011.1553044102.1553163706.3 |
_COOKIE[“_gid”] |
GA1.1.1424351185.1553163707 |
_COOKIE[“b4aa41ef44f2facba6f8066beaeeab03”] |
98fq1d1jl4o5nsru8keh690rb1 |
_COOKIE[“__utmt”] |
1 |
_COOKIE[“__utmb”] |
111872281.13.10.1553163706 |
_COOKIE[“__atuvc”] |
6|12 |
_COOKIE[“__atuvs”] |
5c9369b63df1b0e5005 |
_SERVER[“REDIRECT_HTTP_AUTHORIZATION”] |
no value |
_SERVER[“REDIRECT_MIBDIRS”] |
C:/xampp/php/extras/mibs |
_SERVER[“REDIRECT_MYSQL_HOME”] |
\xampp\mysql\bin |
_SERVER[“REDIRECT_OPENSSL_CONF”] |
C:/xampp/apache/bin/openssl.cnf |
_SERVER[“REDIRECT_PHP_PEAR_SYSCONF_DIR”] |
\xampp\php |
_SERVER[“REDIRECT_PHPRC”] |
\xampp\php |
_SERVER[“REDIRECT_TMP”] |
\xampp\tmp |
_SERVER[“REDIRECT_STATUS”] |
200 |
_SERVER[“HTTP_AUTHORIZATION”] |
no value |
_SERVER[“MIBDIRS”] |
C:/xampp/php/extras/mibs |
_SERVER[“MYSQL_HOME”] |
\xampp\mysql\bin |
_SERVER[“OPENSSL_CONF”] |
C:/xampp/apache/bin/openssl.cnf |
_SERVER[“PHP_PEAR_SYSCONF_DIR”] |
\xampp\php |
_SERVER[“PHPRC”] |
\xampp\php |
_SERVER[“TMP”] |
\xampp\tmp |
_SERVER[“HTTP_HOST”] |
localhost |
_SERVER[“HTTP_CONNECTION”] |
keep-alive |
_SERVER[“HTTP_UPGRADE_INSECURE_REQUESTS”] |
1 |
_SERVER[“HTTP_USER_AGENT”] |
Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.121 Safari/537.36 |
_SERVER[“HTTP_ACCEPT”] |
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 |
_SERVER[“HTTP_REFERER”] |
http://localhost/fiverr/news?start=100 |
_SERVER[“HTTP_ACCEPT_ENCODING”] |
gzip, deflate, br |
_SERVER[“HTTP_ACCEPT_LANGUAGE”] |
pt-PT,pt;q=0.9,en-US;q=0.8,en;q=0.7 |
_SERVER[“HTTP_COOKIE”] |
PHPSESSID=j1dtqpt1g2k9uqfcfqslj8k636; dff6d4b72e4def426a87277bd6d670d6=jpv39q1mhq8ntcv40gj8nusi21; __utmc=111872281; __utmz=111872281.1550529012.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); _ga=GA1.1.1162658711.1550529011; __utma=111872281.1162658711.1550529011.1553044102.1553163706.3; _gid=GA1.1.1424351185.1553163707; b4aa41ef44f2facba6f8066beaeeab03=98fq1d1jl4o5nsru8keh690rb1; __utmt=1; __utmb=111872281.13.10.1553163706; __atuvc=6%7C12; __atuvs=5c9369b63df1b0e5005 |
_SERVER[“PATH”] |
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\ |
_SERVER[“SystemRoot”] |
C:\Windows |
_SERVER[“COMSPEC”] |
C:\Windows\system32\cmd.exe |
_SERVER[“PATHEXT”] |
.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC |
_SERVER[“WINDIR”] |
C:\Windows |
_SERVER[“SERVER_SIGNATURE”] |
<address>Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 Server at localhost Port 80</address> |
_SERVER[“SERVER_SOFTWARE”] |
Apache/2.4.37 (Win32) OpenSSL/1.0.2p PHP/5.6.40 |
_SERVER[“SERVER_NAME”] |
localhost |
_SERVER[“SERVER_ADDR”] |
::1 |
_SERVER[“SERVER_PORT”] |
80 |
_SERVER[“REMOTE_ADDR”] |
::1 |
_SERVER[“DOCUMENT_ROOT”] |
C:/xampp/htdocs |
_SERVER[“REQUEST_SCHEME”] |
http |
_SERVER[“CONTEXT_PREFIX”] |
no value |
_SERVER[“CONTEXT_DOCUMENT_ROOT”] |
C:/xampp/htdocs |
_SERVER[“SERVER_ADMIN”] |
[email protected] |
_SERVER[“SCRIPT_FILENAME”] |
C:/xampp/htdocs/fiverr/index.php |
_SERVER[“REMOTE_PORT”] |
61743 |
_SERVER[“REDIRECT_URL”] |
/fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server |
_SERVER[“GATEWAY_INTERFACE”] |
CGI/1.1 |
_SERVER[“SERVER_PROTOCOL”] |
HTTP/1.1 |
_SERVER[“REQUEST_METHOD”] |
GET |
_SERVER[“QUERY_STRING”] |
no value |
_SERVER[“REQUEST_URI”] |
/fiverr/news/how-to-set-up-a-ubuntu-debian-lamp-server |
_SERVER[“SCRIPT_NAME”] |
/fiverr/index.php |
_SERVER[“PHP_SELF”] |
/fiverr/index.php |
_SERVER[“REQUEST_TIME_FLOAT”] |
1553165508.577 |
_SERVER[“REQUEST_TIME”] |
1553165508 |
PHP Credits
PHP Group |
Thies C. Arntzen, Stig Bakken, Shane Caraveo, Andi Gutmans, Rasmus Lerdorf, Sam Ruby, Sascha Schumann, Zeev Suraski, Jim Winstead, Andrei Zmievski |
Language Design & Concept |
Andi Gutmans, Rasmus Lerdorf, Zeev Suraski, Marcus Boerger |
PHP Authors |
Contribution |
Authors |
Zend Scripting Language Engine |
Andi Gutmans, Zeev Suraski, Stanislav Malyshev, Marcus Boerger, Dmitry Stogov, Xinchen Hui, Nikita Popov |
Extension Module API |
Andi Gutmans, Zeev Suraski, Andrei Zmievski |
UNIX Build and Modularization |
Stig Bakken, Sascha Schumann, Jani Taskinen |
Windows Port |
Shane Caraveo, Zeev Suraski, Wez Furlong, Pierre-Alain Joye, Anatol Belski |
Server API (SAPI) Abstraction Layer |
Andi Gutmans, Shane Caraveo, Zeev Suraski |
Streams Abstraction Layer |
Wez Furlong, Sara Golemon |
PHP Data Objects Layer |
Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky |
Output Handler |
Zeev Suraski, Thies C. Arntzen, Marcus Boerger, Michael Wallner |
SAPI Modules |
Contribution |
Authors |
AOLserver |
Sascha Schumann |
Apache 1.3 (apache_hooks) |
Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar, George Schlossnagle, Lukas Schroeder |
Apache 1.3 |
Rasmus Lerdorf, Zeev Suraski, Stig Bakken, David Sklar |
Apache 2.0 Filter |
Sascha Schumann, Aaron Bannert |
Apache 2.0 Handler |
Ian Holsman, Justin Erenkrantz (based on Apache 2.0 Filter code) |
Caudium / Roxen |
David Hedbor |
CGI / FastCGI |
Rasmus Lerdorf, Stig Bakken, Shane Caraveo, Dmitry Stogov |
CLI |
Edin Kadribasic, Marcus Boerger, Johannes Schlueter, Moriyoshi Koizumi, Xinchen Hui |
Continuity |
Alex Leigh (based on nsapi code) |
Embed |
Edin Kadribasic |
FastCGI Process Manager |
Andrei Nigmatulin, dreamcat4, Antony Dovgal, Jerome Loyet |
ISAPI |
Andi Gutmans, Zeev Suraski |
litespeed |
George Wang |
NSAPI |
Jayakumar Muthukumarasamy, Uwe Schindler |
phpdbg |
Felipe Pena, Joe Watkins, Bob Weinand |
phttpd |
Thies C. Arntzen |
pi3web |
Holger Zimmermann |
Sendmail Milter |
Harald Radi |
thttpd |
Sascha Schumann |
tux |
Sascha Schumann |
WebJames |
Alex Waugh |
Module Authors |
Module |
Authors |
BC Math |
Andi Gutmans |
Bzip2 |
Sterling Hughes |
Calendar |
Shane Caraveo, Colin Viebrock, Hartmut Holzgraefe, Wez Furlong |
COM and .Net |
Wez Furlong |
ctype |
Hartmut Holzgraefe |
cURL |
Sterling Hughes |
Date/Time Support |
Derick Rethans |
DB-LIB (MS SQL, Sybase) |
Wez Furlong, Frank M. Kromann |
DBA |
Sascha Schumann, Marcus Boerger |
DOM |
Christian Stocker, Rob Richards, Marcus Boerger |
enchant |
Pierre-Alain Joye, Ilia Alshanetsky |
ereg |
Rasmus Lerdorf, Jim Winstead, Jaakko Hyvätti |
EXIF |
Rasmus Lerdorf, Marcus Boerger |
fileinfo |
Ilia Alshanetsky, Pierre Alain Joye, Scott MacVicar, Derick Rethans |
Firebird driver for PDO |
Ard Biesheuvel |
FTP |
Stefan Esser, Andrew Skalski |
GD imaging |
Rasmus Lerdorf, Stig Bakken, Jim Winstead, Jouni Ahto, Ilia Alshanetsky, Pierre-Alain Joye, Marcus Boerger |
GetText |
Alex Plotnick |
GNU GMP support |
Stanislav Malyshev |
Iconv |
Rui Hirokawa, Stig Bakken, Moriyoshi Koizumi |
IMAP |
Rex Logan, Mark Musone, Brian Wang, Kaj-Michael Lang, Antoni Pamies Olive, Rasmus Lerdorf, Andrew Skalski, Chuck Hagenbuch, Daniel R Kalowsky |
Input Filter |
Rasmus Lerdorf, Derick Rethans, Pierre-Alain Joye, Ilia Alshanetsky |
InterBase |
Jouni Ahto, Andrew Avdeev, Ard Biesheuvel |
Internationalization |
Ed Batutis, Vladimir Iordanov, Dmitry Lakhtyuk, Stanislav Malyshev, Vadim Savchuk, Kirti Velankar |
JSON |
Omar Kilani, Scott MacVicar |
LDAP |
Amitay Isaacs, Eric Warnke, Rasmus Lerdorf, Gerrit Thomson, Stig Venaas |
LIBXML |
Christian Stocker, Rob Richards, Marcus Boerger, Wez Furlong, Shane Caraveo |
mcrypt |
Sascha Schumann, Derick Rethans |
MS SQL |
Frank M. Kromann |
Multibyte String Functions |
Tsukada Takuya, Rui Hirokawa |
MySQL driver for PDO |
George Schlossnagle, Wez Furlong, Ilia Alshanetsky, Johannes Schlueter |
MySQL |
Zeev Suraski, Zak Greant, Georg Richter, Andrey Hristov |
MySQLi |
Zak Greant, Georg Richter, Andrey Hristov, Ulf Wendel |
MySQLnd |
Andrey Hristov, Ulf Wendel, Georg Richter, Johannes Schlüter |
OCI8 |
Stig Bakken, Thies C. Arntzen, Andy Sautins, David Benson, Maxim Maletsky, Harald Radi, Antony Dovgal, Andi Gutmans, Wez Furlong, Christopher Jones, Oracle Corporation |
ODBC driver for PDO |
Wez Furlong |
ODBC |
Stig Bakken, Andreas Karajannis, Frank M. Kromann, Daniel R. Kalowsky |
OpenSSL |
Stig Venaas, Wez Furlong, Sascha Kettler, Scott MacVicar |
Oracle (OCI) driver for PDO |
Wez Furlong |
pcntl |
Jason Greene, Arnaud Le Blanc |
Perl Compatible Regexps |
Andrei Zmievski |
PHP Archive |
Gregory Beaver, Marcus Boerger |
PHP Data Objects |
Wez Furlong, Marcus Boerger, Sterling Hughes, George Schlossnagle, Ilia Alshanetsky |
PHP hash |
Sara Golemon, Rasmus Lerdorf, Stefan Esser, Michael Wallner, Scott MacVicar |
Posix |
Kristian Koehntopp |
PostgreSQL driver for PDO |
Edin Kadribasic, Ilia Alshanetsky |
PostgreSQL |
Jouni Ahto, Zeev Suraski, Yasuo Ohgaki, Chris Kings-Lynne |
Pspell |
Vlad Krupin |
Readline |
Thies C. Arntzen |
Recode |
Kristian Koehntopp |
Reflection |
Marcus Boerger, Timm Friebe, George Schlossnagle, Andrei Zmievski, Johannes Schlueter |
Sessions |
Sascha Schumann, Andrei Zmievski |
Shared Memory Operations |
Slava Poliakov, Ilia Alshanetsky |
SimpleXML |
Sterling Hughes, Marcus Boerger, Rob Richards |
SNMP |
Rasmus Lerdorf, Harrie Hazewinkel, Mike Jackson, Steven Lawrance, Johann Hanne, Boris Lytochkin |
SOAP |
Brad Lafountain, Shane Caraveo, Dmitry Stogov |
Sockets |
Chris Vandomelen, Sterling Hughes, Daniel Beulshausen, Jason Greene |
SPL |
Marcus Boerger, Etienne Kneuss |
SQLite 3.x driver for PDO |
Wez Furlong |
SQLite3 |
Scott MacVicar, Ilia Alshanetsky, Brad Dewar |
Sybase-CT |
Zeev Suraski, Tom May, Timm Friebe |
System V Message based IPC |
Wez Furlong |
System V Semaphores |
Tom May |
System V Shared Memory |
Christian Cartus |
tidy |
John Coggeshall, Ilia Alshanetsky |
tokenizer |
Andrei Zmievski, Johannes Schlueter |
WDDX |
Andrei Zmievski |
XML |
Stig Bakken, Thies C. Arntzen, Sterling Hughes |
XMLReader |
Rob Richards |
xmlrpc |
Dan Libby |
XMLWriter |
Rob Richards, Pierre-Alain Joye |
XSL |
Christian Stocker, Rob Richards |
Zip |
Pierre-Alain Joye, Remi Collet |
Zlib |
Rasmus Lerdorf, Stefan Roehrich, Zeev Suraski, Jade Nicoletti, Michael Wallner |
PHP Documentation |
Authors |
Mehdi Achour, Friedhelm Betz, Antony Dovgal, Nuno Lopes, Hannes Magnusson, Georg Richter, Damien Seguy, Jakub Vrana, Adam Harvey, Peter Cowburn |
Editor |
Philip Olson |
User Note Maintainers |
Daniel P. Brown, Thiago Henrique Pojda |
Other Contributors |
Previously active authors, editors and other contributors are listed in the manual. |
PHP Quality Assurance Team |
Ilia Alshanetsky, Joerg Behrens, Antony Dovgal, Stefan Esser, Moriyoshi Koizumi, Magnus Maatta, Sebastian Nohn, Derick Rethans, Melvyn Sopacua, Jani Taskinen, Pierre-Alain Joye, Dmitry Stogov, Felipe Pena, David Soria Parra, Stanislav Malyshev, Julien Pauli, Stephen Zarkos, Anatol Belski, Remi Collet, Ferenc Kovacs |
Websites and Infrastructure team |
PHP Websites Team |
Rasmus Lerdorf, Hannes Magnusson, Philip Olson, Lukas Kahwe Smith, Pierre-Alain Joye, Kalle Sommer Nielsen, Peter Cowburn, Adam Harvey, Ferenc Kovacs, Levi Morrison |
Event Maintainers |
Damien Seguy, Daniel P. Brown |
Network Infrastructure |
Daniel P. Brown |
Windows Infrastructure |
Alex Schoenmaker |
PHP License
This program is free software; you can redistribute it and/or modify it under the terms of the PHP License as published by the PHP Group and included in the distribution in the file: LICENSE
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
If you did not receive a copy of the PHP license, or have any questions about PHP licensing, please contact [email protected]. |
Point your browser to http://ip.address/test.php or http://domain/test.php and this should show all your php configuration and default settings.
You can edit necessary values or setup virtual domains using apache configuration file.
2. Installing MySQL Database Server
Installing mysql database server is always necessary if you are running a database driven e-commerce site. Remember running MySQL server to a fair extend requires at least 256mb of RAM in your server. So unless you are running database driven sites you don’t absolutely need MySQL. The following commands will install MySQL 5 server and MySQL 5 client.
apt-get install mysql-server mysql-client php5-mysql
Note: If you have already installed php4, you should make a slight change like this.
apt-get install mysql-server mysql-client php4-mysql
The configuration file of MySQL is located at: /etc/mysql/my.cnf
Creating users to use MySQL and Changing Root Password
By default mysql creates user as root and runs with no passport. You might need to change the root password.
To change Root Password
mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD(‘new-password’) WHERE user=’root’;
mysql> FLUSH PRIVILEGES;
You must never use root password, so you might need to create a user to connect to MySQL database for a PHP script. Alternatively you can add users to MySQL database by using a control panel like Webmin or phpMyAdmin to easily create or assign database permission to users. We will install Webmin and phpMyAdmin during later once we complete basic installation.
3. PhpMyAdmin Installation
PhpMyAdmin is a nice web based database management and administration software and easy to install and configure under apache. Managing databases with tables couldn’t be much simpler by using phpMyAdmin.
All you need to do is:
apt-get install phpmyadmin
The phpMyAdmin configuration file is located at: /etc/phpmyadmin folder.
To set up under Apache all you need to do is include the following line in /etc/apache2/apache2.conf:
Include /etc/phpmyadmin/apache.conf
Now restart Apache:
/etc/init.d/apache2 restart
Point your browser to: http://domain/phpmyadmin
That’s it! MySQL and phpMyAdmin are ready. Log in with your mysql root password and create users to connect to database from your php script.
This tutorial was written by Scott who currently runs MySQL-Apache-PHP.com.