Hello,
I'm following this article: https://archive.h-educate.com/smtp-server-configuration/
I'm at the SMTP Server Installation step (Step 1: Create Database). When I enter the command:
sudo mysql -u root -p
it asks for a password. I entered my VPS server password and Maria DB comes up. Then, I cannot enter the commands that follow in your guide because the prompt to enter a command does not come up.
All the steps leading up to this step seemed to work with no issues.
Could you help me understand what I am doing wrong.
Thank you so much!
Albert
This is correct, if Maria DB opens, then you should add the commands inside it. Are there any screenshots? Did you try to add any command and got an error?
Hello Abdallah,
I cannot attach a screenshot because I am not allowed. I did enter commands in Maria DB and did get an error message:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Maria DB server version for the right syntax to user near 'DATABASE postal CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci' at line 1
Looking back at my steps, this came up after I typed in this command:
utf8mb4_unicode_ci;
The first command (sudo mysql -u root -p) prompted to "Enter password:".
After I typed my VPS server password, I entered the (utf8mb4_unicode_ci;) command.
Please advise.
Thank you for your time.
Albert
Hello Sir,
I am trying to install postal on ubuntu 18.04 getitng below error. any suggestions on this please.
i am using steps mentioned in below link.
https://archive.h-educate.com/free-smtp-server-postal/
E: The repository 'http://www.rabbitmq.com/debian testing Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
root@vmi532412:~#
@C23BETO, I am not sure what you mean. You can remove the database system and try to install it again.
@
Abdallah,
Would I have to go back to Step 1: Install Maria DB Server of the guide and start by entering command "sudo apt update"?
If not, how do I remove the database?
Thank you.
The easiest way if you do not want to dive a bit technically into the server is to reinstall the OS. It does not require much work other than searching how to remove the DB and then checking if there is any issue during the removal and new installation.
Abdallah,
I've reinstalled the OS and ran through all the steps one more time. There were no issues with the OS reinstall.
I still get this error message.
Everything up to this point seems to work out just fine. I'm following the guide word for word.
Where do I go from here?
Hello,
I’m following this article: https://archive.h-educate.com/setup-smtp-server/
and i always get the error while connecting: "getaddrinfo failed"
from this guide it says,
First, check your hostname:
hostname -f
If you don’t see a form of ANYTING.YOURDOMAIN.COM, then you need to change the hostname using the following command:
sudo hostname host.domain.tld
My first questions is this: what if you see something like hwwsrv-837877.hostwindsdns.com, then what should you do?
my second question is: How do you confirm that your ip has been resolved to your domain?
host: server points: YOUR SERVER IP
i tried using this site to check www.whatsmydns.net
if i use host: www points: YOUR SERVER IP it resolves
but if i use host: server points: YOUR SERVER IP it will not resolve
please kindly advise.
Thank you so much!
Chris
You should change your hostname to be the same as your domain name.
as for the domain, check it on ping.eu to see if it resolves to your server IP.
i am still getting the same error
Applications Error: No Internet Connection ! [getaddrinfo failed]
how can i solve this problem?
hi
when I enter the command
mysql -u root -p
it prompts me for the password and when I enter my VPS password
it shows
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
please help!!!
Check the password you used when you secured your SQL. Or try to press enter and check?
[bquote] abdallahTaleb: Check the password you used when you secured your SQL. Or try to press enter and check? [/bquote]
I never secured my SQL
I DONT KNOW WHY I COULD NOT ENTER IN MY SQL ACCOUNT
I AM USING PUTTY...(JUST GOR YOUR REFERENCE)