Installation : Acces denied SQL à l'installation

RaspiSMS
1

Bonjour à tous,
J’essaye d’installer RaspiSMS depuis plusieurs jours, après avoir tenté dans un container docker je suis passé sur une machine virtuelle debian 10 sans UI toute fraîche.
Après avoir installé sudo et passé mon utilisateur en sudoer, je suis les instructions présentes sur RaspiSMS | Téléchargement.
À chaque fois je suis bloqué à l’initialisation de la bdd : voici ce que j’obtiens :

using config file ./phinx.yml
using config parser yaml
using migration paths
 - /usr/share/raspisms/db/migrations
using seed paths
warning no environment specified, defaulting to: prod
using adapter mysql
using database raspisms
ordering by creation time
PDOException: SQLSTATE[HY000] [1045] Access denied for user 'raspisms'@'localhost' (using password: YES) in /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:79
Stack trace:
#0 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(79): PDO->__construct('mysql:host=loca...', 'raspisms', '4DaLh8ArXgXEfpr...', Array)
#1 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(116): Phinx\Db\Adapter\PdoAdapter->createPdoConnection('mysql:host=loca...', 'raspisms', '4DaLh8ArXgXEfpr...', Array)
#2 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(148): Phinx\Db\Adapter\MysqlAdapter->connect()
#3 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(212): Phinx\Db\Adapter\PdoAdapter->getConnection()
#4 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(231): Phinx\Db\Adapter\PdoAdapter->query('SELECT * FROM `...')
#5 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(376): Phinx\Db\Adapter\PdoAdapter->fetchAll('SELECT * FROM `...')
#6 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(348): Phinx\Db\Adapter\PdoAdapter->getVersionLog()
#7 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(204): Phinx\Db\Adapter\PdoAdapter->getVersions()
#8 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(251): Phinx\Db\Adapter\AdapterWrapper->getVersions()
#9 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(303): Phinx\Migration\Manager\Environment->getVersions()
#10 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(120): Phinx\Migration\Manager->migrate('prod', NULL, false)
#11 /usr/share/raspisms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /usr/share/raspisms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /usr/share/raspisms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(Phinx\Console\Command\Migrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Compo
nent\Console\Output\ConsoleOutput))
#14 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(69): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\Cons
oleOutput))
#15 /usr/share/raspisms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /usr/share/raspisms/vendor/robmorgan/phinx/bin/phinx(27): Symfony\Component\Console\Application->run()
#17 /usr/share/raspisms/vendor/bin/phinx(115): include('/usr/share/rasp...')
#18 {main}

Next InvalidArgumentException: There was a problem connecting to the database: SQLSTATE[HY000] [1045] Access denied for user 'raspisms'@'localhost' (using password: YES) in /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Ad
apter/PdoAdapter.php:82
Stack trace:
#0 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(116): Phinx\Db\Adapter\PdoAdapter->createPdoConnection('mysql:host=loca...', 'raspisms', '4DaLh8ArXgXEfpr...', Array)
#1 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(148): Phinx\Db\Adapter\MysqlAdapter->connect()
#2 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(212): Phinx\Db\Adapter\PdoAdapter->getConnection()
#3 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(231): Phinx\Db\Adapter\PdoAdapter->query('SELECT * FROM `...')
#4 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(376): Phinx\Db\Adapter\PdoAdapter->fetchAll('SELECT * FROM `...')
#5 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(348): Phinx\Db\Adapter\PdoAdapter->getVersionLog()
#6 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(204): Phinx\Db\Adapter\PdoAdapter->getVersions()
#7 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(251): Phinx\Db\Adapter\AdapterWrapper->getVersions()
#8 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(303): Phinx\Migration\Manager\Environment->getVersions()
#9 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(120): Phinx\Migration\Manager->migrate('prod', NULL, false)
#10 /usr/share/raspisms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /usr/share/raspisms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /usr/share/raspisms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand(Object(Phinx\Console\Command\Migrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Compo
nent\Console\Output\ConsoleOutput))
#13 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(69): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\Cons
oleOutput))
#14 /usr/share/raspisms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /usr/share/raspisms/vendor/robmorgan/phinx/bin/phinx(27): Symfony\Component\Console\Application->run()
#16 /usr/share/raspisms/vendor/bin/phinx(115): inclure('/usr/share/rasp...')
#17 {main}

