• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

Migration Confixx 3 to Plesk 8.1.1 - SQL Error Access denied

N

njfire

Guest
Hi,
I'm trying to migrate a domain on a confixx 3 based webserver to a new plesk 8.1.1 webserver. Domains wihtout databases work fine, but somehow th emigration tool has a problem wiht the database migration"
Code:
Error log 
Error during dump retrieval
 
  Error during dump file retrieving. 
Remote agent failed with the following stderr messages: 19:15:36 INFO FileFinder: pwd resolved to /bin/pwd
19:15:36 INFO ------------------------------------------------------------
19:15:36 INFO Migration status reporting initialized.
19:15:36 INFO Status file: /migration/supervisor.26446/dumping-status.xml
19:15:36 INFO ------------------------------------------------------------
19:15:37 INFO New connection: mysql DBI connection. db confixx, user confixx, host localhost
DBI connect('dbname=mysql;host=localhost','root',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at Db/DbiBackend.pm line 43
19:15:37 INFO FileFinder: mysql resolved to /usr/bin/mysql
19:15:37 INFO FileFinder: mysqldump resolved to /usr/bin/mysqldump
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
19:15:37 INFO New connection: mysql shell connection. db mysql, user root, host localhost
19:15:37 INFO ------------------------------------------------------------
19:15:37 INFO FILE storage initialized.
19:15:37 INFO Base directory: /migration/supervisor.26446/
19:15:37 INFO Gzip bundles: yes
19:15:37 INFO Bundle split size: do not split
19:15:37 INFO ------------------------------------------------------------
19:15:37 INFO Work dir: /migration/supervisor.26446
19:15:37 INFO Dump file: /migration/supervisor.26446/dump.xml
19:15:37 INFO Status file: 
19:15:37 TRACE SQL: SELECT * FROM admin
19:15:37 INFO Reading IP information ...
19:15:37 TRACE SQL: SELECT standardip FROM admin
19:15:37 TRACE SQL: select ip,anbieter,kunde from ipadressen
19:15:37 INFO OK
19:15:37 TRACE SQL: select distinct anbieter,kunde from domains where (domain in ('abc.de'))
19:15:37 INFO Client 'res3' is started
19:15:37 TRACE SQL: SELECT count(domain) FROM domains WHERE (richtigedomain in (0,1)) AND (anbieter in ('res3'))
19:15:37 TRACE SQL: select * from anbieter where anbieter ='res3'
19:15:37 TRACE SQL: SELECT standardip FROM anbieter WHERE anbieter='res3'
19:15:37 TRACE SQL: SELECT ip FROM ipadressen WHERE anbieter='res3'
19:15:37 TRACE SQL: SELECT ident,name FROM angebote WHERE anbieter='res3'
19:15:37 TRACE SQL: SELECT domain, kunde FROM domains WHERE richtigedomain IN (0,1) AND (anbieter='res3') AND (domain IN ('abc.de'))
19:15:37 INFO Domain 'abc.de' is started
19:15:37 TRACE SQL: SELECT k.* FROM kunden k, domains d WHERE (d.kunde=k.kunde) AND (d.domain='abc.de')
19:15:37 TRACE SQL: SELECT i.idn_name, i.charset, d.id FROM idn_aliases i, domains d WHERE i.domain_id = d.id AND d.domain = 'abc.de'
19:15:37 TRACE SQL: SELECT COUNT(dbname) FROM mysql_datenbanken WHERE kunde='web1'
19:15:37 TRACE SQL: SELECT kbhomedir AS fact FROM kunden WHERE kunde='web1'
19:15:37 TRACE SQL: SELECT * FROM email WHERE domain='abc.de' ORDER BY prefix
19:15:37 TRACE SQL: SELECT longpw FROM pop3 WHERE account='web1p1'
19:15:37 DEBUG Tar bundle. [email protected]:gzipped, destFile=/migration/supervisor.26446//[email protected]
19:15:37 INFO FileFinder: tar resolved to /bin/tar
19:15:38 INFO Executing bundle producer: '/bin/tar -f - -c -T '/tmp/fileCBnA9y'' in /var/spool/mail
19:15:38 TRACE SQL: SELECT longpw FROM pop3 WHERE account='web1p2'
19:15:38 DEBUG Tar bundle. [email protected]:gzipped, destFile=/migration/supervisor.26446//[email protected]
19:15:38 INFO FileFinder: tar resolved to /bin/tar
19:15:38 INFO Executing bundle producer: '/bin/tar -f - -c -T '/tmp/filePFob7N'' in /var/spool/mail
19:15:38 TRACE SQL: SELECT longpw FROM pop3 WHERE account='web1p3'
19:15:38 DEBUG Tar bundle. [email protected]:gzipped, destFile=/migration/supervisor.26446//[email protected]
19:15:38 INFO FileFinder: tar resolved to /bin/tar
19:15:38 INFO Executing bundle producer: '/bin/tar -f - -c -T '/tmp/file8uezb3'' in /var/spool/mail
19:15:38 TRACE SQL: SELECT longpw FROM pop3 WHERE account='web1p4'
19:15:38 DEBUG Tar bundle. [email protected]:gzipped, destFile=/migration/supervisor.26446//[email protected]
19:15:38 INFO FileFinder: tar resolved to /bin/tar
19:15:38 INFO Executing bundle producer: '/bin/tar -f - -c -T '/tmp/fileDQgtvi'' in /var/spool/mail
19:15:38 TRACE SQL: SELECT * FROM autoresponder WHERE absenderemail in ('[email protected]')
19:15:38 TRACE SQL: SELECT * FROM autoresponder WHERE absenderemail in ('[email protected]')
19:15:38 TRACE SQL: SELECT * FROM autoresponder WHERE absenderemail in ('[email protected]')
19:15:38 TRACE SQL: SELECT * FROM autoresponder WHERE absenderemail 19:15:38 TRACE SQL: SELECT * FROM email WHERE kunde='web1'
19:15:38 TRACE SQL: SELECT account, longpw FROM pop3 WHERE kunde='web1' ORDER BY number
19:15:38 TRACE SQL: SELECT pns,sns FROM anbieter WHERE anbieter='res3'
19:15:38 TRACE SQL: SELECT dbname FROM mysql_datenbanken WHERE kunde='web1'
19:15:38 INFO Dump user's mysql 'usr_web1_1'
DBI connect('dbname=usr_web1_1','',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at Db/DbiBackend.pm line 43
DBI connect('dbname=usr_web1_1;host=localhost','',...) failed: Access denied for user: 'root@localhost' (Using password: YES) at Db/DbiBackend.pm line 43
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
19:15:38 INFO New connection: mysql shell connection. db usr_web1_1, user , local socket
19:15:38 TRACE SQL: SELECT 1
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
19:15:38 ERROR Database usr_web1_1 is not accessible for dumping
'undef' value passed to XmlNode::addAttribute for 'cid' at XmlNode.pm line 61, <STDIN> line 1.

Any Idea where the ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) eror is coming from? I think I did grant root full privileges and flushed but somehow it seems not to be working :-(
Thanks for any suggestions!!!!
 
Back
Top