Apache2 et phpmyadmin :

Recherche :

Mot : Pseudo : Filtrer
Bas de page
Auteur	Sujet : Apache2 et phpmyadmin :

dureiken

Bonjour,

j'essaie d'installer un serveur web apache2 avec une bdd mysql et phpadmin sur un dedie chez online qui a deja une seedbox.

J'ai suivi ce tutoriel : http://www.woinux.fr/installation- [...] bian-7-425

et d'autres sur internet, sans succès, j'obtiens toujours :

Code :

The requested URL /phpmyadmin/navigation.php< was not found on this server.

alors que le serveur web marche bien (It Works!), par contre je ne suis pas sur le port 80 car deja utilisé par ailleurs.

Si quelqu'un a une idée ?

Merci

Publicité

Arcan_-

Bonjour,

Voici quelques points où jeter un oeil :

Est-ce que le fichier navigation.php est bien présent dans /usr/share/phpmyadmin ?
Est-ce que le vhost, ou du moins la configuration d'apache est bonne ? (/etc/apache2/conf.d et/ou /etc/apache2/sites-enabled)

Que disent les journaux d'apache et de php ?

Arcan_-

dureiken

Bonjour

Merci de ton aide.

Le fichier navigation.php est bien present et il semble bien aller chercher le repertoire phpmyadmin car tout autre adresse donne une erreur 404.

Le site est bien configure sur le bon port 74 qui me donne bien l'arborescence du repertoire www quand je mets IP:port

Je ne sais pas lire les journaux par contre

Arcan_-

Les logs d'apache sont disponibles dans /var/log/apache2.

Est-ce que le fichier /etc/apache2/conf.d/phpmyadmin.conf existe ?
Si oui, peux tu nous mettre le contenu ?

dureiken

@ MS45

Code :

