Mysql_connect(): Access denied for user 'zabbix'@'localhost'

Fermé
piven2015 Messages postés 1 Date d'inscription jeudi 12 février 2015 Statut Membre Dernière intervention 12 février 2015 - 12 févr. 2015 à 14:50
jordane45 Messages postés 38292 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 19 novembre 2024 - 12 févr. 2015 à 17:47
En esperant trouver une solution dans ce forum je viens vers vous chers frere pour vous soumettre le problème qui me ronge depuis environ 01 mois.
en fait j'ai installer zabbix sur ubuntu 12.04. lorsque je saisie l'adresse de mon serveur sur un navigateur comme firefox j'ai l'erreur
mysql_connect(): Access denied for user 'zabbix'@'localhost' (using password: YES) [include/db.inc.php:58]

par ailleurs lorsque je demarre le serveur apache2 operation qui se termine par OK j'ai ceci sur le fichier error log d'apache2:

[Thu Feb 12 14:32:49 2015] [notice] caught SIGTERM, shutting down
[Thu Feb 12 14:32:50 2015] [notice] Apache/2.2.22 (Ubuntu) PHP/5.3.10-1ubuntu3.15 with Suhosin-Patch configured -- resuming normal operations

fichier zabbix_server.log

8498:20150212:143557.600 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8498:20150212:143557.601 Cannot connect to the database. Exiting...
8839:20150212:143557.691 Starting Zabbix Server. Zabbix 1.8.11 (revision 26205).
8839:20150212:143557.691 ****** Enabled features ******
8839:20150212:143557.691 SNMP monitoring: YES
8839:20150212:143557.691 IPMI monitoring: YES
8839:20150212:143557.691 WEB monitoring: YES
8839:20150212:143557.691 Jabber notifications: YES
8839:20150212:143557.691 Ez Texting notifications: YES
8839:20150212:143557.691 ODBC: NO
8839:20150212:143557.691 SSH2 support: YES
8839:20150212:143557.692 IPv6 support: YES
8839:20150212:143557.692 ******************************
8839:20150212:143557.695 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143557.695 Database is down. Reconnecting in 10 seconds.
8839:20150212:143607.696 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143607.696 Database is down. Reconnecting in 10 seconds.
8839:20150212:143617.696 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143617.696 Database is down. Reconnecting in 10 seconds.
8839:20150212:143627.697 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143627.697 Database is down. Reconnecting in 10 seconds.
8839:20150212:143637.698 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143637.698 Database is down. Reconnecting in 10 seconds.
8839:20150212:143647.698 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143647.699 Database is down. Reconnecting in 10 seconds.
8839:20150212:143657.699 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143657.699 Database is down. Reconnecting in 10 seconds.
8839:20150212:143707.700 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143707.700 Database is down. Reconnecting in 10 seconds.
8839:20150212:143717.700 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143717.701 Database is down. Reconnecting in 10 seconds.
8839:20150212:143727.701 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143727.701 Database is down. Reconnecting in 10 seconds.
8839:20150212:143737.702 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143737.702 Database is down. Reconnecting in 10 seconds.
8839:20150212:143747.702 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143747.703 Database is down. Reconnecting in 10 seconds.
8839:20150212:143757.703 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143757.703 Database is down. Reconnecting in 10 seconds.
8839:20150212:143807.704 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143807.704 Database is down. Reconnecting in 10 seconds.
8839:20150212:143817.704 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143817.704 Database is down. Reconnecting in 10 seconds.
8839:20150212:143827.705 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143827.705 Database is down. Reconnecting in 10 seconds.
8839:20150212:143837.706 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143837.706 Database is down. Reconnecting in 10 seconds.
8839:20150212:143847.706 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143847.707 Database is down. Reconnecting in 10 seconds.
8839:20150212:143857.707 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
8839:20150212:143857.707 Database is down. Reconnecting in 10 seconds.

fichier error.log de mysql

150208 0:19:38 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:38 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:38 InnoDB: The InnoDB memory heap is disabled
150208 0:19:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:38 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:38 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:38 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
150208 0:19:38 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
150208 0:19:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
150208 0:19:39 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
150208 0:19:40 InnoDB: Waiting for the background threads to start
150208 0:19:41 InnoDB: 5.5.41 started; log sequence number 0
150208 0:19:41 InnoDB: Starting shutdown...
150208 0:19:42 InnoDB: Shutdown completed; log sequence number 1595675
150208 0:19:42 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:42 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:42 InnoDB: The InnoDB memory heap is disabled
150208 0:19:42 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:42 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:42 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:42 InnoDB: Completed initialization of buffer pool
150208 0:19:42 InnoDB: highest supported file format is Barracuda.
150208 0:19:43 InnoDB: Waiting for the background threads to start
150208 0:19:44 InnoDB: 5.5.41 started; log sequence number 1595675
150208 0:19:44 InnoDB: Starting shutdown...
150208 0:19:44 InnoDB: Shutdown completed; log sequence number 1595675
150208 0:19:44 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:44 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:44 InnoDB: The InnoDB memory heap is disabled
150208 0:19:44 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:44 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:44 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:44 InnoDB: Completed initialization of buffer pool
150208 0:19:44 InnoDB: highest supported file format is Barracuda.
150208 0:19:44 InnoDB: Waiting for the background threads to start
150208 0:19:45 InnoDB: 5.5.41 started; log sequence number 1595675
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
150208 0:19:45 [ERROR] Aborting

150208 0:19:45 InnoDB: Starting shutdown...
150208 0:19:46 InnoDB: Shutdown completed; log sequence number 1595675
150208 0:19:46 [Note] /usr/sbin/mysqld: Shutdown complete

150208 0:19:46 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:46 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:46 InnoDB: The InnoDB memory heap is disabled
150208 0:19:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:46 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:46 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:46 InnoDB: Completed initialization of buffer pool
150208 0:19:46 InnoDB: highest supported file format is Barracuda.
150208 0:19:46 InnoDB: Waiting for the background threads to start
150208 0:19:47 InnoDB: 5.5.41 started; log sequence number 1595675
150208 0:19:47 InnoDB: Starting shutdown...
150208 0:19:48 InnoDB: Shutdown completed; log sequence number 1595675
150208 0:19:48 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:48 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:48 InnoDB: The InnoDB memory heap is disabled
150208 0:19:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:48 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:48 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:48 InnoDB: Completed initialization of buffer pool
150208 0:19:48 InnoDB: highest supported file format is Barracuda.
150208 0:19:48 InnoDB: Waiting for the background threads to start
150208 0:19:49 InnoDB: 5.5.41 started; log sequence number 1595675
ERROR: 1050 Table 'plugin' already exists
150208 0:19:49 [ERROR] Aborting

150208 0:19:49 InnoDB: Starting shutdown...
150208 0:19:50 InnoDB: Shutdown completed; log sequence number 1595675
150208 0:19:50 [Note] /usr/sbin/mysqld: Shutdown complete

150208 0:19:51 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150208 0:19:51 [Note] Plugin 'FEDERATED' is disabled.
150208 0:19:51 InnoDB: The InnoDB memory heap is disabled
150208 0:19:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150208 0:19:51 InnoDB: Compressed tables use zlib 1.2.3.4
150208 0:19:51 InnoDB: Initializing buffer pool, size = 128.0M
150208 0:19:51 InnoDB: Completed initialization of buffer pool
150208 0:19:51 InnoDB: highest supported file format is Barracuda.
150208 0:19:51 InnoDB: Waiting for the background threads to start
150208 0:19:52 InnoDB: 5.5.41 started; log sequence number 1595675
150208 0:19:52 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150208 0:19:52 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150208 0:19:52 [Note] Server socket created on IP: '127.0.0.1'.
150208 0:19:52 [Note] Event Scheduler: Loaded 0 events
150208 0:19:52 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150209 15:56:15 [Note] /usr/sbin/mysqld: Normal shutdown

150209 15:56:15 [Note] Event Scheduler: Purging the queue. 0 events
150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1411 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1410 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1409 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1408 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1407 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1406 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1405 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1404 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1403 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1402 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1401 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1400 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1399 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1398 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1395 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1394 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1393 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1392 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1391 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1390 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1388 user: 'root'

150209 15:56:17 [Warning] /usr/sbin/mysqld: Forcing close of thread 1387 user: 'root'

150209 15:56:17 InnoDB: Starting shutdown...
150209 15:56:19 InnoDB: Shutdown completed; log sequence number 5761973
150209 15:56:19 [Note] /usr/sbin/mysqld: Shutdown complete

150209 15:57:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150209 15:57:12 [Note] Plugin 'FEDERATED' is disabled.
150209 15:57:12 InnoDB: The InnoDB memory heap is disabled
150209 15:57:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150209 15:57:13 InnoDB: Compressed tables use zlib 1.2.3.4
150209 15:57:13 InnoDB: Initializing buffer pool, size = 128.0M
150209 15:57:13 InnoDB: Completed initialization of buffer pool
150209 15:57:14 InnoDB: highest supported file format is Barracuda.
150209 15:57:20 InnoDB: Waiting for the background threads to start
150209 15:57:21 InnoDB: 5.5.41 started; log sequence number 5761973
150209 15:57:21 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150209 15:57:21 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150209 15:57:21 [Note] Server socket created on IP: '127.0.0.1'.
150209 15:57:23 [Note] Event Scheduler: Loaded 0 events
150209 15:57:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150209 16:33:24 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150209 16:33:24 [Note] Plugin 'FEDERATED' is disabled.
150209 16:33:24 InnoDB: The InnoDB memory heap is disabled
150209 16:33:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150209 16:33:24 InnoDB: Compressed tables use zlib 1.2.3.4
150209 16:33:24 InnoDB: Initializing buffer pool, size = 128.0M
150209 16:33:24 InnoDB: Completed initialization of buffer pool
150209 16:33:24 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150209 16:33:24 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150209 16:33:26 InnoDB: Waiting for the background threads to start
150209 16:33:27 InnoDB: 5.5.41 started; log sequence number 5762905
150209 16:33:27 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150209 16:33:27 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150209 16:33:27 [Note] Server socket created on IP: '127.0.0.1'.
150209 16:33:27 [Note] Event Scheduler: Loaded 0 events
150209 16:33:27 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150209 20:23:25 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150209 20:23:25 [Note] Plugin 'FEDERATED' is disabled.
150209 20:23:25 InnoDB: The InnoDB memory heap is disabled
150209 20:23:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150209 20:23:25 InnoDB: Compressed tables use zlib 1.2.3.4
150209 20:23:25 InnoDB: Initializing buffer pool, size = 128.0M
150209 20:23:26 InnoDB: Completed initialization of buffer pool
150209 20:23:26 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150209 20:23:26 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150209 20:23:27 InnoDB: Waiting for the background threads to start
150209 20:23:28 InnoDB: 5.5.41 started; log sequence number 5762905
150209 20:23:28 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150209 20:23:28 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150209 20:23:28 [Note] Server socket created on IP: '127.0.0.1'.
150209 20:23:28 [Note] Event Scheduler: Loaded 0 events
150209 20:23:28 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150209 21:48:04 [Note] /usr/sbin/mysqld: Normal shutdown

150209 21:48:04 [Note] Event Scheduler: Purging the queue. 0 events
150209 21:48:05 InnoDB: Starting shutdown...
150209 21:48:06 InnoDB: Shutdown completed; log sequence number 5762905
150209 21:48:06 [Note] /usr/sbin/mysqld: Shutdown complete

150210 7:39:31 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150210 7:39:31 [Note] Plugin 'FEDERATED' is disabled.
150210 7:39:31 InnoDB: The InnoDB memory heap is disabled
150210 7:39:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150210 7:39:31 InnoDB: Compressed tables use zlib 1.2.3.4
150210 7:39:31 InnoDB: Initializing buffer pool, size = 128.0M
150210 7:39:31 InnoDB: Completed initialization of buffer pool
150210 7:39:31 InnoDB: highest supported file format is Barracuda.
150210 7:39:33 InnoDB: Waiting for the background threads to start
150210 7:39:34 InnoDB: 5.5.41 started; log sequence number 5762905
150210 7:39:34 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150210 7:39:34 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150210 7:39:34 [Note] Server socket created on IP: '127.0.0.1'.
150210 7:39:34 [Note] Event Scheduler: Loaded 0 events
150210 7:39:34 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150210 10:16:40 [Note] /usr/sbin/mysqld: Normal shutdown

