Contenu | Rechercher | Menus

Annonce

Si vous avez des soucis pour rester connecté, déconnectez-vous puis reconnectez-vous depuis ce lien en cochant la case
Me connecter automatiquement lors de mes prochaines visites.

À propos de l'équipe du forum.

#51 Le 26/11/2021, à 06:58

nany

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Antenaina Flavio Steven R a écrit :

vous pouvez le voir ici

Pourquoi suivre l’ancien guide d’installation qui semble être fait pour 18.04 ?

Personnellement je suivrais le nouveau guide où seules les installations de docker et docker-compose sont requises.

Hors ligne

#52 Le 26/11/2021, à 07:53

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

ah oui j'ai remarqué que je vous ai pas envoye le nouveau guide

je vous ferais des que j"ai fini l'installation

Dernière modification par Antenaina Flavio Steven R (Le 26/11/2021, à 07:55)

Hors ligne

#53 Le 26/11/2021, à 08:12

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

find /etc/apt -type f -name '*.list*' -exec bash -c 'echo -e "\n\t$1\n"; [[ $1 = *".list" ]] && cat -n "$1"' _ '{}' \;

 1  # deb http://asi-fs-n.contabo.net/ubuntu focal main restricted
     2
     3  # deb http://asi-fs-m.contabo.net/ubuntu focal-updates main restricted
     4  # deb http://security.ubuntu.com/ubuntu focal-security main restricted
     5
     6  # See http://help.ubuntu.com/community/UpgradeNotes for how to upgrade to
     7  # newer versions of the distribution.
     8  deb http://asi-fs-n.contabo.net/ubuntu focal main restricted
     9  # deb-src http://asi-fs-m.contabo.net/ubuntu focal main restricted
    10
    11  ## Major bug fix updates produced after the final release of the
    12  ## distribution.
    13  deb http://asi-fs-n.contabo.net/ubuntu focal-updates main restricted
    14  # deb-src http://asi-fs-m.contabo.net/ubuntu focal-updates main restricted
    15
    16  ## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
    17  ## team. Also, please note that software in universe WILL NOT receive any
    18  ## review or updates from the Ubuntu security team.
    19  deb http://asi-fs-n.contabo.net/ubuntu focal universe
    20  # deb-src http://asi-fs-m.contabo.net/ubuntu focal universe
    21  deb http://asi-fs-n.contabo.net/ubuntu focal-updates universe
    22  # deb-src http://asi-fs-m.contabo.net/ubuntu focal-updates universe
    23
    24  ## N.B. software from this repository is ENTIRELY UNSUPPORTED by the Ubuntu
    25  ## team, and may not be under a free licence. Please satisfy yourself as to
    26  ## your rights to use the software. Also, please note that software in
    27  ## multiverse WILL NOT receive any review or updates from the Ubuntu
    28  ## security team.
    29  deb http://asi-fs-n.contabo.net/ubuntu focal multiverse
    30  # deb-src http://asi-fs-m.contabo.net/ubuntu focal multiverse
    31  deb http://asi-fs-n.contabo.net/ubuntu focal-updates multiverse
    32  # deb-src http://asi-fs-m.contabo.net/ubuntu focal-updates multiverse
    33
    34  ## N.B. software from this repository may not have been tested as
    35  ## extensively as that contained in the main release, although it includes
    36  ## newer versions of some applications which may provide useful features.
    37  ## Also, please note that software in backports WILL NOT receive any review
    38  ## or updates from the Ubuntu security team.
    39  deb http://asi-fs-n.contabo.net/ubuntu focal-backports main restricted universe multiverse
    40  # deb-src http://asi-fs-m.contabo.net/ubuntu focal-backports main restricted universe multiverse
    41
    42  ## Uncomment the following two lines to add software from Canonical's
    43  ## 'partner' repository.
    44  ## This software is not part of Ubuntu, but is offered by Canonical and the
    45  ## respective vendors as a service to Ubuntu users.
    46  # deb http://archive.canonical.com/ubuntu focal partner
    47  # deb-src http://archive.canonical.com/ubuntu focal partner
    48
    49  deb http://security.ubuntu.com/ubuntu focal-security main restricted
    50  # deb-src http://security.ubuntu.com/ubuntu focal-security main restricted
    51  deb http://security.ubuntu.com/ubuntu focal-security universe
    52  # deb-src http://security.ubuntu.com/ubuntu focal-security universe
    53  deb http://security.ubuntu.com/ubuntu focal-security multiverse
    54  # deb-src http://security.ubuntu.com/ubuntu focal-security multiverse

        /etc/apt/sources.liste


        /etc/apt/sources.list.d/virtualmin.list

     1  deb http://software.virtualmin.com/vm/6/gpl/apt virtualmin-focal main
     2  deb http://software.virtualmin.com/vm/6/gpl/apt virtualmin-universal main

        /etc/apt/sources.list.d/webmin.list

     1  deb http://download.webmin.com/download/repository sarge contrib

Hors ligne

#54 Le 26/11/2021, à 09:43

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Tout se passe passe bien jusqu'a ce que je passe à la creation de   "postal user  "  ca fait une erreur comme au dessus

root@mail:~# postal make-user
Creating postal_runner_run ... done
Postal User Creator
Enter the information required to create a new Postal user.
This tool is usually only used to create your initial admin user.

