Problème avec le wifi


#1

Bonjour j’ai voulu installer le wifi sur mon raspberry pi3 B+ et j’ai une erreur qui est apparue,gladys ne fonctionne voici logs

    0|gladys   | Unhandled rejection Error: Could not connect to MySQL:
    0|gladys   | Error: connect ECONNREFUSED 127.0.0.1:3306
    0|gladys   |     at afterwards (/home/pi/gladys/node_modules/sails-mysql/lib/connections/spawn.js:72:13)
    0|gladys   |     at /home/pi/gladys/node_modules/sails-mysql/lib/connections/spawn.js:40:7
    0|gladys   |     at Handshake.onConnect [as _callback] (/home/pi/gladys/node_modules/mysql/lib/Pool.js:54:9)
    0|gladys   |     at Handshake.Sequence.end (/home/pi/gladys/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)
    0|gladys   |     at Protocol.handleNetworkError (/home/pi/gladys/node_modules/mysql/lib/protocol/Protocol.js:364:14)
    0|gladys   |     at PoolConnection.Connection._handleNetworkError (/home/pi/gladys/node_modules/mysql/lib/Connection.js:421:18)
    0|gladys   |     at emitOne (events.js:116:13)
    0|gladys   |     at Socket.emit (events.js:211:7)
    0|gladys   |     at emitErrorNT (internal/streams/destroy.js:64:8)
    0|gladys   |     at _combinedTickCallback (internal/process/next_tick.js:138:11)
    0|gladys   |     at process._tickDomainCallback (internal/process/next_tick.js:218:9)
    0|gladys   | Unhandled rejection Error: Could not connect to MySQL:
    0|gladys   | Error: connect ECONNREFUSED 127.0.0.1:3306
    0|gladys   |     at afterwards (/home/pi/gladys/node_modules/sails-mysql/lib/connections/spawn.js:72:13)
    0|gladys   |     at /home/pi/gladys/node_modules/sails-mysql/lib/connections/spawn.js:40:7
    0|gladys   |     at Handshake.onConnect [as _callback] (/home/pi/gladys/node_modules/mysql/lib/Pool.js:54:9)
    0|gladys   |     at Handshake.Sequence.end (/home/pi/gladys/node_modules/mysql/lib/protocol/sequences/Sequence.js:96:24)
    0|gladys   |     at Protocol.handleNetworkError (/home/pi/gladys/node_modules/mysql/lib/protocol/Protocol.js:364:14)
    0|gladys   |     at PoolConnection.Connection._handleNetworkError (/home/pi/gladys/node_modules/mysql/lib/Connection.js:421:18)
    0|gladys   |     at emitOne (events.js:116:13)
    0|gladys   |     at Socket.emit (events.js:211:7)
    0|gladys   |     at emitErrorNT (internal/streams/destroy.js:64:8)
    0|gladys   |     at _combinedTickCallback (internal/process/next_tick.js:138:11)
    0|gladys   |     at process._tickDomainCallback (internal/process/next_tick.js:218:9)
```l

#2

Bonjour,

Gladys ne peut se connecter sur le port 3306 qui correspond à Mysql.

Peux-tu dans un premier temps vérifier que le service MySQL est bien opérationnel ?

sudo service mysql status

ou

ps aux | grep mysql


#3

Bonjour @Vins merci pour t’on aide
voici le logs de sudo service mysql statuts:

mariadb.service - MariaDB 10.1.37 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: activating (auto-restart) (Result: signal) since Wed 2018-12-12 17:23:05 CET; 2s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 24905 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
  Process: 24828 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VA
  Process: 24824 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 24821 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 24905 (code=killed, signal=ABRT)
   Status: "InnoDB: Fatal: Ending processing because of a corrupt database page."

Dec 12 17:23:05 gladys systemd[1]: Failed to start MariaDB 10.1.37 database server.
Dec 12 17:23:05 gladys systemd[1]: mariadb.service: Unit entered failed state.
Dec 12 17:23:05 gladys systemd[1]: mariadb.service: Failed with result 'signal'.

et pour ps aux | grep mysql:

root     24920  0.0  0.3   5584  3016 pts/0    T    17:23   0:00 sudo service mysql status
root     24924  0.0  0.4   6908  3992 pts/0    T    17:23   0:00 systemctl status mysql.service
pi       25995  0.0  0.0   2700   544 pts/0    S+   17:24   0:00 grep --color=auto mysql

#4

Voilà , ne connaissant pas ton niveau voici le 1er lien que Goole me donne avec cette erreur:

http://blackbird.si/mysql-corrupted-innodb-tables-recovery-step-by-step-guide/


#5

Mon niveau est très ba voir nul XD
Mais merc, je vais regarder sa demain
Bonne soirée et encore merci :wink:


#6

Bon j’ai fini par remettre gladys a 0
Merci quand même @Vins


#7

De rien :slight_smile: