• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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