Php5/Apache2.0 et My SQL...

Pat81
Invité n'ayant pas de compte PHPfrance

09 avr. 2009, 21:49

Bonsoir,

Je configure actuellement sur un serveur dédié Windows 2003 R2 Standard x64 Edition :

- Apache 2 (apache_2.0.55-win32-x86-no_ssl.msi)
- Php5 (php-5.1.1-Win32.zip)
- MySQL Essential (mysql-essential-5[1].0.15-win32.msi)

L'installation de mon Apache se déroule correctement, je modifie les premières informations de mon httpf.conf :

- DocumentRoot "c:/web/www"
- DirectoryIndex index.php index.html index.htm index.html.var

Je restart mon serveur web et les modifications sont bien pris en compte, j'accède à la racine de mon site voulu avec le bon indexage.

Je passe alors a PHP5, j'extract dans mon répertoire C:/web/php5 et renome mon php.php-dist en php.ini et le modifie :

- extension_dir = "./" en extension_dir = "c:\web\php5\ext" (chemin de mes futurs extensions)

J'enregistre mon php.ini et le ferme.

Je réouvre mon httpd.conf (Apache tourne toujours) et rajoute ces lignes de codes en bottom :

# Config PHP
LoadModule php5_module "c:/web/php5/php5apache2.dll"
AddType application/x-httpd-php .php

# Path pour php.ini
PHPIniDir "c:/web/php5"

J'enregistre et ferme mon httpd.conf.

Je redémarre mon serveur, mon apache tourne impect et est bien en relation avec mon PHP5 !

J'installe MySQL Essential, l'installation se déroule correctement, je choisi bien SQL5 dans les paramètres de configurations. J'installe également mysql-administrator-1.1.5-win.msi pour plus me sentir à l'aise !

Je crée une base de donnée, mon SQL tourne à merveille, le service est bien démarré tout comme celui d'Apache2.

Je décide donc de réaliser le final... La mise en relation de Apache/PHP5 avec SQL qui tourne.

Je prends alors mon fichier php.ini et modifie cette ligne pour déclarer SQL :

;extension=php_mysql.dll en extension=php_mysql.dll

Et je prends soins de copier le fichier libmysql.dll dans mon répertoire /System32.

J'enregistre mon php.ini et redémarre le serveur.

Au redémarrage du serveur le service Apache ne se lance plus, il me bloque totalement la mise en fonction du serveur web.

J'ai remarqué en commentant la commande PHPIndir "c:/web/php5" et en redémmarant le serveur le service reparté.

Je décide alors de recommenté mon extension=php_mysql.dll et de décommenté mon PHPIndir, en redémmarant, tout redevient normal.

Apache marche, PHP5 marche, mais je n'arrive pas à mettre en relation mon extention SQL avec mon php.ini sans faire bugger le serveur web ://

Dans mon répertoire /php5/ext, je retrouve bien mes fichier .dll dont mysql.

J'ai déja réalisé cette configuration sur un dédié mais là je bloque... j'ai du oublié quelque chose....

J'éspère avoir attiré votre attention et l'envie de me répondre,

Merci par avance,

pat.

Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 10684 Messages

09 avr. 2009, 23:41

Regarde dans les logs d'apache, tu auras probablement plus d'info sur ce qui pose problème :)
Ce n'est pas en améliorant la bougie que l'on a inventé l'ampoule...

Pat81
Invité n'ayant pas de compte PHPfrance

10 avr. 2009, 00:14

En même temps que je fesais mes tests j'analysais mes logs mais quand le serveur redémarre avec la config complete le service ne s'active pas et n'écris aucun logs :/

Voilà ce que j'ai pu tirer du error.log

Code : Tout sélectionner

[Thu Apr 09 17:07:50 2009] [notice] Apache/2.0.55 (Win32) PHP/5.1.1 configured -- resuming normal operations [Thu Apr 09 17:07:50 2009] [notice] Server built: Oct 9 2005 19:16:56 [Thu Apr 09 17:07:50 2009] [notice] Parent: Created child process 1208 [Thu Apr 09 17:07:50 2009] [notice] Child 1208: Child process is running [Thu Apr 09 17:07:50 2009] [notice] Child 1208: Acquired the start mutex. [Thu Apr 09 17:07:50 2009] [notice] Child 1208: Starting 250 worker threads. [Thu Apr 09 17:09:25 2009] [notice] Apache/2.0.55 (Win32) configured -- resuming normal operations [Thu Apr 09 17:09:25 2009] [notice] Server built: Oct 9 2005 19:16:56 [Thu Apr 09 17:09:25 2009] [notice] Parent: Created child process 1508 [Thu Apr 09 17:09:26 2009] [notice] Child 1508: Child process is running [Thu Apr 09 17:09:26 2009] [notice] Child 1508: Acquired the start mutex. [Thu Apr 09 17:09:26 2009] [notice] Child 1508: Starting 250 worker threads. [Thu Apr 09 17:09:30 2009] [error] [client 85.25.17.43] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpmyadmin [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpMyAdmin [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/db [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/web [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/PMA [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/admin [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysql [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/myadmin [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/webadmin [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/sqlweb [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/websql [Thu Apr 09 17:14:02 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/webdb [Thu Apr 09 17:14:03 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysqladmin [Thu Apr 09 17:14:03 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysql-admin [Thu Apr 09 17:14:03 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpmyadmin2 [Thu Apr 09 17:14:03 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/php-my-admin [Thu Apr 09 17:14:33 2009] [error] [client 85.25.17.43] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Thu Apr 09 17:14:34 2009] [error] [client 85.14.221.235] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Thu Apr 09 17:14:59 2009] [notice] Parent: Received restart signal -- Restarting the server. [Thu Apr 09 17:14:59 2009] [notice] Child 1508: Exit event signaled. Child process is ending. [Thu Apr 09 17:14:59 2009] [notice] Apache/2.0.55 (Win32) configured -- resuming normal operations [Thu Apr 09 17:14:59 2009] [notice] Server built: Oct 9 2005 19:16:56 [Thu Apr 09 17:14:59 2009] [notice] Parent: Created child process 3840 [Thu Apr 09 17:14:59 2009] [notice] Child 3840: Child process is running [Thu Apr 09 17:15:00 2009] [notice] Child 1508: Released the start mutex [Thu Apr 09 17:15:00 2009] [notice] Child 3840: Acquired the start mutex. [Thu Apr 09 17:15:00 2009] [notice] Child 3840: Starting 250 worker threads. [Thu Apr 09 17:15:01 2009] [notice] Child 1508: Waiting for 250 worker threads to exit. [Thu Apr 09 17:15:01 2009] [notice] Child 1508: All worker threads have exited. [Thu Apr 09 17:15:01 2009] [notice] Child 1508: Child process is exiting [Thu Apr 09 17:15:50 2009] [notice] Parent: Received restart signal -- Restarting the server. [Thu Apr 09 17:15:50 2009] [notice] Child 3840: Exit event signaled. Child process is ending. [Thu Apr 09 17:15:50 2009] [notice] Apache/2.0.55 (Win32) configured -- resuming normal operations [Thu Apr 09 17:15:50 2009] [notice] Server built: Oct 9 2005 19:16:56 [Thu Apr 09 17:15:50 2009] [notice] Parent: Created child process 1248 [Thu Apr 09 17:15:50 2009] [notice] Child 1248: Child process is running [Thu Apr 09 17:15:51 2009] [notice] Child 3840: Released the start mutex [Thu Apr 09 17:15:51 2009] [notice] Child 1248: Acquired the start mutex. [Thu Apr 09 17:15:51 2009] [notice] Child 1248: Starting 250 worker threads. [Thu Apr 09 17:15:52 2009] [notice] Child 3840: Waiting for 250 worker threads to exit. [Thu Apr 09 17:15:58 2009] [notice] Child 3840: All worker threads have exited. [Thu Apr 09 17:15:58 2009] [notice] Child 3840: Child process is exiting [Thu Apr 09 17:16:37 2009] [error] [client 87.106.47.235] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpmyadmin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpMyAdmin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/db [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/web [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/PMA [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/admin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysql [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/myadmin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/webadmin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/sqlweb [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/websql [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/webdb [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysqladmin [Thu Apr 09 17:19:07 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/mysql-admin [Thu Apr 09 17:19:08 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/phpmyadmin2 [Thu Apr 09 17:19:08 2009] [error] [client 85.25.17.43] File does not exist: C:/web/www/php-my-admin [Thu Apr 09 17:19:41 2009] [error] [client 85.25.17.43] client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): /w00tw00t.at.ISC.SANS.DFind:) [Thu Apr 09 17:20:18 2009] [notice] Parent: Received restart signal -- Restarting the server. [Thu Apr 09 17:20:18 2009] [notice] Child 1248: Exit event signaled. Child process is ending.
Je ne comprends pas les ligne File does not exist, vous auriez la réponse, un piste ??

Merci par avance,

pat.