[apache] Ne se lance pas

[AchilleFraisse]

Bonjour,
J'ai installé apache php php-apache et mariadb sur mon PC pour lancé un serveur web.
J'ai suivi les indications fourni par ce wikia : https://wiki.archlinux.fr/LAMP

Mais lorsque je tape localhost dans mon navigateur, il me dit : page introuvable.

De plus, mysql n'arrive pas à se lancer. Quand je tape systemctl start mysqld il me dit job for mysqld.service failed.

[FoolEcho]

Salut,

Sans log on ne peut pas t'aider...
Voir systemctl pour mariadb et logs dans /var/log/httpd/ pour Apache.

[AchilleFraisse]

Résultats de systemctl status httpd :

Code : Tout sélectionner

● httpd.service - Apache Web Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Sun 2016-05-22 09:16:02 CEST; 2h 7min ago
  Process: 5031 ExecStop=/usr/bin/httpd -k graceful-stop (code=exited, status=1/FAILURE)
  Process: 5027 ExecStart=/usr/bin/httpd -k start -DFOREGROUND (code=exited, status=1/FAILURE)
 Main PID: 5027 (code=exited, status=1/FAILURE)

May 22 09:16:01 systemd[1]: Started Apache Web Server.
May 22 09:16:01 httpd[5027]: [Sun May 22 09:16:01.940065 2016] [:crit] [pid 5027:tid 140277009012608] Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe.  You need to recompile PHP.
May 22 09:16:01 httpd[5027]: AH00013: Pre-configuration failed
May 22 09:16:01 systemd[1]: httpd.service: Main process exited, code=exited, status=1/FAILURE
May 22 09:16:02 httpd[5031]: [Sun May 22 09:16:02.010500 2016] [:crit] [pid 5031:tid 140689455191936] Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe.  You need to recompile PHP.
May 22 09:16:02 httpd[5031]: AH00013: Pre-configuration failed
May 22 09:16:02 systemd[1]: httpd.service: Control process exited, code=exited status=1
May 22 09:16:02 systemd[1]: httpd.service: Unit entered failed state.
May 22 09:16:02 systemd[1]: httpd.service: Failed with result 'exit-code'.

Résultat de systemctl status mysqld.service :

Code : Tout sélectionner

● mysqld.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; vendor preset: disabled)
   Active: activating (start-post) (Result: exit-code) since Sun 2016-05-22 11:25:09 CEST; 53s ago
  Process: 6454 ExecStart=/usr/bin/mysqld --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
 Main PID: 6454 (code=exited, status=1/FAILURE);         : 6455 (mysqld-post)
    Tasks: 2 (limit: 512)
   CGroup: /system.slice/mysqld.service
           └─control
             ├─6455 /bin/sh /usr/bin/mysqld-post
             └─6922 sleep 1

May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [Note] Plugin 'FEEDBACK' is disabled.
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [Note] Recovering after a crash using mysql-bin
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [Note] Starting crash recovery...
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [Note] Crash recovery finished.
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112658688 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [Note] Server socket created on IP: '::'.
May 22 11:25:10 mysqld[6454]: 2016-05-22 11:25:10 140029112792960 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
May 22 11:25:10 systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE

[benjarobin]

Si tu relisais le Wiki (surtout pour la partie apache), pour mysqld tu as bien lu la page Wiki de mariadb ?

[AchilleFraisse]

Ben oui, j'ai tout lu et j'ai fais comme le wiki.
J'ai éditier tous les fichiers de configuration, mais ca ne marche pas.

[benjarobin]

Juste pour confirmer, peux tu donner la sortie (en root) de :

Code : Tout sélectionner

ls -l /var/lib/mysql

Et de

Code : Tout sélectionner

grep -Ev "^ *#|^ *$" /etc/httpd/conf/httpd.conf

[AchilleFraisse]

/var/lib/mysql :

Code : Tout sélectionner

total 111064
-rw-rw---- 1 mysql mysql     8192 May 22 13:13 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 May 22 13:13 aria_log_control
-rw-rw---- 1 mysql mysql 12582912 May 22 13:13 ibdata1
-rw-rw---- 1 mysql mysql 50331648 May 22 13:13 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 May 22 09:19 ib_logfile1
-rw-rw---- 1 mysql mysql      313 May 22 09:20 mysql-bin.000001
-rw-rw---- 1 mysql mysql      313 May 22 09:21 mysql-bin.000002
-rw-rw---- 1 mysql mysql      313 May 22 09:22 mysql-bin.000003
-rw-rw---- 1 mysql mysql      313 May 22 09:24 mysql-bin.000004
-rw-rw---- 1 mysql mysql      313 May 22 09:26 mysql-bin.000005
-rw-rw---- 1 mysql mysql      313 May 22 09:27 mysql-bin.000006
-rw-rw---- 1 mysql mysql      313 May 22 09:29 mysql-bin.000007
-rw-rw---- 1 mysql mysql      313 May 22 09:30 mysql-bin.000008
-rw-rw---- 1 mysql mysql      313 May 22 09:32 mysql-bin.000009
-rw-rw---- 1 mysql mysql      313 May 22 09:33 mysql-bin.000010
-rw-rw---- 1 mysql mysql      313 May 22 09:35 mysql-bin.000011
-rw-rw---- 1 mysql mysql      313 May 22 09:36 mysql-bin.000012
-rw-rw---- 1 mysql mysql      313 May 22 09:38 mysql-bin.000013
-rw-rw---- 1 mysql mysql      313 May 22 09:39 mysql-bin.000014
-rw-rw---- 1 mysql mysql      313 May 22 09:41 mysql-bin.000015
-rw-rw---- 1 mysql mysql      313 May 22 09:42 mysql-bin.000016
-rw-rw---- 1 mysql mysql      313 May 22 09:44 mysql-bin.000017
-rw-rw---- 1 mysql mysql      313 May 22 09:45 mysql-bin.000018
-rw-rw---- 1 mysql mysql      313 May 22 09:47 mysql-bin.000019
-rw-rw---- 1 mysql mysql      313 May 22 09:48 mysql-bin.000020
-rw-rw---- 1 mysql mysql      313 May 22 09:50 mysql-bin.000021
-rw-rw---- 1 mysql mysql      313 May 22 09:51 mysql-bin.000022
-rw-rw---- 1 mysql mysql      313 May 22 09:53 mysql-bin.000023
-rw-rw---- 1 mysql mysql      313 May 22 09:54 mysql-bin.000024
-rw-rw---- 1 mysql mysql      313 May 22 09:56 mysql-bin.000025
-rw-rw---- 1 mysql mysql      313 May 22 09:57 mysql-bin.000026
-rw-rw---- 1 mysql mysql      313 May 22 09:59 mysql-bin.000027
-rw-rw---- 1 mysql mysql      313 May 22 10:00 mysql-bin.000028
-rw-rw---- 1 mysql mysql      313 May 22 10:02 mysql-bin.000029
-rw-rw---- 1 mysql mysql      313 May 22 10:03 mysql-bin.000030
-rw-rw---- 1 mysql mysql      313 May 22 10:05 mysql-bin.000031
-rw-rw---- 1 mysql mysql      313 May 22 10:06 mysql-bin.000032
-rw-rw---- 1 mysql mysql      313 May 22 10:08 mysql-bin.000033
-rw-rw---- 1 mysql mysql      313 May 22 10:09 mysql-bin.000034
-rw-rw---- 1 mysql mysql      313 May 22 10:11 mysql-bin.000035
-rw-rw---- 1 mysql mysql      313 May 22 10:12 mysql-bin.000036
-rw-rw---- 1 mysql mysql      313 May 22 10:14 mysql-bin.000037
-rw-rw---- 1 mysql mysql      313 May 22 10:15 mysql-bin.000038
-rw-rw---- 1 mysql mysql      313 May 22 10:17 mysql-bin.000039
-rw-rw---- 1 mysql mysql      313 May 22 10:18 mysql-bin.000040
-rw-rw---- 1 mysql mysql      313 May 22 10:20 mysql-bin.000041
-rw-rw---- 1 mysql mysql      313 May 22 10:21 mysql-bin.000042
-rw-rw---- 1 mysql mysql      313 May 22 10:23 mysql-bin.000043
-rw-rw---- 1 mysql mysql      313 May 22 10:24 mysql-bin.000044
-rw-rw---- 1 mysql mysql      313 May 22 10:26 mysql-bin.000045
-rw-rw---- 1 mysql mysql      313 May 22 10:27 mysql-bin.000046
-rw-rw---- 1 mysql mysql      313 May 22 10:29 mysql-bin.000047
-rw-rw---- 1 mysql mysql      313 May 22 10:30 mysql-bin.000048
-rw-rw---- 1 mysql mysql      313 May 22 10:32 mysql-bin.000049
-rw-rw---- 1 mysql mysql      313 May 22 10:33 mysql-bin.000050
-rw-rw---- 1 mysql mysql      313 May 22 10:35 mysql-bin.000051
-rw-rw---- 1 mysql mysql      313 May 22 10:36 mysql-bin.000052
-rw-rw---- 1 mysql mysql      313 May 22 10:38 mysql-bin.000053
-rw-rw---- 1 mysql mysql      313 May 22 10:39 mysql-bin.000054
-rw-rw---- 1 mysql mysql      313 May 22 10:41 mysql-bin.000055
-rw-rw---- 1 mysql mysql      313 May 22 10:42 mysql-bin.000056
-rw-rw---- 1 mysql mysql      313 May 22 10:44 mysql-bin.000057
-rw-rw---- 1 mysql mysql      313 May 22 10:45 mysql-bin.000058
-rw-rw---- 1 mysql mysql      313 May 22 10:47 mysql-bin.000059
-rw-rw---- 1 mysql mysql      313 May 22 10:48 mysql-bin.000060
-rw-rw---- 1 mysql mysql      313 May 22 10:50 mysql-bin.000061
-rw-rw---- 1 mysql mysql      313 May 22 10:51 mysql-bin.000062
-rw-rw---- 1 mysql mysql      313 May 22 10:53 mysql-bin.000063
-rw-rw---- 1 mysql mysql      313 May 22 10:55 mysql-bin.000064
-rw-rw---- 1 mysql mysql      313 May 22 10:56 mysql-bin.000065
-rw-rw---- 1 mysql mysql      313 May 22 10:58 mysql-bin.000066
-rw-rw---- 1 mysql mysql      313 May 22 10:59 mysql-bin.000067
-rw-rw---- 1 mysql mysql      313 May 22 11:01 mysql-bin.000068
-rw-rw---- 1 mysql mysql      313 May 22 11:02 mysql-bin.000069
-rw-rw---- 1 mysql mysql      313 May 22 11:04 mysql-bin.000070
-rw-rw---- 1 mysql mysql      313 May 22 11:05 mysql-bin.000071
-rw-rw---- 1 mysql mysql      313 May 22 11:07 mysql-bin.000072
-rw-rw---- 1 mysql mysql      313 May 22 11:08 mysql-bin.000073
-rw-rw---- 1 mysql mysql      313 May 22 11:10 mysql-bin.000074
-rw-rw---- 1 mysql mysql      313 May 22 11:11 mysql-bin.000075
-rw-rw---- 1 mysql mysql      313 May 22 11:13 mysql-bin.000076
-rw-rw---- 1 mysql mysql      313 May 22 11:14 mysql-bin.000077
-rw-rw---- 1 mysql mysql      313 May 22 11:16 mysql-bin.000078
-rw-rw---- 1 mysql mysql      313 May 22 11:17 mysql-bin.000079
-rw-rw---- 1 mysql mysql      313 May 22 11:19 mysql-bin.000080
-rw-rw---- 1 mysql mysql      313 May 22 11:20 mysql-bin.000081
-rw-rw---- 1 mysql mysql      313 May 22 11:22 mysql-bin.000082
-rw-rw---- 1 mysql mysql      313 May 22 11:23 mysql-bin.000083
-rw-rw---- 1 mysql mysql      313 May 22 11:25 mysql-bin.000084
-rw-rw---- 1 mysql mysql      313 May 22 11:26 mysql-bin.000085
-rw-rw---- 1 mysql mysql      313 May 22 11:28 mysql-bin.000086
-rw-rw---- 1 mysql mysql      313 May 22 11:29 mysql-bin.000087
-rw-rw---- 1 mysql mysql      313 May 22 11:31 mysql-bin.000088
-rw-rw---- 1 mysql mysql      313 May 22 11:32 mysql-bin.000089
-rw-rw---- 1 mysql mysql      313 May 22 11:34 mysql-bin.000090
-rw-rw---- 1 mysql mysql      313 May 22 11:35 mysql-bin.000091
-rw-rw---- 1 mysql mysql      313 May 22 11:37 mysql-bin.000092
-rw-rw---- 1 mysql mysql      313 May 22 11:38 mysql-bin.000093
-rw-rw---- 1 mysql mysql      313 May 22 11:40 mysql-bin.000094
-rw-rw---- 1 mysql mysql      313 May 22 11:41 mysql-bin.000095
-rw-rw---- 1 mysql mysql      313 May 22 11:43 mysql-bin.000096
-rw-rw---- 1 mysql mysql      313 May 22 11:44 mysql-bin.000097
-rw-rw---- 1 mysql mysql      313 May 22 11:46 mysql-bin.000098
-rw-rw---- 1 mysql mysql      313 May 22 11:47 mysql-bin.000099
-rw-rw---- 1 mysql mysql      313 May 22 11:49 mysql-bin.000100
-rw-rw---- 1 mysql mysql      313 May 22 11:50 mysql-bin.000101
-rw-rw---- 1 mysql mysql      313 May 22 11:52 mysql-bin.000102
-rw-rw---- 1 mysql mysql      313 May 22 11:53 mysql-bin.000103
-rw-rw---- 1 mysql mysql      313 May 22 11:55 mysql-bin.000104
-rw-rw---- 1 mysql mysql      313 May 22 11:56 mysql-bin.000105
-rw-rw---- 1 mysql mysql      313 May 22 11:58 mysql-bin.000106
-rw-rw---- 1 mysql mysql      313 May 22 11:59 mysql-bin.000107
-rw-rw---- 1 mysql mysql      313 May 22 12:01 mysql-bin.000108
-rw-rw---- 1 mysql mysql      313 May 22 12:53 mysql-bin.000109
-rw-rw---- 1 mysql mysql      313 May 22 12:54 mysql-bin.000110
-rw-rw---- 1 mysql mysql      313 May 22 12:56 mysql-bin.000111
-rw-rw---- 1 mysql mysql      313 May 22 12:57 mysql-bin.000112
-rw-rw---- 1 mysql mysql      313 May 22 12:59 mysql-bin.000113
-rw-rw---- 1 mysql mysql      313 May 22 13:13 mysql-bin.000114
-rw-rw---- 1 mysql mysql     2166 May 22 13:13 mysql-bin.index

/etc/httpd/conf/httpd.conf :

Code : Tout sélectionner

ServerRoot "/etc/httpd"
Listen 80
LoadModule authn_file_module modules/mod_authn_file.so
LoadModule authn_core_module modules/mod_authn_core.so
LoadModule authz_host_module modules/mod_authz_host.so
LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_user_module modules/mod_authz_user.so
LoadModule authz_core_module modules/mod_authz_core.so
LoadModule access_compat_module modules/mod_access_compat.so
LoadModule auth_basic_module modules/mod_auth_basic.so
LoadModule reqtimeout_module modules/mod_reqtimeout.so
LoadModule include_module modules/mod_include.so
LoadModule filter_module modules/mod_filter.so
LoadModule mime_module modules/mod_mime.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule env_module modules/mod_env.so
LoadModule headers_module modules/mod_headers.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule version_module modules/mod_version.so
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_connect_module modules/mod_proxy_connect.so
LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule proxy_fcgi_module modules/mod_proxy_fcgi.so
LoadModule proxy_scgi_module modules/mod_proxy_scgi.so
LoadModule proxy_wstunnel_module modules/mod_proxy_wstunnel.so
LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
LoadModule proxy_express_module modules/mod_proxy_express.so
LoadModule slotmem_shm_module modules/mod_slotmem_shm.so
LoadModule lbmethod_byrequests_module modules/mod_lbmethod_byrequests.so
LoadModule lbmethod_bytraffic_module modules/mod_lbmethod_bytraffic.so
LoadModule lbmethod_bybusyness_module modules/mod_lbmethod_bybusyness.so
LoadModule lbmethod_heartbeat_module modules/mod_lbmethod_heartbeat.so
LoadModule mpm_event_module modules/mod_mpm_event.so
LoadModule unixd_module modules/mod_unixd.so
LoadModule status_module modules/mod_status.so
LoadModule autoindex_module modules/mod_autoindex.so
<IfModule !mpm_prefork_module>
	#LoadModule cgid_module modules/mod_cgid.so
</IfModule>
<IfModule mpm_prefork_module>
	#LoadModule cgi_module modules/mod_cgi.so
</IfModule>
LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
LoadModule userdir_module modules/mod_userdir.so
LoadModule alias_module modules/mod_alias.so
LoadModule php7_module modules/libphp7.so
<IfModule unixd_module>
User http
Group http
</IfModule>
ServerAdmin you@example.com
<Directory />
    AllowOverride none
    Require all denied
</Directory>
DocumentRoot "/srv/http"
<Directory "/srv/http">
    Options Indexes FollowSymLinks
    AllowOverride None
    Require all granted
</Directory>
<IfModule dir_module>
    DirectoryIndex index.html
</IfModule>
<Files ".ht*">
    Require all denied
</Files>
ErrorLog "/var/log/httpd/error_log"
LogLevel warn
<IfModule log_config_module>
    LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
    LogFormat "%h %l %u %t \"%r\" %>s %b" common
    <IfModule logio_module>
      LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
    </IfModule>
    CustomLog "/var/log/httpd/access_log" common
</IfModule>
<IfModule alias_module>
    ScriptAlias /cgi-bin/ "/srv/http/cgi-bin/"
</IfModule>
<IfModule cgid_module>
</IfModule>
<Directory "/srv/http/cgi-bin">
    AllowOverride None
    Options None
    Require all granted
</Directory>
<IfModule mime_module>
    TypesConfig conf/mime.types
    AddType application/x-compress .Z
    AddType application/x-gzip .gz .tgz
</IfModule>
Include conf/extra/httpd-mpm.conf
Include conf/extra/httpd-multilang-errordoc.conf
Include conf/extra/httpd-autoindex.conf
Include conf/extra/httpd-languages.conf
Include conf/extra/httpd-userdir.conf
Include conf/extra/httpd-default.conf
<IfModule proxy_html_module>
Include conf/extra/proxy-html.conf
</IfModule>
<IfModule ssl_module>
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>
Include conf/extra/php7_module.conf

[benjarobin]

Manifestement tu n'as pas lu correctement le Wiki pour la partie apache/httpd ! (Non je ne vais pas donner la solution, elle est donné dans le premier lien que tu as donné: LAMP)
Pour mysql je te recommande d’arrêter le service et de refaire les bases de données (si bien sûr tu n'avais rien stocké dessus)

Code : Tout sélectionner

rm -rf /var/lib/mysql
/usr/bin/mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

[AchilleFraisse]

Pour Apache, j'ai relu le wiki et j'avais tout fais correctement.
Pour mysql, j'ai réinstallé les bdd puis j'ai redémarrer le service mysqld. Mais j'ai toujours l'erreur :
Job for mysqld.service failed because a timeout was exceeded

[benjarobin]

Indice pour apache il faut utiliser mod_mpm_prefork.so et non mod_mpm_event.so si tu veux utiliser le module de php !
Et pour mysql je n'ai pas trop d'idée, mais comme je ne sais vraiment pas ce que tu fais... Et sans log cela n'aide pas

[AchilleFraisse]

Ok. Pour apache, ca marche. Je ne l'avais pas vu car je n'avais pas obtenu cette erreur : Si vous obtenez l'erreur "Apache is running a threaded MPM", c'est que apache utilise le module MPM threaded qui ne permet pas l'utilisation de php (Sauf via CGI).

Pour mysql, j'ai installé mariadb.
J'ai décommenté dans le fichier /etc/php.ini ces deux lignes :

Code : Tout sélectionner

extension=mysqli.so 
extension=pdo_mysql.so

J'ai fais systemctl start mysqld et ca ne marchais pas.
J'ai donc supprimer le repertoire /var/lib/mysql, puis j'ai exécuté la commande :

Code : Tout sélectionner

/usr/bin/mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

J'ai redémarré le service mysqld et ca ne marche toujours pas.

Je tiens à signaler que je ne peux pas accéder au repertoire /var/lib/mysql en utilisateur normal. Je suis obligé d'être root pour RENTRER dedans.

Pour les logs,
systemctl status mysqld :

[benjarobin]

Ok. Pour apache, ca marche. Je ne l'avais pas vu car je n'avais pas obtenu cette erreur : Si vous obtenez l'erreur "Apache is running a threaded MPM", c'est que apache utilise le module MPM threaded qui ne permet pas l'utilisation de php

Sauf que cette erreur tu l'as copié collé ici dans ton 2ième message !!! Donc tu avais bien eu cette erreur...
Pour mysql tout montre que cela fonctionne normalement... Je ne vois pas où tu as vu un échec du lancement de mysqld

[AchilleFraisse]

Je ne vois pas où tu as vu un échec du lancement de mysqld

Effectivement
En faisant un restart au lieu de start sur la commande systemctl ca marche.

Merci infiniment pour ton aide !

[AchilleFraisse]

Juste une dernière question, il faut mieux accéder à mysql avec l'utilisateur root en se créant un utilisateur pour la bdd ?

[benjarobin]

Les comptes utilisateurs de ton PC n'ont aucun rapport avec les utilisateurs de mysql.
Après tu peux lancer le client mysql avec n'importe quel utilisateur de ton PC, donc lancer le client en root n'est pas un problème bien qu'inutile (donc potentiellement dangereux)