TYPO3 8通过DBAL映射远程MySQL服务器account表的技术问询

Hey there! Let's walk through finishing up the DBAL configuration for your TYPO3 8 setup so you can display and edit that remote account table using your custom model. Here's the step-by-step breakdown:

1. Complete the DBAL Global Configuration #

You started setting up $GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['dbal'] – let's fill in the missing parts properly. This config tells TYPO3 about the remote database connection and maps your model to the custom table.

Add this to your extension's ext_localconf.php (preferred for portability) or LocalConfiguration.php:

$GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['dbal'] = [
    'connections' => [
        'remote_mysql' => [
            'driver' => 'mysqli',
            'host' => 'remote-host-ip-or-domain',
            'port' => 3306, // adjust if your remote MySQL uses a non-standard port
            'dbname' => 'your-remote-db-name',
            'user' => 'db-user-with-read-write-access',
            'password' => 'db-user-password',
            'charset' => 'utf8mb4',
        ],
    ],
    'tableConfigurations' => [
        'account' => [
            'connection' => 'remote_mysql',
            'mapping' => [
                'uid' => 'id', // map if remote table's primary key isn't `uid`
                'username' => 'your_remote_username_column', // link model fields to remote columns
                'email' => 'your_remote_email_column',
                // add all other fields from your tx_base_domain_model_account here
            ],
        ],
    ],
    // Optional: Mark the table as remote for TYPO3 backend recognition
    'tables' => [
        'account' => [
            'type' => 'remote',
        ],
    ],
];

Key Notes: #

• Replace all placeholder values with your actual remote database details.
• The mapping section is critical: every field in your tx_base_domain_model_account must have a matching entry pointing to the remote table's column.
• If your remote table uses id instead of TYPO3's default uid as the primary key, the uid => id mapping ensures TYPO3 can correctly identify records.

2. Configure TCA for Your Account Model #

To enable backend editing and listing, set up the Table Configuration Array (TCA) in your custom extension. Create/update Configuration/TCA/tx_base_domain_model_account.php:

return [
    'ctrl' => [
        'title' => 'LLL:EXT:base/Resources/Private/Language/locallang_db.xlf:tx_base_domain_model_account',
        'label' => 'username', // field to display as record label in backend
        'tstamp' => 'tstamp', // map if remote table has a timestamp field; omit if not
        'crdate' => 'crdate',
        'delete' => 'deleted', // map soft delete flag if exists; set to false otherwise
        'enablecolumns' => [
            'disabled' => 'hidden',
        ],
        'searchFields' => 'username,email',
        'iconfile' => 'EXT:base/Resources/Public/Icons/tx_base_domain_model_account.png',
        'rootLevel' => -1,
        'useDBal' => true, // Tell TYPO3 to use DBAL connection
        'tableName' => 'account', // name of the remote table
    ],
    'interface' => [
        'showRecordFieldList' => 'username,email',
    ],
    'types' => [
        '1' => ['showitem' => 'username,email'],
    ],
    'columns' => [
        'hidden' => [
            'exclude' => true,
            'label' => 'LLL:EXT:lang/locallang_general.xlf:LGL.hidden',
            'config' => [
                'type' => 'check',
            ],
        ],
        'username' => [
            'exclude' => false,
            'label' => 'LLL:EXT:base/Resources/Private/Language/locallang_db.xlf:tx_base_domain_model_account.username',
            'config' => [
                'type' => 'input',
                'size' => 30,
                'eval' => 'trim,required',
            ],
        ],
        'email' => [
            'exclude' => false,
            'label' => 'LLL:EXT:base/Resources/Private/Language/locallang_db.xlf:tx_base_domain_model_account.email',
            'config' => [
                'type' => 'input',
                'size' => 30,
                'eval' => 'trim,required,email',
            ],
        ],
        // Add other fields matching your model and remote table columns
    ],
];

Important TCA Tips: #

• ctrl section's tableName must exactly match the remote table name from your DBAL config.
• Setting useDBal to true ensures TYPO3 uses the remote connection instead of the local database.
• Adjust tstamp, crdate, and delete mappings only if your remote table has those fields. If not, remove them or set delete to false (note: hard deletes will affect the remote table directly).

3. Verify Remote Database Permissions #

Don't skip these critical checks on your remote MySQL server:

• The remote database user must have read/write permissions (SELECT, INSERT, UPDATE, DELETE) on the account table.
• Your TYPO3 server's public IP must be allowed to connect to the remote MySQL server. Configure this via MySQL's GRANT statement:

  GRANT ALL ON your-db-name.account TO 'db-user'@'typo3-server-ip' IDENTIFIED BY 'password';
  FLUSH PRIVILEGES;
  

4. Test the Setup #

Once all configs are in place:

1. Clear TYPO3's system cache (System > Maintenance > Flush System Cache).
2. Navigate to the List module in the TYPO3 backend – you should see your remote Account records.
3. Try creating, editing, or deleting a record to confirm write operations work.

If you hit issues, check the TYPO3 system log (System > Log) for DB connection errors or mapping mismatches – it's the best place to debug.

内容的提问来源于stack exchange，提问作者user3660135