• 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

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