After reading a tutorial here on transfering a server from one box to another, I have several nuisances which are driving me mad.
Let me say 1st that my server is working, ISPConfig is working and Apache2 is working, correctly servering pages.
1st server was Fedora Core 8.
2nd server Debian Etch
When dumping the sql dump using command line, it included the mysql database from the first server. I didn't notice this and I imported this dump file using phpmyadmin on the debian box. Well, as you can imgaine, I have issues concerning this.
Here is what I am getting:
Access denied for user 'debian-sys-maint'@'localhost' (using password: YES) -- This I have been able to fix inserting the user into the new mysql.user table.
Now when I try to fix the root user, I get a duplicate key issue.
This is my error message:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
When I upload files to my webs, they are issued www-data www-data as file ownership.
Can someone please help me fix this? Also, I cannot start/stop/restart services from ISPConfig control panel anymore.
NOTE: I have approximately 62 websites on this new box and they are all functioning, so reinstalling the OS/server isn't an option for me.