root@perso:/home/dureiken# ln -s /etc/apache2/conf.d/phpmyadmin.conf /etc/apache2/conf-enabled/phpmyadmin.conf
ln: failed to create symbolic link `/etc/apache2/conf-enabled/phpmyadmin.conf': No such file or directory

je n'ai pas de repertoire conf-enabled, je le cree ?

@Arcan

phpmyadmin.conf existe en lien, voici son contenu :

Code :

# phpMyAdmin default Apache configuration
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
<IfModule mod_php5.c>
AddType application/x-httpd-php .php
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals Off
php_admin_flag allow_url_fopen Off
php_value include_path .
php_admin_value upload_tmp_dir /var/lib/phpmyadmin/tmp
php_admin_value open_basedir /usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/
</IfModule>
</Directory>
# Authorize for setup
<Directory /usr/share/phpmyadmin/setup>
<IfModule mod_authn_file.c>
AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup
</IfModule>
Require valid-user
</Directory>
# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/libraries>
Order Deny,Allow
Deny from All
</Directory>
<Directory /usr/share/phpmyadmin/setup/lib>
Order Deny,Allow
Deny from All
</Directory>

et pour les journaux voici le error.log de apache2

Spoiler :

[Sun Apr 17 23:54:12 2016] [notice] Apache/2.2.22 (Debian) configured -- resuming normal operations
[Sun Apr 17 23:56:11 2016] [error] [client 37.162.220.34] File does not exist: /var/www/favicon.ico
[Sun Apr 17 23:56:11 2016] [error] [client 37.162.220.34] File does not exist: /var/www/favicon.ico
[Sun Apr 17 23:56:31 2016] [error] [client 37.162.220.34] File does not exist: /usr/share/phpmyadmin/<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/
[Sun Apr 17 23:56:31 2016] [error] [client 37.162.220.34] File does not exist: /usr/share/phpmyadmin/navigation.php<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/
[Sun Apr 17 23:56:32 2016] [error] [client 37.162.220.34] File does not exist: /usr/share/phpmyadmin/navigation.php<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/

[Mon Apr 18 09:28:00 2016] [notice] Graceful restart requested, doing restart
[Mon Apr 18 09:28:00 2016] [notice] Apache/2.2.22 (Debian) configured -- resuming normal operations
[Mon Apr 18 09:35:46 2016] [error] [client 37.162.219.211] File does not exist: /var/www/favicon.ico
[Mon Apr 18 09:35:47 2016] [error] [client 37.162.219.211] File does not exist: /var/www/favicon.ico
[Mon Apr 18 09:48:42 2016] [notice] caught SIGTERM, shutting down
[Mon Apr 18 09:48:43 2016] [notice] Apache/2.2.22 (Debian) configured -- resuming normal operations
[Mon Apr 18 11:54:19 2016] [error] [client 37.162.143.139] File does not exist: /var/www/html/favicon.ico

Merci de votre aide les gars

dureiken

Spoiler :

dureiken@persousr/share/phpmyadmin$ ls -la
total 1148
drwxr-xr-x 8 root root 4096 Apr 18 17:23 .
drwxr-xr-x 118 root root 4096 Apr 18 17:23 ..
lrwxrwxrwx 1 root root 36 Oct 28 19:48 Documentation.html -> ../doc/phpmyadmin/Documentation.html
-rw-r--r-- 1 root root 11230 Aug 12 2012 browse_foreigners.php
-rw-r--r-- 1 root root 1621 Aug 12 2012 bs_disp_as_mime_type.php
-rw-r--r-- 1 root root 2060 Aug 12 2012 bs_play_media.php
-rw-r--r-- 1 root root 3855 Aug 12 2012 changelog.php
-rw-r--r-- 1 root root 363 Aug 12 2012 chk_rel.php
-rw-r--r-- 1 root root 3746 Aug 12 2012 config.sample.inc.php
-rw-r--r-- 1 root root 4060 Aug 12 2012 db_create.php
-rw-r--r-- 1 root root 10137 Aug 12 2012 db_datadict.php
-rw-r--r-- 1 root root 2876 Aug 12 2012 db_export.php
-rw-r--r-- 1 root root 466 Aug 12 2012 db_import.php
-rw-r--r-- 1 root root 22673 Aug 12 2012 db_operations.php
-rw-r--r-- 1 root root 7331 Aug 12 2012 db_printview.php
-rw-r--r-- 1 root root 31253 Aug 12 2012 db_qbe.php
-rw-r--r-- 1 root root 13970 Aug 12 2012 db_search.php
-rw-r--r-- 1 root root 1039 Aug 12 2012 db_sql.php
-rw-r--r-- 1 root root 22783 Aug 12 2012 db_structure.php
-rw-r--r-- 1 root root 8357 Aug 12 2012 db_tracking.php
lrwxrwxrwx 1 root root 26 Oct 28 19:48 docs.css -> ../doc/phpmyadmin/docs. css
-rw-r--r-- 1 root root 3498 Aug 12 2012 enum_editor.php
-rw-r--r-- 1 root root 28544 Oct 28 18:24 export.php
-rw-r--r-- 1 root root 18902 Aug 12 2012 favicon.ico
-rw-r--r-- 1 root root 16880 Oct 28 18:24 import.php
-rw-r--r-- 1 root root 1058 Aug 12 2012 import_status.php
-rw-r--r-- 1 root root 6701 Aug 12 2012 index.php
drwxr-xr-x 3 root root 4096 Apr 18 17:23 js
drwxr-xr-x 14 root root 12288 Apr 18 17:23 libraries
-rw-r--r-- 1 root root 730 Aug 12 2012 license.php
drwxr-xr-x 43 root root 4096 Apr 18 17:23 locale
-rw-r--r-- 1 root root 15962 Aug 12 2012 main.php
-rw-r--r-- 1 root root 26742 Aug 12 2012 navigation.php
-rw-r--r-- 1 root root 349 Aug 12 2012 phpinfo.php
-rw-r--r-- 1 root root 1102 Aug 12 2012 phpmyadmin.css.php
drwxr-xr-x 5 root root 4096 Apr 18 17:23 pmd
-rw-r--r-- 1 root root 9854 Aug 12 2012 pmd_common.php
-rw-r--r-- 1 root root 1765 Aug 12 2012 pmd_display_field.php
-rw-r--r-- 1 root root 35073 Aug 12 2012 pmd_general.php
-rw-r--r-- 1 root root 948 Aug 12 2012 pmd_help.php
-rw-r--r-- 1 root root 4539 Oct 28 18:24 pmd_pdf.php
-rw-r--r-- 1 root root 3986 Aug 12 2012 pmd_relation_new.php
-rw-r--r-- 1 root root 2165 Aug 12 2012 pmd_relation_upd.php
-rw-r--r-- 1 root root 2061 Aug 12 2012 pmd_save_pos.php
-rw-r--r-- 1 root root 2600 Aug 12 2012 prefs_forms.php
-rw-r--r-- 1 root root 14904 Aug 12 2012 prefs_manage.php
-rw-r--r-- 1 root root 1064 Aug 12 2012 print.css
-rw-r--r-- 1 root root 7563 Aug 12 2012 querywindow.php
-rw-r--r-- 1 root root 4405 Aug 12 2012 schema_edit.php
-rw-r--r-- 1 root root 1608 Oct 28 18:24 schema_export.php
-rw-r--r-- 1 root root 6802 Aug 12 2012 server_binlog.php
-rw-r--r-- 1 root root 2645 Aug 12 2012 server_collations.php
-rw-r--r-- 1 root root 10010 Aug 12 2012 server_databases.php
-rw-r--r-- 1 root root 5192 Aug 12 2012 server_engines.php
-rw-r--r-- 1 root root 2074 Aug 12 2012 server_export.php
-rw-r--r-- 1 root root 477 Aug 12 2012 server_import.php
-rw-r--r-- 1 root root 107511 Aug 12 2012 server_privileges.php
-rw-r--r-- 1 root root 3606 Aug 12 2012 server_processlist.php
-rw-r--r-- 1 root root 17282 Aug 12 2012 server_replication.php
-rw-r--r-- 1 root root 581 Aug 12 2012 server_sql.php
-rw-r--r-- 1 root root 39132 Aug 12 2012 server_status.php
-rw-r--r-- 1 root root 58107 Aug 12 2012 server_synchronize.php
-rw-r--r-- 1 root root 2777 Aug 12 2012 server_variables.php
drwxr-xr-x 4 root root 4096 Apr 18 17:23 setup
-rw-r--r-- 1 root root 353 Aug 12 2012 show_config_errors.php
-rw-r--r-- 1 root root 38451 Aug 12 2012 sql.php
-rw-r--r-- 1 root root 7964 Aug 12 2012 tbl_addfield.php
-rw-r--r-- 1 root root 7367 Aug 12 2012 tbl_alter.php
-rw-r--r-- 1 root root 52368 Aug 12 2012 tbl_change.php
-rw-r--r-- 1 root root 8171 Aug 12 2012 tbl_chart.php
-rw-r--r-- 1 root root 15019 Aug 12 2012 tbl_create.php
-rw-r--r-- 1 root root 2613 Aug 12 2012 tbl_export.php
-rw-r--r-- 1 root root 1725 Aug 12 2012 tbl_get_field.php
-rw-r--r-- 1 root root 624 Aug 12 2012 tbl_import.php
-rw-r--r-- 1 root root 8156 Aug 12 2012 tbl_indexes.php
-rw-r--r-- 1 root root 2312 Aug 12 2012 tbl_move_copy.php
-rw-r--r-- 1 root root 31534 Aug 12 2012 tbl_operations.php
-rw-r--r-- 1 root root 16369 Oct 28 19:26 tbl_printview.php
-rw-r--r-- 1 root root 23680 Aug 12 2012 tbl_relation.php
-rw-r--r-- 1 root root 16972 Aug 12 2012 tbl_replace.php
-rw-r--r-- 1 root root 4684 Aug 12 2012 tbl_row_action.php
-rw-r--r-- 1 root root 16484 Aug 12 2012 tbl_select.php
-rw-r--r-- 1 root root 978 Aug 12 2012 tbl_sql.php
-rw-r--r-- 1 root root 38529 Aug 12 2012 tbl_structure.php
-rw-r--r-- 1 root root 26485 Aug 12 2012 tbl_tracking.php
drwxr-xr-x 4 root root 4096 Apr 18 17:23 themes
-rw-r--r-- 1 root root 1355 Aug 12 2012 themes.php
-rw-r--r-- 1 root root 2043 Aug 12 2012 transformation_overview.php
-rw-r--r-- 1 root root 3611 Aug 12 2012 transformation_wrapper.php
-rw-r--r-- 1 root root 391 Aug 12 2012 url.php
-rw-r--r-- 1 root root 4879 Aug 12 2012 user_password.php
-rw-r--r-- 1 root root 5354 Aug 12 2012 view_create.php
-rw-r--r-- 1 root root 2802 Aug 12 2012 view_operations.php
-rw-r--r-- 1 root root 1121 Aug 12 2012 webapp.php

Message édité par dureiken le 18-04-2016 à 22:15:25

Arcan_-

Le dossier conf-enabled n'est nécessaire que si apache est configuré pour en inclure le contenu.
Sous Debian, c'est le cas à partir de Jessie. Tu y retrouves le même principe de available/enabled que pour les vhosts et les modules.

Peut être un problème avec l'url utilisée ? :

Citation :

[Sun Apr 17 23:56:31 2016] [error] [client xxx] File does not exist: /usr/share/phpmyadmin/<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/
[Sun Apr 17 23:56:31 2016] [error] [client xxx] File does not exist: /usr/share/phpmyadmin/navigation.php<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/
[Sun Apr 17 23:56:32 2016] [error] [client xxx] File does not exist: /usr/share/phpmyadmin/navigation.php<, referer: http://XXXXXXXXXXXXXX:74/phpmyadmin/

Arcan_-

As tu des règles d'url rewriting quelque part ?

EDIT :
Je viens de lire le tuto que tu as suivi.
Es-tu allé jusqu'au bout ?

Peux tu nous donner le résultat de la commande

Citation :

apache2ctl -M

Message édité par Arcan_- le 19-04-2016 à 09:45:37

dureiken

Bonjour,

voici le resultat

Code :

root@perso:/home/dureiken# apache2ctl -M
[Tue Apr 19 13:51:53 2016] [warn] The Alias directive in /etc/apache2/conf.d/php myadmin.conf at line 3 will probably never match because it overlaps an earlier Alias.
Loaded Modules:
core_module (static)
log_config_module (static)
logio_module (static)
version_module (static)
mpm_worker_module (static)
http_module (static)
so_module (static)
alias_module (shared)
auth_basic_module (shared)
authn_file_module (shared)
authz_default_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
cgi_module (shared)
cgid_module (shared)
deflate_module (shared)
dir_module (shared)
env_module (shared)
mime_module (shared)
negotiation_module (shared)
reqtimeout_module (shared)
setenvif_module (shared)
status_module (shared)
Syntax OK

pour les regles je ne sais pas, j'ai suivi plein de tutos au final

Arcan_-

A priori pas d'url rewrite, le module n'est pas activé.

Pas de module php non plus, ni suexec/suphp. Comment utilises tu php ? FPM ?

Ce warn m'interpelle :

Citation :

[Tue Apr 19 13:51:53 2016] [warn] The Alias directive in /etc/apache2/conf.d/phpmyadmin.conf at line 3 will probably never match because it overlaps an earlier Alias.

Que donne : grep Alias /etc/apache2/{apache2.conf,conf.d/*}

Publicité

dureiken

Cette ligne fait suite à l'ajout de :
Include /etc/apache2/conf.d/[^.#]*
dans apache2.conf, j'avais lu ça sur internet, mais sans succès.

et sinon :

Code :

root@perso:/home/dureiken# grep Alias /etc/apache2/{apache2.conf,conf.d/*}
/etc/apache2/conf.d/localized-error-pages:# We use Alias to redirect any /error/HTTP_<error>.html.var response to
/etc/apache2/conf.d/localized-error-pages:# Alias /error/include/ "/your/include/path/"
/etc/apache2/conf.d/localized-error-pages:# even on a per-VirtualHost basis. If you include the Alias in the global server
/etc/apache2/conf.d/localized-error-pages:# context, is has to come _before_ the 'Alias /error/ ...' line.
/etc/apache2/conf.d/localized-error-pages:# Alias /error/ "/usr/share/apache2/error/"
/etc/apache2/conf.d/phpmyadmin.conf:Alias /phpmyadmin /usr/share/phpmyadmin

Profil supprimé

Essaie de suivre tes includes:

grep -i include /etc/apache2/apache2.conf

dureiken

root@persohome/dureiken# grep -i include /etc/apache2/apache2.conf
# In order to avoid conflicts with backup files, the Include directive is
# * ports.conf is always included from the main configuration file. It is
# Possible values include: debug, info, notice, warn, error, crit,
# Include module configuration:
Include mods-enabled/*.load
Include mods-enabled/*.conf
# Include list of ports to listen on and which to use for name based vhosts
Include ports.conf
# Include of directories ignores editors' and dpkg's backup files,
# Include generic snippets of statements
Include conf.d/
# Include the virtual host configurations:
Include sites-enabled/
root@persohome/dureiken#

Profil supprimé

fais un peu:
ls -al /etc/apache2/conf.d/
Puis:
cat /etc/apache2/ports.conf

dureiken

oot@persohome/dureiken# ls -al /etc/apache2/conf.d/
total 24
drwxr-xr-x 2 root root 4096 Apr 18 17:23 .
drwxr-xr-x 7 root root 4096 Apr 18 17:22 ..
-rw-r--r-- 1 root root 269 Aug 18 2015 charset
-rw-r--r-- 1 root root 3296 Aug 18 2015 localized-error-pages
-rw-r--r-- 1 root root 143 Aug 18 2015 other-vhosts-access-log
lrwxrwxrwx 1 root root 28 Apr 18 17:23 phpmyadmin.conf -> ../../phpmyadmin/apache.conf
-rw-r--r-- 1 root root 2590 Aug 18 2015 security
root@persohome/dureiken# cat /etc/apache2/ports.conf
# If you just change the port or add more ports here, you will likely also
# have to change the VirtualHost statement in
# /etc/apache2/sites-enabled/000-default
# This is also true if you have upgraded from before 2.2.9-3 (i.e. from
# Debian etch). See /usr/share/doc/apache2.2-common/NEWS.Debian.gz and
# README.Debian.gz

NameVirtualHost *:74
Listen 74

<IfModule mod_ssl.c>
# If you add NameVirtualHost *:443 here, you will also have to change
# the VirtualHost statement in /etc/apache2/sites-available/default-ssl
# to <VirtualHost *:443>
# Server Name Indication for SSL named virtual hosts is currently not
# supported by MSIE on Windows XP.
Listen 443
</IfModule>

<IfModule mod_gnutls.c>
Listen 443
</IfModule>

root@persohome/dureiken#

Arcan_-

Peux tu nous donner le résultat de :
ls -la /etc/apache2/mods-enabled/

Ainsi que nous montrer le contenu de /etc/apache2/apache2.conf

dureiken

Code :

dureiken@perso:~$ ls -la /etc/apache2/mods-enabled/
total 8
drwxr-xr-x 2 root root 4096 Apr 18 17:22 .
drwxr-xr-x 7 root root 4096 Apr 18 17:22 ..
lrwxrwxrwx 1 root root 28 Apr 17 23:43 alias.conf -> ../mods-available/alias.conf
lrwxrwxrwx 1 root root 28 Apr 17 23:43 alias.load -> ../mods-available/alias.load
lrwxrwxrwx 1 root root 33 Apr 17 23:43 auth_basic.load -> ../mods-available/auth_basic.load
lrwxrwxrwx 1 root root 33 Apr 17 23:43 authn_file.load -> ../mods-available/authn_file.load
lrwxrwxrwx 1 root root 36 Apr 17 23:43 authz_default.load -> ../mods-available/authz_default.load
lrwxrwxrwx 1 root root 38 Apr 17 23:43 authz_groupfile.load -> ../mods-available/authz_groupfile.load
lrwxrwxrwx 1 root root 33 Apr 17 23:43 authz_host.load -> ../mods-available/authz_host.load
lrwxrwxrwx 1 root root 33 Apr 17 23:43 authz_user.load -> ../mods-available/authz_user.load
lrwxrwxrwx 1 root root 32 Apr 17 23:43 autoindex.conf -> ../mods-available/autoindex.conf
lrwxrwxrwx 1 root root 32 Apr 17 23:43 autoindex.load -> ../mods-available/autoindex.load
lrwxrwxrwx 1 root root 26 Apr 17 23:43 cgi.load -> ../mods-available/cgi.load
lrwxrwxrwx 1 root root 27 Apr 18 17:22 cgid.conf -> ../mods-available/cgid.conf
lrwxrwxrwx 1 root root 27 Apr 18 17:22 cgid.load -> ../mods-available/cgid.load
lrwxrwxrwx 1 root root 30 Apr 17 23:43 deflate.conf -> ../mods-available/deflate.conf
lrwxrwxrwx 1 root root 30 Apr 17 23:43 deflate.load -> ../mods-available/deflate.load
lrwxrwxrwx 1 root root 26 Apr 17 23:43 dir.conf -> ../mods-available/dir.conf
lrwxrwxrwx 1 root root 26 Apr 17 23:43 dir.load -> ../mods-available/dir.load
lrwxrwxrwx 1 root root 26 Apr 17 23:43 env.load -> ../mods-available/env.load
lrwxrwxrwx 1 root root 27 Apr 17 23:43 mime.conf -> ../mods-available/mime.conf
lrwxrwxrwx 1 root root 27 Apr 17 23:43 mime.load -> ../mods-available/mime.load
lrwxrwxrwx 1 root root 34 Apr 17 23:43 negotiation.conf -> ../mods-available/negotiation.conf
lrwxrwxrwx 1 root root 34 Apr 17 23:43 negotiation.load -> ../mods-available/negotiation.load
lrwxrwxrwx 1 root root 33 Apr 17 23:43 reqtimeout.conf -> ../mods-available/reqtimeout.conf
lrwxrwxrwx 1 root root 33 Apr 17 23:43 reqtimeout.load -> ../mods-available/reqtimeout.load
lrwxrwxrwx 1 root root 31 Apr 17 23:43 setenvif.conf -> ../mods-available/setenvif.conf
lrwxrwxrwx 1 root root 31 Apr 17 23:43 setenvif.load -> ../mods-available/setenvif.load
lrwxrwxrwx 1 root root 29 Apr 17 23:43 status.conf -> ../mods-available/status.conf
lrwxrwxrwx 1 root root 29 Apr 17 23:43 status.load -> ../mods-available/status.load

Et apache2
http://paste.debian.net/440015/

Merci ☺

Arcan_-

Je n'ai rien vu de spécial...

Peux tu nous montrer la configuration du vhost ?

dureiken

Merci de ton aide j'ai abandonné j'ai tout mis sur un PC portable a la maison avec un WAMP

Publicité

FORUM HardWare.fr

Linux et OS Alternatifs

Logiciels

Apache2 et phpmyadmin :

Sujets relatifs
[apache2] Déplacer /etc/apache2 ?	Sécurisation apache2
Apache2/debian ne veut pas exécuter les .cgi (mais download)	[resolu] configuration reperoire utilisateur apache2
[RESOLU] Apache2 -> 2 nom de domaines	[ Apache2 ] configuration d'un alias directory pour un sous domaine
DEBIAN echec installation Paquet apache2 php5...	Installation phpmyadmin
Problème pour me connecter à phpmyadmin	Problème pour (re)configurer phpmyadmin
Plus de sujets relatifs à : Apache2 et phpmyadmin :

Page générée en 0.099 secondes