Δημοσιεύτηκε: 15 Δεκ 2014, 23:33
από Vegeta
ls -l /etc/phpmyadmin
Spoiler: show
Κώδικας: Επιλογή όλων
total 44
-rw-r--r-- 1 root root     1108 Ιούλ 28  2013 apache.conf
drwxr-xr-x 2 root root     4096 Δεκ  12  2013 conf.d
-rw-r----- 1 root www-data  530 Δεκ  14 17:18 config-db.php
-rw-r--r-- 1 root root      168 Φεβ  14  2012 config.footer.inc.php
-rw-r--r-- 1 root root      168 Φεβ  14  2012 config.header.inc.php
-rw-r--r-- 1 root root     5173 Ιούλ 28  2013 config.inc.php
-rw-r----- 1 root www-data    8 Απρ  17  2014 htpasswd.setup
-rw-r--r-- 1 root root      570 Φεβ  14  2012 lighttpd.conf
-rw-r--r-- 1 root root      198 Φεβ  14  2012 phpmyadmin.desktop
-rw-r--r-- 1 root root      295 Φεβ  14  2012 phpmyadmin.service

cat /etc/apache2/apache2.conf
Spoiler: show
Κώδικας: Επιλογή όλων
#
# Based upon the NCSA server configuration files originally by Rob McCool.
#
# This is the main Apache server configuration file.  It contains the
# configuration directives that give the server its instructions.
# See http://httpd.apache.org/docs/2.2/ for detailed information about
# the directives.
#
# 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. 
#
# The configuration directives are grouped into three basic sections:
#  1. Directives that control the operation of the Apache server process as a
#     whole (the 'global environment').
#  2. Directives that define the parameters of the 'main' or 'default' server,
#     which responds to requests that aren't handled by a virtual host.
#     These directives also provide default values for the settings
#     of all virtual hosts.
#  3. Settings for virtual hosts, which allow Web requests to be sent to
#     different IP addresses or hostnames and have them handled by the
#     same Apache server process.
#
# 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 "foo.log"
# with ServerRoot set to "/etc/apache2" will be interpreted by the
# server as "/etc/apache2/foo.log".
#

### Section 1: Global Environment
#
# The directives in this section affect the overall operation of Apache,
# such as the number of concurrent requests it can handle or where it
# can find its configuration files.
#

#
# ServerRoot: The top of the directory tree under which the server's
# configuration, error, and log files are kept.
#
# NOTE!  If you intend to place this on an NFS (or otherwise network)
# mounted filesystem then please read the LockFile documentation (available
# at <URL:http://httpd.apache.org/docs/2.2/mod/mpm_common.html#lockfile>);
# you will save yourself a lot of trouble.
#
# Do NOT add a slash at the end of the directory path.
#
#ServerRoot "/etc/apache2"

#
# The accept serialization lock file MUST BE STORED ON A LOCAL DISK.
#
LockFile ${APACHE_LOCK_DIR}/accept.lock

#
# PidFile: The file in which the server should record its process
# identification number when it starts.
# This needs to be set in /etc/apache2/envvars
#
PidFile ${APACHE_PID_FILE}

#
# Timeout: The number of seconds before receives and sends time out.
#
Timeout 300

#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On

#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100

#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5

##
## Server-Pool Size Regulation (MPM specific)
##

# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_prefork_module>
    StartServers          5
    MinSpareServers       5
    MaxSpareServers      10
    MaxClients          150
    MaxRequestsPerChild   0
</IfModule>

# worker MPM
# StartServers: initial number of server processes to start
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadLimit: ThreadsPerChild can be changed to this maximum value during a
#              graceful restart. ThreadLimit can only be changed by stopping
#              and starting Apache.
# ThreadsPerChild: constant number of worker threads in each server process
# MaxClients: maximum number of simultaneous client connections
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_worker_module>
    StartServers          2
    MinSpareThreads      25
    MaxSpareThreads      75
    ThreadLimit          64
    ThreadsPerChild      25
    MaxClients          150
    MaxRequestsPerChild   0
</IfModule>

# event MPM
# StartServers: initial number of server processes to start
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxClients: maximum number of simultaneous client connections
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule mpm_event_module>
    StartServers          2
    MinSpareThreads      25
    MaxSpareThreads      75
    ThreadLimit          64
    ThreadsPerChild      25
    MaxClients          150
    MaxRequestsPerChild   0
</IfModule>

# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}

#
# AccessFileName: The name of the file to look for in each directory
# for additional configuration directives.  See also the AllowOverride
# directive.
#

AccessFileName .htaccess

#
# The following lines prevent .htaccess and .htpasswd files from being
# viewed by Web clients.
#
<Files ~ "^\.ht">
    Order allow,deny
    Deny from all
    Satisfy all
</Files>