150210 10:16:40 [Note] Event Scheduler: Purging the queue. 0 events
150210 10:16:41 InnoDB: Starting shutdown...
150210 10:16:42 InnoDB: Shutdown completed; log sequence number 5762905
150210 10:16:42 [Note] /usr/sbin/mysqld: Shutdown complete

150210 11:31:22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150210 11:31:22 [Note] Plugin 'FEDERATED' is disabled.
150210 11:31:22 InnoDB: The InnoDB memory heap is disabled
150210 11:31:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150210 11:31:22 InnoDB: Compressed tables use zlib 1.2.3.4
150210 11:31:22 InnoDB: Initializing buffer pool, size = 128.0M
150210 11:31:22 InnoDB: Completed initialization of buffer pool
150210 11:31:22 InnoDB: highest supported file format is Barracuda.
150210 11:31:24 InnoDB: Waiting for the background threads to start
150210 11:31:25 InnoDB: 5.5.41 started; log sequence number 5762905
150210 11:31:25 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150210 11:31:25 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150210 11:31:25 [Note] Server socket created on IP: '127.0.0.1'.
150210 11:31:25 [Note] Event Scheduler: Loaded 0 events
150210 11:31:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
150212 13:19:16 [Note] /usr/sbin/mysqld: Normal shutdown

150212 13:19:16 [Note] Event Scheduler: Purging the queue. 0 events
150212 13:19:17 InnoDB: Starting shutdown...
150212 13:19:18 InnoDB: Shutdown completed; log sequence number 5762905
150212 13:19:18 [Note] /usr/sbin/mysqld: Shutdown complete

150212 13:19:18 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
150212 13:19:18 [Note] Plugin 'FEDERATED' is disabled.
150212 13:19:18 InnoDB: The InnoDB memory heap is disabled
150212 13:19:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150212 13:19:18 InnoDB: Compressed tables use zlib 1.2.3.4
150212 13:19:18 InnoDB: Initializing buffer pool, size = 128.0M
150212 13:19:18 InnoDB: Completed initialization of buffer pool
150212 13:19:18 InnoDB: highest supported file format is Barracuda.
150212 13:19:19 InnoDB: Waiting for the background threads to start
150212 13:19:20 InnoDB: 5.5.41 started; log sequence number 5762905
150212 13:19:20 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
150212 13:19:20 [Note] - '127.0.0.1' resolves to '127.0.0.1';
150212 13:19:20 [Note] Server socket created on IP: '127.0.0.1'.
150212 13:19:20 [Note] Event Scheduler: Loaded 0 events
150212 13:19:20 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.41-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

fichier zabbix.conf.php

<?php

/* This file is used by the Zabbix PHP web frontend.
  • It is pre-filled with the information asked during
  • installation of the zabbix-server-* package.
  • /


global $DB;

$DB["TYPE"] = "mysql";
$DB["SERVER"] = "localhost";
$DB["PORT"] = "0";
$DB["DATABASE"] = "zabbix";
$DB["USER"] = "zabbix";
$DB["PASSWORD"] = "@dolphe1+";
$ZBX_SERVER = "127.0.0.1";
$ZBX_SERVER_PORT = "10051";

$IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG;


/* dbconfig-common uses the database types (e.g. "sqlite3")
  • in lowercase. But Zabbix expects these in uppercase.
  • /

## dont remove this!
## This is a work-around for dbconfig-common
if($DB["TYPE"] == "mysql")
$DB["TYPE"] = "MYSQL";

if($DB["TYPE"] == "pgsql")
$DB["TYPE"] = "POSTGRESQL";

if($DB["TYPE"] == "sqlite3")
$DB["TYPE"] = "SQLITE3";
##
?>

Merci de m'aider à trouver une solution..
A voir également:

1 réponse

jordane45 Messages postés 38292 Date d'inscription mercredi 22 octobre 2003 Statut Modérateur Dernière intervention 19 novembre 2024 4 704
12 févr. 2015 à 17:47
Bonjour,

Tu as paramétré ton fichier zabbix.conf.php avec des identifiants..... mais as tu créés cet utilisateur DANS ta base de données ??
(dans les USERS MYSQL)

0