Tag: Connection
-
Post Views: 19 1. Use puttygen to convert the .pem file to .ppk format: open puttygen. Click Load and select the .pem file. Click Save Private Key to save as a .ppk file. as shown in Figure 1 2. Use putty to log in: open putty. In the Connection > ssh > auth, select the .ppk file. as shown in…
-
Post Views: 22 1. Now for an API, 4 tables need to be inserted. The 1st table is the table in database A, and the other 3 tables are the table in database B, and the primary key of the 1st table will be inserted into the 2nd table. 2 database connections have been configured. are WordPress and DB respectively.…
-
Post Views: 17 1. Migrate data from the CSP database to the Cloud database. `channel-pub-api-csp`.`cpa_channel_app_source`. Query 95 records. as shown in Figure 1 2. `channel-pub-api-cloud`.`cpa_channel_app_source`. A total of 158 records were queried. as shown in Figure 2 3. Migrate data from the CSP database to the Cloud database. Field value changes: id, insert `channel-pub-api-cloud`.`cpa_channel_app_source`. Edit command line scripts. /console/controllers/migrate20210425controller.php 4.…
-
Post Views: 14 1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1 2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2 3. To access RDS through the external network, you need to…
-
Post Views: 20 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in Figure 1 2. View the method file of the obtained account list, the code is as follows 3, gethttp://api.channel-pub-api.localhost/v1/channel-app-sources?group_id=015ce30b116ce86058fa6ab4fea4ac63&sort=-channel_app_task_count。Sometimes, when connecting two tables, you may…
-
Post Views: 11 1. When multiple database connection components have been added in Yii 2.0 2. The strategy to migrate multiple databases is to store the migration to different directories. A connection component corresponds to a directory. DB directory: /console/migrations/. Directory of statdb: /console/migrations/stat_db/. as shown in Figure 1 3. When generating the migration file under statdb, you need to…
-
Post Views: 17 1. When multiple database connection components have been added in Yii 2.0 2. When statdb is selected for the database connection ID, only the data table under statdb will appear in the drop-down list of the table name, as shown in Figure 1 3. When the model file under statdb is generated, getdb() is additionally generated, as…
-
Post Views: 15 1. In the console command of Yii 2.0, an error is reported: yii\db\exception: redis error: err Invalid DB index Redis command was: Select 29 in /vendor/yiisoft/yii2-redis/src/connection.php:736, view /console/runtime/logs/app.log 2. The analysis found that when executing the command: Select 29, switch to the corresponding database: 29 errors, and a Redis instance has 16 databases by default, from 0…
-
Post Views: 48 1. Execute the update statement in mysql workbench, the statement is as follows: 2. Error code: 1175, the specific error information is as follows:, as shown in Figure 1 3. Execute the update statement in phpmyadmin, the statement is as follows: the execution is successful, as shown in Figure 2 4. According to the prompts, to disable…
-
Post Views: 15 1. The multi-tenant system contains multiple tenants, and each tenant has its own database configuration information. The existing requirement is to connect the database based on the response host name, user name and password, as shown in Figure 1. 2. Now it is configured as an application component, \common\config\base.php, as shown in Figure 2 3. Open dubug,…