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.

mysql – database design problem without duplicate data

I have a customer database that has customer data and a user table. I store the customer data (Organization Details) in the customer data table and store the user data in the Users table that stores the user's email and hash to log in. I create a database on the registration of the Organization. Now that user can add more users who can have login credentials and some cannot. I do not understand where to store these users not logable. I have a user ID as the primary key in the clients.users table. I keep that identification in the staff table of the organizations database. I look for email in the clients.users table when I log in to the user. At the same time, I have the identification of this user in the staff organization table. But where should I store this non-withholding personnel data? I cannot store them in the organization's personnel table because this table uses the clients.users user ID as the foreign key.
How can I store non-withholding personnel data?

I am storing user details both in the customer table and in the organizations table. I check the client table during authentication. But storing the same data in two tables is not a good way. I want to store user details in the organization's database and use this identification as a foreign key in the customer's database. But I don't know which user belongs to which database. I can't search them in the customer database because it only contains user ID as a foreign key. How to verify your credentials in db clients?

I deleted my WhatsApp database

I have deleted my WhatsApp database and now WhatsApp deletes all my chats. I have uninstalled and reinstalled yet my chat has not been recovered even after having backed up on Google Drive.

Firebird isql exclusive mode? – Exchange of database administrators stack

I have a vague memory that the Firebird isql utility in some situations will make an exclusive connection to the database, which means that any other connection attempt will be rejected.

I can't find information about this.

Can anyone explain in what situations this happens and, in particular, how can I make sure that it does NOT happen?

My intended use is to execute some commands / queries on a scheduled task, and I do not want to run the risk of blocking the work of another database while executing this task.

mysql – How to get the value of another table in the same database in laravel?

Keep it simple … I have 1 database with 2 tables whose name (bit_app_policy_category) and (company_policy).
Inside (bit_app_policy_category) I have these columns:
1. id
2. code
3. description
4. parent_id
5. state
Inside (company_policy) I have these columns:
1. id
2. policy_category_id
3. political_title
4. version_no
5. political_ details
6. due date

so what I want is to get the value of the data from column (1.id) inside the (bit_app_policy_category) in the column (company_policy) (2.policy_category_id), but I don't know how to do it, I've been looking for a solution for more than 20 hours and still lost and so done … could anyone help me?



I want the value of the data to be imported into the value of the option below the line of code in –Select Category–

java – How to backup and restore data from the database

I would like to know how I make a backup and restore the database of my Android application through the code.

insert image description here

It's something like the image above.

By clicking on the "Backup" button, you create a file in the internal storage or on the SD card.

When you click on the restore button, it searches for the file with the data.

7 – Migration of the FreeBSD 12 Drupal site to Ubuntu 18.04 SQL Database unknown behavior

I am currently trying to migrate Drupal site from FreeBSD 12 to Ubuntu 18.04. All settings are copied and moved to Ubuntu 18.04. Everything seems fine and I was able to create the Drupal site with Ubuntu 18.04, but every time I clear the cache on the new site, it seems that the configuration of the page is gone and the content is everywhere. In addition, the newest content is also deleted. I usually use the mysqldump command line to dump the mysql database and restore the backup with the mysql command line. I also tried to download phpmyadmin to dump and restore the mysql database, but the problem is still present. This is a critical problem on the site, because the installation of a new module automatically removes the cache.

Drupal Version: 7.59

I guess when you discard the mysql database, the most recent content and page settings are cached … I'm not really familiar with how mysql saves the database. Any help would be a great help for me to proceed with the migration. Thank you!

Backup: Freelancer has access to Firebase Database. That I have to do?

In November, I put a $ 100 reward on a separate website for anyone who could debug an error that I had found in my application that I was developing and could not eliminate. It turns out that the freelancer was not in a position to work for me. I had lied about being Danish (I was actually from northeastern China and had an Internet connection so poor that I could barely run my application). In addition, his English was much worse than any freelancer with whom he had previously worked, you can't even have a conversation with him.

Anyway, I want to write my $ 100 that I prepared for him, but I'm afraid it will destroy my database as an act of reprisal. You have cloned my Github project, including the GoogleService-Info.plist file that would allow you to make changes to my backend.

My project is still in Beta, but it is scheduled to go out to the public next month. Should I generate a new GoogleService-Info.plist archive and force all current beta users to update their version (the previous version will be unusable) or should I continue with it and hope that the freelancer does not destroy everything I have?

PS: Sorry, this may not be the right StackExchange site for this question. I am an experienced Stack Overflow user and I know it would not be appropriate there. If someone points me to a better place, I will gladly move the question.

performance: extraction of date and time from the database and optimization of a For loop

I'm learning Python and I'm looking for ways to make my code look more python.

My first problem is the conversion of a DateTime returned by a database.

        print("Getting most recent record from database")
        get_max_date=fixfile.conn.execute('SELECT max(date) from sharehistory').fetchall()
        get_max_date=dtime. strptime(get_max_date,'%Y-%m-%d %H:%M:%S')
        day_start=dtime.strptime(day_start, '%m%d%Y')

As you can see, I get the Date, denoting it and converting it.
I guess there is a better way to do this.

Second, I have written 3 FOR loops to address very similar problems

 for div in table.find_all("tr", {'align':'right'}): 

        for div in table.find_all("td", {'align':'right'}): 

        for div in table.find_all("td", {'colspan':'8'}): 

How can this be done more efficiently?

topics: database connection problems with Drupal 8 and Acquia DevDesktop

New in Drupal 8 and stumbled upon it. It seems like something wrong with the database, but if anyone has advice, let me know!
Here is my code:
enter the description of the image here

And here is an error:
enter the description of the image here

And my drupal site doesn't work at all:
enter the description of the image here

I'm not even sure where to start looking. Also, use Acquia DevDesktop if that helps at all. Thank you!