Je précise que je suis débutant. J’ai essayé plusieurs choses, notamment d’installer MariaDB avant RaspiSMS et de définir le user « raspisms » sans mot de passe et en lui donnant tous les privilèges mais cela ne suffit pas.
Quant à l’installation de RaspiSMS on me demande un user pour MySQL et donne « raspisms » et je laisse le champ mot de passe vide, comme j’ai créé « raspisms » avec la commande suivante :

CREATE USER 'raspisms'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON *.* TO 'raspisms'@'localhost';
FLUSH PRIVILEGES;

Quelque chose m’échappe et comme je suis à cours d’inspiration je me tourne enfin vers vous avec l’espoir d’avoir été assez précis dans mes explications pour que vous puissiez m’aider.
Merci beaucoup d’avance, j’essaierai d’être le plus complet et le plus rapide possible dans mes réponses pour vous rendre la tâche plus agréable.
Jean.

2

Ta réponse, il faut que l’utilisateur raspisms est un mot de passe, c’est totalement insécure sinon.

3

Merci pour ta réponse, malheureusement j’avais déjà essayé, et j’obtenais le même résultat.
Pour ma conscience je viens de réessayer mais sans succès.
J’ai aussi tenté d’installer RaspiSMS sans avoir installé MySQL avant mais j’ai encore le même résultat.

Do configuration of RaspiSMS app...
  Copy .dist files to .dist.local for edition
  Replace APP_ENV :
./env.php.dist.local converted
  Replace APP_SECRET :
./env.php.dist.local converted
 Replace APP_STATIC_HTTP_URL :
./env.prod.php.dist.local converted
  Replace APP_DATABASE_HOST :
./env.prod.php.dist.local converted
./phinx.yml.dist.local converted
  Replace APP_DATABASE_NAME :
./env.prod.php.dist.local converted
./phinx.yml.dist.local converted
  Replace APP_DATABASE_USER :
./env.prod.php.dist.local converted
./phinx.yml.dist.local converted
  Replace APP_DATABASE_PASS :
./env.prod.php.dist.local converted
./phinx.yml.dist.local converted
  Remove .dist.local extensions.
Done.


Do composer...
Updating to version 2.7.1 (stable channel).
   Downloading (100%)
