#51 Le 26/11/2021, à 06:58
- nany
Re : Impossible d'installer MariaDB , postal smtp sur Ubuntu 20.4
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.
En 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.
En 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
En 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