#
# DefaultType is the default MIME type the server will use for a document
# if it cannot otherwise determine one, such as from filename extensions.
# If your server contains mostly text or HTML documents, "text/plain" is
# a good value.  If most of your content is binary, such as applications
# or images, you may want to use "application/octet-stream" instead to
# keep browsers from trying to display binary files as though they are
# text.
#
# It is also possible to omit any default MIME type and let the
# client's browser guess an appropriate action instead. Typically the
# browser will decide based on the file's extension then. In cases
# where no good assumption can be made, letting the default MIME type
# unset is suggested  instead of forcing the browser to accept
# incorrect  metadata.
#
DefaultType None


#
# HostnameLookups: Log the names of clients or just their IP addresses
# e.g., www.apache.org (on) or 204.62.129.132 (off).
# The default is off because it'd be overall better for the net if people
# had to knowingly turn this feature on, since enabling it means that
# each client request will result in AT LEAST one lookup request to the
# nameserver.
#
HostnameLookups Off

# 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 ${APACHE_LOG_DIR}/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

# Include module configuration:
Include mods-enabled/*.load
Include mods-enabled/*.conf

# Include all the user configurations:
Include httpd.conf

# Include ports listing
Include ports.conf

#
# The following directives define some format nicknames for use with
# a CustomLog directive (see below).
# If you are behind a reverse proxy, you might want to change %h into %{X-Forwarded-For}i
#
LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent

# Include of directories ignores editors' and dpkg's backup files,
# see README.Debian for details.

# Include generic snippets of statements
Include conf.d/

# Include the virtual host configurations:
Include sites-enabled/

# Include the phpmyadmin configurations:
Include /etc/phpmyadmin/apache.conf

sudo apt-get install php5 libapache2-mod-php5 php5-mysqlnd
Spoiler: show
Κώδικας: Επιλογή όλων
Reading package lists... Done
Building dependency tree       
Reading state information... Done
libapache2-mod-php5 is already the newest version.
libapache2-mod-php5 set to manually installed.
The following packages will be REMOVED:
  php5-mysql
The following NEW packages will be installed:
  php5 php5-mysqlnd
0 upgraded, 2 newly installed, 1 to remove and 10 not upgraded.
Need to get 136 kB of archives.
After this operation, 276 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://gr.archive.ubuntu.com/ubuntu/ trusty-updates/universe php5-mysqlnd amd64 5.5.9+dfsg-1ubuntu4.5 [135 kB]
Get:2 http://gr.archive.ubuntu.com/ubuntu/ trusty-updates/main php5 all 5.5.9+dfsg-1ubuntu4.5 [1302 B]
Fetched 136 kB in 0s (291 kB/s)
dpkg: php5-mysql: dependency problems, but removing anyway as you requested:
phpmyadmin depends on php5-mysql | php5-mysqli | php5-mysqlnd; however:
  Package php5-mysql is to be removed.
  Package php5-mysqli is not installed.
  Package php5-mysqlnd is not installed.

(Reading database ... 403063 files and directories currently installed.)
Removing php5-mysql (5.5.9+dfsg-1ubuntu4.5) ...
php5_invoke prerm: Disable module mysql for cli SAPI
php5_invoke prerm: Disable module mysql for apache2 SAPI
php5_invoke prerm: Disable module mysqli for cli SAPI
php5_invoke prerm: Disable module mysqli for apache2 SAPI
php5_invoke prerm: Disable module pdo_mysql for cli SAPI
php5_invoke prerm: Disable module pdo_mysql for apache2 SAPI
Processing triggers for libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.5) ...
Selecting previously unselected package php5-mysqlnd.
(Reading database ... 403053 files and directories currently installed.)
Preparing to unpack .../php5-mysqlnd_5.5.9+dfsg-1ubuntu4.5_amd64.deb ...
Unpacking php5-mysqlnd (5.5.9+dfsg-1ubuntu4.5) ...
Selecting previously unselected package php5.
Preparing to unpack .../php5_5.5.9+dfsg-1ubuntu4.5_all.deb ...
Unpacking php5 (5.5.9+dfsg-1ubuntu4.5) ...
Processing triggers for libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.5) ...
Setting up php5-mysqlnd (5.5.9+dfsg-1ubuntu4.5) ...

Creating config file /etc/php5/mods-available/mysqlnd.ini with new version
php5_invoke: Enable module mysqlnd for cli SAPI
php5_invoke: Enable module mysqlnd for apache2 SAPI
php5_invoke: Enable module mysql for cli SAPI
php5_invoke: Enable module mysql for apache2 SAPI
php5_invoke: Enable module mysqli for cli SAPI
php5_invoke: Enable module mysqli for apache2 SAPI
php5_invoke: Enable module pdo_mysql for cli SAPI
php5_invoke: Enable module pdo_mysql for apache2 SAPI
Setting up php5 (5.5.9+dfsg-1ubuntu4.5) ...
Processing triggers for libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.5) ...

sudo apt-get install --reinstall php5 libapache2-mod-php5 php5-mysqlnd
Spoiler: show
Κώδικας: Επιλογή όλων
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 3 reinstalled, 0 to remove and 10 not upgraded.
Need to get 2206 kB/2342 kB of archives.
After this operation, 0 B of additional disk space will be used.
Get:1 http://gr.archive.ubuntu.com/ubuntu/ trusty-updates/main libapache2-mod-php5 amd64 5.5.9+dfsg-1ubuntu4.5 [2206 kB]
Fetched 2206 kB in 2s (1013 kB/s)             
(Reading database ... 403071 files and directories currently installed.)
Preparing to unpack .../php5-mysqlnd_5.5.9+dfsg-1ubuntu4.5_amd64.deb ...
Unpacking php5-mysqlnd (5.5.9+dfsg-1ubuntu4.5) over (5.5.9+dfsg-1ubuntu4.5) ...
Preparing to unpack .../libapache2-mod-php5_5.5.9+dfsg-1ubuntu4.5_amd64.deb ...
Unpacking libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.5) over (5.5.9+dfsg-1ubuntu4.5) ...
Preparing to unpack .../php5_5.5.9+dfsg-1ubuntu4.5_all.deb ...
Unpacking php5 (5.5.9+dfsg-1ubuntu4.5) over (5.5.9+dfsg-1ubuntu4.5) ...
Setting up php5-mysqlnd (5.5.9+dfsg-1ubuntu4.5) ...
php5_invoke mysqlnd: already enabled for cli SAPI
php5_invoke mysqlnd: already enabled for apache2 SAPI
php5_invoke mysql: already enabled for cli SAPI
php5_invoke mysql: already enabled for apache2 SAPI
php5_invoke mysqli: already enabled for cli SAPI
php5_invoke mysqli: already enabled for apache2 SAPI
php5_invoke pdo_mysql: already enabled for cli SAPI
php5_invoke pdo_mysql: already enabled for apache2 SAPI
Setting up libapache2-mod-php5 (5.5.9+dfsg-1ubuntu4.5) ...
php5_invoke readline: already enabled for apache2 SAPI
php5_invoke gd: already enabled for apache2 SAPI
php5_invoke mysqlnd: already enabled for apache2 SAPI
php5_invoke pdo: already enabled for apache2 SAPI
php5_invoke mysql: already enabled for apache2 SAPI
php5_invoke mysqli: already enabled for apache2 SAPI
php5_invoke pdo_mysql: already enabled for apache2 SAPI
php5_invoke opcache: already enabled for apache2 SAPI
php5_invoke json: already enabled for apache2 SAPI
apache2_invoke php5: already enabled
Action 'configtest' failed.
The Apache error log may have more information.
apache2_reload: Your configuration is broken. Not restarting Apache 2
Setting up php5 (5.5.9+dfsg-1ubuntu4.5) ...

sudo dpkg-reconfigure -plow phpmyadmin
Spoiler: show
Κώδικας: Επιλογή όλων
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
Replacing config file /etc/phpmyadmin/config-db.php with new version
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO).
unable to connect to mysql server.
error encountered creating user:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
dbconfig-common: phpmyadmin configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
Replacing config file /etc/phpmyadmin/config-db.php with new version
dbconfig-common: flushing administrative password
apache2_invoke phpmyadmin: already enabled
Action 'configtest' failed.
The Apache error log may have more information.
apache2_reload: Your configuration is broken. Not reloading Apache 2
* Reloading web server apache2                                                                                                                  *
* The apache2 configtest failed. Not doing anything.
Output of config test was:
apache2: Syntax error on line 214 of /etc/apache2/apache2.conf: Could not open configuration file /etc/apache2/httpd.conf: No such file or directory
Action 'configtest' failed.
The Apache error log may have more information.
invoke-rc.d: initscript apache2, action "reload" failed.


όπως είπα και παραπάνω δεν μπορώ να καταλάβω αν το πρόβλημα υπάρχει στο phpmyadmin ή στην σύνδεση με το localhost...
κάνω: ping -c 4 localhost
και παίρνω:
Κώδικας: Επιλογή όλων
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.037 ms
64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.039 ms
64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.036 ms
64 bytes from localhost (127.0.0.1): icmp_seq=4 ttl=64 time=0.036 ms

--- localhost ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2997ms
rtt min/avg/max/mdev = 0.036/0.037/0.039/0.001 ms


μέσω firefox δοκιμάζω: http://localhost/
και βλέπω:
Unable to connect
Firefox can't establish a connection to the server at localhost.


μέσω chrome δοκιμάζω: http://localhost/
και βλέπω:
This webpage is not available

είναι λογικό αυτό???