Use composer self-update --rollback to return to version 1.9.3
Composer plugins have been disabled for safety in this non-interactive session. Set COMPOSER_ALLOW_SUPERUSER=1 if you want to allow plugins to run as root/super user.
Do not run Composer as root/super user! See https://getcomposer.org/root for details
Loading composer repositories with package information
Updating dependencies
Lock file operations: 62 installs, 0 updates, 0 removals
  - Locking ajani/flash-message (v2.1)
  - Locking cakephp/cache (3.10.5)
  - Locking cakephp/collection (3.10.5)
  - Locking cakephp/core (3.10.5)
  - Locking cakephp/database (3.10.5)
  - Locking cakephp/datasource (3.10.5)
  - Locking cakephp/log (3.10.5)
  - Locking cakephp/utility (3.10.5)
  - Locking fig/http-message-util (1.1.5)
  - Locking firebase/php-jwt (v6.4.0)
  - Locking giggsey/libphonenumber-for-php (8.13.30)
  - Locking giggsey/locale (2.5)
  - Locking google/auth (v1.26.0)
  - Locking google/cloud-core (v1.49.4)
  - Locking google/cloud-storage (v1.30.2)
  - Locking google/crc32 (v0.1.0)
  - Locking guzzlehttp/guzzle (6.5.8)
  - Locking guzzlehttp/promises (1.5.3)
  - Locking guzzlehttp/psr7 (1.9.1)
  - Locking ingenerator/tokenista (v1.3.0)
  - Locking kreait/clock (1.2)
  - Locking kreait/firebase-php (5.19.0)
  - Locking kreait/firebase-tokens (1.15.0)
  - Locking lcobucci/jwt (3.4.6)
  - Locking monolog/monolog (2.9.2)
  - Locking mtdowling/jmespath.php (2.7.0)
  - Locking ovh/ovh (v2.1.0)
  - Locking phpmailer/phpmailer (v6.9.1)
  - Locking psr/cache (1.0.1)
  - Locking psr/clock (1.0.0)
  - Locking psr/container (1.1.1)
  - Locking psr/http-message (1.1)
  - Locking psr/log (1.1.4)
  - Locking psr/simple-cache (1.0.1)
  - Locking ralouphie/getallheaders (3.0.3)
  - Locking ralouphie/mimey (2.1.0)
  - Locking riverline/multipart-parser (2.1.1)
  - Locking rize/uri-template (0.3.5)
  - Locking robmorgan/phinx (0.11.7)
  - Locking stella-maris/clock (0.1.7)
  - Locking symfony/cache (v5.4.35)
  - Locking symfony/cache-contracts (v2.5.2)
  - Locking symfony/config (v5.4.35)
  - Locking symfony/console (v5.4.35)
  - Locking symfony/deprecation-contracts (v2.5.2)
  - Locking symfony/expression-language (v5.4.35)
  - Locking symfony/filesystem (v5.4.35)
  - Locking symfony/polyfill-ctype (v1.29.0)
  - Locking symfony/polyfill-intl-grapheme (v1.29.0)
  - Locking symfony/polyfill-intl-idn (v1.29.0)
  - Locking symfony/polyfill-intl-normalizer (v1.29.0)
  - Locking symfony/polyfill-mbstring (v1.29.0)
  - Locking symfony/polyfill-php72 (v1.29.0)
  - Locking symfony/polyfill-php73 (v1.29.0)
  - Locking symfony/polyfill-php80 (v1.29.0)
  - Locking symfony/polyfill-php81 (v1.29.0)
  - Locking symfony/service-contracts (v2.5.2)
  - Locking symfony/string (v5.4.35)
  - Locking symfony/var-exporter (v5.4.35)
  - Locking symfony/yaml (v5.4.35)
  - Locking twig/twig (v3.8.0)
  - Locking twilio/sdk (6.44.4)
Writing lock file
Installing dependencies from lock file (including require-dev)
Package operations: 62 installs, 0 updates, 0 removals
  - Downloading ajani/flash-message (v2.1)
  - Downloading psr/simple-cache (1.0.1)
  - Downloading cakephp/core (3.10.5)
  - Downloading cakephp/utility (3.10.5)
  - Downloading cakephp/cache (3.10.5)
  - Downloading cakephp/datasource (3.10.5)
  - Downloading psr/log (1.1.4)
  - Downloading cakephp/log (3.10.5)
  - Downloading firebase/php-jwt (v6.4.0)
  - Downloading symfony/polyfill-mbstring (v1.29.0)
  - Downloading giggsey/locale (2.5)
  - Downloading giggsey/libphonenumber-for-php (8.13.30)
  - Downloading google/crc32 (v0.1.0)
  - Downloading ingenerator/tokenista (v1.3.0)
  - Downloading riverline/multipart-parser (2.1.1)
  - Downloading psr/http-message (1.1)
  - Downloading psr/cache (1.0.1)
  - Downloading mtdowling/jmespath.php (2.7.0)
  - Downloading lcobucci/jwt (3.4.6)
  - Downloading psr/clock (1.0.0)
  - Downloading stella-maris/clock (0.1.7)
  - Downloading kreait/clock (1.2)
  - Downloading symfony/polyfill-php72 (v1.29.0)
  - Downloading symfony/polyfill-intl-normalizer (v1.29.0)
  - Downloading symfony/polyfill-intl-idn (v1.29.0)
  - Downloading ralouphie/getallheaders (3.0.3)
  - Downloading guzzlehttp/psr7 (1.9.1)
  - Downloading guzzlehttp/promises (1.5.3)
  - Downloading guzzlehttp/guzzle (6.5.8)
  - Downloading fig/http-message-util (1.1.5)
  - Downloading kreait/firebase-tokens (1.15.0)
  - Downloading rize/uri-template (0.3.5)
  - Downloading monolog/monolog (2.9.2)
  - Downloading google/auth (v1.26.0)
  - Downloading google/cloud-core (v1.49.4)
  - Downloading google/cloud-storage (v1.30.2)
  - Downloading symfony/polyfill-ctype (v1.29.0)
  - Downloading kreait/firebase-php (5.19.0)
  - Downloading ovh/ovh (v2.1.0)
  - Downloading phpmailer/phpmailer (v6.9.1)
  - Downloading ralouphie/mimey (2.1.0)
  - Downloading symfony/deprecation-contracts (v2.5.2)
  - Downloading symfony/yaml (v5.4.35)
  - Downloading symfony/polyfill-php80 (v1.29.0)
  - Downloading symfony/polyfill-intl-grapheme (v1.29.0)
  - Downloading symfony/string (v5.4.35)
  - Downloading psr/container (1.1.1)
  - Downloading symfony/service-contracts (v2.5.2)
  - Downloading symfony/polyfill-php73 (v1.29.0)
  - Downloading symfony/console (v5.4.35)
  - Downloading symfony/polyfill-php81 (v1.29.0)
  - Downloading symfony/filesystem (v5.4.35)
  - Downloading symfony/config (v5.4.35)
  - Downloading cakephp/database (3.10.5)
  - Downloading cakephp/collection (3.10.5)
  - Downloading robmorgan/phinx (0.11.7)
  - Downloading symfony/cache-contracts (v2.5.2)
  - Downloading symfony/var-exporter (v5.4.35)
  - Downloading symfony/cache (v5.4.35)
  - Downloading symfony/expression-language (v5.4.35)
  - Downloading twig/twig (v3.8.0)
  - Downloading twilio/sdk (6.44.4)
  - Installing ajani/flash-message (v2.1): Extracting archive
  - Installing psr/simple-cache (1.0.1): Extracting archive
  - Installing cakephp/core (3.10.5): Extracting archive
  - Installing cakephp/utility (3.10.5): Extracting archive
  - Installing cakephp/cache (3.10.5): Extracting archive
  - Installing cakephp/datasource (3.10.5): Extracting archive
  - Installing psr/log (1.1.4): Extracting archive
  - Installing cakephp/log (3.10.5): Extracting archive
  - Installing firebase/php-jwt (v6.4.0): Extracting archive
  - Installing symfony/polyfill-mbstring (v1.29.0): Extracting archive
  - Installing giggsey/locale (2.5): Extracting archive
  - Installing giggsey/libphonenumber-for-php (8.13.30): Extracting archive
  - Installing google/crc32 (v0.1.0): Extracting archive
  - Installing ingenerator/tokenista (v1.3.0): Extracting archive
  - Installing riverline/multipart-parser (2.1.1): Extracting archive
  - Installing psr/http-message (1.1): Extracting archive
  - Installing psr/cache (1.0.1): Extracting archive
  - Installing mtdowling/jmespath.php (2.7.0): Extracting archive
  - Installing lcobucci/jwt (3.4.6): Extracting archive
  - Installing psr/clock (1.0.0): Extracting archive
  - Installing stella-maris/clock (0.1.7): Extracting archive
  - Installing kreait/clock (1.2): Extracting archive
  - Installing symfony/polyfill-php72 (v1.29.0): Extracting archive
  - Installing symfony/polyfill-intl-normalizer (v1.29.0): Extracting archive
  - Installing symfony/polyfill-intl-idn (v1.29.0): Extracting archive
  - Installing ralouphie/getallheaders (3.0.3): Extracting archive
  - Installing guzzlehttp/psr7 (1.9.1): Extracting archive
  - Installing guzzlehttp/promises (1.5.3): Extracting archive
  - Installing guzzlehttp/guzzle (6.5.8): Extracting archive
  - Installing fig/http-message-util (1.1.5): Extracting archive
  - Installing kreait/firebase-tokens (1.15.0): Extracting archive
  - Installing rize/uri-template (0.3.5): Extracting archive
  - Installing monolog/monolog (2.9.2): Extracting archive
  - Installing google/auth (v1.26.0): Extracting archive
  - Installing google/cloud-core (v1.49.4): Extracting archive
  - Installing google/cloud-storage (v1.30.2): Extracting archive
  - Installing symfony/polyfill-ctype (v1.29.0): Extracting archive
  - Installing kreait/firebase-php (5.19.0): Extracting archive
  - Installing ovh/ovh (v2.1.0): Extracting archive
  - Installing phpmailer/phpmailer (v6.9.1): Extracting archive
  - Installing ralouphie/mimey (2.1.0): Extracting archive
  - Installing symfony/deprecation-contracts (v2.5.2): Extracting archive
  - Installing symfony/yaml (v5.4.35): Extracting archive
  - Installing symfony/polyfill-php80 (v1.29.0): Extracting archive
  - Installing symfony/polyfill-intl-grapheme (v1.29.0): Extracting archive
  - Installing symfony/string (v5.4.35): Extracting archive
  - Installing psr/container (1.1.1): Extracting archive
  - Installing symfony/service-contracts (v2.5.2): Extracting archive
  - Installing symfony/polyfill-php73 (v1.29.0): Extracting archive
  - Installing symfony/console (v5.4.35): Extracting archive
  - Installing symfony/polyfill-php81 (v1.29.0): Extracting archive
  - Installing symfony/filesystem (v5.4.35): Extracting archive
  - Installing symfony/config (v5.4.35): Extracting archive
  - Installing cakephp/database (3.10.5): Extracting archive
  - Installing cakephp/collection (3.10.5): Extracting archive
  - Installing robmorgan/phinx (0.11.7): Extracting archive
  - Installing symfony/cache-contracts (v2.5.2): Extracting archive
  - Installing symfony/var-exporter (v5.4.35): Extracting archive
  - Installing symfony/cache (v5.4.35): Extracting archive
  - Installing symfony/expression-language (v5.4.35): Extracting archive
  - Installing twig/twig (v3.8.0): Extracting archive
  - Installing twilio/sdk (6.44.4): Extracting archive
34 package suggestions were added by new dependencies, use `composer suggest` to see details.
Generating autoload files
30 packages you are using are looking for funding.
Use the `composer fund` command to find out more!
No security vulnerability advisories found.

Done.


Do Phinx migrations...
Phinx by CakePHP - https://phinx.org.

using config file ./phinx.yml
using config parser yaml
using migration paths
 - /usr/share/raspisms/db/migrations
using seed paths
warning no environment specified, defaulting to: prod
using adapter mysql
using database raspisms
ordering by creation time
PDOException: SQLSTATE[HY000] [1698] Access denied for user 'raspisms'@'localhost' in /usr/share/raspisms/vendor/robmorg
an/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:79
Stack trace:
#0 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(79): PDO->__construct('mysql:host=loca
...', 'raspisms', 'qGNLebwuPI5LZbC...', Array)
#1 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(116): Phinx\Db\Adapter\PdoAdapter->createPdoConnection('mysql:host=loca...', 'raspisms', 'qGNLebwuPI5LZbC...', Array)
#2 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(148): Phinx\Db\Adapter\MysqlAdapter->c
onnect()
#3 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(212): Phinx\Db\Adapter\PdoAdapter->get
Connection()
#4 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(231): Phinx\Db\Adapter\PdoAdapter->que
ry('SELECT * FROM `...')
#5 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(376): Phinx\Db\Adapter\PdoAdapter->fet
chAll('SELECT * FROM `...')
#6 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(348): Phinx\Db\Adapter\PdoAdapter->get
VersionLog()
#7 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(204): Phinx\Db\Adapter\PdoAdapter-
>getVersions()
#8 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(251): Phinx\Db\Adapter\Adapter
Wrapper->getVersions()
#9 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(303): Phinx\Migration\Manager\Environment-
>getVersions()
#10 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(120): Phinx\Migration\Manager->migr
ate('prod', NULL, false)
#11 /usr/share/raspisms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute(Object(S
ymfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /usr/share/raspisms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Obj
ect(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 /usr/share/raspisms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand
(Object(Phinx\Console\Command\Migrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Cons
ole\Output\ConsoleOutput))
#14 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(69): Symfony\Component\Console\App
lication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput
))
#15 /usr/share/raspisms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun(Object(Symfon
y\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 /usr/share/raspisms/vendor/robmorgan/phinx/bin/phinx(27): Symfony\Component\Console\Application->run()
#17 /usr/share/raspisms/vendor/bin/phinx(115): include('/usr/share/rasp...')
#18 {main}

Next InvalidArgumentException: There was a problem connecting to the database: SQLSTATE[HY000] [1698] Access denied for
user 'raspisms'@'localhost' in /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php:82
Stack trace:
#0 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php(116): Phinx\Db\Adapter\PdoAdapter->c
reatePdoConnection('mysql:host=loca...', 'raspisms', 'qGNLebwuPI5LZbC...', Array)
#1 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(148): Phinx\Db\Adapter\MysqlAdapter->c
onnect()
#2 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(212): Phinx\Db\Adapter\PdoAdapter->get
Connection()
#3 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(231): Phinx\Db\Adapter\PdoAdapter->que
ry('SELECT * FROM `...')
#4 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(376): Phinx\Db\Adapter\PdoAdapter->fet
chAll('SELECT * FROM `...')
#5 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php(348): Phinx\Db\Adapter\PdoAdapter->get
VersionLog()
#6 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/AdapterWrapper.php(204): Phinx\Db\Adapter\PdoAdapter-
>getVersions()
#7 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager/Environment.php(251): Phinx\Db\Adapter\Adapter
Wrapper->getVersions()
#8 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Migration/Manager.php(303): Phinx\Migration\Manager\Environment-
>getVersions()
#9 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/Command/Migrate.php(120): Phinx\Migration\Manager->migra
te('prod', NULL, false)
#10 /usr/share/raspisms/vendor/symfony/console/Command/Command.php(298): Phinx\Console\Command\Migrate->execute(Object(S
ymfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /usr/share/raspisms/vendor/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run(Obj
ect(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /usr/share/raspisms/vendor/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand
(Object(Phinx\Console\Command\Migrate), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Cons
ole\Output\ConsoleOutput))
#13 /usr/share/raspisms/vendor/robmorgan/phinx/src/Phinx/Console/PhinxApplication.php(69): Symfony\Component\Console\App
lication->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput
))
#14 /usr/share/raspisms/vendor/symfony/console/Application.php(171): Phinx\Console\PhinxApplication->doRun(Object(Symfon
y\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 /usr/share/raspisms/vendor/robmorgan/phinx/bin/phinx(27): Symfony\Component\Console\Application->run()
#16 /usr/share/raspisms/vendor/bin/phinx(115): include('/usr/share/rasp...')
#17 {main}

Done.

Traitement des actions différées (« triggers ») pour systemd (241-7~deb10u10) ...
Traitement des actions différées (« triggers ») pour man-db (2.8.5-2+deb10u1) ...
Traitement des actions différées (« triggers ») pour libc-bin (2.28-10+deb10u2) ...
raspisms@RaspiSMS:~$

Voici mon log complet au cas ou, mais franchement je n’arrive pas à saisir ce que je dois changer pour que ça marche.
Jean

4

As tu vérifier si le serveur SQL est démarré ?
Que les libs PDO et SQL (pour PHP, entre-autres) sont bien la et installé ?
Sur quel version de PHP es-tu ?

5

Merci encore pour ta réponse,
Les lib PHP sont bien installées et je suis sur PHP 7.4.
A force d’y réfléchir, je suis a peu près persuadé que le problème est dans la configuration de MySQL : je ne sais pas comment expliquer ça mais on dirait que je n’arrive pas à créer de user et a lui donner les droits.

6

SI tu veux t’aider avec la gestion de SQL, je t’invite à installer Webmin.

C’est un gestionnaire de système complet en interface Web, chaque machine que je monte sous Linux à cette version (Webmin) ou la version pour gestion web (Virtualmin).

De la, tu auras une interface plus simple pour contrôler SQL, mais je te suggère fortement de commencer à zéro pour être sur de commencer sur des bases saines.