Phpmyadmin

Support Debian
#1

Bonjour

Voila je viens vers se forum pour un problème sur phpmyadmin

installation faite de phpmyadmin et aussi apache2 et php5, mysql

je n arrive pas a accéder a distance a phpmyadmin
j’ai une erreur 404 url not found
J’ai un serveurs sous debian 6 chez ovh

hésite pas a me poser des questions
merci de votre reponse

#2

Salut,
Comment as-tu installé phpmyadmin ?

#3

merci de ta réponse

jai installer phpmyadmin en fesnr apt-get install phpmyadmin

quand je fais la commende que tu mas donner sa me si sa vdir /etc/apache2/conf.d/php* vdir: impossible d'accéder à /etc/apache2/conf.d/php*: Aucun fichier ou dossier de ce type

merci de ton aide

#4

Re,
Alors essaye ceci:

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf service apache2 restart

#5

la reponse a ra commande

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf ln: création d'un lien symbolique « /etc/apache2/conf.d/phpmyadmin.conf »: Le fichier existe

et quand je reste je nais plus d’erreur 404 mais j’ai rien qui affiche sur mon navigateur

#6

Salut,
As-tu regardé les logs de apache ?

#7

sa me dis permissions non accorder

~# /var/log/apache2/error.log -bash: /var/log/apache2/error.log: Permission non accordée

a savoir que je suis entrais de configurer des serveurs cod 4 en maintenant

#8

[quote=“Roro”]sa me dis permissions non accorder

~# /var/log/apache2/error.log -bash: /var/log/apache2/error.log: Permission non accordée

a savoir que je suis entrais de configurer des serveurs cod 4 en maintenant[/quote]

Pour voir ce qu’il y a dedans:

Ou tail -f /var/log/apache2/error.log au moment ou tu essaye d’ouvrir phpmyadmin. CTRL + C pour sortir.

#9

[Sat May 12 09:31:31 2012] [error] [client 88.160.95.162] File does not exist: /var/www/phpmyadmin [Sat May 12 10:07:43 2012] [notice] caught SIGTERM, shutting down [Sat May 12 10:07:44 2012] [notice] Apache/2.2.16 (Debian) PHP/5.3.3-7+squeeze9 with Suhosin-Patch configured -- resuming normal operations [Sat May 12 10:08:11 2012] [notice] caught SIGTERM, shutting down [Sat May 12 10:08:12 2012] [notice] Apache/2.2.16 (Debian) PHP/5.3.3-7+squeeze9 with Suhosin-Patch configured -- resuming normal operations

voila le debut du log je te mais pas tous

#10

Re,
Tu as fait d’autres modifications sur apache ou sur le répertoire /var/www ?
Il y a quoi dans phpmyadmin.conf ?

#11

oui j’ai tenter des chose mais rien ne marche

[code]# phpMyAdmin default Apache configuration

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
Allow from All

AddType application/x-httpd-php .php

            php_flag magic_quotes_gpc Off
            php_flag track_vars On
            php_flag register_globals Off
            php_value include_path .
    </IfModule>

Authorize for setup

<Directory /usr/share/phpmyadmin/setup>

AuthType Basic
AuthName "phpMyAdmin Setup"
AuthUserFile /etc/phpmyadmin/htpasswd.setup

Require valid-user

Disallow web access to directories that don’t need it

<Directory /usr/share/phpmyadmin/libraries>
Order Deny,Allow
Deny from All

<Directory /usr/share/phpmyadmin/setup/lib>
Order Deny,Allow
Deny from All

[/code]

#12

Ton fichier à l’air ok évidemment, mais si tu as touché à la configuration d’apache, je ne peux rien faire…

Tu te souviens quoi ? Quels modifications exactement ?
Tu as sauvegardé les fichiers avant modification ?

Il suffit d’une virgule pour que plus rien ne fonctionne…

#13

ok j’ai juste changer des chose para port au adresse prise en comte par myql

juste dans se fichiers
en suivant ce tuto http://tosri.free.fr/index.php?post/2011/03/24/Installer-phpMyAdmin-en-5min-sur-Debian

[code]# The MySQL database server configuration file.

You can copy this to one of:

- “/etc/mysql/my.cnf” to set global options,

- “~/.my.cnf” to set user-specific options.

One can use all long options that the program supports.

Run program with --help to get a list of available options and with

–print-defaults to see which it would actually understand and use.

For explanations see

http://dev.mysql.com/doc/mysql/en/server-system-variables.html

This will be passed to all mysql clients

It has been reported that passwords should be enclosed with ticks/quotes

escpecially if they contain “#” chars…

Remember to edit /etc/mysql/debian.cnf when changing the socket location.

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

Here is entries for some specific programs

The following values assume you have at least 32M ram

