We Will Go Above And Beyond To Answer Your Queries, Because We Care!

Welcome To The Fastest Growing Digital Marketing Forum On The Planet… soon on Mars 😅🚀

SMTP Server Install...
 
Notifications
Clear all

SMTP Server Installation Problem

c23beto
(@c23beto)
New Member

Hello,

I'm following this article: https://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

Quote
Topic starter Posted : 23/02/2021 3:18 pm
Abdallah
(@abdallahtaleb)
Estimable Member

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?

ReplyQuote
Posted : 23/02/2021 8:34 pm
c23beto
(@c23beto)
New Member

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

ReplyQuote
Topic starter Posted : 23/02/2021 9:08 pm
sachi0066@gmail.com
(@sachi0066gmail-com)
New Member

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://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:~#

ReplyQuote
Posted : 24/02/2021 12:30 pm
Abdallah
(@abdallahtaleb)
Estimable Member

@C23BETO, I am not sure what you mean. You can remove the database system and try to install it again.

@sachi0066@gmail.com, reinstall the VPS os and use below tutorial instead.

https://h-educate.com/smtp-server-configuration/

ReplyQuote
Posted : 24/02/2021 1:07 pm
c23beto
(@c23beto)
New Member

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.

 

ReplyQuote
Topic starter Posted : 24/02/2021 3:12 pm
Abdallah
(@abdallahtaleb)
Estimable Member

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.

ReplyQuote
Posted : 26/02/2021 1:05 pm
c23beto
(@c23beto)
New Member

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?

ReplyQuote
Topic starter Posted : 26/02/2021 2:02 pm
chrisaso
(@chrisaso)
New Member

 

 

Hello,

 

I’m following this article: https://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

ReplyQuote
Posted : 27/02/2021 10:20 pm
Abdallah
(@abdallahtaleb)
Estimable Member

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.

ReplyQuote
Posted : 28/02/2021 12:23 pm
chrisaso
(@chrisaso)
New Member

i am still getting the same error

 

Applications Error: No Internet Connection ! [getaddrinfo failed]

 

how can i solve this problem?

 

 

ReplyQuote
Posted : 28/02/2021 11:38 pm
danny2204
(@danny2204)
New Member

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!!!

ReplyQuote
Posted : 03/03/2021 9:49 am
Abdallah
(@abdallahtaleb)
Estimable Member

Check the password you used when you secured your SQL. Or try to press enter and check?

ReplyQuote
Posted : 07/03/2021 7:32 pm
danny2204
(@danny2204)
New Member
Posted : 08/03/2021 10:03 am
Share: