CloningProcess.php — WP STAGING – WordPress Backups, Restore, Migration & Clone 4.11.1

wp-staging / Backend / Modules / Jobs / CloningProcess.php

wp-staging / Backend / Modules / Jobs Last commit date

Cleaners 1 week ago Exceptions 1 week ago Cancel.php 1 week ago CancelUpdate.php 1 week ago Cloning.php 1 week ago CloningProcess.php 1 week ago Data.php 1 week ago Database.php 1 week ago Delete.php 1 week ago Directories.php 1 week ago Files.php 1 week ago Finish.php 1 week ago Job.php 1 week ago JobExecutable.php 1 week ago Logs.php 1 week ago PreserveDataFirstStep.php 1 week ago PreserveDataSecondStep.php 1 week ago ProcessLock.php 1 week ago Scan.php 1 week ago SearchReplace.php 1 week ago TotalStepsAreNumberOfTables.php 1 week ago Updating.php 1 week ago

CloningProcess.php

167 lines

1	<?php
2
3	namespace WPStaging\Backend\Modules\Jobs;
4
5	use WPStaging\Core\WPStaging;
6	use WPStaging\Framework\Adapter\Database\DatabaseException;
7
8
9
10
11	abstract class CloningProcess extends JobExecutable
12	{
13
14
15
16
17	protected $stagingDb;
18
19
20
21
22
23	protected $productionDb;
24
25
26
27
28	protected function setupMemoryExhaustFile()
29	{
30	$this->memoryExhaustErrorTmpFile = $this->getMemoryExhaustErrorTmpFile(Cloning::WPSTG_REQUEST);
31	}
32
33	protected function initializeDbObjects()
34	{
35	$this->productionDb = WPStaging::getInstance()->get("wpdb");
36
37	if ($this->isExternalDatabase()) {
38	$this->setExternalDatabase();
39	} else {
40	$this->setLocalDatabase();
41	}
42	}
43
44	protected function setLocalDatabase()
45	{
46	$this->stagingDb = WPStaging::getInstance()->get("wpdb");
47	}
48
49
50
51
52	protected function setExternalDatabase()
53	{
54	if (!$this->validateExternalDatabaseConnectionData()) {
55	return false;
56	}
57
58	if ($this->options->databaseSsl && !defined('MYSQL_CLIENT_FLAGS')) {
59	// phpcs:disable PHPCompatibility.Constants.NewConstants.mysqli_client_ssl_dont_verify_server_certFound
60	define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL \| MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT);
61	}
62
63	$this->stagingDb = new \wpdb($this->options->databaseUser, str_replace("\\\\", "\\", $this->options->databasePassword), $this->options->databaseDatabase, $this->options->databaseServer);
64
65	if (!is_object($this->stagingDb)) {
66	$this->returnException('Can not create database object.');
67	return false;
68	}
69
70
71	if (
72	property_exists($this->stagingDb, 'error') &&
73	$this->stagingDb->error instanceof \WP_Error
74	) {
75
76	$wp_error = $this->stagingDb->error;
77	if ($wp_error->get_error_code() === 'db_connect_fail') {
78	$this->returnException(sprintf(
79	__('Can not connect to external database: %1$s. %2$s', 'wp-staging'),
80	$this->getExternalDatabaseLabel(),
81	$this->getExternalDatabaseConnectionFailureMessage($wp_error)
82	));
83
84	return false;
85	}
86	}
87
88	$this->stagingDb->select($this->options->databaseDatabase);
89	if (!$this->stagingDb->ready) {
90	if (
91	property_exists($this->stagingDb, 'error') &&
92	$this->stagingDb->error instanceof \WP_Error
93	) {
94
95	$wp_error = $this->stagingDb->error;
96	if ($wp_error->get_error_code() === 'db_select_fail') {
97	$message = $this->normalizeDatabaseErrorMessage($wp_error->get_error_message());
98	$this->returnException($message !== '' ? $message : sprintf('Error: Can\'t select database %s. Either it does not exist or you don\'t have privileges to access it.', $this->options->databaseDatabase));
99	exit;
100	}
101
102
103	$this->returnException(sprintf('Error: Can\'t select database %s. Either it does not exist or you don\'t have privileges to access it.', $this->options->databaseDatabase));
104	exit;
105	}
106
107
108	$this->returnException(sprintf('Error: Can\'t select database %s. Either it does not exist or you don\'t have privileges to access it.', $this->options->databaseDatabase));
109	exit;
110	}
111
112	return true;
113	}
114
115
116
117
118	protected function validateExternalDatabaseConnectionData(): bool
119	{
120	try {
121	$this->externalDatabaseConfiguration->validateConnectionTarget($this->options);
122	} catch (DatabaseException $exception) {
123	$this->returnException($exception->getMessage());
124	return false;
125	}
126
127	return true;
128	}
129
130
131
132
133	private function getExternalDatabaseLabel(): string
134	{
135	$databaseName = isset($this->options->databaseDatabase) ? trim((string)$this->options->databaseDatabase) : '[Not Set]';
136
137	return $databaseName;
138	}
139
140
141
142
143
144	private function getExternalDatabaseConnectionFailureMessage(\WP_Error $wpError): string
145	{
146	$message = $this->normalizeDatabaseErrorMessage($wpError->get_error_message());
147	if ($message === '' \|\| stripos($message, 'Error establishing a database connection') !== false) {
148	return __('Verify the database host, database name, database user, and password, and make sure the database server is reachable.', 'wp-staging');
149	}
150
151	return sprintf(__('Reason: %s', 'wp-staging'), $message);
152	}
153
154
155
156
157
158	private function normalizeDatabaseErrorMessage(string $message): string
159	{
160	$message = html_entity_decode($message, ENT_QUOTES, 'UTF-8');
161	$message = wp_strip_all_tags($message, true);
162	$message = preg_replace('/\s+/', ' ', $message);
163
164	return is_string($message) ? trim($message) : '';
165	}
166	}
167