Bonjour,
J’ai un problème récurrent avec Dolibarr…Dolibarr est installé sur une machine bitnami…à chaque fois que je redémarre la machine, j’obtiens le message ci-dessous…parfois le problème disparaît tout seul après plusieurs redémarrages…j’en ai assez de ce problème…s’il vous plait Est-ce que quelqu’un peut m’aider?
Date: 20220425173359
Dolibarr: 14.0.3 - .dolibarr.org
PHP: 7.4.24
Server: Apache/2.4.51 (Unix) OpenSSL/1.1.1n
OS: Linux debian 4.19.0-18-amd64 #1 SMP Debian 4.19.208-1 (2021-09-29) x86_64
UserAgent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Firefox/91.0
RequestedUrl: /
Referer:
MenuManager:
DatabaseTypeManager: mysqli
RequestLastAccessInError: ErrorNoRequestInError
ReturnCodeLastAccessInError: ErrorNoRequestInError
InformationLastAccessInError: ErrorNoRequestInError
Message: host=127.0.0.1, port=3306, user=bn_dolibarr, databasename=bitnami_dolibarr, Connection refused
Bonjour
Regardez du côté des logs mysql s’il y a pourquoi la connexion est refusée.
Il y a quoi d’autre sur la machine ?
Des sécurité type fail2ban ?..
Si vous ne faites rien, ça passe au bout d’un moment ?
@+
Merci de revenir vers moi. J’ai trouvé le journal avec cette commande:
tail -n 100 /opt/bitnami/mariadb/logs/mysqld.log
Rien d’autre n’est installé sur le serveur… Voici la sortie du journal :
"
2022-04-25 13:53:47 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 13:53:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 220425 13:53:47
2022-04-25 13:53:48 0 [Note] InnoDB: Removed temporary tablespace data file: « ibtmp1 »
2022-04-25 13:53:48 0 [Note] InnoDB: Shutdown completed; log sequence number 20739905; transaction id 15475
2022-04-25 13:53:48 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete
2022-04-25 13:56:08 0 [Note] InnoDB: Using Linux native AIO
2022-04-25 13:56:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-25 13:56:08 0 [Note] InnoDB: Uses event mutexes
2022-04-25 13:56:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-25 13:56:08 0 [Note] InnoDB: Number of pools: 1
2022-04-25 13:56:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-25 13:56:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-04-25 13:56:08 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-25 13:56:08 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-25 13:56:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-04-25 13:56:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-25 13:56:08 0 [Note] InnoDB: Setting file ‹ ./ibtmp1 › size to 12 MB. Physically writing the file full; Please wait …
2022-04-25 13:56:08 0 [Note] InnoDB: File ‹ ./ibtmp1 › size is now 12 MB.
2022-04-25 13:56:08 0 [Note] InnoDB: Waiting for purge to start
2022-04-25 13:56:08 0 [Note] InnoDB: 10.3.31 started; log sequence number 20739905; transaction id 15476
2022-04-25 13:56:08 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 13:56:08 0 [Note] Plugin ‹ FEEDBACK › is disabled.
2022-04-25 13:56:08 0 [Note] Server socket created on IP: ‹ 127.0.0.1 ›.
2022-04-25 13:56:08 0 [Warning] ‹ proxies_priv › entry ‹ @% root@debian › ignored in --skip-name-resolve mode.
2022-04-25 13:56:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220425 13:56:08
2022-04-25 13:56:08 0 [Note] Reading of all Master_info entries succeeded
2022-04-25 13:56:08 0 [Note] Added new Master_info ‹ › to hash table
2022-04-25 13:56:08 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: ‹ 10.3.31-MariaDB › socket: ‹ /opt/bitnami/mariadb/tmp/mysql.sock › port: 3306 Source distribution
2022-04-25 14:00:29 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-04-25 14:00:29 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-25 14:00:29 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-04-25 14:00:29 0 [Note] InnoDB: Starting shutdown…
2022-04-25 14:00:29 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 14:00:29 0 [Note] InnoDB: Instance 0, restricted to 255 pages due to innodb_buf_pool_dump_pct=25
2022-04-25 14:00:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 220425 14:00:29
2022-04-25 14:00:31 0 [Note] InnoDB: Removed temporary tablespace data file: « ibtmp1 »
2022-04-25 14:00:31 0 [Note] InnoDB: Shutdown completed; log sequence number 20739914; transaction id 15477
2022-04-25 14:00:31 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete
2022-04-25 14:01:08 0 [Note] InnoDB: Using Linux native AIO
2022-04-25 14:01:08 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-25 14:01:08 0 [Note] InnoDB: Uses event mutexes
2022-04-25 14:01:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-25 14:01:08 0 [Note] InnoDB: Number of pools: 1
2022-04-25 14:01:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-25 14:01:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-04-25 14:01:08 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-25 14:01:08 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-25 14:01:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-04-25 14:01:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-25 14:01:08 0 [Note] InnoDB: Setting file ‹ ./ibtmp1 › size to 12 MB. Physically writing the file full; Please wait …
2022-04-25 14:01:08 0 [Note] InnoDB: File ‹ ./ibtmp1 › size is now 12 MB.
2022-04-25 14:01:08 0 [Note] InnoDB: Waiting for purge to start
2022-04-25 14:01:08 0 [Note] InnoDB: 10.3.31 started; log sequence number 20739914; transaction id 15476
2022-04-25 14:01:08 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 14:01:08 0 [Note] Plugin ‹ FEEDBACK › is disabled.
2022-04-25 14:01:08 0 [Note] Server socket created on IP: ‹ 127.0.0.1 ›.
2022-04-25 14:01:08 0 [Note] InnoDB: Buffer pool(s) load completed at 220425 14:01:08
2022-04-25 14:01:08 0 [Warning] ‹ proxies_priv › entry ‹ @% root@debian › ignored in --skip-name-resolve mode.
2022-04-25 14:01:08 0 [Note] Reading of all Master_info entries succeeded
2022-04-25 14:01:08 0 [Note] Added new Master_info ‹ › to hash table
2022-04-25 14:01:08 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: ‹ 10.3.31-MariaDB › socket: ‹ /opt/bitnami/mariadb/tmp/mysql.sock › port: 3306 Source distribution
2022-04-25 15:13:20 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (initiated by: unknown): Normal shutdown
2022-04-25 15:13:20 0 [Note] InnoDB: FTS optimize thread exiting.
2022-04-25 15:13:20 0 [Note] Event Scheduler: Purging the queue. 0 events
2022-04-25 15:13:20 0 [Note] InnoDB: Starting shutdown…
2022-04-25 15:13:20 0 [Note] InnoDB: Dumping buffer pool(s) to /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 15:13:20 0 [Note] InnoDB: Instance 0, restricted to 255 pages due to innodb_buf_pool_dump_pct=25
2022-04-25 15:13:20 0 [Note] InnoDB: Buffer pool(s) dump completed at 220425 15:13:20
2022-04-25 15:13:21 0 [Note] InnoDB: Removed temporary tablespace data file: « ibtmp1 »
2022-04-25 15:13:21 0 [Note] InnoDB: Shutdown completed; log sequence number 20739923; transaction id 15479
2022-04-25 15:13:21 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: Shutdown complete
2022-04-25 15:13:59 0 [Note] InnoDB: Using Linux native AIO
2022-04-25 15:13:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-04-25 15:13:59 0 [Note] InnoDB: Uses event mutexes
2022-04-25 15:13:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-25 15:13:59 0 [Note] InnoDB: Number of pools: 1
2022-04-25 15:13:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-25 15:13:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-04-25 15:13:59 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-25 15:13:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-04-25 15:13:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-04-25 15:13:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-25 15:13:59 0 [Note] InnoDB: Setting file ‹ ./ibtmp1 › size to 12 MB. Physically writing the file full; Please wait …
2022-04-25 15:13:59 0 [Note] InnoDB: File ‹ ./ibtmp1 › size is now 12 MB.
2022-04-25 15:13:59 0 [Note] InnoDB: Waiting for purge to start
2022-04-25 15:13:59 0 [Note] InnoDB: 10.3.31 started; log sequence number 20739923; transaction id 15476
2022-04-25 15:13:59 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-04-25 15:13:59 0 [Note] Plugin ‹ FEEDBACK › is disabled.
2022-04-25 15:13:59 0 [Note] Server socket created on IP: ‹ 127.0.0.1 ›.
2022-04-25 15:13:59 0 [Note] InnoDB: Buffer pool(s) load completed at 220425 15:13:59
2022-04-25 15:14:00 0 [Warning] ‹ proxies_priv › entry ‹ @% root@debian › ignored in --skip-name-resolve mode.
2022-04-25 15:14:00 0 [Note] Reading of all Master_info entries succeeded
2022-04-25 15:14:00 0 [Note] Added new Master_info ‹ › to hash table
2022-04-25 15:14:00 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: ‹ 10.3.31-MariaDB › socket: ‹ /opt/bitnami/mariadb/tmp/mysql.sock › port: 3306 Source distribution
"
Merci d’avance.
Boulbul
Beaucoup de « shutdown » dans ce log. C’est à quel moment ?
Pourquoi utilisez vous bitnami ?
@+
1 « J'aime »