This was formally known as [safe_mysqld]. Both versions are currently parsed.

[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]

* Basic Settings

user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/french
skip-external-locking

Instead of skip-networking the default is now to listen only on

localhost which is more compatible and is not less secure.

#bind-address = xx.xx.42.108

* Fine Tuning

key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8

This replaces the startup script and checks MyISAM tables if needed

the first time they are touched

myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10

* Query Cache Configuration

query_cache_limit = 1M
query_cache_size = 16M

* Logging and Replication

Both location gets rotated by the cronjob.

Be aware that this log type is a performance killer.

As of 5.1 you can enable the log at runtime!

#general_log_file = /var/log/mysql/mysql.log
#general_log = 1

Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.

Here you can see queries with especially long duration

#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

The following can be used as easy to replay backup logs or for replication.

note: if you are setting up a replication slave, see README.Debian about

other settings you may need to change.

#server-id = 1
#log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name

* InnoDB

InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.

Read the manual for more InnoDB related options. There are many!

* Security Features

Read the manual, too, if you want chroot!

chroot = /var/lib/mysql/

For generating SSL certificates I recommend the OpenSSL GUI “tinyca”.

ssl-ca=/etc/mysql/cacert.pem

ssl-cert=/etc/mysql/server-cert.pem

ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer = 16M

* IMPORTANT: Additional settings that can override those from this file!

The files must end with ‘.cnf’, otherwise they’ll be ignored.

#[/code]

#14

Salut,
Rien à voir avec le fichier de conf de mysql, je pense.
Mais il serait bon d’avoir ça:bind-address = 127.0.0.1

(j’édite ton message pour enlever ton ip…)

Par contre, je suis étonné par ça:

Le fichier de conf donne ça comme alias:

Tu n’as pas touché à la conf d’apache ? (/etc/apache2/sites-available/default ?)

#15

j’ai remis l’adresse tu mas dis

et non je nai pas toucher au fichiers par default

[code]<VirtualHost *:80>
ServerAdmin webmaster@localhost

    DocumentRoot /var/www
    <Directory />
            Options FollowSymLinks
            AllowOverride None
    </Directory>
    <Directory /var/www/>
            Options Indexes FollowSymLinks MultiViews
            AllowOverride None
            Order allow,deny
            allow from all
    </Directory>

    ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
    <Directory "/usr/lib/cgi-bin">
            AllowOverride None
            Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
            Order allow,deny
            Allow from all
    </Directory>

[/code]

jen ai créer un autre pour pouvoir maitre mon site
sa c’est moi qui lais pris d’un tuto que j’ai suivis

[code]<VirtualHost *:80>
ServerAdmin zen-esport@gmail.com
ServerName sql.team-zen-atitude.com
DocumentRoot /var/www/sql.team-zen-attitude.com/

<Directory /var/www/sql.team-zen-attitude.com/>
    # On autorise tous le monde a voir le site
    Order allow,deny
    allow from all
    # Vous pouvez mettre ici une protection comme dans le tutoriel xHTML de M@teo21
</Directory>

ErrorLog /var/log/apache2/sql.team-zen-attitude.com-error_log      # Erreurs
TransferLog /var/log/apache2/sql.team-zen-attitude.com-access_log  # Accès

[/code]

#16

Je ne vois pas…

Tu as ajouté ceci au fichier de apache.conf de phpmyadmin ?

[quote]<Directory /usr/share/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
Allow from All

AddType application/x-httpd-php .php

            php_flag magic_quotes_gpc Off
            php_flag track_vars On
            php_flag register_globals Off
            php_value include_path .
    </IfModule>[/quote]

Tu as quoi comme message dans la console au re-démarrage de apache ? Donne aussi les logs au re-démarrage.

#17

oui c’est moi qui est changer dans le fichiers de configurations

voici le redemarage des apache

Restarting web server: apache2[Sat May 12 14:45:27 2012] [warn] NameVirtualHost *:8080 has no VirtualHosts ... waiting [Sat May 12 14:45:28 2012] [warn] NameVirtualHost *:8080 has no VirtualHosts .

#18

Les logs au moment du re-démarrage ?

#19

je pense que c’est sa que tu veux
dsl je mi connait pas encore bcp mais j’apprends tous les jour

[Sat May 12 14:29:10 2012] [error] [client 46.45.140.95] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Sat May 12 14:29:13 2012] [error] [client 46.45.140.95] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Sat May 12 14:45:27 2012] [notice] caught SIGTERM, shutting down [Sat May 12 14:45:28 2012] [notice] Apache/2.2.16 (Debian) PHP/5.3.3-7+squeeze9 with Suhosin-Patch configured -- resuming normal operations

#20

Re,
Je ne vois pas trop ou pourrait être le problème…
Que donne: