forked from docs/doc-exports
Ru, Li Yi
44a5966759
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com> Co-authored-by: Ru, Li Yi <liyiru7@huawei.com> Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
148 lines
16 KiB
HTML
148 lines
16 KiB
HTML
<a name="drs_precheck"></a><a name="drs_precheck"></a>
|
|
|
|
<h1 class="topictitle1">Checking Whether the Source Database Is Connected</h1>
|
|
<div id="body8662426"><div class="section" id="drs_precheck__en-us_topic_0000001205627821_section1156679095"><h4 class="sectiontitle">MySQL Migration</h4>
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="drs_precheck__en-us_topic_0000001205627821_table6980140185321" frame="border" border="1" rules="all"><caption><b>Table 1 </b>Checking whether the source database is connected</caption><tbody><tr id="drs_precheck__en-us_topic_0000001205627821_row23273730185321"><th class="firstcol" valign="top" width="11%" id="mcps1.3.1.2.2.3.1.1"><p id="drs_precheck__en-us_topic_0000001205627821_p21779339185323"><strong id="drs_precheck__en-us_topic_0000001205627821_b964419482128">Check Item</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.1.2.2.3.1.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p39446490185323">Whether the source database is connected</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row48431253185321"><th class="firstcol" valign="top" width="11%" id="mcps1.3.1.2.2.3.2.1"><p id="drs_precheck__en-us_topic_0000001205627821_p33897715185323"><strong id="drs_precheck__en-us_topic_0000001205627821_b1666535371216">Description</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.1.2.2.3.2.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p23078212192535">Check the connectivity and accuracy of the IP address, port number, username, and password of the source database.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row39952927185321"><th class="firstcol" rowspan="6" valign="top" width="11%" id="mcps1.3.1.2.2.3.3.1"><p id="drs_precheck__en-us_topic_0000001205627821_p66631160185323">Failure Cause and Handling Suggestion</p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p104671641123619">Failure cause: The connection fails.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p149811309211">Handling suggestion: Configure the network by referring to "Network Types" in Real-Time Migration.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row188280599366"><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p010098183717">Failure cause: Incorrect username or password</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p143181665374">Handling suggestion: Check whether the input username and password for the connection test are correct.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row661591417375"><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p17787222103718">Failure cause: The database account does not allow remote connections.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p163165537336">Handling suggestion:</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p83315283347">Run the following command to create a user that allows remote connections. After the migration, delete this user.</p>
|
|
<pre class="codeblock" id="drs_precheck__en-us_topic_0000001205627821_codeblock5791722205817"><strong id="drs_precheck__en-us_topic_0000001205627821_b59191147573">CREATE USER</strong> '<em id="drs_precheck__en-us_topic_0000001205627821_i684869145313">Account</em>' <strong id="drs_precheck__en-us_topic_0000001205627821_b989918865714">@ '%' IDENTIFIED BY</strong> '<em id="drs_precheck__en-us_topic_0000001205627821_i6244121875313">Password</em>'</pre>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row13912193011375"><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p1822518344374">Failure cause: The SSL CA root certificate is invalid.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p3334143203714">Handling suggestion: Upload a valid SSL CA certificate.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row111311138143718"><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p13850164510379">Failure cause: No SSL CA root certificate exists.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p9302843183710">Handling suggestion: Contact technical support.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row35418387185321"><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p15412145620371">Failure cause: The database is unavailable.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p1866214579378">Handling suggestion: Contact technical support.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="drs_precheck__en-us_topic_0000001205627821_section1419453411113"><h4 class="sectiontitle">PostgreSQL Synchronization</h4>
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="drs_precheck__en-us_topic_0000001205627821_table19898928171119" frame="border" border="1" rules="all"><caption><b>Table 2 </b>Checking whether the source database is connected</caption><tbody><tr id="drs_precheck__en-us_topic_0000001205627821_row3898128111111"><th class="firstcol" valign="top" width="11%" id="mcps1.3.2.2.2.3.1.1"><p id="drs_precheck__en-us_topic_0000001205627821_p5898828151110"><strong id="drs_precheck__en-us_topic_0000001205627821_b12661225194010">Check Item</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.2.2.2.3.1.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p16898182814117">Whether the source database is connected</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row989862815112"><th class="firstcol" valign="top" width="11%" id="mcps1.3.2.2.2.3.2.1"><p id="drs_precheck__en-us_topic_0000001205627821_p1489832811117"><strong id="drs_precheck__en-us_topic_0000001205627821_b1080113324011">Description</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.2.2.2.3.2.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p289813286112">Check the connectivity and accuracy of the IP address, port number, username, and password of the source database.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row7898162811117"><th class="firstcol" rowspan="7" valign="top" width="11%" id="mcps1.3.2.2.2.3.3.1"><p id="drs_precheck__en-us_topic_0000001205627821_p28981528111114">Failure Cause and Handling Suggestion</p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p105570585195">Failure cause: The IP address is inaccessible.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p107034143511">Handling suggestion: Configure the network by referring to "Network Types" in Real-Time Migration.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row591212841113"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p1457114711911">Failure cause: The connection fails.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p148748181150">Handling suggestion: Configure the network by referring to "Network Types" in Real-Time Migration.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row1172815115197"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p5322156202020">Failure cause: The database account does not allow remote connections.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p188702535216">Handling suggestion:</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p7224108121614">Configure the remote connection permission for the user in the <strong id="drs_precheck__en-us_topic_0000001205627821_b2035744914118">pg_hba.conf</strong> file.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p129713137517">Open <strong id="drs_precheck__en-us_topic_0000001205627821_b1488768969114023">pg_hba.conf</strong>, add the following, and restart the database for the modification to take effect:</p>
|
|
<pre class="codeblock" id="drs_precheck__en-us_topic_0000001205627821_codeblock114339257711">host all xxx(dbuser) 0.0.0.0/0 password</pre>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p10432184162018">After the migration is complete, delete this record and restart the database again.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row94326220200"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p199161326162019">Failure cause: Failed to connect to the database.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p1495919297166">Handling suggestion:</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p143317312221">The <strong id="drs_precheck__en-us_topic_0000001205627821_b187285246485">listen_addresses</strong> parameter value or port number in the <strong id="drs_precheck__en-us_topic_0000001205627821_b1242422674912">postgres.conf</strong> file is incorrect.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p95416241205">In the <strong id="drs_precheck__b240359198">postgres.conf</strong> file, set the <strong id="drs_precheck__en-us_topic_0000001205627821_b1089573813493">listen_addresses</strong> value to <strong id="drs_precheck__en-us_topic_0000001205627821_b16897153834915">'*'</strong> or set the port number to the correct value. Then, restart the database for the modification to take effect.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row1678213713205"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p16892204002011">Failure cause: Incorrect username or password</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p12360133962016">Handling suggestion: Check whether the input username and password for the connection test are correct.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row13109115219201"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p96722555201">Failure cause: The user does not have the login permission.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p949094442210">Handling suggestion:</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p6516185320206">Run the following command to grant the login permission to the user:</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p447014691712"><strong id="drs_precheck__en-us_topic_0000001205627821_b12327135951213">alter role</strong> <em id="drs_precheck__en-us_topic_0000001205627821_i1267185121318">xxx(dbuser)</em><strong id="drs_precheck__en-us_topic_0000001205627821_b18843131012131"> login</strong></p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row353112710213"><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p864292162111">Failure cause: The postgres database does not exist in the source database.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p16720184341612">Handling suggestion: Create a postgres database.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div class="section" id="drs_precheck__en-us_topic_0000001205627821_section7120182416126"><h4 class="sectiontitle">Migration from MongoDB to DDS</h4>
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="drs_precheck__en-us_topic_0000001205627821_table1401319101210" frame="border" border="1" rules="all"><caption><b>Table 3 </b>Checking whether the source database is connected</caption><tbody><tr id="drs_precheck__en-us_topic_0000001205627821_row24081921213"><th class="firstcol" valign="top" width="11%" id="mcps1.3.3.2.2.3.1.1"><p id="drs_precheck__en-us_topic_0000001205627821_p144041913128"><strong id="drs_precheck__en-us_topic_0000001205627821_b19732105115118">Check Item</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.3.2.2.3.1.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p1557191916127">Whether the source database is connected</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row357131920129"><th class="firstcol" valign="top" width="11%" id="mcps1.3.3.2.2.3.2.1"><p id="drs_precheck__en-us_topic_0000001205627821_p1657171918124"><strong id="drs_precheck__en-us_topic_0000001205627821_b5878195475120">Description</strong></p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.3.2.2.3.2.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p75791991211">Check the connectivity and accuracy of the IP address, port number, username, and password of the source database.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row5575198128"><th class="firstcol" rowspan="6" valign="top" width="11%" id="mcps1.3.3.2.2.3.3.1"><p id="drs_precheck__en-us_topic_0000001205627821_p25791901212">Failure Cause and Handling Suggestion</p>
|
|
</th>
|
|
<td class="cellrowborder" valign="top" width="89%" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p1711021552415">Failure cause: The connection fails.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p176218248511">Handling suggestion: Configure the network by referring to "Network Types" in Real-Time Migration.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row123729102314"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p10371197234">Failure cause: The username, password, or authentication database of the source database is incorrect.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p1372921162511">Handling suggestion: Check that the input username, password, and authentication database for the connection test are correct.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row722631272315"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p722610128236">Failure cause: The database is unavailable.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p2293144152511">Handling suggestion: Contact technical support.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row1286561432319"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p786510143235">Failure cause: An internal error occurs.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p1651113632518">Handling suggestion: Contact technical support.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row553191812230"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p175319184236">Failure cause: SSL connection parameters are not configured.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p85584911255">Handling suggestion: Contact technical support.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="drs_precheck__en-us_topic_0000001205627821_row145564212316"><td class="cellrowborder" valign="top" headers="mcps1.3.3.2.2.3.3.1 "><p id="drs_precheck__en-us_topic_0000001205627821_p17455194242311">Failure cause: The source database cannot connect to the port of the replication instance.</p>
|
|
<p id="drs_precheck__en-us_topic_0000001205627821_p962015118253">Handling suggestion: Modify the firewall, security group, or ACL configurations of the source and destination databases to enable the source database to connect to the port of the replication instance.</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="drs_12_0003.html">Networks</a></div>
|
|
</div>
|
|
</div>
|
|
|