/usr/local/bundle/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `connect': Access denied for user 'root'@'172.17.0.1' (using password: YES) (Mysql2::Error::ConnectionError)
        from /usr/local/bundle/gems/mysql2-0.5.3/lib/mysql2/client.rb:90:in `initialize'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `new'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/mysql2_adapter.rb:22:in `mysql2_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:830:in `new_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:874:in `checkout_new_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:853:in `try_to_checkout_new_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:814:in `acquire_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:538:in `checkout'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:382:in `connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_adapters/abstract/connection_pool.rb:1033:in `retrieve_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_handling.rb:118:in `retrieve_connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/connection_handling.rb:90:in `connection'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/model_schema.rb:466:in `load_schema!'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/attributes.rb:234:in `load_schema!'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/attribute_decorators.rb:51:in `load_schema!'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/model_schema.rb:459:in `block in load_schema'
        from /usr/local/lib/ruby/2.6.0/monitor.rb:235:in `mon_synchronize'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/model_schema.rb:456:in `load_schema'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/model_schema.rb:346:in `attribute_types'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/attribute_methods.rb:230:in `has_attribute?'
        from /usr/local/bundle/gems/activerecord-5.2.6/lib/active_record/inheritance.rb:55:in `new'
        from /opt/postal/app/lib/postal/user_creator.rb:12:in `start'
        from script/make_user.rb:7:in `<main>'
ERROR: 1

Hors ligne

#55 Le 26/11/2021, à 10:14

nany

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Redonne le retour de :

cat /opt/postal/config/postal.yml

En remplaçant les mots de passe par des xxxx.

Hors ligne

#56 Le 26/11/2021, à 10:18

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

general:
  # This can be changed to allow messages to be sent from multiple IP addresses
  use_ip_pools: false

web:
  # The host that the management interface will be available on
  host: mail.piikla.com
  # The protocol that requests to the management interface should happen on
  protocol: https

web_server:
  # Specify configuration for the Postal web server
  bind_address: 45.88.191.215
  port: 5000

smtp_server:
  # Specify configuration to the Postal SMTP server
  port: 25

logging:
  # Specify options for the logging
  stdout: true

main_db:
  # Specify the connection details for your MySQL database
  host: 127.0.0.1
  username: root
  password: xxxx
  database: postal

message_db:
  # Specify the connection details for your MySQL server that will be house the
  # message databases for mail servers.
  host: 127.0.0.1
  username: root
  password: xxxx
  prefix: postal

rabbitmq:
  # Specify connection details for your RabbitMQ server
  host: 127.0.0.1
  username: postal
  password: xxxx
  vhost: postal

dns:
  # Specify the DNS records that you have configured. Refer to the documentation at
  # https://github.com/atech/postal/wiki/Domains-&-DNS-Configuration for further
  # information about these.
  mx_records:
    - mx.postal.example.com
  smtp_server_hostname: postal.example.com
  spf_include: spf.postal.example.com
  return_path: rp.postal.example.com
  route_domain: routes.postal.example.com
  track_domain: track.postal.example.com

smtp:
  # Specify an SMTP server that can be used to send messages from the Postal management
  # system to users. You can configure this to use a Postal mail server once the
  # your installation has been set up.
  host: 127.0.0.1
  port: 2525
  username: # Complete when Postal is running and you can
  password: # generate the credentials within the interface.
  from_name: Postal
  from_address: mail.piikla.com

rails:
  # This is generated automatically by the config initialization. It should be a random
  # string unique to your installation.
  secret_key: 7492ca636bf827c4817e9622c8e0a5877879e5cf662b29728f43701f6419a8e3163dc6153db2ba94d4c5713242c569ddef77423b59ddff9484394700cf41382e181e4cd718ca2a814327fc5384c5975597d4c835bcae3f9e27808b975e163af3cad891ea2b88223becaf4fd98117caa584a969b930fbf575a594f929a6ee6928

Hors ligne

#57 Le 26/11/2021, à 11:24

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Je vous ai envoyé le retour

Hors ligne

#58 Le 26/11/2021, à 11:25

bruno

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

`connect': Access denied for user 'root'@'172.17.0.1'

Mea culpa, maraidb tourne dans un conteneur docker. 172.17.0.1 est donc certainement l'adresse IP de ce conteneur.
Il faut voir si la connexion fonctionne en ligne de commande :

mysql -h 172.17.0.1 -u root -p

et saisir le mot de passe défini à la création du conteneur docker.

#59 Le 26/11/2021, à 11:33

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Bonjour , et comme suis-je censé savoir le mot de passe de ce dernier s'il vous plait ?

Hors ligne

#60 Le 26/11/2021, à 11:55

bruno

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

C'est toi qui a défini ce mot de passe !
Bon, désolé mais j'abandonne…
Surtout que visiblement c'est pour monter un serveur de spam mailing commercial qui ne manquera pas d'être rapidement inscrit sur toutes les listes noires.

Dernière modification par bruno (Le 26/11/2021, à 12:23)

#61 Le 26/11/2021, à 11:59

nany

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

Si tu as passé la commande suivante telle quelle, eh bien le mot de passe est postalpassword.

docker run -d \
   --name postal-mariadb \
   -p 127.0.0.1:3306:3306 \
   --restart always \
   -e MARIADB_DATABASE=postal \
   -e MARIADB_ROOT_PASSWORD=postalpassword \
   mariadb

Hors ligne

#62 Le 26/11/2021, à 12:28

Antenaina Flavio Steven R

Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4

D'accord , merci beaucoup  pour votre aide !

Hors ligne