Skip to content

Forum Archive

SMTP Server Install...
 
Notifications
Clear all

SMTP Server Installation Problem

14 Posts
5 Users
0 Likes
457 Views
c23beto
(@c23beto)
Posts: 5
Member Customer
Topic starter
 

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

 
Posted : 23/02/2021 3:18 pm
Abdallah
(@abdallahtaleb)
Posts: 519
Noble Member Admin
 

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?

 
Posted : 23/02/2021 8:34 pm
c23beto
(@c23beto)
Posts: 5
Member Customer
Topic starter
 

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

 
Posted : 23/02/2021 9:08 pm
sachi0066@gmail.com
(@sachi0066gmail-com)
Posts: 7
Member Customer
 

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

 
Posted : 24/02/2021 12:30 pm
Abdallah
(@abdallahtaleb)
Posts: 519
Noble Member Admin
 

@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://archive.h-educate.com/smtp-server-configuration/

 
Posted : 24/02/2021 1:07 pm
c23beto
(@c23beto)
Posts: 5
Member Customer
Topic starter
 

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.

 

 
Posted : 24/02/2021 3:12 pm
Abdallah
(@abdallahtaleb)
Posts: 519
Noble Member Admin
 

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.

 
Posted : 26/02/2021 1:05 pm
c23beto
(@c23beto)
Posts: 5
Member Customer
Topic starter
 

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?

 
Posted : 26/02/2021 2:02 pm
chrisaso
(@chrisaso)
Posts: 2
Member Customer
 

 

 

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

 
Posted : 27/02/2021 10:20 pm
Abdallah
(@abdallahtaleb)
Posts: 519
Noble Member Admin
 

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.

 
Posted : 28/02/2021 12:23 pm
chrisaso
(@chrisaso)
Posts: 2
Member Customer
 

i am still getting the same error

 

Applications Error: No Internet Connection ! [getaddrinfo failed]

 

how can i solve this problem?

 

 

 
Posted : 28/02/2021 11:38 pm
danny2204
(@danny2204)
Posts: 3
Member Customer
 

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

 
Posted : 03/03/2021 9:49 am
Abdallah
(@abdallahtaleb)
Posts: 519
Noble Member Admin
 

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

 
Posted : 07/03/2021 7:32 pm
danny2204
(@danny2204)
Posts: 3
Member Customer
 

[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)

 

 
Posted : 08/03/2021 10:03 am
Share: