migration JSON API REPLY ERROR: Invalid client_id

Hi,
i did already some migrations (wounderful tool) on servers but now on one one i got problems with JSON API REPLY ERROR: Invalid client_id"
- Systems: Migration from 3.3.0p1 (Ubuntu 18.04.6) to 3.3.0p3 (Ubuntu 24.04.3)
- first: isconfig works, phpmyadmin works, ssh works, all databases are migrated, all mails in /var/vmail and all webfiles in /var/www are migrated correctly. ("clients", "email routing" and "relay receipients" are migrated also to ispconfig new one). In source there is no empty line in "domain" in "web_domain" table. It was before but i deleted this and migrated again. (i did empty of all "web_domain", "domain", "client" in new database before of course. Sys_config:db_version 3.2.12.p1 on new, Sys_config:db_version 3.5.0.2 on old one)

but the dbispconfig database migration has problems, only the "clients", "email routing" and "relay receipients" are migrated correctly (correct ID als old system) bit in ispconfig not the sites, not db, not the mail, no settings. I assume that is has to do with the client_id, but they are correct as far as i can see in the new dbispconfig. i used the migration documenation of course. The version of certbot differs also on both but certs are copied also.

2025-11-18 16:11:01 - [INFO] Migration tool version 2.2.23 started.
2025-11-18 16:11:04 - [INFO] Using importer module ispconfig3.
2025-11-18 16:11:06 - [INFO] Target ISPConfig version is 3.3.0p3
2025-11-18 16:11:09 - [INFO] Source is multiserver? no
2025-11-18 16:11:09 - [INFO] Target is multiserver? no
2025-11-18 16:11:27 - [INFO] Config file saved.
2025-11-18 16:11:27 - [INFO] No billing module found, skipping entries.
.......
2025-11-18 16:11:27 - [INFO] Found 0 invoice sepa xml export entries.
2025-11-18 16:11:36 - [INFO] Successfully executed command PHP=$(which php) && $PHP -r "print PHP_VERSION;"
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
2025-11-18 16:11:36 - [INFO] Using id 0 for Default on target.
--------
2025-11-18 16:11:37 - [INFO] Successfully executed command mysql -h 'localhost' -u 'root' -p'xxxxxxxxx' -e "SELECT VERSION();"
2025-11-18 16:11:37 - [INFO] Successfully executed command mysql -h 'localhost' -u 'root' -p'xxxxx' -s -e "SELECT @@max_allowed_packet;"
2025-11-18 16:11:37 - [INFO] Config file saved.
2025-11-18 16:11:37 - [INFO] Directory /etc/letsencrypt/live exists.
2025-11-18 16:11:37 - [INFO] Successfully executed command rsync --version 2>/dev/null
2025-11-18 16:11:38 - [INFO] Rsync copy from /etc/letsencrypt/ to /etc/letsencrypt/ successful.
2025-11-18 16:11:40 - [ERROR] API call to domains_domain_add failed.
2025-11-18 16:11:40 - [ERROR] JSON API REPLY ERROR: Invalid client_id 1 - Arguments sent were: array (
'client_id' => '1',
'params' =>
array (
'domain' => 'aa.de',
'_migrate_status' => NULL,
'_migrate_status_type' => NULL,
'_migrate_status_dep' => NULL,
),
'session_id' => 'a8c7812516da9eef71a200e4dca55bedee8038904',
)
2025-11-18 16:11:40 - [ERROR] API call to domains_domain_add failed.
2json025-11-18 16:11:40 - [ERROR] JSON API REPLY ERROR: Invalid client_id 1 - Arguments sent were: array (
'client_id' => '1',
'params' =>
array (
'domain' => 'ambula.de',
'_migrate_status' => NULL,
'_migrate_status_type' => NULL,
'_migrate_status_dep' => NULL,
),
'session_id' => 'a8c7812516da9eef71a200e4dca55bedee8038904',
)
2025-11-18 16:11:40 - [ERROR] API call to domains_domain_add failed.
2025-11-18 16:11:40 - [ERROR] JSON API REPLY ERROR: Invalid client_id 1 - Arguments sent were: array (
'client_id' => '1',
'params' =>
array (
'domain' => 'autoconf.fullser.de',
'_migrate_status' => NULL,
'_migrate_status_type' => NULL,
'_migrate_status_dep' => NULL,

.... same entires a lot more

2025-11-18 16:12:05 - [ERROR] API call to sites_database_add failed.
2025-11-18 16:12:05 - [ERROR] JSON API REPLY ERROR: Invalid client_id 38 - Arguments sent were: array (
'client_id' => '38',
'params' =>
array (
'server_id' => '1',
'parent_domain_id' => 0,
'type' => 'mysql',
'database_name' => 'c38orbach_db',
'database_user_id' => false,
'database_ro_user_id' => '52',
'database_charset' => 'utf8mb4',
'remote_access' => 'n',
'active' => 'y',
'remote_ips' => '',
'sys_perm_user' => 'riud',
'sys_perm_group' => 'riud',
'sys_perm_other' => '',
'database_name_prefix' => 'c38',
'database_quota' => '-1',
'quota_exceeded' => 'n',
'last_quota_notification' => NULL,
'backup_interval' => 'daily',
.....

2025-11-18 16:12:05 - [INFO] Job queue has 41 entries left. Waiting ...
2025-11-18 16:13:02 - [INFO] Target ISPConfig job queue has completed. Continuing.
2025-11-18 16:13:02 - [INFO] Skipping system server as we have no job entries for this target.
2025-11-18 16:13:03 - [INFO] Command replace -? 2>/dev/null failed with code 127.
2025-11-18 16:13:03 - [INFO] Replace command unavailable for web server. Using sed instead.
2025-11-18 16:13:03 - [INFO] Successfully executed command chattr -i '/var/www/clients/client0/web109'
2025-11-18 16:13:03 - [INFO] Successfully executed command rm -f '/var/www/clients/client0/web109/web/index.html' ;
2025-11-18 16:13:03 - [INFO] Directory /var/www/clients/client0/web109/ exists.
2025-11-18 16:13:05 - [INFO] Rsync copy from /var/www/clients/client0/web108/web to /var/www/clients/client0/web109/ successful.
2025-11-18 16:13:05 - [INFO] Directory /var/www/clients/client0/web109/private/ exists.
2025-11-18 16:13:05 - [INFO] Rsync copy from /var/www/clients/client0/web108/private/ to /var/www/clients/client0/web109/private/ successful.
2025-11-18 16:13:06 - [INFO] Directory /var/www/clients/client0/web109/ssl/ exists.

.... same entires a lot more

2025-11-18 16:13:52 - [INFO] Directory /var/vmail/haerterei-niederbayern.de/versand/Maildir/ exists.
2025-11-18 16:13:53 - [INFO] Rsync copy from /var/vmail/haerterei-niederbayern.de/versand/Maildir/ to /var/vmail/haerterei-niederbayern.de/versand/Maildir/ successful.
2025-11-18 16:13:53 - [INFO] Successfully executed command rm -f '/var/vmail/haerterei-niederbayern.de/versand/.quotausage' ;
chmod '744' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/subscriptions' 2>/dev/null ;
chmod '600' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/dovecot-*' 2>/dev/null ;
chmod -R '600' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/cur' 2>/dev/null ;
chmod -R '600' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/new' 2>/dev/null ;
chmod -R '600' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/tmp' 2>/dev/null ;
chmod '700' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/cur' 2>/dev/null ;
chmod '700' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/new' 2>/dev/null ;
chmod '700' '/var/vmail/haerterei-niederbayern.de/versand/Maildir/tmp' 2>/dev/null ;
2025-11-18 16:13:53 - [INFO] Command replace -? 2>/dev/null failed with code 127.
2025-11-18 16:13:53 - [INFO] Replace command unavailable for db server. Using sed instead.
2025-11-18 16:13:53 - [INFO] Successfully executed command if [ ! -d '/tmp/dumps' ] ; then mkdir -p '/tmp/dumps' ; fi
2025-11-18 16:13:53 - [INFO] Successfully executed command for T in `mysql -h 'localhost' -u 'root' -p'xxxxxxxxx' c2msstamm_db -e 'SHOW FULL TABLES WHERE TABLE_TYPE L$
2025-11-18 16:13:56 - [INFO] Successfully executed command for T in `mysql -h 'localhost' -u 'root' -p'xxxxx' c2msstamm_db -e 'SHOW FULL TABLES WHERE TABLE_TYPE N$
2025-11-18 16:13:56 - [INFO] Successfully executed command umask 0077 ; R="" ; if [ "$(mysqldump --help | grep '\-\-routines' >/dev/null 2>&1 ; echo $?)" -eq 0 ] ; then R$
2025-11-18 16:13:56 - [INFO] File /tmp/migrate-import-tmp.sql.gz successfully transferred.
2025-11-18 16:14:02 - [INFO] Successfully executed command gunzip -c /tmp/migrate-import-tmp.sql.gz | mysql --max_allowed_packet=1G -h 'localhost' -D c2msstamm_db -u 'roo$
2025-11-18 16:14:02 - [INFO] Successfully executed command rm -f '/tmp/migrate-import-tmp.sql.gz' ;
2025-11-18 16:14:02 - [INFO] Successfully executed command rm -rf '/tmp/dumps'
2025-11-18 16:14:02 - [INFO] Successfully executed command if [ ! -d '/tmp/dumps' ] ; then mkdir -p '/tmp/dumps' ; fi

.... same entires a lot more

 

ok thanks, i contacted the support.

this client_id was the first i checked, but the it is there
old dbispconfig
Bearbeiten Kopieren Löschen
1 1 1 riud riud Internetservices Name Surname 0001

new dbispconfig
Bearbeiten Bearbeiten Kopieren Kopieren Löschen Löschen
1 1 1 riud riud Internetservices Name Surname 0001