8 – Cannot connect to the DigitalOcean remote database

I am trying to connect an existing Drupal 8 site to a database managed by DigitalOcean.

The connection information I received from DigitalOcean:

username = digitaloceanadmin
password = password
host = nameofmydbcluster.db.ondigitalocean.com
port = 25060
sslmode = REQUIRED

I have made the settings to settings.php:

$databases('default')('default') = array (
  'database' => 'dbname',
  'username' => '...',
  'password' => '...',
  'prefix' => '',
  'host' => 'dbclustername.db.ondigitalocean.com',
  'port' => '25060',
  'namespace' => 'Drupal\Core\Database\Driver\mysql',
  'driver' => 'mysql',
);

However, I receive the following error:

PDOException: SQLSTATE(HY000) (2054) The server requested authentication method 
unknown to the client in ...

More mistakes when I drush cr:

In Connection.php line 416:

  SQLSTATE(HY000) (2054) The server requested authentication method unknown to the client


In Connection.php line 416:

  PDO::__construct(): The server requested authentication method unknown to the client (caching_sha2_password)

I am running Drupal 8.8.1 with php7.2. The remote DB version is MySQL 8.

Any help would be highly appreciated.

Server: Apache crashes and automatically restarts in digitalocean

I recently requested a change in my root password that was successful and I can use it in the console. However, my IP address stopped working. Both visiting my domain and SSH are responding with an exhausted connection error.

It worked fine until I changed my root password and the server rebooted.

I checked the error log using this command:

tail -50 /var/log/apache2/error.log

And this is what I got:

(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 994) AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
(Mon Jan 20 00:47:06.157921 2020) (core:notice) (pid 994) AH00094: Command line: '/usr/sbin/apache2'
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 981) AH00169: caught SIGTERM, shutting down
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 970) AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
(Mon Jan 20 00:47:06.157921 2020 (core:notice) (pid 970) AH00094: Command line: '/usr/sbin/apache2'
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 903) AH00169: caught SIGTERM, shutting down
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 903) AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
(Mon Jan 20 00:47:06.157921 2020) (core:notice) (pid 994) AH00094: Command line: '/usr/sbin/apache2'
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 994) AH00169: caught SIGTERM, shutting down
(Mon Jan 20 00:47:06.157921 2020) (mpm_prefork:notice) (pid 970) AH00163: Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g configured -- resuming normal operations
(Mon Jan 20 00:47:06.157921 2020) (core:notice) (pid 990) AH00094: Command line: '/usr/sbin/apache2'

Observe the SIGTERM, shutting down? I think Apache is blocking and the service restarts automatically.

At first I thought it was as a result of low memory usage, then I checked with this command free -mh

Here are the results. My ram is enough:

              total        used        free      shared  buff/cache   available
Mem:           1.9G        259M        1.4G         612K        258M        1.6G
Swap:            0B          0B          0B

The firewall is inactive, so nothing blocks port 80

sudo ufw status
Status: Inactive

I also execute this command to see what is being heard

sudo lsof -iTCP -sTCP:LISTEN -P

COMMAND    PID           USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
sshd      812           root    3u  IPv4  18468      0t0  TCP  localhost:53 (LISTEN)
sshd      812           root    4u  IPv6  18468      0t0  TCP *:22 (LISTEN)
mysqld      899           mysql    29u  IPv4  19368      0t0  TCP localhost:3306 (LISTEN)
master      1089           root    13u  IPv4  19478      0t0  TCP *:25 (LISTEN)
master      1089           root    14u  IPv6  19479      0t0  TCP *:25 (LISTEN)

Could it be my Apache configuration?
this is what is heard in me /etc/apache2/ports.conf

grep "Listen" /etc/apache2/*.conf

etc/apache2/ports.conf: Listen 0.0.0.0

etc/apache2/ports.conf: Listen 433
etc/apache2/ports.conf: Listen 433

I can't even restart Apache, it doesn't let me

service apache2 restart

Job for apache2.service failed because the control proccess exited with error code. See "systemctl status apache2.service" and "journalctl -xe" for details.

When executing that command I got this:

apache2.service - The Apache HTTP Server
Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset
Drop-In: /lib/systemd/system/apache2.service.d
         apache-system.conf
Active: failed (Result: exit-code) since Mon 2020-01-20 12:16:35 UTC; 4min 9s
Process: 1616 ExecStart=/usr/sbin/apachectl start (code=exited, status=1/FAILURE

This is normal? Please help

virtualhost: Sendmail cannot work in Ubuntu 18.04.3 (LTS) x64 in DigitalOcean Droplet

I have taken these steps (collected from numerous posts in this forum and others) to install and configure SendMail on my DigitalOcean droplet, running Ubuntu 18.04.3 (LTS) x64, but I couldn't make it work.

1. sendmail installed:

sudo apt-get install sendmail

2. changed the host name:

# sudo hostnamectl set-hostname coffee

# sudo nano /etc/hostname
coffee

# hostname
coffee

3. Modified the hosts file:

# sudo nano /etc/hosts
127.0.0.1 localhost.localdomain localhost
127.0.1.1 coffee.barismo.com coffee

::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

4. Modified the local host names file:

# sudo nano /etc/mail/local-host-names
localhost
coffee

5. Created a generic table:

sudo nano /etc/mail/genericstable
www-data       webmaster@barismo.com
root           server@barismo.com

6. created a generic domain file:

sudo nano /etc/mail/generics-domains
barismo.com

7. added the following to sendmail.mc:

sudo nano /etc/mail/sendmail.mc
FEATURE(`genericstable',`hash -o /etc/mail/genericstable.db')dnl
GENERICS_DOMAIN_FILE(`/etc/mail/generics-domains')dnl

8. and finally reconfigured sendmail and restarted the services and the server:

sudo sendmailconfig
sudo systemctl restart sendmail
sudo service apache2 restart
sudo systemctl restart apache2

After all this, it still doesn't work.

When I tried to send a test email:

# echo "Subject: test" | /usr/lib/sendmail -v isofia666@gmail.com

I get this error in Electronic record:

Jan 19 08:13:07 barismo sm-mta(25919): 00J837P9025919: to=, 
ctladdr= (0/0), delay=00:10:00, xdelay=00:10:00, 
mailer=esmtp, pri=30295, relay=alt4.gmail-smtp-in.l.google.com. (172.253.112.27), 
dsn=4.0.0, stat=Deferred: Connection timed out with alt4.gmail-smtp-in.l.google.com.

And when I tried to send myself an email in my PHP script, I received this error:

Jan 19 08:10:43 barismo sm-mta(26115): 00J81emc025911: to=, 
ctladdr= (33/33), delay=00:09:03, xdelay=00:04:22, 
mailer=esmtp, pri=210494, relay=shared18.accountservergroup.com. (192.185.134.44), 
dsn=4.0.0, stat=Deferred: Connection timed out with shared18.accountservergroup.com.

If relevant, it should be noted that the DNS of my domain is hosted on Site5 and I have modified only the registry & # 39; A & # 39; to point to my Digital Ocean droplet, while keeping records & # 39; MX & # 39; with Site5 to handle emails.

I can still send and receive emails from my Site5 mailbox and the domain name itself (barismo.com and www.barismo.com) It solves correctly in my Digital Ocean drop without problem.

Any address will be greatly appreciated. Thank you.

bitcoind: cannot connect to Bitcoin RPC on the DigitalOcean server

I am running bitcoind on a drop of DigitalOcean with public IP address, p. 1.1.1.1.

I would like to connect to it through RPC from another drop of DigitalOcean with public IP address, p. 2.2.2.2.

Both Droplets run Ubuntu Linux 18.04.

~/.bitcoin/bitcoin.conf in 1.1.1.1:

datadir=/mnt/vol1
disablewallet=1
rpcbind=1.1.1.1
rpcuser=x
rpcpassword=x
rpcallowip=2.2.2.2/32
server=1

netstat -ln | grep 8332 in 1.1.1.1 yields:

tcp        0      0 127.0.0.1:8332          0.0.0.0:*               LISTEN
tcp6       0      0 ::1:8332                :::*                    LISTEN

RPC commands in 1.1.1.1 how ./bitcoin-cli -rpcuser=x -rpcpassword=x -rpcconnect=localhost -rpcport=8332 getnetworkinfo return normally.

However, in the machine 2.2.2.2when I run ./bitcoin-cli -rpcuser=x -rpcpassword=x -rpcconnect=1.1.1.1 -rpcport=8332 getnetworkinfo I get:

error: Could not connect to the server 1.1.1.1:8332

Make sure the bitcoind server is running and that you are connecting to the correct RPC port.

Machine 1.1.1.1 You have firewall rules in DigitalOcean as follows:

Type        Protocol        Port Range      Sources
SSH         TCP             22              2.2.2.2/32
Custom      TCP             8332            2.2.2.2/32

Note that SSH in 1.1.1.1 since 2.2.2.2 it is working well

sudo iptables -L in 1.1.1.1 gives:

Chain INPUT (policy ACCEPT)
target     prot opt source               destination

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination   

Is there something obviously wrong with my configuration or configuration?

Running curl -v 1.1.1.1:8332 in 2.2.2.2 return immediately with:

* Rebuilt URL to: 1.1.1.1:8332/
*   Trying 1.1.1.1...
* connect to 1.1.1.1 port 8332 failed: Connection refused
* Failed to connect to 1.1.1.1 port 8332: Connection refused
* Closing connection 0
curl: (7) Failed to connect to 1.1.1.1 port 8332: Connection refused

Which of what I read probably indicates a firewall problem.

Buckle up for the new DigitalOcean drops for WHMCS 1.4.0 and the massive Black Week sale! The | Proxies123.com

1] DigitalOcean drops for WHMCS 1.4.0

It is always a great feeling to share the news of our new releases with the entire web hosting community. So why not dive into this week's summary from our most recent update? DigitalOcean drops for WHMCS 1.4.0!

Because of this latest version, a complete set of completely new permissions is brought:

  • Perfect integration with the latest WHMCS V7.9.
  • The possibility of your customers edit previously created firewall rules, which parameters, such as the maximum incoming, outgoing and maximum limit, can now be defined thanks to their new administrative privileges.
  • Support for floating IP addresses, making the process of its assignment after the new creation and update of Droplet completely automated.

Control your excitement for a little more time, as there are still a couple of new, more advantageous features to explore: feel welcome to give them a proper evaluation.

Click here to find out more about DigitalOcean drops for WHMCS 1.4.0!

two] Happy thanksgiving to all!

It fills us with infinite pleasure, once again, expressing our deepest gratitude and gratitude to all our clients, a motivating force behind each of our companies. Best wishes to you and your loved ones on these special holidays: may your Thanksgiving be full of joy and joy, and that the future year abounds in happiness, peace and prosperity.

3] Don't miss the blackest deals of the year!

We have barely finished storing our summer clothes and Christmas is just around the corner. And that means that some key dates for bargain seekers are rising rapidly: Black Friday is constantly chasing its younger brother, Cyber ​​Monday!

Discount hunters prepare: this year, we decided not to restrict their purchase aspirations, therefore, Black week Pure selling madness is all yours to participate! It doesn't matter if you already have an eye on some particular software or just want to buy something on a whim, be sure to be aware of the irresistible bargains of the Black Week that It will be announced in a matter of several hours!

Sit well and keep your eyes wide open!

4] See also our other module updates:

Do you need custom software development for your business?

Especially for you, we will adapt an application and its design to your own needs, we will create a new module or even a completely new system built from scratch.

nginx with apache in laravel forge digitalocean

I have several websites in my laravel forge account. One of these websites requires apache and only nginx configured on the server. Can I use apache for this website and nginx for another website? Is it possible or what is the best way to achieve the objective of this website also running with nginx?

Is using DigitalOcean a good idea to sell shared hosting?

Hello,

I have an agency
We already have more than 50 clients that offer shared hosting through a local web hosting provider,
We are looking to start hosting our clients' websites because lately we are facing some performance and speed problems.

After doing a little research, I discovered that DigitalOcean offers good prices and at the same time provides EU servers (our clients are based in this region and this will be excellent for them).

Most of our customers are using WordPress / HTML landing pages (we install and design for them) and they don't have large visitors (1K visitors / day / customer average)

We will use WHMCS, the questions I have are:
1- Is DigitalOcean a good option to provide shared hosting?
2- Is it possible to give our clients a dedicated IP with shared hosting?
3- What is your recommendation?

I will hire a full-time server administrator (SysAdmin) to handle migrations, maintenance, security, backup …
In reality, there is no need to do any kind of customer service at this time, except for some minor things (Migration, Backup) that SysAdmin can handle.
Our current clients pay $ 40 / year for lodging.
And we are projecting a 100% increase in customers by the end of the first quarter of next year if we only host our customers,
But if we can provide a good service, we will expand our service to offer shared hosting for anyone.

Thank you.

[MilesWeb] Get a 25% discount on DigitalOcean Managed VPS | Free migration, support 24/7 | Start at $ 9 / month

the managed VPS hosting plans With KVM hypervisor technology they are available in 4 sizes with various technical components, all based on a robust infrastructure with built-in SSD storage.

Obtain 20% DISCOUNT on the first month bill of any managed Linux VPS hosting plan. Enter promotion code VM20 during payment. The renovation would be at a regular price.

Entry plan

  • 1 vCPU
  • 1 GB of memory
  • 30 GB SSD in RAID
  • 100 GB bandwidth
  • 1 dedicated IP

Discounted price: $ 11.20 / month – Buy now

Luxury plan

  • 2 vCPU
  • 2 GB of memory
  • 50 GB SSD on RAID
  • 200 GB bandwidth
  • 1 dedicated IP

Discounted price: $ 20.80 / month – Buy now

Business plan

  • 2 vCPU
  • 4 GB of memory
  • 100 GB SSD on RAID
  • 300 GB bandwidth
  • 1 dedicated IP

Discounted price: $ 33.60 / month – Buy now

Master plan

  • 4 vCPU
  • 8 GB of memory
  • 150 GB SSD on RAID
  • 400 GB bandwidth
  • 1 dedicated IP

Discounted price: $ 62.40 / month – Buy now

For more details on Cheap Linux VPS hosting plans please visit: https://www.milesweb.in/hosting/cheap-vps-plans


MilesWeb offers fully managed Linux VPS hosting plans with DigitalOcean technology available in 4 sizes with various technical components, with benefits such as built-in SSD storage, SSH access, guaranteed server resources and protection against hardware attacks.

Obtain 25% DISCOUNT on the first month bill of any managed Linux VPS hosting plan. Enter promotion code NY25 during payment. The renovation would be at a regular price.

Linux server location:

  • Bangalore
  • New York
  • San Francisco
  • London
  • Singapore
  • Frankfurt
  • Amsterdam
  • Toronto

Below is the list of Linux VPS hosting plans offered by MilesWeb:

V1 Plan

  • 1 GB of RAM | 1 vCPU | 25 GB SSD | 1 TB transfer | Discounted price: $ 9 / month

V2 Plan

  • 2 GB of RAM | 1 vCPU | 50 GB SSD | 2 TB transfer | Discounted price: $ 15 / month

V3 Plan

  • 3 GB of RAM | 1 vCPU | 60 GB SSD | 3 TB transfer | Discounted price: $ 22.50 / month

V4 Plan

  • 2 GB of RAM | 2 vCPU | 60 GB SSD | 3 TB transfer | Discounted price: $ 22.50 / month

V5 Plan

  • 1 GB of RAM | 3 vCPU | 60 GB SSD | 3 TB transfer | Discounted price: $ 22.50 / month

V6 Plan

  • 4 GB of RAM | 2 vCPU | 80 GB SSD | 4 TB transfer | Discounted price: $ 30 / month

V7 Plan

  • 8 GB of RAM | 4 vCPU | 160GB SSD | 5 TB transfer | Discounted price: $ 60 / month

V8 Plan

  • 16 GB of RAM | 6 vCPU | 320 GB SSD | 6 TB transfer | Discounted price: $ 112.50 / month

V9 Plan

  • 32 GB of RAM | 8 vCPU | 640 GB SSD | 7 TB transfer | Discounted price: $ 225 / month

V10 Plan

  • 48 GB of RAM | 12 vCPU | 960 GB SSD | 8 TB transfer | Discounted price: $ 300 / month

V11 Plan

  • 64 GB of RAM | 16 vCPU | 1280 GB SSD | Transfer of 9 TB | Discounted price: $ 390 / month

V12 Plan

  • 96 GB of RAM | 20 vCPU | 1920 GB SSD | 10 TB transfer | Discounted price: $ 562.50 / month

V13 Plan

  • 128 GB of RAM | 24 vCPU | 2560 GB SSD | 11 TB transfer | Discounted price: $ 715.50 / month

V14 Plan

  • 192 GB of RAM | 32 vCPU | 3840 GB SSD | 12 TB transfer | Discounted price: $ 1087.50 / month

VPS optimized plans

VD1 Plan

  • 4 GB of RAM | 2 vCPU | 25 GB SSD | 4 TB transfer | Discounted price: $ 60 / month

VD2 Plan

  • 8 GB of RAM | 4 vCPU | 50 GB SSD | 5 TB transfer | Discounted price: $ 112.50 / month

VD3 Plan

  • 16 GB of RAM | 8 vCPU | 100 GB SSD | 6 TB transfer | Discounted price: $ 225 / month

VD4 Plan

  • 32 GB of RAM | 16 vCPU | 200 GB SSD | 7 TB transfer | Discounted price: $ 390 / month

VD5 Plan

  • 64 GB of RAM | 32 vCPU | 400 GB SSD | Transfer of 9 TB | Discounted price: $ 712.50 / month

For more details on VPS Linux hosting with DigitalOcean plans visit: https://www.milesweb.in/hosting/vps-hosting

Control Panel:

  • c WHM panel Up to 5 accounts $ 16.00USD
  • c WHM panel Up to 30 accounts $ 22.00USD
  • c WHM panel Up to 100 accounts $ 38.00USD
  • c WHM panel Up to 5 accounts + Softaculous $ 18.00USD
  • c WHM panel Up to 30 accounts + Softaculous $ 24.00USD
  • c WHM panel Up to 100 accounts + Softaculous $ 40.00USD
  • Plesk web administrator $ 13.00 USD
  • Plesk Web Pro $ 20.00USD
  • Plesk Web Host $ 30.00USD

OS:

  • Centos-7.5-x86_64
  • Centos-6.9-x86_64
  • Centos-7.1-x86_64
  • Centos-7.3-x86_64
  • Debian-7.8-x86_64
  • Debian-8.7-x86_64
  • Ubuntu-12.04-x86_64
  • Ubuntu-14.04-x86_64
  • Ubuntu-15.04-x86_64
  • Ubuntu-16.04-x86_64
  • Fedora-20-x86_64
  • Fedora-21-x86_64

Web server:

  • LSWS with LSCache (2GB RAM) for 1 domain $ 5.00USD
  • LSWS with caching (8 GB of RAM) for 5 domains $ 14.00USD
  • LSWS with caching (unlimited RAM) for 5 domains $ 23.00USD
  • LSWS with caching (8 GB of RAM) for unlimited domains $ 36.00 USD
  • LSWS with caching (unlimited RAM) for unlimited domains $ 49.00USD

For immediate assistance, visit our website and start a live chat.