Moving ISPconfig

[Ovidiu]

I did not solve the last problem yet, but I have a new one:

I copied over the mysql database and now when I try to restart mysql I get this error:

h898552:/var/www# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
h898552:/var/www#

any idea why the debian-sys-maint user cannot login anymore?

###edit###

basically its 2 different problems:

I copied over one site to the new server but the web6_u1 was not inside the mysql db of the new server, so I copied the newest mysql db from the old server to the nwe one. Basically now I cannot restart the mysqld on the new server (see above errors) and I cannot login to the web6_db1 I also copied over although now the web6_u1 user is inside the mysql db.
2nd problem is a working db that I had already created on the new server is not working anymore.


###2nd edit###
1st problem: http://pacura.ru does not react at all, I get a site not found. I redirected this domain to the new server IP more than 24hours ago then went ahead and transfered the account to the new isp cfg server running debian, like described earlier in this thread - so where is the catch? web6_db1 exists, web6_u1 exists, I can login with phpmyadmin with these info.

2nd problem: web8_db1 and web8_u1 work to login using phpmyadmin but if I login as web8_u1 I see no databases, if I login as root I see web8_db1 so how can I repair this so that that user sees that DB? ###solved### I logged in with webmin, went to the mysql module and added the web8_u1 user to the database permissions table

[falko]

Originally Posted by Tenaka

1st problem: http://pacura.ru does not react at all, I get a site not found.

It's working for me. I get a white page, but it's working.

[Ovidiu]

in between I got a white page too, but no source code???

by now it works, it looks to as if the DNS update took longer than 24 hours ....
I hope zice.ro will work too soon... thats the one where I get the shared IP page.

[todvard]

h898552:/var/www# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld...failed.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
Killing MySQL database server by signal: mysqld.
Starting MySQL database server: mysqld.
Checking for crashed MySQL tables in the background.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'debian-sys-maint@localhost' (Using password: YES)'
h898552:/var/www#

the password for debian-sys-maint user is stored in two places, first encrypted in the mysql database, second in the /etc/mysql/debian.cnf file. I think you overwrote your mysql database with the dump from your old server, which means you will need to copy over the debian.cnf file from the old server as well.

[Ovidiu]

thx.

that worked wonderful and I think it is worht mentioning somewhere, like in the FAQ.

[Ovidiu]

ok, the move went ok, I jsut have one problem left: the stats are no longer compiling on the new server...

any suggestions what could have went wrong during the move or shall I start loking for "stats no longer compiling" posts?

also the problem with one of the databases persists:

h898552:/var/www# mysql -h localhost -u root -p****** web3_db1 < web3_db1.sql
ERROR 1064 at line 12: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM'
h898552:/var/www#

any ideas? the mysql version is the same on both systems. I could upgrade wordpress (the application that uses this DB) to the newest version, maybe the error lies within the DB ?

[falko]

Originally Posted by Tenaka

ok, the move went ok, I jsut have one problem left: the stats are no longer compiling on the new server...

Run

crontab -e

and then restart cron:

/etc/init.d/cron restart

Originally Posted by Tenaka

any ideas? the mysql version is the same on both systems. I could upgrade wordpress (the application that uses this DB) to the newest version, maybe the error lies within the DB ?

What's in line 12 of web3_db1.sql?
Is web3_db1.sql emtpy (no tables in it) when you try to restore it from the dump?

[Ovidiu]

thx for helping, I tried the crontab -e and cron restart solution already, I'll wait and see what the new month brings.

regarding the DB issues, it got solved here: http://www.howtoforge.com/forums/showthread.php?t=5909

there was a problem with some backticks. I just cut out the section with the backticks as it was a plugin for wordpress.

[Ovidiu]

I have no stats showing for august for those sites that I moved from the old server, for the new created sites there is not even a stats folder being created.

I will look out for the thread dealing with this problem, I just wanted to mention that the stats stopped/never worked on this new system...

[till]

Do you have httpd logfiles in /var/log/httpd with the date in the name?

Do you get any errors when you execute:

/root/ispconfig/php/php -q /root/ispconfig/scripts/shell/logs.php